public List <Product> All()
{
string query = "SELECT * from Product";
var model = new List <Product>();
var ImageContext = new ImageSQLContext();
using (SqlConnection con = new SqlConnection(cs_database.CS()))
{
con.Open();
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var p = new Product();
p.Id = Convert.ToInt32(reader["Id"]);
p.Name = (string)reader["Name"];
p.Ingredients = (string)reader["Ingredients"];
p.Price = Convert.ToDouble(reader["Price"]);
p.Picture = ImageContext.GetImageForProduct(Convert.ToInt32(reader["Id"]));
model.Add(p);
}
}
return(model);
}
/// <summary>
/// Populate an instance of <see cref="Product"/> from an <see cref="SqlDataReader"/>
/// </summary>
/// <param name="reader">The <see cref="SqlDataReader"/> containing a single record describing an <see cref="Product"/></param>
/// <returns>An instance of <see cref="Product"/> populated with all available properties</returns>
///
public static Product ProductFromReader(SqlDataReader reader)
{
//ProductSQLContext PContext = new ProductSQLContext();
var ImageContext = new ImageSQLContext();
Product newproduct = new Product
{
Id = Convert.ToInt32(reader["Id"]),
Name = (string)reader["Name"],
Ingredients = (string)reader["Ingredients"],
Picture = ImageContext.GetImageForProduct(Convert.ToInt32(reader["Id"]))
};
return(newproduct);
}