public void Update(MainDish mainDish)
{
try
{
// UPDATE dbo.MainDish SET Name = 'ChickenBreast', Price = 42 WHERE Price = 42
string cmText = "UPDATE dbo.MainDish SET Name = @Name, Price = @Price WHERE Price = @OldPrice";
SqlCommand command = new SqlCommand(cmText, SqlConnection);
command.Parameters.AddWithValue("@Name", mainDish.Name);
command.Parameters.AddWithValue("@OldPrice", mainDish.Price);
command.Parameters.AddWithValue("@Price", 70);
SqlConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw new Exception($"Update failed on exeption: {e}");
}
finally
{
if (SqlConnection != null)
{
SqlConnection.Close();
}
}
}
private void showMainDish(MainDish i_MainDish)
{
errorText.Text = "";
quantityText.Text = "";
severalDinerText.Text = "";
currentListBox.Items.Insert(currentListBox.Items.Count, i_MainDish);
}
public void SelectMainDishToDB()
{
MainDish mainDish = InitializeDishes.InitializeMainDish("ChickenBreast", 2, 1, eMainDish.ChickenBreast);
mainDish.Price = 70;
Broker broker = new Broker();
string name = broker.Select(mainDish);
Assert.AreEqual("ChickenBreast", name);
}
public void UpdateMainDishToDB()
{
MainDish mainDish = InitializeDishes.InitializeMainDish("ChickenBreast", 2, 1, eMainDish.ChickenBreast);
mainDish.Price = 42;
Broker broker = new Broker();
broker.Update(mainDish);
Assert.AreEqual(eAppetizer.ChickenNuggets, eAppetizer.ChickenNuggets);
}
public void AddMainDishToDB()
{
MainDish mainDish = InitializeDishes.InitializeMainDish("chicken", 2, 1, eMainDish.ChickenBreast);
mainDish.Price = 30;
Broker broker = new Broker();
broker.Insert(mainDish);
Assert.AreEqual(eAppetizer.ChickenNuggets, eAppetizer.ChickenNuggets);
}
static void Main(string[] args)
{
Coffee coffee = new Coffee("Late", true, false, true, true);
Tea tea = new Tea("Green tea", true, false, false);
Coctail coctail = new Coctail("Margarita", false, true, false, true);
Soup soup = new Soup("Jauhelihakeitto", "usual", true, true, false);
MainDish maindish = new MainDish("Salmonsteak", "grillfood", true, false, true, "Salad");
Dessert dessert = new Dessert("Icecreamballs", "icecream", false, "chocolate");
Console.WriteLine(coffee.Info());
Console.WriteLine(tea.Info());
Console.WriteLine(coctail.Info());
Console.WriteLine(soup.Info());
Console.WriteLine(maindish.Info());
Console.WriteLine(dessert.Info());
}
//private void waterButton_Click(object sender, EventArgs e)
//{
// createMainDish("Water", "Soft");
//}
//private void appleButton_Click(object sender, EventArgs e)
//{
// createMainDish("Apple", "Soft");
//}
//private void orangeButton_Click(object sender, EventArgs e)
//{
// createMainDish("Orange", "Soft");
//}
private void createMainDish(string i_Name)
{
if (severalDinerText.Text == "")
{
errorText.Text = "Several Diner Has Not Been Chosen Yet!";
}
else if (quantityText.Text == "")
{
errorText.Text = "Quantity Has Not Been Chosen Yet!";
}
else
{
MainDish mainDish = InitializeFoods.InitializeMainDish(i_Name, Int32.Parse(quantityText.Text), severalDinerText.Text);
showMainDish(mainDish);
}
}
public void InitializeMainDish_SpringChicken()
{
string name = "Spring Chicken";
int quantity = 2;
int dinerSerialNumber = 1;
eMainDish mainDishType = eMainDish.SpringChicken;
MainDish mainDish = InitializeDishes.InitializeMainDish(name, quantity, dinerSerialNumber, mainDishType);
Assert.AreEqual(mainDishType, mainDish.MainDishType);
Assert.AreEqual(dinerSerialNumber, mainDish.DinerSerialNumber);
Assert.AreEqual(DishRanks.DishesRank[eDishTypes.MainDish], mainDish.MainRank);
Assert.AreEqual(name, mainDish.Name);
Assert.AreEqual(DishPrices.MainDishPrices[mainDishType], mainDish.Price);
Assert.AreEqual(quantity, mainDish.Quantity);
Assert.AreEqual(1, mainDish.SecondRank);
Assert.AreEqual(DishRanks.MainDishRanks[mainDishType], mainDish.ThirdRank);
}
public void OrderTests_SortOrder()
{
Order order = new Order();
string name = "Spring Chicken";
int quantity = 2;
int dinerSerialNumber = 1;
eMainDish mainDishType = eMainDish.SpringChicken;
MainDish mainDish2 = InitializeDishes.InitializeMainDish(name, quantity, dinerSerialNumber, mainDishType);
order.Dishes.Add(mainDish2);
name = "Chicken Nuggets";
quantity = 2;
dinerSerialNumber = 1;
eAppetizer appetizerType = eAppetizer.ChickenNuggets;
Appetizer appetizer = InitializeDishes.InitializeAppetizer(name, quantity, dinerSerialNumber, appetizerType);
order.Dishes.Add(appetizer);
name = "Schnitzel";
quantity = 2;
dinerSerialNumber = 1;
mainDishType = eMainDish.Schnitzel;
MainDish mainDish = InitializeDishes.InitializeMainDish(name, quantity, dinerSerialNumber, mainDishType);
order.Dishes.Add(mainDish);
name = "Chicken Skewers";
quantity = 2;
dinerSerialNumber = 1;
appetizerType = eAppetizer.ChickenSkewers;
Appetizer appetizer2 = InitializeDishes.InitializeAppetizer(name, quantity, dinerSerialNumber, appetizerType);
order.Dishes.Add(appetizer2);
order.SortOrder();
Assert.AreEqual(order.Dishes[0].Name, appetizer.Name);
Assert.AreEqual(order.Dishes[1].Name, appetizer2.Name);
Assert.AreEqual(order.Dishes[2].Name, mainDish.Name);
Assert.AreEqual(order.Dishes[3].Name, mainDish2.Name);
}
public string Select(MainDish mainDish)
{
try
{
// UPDATE dbo.MainDish SET Name = 'ChickenBreast', Price = 42 WHERE Price = 42
string cmText = "SELECT * FROM dbo.MainDish WHERE Price = @Price";
SqlCommand command = new SqlCommand(cmText, SqlConnection);
command.Parameters.AddWithValue("@Price", mainDish.Price);
//command.Parameters.AddWithValue("@Name", mainDish.Name);
//command.Parameters.AddWithValue("@OldPrice", mainDish.Price);
//command.Parameters.AddWithValue("@Price", 70);
SqlConnection.Open();
SqlDataReader reader = command.ExecuteReader();
string name = null;
if (reader.Read())
{
name = reader["Name"].ToString();
}
else
{
throw new Exception($"Name with price '{mainDish.Price}' was not found ");
}
return(name);
}
catch (Exception e)
{
throw new Exception($"Update failed on exeption: {e}");
}
finally
{
if (SqlConnection != null)
{
SqlConnection.Close();
}
}
}
public static void Main(string[] args)
{
Product product = new Product("plod", 2);
Beverage beverage = new Beverage("Vodka", 3.5m, 100);
HotBeverage hotBeverage = new HotBeverage("bulyon", 0.5m, 250);
Coffee coffee = new Coffee("Lavazza", 70);
Tea tea = new Tea("Jasmine", 3.5m, 200);
ColdBeverage coldBeverage = new ColdBeverage("Juice", 2.5m, 250);
Food food = new Food("pasta", 4.5m, 250);
MainDish mainDish = new MainDish("Bob", 3, 250);
Fish fish = new Fish("Cipura", 6);
Dessert dessert = new Dessert("Kompot", 2, 500, 300);
Cake cake = new Cake("Nedlya");
Starter starter = new Starter("Tarator", 3.5m, 300);
Starter soup = new Starter("Angel", 1.33m, 500);
}
public void Insert(MainDish mainDish)
{
try
{
string cmText = "INSERT INTO dbo.MainDish(Name, Price) VALUES(@Name, @Price)";
SqlCommand command = new SqlCommand(cmText, SqlConnection);
command.Parameters.AddWithValue("@Name", mainDish.Name);
command.Parameters.AddWithValue("@Price", mainDish.Price);
SqlConnection.Open();
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw new Exception($"Insert failed on exeption: {e}");
}
finally
{
if (SqlConnection != null)
{
SqlConnection.Close();
}
}
}
