public static void MoveCategoryDown(int categoryId) { Category source = new Category(); if (source.LoadByPrimaryKey(categoryId)) { //SELECT TOP 1 * //FROM DNNspot_Store_Category WHERE StoreId = 1 AND ParentId IS NULL AND SortOrder >= 3 AND Id <> 33 //ORDER BY SortOrder ASC CategoryQuery q = new CategoryQuery(); q.es.Top = 1; q.Where(q.StoreId == source.StoreId); if (source.ParentId.HasValue) { q.Where(q.ParentId == source.ParentId.Value); } else { q.Where(q.ParentId.IsNull()); } q.Where(q.SortOrder >= source.SortOrder); q.Where(q.Id != categoryId); q.OrderBy(q.SortOrder.Ascending); Category dest = new Category(); if (dest.Load(q)) { SwapAndReNumberSortOrder(source, dest); } } }
public static List <Category> GetTopLevelCategories(int storeId, bool includeHidden) { CategoryQuery qry = new CategoryQuery(); qry.Where(qry.StoreId == storeId); qry.Where(qry.ParentId.IsNull()); if (!includeHidden) { qry.Where(qry.IsDisplayed == true); } qry.OrderBy(qry.SortOrder.Ascending, qry.Name.Ascending); CategoryCollection rootCategories = new CategoryCollection(); rootCategories.Load(qry); List <Category> catList = new List <Category>(rootCategories.Count); foreach (var c in rootCategories) { catList.Add(c); } //return rootCategories; return(catList); }
public CategoryCollection GetChildCategoriesInSortedOrder(bool includeHidden) { //SortChildCategories(); //return this.CategoryCollectionByParentId; CategoryQuery q = new CategoryQuery(); q.Where(q.ParentId == this.Id.Value); if (!includeHidden) { q.Where(q.IsDisplayed == true); } q.OrderBy(q.SortOrder.Ascending, q.Name.Ascending); CategoryCollection collection = new CategoryCollection(); collection.Load(q); return(collection); }