Beispiel #1
0
        //G
        public static void searchPatientName(string[] name, bool main)
        {
            //create sql statement
            DBConnection connection = DBConnection.getDBConnectionInstance();

            if (name[2].Contains('/'))
            {
                string  sqlQuery    = @"SELECT * FROM Patients WHERE Patient_name = @Name AND Patient_surname = @Surname AND Patient_date_of_birth = @DobOrAddress;";
                DataSet patientData = connection.searchPatientByName(sqlQuery, name[0], name[1], name[2]);
                //checks that the query returned exactly one result
                int count = patientData.Tables[0].Rows.Count;

                if (count == 1)
                {
                    individual_patient patient = new individual_patient(patientData.Tables[0].Rows[0].Field <int>("Patient_Id").ToString(), patientData);
                    patient.Show();
                }
                else
                {
                    MessageBox.Show("No patient found.");
                    if (main)
                    {
                        main_screen frm = new main_screen();
                        frm.Show();
                    }
                    else
                    {
                        Patients frm = new Patients();
                        frm.Show();
                    }
                }
            }
            else
            {
                string  query = @"SELECT * FROM Patients WHERE Patient_name = @Name AND Patient_surname = @Surname AND Patient_postcode = @DobOrAddress;";
                DataSet patientDataPostcode = connection.searchPatientByName(query, name[0], name[1], name[2]);
                //checks that the query returned exactly one result
                int count = patientDataPostcode.Tables[0].Rows.Count;

                if (count == 1)
                {
                    individual_patient patient = new individual_patient(patientDataPostcode.Tables[0].Rows[0].Field <int>("Patient_Id").ToString(), patientDataPostcode);
                    patient.Show();
                }
                else
                {
                    MessageBox.Show("No patient found.");
                    if (main)
                    {
                        main_screen frm = new main_screen();
                        frm.Show();
                    }
                    else
                    {
                        Patients frm = new Patients();
                        frm.Show();
                    }
                }
            }
        }
Beispiel #2
0
        //G
        public static void searchPatient(string id, bool main)
        {
            //creates the SQL query
            string       query       = @"SELECT * FROM Patients WHERE Patient_Id = @ID;";
            DBConnection connection  = DBConnection.getDBConnectionInstance();
            DataSet      patientData = connection.getDataById(query, id);
            //checks that the query returned exactly one result
            int count = patientData.Tables[0].Rows.Count;

            if (count == 1)
            {
                individual_patient patient = new individual_patient(id, patientData);
                patient.Show();
            }
            else
            {
                MessageBox.Show("No patient found.");
                if (main)
                {
                    main_screen frm = new main_screen();
                    frm.Show();
                }
                else
                {
                    Patients frm = new Patients();
                    frm.Show();
                }
            }
        }
Beispiel #3
0
        public static void searchPatient(string id)
        {
            //creates the SQL query
            string       query       = @"SELECT * FROM Patients WHERE Patient_Id = '" + id + "';";
            DBConnection connection  = DBConnection.getDBConnectionInstance();
            DataSet      patientData = connection.getDataSet(query);
            //checks that the query returned exactly one result
            int count = patientData.Tables[0].Rows.Count;

            if (count == 1)
            {
                individual_patient patient = new individual_patient(id, patientData);
                patient.Show();
            }
            else
            {
                MessageBox.Show("No patient found.");
            }
        }
Beispiel #4
0
        void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target)
        {
            switch (connectionId)
            {
            case 1:
                this.individual_screen = ((WpfApp2.individual_patient)(target));
                return;

            case 2:
                this.bt_patient_record = ((System.Windows.Controls.Button)(target));

            #line 10 "..\..\individual patient.xaml"
                this.bt_patient_record.Click += new System.Windows.RoutedEventHandler(this.bt_patient_record_Click);

            #line default
            #line hidden
                return;

            case 3:
                this.booking = ((System.Windows.Controls.Label)(target));
                return;

            case 4:
                this.dataGrid = ((System.Windows.Controls.DataGrid)(target));
                return;

            case 5:
                this.tb_name = ((System.Windows.Controls.TextBlock)(target));
                return;

            case 6:
                this.bt_prescriptions = ((System.Windows.Controls.Button)(target));

            #line 14 "..\..\individual patient.xaml"
                this.bt_prescriptions.Click += new System.Windows.RoutedEventHandler(this.bt_prescriptions_Click);

            #line default
            #line hidden
                return;
            }
            this._contentLoaded = true;
        }
