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