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()); }