function update(Manufacturer $man)
 {
     $query = "UPDATE `manufacturer` SET `idmanufacturer`='" . $man->getIdmanufacturer() . "',`manufacturer_name`='" . $man->getManufacturerName() . "',`address_number`='" . $man->getAddressNumber() . "',`address_street`='" . $man->getAddressStreet() . "',`address_city`='" . $man->getAddressCity() . "',`address_country`='" . $man->getAddressCountry() . "',`contact_number`='" . $man->getContactNumber() . "' WHERE `idmanufacturer`='" . $man->getIdmanufacturer() . "'";
     $this->con->openConnection();
     $this->con->executeRawQuery($query);
     $this->con->closeConnection();
 }