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