// GET: Reserve/Details/5 public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var reserveModel = await _context.Reserve .FirstOrDefaultAsync(m => m.Id == id); //loading data ReserveIndexViewModel reserveIndex = new ReserveIndexViewModel(); reserveIndex.Id = reserveModel.Id; reserveIndex.GuestName = _context.Guests.Where(u => u.Id == reserveModel.GuestId).Where(m => m.delete == false).Select(u => u.Name).SingleOrDefault(); reserveIndex.RoomName = _context.Rooms.Where(u => u.Id == reserveModel.RoomId).Where(m => m.delete == false).Select(u => u.RoomName).SingleOrDefault(); reserveIndex.ReservationCode = reserveModel.ReservationCode; reserveIndex.CheckIn = reserveModel.CheckIn; reserveIndex.CheckOut = reserveModel.CheckOut; reserveIndex.Adults = reserveModel.Adults; reserveIndex.Children = reserveModel.Children; reserveIndex.NoOfNights = reserveModel.NoOfNights; if (reserveIndex == null) { return(NotFound()); } return(View(reserveIndex)); }
// GET: Reserve public async Task <IActionResult> Index() { List <ReserveModel> reserve = new List <ReserveModel>(); List <ReserveIndexViewModel> ReserveViewList = new List <ReserveIndexViewModel>(); reserve = _context.Reserve.ToList(); foreach (var i in reserve) { ReserveIndexViewModel reserveIndex = new ReserveIndexViewModel(); reserveIndex.Id = i.Id; reserveIndex.GuestName = _context.Guests.Where(u => u.Id == i.GuestId).Where(m => m.delete == false).Select(u => u.Name).SingleOrDefault(); reserveIndex.RoomName = _context.Rooms.Where(u => u.Id == i.RoomId).Where(m => m.delete == false).Select(u => u.RoomName).SingleOrDefault(); reserveIndex.ReservationCode = i.ReservationCode; reserveIndex.CheckIn = i.CheckIn; reserveIndex.CheckOut = i.CheckOut; reserveIndex.Adults = i.Adults; reserveIndex.Children = i.Children; reserveIndex.NoOfNights = i.NoOfNights; ReserveViewList.Add(reserveIndex); } return(View(ReserveViewList)); }