/**
* Add given offer room object to database.
* @param OfferRoom $room
*/
public static function AddRoom(OfferRoom $room)
{
$query = "INSERT INTO #S#offers_rooms (offers_id, kind, `order`, area, level, `type`, height, kitchen_type, number, glaze, window_view\r\n\t\t\t, description, floors_state, room_type, offers_id_lng) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);";
$params = array($room->GetOfferId(), $room->GetKind(), $room->GetOrder(), $room->GetArea(), $room->GetLevel(), $room->GetType(), $room->GetHeight(), $room->GetKitchenType(), $room->GetNumber(), $room->GetGlaze(), $room->GetWindowView(), $room->GetDescription(), $room->GetFloorsState(), $room->GetRoomType(), $room->GetOfferLng());
$result = DataBase::GetDbInstance()->ExecuteQueryWithParams($query, $params);
//echo $result;
$room->SetId(DataBase::GetDbInstance()->LastInsertedId("offers_rooms"));
self::SaveSets($room->GetFloors(), "Podlogi", $room->GetId());
self::SaveSets($room->GetWalls(), "Sciany", $room->GetId());
self::SaveSets($room->GetEquipment(), "Wyposazenie", $room->GetId());
self::SaveSets($room->GetWindowsExhibition(), "WystawaOkien", $room->GetId());
}
