private void next_btn_Click(object sender, EventArgs e) { label2.Text = GlobalVar.doc_filtred.ToString(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (GlobalVar.doc_filtred) { GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count()); } else { if (comboBox1.Text == "Работает") { GlobalVar.pages_count = gl.PageCount(context.Doctors.Where(c => c.doc_status == "Работает").Count()); } else { GlobalVar.pages_count = gl.PageCount(context.Doctors.Where(c => c.doc_status == "Уволен").Count()); } } if (Convert.ToUInt32(page_label.Text) == GlobalVar.pages_count) { next_btn.Enabled = false; back_btn.Enabled = true; } else { next_btn.Enabled = true; page_label.Text = (int.Parse(page_label.Text) + 1).ToString(); } }
private void button1_Click(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); GlobalVar.filtred_doc_id.Clear(); if (radioButton1.Checked) { GlobalVar.filtred_doc_id = context.Patients.Where(c => c.patient_name.StartsWith(textBox1.Text)).Select(c => c.patient_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FPatientDataView = true; Close(); } else { if (radioButton2.Checked) { GlobalVar.filtred_doc_id = context.Identifiers.Where(c => c.medcard_number == numericUpDown1.Value).Select(c => c.patient_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FPatientDataView = true; Close(); } else { if (radioButton3.Checked) { GlobalVar.filtred_doc_id = context.Passports.Where(c => c.series == textBox2.Text && c.numbers == textBox3.Text).Select(c => c.patient_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FPatientDataView = true; Close(); } } } }
private void FDocInfoView_Activated(object sender, EventArgs e) { if (GlobalVar.needToUpdate_FDocInfoView) { MedicineContext context = new MedicineContext(); Medicine_Data data = new Medicine_Data(); GlobalVar _var = new GlobalVar(); dataGridView1.Rows.Clear(); dataGridView1.Rows.Add("Полное имя(ФИО):", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.doctor_name).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Специализация:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.job_name).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Номер кабинета:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.room_number).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Стаж работы:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.doc_experience).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Моб. номер телефона:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.phone_number).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Пол:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.doc_sex).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Возраст:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.doc_birthdate).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Серия паспорта:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.passport_series).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Номер паспорта:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.passport_number).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Обслуживает адресс:", context.Regions.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.region_name).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Номер карты:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.doc_card).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Архивный номер:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.archive_number).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Статус:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.doc_status).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Смена:", context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.time_working).FirstOrDefault().ToString()); pictureBox1.Image = data.Base64ToImage(context.Doctors.Where(c => c.doctor_id == GlobalVar.selected_docID).Select(c => c.doc_photo).FirstOrDefault()); _var.SetContextMenu_Cells(dataGridView1, contextMenuStrip1); GlobalVar.needToUpdate_FDocInfoView = false; } }
private void button1_Click(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); GlobalVar.filtred_doc_id.Clear(); if (radioButton1.Checked) { GlobalVar.filtred_doc_id = context.Preparations.Where(c => c.med_name.StartsWith(textBox1.Text)).Select(c => c.med_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FMedications = true; Close(); } else { if (radioButton2.Checked) { GlobalVar.filtred_doc_id = context.Preparations.Where(c => c.med_code.StartsWith(textBox2.Text)).Select(c => c.med_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FMedications = true; Close(); } else { if (radioButton3.Checked) { GlobalVar.filtred_doc_id = context.Preparations.Where(c => c.med_count >= numericUpDown1.Value && c.med_count <= numericUpDown2.Value).Select(c => c.med_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FMedications = true; Close(); } } } }
private void button1_Click(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); GlobalVar.filtred_doc_id.Clear(); if (radioButton1.Checked) { GlobalVar.filtred_doc_id = context.Researches.Where(c => c.ins_name.StartsWith(textBox1.Text)).Select(c => c.ins_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FResearches = true; Close(); } else { if (radioButton2.Checked) { GlobalVar.filtred_doc_id = context.Researches.Where(c => c.ins_countdays >= numericUpDown1.Value && c.ins_countdays <= numericUpDown2.Value).Select(c => c.ins_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FResearches = true; Close(); } else { if (radioButton3.Checked) { GlobalVar.filtred_doc_id = context.Researches.Where(c => c.ins_price >= numericUpDown3.Value && c.ins_price <= numericUpDown4.Value).Select(c => c.ins_id).ToList(); GlobalVar.doc_filtred = true; GlobalVar.needToUpdate_FResearches = true; Close(); } } } }
private void FPatInfoView_Activated(object sender, EventArgs e) { if (GlobalVar.needToUpdate_FPatInfoView) { MedicineContext context = new MedicineContext(); Medicine_Data data = new Medicine_Data(); GlobalVar _var = new GlobalVar(); dataGridView1.Rows.Clear(); dataGridView1.Rows.Add("Полное имя(ФИО):", context.Patients.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.patient_name).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Дата рождения:", context.Patients.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.birth_date).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Номер мед. карты:", context.Identifiers.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.medcard_number).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Место жительства:", context.Locations.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.home_adress).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Серия паспорта:", context.Passports.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.series).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Номер паспорта:", context.Passports.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.numbers).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Сотовый:", context.Communications.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.sms_value).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Email:", context.Communications.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.email_value).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Платежная карта:", context.Patients_Money.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.discount_card).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Разрешение на sms:", context.Agreements.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.sms_bool).FirstOrDefault().ToString()); dataGridView1.Rows.Add("Разрешение на email:", context.Agreements.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.email_bool).FirstOrDefault().ToString()); pictureBox1.Image = data.Base64ToImage(context.Patients.Where(c => c.patient_id == GlobalVar.selected_docID).Select(c => c.photo_path).FirstOrDefault()); _var.SetContextMenu_Cells(dataGridView1, contextMenuStrip1); GlobalVar.needToUpdate_FPatInfoView = false; } }
private void back_btn_Click(object sender, EventArgs e) { filtr_lbl.Text = GlobalVar.doc_filtred.ToString(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (GlobalVar.doc_filtred) { GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count()); } else { GlobalVar.pages_count = gl.PageCount(context.Researches.Count()); } if (int.Parse(page_label.Text) == 1) { back_btn.Enabled = false; next_btn.Enabled = true; } else { page_label.Text = (int.Parse(page_label.Text) - 1).ToString(); next_btn.Enabled = true; if (int.Parse(page_label.Text) == 1) { back_btn.Enabled = false; } } }
private void next_btn_Click(object sender, EventArgs e) { filtr_lbl.Text = GlobalVar.doc_filtred.ToString(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (GlobalVar.doc_filtred) { GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count()); } else { GlobalVar.pages_count = gl.PageCount(context.Patients.Count()); } if (Convert.ToUInt32(page_label.Text) == GlobalVar.pages_count) { next_btn.Enabled = false; back_btn.Enabled = true; } else { next_btn.Enabled = true; page_label.Text = (int.Parse(page_label.Text) + 1).ToString(); } }
private void button4_Click(object sender, EventArgs e) { GlobalVar gl = new GlobalVar(); MedicineContext context = new MedicineContext(); int _ser_id; string _name; string _price; if (comboBox2.Text != "") { _ser_id = Convert.ToInt32(context.Services.Where(c => c.service_name == comboBox2.Text).Select(c => c.service_id).FirstOrDefault()); _name = context.Services.Where(c => c.service_id == _ser_id).Select(c => c.service_name).FirstOrDefault().ToString(); _price = context.Services.Where(c => c.service_id == _ser_id).Select(c => c.service_price).FirstOrDefault().ToString(); if (gl.CheckDistinct_ValueGrid(dataGridView1, _name)) { dataGridView1.Rows.Add(_ser_id, _name, _price); } else { MessageBox.Show("Такая услуга уже была добавлена в список.", "Добавление данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Не указана услуга для добавления в список.", "Добавление данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } gl.SetContextMenu_Collumns(dataGridView1, id_context); }
private void FMedications_Shown(object sender, EventArgs e) { List <Preparation> medList = new List <Preparation>(); GlobalVar gl = new GlobalVar(); MedicineContext context = new MedicineContext(); if (GlobalVar.doc_filtred) { GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count()); } else { GlobalVar.pages_count = gl.PageCount(context.Preparations.Count()); } if (GlobalVar.doc_filtred) { GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count(); } else { GlobalVar.count_datarows = context.Preparations.Count(); } Count_row_lbl.Text = GlobalVar.count_datarows.ToString(); dataGridView1.Rows.Clear(); if (GlobalVar.doc_filtred) { List <Preparation> medList1 = new List <Preparation>(); foreach (var r in GlobalVar.filtred_doc_id) { medList1.Add(context.Preparations.Where(c => c.med_id == r).FirstOrDefault()); } medList = medList1.OrderBy(c => c.med_id).Take(12).ToList(); foreach (var r in medList) { dataGridView1.Rows.Add(r.med_id, r.med_name, r.med_code, r.med_count); } } else { medList = context.Preparations.OrderBy(c => c.med_id).Take(12).ToList(); foreach (var r in medList) { dataGridView1.Rows.Add(r.med_id, r.med_name, r.med_code, r.med_count); } } gl.SetContextMenu_Collumns(dataGridView1, id_context); gl.SetContextMenu_Collumns(dataGridView1, contextMenuStrip); }
private void FResearches_Shown(object sender, EventArgs e) { List <Research> resList = new List <Research>(); GlobalVar gl = new GlobalVar(); MedicineContext context = new MedicineContext(); if (GlobalVar.doc_filtred) { GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count()); } else { GlobalVar.pages_count = gl.PageCount(context.Researches.Count()); } if (GlobalVar.doc_filtred) { GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count(); } else { GlobalVar.count_datarows = context.Researches.Count(); } Count_row_lbl.Text = GlobalVar.count_datarows.ToString(); dataGridView1.Rows.Clear(); if (GlobalVar.doc_filtred) { List <Research> resList1 = new List <Research>(); foreach (var r in GlobalVar.filtred_doc_id) { resList1.Add(context.Researches.Where(c => c.ins_id == r).FirstOrDefault()); } resList = resList1.OrderBy(c => c.ins_id).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } else { resList = context.Researches.OrderBy(c => c.ins_id).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } gl.SetContextMenu_Collumns(dataGridView1, id_context); gl.SetContextMenu_Collumns(dataGridView1, contextMenuStrip); }
private void FSetReseption_Activated(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); if (GlobalVar.selected_patientID_reception > 0) { textBox1.Text = context.Patients.Where(c => c.patient_id == GlobalVar.selected_patientID_reception).Select(c => c.patient_name).FirstOrDefault().ToString(); } }
private void FSetReseption_Shown(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); GlobalVar.set_patient_need = true; doc_name_lbl.Text = context.Doctors.Where(c => c.doctor_id == GlobalVar.FMain_selected_docid).Select(c => c.doctor_name).FirstOrDefault().ToString(); date_lbl.Text = GlobalVar.selected_date_reception; time_lbl.Text = GlobalVar.selected_time_reception; comboBox1.SelectedIndex = 0; foreach (var r in context.Services.ToList()) { comboBox2.Items.Add(r.service_name); } }
private void создатьАккаунтToolStripMenuItem_Click(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); GlobalVar.selected_docID = Convert.ToInt32(dataGridView1.SelectedCells[0].Value); if (context.Doc_Accounts.Any(c => c.doctor_id == GlobalVar.selected_docID)) { MessageBox.Show("У этого врача уже есть учетная запись!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { FDocAccCreate acc = new FDocAccCreate(); acc.ShowDialog(); } }
private void button3_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); if (richTextBox1.TextLength == 0) { data.Create_AnMorbi_Record(GlobalVar.selected_reception_ID, Convert.ToInt32(numericUpDown1.Value)); richTextBox1.Text = "Болеет " + context.AnMorbis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.count_days).FirstOrDefault().ToString() + " дней"; } else { data.UpdateAnMorbi_CountDays(GlobalVar.selected_reception_ID, Convert.ToInt32(numericUpDown1.Value)); richTextBox1.Text = "Болеет " + context.AnMorbis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.count_days).FirstOrDefault().ToString() + " дней"; } }
private void button6_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); if (richTextBox3.TextLength == 0 && richTextBox5.TextLength == 0) { data.Create_CurStatus_Record(GlobalVar.selected_reception_ID, richTextBox4.Text, richTextBox6.Text); richTextBox3.Text = context.Current_Status.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.general_state).FirstOrDefault().ToString(); richTextBox5.Text = context.Current_Status.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.physique_value).FirstOrDefault().ToString(); } else { data.UpdateCurStatus_Status(GlobalVar.selected_reception_ID, richTextBox4.Text, richTextBox6.Text); richTextBox3.Text = context.Current_Status.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.general_state).FirstOrDefault().ToString(); richTextBox5.Text = context.Current_Status.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.physique_value).FirstOrDefault().ToString(); } }
private void button1_Click(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); Medicine_Data data = new Medicine_Data(); if (textBox1.Text != "") { if (textBox2.Text != "") { if (textBox3.Text != "") { if (!data.Check_Data_DocLogin(textBox1.Text)) { if (textBox3.Text == textBox2.Text) { data.Create_DocAcc_Record(GlobalVar.selected_docID, textBox1.Text, textBox2.Text, comboBox1.Text); MessageBox.Show("Аккаунт успешно создан!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } else { MessageBox.Show("Поле повтор пароля не равен полю пароля!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Такой логин уже существует!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Поле повтора пароля не заполнено!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Поле пароля не заполнено!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Поле логина не заполнено!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button2_Click(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); Medicine_Data data = new Medicine_Data(); GlobalVar gl = new GlobalVar(); if (textBox1.Text != "") { data.Create_Complaint_Record(GlobalVar.selected_reception_ID, textBox1.Text); dataGridView2.Rows.Clear(); foreach (var r in context.Complaints.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _compl_name = context.Complaints.Where(c => c.complaint_id == r.complaint_id).Select(c => c.complaint_value).FirstOrDefault().ToString(); dataGridView2.Rows.Add(r.complaint_id, _compl_name); } gl.SetContextMenu_Collumns(dataGridView2, id_context); } }
private void button8_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (textBox4.Text != "") { data.Create_Diagnosis_Record(GlobalVar.selected_reception_ID, textBox4.Text, comboBox4.Text); dataGridView5.Rows.Clear(); if (context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _diag_name = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_value).FirstOrDefault().ToString(); string _diag_type = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_type).FirstOrDefault().ToString(); dataGridView5.Rows.Add(r.diag_id, _diag_name, _diag_type); } gl.SetContextMenu_Collumns(dataGridView5, id_context); } } }
private void button4_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (textBox2.Text != "") { data.Create_AnVitae_Record(GlobalVar.selected_reception_ID, textBox2.Text); dataGridView3.Rows.Clear(); if (context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _vit_name = context.AnVitaes.Where(c => c.vitae_id == r.vitae_id).Select(c => c.vitae_value).FirstOrDefault().ToString(); dataGridView3.Rows.Add(r.vitae_id, _vit_name); } gl.SetContextMenu_Collumns(dataGridView3, id_context); } } }
private void button10_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (comboBox3.Text != "") { int _med_id = Convert.ToInt32(context.Preparations.Where(c => c.med_name == comboBox3.Text).Select(c => c.med_id).FirstOrDefault()); data.Create_Medication_Record(GlobalVar.selected_reception_ID, _med_id, Convert.ToInt32(numericUpDown2.Value)); } dataGridView7.Rows.Clear(); if (context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _med_name = context.Preparations.Where(c => c.med_id == r.med_id).Select(c => c.med_name).FirstOrDefault().ToString(); string _med_days = context.Medications.Where(c => c.med_id == r.med_id).Select(c => c.med_days).FirstOrDefault().ToString(); dataGridView7.Rows.Add(r.selected_med_id, _med_name, _med_days); } gl.SetContextMenu_Collumns(dataGridView7, id_context); } }
private void button1_Click(object sender, EventArgs e) { GlobalVar gl = new GlobalVar(); Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); if (comboBox1.Text != "") { if (gl.CheckDistinct_ValueGrid(dataGridView1, comboBox1.Text)) { int _ser_id = Convert.ToInt32(context.Services.Where(c => c.service_name == comboBox1.Text).Select(c => c.service_id).FirstOrDefault()); data.CreateONE_Attendances_Record(GlobalVar.selected_reception_ID, _ser_id); dataGridView1.Rows.Clear(); foreach (var r in context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ser_name = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_name).FirstOrDefault().ToString(); string _ser_price = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_price).FirstOrDefault().ToString(); dataGridView1.Rows.Add(r.service_id, _ser_name, _ser_price); } gl.SetContextMenu_Collumns(dataGridView1, id_context); } } }
private void button9_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (comboBox2.Text != "") { int _ins_id = Convert.ToInt32(context.Researches.Where(c => c.ins_name == comboBox2.Text).Select(c => c.ins_id).FirstOrDefault()); data.Create_Inspection_Record(GlobalVar.selected_reception_ID, _ins_id, comboBox5.Text); } dataGridView6.Rows.Clear(); if (context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ins_name = context.Researches.Where(c => c.ins_id == r.ins_id).Select(c => c.ins_name).FirstOrDefault().ToString(); string _ins_status = context.Inspections.Where(c => c.ins_id == r.ins_id).Select(c => c.inspection_status).FirstOrDefault().ToString(); dataGridView6.Rows.Add(r.selected_ins_id, _ins_name, _ins_status); } gl.SetContextMenu_Collumns(dataGridView6, id_context); } }
private void button1_Click(object sender, EventArgs e) { switch (reports_list.SelectedItem.ToString()) { case "Список предлогаемых услуг": { int i = 1; string services_list = ""; MedicineContext context = new MedicineContext(); foreach (var r in context.Services.ToList()) { services_list += i.ToString() + ") " + r.service_name + ". Цена: " + r.service_price.ToString() + Convert.ToChar(11); i++; } Word.Application app = new Word.Application(); object fileName = Application.StartupPath + "\\Reports_Template\\ServiceList.dotx"; Word.Document doc = app.Documents.Open(fileName); doc.Bookmarks["service"].Range.Text = services_list; doc.Application.Visible = true; break; } case "Список предлогаемых обследований": { int i = 1; string insp_list = ""; MedicineContext context = new MedicineContext(); foreach (var r in context.Researches.ToList()) { insp_list += i.ToString() + ") " + r.ins_name + ". Цена: " + r.ins_price.ToString() + Convert.ToChar(11); i++; } Word.Application app = new Word.Application(); object fileName = Application.StartupPath + "\\Reports_Template\\ResearchList.dotx"; Word.Document doc = app.Documents.Open(fileName); doc.Bookmarks["research"].Range.Text = insp_list; doc.Application.Visible = true; break; } case "Список медикоментов в наличии": { int i = 1; string med_list = ""; MedicineContext context = new MedicineContext(); foreach (var r in context.Preparations.ToList()) { med_list += i.ToString() + ") " + r.med_name + ". Количество: " + r.med_count.ToString() + Convert.ToChar(11); i++; } Word.Application app = new Word.Application(); object fileName = Application.StartupPath + "\\Reports_Template\\MedList.dotx"; Word.Document doc = app.Documents.Open(fileName); doc.Bookmarks["med"].Range.Text = med_list; doc.Application.Visible = true; break; } case "Загруженность графика работы каждого врача": { int i = 1; string rec_list = ""; MedicineContext context = new MedicineContext(); foreach (var r in context.Doctors.ToList()) { int rec_count = context.Receptions.Where(c => c.doctor_id == r.doctor_id).Count(); rec_list += i.ToString() + ") " + r.doctor_name.ToString() + ". Записей на прием: " + rec_count.ToString() + Convert.ToChar(11); i++; } Word.Application app = new Word.Application(); object fileName = Application.StartupPath + "\\Reports_Template\\ReceptionsDocList.dotx"; Word.Document doc = app.Documents.Open(fileName); doc.Bookmarks["pop"].Range.Text = rec_list; doc.Application.Visible = true; break; } case "Посещаемость мед. учреждения пациентами": { int i = 1; string rec_list = ""; MedicineContext context = new MedicineContext(); foreach (var r in context.Patients.ToList()) { int rec_count = context.Receptions.Where(c => c.patient_id == r.patient_id).Count(); rec_list += i.ToString() + ") " + r.patient_name.ToString() + ". Всего записей на прием: " + rec_count.ToString() + Convert.ToChar(11); i++; } Word.Application app = new Word.Application(); object fileName = Application.StartupPath + "\\Reports_Template\\ReceptionsPatList.dotx"; Word.Document doc = app.Documents.Open(fileName); doc.Bookmarks["patients"].Range.Text = rec_list; doc.Application.Visible = true; break; } } ; }
private void button7_Click(object sender, EventArgs e) { try { MedicineContext context = new MedicineContext(); Word.Application app = new Word.Application(); object fileName = Application.StartupPath + "\\Reports_Template\\Current_History2.dotx"; Word.Document doc = app.Documents.Open(fileName); string anMorbi = ""; //-- string anVitae = ""; //-- string complaint = ""; //-- string currStatus = ""; //-- string diag = ""; //-- string dises = ""; //-- string doc_v = ""; //-- string ins = ""; //-- string med = ""; //-- int _doc_id = Convert.ToInt32(context.Receptions.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.doctor_id).FirstOrDefault()); tabControl1.Enabled = false; tabControl1.SelectedIndex = 1; for (int i = 0; i < dataGridView2.Rows.Count; i++) { string complaint_buf = dataGridView2.Rows[i].Cells[1].Value.ToString(); if (i == dataGridView2.Rows.Count - 1) { complaint += complaint_buf; } else { complaint += complaint_buf + ", "; } } tabControl1.SelectedIndex = 2; anMorbi = richTextBox1.Text; tabControl1.SelectedIndex = 3; for (int i = 0; i < dataGridView3.Rows.Count; i++) { anVitae += (i + 1).ToString() + ") " + dataGridView3.Rows[i].Cells[1].Value.ToString() + Convert.ToChar(11); } tabControl1.SelectedIndex = 4; for (int i = 0; i < dataGridView4.Rows.Count; i++) { dises += (i + 1).ToString() + ") " + dataGridView4.Rows[i].Cells[1].Value.ToString() + Convert.ToChar(11); } tabControl1.SelectedIndex = 5; currStatus = "Общее состояние: " + richTextBox3.Text + Convert.ToChar(11) + "Телосложение: " + richTextBox5.Text; tabControl1.SelectedIndex = 6; for (int i = 0; i < dataGridView5.Rows.Count; i++) { diag += (i + 1).ToString() + ") " + dataGridView5.Rows[i].Cells[1].Value.ToString() + Convert.ToChar(11); } doc_v = context.Doctors.Where(c => c.doctor_id == _doc_id).Select(c => c.doctor_name).FirstOrDefault().ToString(); tabControl1.SelectedIndex = 7; for (int i = 0; i < dataGridView6.Rows.Count; i++) { ins += (i + 1).ToString() + ") " + dataGridView6.Rows[i].Cells[1].Value.ToString() + Convert.ToChar(11); } tabControl1.SelectedIndex = 8; for (int i = 0; i < dataGridView7.Rows.Count; i++) { med += (i + 1).ToString() + ") " + dataGridView7.Rows[i].Cells[1].Value.ToString() + ". Дней: " + dataGridView7.Rows[i].Cells[2].Value.ToString() + Convert.ToChar(11); } tabControl1.SelectedIndex = 0; tabControl1.Enabled = true; doc.Bookmarks["anMorbi_value"].Range.Text = anMorbi; doc.Bookmarks["anVitae_value"].Range.Text = anVitae; doc.Bookmarks["complaint_value"].Range.Text = complaint; doc.Bookmarks["currStatus_value"].Range.Text = currStatus; doc.Bookmarks["diag_value"].Range.Text = diag; doc.Bookmarks["diseas_value"].Range.Text = dises; doc.Bookmarks["doc_value"].Range.Text = doc_v; doc.Bookmarks["ins_value"].Range.Text = ins; doc.Bookmarks["med_value"].Range.Text = med; doc.Application.Visible = true; } catch { MessageBox.Show("Закройте ворд перед нажатием!", "База данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void page_label_TextChanged(object sender, EventArgs e) { List <Research> resList = new List <Research>(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); dataGridView1.Rows.Clear(); if (int.Parse(page_label.Text) == 1) { if (GlobalVar.doc_filtred) { List <Research> resList1 = new List <Research>(); foreach (var r in GlobalVar.filtred_doc_id) { resList1.Add(context.Researches.Where(c => c.ins_id == r).FirstOrDefault()); } resList = resList1.OrderBy(c => c.ins_id).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } else { resList = context.Researches.OrderBy(c => c.ins_id).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } } else { if (GlobalVar.doc_filtred) { List <Research> resList1 = new List <Research>(); foreach (var r in GlobalVar.filtred_doc_id) { resList1.Add(context.Researches.Where(c => c.ins_id == r).FirstOrDefault()); } resList = resList1.OrderBy(c => c.ins_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } else { resList = context.Researches.OrderBy(c => c.ins_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } } gl.SetContextMenu_Collumns(dataGridView1, id_context); gl.SetContextMenu_Collumns(dataGridView1, contextMenuStrip); }
private void timer1_Tick(object sender, EventArgs e) { List <Research> resList = new List <Research>(); GlobalVar gl = new GlobalVar(); MedicineContext context = new MedicineContext(); if (GlobalVar.doc_filtred) { GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count()); } else { GlobalVar.pages_count = gl.PageCount(context.Researches.Count()); } if (GlobalVar.doc_filtred) { GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count(); } else { GlobalVar.count_datarows = context.Researches.Count(); } if (int.Parse(page_label.Text) == GlobalVar.pages_count) { next_btn.Enabled = false; if (GlobalVar.pages_count == 1) { back_btn.Enabled = false; } else { back_btn.Enabled = true; } } else { next_btn.Enabled = true; } if ((int.Parse(Count_row_lbl.Text) != GlobalVar.count_datarows) || (GlobalVar.needToUpdate_FResearches == true)) { GlobalVar.needToUpdate_FResearches = false; if (GlobalVar.doc_filtred) { GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count()); } else { GlobalVar.pages_count = gl.PageCount(context.Researches.Count()); } if (GlobalVar.doc_filtred) { GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count(); } else { GlobalVar.count_datarows = context.Researches.Count(); } Count_row_lbl.Text = GlobalVar.count_datarows.ToString(); dataGridView1.Rows.Clear(); if (int.Parse(page_label.Text) == 1) { if (GlobalVar.doc_filtred) { List <Research> resList1 = new List <Research>(); foreach (var r in GlobalVar.filtred_doc_id) { resList1.Add(context.Researches.Where(c => c.ins_id == r).FirstOrDefault()); } resList = resList1.OrderBy(c => c.ins_id).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } else { resList = context.Researches.OrderBy(c => c.ins_id).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } } else { if (GlobalVar.doc_filtred) { List <Research> resList1 = new List <Research>(); foreach (var r in GlobalVar.filtred_doc_id) { resList1.Add(context.Researches.Where(c => c.ins_id == r).FirstOrDefault()); } resList = resList1.OrderBy(c => c.ins_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } else { resList = context.Researches.OrderBy(c => c.ins_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList(); foreach (var r in resList) { dataGridView1.Rows.Add(r.ins_id, r.ins_name, r.ins_countdays, r.ins_price); } } } Count_row_lbl.Text = GlobalVar.count_datarows.ToString(); gl.SetContextMenu_Collumns(dataGridView1, id_context); gl.SetContextMenu_Collumns(dataGridView1, contextMenuStrip); } }
private void удалитьЗаписьToolStripMenuItem_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); switch (GlobalVar.TabIndex) { case 0: { GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView1.SelectedCells[0].Value); data.DeleteONE_Attendaces_Record(GlobalVar.selected_reception_ID, GlobalVar.selected_ListRowIndex); dataGridView1.Rows.Clear(); foreach (var r in context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ser_name = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_name).FirstOrDefault().ToString(); string _ser_price = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_price).FirstOrDefault().ToString(); dataGridView1.Rows.Add(r.service_id, _ser_name, _ser_price); } gl.SetContextMenu_Collumns(dataGridView1, id_context); break; } case 1: { GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView2.SelectedCells[0].Value); data.Delete_Complaint_Record(GlobalVar.selected_ListRowIndex); dataGridView2.Rows.Clear(); foreach (var r in context.Complaints.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _compl_name = context.Complaints.Where(c => c.reception_id == r.reception_id).Select(c => c.complaint_value).FirstOrDefault().ToString(); dataGridView2.Rows.Add(r.complaint_id, _compl_name); } gl.SetContextMenu_Collumns(dataGridView2, id_context); break; } case 2: { break; } case 3: { GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView3.SelectedCells[0].Value); data.Delete_AnVitae_Record(GlobalVar.selected_ListRowIndex); dataGridView3.Rows.Clear(); if (context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _vit_name = context.AnVitaes.Where(c => c.vitae_id == r.vitae_id).Select(c => c.vitae_value).FirstOrDefault().ToString(); dataGridView3.Rows.Add(r.vitae_id, _vit_name); } gl.SetContextMenu_Collumns(dataGridView3, id_context); } break; } case 4: { GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView4.SelectedCells[0].Value); data.Delete_Diseas_Record(GlobalVar.selected_ListRowIndex); dataGridView4.Rows.Clear(); if (context.Diseases.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Diseases.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _dis_name = context.Diseases.Where(c => c.dis_id == r.dis_id).Select(c => c.disease_value).FirstOrDefault().ToString(); dataGridView4.Rows.Add(r.dis_id, _dis_name); } gl.SetContextMenu_Collumns(dataGridView4, id_context); } break; } case 5: { break; } case 6: { GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView5.SelectedCells[0].Value); data.Delete_Diagnosis_Recird(GlobalVar.selected_ListRowIndex); dataGridView5.Rows.Clear(); if (context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _diag_name = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_value).FirstOrDefault().ToString(); string _diag_type = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_type).FirstOrDefault().ToString(); dataGridView5.Rows.Add(r.diag_id, _diag_name, _diag_type); } gl.SetContextMenu_Collumns(dataGridView5, id_context); } break; } case 7: { GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView6.SelectedCells[0].Value); data.Delete_Inspection_Record(GlobalVar.selected_ListRowIndex); dataGridView6.Rows.Clear(); if (context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ins_name = context.Researches.Where(c => c.ins_id == r.ins_id).Select(c => c.ins_name).FirstOrDefault().ToString(); string _ins_status = context.Inspections.Where(c => c.ins_id == r.ins_id).Select(c => c.inspection_status).FirstOrDefault().ToString(); dataGridView6.Rows.Add(r.selected_ins_id, _ins_name, _ins_status); } gl.SetContextMenu_Collumns(dataGridView6, id_context); } break; } case 8: { GlobalVar.selected_ListRowIndex = Convert.ToInt32(dataGridView7.SelectedCells[0].Value); data.Delete_Medication_Record(GlobalVar.selected_ListRowIndex); dataGridView7.Rows.Clear(); if (context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _med_name = context.Preparations.Where(c => c.med_id == r.med_id).Select(c => c.med_name).FirstOrDefault().ToString(); string _med_days = context.Medications.Where(c => c.med_id == r.med_id).Select(c => c.med_days).FirstOrDefault().ToString(); dataGridView7.Rows.Add(r.selected_med_id, _med_name, _med_days); } gl.SetContextMenu_Collumns(dataGridView7, id_context); } break; } } ; }
private void FReceptionHistory_Shown(object sender, EventArgs e) { MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); GlobalVar.TabIndex = tabControl1.SelectedIndex; label2.Text = context.Patients.Where(c => c.patient_id == GlobalVar.selected_patientID_reception).Select(c => c.patient_name).FirstOrDefault().ToString(); label4.Text = context.Patients.Where(c => c.patient_id == GlobalVar.selected_patientID_reception).Select(c => c.birth_date).FirstOrDefault().ToString(); label6.Text = context.Identifiers.Where(c => c.patient_id == GlobalVar.selected_patientID_reception).Select(c => c.medcard_number).FirstOrDefault().ToString(); switch (GlobalVar.TabIndex) { case 0: { foreach (var r in context.Services.ToList()) { comboBox1.Items.Add(r.service_name); } if (context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ser_name = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_name).FirstOrDefault().ToString(); string _ser_price = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_price).FirstOrDefault().ToString(); dataGridView1.Rows.Add(r.service_id, _ser_name, _ser_price); } gl.SetContextMenu_Collumns(dataGridView1, id_context); } break; } case 1: { if (context.Complaints.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Complaints.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _compl_name = context.Complaints.Where(c => c.reception_id == r.reception_id).Select(c => c.complaint_value).FirstOrDefault().ToString(); dataGridView2.Rows.Add(r.complaint_id, _compl_name); } gl.SetContextMenu_Collumns(dataGridView2, id_context); } break; } case 2: { break; } case 3: { break; } case 4: { break; } case 5: { break; } case 6: { break; } case 7: { break; } case 8: { break; } } ; }
private void tabControl1_Selected(object sender, TabControlEventArgs e) { GlobalVar.TabIndex = e.TabPageIndex; MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); dataGridView1.Rows.Clear(); dataGridView2.Rows.Clear(); dataGridView3.Rows.Clear(); dataGridView4.Rows.Clear(); dataGridView5.Rows.Clear(); dataGridView6.Rows.Clear(); dataGridView7.Rows.Clear(); switch (GlobalVar.TabIndex) { case 0: { comboBox1.Items.Clear(); dataGridView1.Rows.Clear(); foreach (var r in context.Services.ToList()) { comboBox1.Items.Add(r.service_name); } if (context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ser_name = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_name).FirstOrDefault().ToString(); string _ser_price = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_price).FirstOrDefault().ToString(); dataGridView1.Rows.Add(r.service_id, _ser_name, _ser_price); } gl.SetContextMenu_Collumns(dataGridView1, id_context); } break; } case 1: { dataGridView2.Rows.Clear(); if (context.Complaints.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Complaints.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _compl_name = context.Complaints.Where(c => c.complaint_id == r.complaint_id).Select(c => c.complaint_value).FirstOrDefault().ToString(); dataGridView2.Rows.Add(r.complaint_id, _compl_name); } gl.SetContextMenu_Collumns(dataGridView2, id_context); } break; } case 2: { richTextBox1.Clear(); if (context.AnMorbis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { richTextBox1.Text = "Болеет " + context.AnMorbis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.count_days).FirstOrDefault().ToString() + " дней"; } break; } case 3: { dataGridView3.Rows.Clear(); if (context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.AnVitaes.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _vit_name = context.AnVitaes.Where(c => c.vitae_id == r.vitae_id).Select(c => c.vitae_value).FirstOrDefault().ToString(); dataGridView3.Rows.Add(r.vitae_id, _vit_name); } gl.SetContextMenu_Collumns(dataGridView3, id_context); } break; } case 4: { dataGridView4.Rows.Clear(); if (context.Diseases.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Diseases.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _dis_name = context.Diseases.Where(c => c.dis_id == r.dis_id).Select(c => c.disease_value).FirstOrDefault().ToString(); dataGridView4.Rows.Add(r.dis_id, _dis_name); } gl.SetContextMenu_Collumns(dataGridView4, id_context); } break; } case 5: { richTextBox3.Clear(); richTextBox5.Clear(); if (context.Current_Status.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { richTextBox3.Text = context.Current_Status.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.general_state).FirstOrDefault().ToString(); richTextBox5.Text = context.Current_Status.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Select(c => c.physique_value).FirstOrDefault().ToString(); } break; } case 6: { comboBox4.SelectedIndex = 0; dataGridView5.Rows.Clear(); if (context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Diagnosis.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _diag_name = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_value).FirstOrDefault().ToString(); string _diag_type = context.Diagnosis.Where(c => c.diag_id == r.diag_id).Select(c => c.diag_type).FirstOrDefault().ToString(); dataGridView5.Rows.Add(r.diag_id, _diag_name, _diag_type); } gl.SetContextMenu_Collumns(dataGridView5, id_context); } break; } case 7: { foreach (var r in context.Researches.ToList()) { comboBox2.Items.Add(r.ins_name); } comboBox5.SelectedIndex = 0; dataGridView6.Rows.Clear(); if (context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Inspections.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ins_name = context.Researches.Where(c => c.ins_id == r.ins_id).Select(c => c.ins_name).FirstOrDefault().ToString(); string _ins_status = context.Inspections.Where(c => c.ins_id == r.ins_id).Select(c => c.inspection_status).FirstOrDefault().ToString(); dataGridView6.Rows.Add(r.selected_ins_id, _ins_name, _ins_status); } gl.SetContextMenu_Collumns(dataGridView6, id_context); } break; } case 8: { foreach (var r in context.Preparations.ToList()) { comboBox3.Items.Add(r.med_name); } dataGridView7.Rows.Clear(); if (context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _med_name = context.Preparations.Where(c => c.med_id == r.med_id).Select(c => c.med_name).FirstOrDefault().ToString(); string _med_days = context.Medications.Where(c => c.med_id == r.med_id).Select(c => c.med_days).FirstOrDefault().ToString(); dataGridView7.Rows.Add(r.selected_med_id, _med_name, _med_days); } gl.SetContextMenu_Collumns(dataGridView7, id_context); } break; } } ; }