public CategoryCollection FetchByQuery(Query qry) { CategoryCollection coll = new CategoryCollection(); 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); }
public CategoryCollection FetchAll() { CategoryCollection coll = new CategoryCollection(); Query qry = new Query(Category.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static MettleSystems.dashCommerce.Store.CategoryCollection GetCategoryCollection(int varProductId) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand( "SELECT * FROM dashCommerce_Store_Category INNER JOIN dashCommerce_Store_Product_Category_Map ON " + "dashCommerce_Store_Category.CategoryId=dashCommerce_Store_Product_Category_Map.CategoryId WHERE dashCommerce_Store_Product_Category_Map.ProductId=@ProductId", Product.Schema.Provider.Name); cmd.AddParameter("@ProductId", varProductId, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); CategoryCollection coll = new CategoryCollection(); coll.LoadAndCloseReader(rdr); return(coll); }
public static void SaveCategoryMap(int varProductId, CategoryCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM dashCommerce_Store_Product_Category_Map WHERE ProductId=@ProductId", Product.Schema.Provider.Name); cmdDel.AddParameter("@ProductId", varProductId); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Category item in items) { ProductCategoryMap varProductCategoryMap = new ProductCategoryMap(); varProductCategoryMap.SetColumnValue("ProductId", varProductId); varProductCategoryMap.SetColumnValue("CategoryId", item.GetPrimaryKeyValue()); varProductCategoryMap.Save(); } }
public CategoryCollection FetchByID(object CategoryId) { CategoryCollection coll = new CategoryCollection().Where("CategoryId", CategoryId).Load(); return(coll); }