private void button1_Click(object sender, EventArgs e) { string examCode = ""; ExaminationsSearchCriteria examinationSearchCriteria = new ExaminationsSearchCriteria(); examinationSearchCriteria.setExaminationName(comboBox1.Text); var resExa = SQLDoc.GetPhysicalExamination(examinationSearchCriteria); foreach (var order in resExa) { examCode = order.examDictionaryTable.Exam_Code; } if (examCode != "" && textBox5.Text != "") { int idAppointment = Int32.Parse(IDVis); int idExamination = Int32.Parse(textBox4.Text); SQLDoc.updatePhysicalExamination(idExamination, examCode, textBox5.Text); Panel P = new Panel(); P.Controls.Clear(); this.Hide(); this.Parent.Controls.Add(new PhysicalExamination(idpat, IDVis, procedure)); } else { MessageBox.Show("Wymagane dane: rodzaj badania, wynik"); } }
public ShowPhysicalExamination(int IDPatient, string IDVisit, string IDExamination, int procedure1) // w zależności czy pokazujemy wizyty czy obsługujemy wizytę { InitializeComponent(); IDVis = IDVisit; idpat = IDPatient; procedure = procedure1; textBox4.Text = IDExamination; PatientsSearchCriteria searchCriteria = new PatientsSearchCriteria(); searchCriteria.setPatientId(IDPatient); var res = SQLDoc.GetPatient(searchCriteria); foreach (var order in res) { textBox1.Text = order.patientTable.Name; textBox2.Text = order.patientTable.Surname; textBox3.Text = order.patientTable.PESEL; } // textBox6 rodzaj badania // textBox5 wynik ExaminationsSearchCriteria examSearchCriteria = new ExaminationsSearchCriteria(); examSearchCriteria.setAppointmentId(Int32.Parse(IDVisit)); examSearchCriteria.setPatientId(IDPatient); var a = SQLDoc.GetPhysicalExamination(examSearchCriteria); textBox6.Text = a.First().examDictionaryTable.Name; textBox5.Text = a.First().physicalExaminationTable.Result; }
public LabolatoryExaminantion(int IdPatient, string IdVisit, int procedure1) // procedure informuje o trybie formatki czy edytowalna (zlec badanie )- "2" czy tylko pokazujemy badanka - "1" { InitializeComponent(); if (procedure1 == 1) { button2.Visible = false; button3.Visible = false; } IDVis = IdVisit; idpat = IdPatient; procedure = procedure1; PatientsSearchCriteria searchCriteria = new PatientsSearchCriteria(); searchCriteria.setPatientId(IdPatient); var res = SQLDoc.GetPatient(searchCriteria); foreach (var order in res) { textBox1.Text = order.patientTable.Name; textBox2.Text = order.patientTable.Surname; textBox3.Text = order.patientTable.PESEL; } Mainlist.FullRowSelect = true; Mainlist.GridLines = true; int idVisitInt = int.Parse(IdVisit); ExaminationsSearchCriteria examSearchCriteria = new ExaminationsSearchCriteria(); examSearchCriteria.setAppointmentId(idVisitInt); examSearchCriteria.setPatientId(IdPatient); var a = SQLDoc.GetLaboratoryExamination(examSearchCriteria); Mainlist.Items.Clear(); foreach (var order in a) { ListViewItem lvi = new ListViewItem(order.laboratoryExaminationTable.Id_Examination.ToString()); lvi.SubItems.Add(order.examDictionaryTable.Name); //typ badania lvi.SubItems.Add(order.laboratoryExaminationTable.State); //stan badania lvi.SubItems.Add(order.laboratoryExaminationTable.Comments_Doctor); //notatka doktora lvi.SubItems.Add(order.laboratoryExaminationTable.Date_Of_Order.ToString()); //data wykonania Mainlist.Items.Add(lvi); } }
public ShowLabExamination(int IDPatient, string IDVisit, string IDExamination, int procedure1) // procedura jeśłi 1 - wchodzi dla popatrzenia sobie z "pokaż" wizyty { InitializeComponent(); IDVis = IDVisit; IDPat = IDPatient; procedure = procedure1; PatientsSearchCriteria searchCriteria = new PatientsSearchCriteria(); searchCriteria.setPatientId(IDPatient); var res = SQLDoc.GetPatient(searchCriteria); foreach (var order in res) { textBox1.Text = order.patientTable.Name; textBox2.Text = order.patientTable.Surname; textBox3.Text = order.patientTable.PESEL; } textBox10.Text = IDExamination; //if (procedure == 1) //{ // button1.Visible = true; //} //else //{ // button1.Visible = false; //} int idVisitInt = int.Parse(IDVisit); ExaminationsSearchCriteria examSearchCriteria = new ExaminationsSearchCriteria(); examSearchCriteria.setAppointmentId(idVisitInt); examSearchCriteria.setPatientId(IDPatient); var a = SQLDoc.GetLaboratoryExamination(examSearchCriteria); foreach (var order in a) { textBox10.Text = order.laboratoryExaminationTable.Id_Examination.ToString(); textBox6.Text = order.examDictionaryTable.Name; //typ badania textBox8.Text = order.laboratoryExaminationTable.State; //stan badania textBox5.Text = order.laboratoryExaminationTable.Result; //wynik badania textBox9.Text = order.laboratoryExaminationTable.Comments_Doctor; //uwagi doktora textBox7.Text = order.laboratoryExaminationTable.Comments_Man_Lab; //uwagi kierownika } }
public NewLabolatoryExaminationcs(int IDP, string IDV, int procedure1, int idexamination) // procedure = 2 -> edytuj, procedure = 1 -> nowe { InitializeComponent(); IDVis = IDV; idpat = IDP; procedure = procedure1; PatientsSearchCriteria searchCriteria = new PatientsSearchCriteria(); searchCriteria.setPatientId(IDP); var res = SQLDoc.GetPatient(searchCriteria); foreach (var order in res) { textBox1.Text = order.patientTable.Name; textBox2.Text = order.patientTable.Surname; textBox3.Text = order.patientTable.PESEL; } if (idexamination != -1) { textBox10.Text = idexamination.ToString();; ExaminationsSearchCriteria examinationSearchCriteria = new ExaminationsSearchCriteria(); examinationSearchCriteria.setExaminationId(idexamination); var resExa = SQLDoc.GetLaboratoryExamination(examinationSearchCriteria); foreach (var order in resExa) { comboBox1.Text = order.examDictionaryTable.Name; textBox5.Text = order.laboratoryExaminationTable.Comments_Doctor; } } var result = SQLDoc.GetLabolatoryExamination(); foreach (var order in result) { comboBox1.Items.Add(order.Name); } }
public EditPhysicalExamination(int IDP, string IDV, int procedure1, int idexamination) // proce4dura ułatwia ogarniecie kiedy można edytować powiazane formatki - 1 -> oglądamy { InitializeComponent(); IDVis = IDV; idpat = IDP; procedure = procedure1; idExamination = idexamination; PatientsSearchCriteria searchCriteria = new PatientsSearchCriteria(); searchCriteria.setPatientId(IDP); var res = SQLDoc.GetPatient(searchCriteria); foreach (var order in res) { textBox1.Text = order.patientTable.Name; textBox2.Text = order.patientTable.Surname; textBox3.Text = order.patientTable.PESEL; } if (idexamination != -1) { textBox4.Text = idexamination.ToString(); ExaminationsSearchCriteria examinationSearchCriteria = new ExaminationsSearchCriteria(); examinationSearchCriteria.setExaminationId(idexamination); var resExa = SQLDoc.GetPhysicalExamination(examinationSearchCriteria); foreach (var order in resExa) { comboBox1.Text = order.examDictionaryTable.Name; textBox5.Text = order.physicalExaminationTable.Result; } } var result = SQLDoc.GetPhysicalExamination(); foreach (var order in result) { comboBox1.Items.Add(order.Name); } }