Beispiel #5
0
        public static void searchPatientName(string[] name)
        {
            //create sql statement
            DBConnection connection = DBConnection.getDBConnectionInstance();

            if (name[2].Contains('/'))
            {
                string  sqlQuery    = @"SELECT * FROM Patients WHERE Patient_name = '" + name[0] + "' AND Patient_surname = '" + name[1] + "' AND Patient_date_of_birth = '" + name[2] + "';";
                DataSet patientData = connection.getDataSet(sqlQuery);
                //checks that the query returned exactly one result
                int count = patientData.Tables[0].Rows.Count;

                if (count == 1)
                {
                    individual_patient patient = new individual_patient(patientData.Tables[0].Rows[0].Field <int>("Patient_Id").ToString(), patientData);
                    patient.Show();
                }
                else
                {
                    MessageBox.Show("No patient found.");
                }
            }
            else
            {
                string  query = @"SELECT * FROM Patients WHERE Patient_name = '" + name[0] + "' AND Patient_surname = '" + name[1] + "' AND Patient_postcode = '" + name[2] + "';";
                DataSet patientDataPostcode = connection.getDataSet(query);
                //checks that the query returned exactly one result
                int count = patientDataPostcode.Tables[0].Rows.Count;

                if (count == 1)
                {
                    individual_patient patient = new individual_patient(patientDataPostcode.Tables[0].Rows[0].Field <int>("Patient_Id").ToString(), patientDataPostcode);
                    patient.Show();
                }
                else
                {
                    MessageBox.Show("No patient found.");
                }
            }
        }
Beispiel #6
0
        void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target)
        {
            switch (connectionId)
            {
            case 1:
                this.individual_screen = ((WpfApp2.individual_patient)(target));
                return;

            case 2:
                this.bt_home = ((System.Windows.Controls.Button)(target));

            #line 10 "..\..\individual patient.xaml"
                this.bt_home.Click += new System.Windows.RoutedEventHandler(this.bt_home_Click);

            #line default
            #line hidden
                return;

            case 3:
                this.bt_booking = ((System.Windows.Controls.Button)(target));

            #line 11 "..\..\individual patient.xaml"
                this.bt_booking.Click += new System.Windows.RoutedEventHandler(this.bt_booking_Click);

            #line default
            #line hidden
                return;

            case 4:
                this.bt_staff = ((System.Windows.Controls.Button)(target));

            #line 12 "..\..\individual patient.xaml"
                this.bt_staff.Click += new System.Windows.RoutedEventHandler(this.bt_staff_Click);

            #line default
            #line hidden
                return;

            case 5:
                this.bt_test = ((System.Windows.Controls.Button)(target));
                return;

            case 6:
                this.bt_patient_record = ((System.Windows.Controls.Button)(target));

            #line 14 "..\..\individual patient.xaml"
                this.bt_patient_record.Click += new System.Windows.RoutedEventHandler(this.bt_patient_record_Click);

            #line default
            #line hidden
                return;

            case 7:
                this.prescriptions_list = ((System.Windows.Controls.ListView)(target));
                return;

            case 8:
                this.prescription_scroll_bar = ((System.Windows.Controls.Primitives.ScrollBar)(target));
                return;

            case 9:
                this.prescriptions = ((System.Windows.Controls.Label)(target));
                return;

            case 10:
                this.edit = ((System.Windows.Controls.Image)(target));
                return;

            case 11:
                this.back_page = ((System.Windows.Controls.Image)(target));
                return;

            case 12:

            #line 34 "..\..\individual patient.xaml"
                ((System.Windows.Controls.ListBoxItem)(target)).Selected += new System.Windows.RoutedEventHandler(this.ListBoxItem_Selected);

            #line default
            #line hidden
                return;

            case 13:
                this.booking_scroll_bar = ((System.Windows.Controls.Primitives.ScrollBar)(target));
                return;

            case 14:
                this.booking = ((System.Windows.Controls.Label)(target));
                return;
            }
            this._contentLoaded = true;
        }