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; }