public IActionResult ChooseSeat()
{
var cart = SessionHelper.GetObjFromJson <SummaryBookingViewModel>(HttpContext.Session, Common.SESSIONSUMMARY_NAME);
var model = SeatQuery.GetSeatInPlane(FlightQueries.FindFlight(cart.DeparFlight.IdFlight).IdPlane);
ViewBag.Summary = cart;
return(View(model));
}
// GET: Seats
public ActionResult Index([FromQuery] SeatQuery query)
{
try
{
return(View(executor.ExecuteQuery(getSeats, query)));
}
catch (EntityNotAllowedException)
{
return(RedirectToAction("PageNotFound", "Redirections"));
}
catch (Exception e)
{
TempData["error"] = e.Message;
}
return(RedirectToAction("Home", "Index"));
}
public IActionResult Get([FromQuery] SeatQuery query)
{
try
{
return(Ok(getSeats.Execute(query)));
}
catch (Exception e)
{
return(StatusCode(500, new
{
Errors = new List <string> {
e.Message
}
}));
}
}
public PagedResponse <SeatRowDto> Execute(SeatQuery request)
{
var query = Context.Seats
.OrderBy(s => s.Name)
.ThenBy(s => s.Number)
.Include(h => h.Hall)
.AsQueryable();
query = query.Where(s => s.IsDeleted == false);
if (request.Name != null)
{
query = query.Where(s => s.Name.ToLower().Contains(request.Name.ToLower()));
}
if (request.HallId > 0)
{
query = query.Where(s => s.HallId == request.HallId);
}
if (request.HallName != null)
{
query = query.Where(s => s.Hall.Name.ToLower().Contains(request.HallName.ToLower()));
}
if (request.Number > 0)
{
query = query.Where(s => s.Number == request.Number);
}
if (request.IsBroken != null)
{
query = query.Where(s => s.IsBroken == request.IsBroken);
}
var totalCount = query.Count();
query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage);
var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage);
var rows = query.Select(x => x.Name).Distinct().ToList();
var seatRows = rows.Select(x => new SeatRowDto
{
Name = x,
Seats = query.Where(s => s.Name == x).Select(s => new SeatDto
{
Id = s.Id,
HallId = s.HallId,
IsBroken = s.IsBroken,
Name = s.Name,
Number = s.Number,
HallName = s.Hall.Name
}).ToList()
}).ToList();
return(new PagedResponse <SeatRowDto>
{
CurrentPage = request.PageNumber,
PagesCount = pagesCount,
TotalCount = totalCount,
Data = seatRows
});
}