public CategoryCollection FetchAll() { CategoryCollection coll = new CategoryCollection(); Query qry = new Query(Category.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
/// <summary> /// Fetches the associated categories by product id. /// </summary> /// <param name="productId">The product id.</param> /// <returns></returns> public CategoryCollection FetchAssociatedCategoriesByProductId(int productId) { IDataReader reader = SPs.FetchAssociatedCategoriesByProductId(productId).GetReader(); CategoryCollection categoryCollection = new CategoryCollection(); categoryCollection.LoadAndCloseReader(reader); return categoryCollection; }
/// <summary> /// Gets all Sub-Categories by the specified Category Id /// </summary> /// <param name="categoryId"></param> /// <returns></returns> public CategoryCollection GetSubCategories(int categoryId) { CategoryCollection categories = new CategoryCollection(); Query q = Category.CreateQuery(); q.AndWhere(Category.Columns.ParentId, categoryId); q.OrderByDesc(Category.Columns.Name); categories.LoadAndCloseReader(q.ExecuteReader()); return(categories); }
public static CategoryCollection GetCategories(int hostID) { CacheManager<string, CategoryCollection> categoryCache = GetCache(); string cacheKey = String.Format("KickCategories_{0}", hostID); CategoryCollection categories = categoryCache[cacheKey]; if (categories == null) { categories = new CategoryCollection(); SubSonic.OrderBy orderBy = SubSonic.OrderBy.Asc(Category.Columns.Name); categories.LoadAndCloseReader(Category.FetchByParameter(Category.Columns.HostID, hostID, orderBy)); categoryCache.Insert(cacheKey, categories, CacheHelper.CACHE_DURATION_IN_SECONDS); } return categories; }
public static CategoryCollection GetCategories(int hostID) { CacheManager <string, CategoryCollection> categoryCache = GetCache(); string cacheKey = String.Format("KickCategories_{0}", hostID); CategoryCollection categories = categoryCache[cacheKey]; if (categories == null) { categories = new CategoryCollection(); SubSonic.OrderBy orderBy = SubSonic.OrderBy.Asc(Category.Columns.Name); categories.LoadAndCloseReader(Category.FetchByParameter(Category.Columns.HostID, hostID, orderBy)); categoryCache.Insert(cacheKey, categories, CacheHelper.CACHE_DURATION_IN_SECONDS); } return(categories); }
/// <summary> /// Gets all Sub-Categories by the specified Category Id /// </summary> /// <param name="categoryId"></param> /// <returns></returns> public CategoryCollection GetSubCategories(int categoryId) { CategoryCollection categories = new CategoryCollection(); Query q = Category.CreateQuery(); q.AndWhere(Category.Columns.ParentId, categoryId); q.OrderByDesc(Category.Columns.Name); categories.LoadAndCloseReader(q.ExecuteReader()); return categories; }
public CategoryCollection FetchByQuery(Query qry) { CategoryCollection coll = new CategoryCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }