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 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 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 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 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 timer1_Tick(object sender, EventArgs e)
{
List <Patient> patList = new List <Patient>();
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.Patients.Count());
}
if (GlobalVar.doc_filtred)
{
GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count();
}
else
{
GlobalVar.count_datarows = context.Patients.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_FPatientDataView == true))
{
GlobalVar.needToUpdate_FPatientDataView = false;
if (GlobalVar.doc_filtred)
{
GlobalVar.pages_count = gl.PageCount(GlobalVar.filtred_doc_id.Count());
}
else
{
GlobalVar.pages_count = gl.PageCount(context.Patients.Count());
}
if (GlobalVar.doc_filtred)
{
GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count();
}
else
{
GlobalVar.count_datarows = context.Patients.Count();
}
Count_row_lbl.Text = GlobalVar.count_datarows.ToString();
dataGridView1.Rows.Clear();
if (int.Parse(page_label.Text) == 1)
{
if (GlobalVar.doc_filtred)
{
List <Patient> patList1 = new List <Patient>();
foreach (var r in GlobalVar.filtred_doc_id)
{
patList1.Add(context.Patients.Where(c => c.patient_id == r).FirstOrDefault());
}
patList = patList1.OrderBy(c => c.patient_id).Take(12).ToList();
foreach (var r in patList)
{
string _pat_medcard = context.Identifiers.Where(c => c.patient_id == r.patient_id).Select(c => c.medcard_number).FirstOrDefault().ToString();
string _pat_phone = context.Communications.Where(c => c.patient_id == r.patient_id).Select(c => c.sms_value).FirstOrDefault().ToString();
dataGridView1.Rows.Add(r.patient_id, r.patient_name, _pat_medcard, _pat_phone);
}
}
else
{
patList = context.Patients.OrderBy(c => c.patient_id).Take(12).ToList();
foreach (var r in patList)
{
string _pat_medcard = context.Identifiers.Where(c => c.patient_id == r.patient_id).Select(c => c.medcard_number).FirstOrDefault().ToString();
string _pat_phone = context.Communications.Where(c => c.patient_id == r.patient_id).Select(c => c.sms_value).FirstOrDefault().ToString();
dataGridView1.Rows.Add(r.patient_id, r.patient_name, _pat_medcard, _pat_phone);
}
}
}
else
{
if (GlobalVar.doc_filtred)
{
List <Patient> patList1 = new List <Patient>();
foreach (var r in GlobalVar.filtred_doc_id)
{
patList1.Add(context.Patients.Where(c => c.patient_id == r).FirstOrDefault());
}
patList = patList1.OrderBy(c => c.patient_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList();
foreach (var r in patList)
{
string _pat_medcard = context.Identifiers.Where(c => c.patient_id == r.patient_id).Select(c => c.medcard_number).FirstOrDefault().ToString();
string _pat_phone = context.Communications.Where(c => c.patient_id == r.patient_id).Select(c => c.sms_value).FirstOrDefault().ToString();
dataGridView1.Rows.Add(r.patient_id, r.patient_name, _pat_medcard, _pat_phone);
}
}
else
{
patList = context.Patients.OrderBy(c => c.patient_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList();
foreach (var r in patList)
{
string _pat_medcard = context.Identifiers.Where(c => c.patient_id == r.patient_id).Select(c => c.medcard_number).FirstOrDefault().ToString();
string _pat_phone = context.Communications.Where(c => c.patient_id == r.patient_id).Select(c => c.sms_value).FirstOrDefault().ToString();
dataGridView1.Rows.Add(r.patient_id, r.patient_name, _pat_medcard, _pat_phone);
}
}
}
Count_row_lbl.Text = GlobalVar.count_datarows.ToString();
gl.SetContextMenu_Collumns(dataGridView1, id_context);
}
}
private void FDocDataView_Shown(object sender, EventArgs e)
{
List <Doctor> personList = new List <Doctor>();
GlobalVar gl = new GlobalVar();
MedicineContext context = new MedicineContext();
comboBox1.SelectedIndex = 0;
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 (GlobalVar.doc_filtred)
{
GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count();
}
else
{
if (comboBox1.Text == "Работает")
{
GlobalVar.count_datarows = context.Doctors.Where(c => c.doc_status == "Работает").Count();
}
else
{
GlobalVar.count_datarows = context.Doctors.Where(c => c.doc_status == "Уволен").Count();
}
}
Count_row_lbl.Text = GlobalVar.count_datarows.ToString();
dataGridView1.Rows.Clear();
if (GlobalVar.doc_filtred)
{
List <Doctor> personList1 = new List <Doctor>();
foreach (var r in GlobalVar.filtred_doc_id)
{
personList1.Add(context.Doctors.Where(c => c.doctor_id == r).FirstOrDefault());
}
personList = personList1.OrderBy(c => c.doctor_id).Take(12).ToList();
foreach (var r in personList)
{
dataGridView1.Rows.Add(r.doctor_id, r.doctor_name, r.room_number, r.job_name, r.phone_number);
}
}
else
{
if (comboBox1.Text == "Работает")
{
personList = context.Doctors.Where(c => c.doc_status == "Работает").OrderBy(c => c.doctor_id).Take(12).ToList();
}
else
{
personList = context.Doctors.Where(c => c.doc_status == "Уволен").OrderBy(c => c.doctor_id).Take(12).ToList();
}
foreach (var r in personList)
{
dataGridView1.Rows.Add(r.doctor_id, r.doctor_name, r.room_number, r.job_name, r.phone_number);
}
}
gl.SetContextMenu_Collumns(dataGridView1, id_context);
}
private void timer1_Tick(object sender, EventArgs e)
{
List <Doctor> personList = new List <Doctor>();
GlobalVar gl = new GlobalVar();
MedicineContext context = new MedicineContext();
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 (GlobalVar.doc_filtred)
{
GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count();
}
else
{
if (comboBox1.Text == "Работает")
{
GlobalVar.count_datarows = context.Doctors.Where(c => c.doc_status == "Работает").Count();
}
else
{
GlobalVar.count_datarows = context.Doctors.Where(c => c.doc_status == "Уволен").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_FDocDataView == true))
{
GlobalVar.needToUpdate_FDocDataView = false;
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 (GlobalVar.doc_filtred)
{
GlobalVar.count_datarows = GlobalVar.filtred_doc_id.Count();
}
else
{
if (comboBox1.Text == "Работает")
{
GlobalVar.count_datarows = context.Doctors.Where(c => c.doc_status == "Работает").Count();
}
else
{
GlobalVar.count_datarows = context.Doctors.Where(c => c.doc_status == "Уволен").Count();
}
}
Count_row_lbl.Text = GlobalVar.count_datarows.ToString();
dataGridView1.Rows.Clear();
if (int.Parse(page_label.Text) == 1)
{
if (GlobalVar.doc_filtred)
{
List <Doctor> personList1 = new List <Doctor>();
foreach (var r in GlobalVar.filtred_doc_id)
{
personList1.Add(context.Doctors.Where(c => c.doctor_id == r).FirstOrDefault());
}
personList = personList1.OrderBy(c => c.doctor_id).Take(12).ToList();
foreach (var r in personList)
{
dataGridView1.Rows.Add(r.doctor_id, r.doctor_name, r.room_number, r.job_name, r.phone_number);
}
}
else
{
if (comboBox1.Text == "Работает")
{
personList = context.Doctors.Where(c => c.doc_status == "Работает").OrderBy(c => c.doctor_id).Take(12).ToList();
}
else
{
personList = context.Doctors.Where(c => c.doc_status == "Уволен").OrderBy(c => c.doctor_id).Take(12).ToList();
}
foreach (var r in personList)
{
dataGridView1.Rows.Add(r.doctor_id, r.doctor_name, r.room_number, r.job_name, r.phone_number);
}
}
}
else
{
if (GlobalVar.doc_filtred)
{
List <Doctor> personList1 = new List <Doctor>();
foreach (var r in GlobalVar.filtred_doc_id)
{
personList1.Add(context.Doctors.Where(c => c.doctor_id == r).FirstOrDefault());
}
personList = personList1.OrderBy(c => c.doctor_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList();
foreach (var r in personList)
{
dataGridView1.Rows.Add(r.doctor_id, r.doctor_name, r.room_number, r.job_name, r.phone_number);
}
}
else
{
if (comboBox1.Text == "Работает")
{
personList = context.Doctors.Where(c => c.doc_status == "Работает").OrderBy(c => c.doctor_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList();
}
else
{
personList = context.Doctors.Where(c => c.doc_status == "Уволен").OrderBy(c => c.doctor_id).Skip(12 * int.Parse(page_label.Text) - 12).Take(12).ToList();
}
foreach (var r in personList)
{
dataGridView1.Rows.Add(r.doctor_id, r.doctor_name, r.room_number, r.job_name, r.phone_number);
}
}
}
Count_row_lbl.Text = GlobalVar.count_datarows.ToString();
gl.SetContextMenu_Collumns(dataGridView1, id_context);
}
}
