public override List <IProductByStore> Select()
{
Source = "sp_FetchProductByStore";
// Product fetching stored procedure
try
{
Object[] param = null;
DataSet Output = Commands.ExecuteQuery(Source, CommandType.StoredProcedure, param);
List <IProductByStore> ProductList = new List <IProductByStore>();
foreach (DataRow dr in Output.Tables[0].Rows)
{
IProductByStore Product = new ProductByStore();
Product.SetProductByStoreID(Int32.Parse(dr["pbsID"].ToString()));
Product.SetStoreID(Int32.Parse(dr["sID"].ToString()));
Product.SetCategoryID(Int32.Parse(dr["cID"].ToString()));
Product.SetProductID(Int32.Parse(dr["pID"].ToString()));
Product.SetStoreName(dr["storeName"].ToString());
Product.SetCategoryName(dr["categoryName"].ToString());
Product.SetProductName(dr["productName"].ToString());
Product.SetPrice((double)dr["price"]);
Product.SetQuantity(Int32.Parse(dr["Quantity"].ToString()));
Product.SetQuantityPerUnit(dr["QuantityPerUnit"].ToString());
ProductList.Add(Product);
}
return(ProductList);
}
catch (Exception ex)
{
Logger.Instance().Log(Fatal.Instance(), ex);
throw ex;
}
}