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