public AttributeCollection FetchByQuery(Query qry) { AttributeCollection coll = new AttributeCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
/// <summary> /// Fetches the available attributes by product id. /// </summary> /// <param name="productId">The product id.</param> /// <returns></returns> public AttributeCollection FetchAvailableAttributesByProductId(int productId) { IDataReader reader = SPs.FetchAvailableAttributesByProductId(productId).GetReader(); AttributeCollection attributeCollection = new AttributeCollection(); attributeCollection.LoadAndCloseReader(reader); return(attributeCollection); }
public AttributeCollection FetchAll() { AttributeCollection coll = new AttributeCollection(); Query qry = new Query(Attribute.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static MettleSystems.dashCommerce.Store.AttributeCollection GetAttributeCollection(int varProductId) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand( "SELECT * FROM dashCommerce_Store_Attribute INNER JOIN dashCommerce_Store_Product_Attribute_Map ON " + "dashCommerce_Store_Attribute.AttributeId=dashCommerce_Store_Product_Attribute_Map.AttributeId WHERE dashCommerce_Store_Product_Attribute_Map.ProductId=@ProductId", Product.Schema.Provider.Name); cmd.AddParameter("@ProductId", varProductId, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); AttributeCollection coll = new AttributeCollection(); coll.LoadAndCloseReader(rdr); return(coll); }
/// <summary> /// Fetches the available attributes by product id. /// </summary> /// <param name="productId">The product id.</param> /// <returns></returns> public AttributeCollection FetchAvailableAttributesByProductId(int productId) { IDataReader reader = SPs.FetchAvailableAttributesByProductId(productId).GetReader(); AttributeCollection attributeCollection = new AttributeCollection(); attributeCollection.LoadAndCloseReader(reader); return attributeCollection; }