public List <BBeverage> GetAllColdDrinks()
{
List <BBeverage> beverages = new List <BBeverage>();
BBeverage tempB;
BBeverageCategory tempBC;
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "select beverage.id as bid, beverage.name as bname, beverage.price as price, beverageCategory.id as id, BeverageCategory.name as name from Beverage, BeverageCategory where Beverage.beverageCategoryID = BeverageCategory.id and BeverageCategory.id = 2";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tempB = new BBeverage();
tempBC = new BBeverageCategory();
tempB.Id = reader.GetInt32(reader.GetOrdinal("bid"));
tempB.Name = reader.GetString(reader.GetOrdinal("bname"));
tempB.Price = reader.GetDecimal(reader.GetOrdinal("price"));
tempBC.Id = reader.GetInt32(reader.GetOrdinal("id"));
tempBC.Name = reader.GetString(reader.GetOrdinal("name"));
tempB.BeverageCategory = tempBC;
beverages.Add(tempB);
}
}
}
return(beverages);
}
