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)); }