public static IEnumerable <Item> GetSuppliedItems(string supplierId = "%",
string itemName = "%")
{
var reader = InventoryDb.GetSupplierItems(supplierId, itemName).CreateDataReader();
while (reader.Read())
{
var pId = int.Parse(reader["Item_ID"].ToString());
var pName = reader["ProductName"].ToString();
var pStock = int.Parse(reader["Stock"].ToString());
var pPrice = decimal.Parse(reader["Price"].ToString());
yield return(new Item(pId, pName, pStock, pPrice));
}
}
