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 Add_Button(object sender, EventArgs e) { Computer computer = new Computer(); computer.status = comboBox4.Text; var val = int.Parse(comboBox1.SelectedValue.ToString()); computer.motherboard = db.Motherboards.Where( s => s.MotherboardId == val ).FirstOrDefault <Motherboard>(); var val1 = int.Parse(comboBox2.SelectedValue.ToString()); computer.hdd = db.HDDs.Where( s => s.HddId == val1 ).FirstOrDefault <HDD>(); var val2 = int.Parse(comboBox3.SelectedValue.ToString()); computer.cpu = db.CPUs.Where( s => s.CpuId == val2 ).FirstOrDefault <CPU>(); db.Computers.Add(computer); db.SaveChanges(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { Manufacturer manufacturer = new Manufacturer(); manufacturer.ManufacturerName = textBox1.Text; db.Manufacturers.Add(manufacturer); db.SaveChanges(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { using (SampleContext db = new SampleContext()) { Departament departament = new Departament(); departament.DepartamentName = textBox1.Text; db.Departaments.Add(departament); db.SaveChanges(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { Type type = new Type { TypeName = textBox1.Text }; db.Types.Add(type); db.SaveChanges(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { using (SampleContext db = new SampleContext()) { Administrator administrator = new Administrator(); administrator.Login = textBox1.Text; administrator.Password = textBox2.Text; db.Administrators.Add(administrator); db.SaveChanges(); } }
private void button1_Click(object sender, EventArgs e) { Employee employee = new Employee(); employee.fullName = textBox1.Text; employee.position = textBox2.Text; employee.departament = db.Departaments.Find(comboBox1.SelectedValue); employee.computer = db.Computers.Find(comboBox2.SelectedValue); db.Employees.Add(employee); 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 button1_Click(object sender, EventArgs e) { CPU cpu = new CPU(); var val = int.Parse(comboBox1.SelectedValue.ToString()); cpu.manufacturer = db.Manufacturers.Where( s => s.ManufacturerId == val ).FirstOrDefault <Manufacturer>(); cpu.CpuName = textBox1.Text; cpu.rate = textBox2.Text; db.CPUs.Add(cpu); db.SaveChanges(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { HDD hdd = new HDD(); var val = int.Parse(comboBox1.SelectedValue.ToString()); hdd.manufacturer = db.Manufacturers.Where( s => s.ManufacturerId == val ).FirstOrDefault <Manufacturer>(); hdd.capacity = Convert.ToInt32(textBox1.Text); hdd.HddName = textBox2.Text; db.HDDs.Add(hdd); db.SaveChanges(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("Fill all fields"); } else { Manufacturer manufacturer = new Manufacturer(); manufacturer.ManufacturerName = textBox1.Text; db.Manufacturers.Add(manufacturer); db.SaveChanges(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { Motherboard motherboard = new Motherboard(); motherboard.MotherboardName = textBox1.Text; var val = int.Parse(comboBox1.SelectedValue.ToString()); motherboard.manufacturer = db.Manufacturers.Where( s => s.ManufacturerId == val ).FirstOrDefault <Manufacturer>(); db.Motherboards.Add(motherboard); db.SaveChanges(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("Fill all fields"); } else { Type type = new Type { TypeName = textBox1.Text }; db.Types.Add(type); db.SaveChanges(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("") || textBox2.Text.Equals("")) { MessageBox.Show("Fill all fields"); } else { Employee employee = new Employee(); employee.fullName = textBox1.Text; employee.position = textBox2.Text; employee.departament = db.Departaments.Find(comboBox1.SelectedValue); employee.computer = db.Computers.Find(comboBox2.SelectedValue); db.Employees.Add(employee); db.SaveChanges(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("")) { MessageBox.Show("Fill all fields"); } else { using (SampleContext db = new SampleContext()) { Departament departament = new Departament(); departament.DepartamentName = textBox1.Text; db.Departaments.Add(departament); db.SaveChanges(); this.Close(); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("") || textBox2.Text.Equals("")) { MessageBox.Show("Fill all fields"); } else { using (SampleContext db = new SampleContext()) { Administrator administrator = new Administrator(); administrator.Login = textBox1.Text; administrator.Password = textBox2.Text; db.Administrators.Add(administrator); db.SaveChanges(); this.Close(); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Equals("") || textBox2.Text.Equals("")) { MessageBox.Show("Fill all fields"); } else { CPU cpu = new CPU(); var val = int.Parse(comboBox1.SelectedValue.ToString()); cpu.manufacturer = db.Manufacturers.Where( s => s.ManufacturerId == val ).FirstOrDefault <Manufacturer>(); cpu.CpuName = textBox1.Text; cpu.rate = textBox2.Text; db.CPUs.Add(cpu); db.SaveChanges(); this.Close(); } }
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; } }