private void del_btn_Click(object sender, EventArgs e) { ClassMenu cm = (ClassMenu)data_menu_list.SelectedItem; List <ClassMenu> cmlist = DBConnection.Entities.ClassMenus.ToList(); if (cm == null) { MessageBox.Show("Выберите меню для удаления!"); } else { if (cm.Class.Num < 5) { foreach (var item in cmlist) { if (item.Class.Num < 5) { DBConnection.Entities.ClassMenus.Remove(item); DBConnection.Entities.SaveChanges(); } } } if (cm.Class.Num < 10 && cm.Class.Num > 4) { foreach (var item in cmlist) { if (item.Class.Num < 10 && item.Class.Num > 4) { DBConnection.Entities.ClassMenus.Remove(item); DBConnection.Entities.SaveChanges(); } } } if (cm.Class.Num > 9) { foreach (var item in cmlist) { if (item.Class.Num > 9) { DBConnection.Entities.ClassMenus.Remove(item); DBConnection.Entities.SaveChanges(); } } } MessageBox.Show("Меню удалено!"); this.Fill(); } }
private void Detail_btn_Click(object sender, EventArgs e) { ClassMenu obj = (ClassMenu)data_menu_list.SelectedItem; using (var f = new CompiledMenuForm(obj)) { var res = f.ShowDialog(); if (res == DialogResult.OK) { this.classm = obj; this.DialogResult = DialogResult.OK; this.Close(); } } this.Fill(); }
public CompiledMenuForm(ClassMenu cm) { InitializeComponent(); List <ClassMenu> cl = DBConnection.Entities.ClassMenus.ToList(); List <Dish> d = DBConnection.Entities.Dishes.ToList(); foreach (ClassMenu item in cl) { if (cm.ClassId == item.ClassId) { foreach (Dish val in d) { if (val.DishId == item.IdDish) { if (val.MealTime.ToLower() == "завтрак") { break_dish_list.Items.Add(val); break_sum += Convert.ToDouble(val.Calories) * Convert.ToDouble(item.Gramm / 100); } else if (val.MealTime.ToLower() == "обед") { din_dish_list.Items.Add(val); din_sum += Convert.ToDouble(val.Calories) * Convert.ToDouble(item.Gramm / 100); } else if (val.MealTime.ToLower() == "полдник") { aft_dish_list.Items.Add(val); aft_sum += Convert.ToDouble(val.Calories) * Convert.ToDouble(item.Gramm / 100); } } } } } rec_aft_kal_lbl.Text = aft_sum.ToString(); rec_break_kal_lbl.Text = break_sum.ToString(); rec_din_kal_lbl.Text = din_sum.ToString(); }
private void save_all_btn_Click(object sender, EventArgs e) { ClassMenu cm = new ClassMenu(); List <Class> cli = DBConnection.Entities.Classes.ToList(); List <DishMealTime> dmt = new List <DishMealTime>(); foreach (DishMealTime d in break_dish_list.Items) { dmt.Add(d); } foreach (DishMealTime d in din_dish_list.Items) { dmt.Add(d); } foreach (DishMealTime d in aft_dish_list.Items) { dmt.Add(d); } cm.Date = menu_date.Value; foreach (DishMealTime d in dmt) { cm.IdDishMenu = d.Id; if (first_call_tlstr.Checked || second_call_tlstr.Checked || third_call_tlstr.Checked || four_call_tlstr.Checked) { foreach (Class c in cli) { if (c.Num == 1 || c.Num == 2 || c.Num == 3 || c.Num == 4) { cm.ClassId = c.ClassId; cli.Remove(c); break; } } } else if (fifth_call_tlstr.Checked || six_call_tlstr.Checked || seventh_call_tlstr.Checked || eighth_call_tlstr.Checked || ninth_call_tlstr.Checked) { foreach (Class c in cli) { if (c.Num == 5 || c.Num == 6 || c.Num == 7 || c.Num == 8 || c.Num == 9) { cm.ClassId = c.ClassId; cli.Remove(c); break; } } } else if (tenth_call_tlstr.Checked || eleventh_call_tlstr.Checked) { foreach (Class c in cli) { if (c.Num == 10 || c.Num == 11) { cm.ClassId = c.ClassId; cli.Remove(c); break; } } } DBConnection.Entities.ClassMenus.Add(cm); DBConnection.Entities.SaveChanges(); } MessageBox.Show("Меню успешно сохранено!"); }
private void choose_comp_menu_btn_Click(object sender, EventArgs e) { using (var f = new ChoiceMenuForm()) { var res = f.ShowDialog(); if (res == DialogResult.OK) { break_dish_list.Items.Clear(); din_dish_list.Items.Clear(); aft_dish_list.Items.Clear(); if (f.classm == null) { this.Fill(); } else { ClassMenu cm = f.classm; List <ClassMenu> cl = DBConnection.Entities.ClassMenus.ToList(); List <Dish> d = DBConnection.Entities.Dishes.ToList(); menu_date.Value = cm.Date; foreach (ClassMenu item in cl) { if (cm.ClassId == item.ClassId) { foreach (Dish val in d) { if (val.DishId == item.IdDish) { DishGram dg = new DishGram(); if (val.MealTime.ToLower() == "завтрак") { dg.d = val; dg.gramm = item.Gramm; break_dish_list.Items.Add(dg); break_norm += val.Calories * Convert.ToDouble(item.Gramm / 100); car += val.Carbohydrates * Convert.ToDouble(item.Gramm / 100); fat += val.Fats * Convert.ToDouble(item.Gramm / 100); prot += val.Protein * Convert.ToDouble(item.Gramm / 100); } else if (val.MealTime.ToLower() == "обед") { dg.d = val; dg.gramm = item.Gramm; din_dish_list.Items.Add(dg); din_norm += val.Calories * Convert.ToDouble(item.Gramm / 100); car += val.Carbohydrates * Convert.ToDouble(item.Gramm / 100); fat += val.Fats * Convert.ToDouble(item.Gramm / 100); prot += val.Protein * Convert.ToDouble(item.Gramm / 100); } else if (val.MealTime.ToLower() == "полдник") { dg.d = val; dg.gramm = item.Gramm; aft_dish_list.Items.Add(dg); aft_norm += val.Calories * Convert.ToDouble(item.Gramm / 100); car += val.Carbohydrates * Convert.ToDouble(item.Gramm / 100); fat += val.Fats * Convert.ToDouble(item.Gramm / 100); prot += val.Protein * Convert.ToDouble(item.Gramm / 100); } } } } } rec_aft_kal_lbl.Text = aft_norm.ToString(); rec_break_kal_lbl.Text = break_norm.ToString(); rec_din_kal_lbl.Text = din_norm.ToString(); typed_carbohydrates_lbl.Text = car.ToString(); typed_fats_lbl.Text = fat.ToString(); typed_proteins_lbl.Text = prot.ToString(); earn_day_kal_lbl.Text = Convert.ToString(sum = break_norm + aft_norm + din_norm); } } } this.Fill(); }
private void save_all_btn_Click(object sender, EventArgs e) { ClassMenu cm = new ClassMenu(); List <Class> cli = DBConnection.Entities.Classes.ToList(); List <DishGram> clm = new List <DishGram>(); foreach (DishGram d in break_dish_list.Items) { clm.Add(d); } foreach (DishGram d in din_dish_list.Items) { clm.Add(d); } foreach (DishGram d in aft_dish_list.Items) { clm.Add(d); } cm.Date = menu_date.Value; foreach (Class c in cli) { if (first_call_tlstr.Checked) { if (c.Num < 5) { cm.ClassId = c.ClassId; foreach (var d in clm) { foreach (DishGram item in dg) { if (d.d.DishId == item.d.DishId) { cm.Gramm = item.gramm; cm.IdDish = d.d.DishId; break; } } DBConnection.Entities.ClassMenus.Add(cm); DBConnection.Entities.SaveChanges(); } } } else if (second_call_tlstr.Checked) { if (c.Num > 4 && c.Num < 10) { cm.ClassId = c.ClassId; foreach (var d in clm) { foreach (DishGram item in dg) { if (d.d.DishId == item.d.DishId) { cm.Gramm = item.gramm; cm.IdDish = d.d.DishId; break; } } DBConnection.Entities.ClassMenus.Add(cm); DBConnection.Entities.SaveChanges(); } } } else if (third_call_tlstr.Checked) { if (c.Num > 9) { cm.ClassId = c.ClassId; foreach (var d in clm) { foreach (DishGram item in dg) { if (d.d.DishId == item.d.DishId) { cm.Gramm = item.gramm; cm.IdDish = d.d.DishId; break; } } DBConnection.Entities.ClassMenus.Add(cm); DBConnection.Entities.SaveChanges(); } } } } MessageBox.Show("Меню успешно сохранено!"); }
private void Choose_btn_Click(object sender, EventArgs e) { this.classm = (ClassMenu)data_menu_list.SelectedItem; this.DialogResult = DialogResult.OK; this.Close(); }