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