public PagedList <CategoryModel> GetAllCategoryParent(PagingParams pagingParams)
{
DisplayCategory category = new DisplayCategory();
category.objUser = this.objUser;
var query = new List <CategoryModel>((List <CategoryModel>)category.DisplayCategoryParent()).AsQueryable();
IQueryable <CategoryModel> filter;
filter = query.Where(p => p.category_name.StartsWith(pagingParams.Query ?? string.Empty, StringComparison.InvariantCultureIgnoreCase));
return(new PagedList <CategoryModel>(filter, pagingParams.PageNumber, pagingParams.PageSize));
}
public PagedList <CategoryModel> GetAllSubCategories(PagingParams pagingParams, string id)
{
DisplayCategory category = new DisplayCategory();
category.objUser = this.objUser;
var query = new List <CategoryModel>((List <CategoryModel>)category.DisplaySubCategory(id)).AsQueryable();
IQueryable <CategoryModel> filter;
if (pagingParams.Term.ToUpper() == "TYPE")
{
filter = query.Where(p => p.category_type.StartsWith(pagingParams.Query ?? string.Empty, StringComparison.InvariantCultureIgnoreCase));
}
else
{
filter = query.Where(p => p.category_name.StartsWith(pagingParams.Query ?? string.Empty, StringComparison.InvariantCultureIgnoreCase));
}
return(new PagedList <CategoryModel>(filter, pagingParams.PageNumber, pagingParams.PageSize));
}