public int DeleteRoom(int id)
{
var roomToDelete = Room.SingleOrDefault(b => b.Id == id);
foreach (var booking in RoomTime.Where(rt => rt.RId == id))
{
RoomTime.Remove(booking);
}
Room.Remove(roomToDelete);
return(SaveChanges());
}
public ShowBookingVM[] GetBooking(string id)
{
var bookings = Room
.Join(RoomTime.Where(c => c.UId == id && c.EndTime > DateTime.Now),
r => r.Id,
rt => rt.RId,
(r, rt) => new ShowBookingVM
{
Id = rt.Id,
RoomName = r.Name,
Start = rt.StartTime,
End = rt.EndTime,
Description = rt.Description
});
return(bookings.ToArray());;
}
