public void UpdateBeverage(int id, string name, decimal price, BBeverageCategory beverageCategory)
{
BBeverage beverage = new BBeverage(id, name, price, beverageCategory);
BeverageController beverageController = new BeverageController();
beverageController.UpdateBeverage(beverage);
}
public void DeleteBeverage(int id)
{
BBeverage beverage = new BBeverage(id);
BeverageController beverageController = new BeverageController();
beverageController.DeleteBeverage(beverage);
}
public void CreateBeverage(string name, decimal price, BBeverageCategory beverageCategory)
{
BBeverage beverage = new BBeverage(name, price, beverageCategory);
BeverageController beverageController = new BeverageController();
beverageController.CreateBeverage(beverage);
}
public List <BBeverage> GetAllHotDrinks()
{
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 = 1";
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);
}
public void DeleteBeverage(BBeverage beverage)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdDeleteBeverage = connection.CreateCommand())
{
cmdDeleteBeverage.CommandText = "delete from Beverage where id = @id";
cmdDeleteBeverage.Parameters.AddWithValue("Id", beverage.Id);
cmdDeleteBeverage.ExecuteNonQuery();
}
}
}
public void CreateBeverage(BBeverage beverage)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdInsertBeverage = connection.CreateCommand())
{
cmdInsertBeverage.CommandText = "INSERT INTO Beverage(Name, Price, BeverageCategory) VALUES(@Name, @Price, @BeverageCategory)";
cmdInsertBeverage.Parameters.AddWithValue("Name", beverage.Name);
cmdInsertBeverage.Parameters.AddWithValue("Price", beverage.Price);
cmdInsertBeverage.Parameters.AddWithValue("beverageCategoryId", beverage.BeverageCategory);
cmdInsertBeverage.ExecuteNonQuery();
}
}
}
public void UpdateBeverage(BBeverage beverage)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand cmdUpdateBeverage = connection.CreateCommand())
{
cmdUpdateBeverage.CommandText = "update beverage set name = @name, price = @price, BeverageCategoryId = @beverageCategoryId where id = @id";
cmdUpdateBeverage.Parameters.AddWithValue("id", beverage.Id);
cmdUpdateBeverage.Parameters.AddWithValue("name", beverage.Name);
cmdUpdateBeverage.Parameters.AddWithValue("price", beverage.Price);
cmdUpdateBeverage.Parameters.AddWithValue("beverageCategoryId", beverage.BeverageCategory.Id);
cmdUpdateBeverage.ExecuteNonQuery();
}
}
}
public void DeleteBeverage(BBeverage beverage)
{
DBBeverage dBBeverage = new DBBeverage();
dBBeverage.DeleteBeverage(beverage);
}
public void UpdateBeverage(BBeverage beverage)
{
DBBeverage dBBeverage = new DBBeverage();
dBBeverage.UpdateBeverage(beverage);
}
public void CreateBeverage(BBeverage beverage)
{
DBBeverage dBBeverage = new DBBeverage();
dBBeverage.CreateBeverage(beverage);
}
