protected virtual ControlGridAjaxData <TEntity> GetRecords(ControlGridFormRequest options)
{
int totals;
var records = Service.GetRecords(options, out totals);
return(new ControlGridAjaxData <TEntity>(records, totals));
}
protected override ControlGridAjaxData <User> GetRecords(ControlGridFormRequest options)
{
int totals;
var roleId = 0;
if (Request.Form["RoleId"] != null)
{
roleId = Convert.ToInt32(Request.Form["RoleId"]);
}
var searchText = string.Empty;
if (!string.IsNullOrEmpty(Request.Form["SearchText"]))
{
searchText = Request.Form["SearchText"];
}
if (roleId > 0)
{
var records = membershipService.SearchUserByRolePaged(searchText, roleId, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <User>(records, totals));
}
else
{
var records = membershipService.SearchUserPaged(searchText, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <User>(records, totals));
}
}
private ControlGridAjaxData <Newsletter> GetNewsletters(ControlGridFormRequest options)
{
int totals;
var records = newsletterService.GetRecords(options, out totals, x => x.RefId == null);
return(new ControlGridAjaxData <Newsletter>(records, totals));
}
private ControlGridAjaxData <ArticlesInfo> GetArticles(ControlGridFormRequest options)
{
var searchText = string.Empty;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.SearchText]))
{
searchText = Request.Form[Extensions.Constants.SearchText];
}
var categoryId = 0;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.CategoryId]))
{
categoryId = Convert.ToInt32(Request.Form[Extensions.Constants.CategoryId]);
}
var status = -1;
var userId = 0;
int totals;
var service = WorkContext.Resolve <IArticlesService>();
service.CategoryId = categoryId;
var records = service.SearchPaged(searchText, userId, status, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <ArticlesInfo>(records, totals));
}
private ControlGridAjaxData <Page> GetPages(ControlGridFormRequest options)
{
int totals;
var records = pageService.GetRecords(options, out totals, x => x.RefId == null);
return(new ControlGridAjaxData <Page>(records, totals));
}
private ControlGridAjaxData <Menu> GetMenus(ControlGridFormRequest options)
{
int totals;
var records = menuService.GetRecords(options, out totals);
return(new ControlGridAjaxData <Menu>(records, totals));
}
private ControlGridAjaxData <HistoricPage> GetHistoricPages(ControlGridFormRequest options, int pageId)
{
int totals;
var records = historicPageService.GetRecords(options, out totals, x => x.PageId == pageId);
return(new ControlGridAjaxData <HistoricPage>(records, totals));
}
private ControlGridAjaxData <ProductInfo> GetProducts(ControlGridFormRequest options)
{
var searchText = string.Empty;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.SearchText]))
{
searchText = Request.Form[Extensions.Constants.SearchText];
}
var productGroup = 0;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.ProductGroup]))
{
productGroup = Convert.ToInt32(Request.Form[Extensions.Constants.ProductGroup]);
}
var languageCode = WorkContext.CurrentCulture;
var categoryId = 0;
int totals;
service.LanguageCode = languageCode;
service.CategoryId = categoryId;
var records = service.SearchPaged(searchText, productGroup, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <ProductInfo>(records, totals));
}
private ControlGridAjaxData <ListField> GetFields(ControlGridFormRequest options, int listId)
{
int totals;
var records = listFieldService.GetRecords(options, out totals, x => x.ListId == listId);
return(new ControlGridAjaxData <ListField>(records, totals));
}
private ControlGridAjaxData <List> GetLists(ControlGridFormRequest options)
{
int totals;
var records = listService.GetRecords(options, out totals);
return(new ControlGridAjaxData <List>(records, totals));
}
private ControlGridAjaxData <ListComment> GetListItemComments(ControlGridFormRequest options, int listId)
{
int totals;
var records = commentService.GetCommentsOfList(listId, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <ListComment>(records, totals));
}
private ControlGridAjaxData <Domain.Language> GetLanguages(ControlGridFormRequest controlGridFormRequest)
{
int totals;
var items = languageService.GetRecords(controlGridFormRequest, out totals);
return(new ControlGridAjaxData <Domain.Language>(items, totals));
}
protected override ControlGridAjaxData <Slide> GetRecords(ControlGridFormRequest options)
{
var slideId = new Guid(RouteData.GetRequiredString("sliderId"));
int totals;
var records = Service.GetRecords(options, out totals, x => x.SliderId == slideId);
return(new ControlGridAjaxData <Slide>(records, totals));
}
private ControlGridAjaxData <ListCategoryModel> GetCategories(ControlGridFormRequest options, int listId)
{
int totals;
var records = listCategoryService.GetRecords(options, out totals, x => x.ListId == listId);
var sorted = SortCategories(records);
return(new ControlGridAjaxData <ListCategoryModel>(sorted));
}
private ControlGridAjaxData <ShellFeature> GetData(ControlGridFormRequest options)
{
var service = WorkContext.Resolve <IShellDescriptorManager>();
var setting = service.GetShellDescriptor();
var records = setting.Features;
return(new ControlGridAjaxData <ShellFeature>(records));
}
private ControlGridAjaxData <OrderInfo> GetOrders(ControlGridFormRequest options)
{
int totals;
var items = this.service.GetRecords(options, out totals);
var result = new ControlGridAjaxData <OrderInfo>(items, totals);
return(result);
}
private ControlGridAjaxData <PartnerInfo> GetPartner(ControlGridFormRequest options)
{
int totals;
var service = WorkContext.Resolve <IPartnerService>();
var items = service.GetRecords(options, out totals, x => x.RefId == 0);
var result = new ControlGridAjaxData <PartnerInfo>(items, totals);
return(result);
}
private ControlGridAjaxData <EmailInfo> GetEmails(ControlGridFormRequest options)
{
int totals;
var service = WorkContext.Resolve <IEmailsService>();
var items = service.GetRecords(options, out totals);
var result = new ControlGridAjaxData <EmailInfo>(items, totals);
return(result);
}
private ControlGridAjaxData <SettingsModel> GetSettings(ControlGridFormRequest options)
{
var models = settings.Value.Where(x => !x.Hidden).Select(x => new SettingsModel
{
Id = x.GetType().FullName,
Name = x.Name
}).OrderBy(x => x.Name).ToList();
return(new ControlGridAjaxData <SettingsModel>(models));
}
private ControlGridAjaxData <RecruitmentInfo> GetRecruitment(ControlGridFormRequest options)
{
var categoryId = 0;
var status = -1;
service.CategoryId = categoryId;
int totals;
var items = this.service.SearchPaged(status, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <RecruitmentInfo>(items, totals));
}
private ControlGridAjaxData <CategoryInfo> GetCategories(ControlGridFormRequest options)
{
int totals;
var service = WorkContext.Resolve <ICategoriesService>();
bool status = false;
var list = service.GetPaged(status, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <CategoryInfo>(list, totals));
}
private ControlGridAjaxData <ExtensionDescriptorModel> GetThemes(ControlGridFormRequest controlGridFormRequest)
{
var themes = extensionManager.AvailableExtensions().Where(IsAllowedTheme).ToList();
return(new ControlGridAjaxData <ExtensionDescriptorModel>(themes.Select(x => new ExtensionDescriptorModel
{
Id = x.Id,
Name = x.Name,
Installed = shellDescriptor.Features.Any(y => y.Name == x.Id) || x.Id == "Default",
IsDefault = x.Id == siteSettings.Theme
}).OrderByDescending(x => x.Installed).ThenBy(x => x.Name)));
}
private ControlGridAjaxData <BannerInfo> GetBanners(ControlGridFormRequest options)
{
int totals;
var CategoryId = 0;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.CategoryId]))
{
CategoryId = Convert.ToInt32(Request.Form[Extensions.Constants.CategoryId]);
}
var items = this.service.GetRecords(options, out totals, x => x.CategoryId == CategoryId);
var result = new ControlGridAjaxData <BannerInfo>(items, totals);
return(result);
}
private ControlGridAjaxData <Widget> GetWidgets(ControlGridFormRequest options, int?pageId)
{
var widgetService = WorkContext.Resolve <IWidgetService>();
if (pageId.HasValue)
{
return(new ControlGridAjaxData <Widget>(widgetService.GetRecords(x => x.PageId == pageId && x.RefId == null).OrderBy(x => x.ZoneId).ThenBy(x => x.Order)));
}
int totals;
var records = widgetService.GetRecords(options, out totals, x => x.PageId == null && x.RefId == null).OrderBy(x => x.ZoneId).ThenBy(x => x.Order);
return(new ControlGridAjaxData <Widget>(records, totals));
}
private ControlGridAjaxData <OrderDetailsInfo> GetProducts(ControlGridFormRequest options)
{
var orderId = 0;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.OrderId]))
{
orderId = Convert.ToInt32(Request.Form[Extensions.Constants.OrderId]);
}
var totals = 0;
var items = WorkContext.Resolve <IOrderDetailsService>().GetRecords(x => x.OrderId == orderId);
var result = new ControlGridAjaxData <OrderDetailsInfo>(items, totals);
return(result);
}
private ControlGridAjaxData <ImageInfo> GetImages(ControlGridFormRequest options)
{
int totals;
var service = WorkContext.Resolve <IImagesService>();
var categoryId = 0;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.CategoryId]))
{
categoryId = Convert.ToInt32(Request.Form[Extensions.Constants.CategoryId]);
}
var records = service.SearchPaged("", categoryId, -1, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <ImageInfo>(records, totals));
}
private ControlGridAjaxData <ArticlesInfo> GetArticles(ControlGridFormRequest options)
{
var searchText = string.Empty;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.SearchText]))
{
searchText = Request.Form[Extensions.Constants.SearchText];
}
var languageCode = WorkContext.CurrentCulture;
var categoryId = 0;
int totals;
var service = WorkContext.Resolve <IArticlesService>();
service.LanguageCode = languageCode;
service.CategoryId = categoryId;
var records = service.SearchPaged(searchText, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <ArticlesInfo>(records, totals));
}
public IList <TRecord> GetRecords(ControlGridFormRequest request, out int totalRecords, Expression <Func <TRecord, bool> > predicate = null, params Expression <Func <TRecord, dynamic> >[] includePaths)
{
var queryable = Repository.Table;
if (!string.IsNullOrEmpty(request.SortColumn))
{
queryable = request.SortDirection ?
queryable.OrderBy(request.SortColumn) :
queryable.OrderBy(request.SortColumn + " DESC");
}
else
{
queryable = MakeDefaultOrderBy(queryable);
}
if (includePaths != null && includePaths.Length > 0)
{
queryable = includePaths.Aggregate(queryable, (current, path) => current.Include(path));
}
// Filtering
if (request.Filters != null && request.Filters.Count > 0)
{
var expression = GetFilters(request.Filters);
queryable = queryable.Where(expression);
}
if (predicate != null)
{
queryable = queryable.AsExpandable().Where(predicate);
}
totalRecords = queryable.Count();
var items = queryable.Skip((request.PageIndex - 1) * request.PageSize).Take(request.PageSize).ToList();
return(items);
}
private ControlGridAjaxData <CategoryInfo> GetCategories(ControlGridFormRequest options)
{
int totals;
var service = WorkContext.Resolve <ICategoriesService>();
var languageCode = WorkContext.CurrentCulture;
bool status = false;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.StatusId]))
{
var statusId = Convert.ToInt32(Request.Form[Extensions.Constants.StatusId]);
switch ((Status)statusId)
{
case Status.Deleted:
status = true;
break;
}
}
service.LanguageCode = languageCode;
var list = service.GetPaged(status, options.PageIndex, options.PageSize, out totals);
return(new ControlGridAjaxData <CategoryInfo>(list, totals));
}
private ControlGridAjaxData <SliderInfo> GetSliders(ControlGridFormRequest options)
{
int totals;
var service = WorkContext.Resolve <ISlidersService>();
var pageType = 0;
if (Utilities.IsNotNull(Request.Form[Extensions.Constants.PageType]))
{
pageType = Convert.ToInt32(Request.Form[Extensions.Constants.PageType]);
}
if (pageType != 0)
{
var items = service.GetRecords(options, out totals, x => x.Type == pageType);
var result = new ControlGridAjaxData <SliderInfo>(items, totals);
return(result);
}
else
{
var items = service.GetRecords(options, out totals);
var result = new ControlGridAjaxData <SliderInfo>(items, totals);
return(result);
}
}
