public async Task <IEnumerable <Ticket> > GetProjectTickets(int id, TicketParams ticketParams)
{
var tickets = _context.Tickets
.Include(t => t.Status)
.Include(t => t.Category)
.Include(t => t.Priority)
.Include(t => t.User)
.Include(t => t.project).Where(t => t.project.Id == id).AsQueryable();
tickets = TQuery.TicketQuery(ticketParams, tickets);
return(await tickets.ToListAsync());
}
public async Task <IEnumerable <Ticket> > GetUserTickets(string id, TicketParams ticketParams)
{
var tickets = _context.Tickets
.OrderBy(t => t.SubmissionDate)
.Include(t => t.Status)
.Include(t => t.Category)
.Include(t => t.Priority)
.Include(t => t.project)
.Include(t => t.User).Where(t => t.User.Id.Equals(id))
.AsQueryable();
tickets = TQuery.TicketQuery(ticketParams, tickets);
return(await tickets.ToListAsync());
}
