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