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