/// <summary>
/// Get an individual item based on a unique key
/// </summary>
/// <param name="itemId">unique key</param>
/// <returns>Details about the Item</returns>
public ItemInfo GetItem(string itemId)
{
//Set up a return value
ItemInfo item = null;
//Create a parameter
SqlParameter parm = new SqlParameter(PARM_ITEM_ID, SqlDbType.VarChar, 10);
//Bind the parameter
parm.Value = itemId;
//Execute the query
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ITEM, parm))
{
if (rdr.Read())
item = new ItemInfo(rdr.GetString(0), rdr.GetString(1), 0, rdr.GetDecimal(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6));
else
item = new ItemInfo();
}
return item;
}
/// <summary>
/// Function to get a list of items within a product group
/// </summary>
/// <param name="productId">Product Id</param>
/// <returns>A Generic List of ItemInfo</returns>
public IList<ItemInfo> GetItemsByProduct(string productId)
{
IList<ItemInfo> itemsByProduct = new List<ItemInfo>();
SqlParameter parm = new SqlParameter(PARM_PRODUCT_ID, SqlDbType.VarChar, 10);
parm.Value = productId;
//Execute the query against the database
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ITEMS_BY_PRODUCT, parm))
{
// Scroll through the results
while (rdr.Read())
{
ItemInfo item = new ItemInfo(rdr.GetString(0), rdr.GetString(1), rdr.GetInt32(2), rdr.GetDecimal(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetString(7));
//Add each item to the arraylist
itemsByProduct.Add(item);
}
}
return itemsByProduct;
}