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("Не удалось добавить процедуру!");
}
}
}
