private void btnSearch_Click(object sender, EventArgs e) { patient = new Card_Patients(); sick_leave = new Sick_leaves(); ref_analyze = new Ref_Analyzes(); SearchForm f = new SearchForm(patient, sick_leave, ref_analyze); f.ShowDialog(); }
//Registration_patientsEntities bd = null; public SearchForm(Card_Patients p, Sick_leaves s, Ref_Analyzes a) { InitializeComponent(); this.patient = p; this.sick_leave = s; this.analyze = a; bd = new Registration_patientsEntities2(); comboBoxSurname.DataSource = null; comboBoxAdress.DataSource = null; comboBoxCard_num.DataSource = null; comboBoxAnalyz.DataSource = null; }
//Registration_patientsEntities bd = null; public Sick_LeavesForm(Sick_leaves s) { InitializeComponent(); this.sick_leave = s; bd = new Registration_patientsEntities2(); //bd = new Registration_patientsEntities(); comboBoxPatient.DataSource = null; bd.Card_Patients.Load(); comboBoxPatient.DataSource = bd.Card_Patients.Local.ToList(); comboBoxPatient.DisplayMember = "Surname"; comboBoxPatient.ValueMember = "Id"; textBoxPlace.Text = sick_leave.PlaceOfWork; textBoxDiagnos.Text = sick_leave.Diagnosis; bd.Therapists.Load(); comboBoxTherapist.DataSource = bd.Therapists.Local.ToList(); comboBoxTherapist.DisplayMember = "Surname"; comboBoxTherapist.ValueMember = "Id"; dateTimePickerOpen.Value = DateTime.Now.Date; }
private void удалитьБольничныйToolStripMenuItem_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; } sick_leave = bd.Sick_leaves.Find(Id); bd.Sick_leaves.Remove(sick_leave); bd.SaveChanges(); dataGridViewMain.Update(); dataGridViewMain.Refresh(); MessageBox.Show("Обьект удален!"); } else { MessageBox.Show("Не удалось удалить данные!"); } }
private void добавитьБольничныйToolStripMenuItem_Click(object sender, EventArgs e) { bd.Sick_leaves.Load(); sick_leave = new Sick_leaves(); Sick_LeavesForm l = new Sick_LeavesForm(sick_leave); if (l.ShowDialog() == DialogResult.OK) { Sick_leaves tmp = bd.Sick_leaves.Local.Where(x => x.Id_Patient == sick_leave.Id_Patient && x.PlaceOfWork == sick_leave.PlaceOfWork && x.Diagnosis == sick_leave.Diagnosis && x.IsAmbulatory == sick_leave.IsAmbulatory && x.IsStationary == sick_leave.IsStationary && x.Id_Therapist == sick_leave.Id_Therapist && x.Opening_date == sick_leave.Opening_date && x.Closing_date == sick_leave.Closing_date).FirstOrDefault(); if (tmp == null) { bd.Sick_leaves.Add(sick_leave); bd.SaveChanges(); MessageBox.Show("Больничный успешно добавлен!"); } else { MessageBox.Show("Не удалось добавить больничный!"); } } }