示例#1
0
        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;
            }
        }
示例#2
0
      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 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);
            }
        }
示例#5
0
        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);
            }
        }
示例#7
0
        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);
            }
        }
示例#9
0
        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);
            }
        }
示例#10
0
        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");
            }
        }