private void Add_Button(object sender, EventArgs e)
{
if (textBox2.Text.Equals(""))
{
MessageBox.Show("Fill all fields");
}
else
{
PeripheralDevice peripheral = new PeripheralDevice();
peripheral.status = comboBox4.Text;
peripheral.name = textBox2.Text;
var val = int.Parse(comboBox1.SelectedValue.ToString());
peripheral.manufacturer = db.Manufacturers.Where(s => s.ManufacturerId == val).FirstOrDefault <Manufacturer>();
var val1 = int.Parse(comboBox2.SelectedValue.ToString());
Project1.Type t = db.Types.Where(s => s.TypeId == val1).FirstOrDefault <Type>();
peripheral.TypeId = t.TypeId;
var val2 = int.Parse(comboBox3.SelectedValue.ToString());
peripheral.departament = db.Departaments.Where(s => s.DepartamentId == val2).FirstOrDefault <Departament>();
var val3 = int.Parse(comboBox5.SelectedValue.ToString());
peripheral.computer = db.Computers.Where(s => s.ComputerId == val3).FirstOrDefault <Computer>();
db.PeripheralDevices.Add(peripheral);
db.SaveChanges();
this.Close();
}
}
private void Delete(object sender, EventArgs e)
{
switch (Tabform.SelectedIndex)
{
case 0:
int index = dataGridView1.SelectedRows[0].Index;
int id = 0;
Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
PeripheralDevice player = db.PeripheralDevices.Find(id);
db.PeripheralDevices.Remove(player);
db.SaveChanges();
UpdatePD();
break;
case 1:
int index1 = dataGridView2.SelectedRows[0].Index;
int id1 = 0;
Int32.TryParse(dataGridView2[0, index1].Value.ToString(), out id1);
Computer player1 = db.Computers.Find(id1);
db.Computers.Remove(player1);
db.SaveChanges();
UpdateComp();
break;
case 2:
int index2 = dataGridView3.SelectedRows[0].Index;
int id2 = 0;
Int32.TryParse(dataGridView3[0, index2].Value.ToString(), out id2);
Employee player2 = db.Employees.Find(id2);
db.Employees.Remove(player2);
db.SaveChanges();
UpdateEmployee();
break;
}
}
private void Edit(object sender, EventArgs e)
{
switch (Tabform.SelectedIndex)
{
case 0:
int index = dataGridView1.SelectedRows[0].Index;
int id = 0;
Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
PeripheralDevice player = db.PeripheralDevices.Find(id);
Redit plForm = new Redit();
plForm.comboBox4.SelectedItem = player.status;
plForm.comboBox1.SelectedValue = player.ManufacturerId;
plForm.textBox2.Text = player.name;
plForm.comboBox2.SelectedValue = player.TypeId;
plForm.comboBox3.SelectedValue = player.DepartamentId;
plForm.comboBox5.SelectedValue = player.ComputerId;
DialogResult result = plForm.ShowDialog(this);
if (result == DialogResult.Cancel)
{
return;
}
player.status = plForm.comboBox4.SelectedItem.ToString();
player.name = plForm.textBox2.Text;
var val = int.Parse(plForm.comboBox1.SelectedValue.ToString());
player.manufacturer = db.Manufacturers.Where(s => s.ManufacturerId == val).FirstOrDefault <Manufacturer>();
var val1 = int.Parse(plForm.comboBox2.SelectedValue.ToString());
player.type = db.Types.Where(s => s.TypeId == val1).FirstOrDefault <Type>();
var val12 = int.Parse(plForm.comboBox3.SelectedValue.ToString());
player.departament = db.Departaments.Where(s => s.DepartamentId == val12).FirstOrDefault <Departament>();
var val3 = int.Parse(plForm.comboBox5.SelectedValue.ToString());
player.computer = db.Computers.Where(s => s.ComputerId == val3).FirstOrDefault <Computer>();
db.SaveChanges();
UpdatePD();
MessageBox.Show("Объект обновлен");
break;
case 1:
int index1 = dataGridView2.SelectedRows[0].Index;
int id1 = 0;
Int32.TryParse(dataGridView2[0, index1].Value.ToString(), out id1);
Computer player1 = db.Computers.Find(id1);
CEdit plForm1 = new CEdit();
plForm1.comboBox4.SelectedItem = player1.status;
plForm1.comboBox1.SelectedValue = player1.MotherboardId;
plForm1.comboBox2.SelectedValue = player1.HddId;
plForm1.comboBox3.SelectedValue = player1.CpuId;
DialogResult result1 = plForm1.ShowDialog(this);
if (result1 == DialogResult.Cancel)
{
return;
}
player1.status = plForm1.comboBox4.SelectedItem.ToString();
var val5 = int.Parse(plForm1.comboBox1.SelectedValue.ToString());
player1.motherboard = db.Motherboards.Where(s => s.MotherboardId == val5).FirstOrDefault <Motherboard>();
var val6 = int.Parse(plForm1.comboBox2.SelectedValue.ToString());
player1.hdd = db.HDDs.Where(s => s.HddId == val6).FirstOrDefault <HDD>();
var val7 = int.Parse(plForm1.comboBox3.SelectedValue.ToString());
player1.cpu = db.CPUs.Where(s => s.CpuId == val7).FirstOrDefault <CPU>();
db.SaveChanges();
UpdateComp();
MessageBox.Show("Объект обновлен");
break;
case 2:
int index2 = dataGridView3.SelectedRows[0].Index;
int id2 = 0;
Int32.TryParse(dataGridView3[0, index2].Value.ToString(), out id2);
Employee player2 = db.Employees.Find(id2);
Eedit plForm2 = new Eedit();
plForm2.textBox1.Text = player2.fullName;
plForm2.textBox2.Text = player2.position;
plForm2.comboBox1.SelectedValue = player2.DepartamentId;
plForm2.comboBox2.SelectedValue = player2.ComputerId;
DialogResult result2 = plForm2.ShowDialog(this);
if (result2 == DialogResult.Cancel)
{
return;
}
player2.fullName = plForm2.textBox1.Text;
player2.position = plForm2.textBox2.Text;
var val8 = int.Parse(plForm2.comboBox1.SelectedValue.ToString());
player2.departament = db.Departaments.Where(s => s.DepartamentId == val8).FirstOrDefault <Departament>();
var val9 = int.Parse(plForm2.comboBox2.SelectedValue.ToString());
player2.computer = db.Computers.Where(s => s.ComputerId == val9).FirstOrDefault <Computer>();
db.SaveChanges();
UpdateEmployee();
MessageBox.Show("Объект обновлен");
break;
}
}
private void Delete(object sender, EventArgs e)
{
switch (Tabform.SelectedIndex)
{
case 0:
int num = 0;
int id = 0;
bool scan = true;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Selected == true)
{
Int32.TryParse(dataGridView1[0, i].Value.ToString(), out id);
PeripheralDevice player = db.PeripheralDevices.Find(id);
db.PeripheralDevices.Remove(player);
num++;
scan = false;
}
}
db.SaveChanges();
UpdatePD();
if (scan == true)
{
MessageBox.Show("Надо выбрать строку полностью");
}
if (scan == false)
{
MessageBox.Show("Удалено:" + num);
}
break;
case 1:
num = 0;
int id1 = 0;
scan = true;
int sel = 0;
for (int i = 0; i < dataGridView2.RowCount; i++)
{
if (dataGridView2.Rows[i].Selected == true)
{
sel++;
Int32.TryParse(dataGridView2[0, i].Value.ToString(), out id1);
Computer player1 = db.Computers.Find(id1);
if (db.Employees.Where(s => s.ComputerId == player1.ComputerId).FirstOrDefault <Employee>() != null || db.PeripheralDevices.Where(s => s.ComputerId == player1.ComputerId).FirstOrDefault <PeripheralDevice>() != null)
{
scan = false;
}
}
}
if (sel == 0)
{
MessageBox.Show("Надо выбрать строку полностью");
}
else if (scan == false)
{
MessageBox.Show("К этому компьютеру уже назначен пользователь или периферия");
}
else if (scan == true)
{
for (int i = 0; i < dataGridView2.RowCount; i++)
{
if (dataGridView2.Rows[i].Selected == true)
{
Int32.TryParse(dataGridView2[0, i].Value.ToString(), out id1);
Computer player1 = db.Computers.Find(id1);
db.Computers.Remove(player1); num++;
}
}
db.SaveChanges();
UpdateComp();
MessageBox.Show("Удалено:" + num);
}
break;
case 2:
num = 0;
scan = true;
int id2 = 0;
for (int i = 0; i < dataGridView3.RowCount; i++)
{
if (dataGridView3.Rows[i].Selected == true)
{
Int32.TryParse(dataGridView3[0, i].Value.ToString(), out id2);
Employee player2 = db.Employees.Find(id2);
db.Employees.Remove(player2);
num++;
scan = false;
}
}
db.SaveChanges();
UpdateEmployee();
if (scan == true)
{
MessageBox.Show("Надо выбрать строку полностью");
}
if (scan == false)
{
MessageBox.Show("Удалено:" + num);
}
break;
}
}
