private void button1_Click(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); GlobalVar.filtred_doc_id.Clear(); DateTime d1 = Convert.ToDateTime(dateTimePicker1.Text); DateTime d2 = Convert.ToDateTime(dateTimePicker2.Text); GlobalVar gl = new GlobalVar(); if (comboBox1.SelectedIndex == 0 && comboBox2.SelectedIndex == 0) { GlobalVar.filtred_doc_id.Clear(); if (radioButton1.Checked) { foreach (var r in context.Doctors.ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Мужской" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } else { foreach (var r in context.Doctors.ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Женский" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } } else { if (comboBox1.SelectedIndex == 0 && comboBox2.SelectedIndex > 0) { GlobalVar.filtred_doc_id.Clear(); if (radioButton1.Checked) { foreach (var r in context.Doctors.Where(c => c.doc_status == comboBox2.Text).ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Мужской" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } else { foreach (var r in context.Doctors.Where(c => c.doc_status == comboBox2.Text).ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Женский" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } } else { if (comboBox1.SelectedIndex > 0 && comboBox2.SelectedIndex == 0) { GlobalVar.filtred_doc_id.Clear(); if (radioButton1.Checked) { foreach (var r in context.Doctors.Where(c => c.job_name == comboBox1.Text).ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Мужской" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } else { foreach (var r in context.Doctors.Where(c => c.job_name == comboBox1.Text).ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Женский" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } } else { if (comboBox1.SelectedIndex > 0 && comboBox2.SelectedIndex > 0) { GlobalVar.filtred_doc_id.Clear(); if (radioButton1.Checked) { foreach (var r in context.Doctors.Where(c => c.job_name == comboBox1.Text && c.doc_status == comboBox2.Text).ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Мужской" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } else { foreach (var r in context.Doctors.Where(c => c.job_name == comboBox1.Text && c.doc_status == comboBox2.Text).ToList()) { if (r.doctor_name.StartsWith(textBox1.Text) && gl.CheckNumberIn(numericUpDown1, numericUpDown2, Convert.ToInt32(r.room_number)) && r.doc_sex == "Мужской" && (d1.CompareTo(Convert.ToDateTime(r.doc_birthdate)) <= 0 && d2.CompareTo(Convert.ToDateTime(r.doc_birthdate)) >= 0) && gl.CheckNumberIn(numericUpDown3, numericUpDown4, Convert.ToInt32(r.doc_experience))) { GlobalVar.filtred_doc_id.Add(r.doctor_id); } } GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FDocDataView = true; Close(); } } } } } }