public List <User> GetUsersForAdmin(string search, PagingSortingInfo pagingSorting)
{
var query = EntitySet.AsQueryable();
if (!string.IsNullOrWhiteSpace(search))
{
search = search.Trim();
query = query.Where(x => x.FullName.Contains(search));
}
return(query.IncludeRoles().PagingSorting(pagingSorting).ToList());
}
public static SortColumnModel Create(ColumnModel column, PagingSortingInfo pagingSortingInfo)
{
var sortedByCurrentField = column.SortMemberName == pagingSortingInfo.SortMember;
var sortByDescending = sortedByCurrentField && !pagingSortingInfo.SortDescending;
return(new SortColumnModel
{
Column = column,
SortedByCurrentField = sortedByCurrentField,
SortByDescending = sortByDescending
});
}
public List <Country> GetCountries(string search, PagingSortingInfo pagingSorting)
{
var query = Context.Set <Country>().AsQueryable();
if (!string.IsNullOrWhiteSpace(search))
{
search = search.Trim();
query = query.Where(x => x.Name.Contains(search));
}
return(query
.PagingSorting(pagingSorting).ToList());
}
public static IQueryable <T> PagingSorting <T>(this IQueryable <T> source, PagingSortingInfo page)
{
IQueryable <T> qSource = source;
if (source == null)
{
throw new ArgumentNullException(nameof(source), "source is null.");
}
if (page == null)
{
return(qSource);
}
page.TotalItemCount = qSource.Count();
if (!string.IsNullOrWhiteSpace(page.Sort))
{
qSource = qSource.OrderBy(page.Sort);
}
qSource = qSource.Skip((page.Page - 1) * page.PageSizeReal).Take(page.PageSizeReal);
return(qSource);
}
public UserListArgs()
{
PagingSortingInfo = PagingSortingInfo.GetDefault(
PropertyUtil.GetName <UserListItemModel>(x => x.LastName)
);
}
public CountryArgsModel()
{
PagingSortingInfo = PagingSortingInfo.GetDefault(
PropertyUtil.GetName <CountryListItemModel>(x => x.Name)
);
}
public void SetPagingSorting(TagHelperContext context, PagingSortingInfo pagingSorting)
{
context.Items.Add(typeof(PagingSortingInfo), pagingSorting);
}
