public async Task <long> CountAsync(ExpenseFilterDto filter, CancellationToken cancellationToken) { return(await DbSet .Where(x => x.ProjectId == filter.ProjectId) .From(filter.From) .To(filter.To) .LongCountAsync(cancellationToken)); }
public async Task <ICollection <ExpenseDto> > GetAsync(ExpenseFilterDto filter, CancellationToken cancellationToken) { return(await DbSet .Where(x => x.ProjectId == filter.ProjectId) .From(filter.From) .To(filter.To) // Default order .OrderByDescending(e => e.DateAdded) .ThenBy(e => e.Id) .Skip(filter.Skip) .Take(filter.Count) .ProjectTo <ExpenseDto>(fMapper.ConfigurationProvider) .ToArrayAsync(cancellationToken)); }