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