public static IQueryable <TEntity> GetQuery(IQueryable <TEntity> inputQUery,
iSpecification <TEntity> spec)
{
var query = inputQUery;
if (spec.Criteria != null)
{
query = query.Where(spec.Criteria); // p => p.ProductTypeId == id
}
if (spec.OrderBy != null)
{
query = query.OrderBy(spec.OrderBy);
}
if (spec.OrderByDescending != null)
{
query = query.OrderByDescending(spec.OrderByDescending);
}
if (spec.IsPagingEnabled)
{
query = query.Skip(spec.Skip).Take(spec.Take);
}
query = spec.Includes.Aggregate(query, (current, include) => current.Include(include));
return(query);
}
private IQueryable <T> ApplySpecification(iSpecification <T> spec)
{
return(SpecificationEvaluator <T> .GetQuery(_context.Set <T>().AsQueryable(), spec));
}
public async Task <int> CountAsync(iSpecification <T> spec)
{
return(await ApplySpecification(spec).CountAsync());
}
public async Task <IReadOnlyList <T> > ListAsync(iSpecification <T> spec)
{
return(await ApplySpecification(spec).ToListAsync());
}
public async Task <T> GetEntityWithSpec(iSpecification <T> spec)
{
return(await ApplySpecification(spec).FirstOrDefaultAsync());
}
