private static string ConvertFilteringCriteria(FilteringCriteria criteria)
{
switch (criteria)
{
case FilteringCriteria.Equal:
return("eq");
case FilteringCriteria.NotEqual:
return("ne");
case FilteringCriteria.GreaterThan:
return("gt");
case FilteringCriteria.GreaterThanOrEqual:
return("ge");
case FilteringCriteria.LessThan:
return("lt");
case FilteringCriteria.LessThanOrEqual:
return("le");
case FilteringCriteria.Not:
return("not");
default:
throw new NotSupportedException(string.Format(PnPCoreResources.Exception_Unsupported_Criteria, criteria));
}
}
private static string ConvertFilteringCriteria(FilteringCriteria criteria)
{
return(criteria switch
{
FilteringCriteria.Equal => "eq",
FilteringCriteria.NotEqual => "ne",
FilteringCriteria.GreaterThan => "gt",
FilteringCriteria.GreaterThanOrEqual => "ge",
FilteringCriteria.LessThan => "lt",
FilteringCriteria.LessThanOrEqual => "le",
FilteringCriteria.Not => "not",
_ => throw new NotSupportedException(string.Format(PnPCoreResources.Exception_Unsupported_Criteria, criteria)),
});
public static async Task <IPagedResult <T> > ToPagedListAsync <T>(this IQueryable <T> query,
int page,
int pageSize,
string sortExpression,
FilteringCriteria filtering, CancellationToken cancellationToken = default)
{
query = query.ApplyFiltering(filtering);
var totalCount = await query.LongCountAsync(cancellationToken);
query = query.ApplySorting(sortExpression);
query = query.ApplyPaging(page, pageSize);
return(new PagedResult <T>
{
ItemList = await query.ToListAsync(cancellationToken),
TotalCount = totalCount
});
}
public StudentData Get([FromQuery] FilteringCriteria pagingParam)
{
var result = _studentRepo.GetAll(pagingParam.PageNumber, pagingParam.PageSize, pagingParam.name);
return(result);
}
