public List <Products> GetAllProducts()
{
List <Products> AllProducts = new List <Products>();
using (ADOExecution exec = new ADOExecution(SQLBase.GetConnectionString()))
{
using (IDataReader dr = exec.ExecuteReader(CommandType.StoredProcedure, "GetAllProducts"))
while (dr.Read())
{
var Products = new Products();
Products.ID = Convert.ToInt32(dr["ID"]);
Products.product_id = (Convert.ToString(dr["product_id"]));
Products.product_name = Convert.ToString(dr["product_name"]);
Products.stock_available = Convert.ToString(dr["stock_available"]);
AllProducts.Add(Products);
}
return(AllProducts);
}
}
