public static IQueryable<CatRequestModel> ToFilteredCats(this IQueryable<CatRequestModel> query, CatFilterModel filters)
{
if (filters == null)
{
return query;
}
if (!string.IsNullOrWhiteSpace(filters.Name))
{
query = query.Where(c => c.Name.ToLower().Contains(filters.Name.ToLower()));
}
if (filters.Age != null)
{
query = query.Where(c => c.Age == filters.Age);
}
if (filters.Breed != null)
{
query = query.Where(c => c.Breed == filters.Breed);
}
var skip = (filters.Page - 1) * 3;
var take = 3;
query = query
.OrderByDescending(c => c.Id)
.Skip(skip)
.Take(take);
return query;
}
public IHttpActionResult Get([FromUri] CatFilterModel model)
{
var result = this.catsData
.AsQueryable()
.ToFilteredCats(model)
.Take(10)
.ToList();
return(this.Ok(result));
}
public static IQueryable <CatRequestModel> ToFilteredCats(this IQueryable <CatRequestModel> query, CatFilterModel filters)
{
if (filters == null)
{
return(query);
}
if (!string.IsNullOrWhiteSpace(filters.Name))
{
query = query.Where(c => c.Name.ToLower().Contains(filters.Name.ToLower()));
}
if (filters.Age != null)
{
query = query.Where(c => c.Age == filters.Age);
}
if (filters.Breed != null)
{
query = query.Where(c => c.Breed == filters.Breed);
}
var skip = (filters.Page - 1) * 3;
var take = 3;
query = query
.OrderByDescending(c => c.Id)
.Skip(skip)
.Take(take);
return(query);
}