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