public Ref_ProceduresForm(Ref_Procedures p) { InitializeComponent(); this.ref_proc = p; bd = new Registration_patientsEntities2(); //bd = new Registration_patientsEntities(); comboBoxProced.DataSource = null; bd.Procedures.Load(); comboBoxProced.DataSource = bd.Procedures.Local.ToList(); comboBoxProced.DisplayMember = "Name_proced"; comboBoxProced.ValueMember = "Id"; comboBoxPatient.DataSource = null; bd.Card_Patients.Load(); comboBoxPatient.DataSource = bd.Card_Patients.Local.ToList(); comboBoxPatient.DisplayMember = "Surname"; comboBoxPatient.ValueMember = "Id"; comboBoxTherapist.DataSource = null; bd.Therapists.Load(); comboBoxTherapist.DataSource = bd.Therapists.Local.ToList(); comboBoxTherapist.DisplayMember = "Surname"; comboBoxTherapist.ValueMember = "Id"; dateTimePickerDate.Value = DateTime.Now.Date; }
private void удалитьПроцедуруToolStripMenuItem1_Click(object sender, EventArgs e) { if (dataGridViewMain.SelectedRows.Count == 1) { int index = dataGridViewMain.SelectedRows[0].Index; int Id = 0; bool converted = Int32.TryParse(dataGridViewMain[0, index].Value.ToString(), out Id); if (converted == false) { return; } ref_procedure = bd.Ref_Procedures.Find(Id); bd.Ref_Procedures.Remove(ref_procedure); bd.SaveChanges(); dataGridViewMain.Update(); dataGridViewMain.Refresh(); MessageBox.Show("Обьект удален!"); } else { MessageBox.Show("Не удалось удалить данные!"); } }
private void добавитьПроцедуруToolStripMenuItem1_Click(object sender, EventArgs e) { bd.Ref_Procedures.Load(); ref_procedure = new Ref_Procedures(); Ref_ProceduresForm pr = new Ref_ProceduresForm(ref_procedure); if (pr.ShowDialog() == DialogResult.OK) { Ref_Procedures tmp = bd.Ref_Procedures.Local.Where(x => x.Id_proced == ref_procedure.Id_proced && x.Count_proced == ref_procedure.Count_proced && x.Id_Patient == ref_procedure.Id_Patient && x.Id_Therapist == ref_procedure.Id_Therapist && x.Date_proc == ref_procedure.Date_proc).FirstOrDefault(); if (tmp == null) { bd.Ref_Procedures.Add(ref_procedure); bd.SaveChanges(); MessageBox.Show("Процедура успешно добавлена!"); } else { MessageBox.Show("Не удалось добавить процедуру!"); } } }