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