public IList <CategoryDataTableModel> GetDataTable(string term, int page, int count, Order order, CategoryOrderBy orderBy, CategorySearchBy searchBy) { IQueryable <Category> selectedCategories = _categories.AsQueryable(); if (!string.IsNullOrEmpty(term)) { switch (searchBy) { case CategorySearchBy.Name: selectedCategories = selectedCategories.Where(category => category.Name.Contains(term)).AsQueryable(); break; case CategorySearchBy.Description: selectedCategories = selectedCategories.Where(category => category.Description.Contains(term)).AsQueryable(); break; } } if (order == Order.Asscending) { switch (orderBy) { case CategoryOrderBy.Id: selectedCategories = selectedCategories.OrderBy(category => category.Id).AsQueryable(); break; case CategoryOrderBy.Name: selectedCategories = selectedCategories.OrderBy(category => category.Name).AsQueryable(); break; } } else { switch (orderBy) { case CategoryOrderBy.Id: selectedCategories = selectedCategories.OrderByDescending(category => category.Id).AsQueryable(); break; case CategoryOrderBy.Name: selectedCategories = selectedCategories.OrderByDescending(category => category.Name).AsQueryable(); break; } } return(selectedCategories.Select(category => new CategoryDataTableModel { Name = category.Name, Description = category.Description, Id = category.Id, ArticlesCount = category.Articles.Count, Order = category.Order, }).Skip(page * count).Take(count).ToList()); }
public IList<CategoryDataTableModel> GetDataTable(string term, int page, int count, Order order, CategoryOrderBy orderBy, CategorySearchBy searchBy) { IQueryable<Category> selectedCategories = _categories.AsQueryable(); if (!string.IsNullOrEmpty(term)) { switch (searchBy) { case CategorySearchBy.Name: selectedCategories = selectedCategories.Where(category => category.Name.Contains(term)).AsQueryable(); break; case CategorySearchBy.Description: selectedCategories = selectedCategories.Where(category => category.Description.Contains(term)).AsQueryable(); break; } } if (order == Order.Asscending) { switch (orderBy) { case CategoryOrderBy.Id: selectedCategories = selectedCategories.OrderBy(category => category.Id).AsQueryable(); break; case CategoryOrderBy.Name: selectedCategories = selectedCategories.OrderBy(category => category.Name).AsQueryable(); break; } } else { switch (orderBy) { case CategoryOrderBy.Id: selectedCategories = selectedCategories.OrderByDescending(category => category.Id).AsQueryable(); break; case CategoryOrderBy.Name: selectedCategories = selectedCategories.OrderByDescending(category => category.Name).AsQueryable(); break; } } return selectedCategories.Select(category => new CategoryDataTableModel { Name = category.Name, Description = category.Description, Id = category.Id, ArticlesCount = category.Articles.Count, Order = category.Order, }).Skip(page * count).Take(count).ToList(); }
public CategoryFilter(XmlElement node) : base(node) { foreach (XmlElement propertyNode in node.ChildNodes) { switch (propertyNode.Name) { case "freeText": this._FreeText = propertyNode.InnerText; continue; case "membersIn": this._MembersIn = propertyNode.InnerText; continue; case "nameOrReferenceIdStartsWith": this._NameOrReferenceIdStartsWith = propertyNode.InnerText; continue; case "managerEqual": this._ManagerEqual = propertyNode.InnerText; continue; case "memberEqual": this._MemberEqual = propertyNode.InnerText; continue; case "fullNameStartsWithIn": this._FullNameStartsWithIn = propertyNode.InnerText; continue; case "ancestorIdIn": this._AncestorIdIn = propertyNode.InnerText; continue; case "idOrInheritedParentIdIn": this._IdOrInheritedParentIdIn = propertyNode.InnerText; continue; case "orderBy": this._OrderBy = (CategoryOrderBy)StringEnum.Parse(typeof(CategoryOrderBy), propertyNode.InnerText); continue; } } }
public CategoryFilter(JToken node) : base(node) { if (node["freeText"] != null) { this._FreeText = node["freeText"].Value <string>(); } if (node["membersIn"] != null) { this._MembersIn = node["membersIn"].Value <string>(); } if (node["nameOrReferenceIdStartsWith"] != null) { this._NameOrReferenceIdStartsWith = node["nameOrReferenceIdStartsWith"].Value <string>(); } if (node["managerEqual"] != null) { this._ManagerEqual = node["managerEqual"].Value <string>(); } if (node["memberEqual"] != null) { this._MemberEqual = node["memberEqual"].Value <string>(); } if (node["fullNameStartsWithIn"] != null) { this._FullNameStartsWithIn = node["fullNameStartsWithIn"].Value <string>(); } if (node["ancestorIdIn"] != null) { this._AncestorIdIn = node["ancestorIdIn"].Value <string>(); } if (node["idOrInheritedParentIdIn"] != null) { this._IdOrInheritedParentIdIn = node["idOrInheritedParentIdIn"].Value <string>(); } if (node["orderBy"] != null) { this._OrderBy = (CategoryOrderBy)StringEnum.Parse(typeof(CategoryOrderBy), node["orderBy"].Value <string>()); } }
public virtual ActionResult DataTable(string term = "", int page = 0, int count = 10, Order order = Order.Descending, CategoryOrderBy orderBy = CategoryOrderBy.Id, CategorySearchBy searchBy = CategorySearchBy.Name) { ViewBag.CurrentPage = page; ViewBag.Count = count; ViewBag.TERM = term; ViewBag.PAGE = page; ViewBag.COUNT = count; ViewBag.ORDER = order; ViewBag.ORDERBY = orderBy; ViewBag.SEARCHBY = searchBy; var selectListOrderBy = new List <SelectListItem> { new SelectListItem { Text = "تاریخ", Value = "Id" }, new SelectListItem { Text = "نام", Value = "Name" }, }; ViewBag.OrderByItems = new SelectList(selectListOrderBy, "Value", "Text", orderBy); ViewBag.OrderByList = DropDownList.OrderList(order); ViewBag.CountList = DropDownList.CountList(count); IList <CategoryDataTableModel> model = _categoryService.GetDataTable(term, page, count, order, orderBy, searchBy); ViewBag.TotalRecords = (string.IsNullOrEmpty(term)) ? _categoryService.Count : model.Count; return(PartialView(MVC.Admin.Category.Views._DataTable, model)); }
private IEnumerable <Category> OrderByDescending(IEnumerable <Category> categories, CategoryOrderBy categoryOrderBy) { return(categoryOrderBy == CategoryOrderBy.Newest ? categories.OrderByDescending(c => c.DateCreated) : categories.OrderByDescending(c => c.BlogCategories.Count())); }
public Category(JToken node) : base(node) { if (node["id"] != null) { this._Id = ParseInt(node["id"].Value <string>()); } if (node["parentId"] != null) { this._ParentId = ParseInt(node["parentId"].Value <string>()); } if (node["depth"] != null) { this._Depth = ParseInt(node["depth"].Value <string>()); } if (node["partnerId"] != null) { this._PartnerId = ParseInt(node["partnerId"].Value <string>()); } if (node["name"] != null) { this._Name = node["name"].Value <string>(); } if (node["fullName"] != null) { this._FullName = node["fullName"].Value <string>(); } if (node["fullIds"] != null) { this._FullIds = node["fullIds"].Value <string>(); } if (node["entriesCount"] != null) { this._EntriesCount = ParseInt(node["entriesCount"].Value <string>()); } if (node["createdAt"] != null) { this._CreatedAt = ParseInt(node["createdAt"].Value <string>()); } if (node["updatedAt"] != null) { this._UpdatedAt = ParseInt(node["updatedAt"].Value <string>()); } if (node["description"] != null) { this._Description = node["description"].Value <string>(); } if (node["tags"] != null) { this._Tags = node["tags"].Value <string>(); } if (node["appearInList"] != null) { this._AppearInList = (AppearInListType)ParseEnum(typeof(AppearInListType), node["appearInList"].Value <string>()); } if (node["privacy"] != null) { this._Privacy = (PrivacyType)ParseEnum(typeof(PrivacyType), node["privacy"].Value <string>()); } if (node["inheritanceType"] != null) { this._InheritanceType = (InheritanceType)ParseEnum(typeof(InheritanceType), node["inheritanceType"].Value <string>()); } if (node["userJoinPolicy"] != null) { this._UserJoinPolicy = (UserJoinPolicyType)ParseEnum(typeof(UserJoinPolicyType), node["userJoinPolicy"].Value <string>()); } if (node["defaultPermissionLevel"] != null) { this._DefaultPermissionLevel = (CategoryUserPermissionLevel)ParseEnum(typeof(CategoryUserPermissionLevel), node["defaultPermissionLevel"].Value <string>()); } if (node["owner"] != null) { this._Owner = node["owner"].Value <string>(); } if (node["directEntriesCount"] != null) { this._DirectEntriesCount = ParseInt(node["directEntriesCount"].Value <string>()); } if (node["referenceId"] != null) { this._ReferenceId = node["referenceId"].Value <string>(); } if (node["contributionPolicy"] != null) { this._ContributionPolicy = (ContributionPolicyType)ParseEnum(typeof(ContributionPolicyType), node["contributionPolicy"].Value <string>()); } if (node["membersCount"] != null) { this._MembersCount = ParseInt(node["membersCount"].Value <string>()); } if (node["pendingMembersCount"] != null) { this._PendingMembersCount = ParseInt(node["pendingMembersCount"].Value <string>()); } if (node["privacyContext"] != null) { this._PrivacyContext = node["privacyContext"].Value <string>(); } if (node["privacyContexts"] != null) { this._PrivacyContexts = node["privacyContexts"].Value <string>(); } if (node["status"] != null) { this._Status = (CategoryStatus)ParseEnum(typeof(CategoryStatus), node["status"].Value <string>()); } if (node["inheritedParentId"] != null) { this._InheritedParentId = ParseInt(node["inheritedParentId"].Value <string>()); } if (node["partnerSortValue"] != null) { this._PartnerSortValue = ParseInt(node["partnerSortValue"].Value <string>()); } if (node["partnerData"] != null) { this._PartnerData = node["partnerData"].Value <string>(); } if (node["defaultOrderBy"] != null) { this._DefaultOrderBy = (CategoryOrderBy)StringEnum.Parse(typeof(CategoryOrderBy), node["defaultOrderBy"].Value <string>()); } if (node["directSubCategoriesCount"] != null) { this._DirectSubCategoriesCount = ParseInt(node["directSubCategoriesCount"].Value <string>()); } if (node["moderation"] != null) { this._Moderation = (NullableBoolean)ParseEnum(typeof(NullableBoolean), node["moderation"].Value <string>()); } if (node["pendingEntriesCount"] != null) { this._PendingEntriesCount = ParseInt(node["pendingEntriesCount"].Value <string>()); } if (node["isAggregationCategory"] != null) { this._IsAggregationCategory = (NullableBoolean)ParseEnum(typeof(NullableBoolean), node["isAggregationCategory"].Value <string>()); } if (node["aggregationCategories"] != null) { this._AggregationCategories = node["aggregationCategories"].Value <string>(); } if (node["adminTags"] != null) { this._AdminTags = node["adminTags"].Value <string>(); } }
public Category(XmlElement node) : base(node) { foreach (XmlElement propertyNode in node.ChildNodes) { switch (propertyNode.Name) { case "id": this._Id = ParseInt(propertyNode.InnerText); continue; case "parentId": this._ParentId = ParseInt(propertyNode.InnerText); continue; case "depth": this._Depth = ParseInt(propertyNode.InnerText); continue; case "partnerId": this._PartnerId = ParseInt(propertyNode.InnerText); continue; case "name": this._Name = propertyNode.InnerText; continue; case "fullName": this._FullName = propertyNode.InnerText; continue; case "fullIds": this._FullIds = propertyNode.InnerText; continue; case "entriesCount": this._EntriesCount = ParseInt(propertyNode.InnerText); continue; case "createdAt": this._CreatedAt = ParseInt(propertyNode.InnerText); continue; case "updatedAt": this._UpdatedAt = ParseInt(propertyNode.InnerText); continue; case "description": this._Description = propertyNode.InnerText; continue; case "tags": this._Tags = propertyNode.InnerText; continue; case "appearInList": this._AppearInList = (AppearInListType)ParseEnum(typeof(AppearInListType), propertyNode.InnerText); continue; case "privacy": this._Privacy = (PrivacyType)ParseEnum(typeof(PrivacyType), propertyNode.InnerText); continue; case "inheritanceType": this._InheritanceType = (InheritanceType)ParseEnum(typeof(InheritanceType), propertyNode.InnerText); continue; case "userJoinPolicy": this._UserJoinPolicy = (UserJoinPolicyType)ParseEnum(typeof(UserJoinPolicyType), propertyNode.InnerText); continue; case "defaultPermissionLevel": this._DefaultPermissionLevel = (CategoryUserPermissionLevel)ParseEnum(typeof(CategoryUserPermissionLevel), propertyNode.InnerText); continue; case "owner": this._Owner = propertyNode.InnerText; continue; case "directEntriesCount": this._DirectEntriesCount = ParseInt(propertyNode.InnerText); continue; case "referenceId": this._ReferenceId = propertyNode.InnerText; continue; case "contributionPolicy": this._ContributionPolicy = (ContributionPolicyType)ParseEnum(typeof(ContributionPolicyType), propertyNode.InnerText); continue; case "membersCount": this._MembersCount = ParseInt(propertyNode.InnerText); continue; case "pendingMembersCount": this._PendingMembersCount = ParseInt(propertyNode.InnerText); continue; case "privacyContext": this._PrivacyContext = propertyNode.InnerText; continue; case "privacyContexts": this._PrivacyContexts = propertyNode.InnerText; continue; case "status": this._Status = (CategoryStatus)ParseEnum(typeof(CategoryStatus), propertyNode.InnerText); continue; case "inheritedParentId": this._InheritedParentId = ParseInt(propertyNode.InnerText); continue; case "partnerSortValue": this._PartnerSortValue = ParseInt(propertyNode.InnerText); continue; case "partnerData": this._PartnerData = propertyNode.InnerText; continue; case "defaultOrderBy": this._DefaultOrderBy = (CategoryOrderBy)StringEnum.Parse(typeof(CategoryOrderBy), propertyNode.InnerText); continue; case "directSubCategoriesCount": this._DirectSubCategoriesCount = ParseInt(propertyNode.InnerText); continue; case "moderation": this._Moderation = (NullableBoolean)ParseEnum(typeof(NullableBoolean), propertyNode.InnerText); continue; case "pendingEntriesCount": this._PendingEntriesCount = ParseInt(propertyNode.InnerText); continue; case "isAggregationCategory": this._IsAggregationCategory = (NullableBoolean)ParseEnum(typeof(NullableBoolean), propertyNode.InnerText); continue; case "aggregationCategories": this._AggregationCategories = propertyNode.InnerText; continue; } } }