/** * 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); }