public async Task <Page <IssueListItemView> > Handle(IssueListQuery query, CancellationToken cancellationToken)
{
var sql = _context.Issues.AsNoTracking()
.OrderBy(p => p.CreateDate)
.Where(i => i.ProjectId == query.ProjectId)
.Select(i => new IssueListItemView
{
Id = i.Id,
Number = i.Number,
Title = i.Title,
TrackerName = i.Tracker.Name,
StatusName = i.Status.Name,
PriorityName = i.Priority.Name,
AssigneeName = i.Assignee.Name,
UpdateDate = i.UpdateDate ?? i.CreateDate,
})
.AsQueryable();
return(new Page <IssueListItemView>
{
Limit = query.Limit,
Offset = query.Offset,
Total = await sql.CountAsync(cancellationToken),
Items = await sql.Skip(query.Offset).Take(query.Limit).ToListAsync(cancellationToken)
});
}
public async Task <IActionResult> List(IssueListQuery query)
{
var result = await Mediator.Send(query);
return(Ok(result));
}
