public ActionResult GetSeatList() { var R_Id = Request.Cookies["idCookie"].Values["r_id"]; var SeatList = seatService.GetSeatByRAccount(R_Id).Select(Mapper.Map <Seat, SeatViewModel>); return(PartialView("_SeatList", SeatList)); }
// GET: Reserve public ActionResult Index() { var cookie = Request.Cookies["idCookie"]; var R_Id = cookie.Values["r_id"]; var SeatList = seatService.GetSeatByRAccount(R_Id).Select(Mapper.Map<Seat, SeatViewModel>); return View(SeatList); }
public IEnumerable <ReserveViewModel> GetReserveListByRAccount(string r_id, IEnumerable <Reservations> Reserves) { var seatList = seatService.GetSeatByRAccount(r_id); var query = from reserve in Reserves join seat in seatList on reserve.Id equals seat.Id join customer in db.Customers on reserve.C_Id equals customer.C_Id orderby seat.SeatName select new ReserveViewModel { Id = reserve.Id, C_Name = customer.C_Name, C_PhoneNum = customer.C_PhoneNum, Details = reserve.Details, PeopleNum = reserve.PeopleNum, AddTime = reserve.AddTime, R_Id = seat.R_Id, SeatCapacity = seat.SeatCapacity, SeatId = seat.Id, SeatName = seat.SeatName, SeatSmoke = seat.SeatSmoke, Seats = seatList }; //var q = Reserves.Join(seatList, // r => r.SeatId, // s => s.SeatId, // (r, s) => new ReserveViewModel // { // Id = r.Id, // Details = r.Details, // PeopleNum = r.PeopleNum, // ReserveTime = r.ReserveTime, // R_Id = s.R_Id, // SeatCapacity = s.SeatCapacity, // SeatId = s.SeatId, // SeatName = s.SeatName, // SeatSmoke = s.SeatSmoke, // Seats = seatList // }).OrderBy(i => i.SeatName).ToList(); return(query); }