public static void AddSQLPaging(IPageCriteria pageCriteria, string sortby, SqlCommand cmd)
{
pageCriteria.TotalItemCount = SQLHelper.GetTotalItemsCount(cmd);
cmd.CommandText += string.Format(@" ORDER BY {0}
OFFSET {1} * ({2} - 1) ROWS
FETCH NEXT {1} ROWS ONLY", sortby, pageCriteria.PageSize, pageCriteria.PageIndex);
}
public static ResultPage <T> PickPage <T>(this IQueryable <T> query, IPageCriteria criteria, int totalItemsCount)
{
return(new ResultPage <T>(query.Skip((criteria.PageNumber - 1) * criteria.PageSize)
.Take(criteria.PageSize).ToList(), criteria.PageNumber, criteria.PageSize, totalItemsCount));
}
public static ResultPage <T> PickPage <T>(this IQueryable <T> query, IPageCriteria criteria)
{
return(PickPage(query, criteria, query.Count()));
}