public IEnumerable <TicketEM> Filter(TicketFilterDTO filterDTO, out int totalCount)
{
var param = ParametersHelper.CreateFromObject(filterDTO).IncludeOutputTotal();
var tickets = ExecuteSP <TicketEM, PackageEM, SerialEM, ColorEM, NominalEM, TicketEM>("USP_Ticket_Filter",
TicketEM.MapTicket, SPLIT_ON, param);
totalCount = param.GetOutputTotal();
return(tickets);
}
public async Task <List <TicketDTO> > GetAllTicketsAsync(TicketFilterDTO ticketFilterDTO)
{
var tickets = await _DBContext.Tickets
.Include(t => t.Festival)
.Include(t => t.Purchases)
.AsNoTracking()
.Where(ticket => ticket.FestivalId == ticketFilterDTO.FestivalId)
.ToListAsync();
var ticketsDTO = _mapper.Map <List <TicketDTO> >(tickets);
return(ticketsDTO);
}
