public AttributeItemCollection FetchByQuery(Query qry)
{
AttributeItemCollection coll = new AttributeItemCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public AttributeItemCollection FetchAll()
{
AttributeItemCollection coll = new AttributeItemCollection();
Query qry = new Query(AttributeItem.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
/// <summary>
/// Fetches the selected attribute item.
/// </summary>
/// <param name="attributeId">The attribute id.</param>
/// <param name="skuSuffix">The sku suffix.</param>
/// <returns></returns>
public AttributeItem FetchSelectedAttributeItem(int attributeId, string skuSuffix)
{
Query query = new Query(Store.AttributeItem.Schema).
AddWhere(Store.AttributeItem.Columns.AttributeId, attributeId).
AddWhere(Store.AttributeItem.Columns.SkuSuffix, skuSuffix);
IDataReader reader = query.ExecuteReader();
AttributeItemCollection attributeItemCollection = new AttributeItemCollection();
attributeItemCollection.LoadAndCloseReader(reader);
if (attributeItemCollection.Count > 0)
{
return(attributeItemCollection[0]);
}
else
{
return(null);
}
}
public AttributeItemCollection FetchByID(object AttributeItemId)
{
AttributeItemCollection coll = new AttributeItemCollection().Where("AttributeItemId", AttributeItemId).Load();
return(coll);
}