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;
}
}
;
}
