public static IList <T> GetSortedPagedList <T>(IQueryable <T> source, PaginationRequest paging, out int totalCount, ChildLoad childLoad = ChildLoad.None)
{
totalCount = 0;
//If not need paging, pass the null PaginationRequest
if (paging == null)
{
var list = source.ToList();
totalCount = list.Count();
return(list);
}
source = source.Distinct();
//Call to build sorted paged query
IQueryable <T> sortedPagedQuery = GetSortedPagedQuerable <T>(source, paging);
//Call db one time to get data rows and count together
if (childLoad == ChildLoad.None)
{
//Build one-call query from created regular query
var pagedGroup = from sel in sortedPagedQuery
select new PagedResultSet <T>()
{
PagedData = sel,
TotalCount = source.Count()
};
//Get the complete resultset from db.
List <PagedResultSet <T> > pagedResultSet;
try
{
pagedResultSet = pagedGroup.AsParallel().ToList();
}
catch (NotSupportedException)
{
//In case not supported with EF version, do two calls instead
totalCount = source.Count();
return(sortedPagedQuery.ToList());
}
//Get data and total count from the resultset
IEnumerable <T> pagedList = new List <T>();
if (pagedResultSet.Count() > 0)
{
totalCount = pagedResultSet.First().TotalCount;
pagedList = pagedResultSet.Select(s => s.PagedData);
}
//Remove the wrapper reference
pagedResultSet = null;
return(pagedList.ToList());
}
//Call db twice when childLoad == Include or else
else
{
totalCount = source.Count();
return(sortedPagedQuery.ToList());
}
}
private static IQueryable <T> GetSortedPagedQuerable <T>(IQueryable <T> source, PaginationRequest paging)
{
IQueryable <T> pagedQuery = source;
if (paging.Sort == null)
{
paging.Sort = new Sort();
}
string sortingPropertyType = "System.String"; //default type
PropertyInfo[] props = typeof(T).GetProperties();
PropertyInfo sortingProperty = null;
//Get system type for SortBy property
if (!string.IsNullOrEmpty(paging.Sort.SortBy))
{
//For child SortBy property
if (paging.Sort.SortBy.Contains("."))
{
var childSortBy = paging.Sort.SortBy.Split('.');
var entFullName = System.Configuration.ConfigurationManager.AppSettings["FullEntityAssemblyName"];
Type childT = Type.GetType(string.Format("{0}.{1}, {2}", entFullName, childSortBy[0], entFullName));
PropertyInfo[] childProps = childT.GetProperties();
sortingProperty = childProps.ToList().Find(x => x.Name.Equals(childSortBy[1]));
}
//For all non-child SortBy properties
if (!paging.Sort.SortBy.Contains("."))
{
sortingProperty = props.ToList().Find(x => x.Name.Equals(paging.Sort.SortBy));
}
}
if (sortingProperty == null)
{
//Use default SortBy property
paging.Sort.SortBy = props.ToList().FirstOrDefault().Name;
sortingProperty = props.ToList().Find(x => x.Name.Equals(paging.Sort.SortBy));
}
//For all SortBy properties
sortingPropertyType = sortingProperty.PropertyType.FullName;
//Check for Nullable<T> properties and add it if there
if (sortingProperty.PropertyType.IsGenericType)
{
Type genericTypeDef = sortingProperty.PropertyType.GetGenericTypeDefinition();
Type[] agrumentTypes = sortingProperty.PropertyType.GetGenericArguments();
if (genericTypeDef == typeof(Nullable <>))
{
sortingPropertyType = string.Format("System.Nullable`1[{0}]", agrumentTypes.FirstOrDefault().FullName);
}
}
//Construct sorted query based on the sorting property type
if (sortingPropertyType == "System.String")
{
pagedQuery = AsSortedQueryable <T, String>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if (sortingPropertyType == "System.DateTime")
{
pagedQuery = AsSortedQueryable <T, DateTime>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if (sortingPropertyType == "System.Nullable`1[System.DateTime]")
{
pagedQuery = AsSortedQueryable <T, DateTime?>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if ((sortingPropertyType == "System.Nullable`1[System.Int32]") ||
(sortingPropertyType == "System.Nullable`1[System.Int16]") ||
(sortingPropertyType == "System.Nullable`1[System.Int64]"))
{
pagedQuery = AsSortedQueryable <T, Int32?>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if ((sortingPropertyType == "System.Nullable`1[System.Decimal]") ||
(sortingPropertyType == "System.Nullable`1[System.Single]") ||
(sortingPropertyType == "System.Nullable`1[System.Double]"))
{
pagedQuery = AsSortedQueryable <T, Decimal?>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if (sortingPropertyType == "System.Nullable`1[System.Boolean]")
{
pagedQuery = AsSortedQueryable <T, Boolean?>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if (sortingPropertyType == "System.Boolean")
{
pagedQuery = AsSortedQueryable <T, Boolean>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if ((sortingPropertyType == "System.Int32") ||
(sortingPropertyType == "System.Int16") ||
(sortingPropertyType == "System.Int64"))
{
pagedQuery = AsSortedQueryable <T, Int32>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else if ((sortingPropertyType == "System.Decimal") ||
(sortingPropertyType == "System.Single") ||
(sortingPropertyType == "System.Double"))
{
pagedQuery = AsSortedQueryable <T, Decimal>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
else
{
pagedQuery = AsSortedQueryable <T, Object>(source, paging.Sort.SortBy, paging.Sort.SortDirection);
}
//Construct paged query
if (paging.PageSize > 0)
{
pagedQuery = AsPagedQueryable <T>(pagedQuery, paging.PageIndex, paging.PageSize);
}
else
{
//Passing PageSize 0 to get all rows but using sorting.
paging.PageIndex = 0;
}
//Return sorted paged query
return(pagedQuery);
}
