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