public int addMenu(Menu menu)
{
connector.openConnection();
int changes = 0;
String IsSpecial = menu.IsSpecialMenu ? "TRUE" : "FALSE";
foreach (String dishName in menu.Menu1)
{
changes += connector.executeNonQuery("INSERT INTO Menu (ID_Dish, Date_Menu, Is_Special) SELECT d.ID_Dish, \"" + menu.MenuDate.ToShortDateString() + "\", " + IsSpecial + " FROM Dishes d WHERE Name_Dish = \"" + dishName + "\"");
}
foreach (String dishName in menu.Menu2)
{
changes += connector.executeNonQuery("INSERT INTO Menu (ID_Dish, Date_Menu, Is_Special) SELECT d.ID_Dish, \"" + menu.MenuDate.ToShortDateString() + "\", " + IsSpecial + " FROM Dishes d WHERE Name_Dish = \"" + dishName + "\"");
}
foreach (String dishName in menu.Menu3)
{
changes += connector.executeNonQuery("INSERT INTO Menu (ID_Dish, Date_Menu, Is_Special) SELECT d.ID_Dish, \"" + menu.MenuDate.ToShortDateString() + "\", " + IsSpecial + " FROM Dishes d WHERE Name_Dish = \"" + dishName + "\"");
}
connector.closeConnection();
return changes;
}
public TRPO.Structures.Menu getCreatedMenu()
{
TRPO.Structures.Menu m;
if (!complexDishCheckbox.Checked)
{
List<String> menu1 = new List<String>();
List<String> menu2 = new List<String>();
List<String> menu3 = new List<String>();
foreach (DataGridViewRow r in dataGridView1.Rows)
{
menu1.Add(r.Cells[0].Value.ToString());
}
foreach (DataGridViewRow r in dataGridView2.Rows)
{
menu2.Add(r.Cells[0].Value.ToString());
}
foreach (DataGridViewRow r in dataGridView3.Rows)
{
menu3.Add(r.Cells[0].Value.ToString());
}
m = new TRPO.Structures.Menu(menu1, menu2, menu3, false, dateTimePicker.Value);
}
else
{
List<String> menu1 = new List<String>();
List<String> menu2 = new List<String>();
List<String> menu3 = new List<String>();
foreach (DataGridViewRow r in dataGridView4.Rows)
{
switch (r.Cells[1].Value.ToString())
{
case "Первое":
menu1.Add(r.Cells[0].Value.ToString());
break;
case "Второе":
menu2.Add(r.Cells[0].Value.ToString());
break;
case "Третье":
menu3.Add(r.Cells[0].Value.ToString());
break;
}
}
m = new TRPO.Structures.Menu(menu1, menu2, menu3, true, dateTimePicker.Value);
}
return m;
}
