/** * @param Region $region * @return bool * this function will add the region to the data base * takes region parameter */ function Add_Region(Region $region) { $Region_Name = $region->getRegionName(); $Region_Name_Amharic = $region->getRegionNameAmharic(); //add the region to the region database $query = "INSERT INTO region (Name,Name_Amharic) VALUES('{$Region_Name}','{$Region_Name_Amharic}')"; $result = mysqli_query($this->getDbc(), $query); if ($result) { return TRUE; } else { return FALSE; } }
function Edit_Region(Region $region, $Region_ID) { $Name = $region->getRegionName(); $Name_Amharic = $region->getRegionNameAmharic(); $query = "UPDATE Region set Name='{$Name}',Name_Amharic='{$Name_Amharic}' where ID='{$Region_ID}'"; $result = mysqli_query($this->getDbc(), $query); //if the company is deleted return true if ($result) { return TRUE; } else { return FALSE; } }