public IActionResult Get([FromQuery] IRSqlQuery <Customer> query,
[FromQuery] IRSqlPageable <Customer> pageable)
{
using (RSqlHistogramDuration.NewTimer())
{
// is not valid request
if (!ModelState.IsValid)
{
return(BadRequest(new ErrorModel(ModelState)));
}
var page = _customers
.AsQueryable()
.Page(pageable, query);
return(this.Page(page));
}
}
/// <summary>
///
/// </summary>
/// <param name="obj"></param>
/// <param name="query"></param>
/// <param name="pageable"></param>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
/// <exception cref="ArgumentNullException"></exception>
public static IRSqlPage <T> Page <T>(this IQueryable <T> obj,
IRSqlPageable <T> pageable,
IRSqlQuery <T> query = null) where T : class
{
if (obj == null)
{
throw new ArgumentNullException(nameof(obj));
}
if (pageable == null)
{
throw new ArgumentNullException(nameof(pageable));
}
var where = query == null?RSqlQueryExpressionHelper.True <T>() : query.Value();
var count = obj.Count(where);
IOrderedQueryable <T> sorted = null;
if (pageable.Sort() != null)
{
var sort = pageable.Sort();
sorted = sort.IsDescending ? obj.OrderByDescending(sort.Value) : obj.OrderBy(sort.Value);
sort = sort.Next;
while (sort != null)
{
sorted = sort.IsDescending ? sorted.ThenByDescending(sort.Value) : sorted.ThenBy(sort.Value);
sort = sort.Next;
}
}
var offset = pageable.PageNumber() * pageable.PageSize();
var limit = pageable.PageSize();
var result = (sorted ?? obj).Where(where)
.Skip(offset)
.Take(limit)
.ToList();
return(new RSqlPage <T>(result, pageable, count));
}
private void MockQueryMethod(IRSqlQuery <Customer> query)
{
}
