public JsonResult LoadPages(DTParameters param)
{
var filtered = _pagesContext.FilterAbstractContext <Page>(param.Search.Value, param.SortOrder, param.Start,
param.Length,
out var totalCount, x => !x.IsLayout && !x.IsDeleted).Select(x => new Page
{
Id = x.Id,
Created = x.Created,
Changed = x.Changed,
Author = x.Author,
Settings = _pagesContext.PageSettings.FirstOrDefault(y => y.Id.Equals(x.SettingsId)),
PageType = x.PageType,
ModifiedBy = x.ModifiedBy,
IsDeleted = x.IsDeleted,
Layout = _pagesContext.Pages.Include(g => g.Settings).FirstOrDefault(y => y.Id == x.LayoutId),
SettingsId = x.SettingsId,
PageTypeId = x.PageTypeId,
IsSystem = x.IsSystem,
Path = x.Path
}).ToList();
var finalResult = new DTResult <Page>
{
Draw = param.Draw,
Data = filtered.ToList(),
RecordsFiltered = totalCount,
RecordsTotal = filtered.Count()
};
return(Json(finalResult));
}
public JsonResult LoadPages(DTParameters param)
{
var filtered = _pagesContext.FilterAbstractContext <Block>(param.Search.Value, param.SortOrder, param.Start,
param.Length,
out var totalCount);
var finalResult = new DTResult <Block>
{
Draw = param.Draw,
Data = filtered.ToList(),
RecordsFiltered = totalCount,
RecordsTotal = filtered.Count()
};
return(Json(finalResult));
}
