public IEnumerable <Room> CheckAllRooms(CheckRooms reservation) { var roomList = _context.Room .Include(r => r.Type) .Where(r => r.Booking.All(b => b.CheckIn > reservation.CheckOut || b.CheckOut < reservation.CheckIn)) .ToList(); return(roomList); }
public IActionResult Index() { CheckRooms reservation = new CheckRooms() { RoomTypes = new SelectList(_typeRepository.GetAll(), "TypeId", "TypeName") }; return(View(reservation)); }
public IActionResult AvailableRooms(CheckRooms model) { checkIn = model.CheckIn; checkOut = model.CheckOut; if (ModelState.IsValid) { var availableRooms = _roomRepository.CheckAvailabileRooms(model); return(View(availableRooms)); } else if (model.TypeId == 0) { var availableRooms = _roomRepository.CheckAllRooms(model); return(View(availableRooms)); } else { return(RedirectToAction("Index", "Home")); } }