private IQueryable <FileDeal> CreateFileDealsQuery(FileDealParamMap paramMap)
{
var query = DbContext.FileDeals.AsQueryable();
if (paramMap.Status.HasValue)
{
query = query.Where(q => q.Status == paramMap.Status.Value);
}
return(query);
}
public async Task <int> CountFileDeals(FileDealParamMap paramMap)
{
var query = CreateFileDealsQuery(paramMap);
return(await query.CountAsync());
}
public async Task <IList <FileDeal> > GetFileDeals(FileDealParamMap paramMap, int skip, int limit)
{
var query = CreateFileDealsQuery(paramMap);
return(await query.AsNoTracking().Skip(skip).Take(limit).ToListAsync());
}
