private IQueryable <FileJob> CreateFileJobsQuery(FileJobParamMap paramMap)
{
var query = DbContext.FileJobs.AsQueryable();
if (paramMap.Status.HasValue)
{
query = query.Where(q => q.Status == paramMap.Status.Value);
}
return(query);
}
public async Task <int> CountFileJobs(FileJobParamMap paramMap)
{
var query = CreateFileJobsQuery(paramMap);
return(await query.CountAsync());
}
public async Task <IList <FileJob> > GetFileJobs(FileJobParamMap paramMap, int skip, int limit)
{
var query = CreateFileJobsQuery(paramMap);
return(await query.AsNoTracking().Skip(skip).Take(limit).ToListAsync());
}
