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 SearchAnalyze() { if (comboBoxAnalyz.SelectedIndex != -1) { bd = new Registration_patientsEntities2(); int id = Convert.ToInt32(comboBoxAnalyz.SelectedValue); var query = (from res_an in bd.Result_Analyzes join ref_an in bd.Ref_Analyzes on res_an.Id_ref_Analyzes equals ref_an.Id join an in bd.Analyzes on ref_an.Id_Analyze equals an.Id join p in bd.Card_Patients on ref_an.Id_Patient equals p.Id join th in bd.Therapists on ref_an.Id_Therapist equals th.Id where ref_an.Id_Analyze == id select new { FullName_Patient = p.Surname + " " + p.Name + " " + p.Patronymic, Description_Analyze = res_an.Description, FullName_Doctor = th.Surname + " " + th.Name + " " + th.Patronymic, DateOfTest = res_an.Date_res_analyze }).ToList(); dataGridViewSearch.DataSource = null; dataGridViewSearch.Update(); dataGridViewSearch.DataSource = query; } else { MessageBox.Show("Выберите анализ!"); } }
//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; }
private void SearchSurname() { if (comboBoxSurname.SelectedIndex != -1) { bd = new Registration_patientsEntities2(); bd.Card_Patients.Load(); int id = Convert.ToInt32(comboBoxSurname.SelectedValue); var query = bd.Card_Patients.Local.Where(x => x.Id == id).ToList(); dataGridViewSearch.DataSource = null; dataGridViewSearch.DataSource = query; } else { MessageBox.Show("Выберите фамилию!"); } }
private void SearchSickData() { try { bd = new Registration_patientsEntities2(); bd.Sick_leaves.Load(); var query = bd.Sick_leaves.Local.Where(x => x.Opening_date == dateTimePickeSick.Value.Date).ToList(); dataGridViewSearch.DataSource = null; dataGridViewSearch.DataSource = query; dataGridViewSearch.Columns["Card_Patients"].Visible = false; dataGridViewSearch.Columns["Therapists"].Visible = false; } catch (Exception ex) { MessageBox.Show("Error" + ex.Message); } }
private void SearchCard_number() { if (comboBoxCard_num.SelectedIndex != -1) { bd = new Registration_patientsEntities2(); bd.Card_Patients.Load(); int id = Convert.ToInt32(comboBoxCard_num.SelectedValue); var query = bd.Card_Patients.Local.Where(x => x.Id == id).ToList(); dataGridViewSearch.DataSource = null; dataGridViewSearch.DataSource = query; dataGridViewSearch.Columns["Therapists"].Visible = false; } else { MessageBox.Show("Выберите номер карты пациента!"); } }
public PatientsForm(Card_Patients p) { InitializeComponent(); this.patient = p; bd = new Registration_patientsEntities2(); //bd = new Registration_patientsEntities(); textBoxNumCard.Text = patient.Number_Card.ToString(); textBoxSurname.Text = patient.Surname; textBoxName.Text = patient.Name; textBoxPatronymic.Text = patient.Patronymic; textBoxPassropt.Text = patient.Passport; textBoxAdress.Text = patient.Adress; textBoxPhone.Text = patient.Phone_number; dateTimePickerBirthday.Value = DateTime.Now.Date; comboBoxTherapist.DataSource = null; bd.Therapists.Load(); comboBoxTherapist.DataSource = bd.Therapists.Local.ToList(); comboBoxTherapist.DisplayMember = "Surname"; comboBoxTherapist.ValueMember = "Id"; }
//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; }
public Ref_AnalyzesForm(Ref_Analyzes an) { InitializeComponent(); this.ref_analyze = an; 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"; comboBoxTherapist.DataSource = null; bd.Therapists.Load(); comboBoxTherapist.DataSource = bd.Therapists.Local.ToList(); comboBoxTherapist.DisplayMember = "Surname"; comboBoxTherapist.ValueMember = "Id"; comboBoxAnalyz.DataSource = null; bd.Analyzes.Load(); comboBoxAnalyz.DataSource = bd.Analyzes.Local.ToList(); comboBoxAnalyz.DisplayMember = "Name_analyze"; comboBoxAnalyz.ValueMember = "Id"; }
public MainForm() { InitializeComponent(); //bd = new Registration_patientsEntities(); bd = new Registration_patientsEntities2(); }