public bool Delete(string id) { PopupNotifier popup = new PopupNotifier(); popup.TitleText = "Ошибка"; popup.BodyColor = Color.LightGray; gr691_invert db = new gr691_invert(); try { int num = Convert.ToInt32(id); var d_e = db.Equipment.Where(i => i.id == num).FirstOrDefault(); if (d_e == null) { popup.ContentText = "Вы не выбрали строку"; popup.Popup(); return(false); } else { db.Equipment.Remove(d_e); db.SaveChanges(); } } catch { popup.ContentText = "ОШИБКА"; popup.Popup(); return(false); } return(true); }
public Invert_Cabinet() { InitializeComponent(); db = new gr691_invert(); List <Equipment> us = db.Database.SqlQuery <Equipment>("Select*from Equipment Where indef = 'Монитор'").ToList(); //Monitor_Count.Content = Convert.ToString(us.Count); us = db.Database.SqlQuery <Equipment>("Select*from Equipment Where indef = 'Стул'").ToList(); us = db.Database.SqlQuery <Equipment>("Select*from Equipment Where indef = 'Стол'").ToList(); Table_Count.Text = Convert.ToString(us.Count); us = db.Database.SqlQuery <Equipment>("Select*from Equipment Where indef = 'Компьютер'").ToList(); List <Equipment> ps = db.Equipment.Where(db => db.indef == "Стул").ToList(); Chair_Count.Text = Convert.ToString(ps.Count); Computer_Case_Count.Text = Convert.ToString(us.Count); Table_Cabinet.ItemsSource = db.Equipment.ToList(); }
public void Cb_Cabinet_1_SelectionChanged(object sender, SelectionChangedEventArgs e) { db = new gr691_invert(); if (Cb_Cabinet_1.SelectedIndex == 0) { Monitor_Count.Text = db.Equipment.Where(w => w.indef == "Монитор").Count().ToString(); Chair_Count.Text = db.Equipment.Where(db => db.indef == "Стул").Count().ToString(); Table_Count.Text = db.Equipment.Where(db => db.indef == "Стол").Count().ToString(); Computer_Case_Count.Text = db.Equipment.Where(db => db.indef == "Компьютер").Count().ToString(); selectedCabinet = "0"; Table_Cabinet.ItemsSource = db.Equipment.ToList(); } else if (Cb_Cabinet_1.SelectedIndex == 1) { Monitor_Count.Text = db.Equipment.Where(db => db.indef == "Монитор" && db.cabinet == "1").Count().ToString(); Chair_Count.Text = db.Equipment.Where(db => db.indef == "Стул" && db.cabinet == "1").Count().ToString(); Table_Count.Text = db.Equipment.Where(db => db.indef == "Стол" && db.cabinet == "1").Count().ToString(); Computer_Case_Count.Text = db.Equipment.Where(db => db.indef == "Компьютер" && db.cabinet == "1").Count().ToString(); selectedCabinet = "1"; Table_Cabinet.ItemsSource = db.Equipment.Where(d => d.cabinet == "1").ToList(); } else if (Cb_Cabinet_1.SelectedIndex == 2) { Monitor_Count.Text = db.Equipment.Where(db => db.indef == "Монитор" && db.cabinet == "2").Count().ToString(); Chair_Count.Text = db.Equipment.Where(db => db.indef == "Стул" && db.cabinet == "2").Count().ToString(); Table_Count.Text = db.Equipment.Where(db => db.indef == "Стол" && db.cabinet == "2").Count().ToString(); Computer_Case_Count.Text = db.Equipment.Where(db => db.indef == "Компьютер" && db.cabinet == "2").Count().ToString(); selectedCabinet = "2"; Table_Cabinet.ItemsSource = db.Equipment.Where(d => d.cabinet == "2").ToList(); } else if (Cb_Cabinet_1.SelectedIndex == 3) { Monitor_Count.Text = db.Equipment.Where(db => db.indef == "Монитор" && db.cabinet == "3").Count().ToString(); Chair_Count.Text = db.Equipment.Where(db => db.indef == "Стул" && db.cabinet == "3").Count().ToString(); Table_Count.Text = db.Equipment.Where(db => db.indef == "Стол" && db.cabinet == "3").Count().ToString(); Computer_Case_Count.Text = db.Equipment.Where(db => db.indef == "Компьютер" && db.cabinet == "3").Count().ToString(); selectedCabinet = "3"; Table_Cabinet.ItemsSource = db.Equipment.Where(d => d.cabinet == "3").ToList(); } }
private void Update(object sender, RoutedEventArgs e) { Equipment equipment = Table_Editing.SelectedItem as Equipment; PopupNotifier popup = new PopupNotifier(); popup.TitleText = "Ошибка"; popup.BodyColor = Color.LightGray; if (Table_Editing.SelectedItem == null) { popup.ContentText = "Вы не выбрали кабинет"; popup.Popup(); return; } db.Equipment.Where(i => i.id == equipment.id).FirstOrDefault(); if (equip.Update(equipment != null ? equipment.id.ToString() : "0", Cb_Equipment.SelectedIndex.ToString(), Cb_Cabinet_2.Text) == true) { gr691_invert db = new gr691_invert(); Cb_Cabinet_2.SelectedIndex = -1; Cb_Equipment.SelectedIndex = -1; Table_Editing.ItemsSource = db.Equipment.ToList(); } }
public bool Add(string equip, string cabin) { PopupNotifier popup = new PopupNotifier(); popup.TitleText = "Ошибка"; popup.BodyColor = Color.LightGray; gr691_invert db = new gr691_invert(); Equipment equipment = new Equipment(); try { var last_id = db.Equipment.Max(f => f.id); if (equip == "") { popup.ContentText = "Вы не выбрали оборудование"; popup.Popup(); return(false); } else if (cabin == "") { popup.ContentText = "Вы не выбрали кабинет"; popup.Popup(); return(false); } switch (Convert.ToInt32(equip)) { case 0: equipment.cabinet = cabin; equipment.indef = "Монитор"; equipment.inv_num = cabin + "MN" + (last_id + 1); db.Equipment.Add(equipment); db.SaveChanges(); break; case 1: equipment.cabinet = cabin; equipment.indef = "Стол"; equipment.inv_num = cabin + "DK" + (last_id + 1); db.Equipment.Add(equipment); db.SaveChanges(); break; case 2: equipment.cabinet = cabin; equipment.indef = "Стул"; equipment.inv_num = cabin + "CR" + (last_id + 1); db.Equipment.Add(equipment); db.SaveChanges(); break; case 3: equipment.cabinet = cabin; equipment.indef = "Компьютер"; equipment.inv_num = cabin + "PC" + (last_id + 1); db.Equipment.Add(equipment); db.SaveChanges(); break; } } catch { popup.ContentText = "ОШИБКА"; popup.Popup(); return(false); } return(true); }
public bool Update(string id, string equip, string cabin) { PopupNotifier popup = new PopupNotifier(); popup.TitleText = "Ошибка"; popup.BodyColor = Color.LightGray; gr691_invert db = new gr691_invert(); try { int num = Convert.ToInt32(id); var u_e = db.Equipment.Where(u => u.id == num).FirstOrDefault(); if (u_e == null) { popup.ContentText = "Вы не выбрали строку"; popup.Popup(); return(false); } else if (equip == "") { popup.ContentText = "Вы не выбрали оборудование"; popup.Popup(); return(false); } else if (cabin == "") { popup.ContentText = "Вы не выбрали кабинет"; popup.Popup(); return(false); } switch (Convert.ToInt32(equip)) { case 0: u_e.cabinet = cabin; u_e.indef = "Монитор"; u_e.inv_num = cabin + "MN" + num; db.SaveChanges(); break; case 1: u_e.cabinet = cabin; u_e.indef = "Стол"; u_e.inv_num = cabin + "DK" + num; db.SaveChanges(); break; case 2: u_e.cabinet = cabin; u_e.indef = "Стул"; u_e.inv_num = cabin + "CR" + num; db.SaveChanges(); break; case 3: u_e.cabinet = cabin; u_e.indef = "Компьютер"; u_e.inv_num = cabin + "PC" + num; db.SaveChanges(); break; } db.SaveChanges(); } catch { popup.ContentText = "ОШИБКА"; popup.Popup(); return(false); } return(true); }
//ЗАГРУЗКА ДАННЫХ В ТАБЛИЦАХ private void Window_Loaded(object sender, RoutedEventArgs e) { db = new gr691_invert(); Table_Editing.ItemsSource = db.Equipment.ToList(); }
public MainWindow() { InitializeComponent(); db = new gr691_invert(); }