public Procedure(procedure_schedule procedure_schedule) { InitializeComponent(); button1.Text = "Изменить"; this.procedure_schedule = procedure_schedule; dataView.ShowClientListForEdit(comboBox1, procedure_schedule); dataView.ShowServiceListForEdit(comboBox2, procedure_schedule); dateTimePicker1.MinDate = DateTime.Now.AddDays(1); dateTimePicker1.MaxDate = DateTime.Now.AddDays(5); i++; }
public void removeProcedure(procedure_schedule procedure_schedule) { try { procedure_schedule procedure_schedule1; using (var cn = new Model1()) { procedure_schedule1 = cn.procedure_schedule.Where(w => w.id_procedure == procedure_schedule.id_procedure).FirstOrDefault(); cn.procedure_schedule.Remove(procedure_schedule1); cn.SaveChanges(); } } catch { MessageBox.Show("Невозможно произвести удаление"); } }
private void button2_Click(object sender, EventArgs e)// Изменить { if (comboBox1.SelectedIndex == 0) { List <client> query = (from client in db.client select client).ToList(); client item = query.First(w => w.id_client.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); EditUser editUser = new EditUser(item); editUser.Owner = this; editUser.Show(); } if ((comboBox1.SelectedIndex == 1) || (comboBox1.SelectedIndex == 2)) { List <employee> query = (from employee in db.employee select employee).ToList(); employee item = query.First(w => w.id_employee.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); EditUser editUser = new EditUser(item); editUser.Owner = this; editUser.Show(); } if (comboBox1.SelectedIndex == 3) { List <service> query = (from service in db.service select service).ToList(); service item = query.First(w => w.name.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); EditService editUser = new EditService(item); editUser.Owner = this; editUser.Show(); } if (comboBox1.SelectedIndex == 4) { List <procedure_schedule> query = (from procedure_schedule in db.procedure_schedule select procedure_schedule).ToList(); procedure_schedule item = query.First(w => w.date.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); Procedure procedure = new Procedure(item); procedure.Show(); } }
public void ShowServiceListForEdit(ComboBox comboBox, procedure_schedule procedure_schedule1) { List <string> infoClient = new List <string>(); List <service> services = (from service in db.service select service).ToList(); string s = "не удалось"; var query = (from service in services select service.name).Distinct(); foreach (string r in query) { infoClient.Add(r); } foreach (string w in infoClient) { comboBox.Items.Add(w); } service service1 = db.service.SingleOrDefault(w => w.id_service == procedure_schedule1.id_service); comboBox.SelectedItem = service1.name; }
public void ShowClientListForEdit(ComboBox comboBox, procedure_schedule procedure_schedule1) { List <string> infoClient = new List <string>(); List <service> services = (from service in db.service select service).ToList(); string s = "не удалось"; var query = (from service in services join procedure_schedule in db.procedure_schedule on service.id_service equals procedure_schedule.id_service join client in db.client on procedure_schedule.id_client equals client.id_client where procedure_schedule.id_procedure == procedure_schedule1.id_procedure select s = (client.surname + " " + client.name + " " + client.lastlename)).Distinct(); foreach (string r in query) { infoClient.Add(r); } foreach (string w in infoClient) { comboBox.Items.Add(w); } }
private void button3_Click(object sender, EventArgs e)// remove { RemoveInfo removeInfo = new RemoveInfo(); switch (comboBox1.SelectedIndex) { case 0: { List <client> query = (from client in db.client select client).ToList(); client item = query.First(w => w.id_client.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); removeInfo.removeClient(item); dw.ShowInfoToAdmin(dataGridView1, comboBox1); } break; case 1: { List <employee> query = (from employee in db.employee select employee).ToList(); employee item = query.First(w => w.id_employee.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); if (admin == item) { MessageBox.Show("Нельзя удалить самого себя"); } else { removeInfo.removeemployee(item.id_employee); dw.ShowInfoToAdmin(dataGridView1, comboBox1); } } break; case 2: { List <employee> query = (from employee in db.employee select employee).ToList(); employee item = query.First(w => w.id_employee.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); if (admin == item) { MessageBox.Show("Нельзя удалить самого себя"); } else { removeInfo.removeemployee(item.id_employee); dw.ShowInfoToAdmin(dataGridView1, comboBox1); } } break; case 3: { List <service> query = (from service in db.service select service).ToList(); service item = query.First(w => w.name.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); removeInfo.removeService(item); dw.ShowInfoToAdmin(dataGridView1, comboBox1); } break; case 4: { List <procedure_schedule> query = (from procedure_schedule in db.procedure_schedule select procedure_schedule).ToList(); procedure_schedule item = query.First(w => w.date.ToString() == dataGridView1.SelectedCells[0].OwningRow.Cells[0].Value.ToString()); removeInfo.removeProcedure(item); dw.ShowInfoToAdmin(dataGridView1, comboBox1); } break; } }
public EditInfo(procedure_schedule procedure_Schedule, Procedure procedure) { this.procedure_Schedule = procedure_Schedule; this.procedure = procedure; }