public IEnumerable <RoomBl> GetAllRoomsWithProp()
{
List <RoomBl> listRoomBl = new List <RoomBl>();
List <Room> room = _context.Room.ToList();
List <RoomProp> roomProp = _context.RoomProp.ToList();
RoomBl roomBl;
for (int i = 0; i < room.Count; i++)
{
if (roomProp[i] == null)
{
roomBl = new RoomBl
{
Id = room[i].Id,
Number = room[i].Number,
Cost = (int)room[i].Cost,
Сapacity = room[i].Сapacity,
Type = room[i].Type,
Shower = false,
Restroom = false,
Description = "",
Bed = 0,
Wifi = false,
Tv = false,
Fridge = false,
};
}
else
{
roomBl = new RoomBl
{
Id = room[i].Id,
Number = room[i].Number,
Cost = (int)room[i].Cost,
Сapacity = room[i].Сapacity,
Type = room[i].Type,
Shower = roomProp[i].Shower == null ? false : roomProp[i].Shower,
Restroom = roomProp[i].Restroom == null ? false : roomProp[i].Restroom,
Description = roomProp[i].Description == null ? "" : roomProp[i].Description,
Bed = roomProp[i].Bed == null ? 0 : roomProp[i].Bed,
Wifi = roomProp[i].Wifi == null ? false : roomProp[i].Wifi,
Tv = roomProp[i].Tv == null ? false : roomProp[i].Tv,
Fridge = roomProp[i].Fridge == null ? false : roomProp[i].Fridge,
};
}
listRoomBl.Add(roomBl);
}
return(listRoomBl);
}
public BookingBl GetBooking(int IdClient, int IdRoom)
{
ClientBl clientBl = GetClient(IdClient);
RoomBl roomBl = GetRoom(IdRoom);
HandlingBl handlingBl = new HandlingBl();
BookingBl bookingBl = new BookingBl
{
client = clientBl,
room = roomBl,
handling = handlingBl,
};
return(bookingBl);
}
public RoomBl GetRoom(int id)
{
Room room = _context.Room.FirstOrDefault(p => p.Id == id);
RoomProp roomProp = _context.RoomProp.FirstOrDefault(p => p.IdRoom == id);
RoomBl roomBl;
if (roomProp == null)
{
roomBl = new RoomBl
{
Id = room.Id,
Number = room.Number,
Cost = (int)room.Cost,
Сapacity = room.Сapacity,
Type = room.Type,
Shower = false,
Restroom = false,
Description = "",
Bed = 0,
Wifi = false,
Tv = false,
Fridge = false,
};
}
else
{
roomBl = new RoomBl
{
Id = room.Id,
Number = room.Number,
Cost = (int)room.Cost,
Сapacity = room.Сapacity,
Type = room.Type,
Shower = roomProp.Shower == null ? false : roomProp.Shower,
Restroom = roomProp.Restroom == null ? false : roomProp.Restroom,
Description = roomProp.Description == null ? "" : roomProp.Description,
Bed = roomProp.Bed == null ? 0 : roomProp.Bed,
Wifi = roomProp.Wifi == null ? false : roomProp.Wifi,
Tv = roomProp.Tv == null ? false : roomProp.Tv,
Fridge = roomProp.Fridge == null ? false : roomProp.Fridge,
};
}
return(roomBl);
}
public bool EditRoom(RoomBl room)
{
try
{
Room smalroom = new Room
{
Id = room.Id,
Number = room.Number,
Cost = room.Cost,
Сapacity = room.Сapacity,
Type = room.Type,
};
_context.Room.Update(smalroom);
_context.SaveChanges();
RoomProp roomPropCheck = _context.RoomProp.FirstOrDefault(p => p.IdRoom == room.Id);
RoomProp roomProp = new RoomProp
{
IdRoom = smalroom.Id,
Shower = room.Shower,
Restroom = room.Restroom,
Description = room.Description,
Bed = room.Bed,
Wifi = room.Wifi,
Tv = room.Tv,
Fridge = room.Fridge,
};
if (roomPropCheck == null)
{
_context.RoomProp.Add(roomProp);
}
else
{
_context.RoomProp.Update(roomProp);
}
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public bool CreateRoom(RoomBl room)
{
try
{
Room smalroom = new Room
{
Id = room.Id,
Number = room.Number,
Cost = room.Cost,
Сapacity = room.Сapacity,
Type = room.Type,
};
_context.Room.Add(smalroom);
_context.SaveChanges();
RoomProp RoomBl = new RoomProp
{
IdRoom = smalroom.Id,
Shower = room.Shower,
Restroom = room.Restroom,
Description = room.Description,
Bed = room.Bed,
Wifi = room.Wifi,
Tv = room.Tv,
Fridge = room.Fridge,
};
_context.RoomProp.Add(RoomBl);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}