Example #1
0
 /**
  * Save given offer room object (roomNew) to database.
  * @param OfferRoom $roomOld
  * @param OfferRoom $roomNew
  */
 public static function EditRoom(OfferRoom $roomOld, OfferRoom $roomNew)
 {
     $query = "UPDATE #S#offers_rooms SET offers_id=?, kind=?, `order`=?, area=?, level=?, `type`=?, height=?, kitchen_type=?, number=?,\r\n\t\t\tglaze=?, window_view=?, description=?, floors_state=?, room_type=?, offers_id_lng=? WHERE id=?;";
     $params = array($roomNew->GetOfferId(), $roomNew->GetKind(), $roomNew->GetOrder(), $roomNew->GetArea(), $roomNew->GetLevel(), $roomNew->GetType(), $roomNew->GetHeight(), $roomNew->GetKitchenType(), $roomNew->GetNumber(), $roomNew->GetGlaze(), $roomNew->GetWindowView(), $roomNew->GetDescription(), $roomNew->GetFloorsState(), $roomNew->GetRoomType(), $room->GetOfferLng(), (int) $roomOld->GetId());
     $result = DataBase::GetDbInstance()->ExecuteQueryWithParams($query, $params);
 }