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