public NewPhysicalExaminationcs(int IDP, string IDV, int procedure1) //procedure- ogarnia kiedy pokazujemy wizyte a kiedy obsługujemy - 1 -> pokazujemy { 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; } var result = SQLDoc.GetPhysicalExamination(); foreach (var order in result) { comboBox1.Items.Add(order.Name); } }
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; * * }*/ examCode = SQLDoc.GetExamCode(comboBox1.Text.ToString()).First().Exam_Code.ToString(); int idAppointment = Int32.Parse(IDVis); if (examCode != "" && textBox5.Text != "") { SQLDoc.insertPhysicalExamination(idAppointment, 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 Show(int IDPatient, string IDVisit) { InitializeComponent(); IdVisit = IDVisit; IdPatient = IDPatient; 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; } int x = Int32.Parse(IDVisit); var res1 = SQLDoc.GetAppointment(x); foreach (var order in res1) { textBox4.Text = order.Descirption; textBox5.Text = order.Diagnosis; } }
public Handle(int IDP, string IDV) { InitializeComponent(); IDVis = IDV; //textb = text; idpat = IDP; 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; } int x = Int32.Parse(IDV); var res1 = SQLDoc.GetAppointment(x); foreach (var order in res1) { textBox4.Text = order.Descirption; textBox5.Text = order.Diagnosis; } }
private void button2_Click(object sender, EventArgs e) //show { if (listView1.SelectedItems.Count > 0) { ListViewItem item = listView1.SelectedItems[0]; PatientsSearchCriteria searchCriteria = new PatientsSearchCriteria(); long pesel = long.Parse(item.SubItems[4].Text.TrimEnd()); searchCriteria.setPesel(pesel); // Refresh(SQLDoc.GetPatient(searchCriteria)); var res = SQLDoc.GetPatient(searchCriteria); foreach (var x in res) { panel1.Controls.Clear(); panel1.Controls.Add(new Show(x.patientTable.Id_Patient, item.SubItems[0].Text.TrimEnd())); panel1.Visible = true; panel1.Dock = DockStyle.Fill; panel1.BringToFront(); } } else { MessageBox.Show("Nie wybrano pacjenta"); } }
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; }
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"); } }
private void button1_Click(object sender, EventArgs e) { State stateTemp = (State)Enum.Parse(typeof(State), comboBox2.Text); VisitsSearchCriteria searchCriteria = new VisitsSearchCriteria(); searchCriteria.setDate(dateTimePicker1.Value.Date, dateTimePicker1.Checked); searchCriteria.setState(stateTemp); searchCriteria.setOnlyVisitsForDoctor(checkBox1.Checked); searchCriteria.setDoctorId(this.whoami); Refresh(SQLDoc.GetVisits(searchCriteria)); }
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 } }
private void button1_Click(object sender, EventArgs e) {//pokaz opis i diagnoze if (Mainlist.SelectedItems.Count > 0) { ListViewItem item = Mainlist.SelectedItems[0]; var vis = SQLDoc.GetAppointment(Int32.Parse(item.SubItems[0].Text)); { textBox1.Text = vis.First().Descirption; //opis textBox2.Text = vis.First().Diagnosis; //diag } } }
private void button1_Click(object sender, EventArgs e) { if (Mainlist.SelectedItems.Count > 0) { ListViewItem item = Mainlist.SelectedItems[0]; var vis = SQLDoc.GetHisP(Int32.Parse(item.SubItems[0].Text)); { textBox6.Text = vis.First().Exam_Code; //rodzaj textBox9.Text = vis.First().Result; //wyn } } }
public Doctor(int id) : this() { dateTimePicker1.Value = DateTime.Today; whoami = id; connector.Text = whoami.ToString(); State stateTemp = (State)Enum.Parse(typeof(State), "Wszystkie"); VisitsSearchCriteria searchCriteria = new VisitsSearchCriteria(); searchCriteria.setDate(dateTimePicker1.Value.Date, dateTimePicker1.Checked); searchCriteria.setState(stateTemp); searchCriteria.setOnlyVisitsForDoctor(checkBox1.Checked); searchCriteria.setDoctorId(this.whoami); Refresh(SQLDoc.GetVisits(searchCriteria)); }
private void button1_Click(object sender, EventArgs e) { if (Mainlist.SelectedItems.Count > 0) { ListViewItem item = Mainlist.SelectedItems[0]; var vis = SQLDoc.GetHisL(Int32.Parse(item.SubItems[0].Text)); { textBox1.Text = vis.First().Result; //wyn textBox2.Text = vis.First().Comments_Man_Lab; //kom m textBox9.Text = vis.First().Comments_Doctor; //kom l } } }
private void button2_Click(object sender, EventArgs e) //back { int idDoctor = -1; int x = Int32.Parse(IDVis); var res1 = SQLDoc.GetAppointment(x); foreach (var order in res1) { idDoctor = order.Id_Doctor; } this.Controls.Clear(); this.Hide(); this.Controls.Add(new MedicalClinic.Doctor.Doctor(idDoctor)); this.Visible = true; this.Dock = DockStyle.Fill; this.BringToFront(); }
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); } }
private void button3_Click(object sender, EventArgs e) //handle { if (listView1.SelectedItems.Count > 0) { ListViewItem item = listView1.SelectedItems[0]; PatientsSearchCriteria searchCriteria = new PatientsSearchCriteria(); long pesel = long.Parse(item.SubItems[4].Text.TrimEnd()); searchCriteria.setPesel(pesel); var x = SQLDoc.GetPatientsList("", "", item.SubItems[4].Text.TrimEnd().ToString()); panel1.Controls.Clear(); panel1.Controls.Add(new Handle(x.First().Id_Patient, item.SubItems[0].Text.TrimEnd())); panel1.Visible = true; panel1.Dock = DockStyle.Fill; panel1.BringToFront(); } else { MessageBox.Show("Nie wybrano pacjenta"); } }
private void button6_Click(object sender, EventArgs e) //anulowanie { SQLDoc.updateDescDia(Int32.Parse(IDVis), textBox5.Text.ToString(), textBox4.Text.ToString(), "C"); MessageBox.Show("Zapisano i anulowano wizytę"); //this.Controls.Clear(); //this.Visible = false; //this.Parent.Hide(); int idDoctor = -1; int x = Int32.Parse(IDVis); var res1 = SQLDoc.GetAppointment(x); foreach (var order in res1) { idDoctor = order.Id_Doctor; } if (idDoctor != -1) { Panel P = new Panel(); P.Controls.Clear(); this.Hide(); this.Parent.Controls.Add(new Doctor(idDoctor)); } }
public HistoryLaboratoryExamination(int IDP) { idpat = IDP; InitializeComponent(); var a = SQLDoc.GetLab(IDP); Mainlist.Items.Clear(); foreach (var order in a) { ListViewItem lvi = new ListViewItem(order.laboratoryExaminationTable.Id_Examination.ToString()); lvi.SubItems.Add(order.appointmentTable.Date_Appointment.ToString()); //data lvi.SubItems.Add(order.staffTable.Surname); //nazwisko lekarza lvi.SubItems.Add(order.laboratoryExaminationTable.State); //stan Mainlist.Items.Add(lvi); } Mainlist.FullRowSelect = true; Mainlist.GridLines = true; }
public HistoryVisits(int id) { InitializeComponent(); Refresh(SQLDoc.GetAppointmentP(id)); }
private void save_Click(object sender, EventArgs e) //zapisz { SQLDoc.updateDescDia(Int32.Parse(IDVis), textBox5.Text.ToString(), textBox4.Text.ToString(), "R"); MessageBox.Show("Zapisano"); }