private void searchPB_click(object sender, EventArgs e)
        {
            addPatientPanel.Hide();
            informPanel.Hide();
            medicalPanel.Hide();
            addDetailPanel.Hide();
            searchPanel.Show();

            addPatientPB.BorderStyle    = BorderStyle.None;
            medicalDetailPB.BorderStyle = BorderStyle.None;
            displayPB.BorderStyle       = BorderStyle.None;
            searchPB.BorderStyle        = BorderStyle.Fixed3D;

            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();
            addPatientHandler addPatientHandler = new addPatientHandler();

            patientDAT.DataSource = addPatientHandler.getAllPatient(databaseConnertor.getconn());

            DatabaseConnertor database = new DatabaseConnertor();

            databaseConnertor.connect();
            pmdetailsHandler pmdetailsHandler = new pmdetailsHandler();

            dataGridView1.DataSource = pmdetailsHandler.getAlldetails(databaseConnertor.getconn());
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            pmdetails pmdetails = new pmdetails();

            pmdetails.P_id          = int.Parse(patientIDTB.Text);
            pmdetails.P_systolic    = int.Parse(systolicTB.Text);
            pmdetails.P_diastolic   = int.Parse(diastolicTB.Text);
            pmdetails.P_breathing   = int.Parse(breathingTB.Text);
            pmdetails.P_pulse       = int.Parse(pulseTB.Text);
            pmdetails.P_temperater1 = double.Parse(temperatureTB.Text);

            pmdetailsHandler pmdetailsHandler = new pmdetailsHandler();
            int recordCnt2 = pmdetailsHandler.addNewDetails(databaseConnertor.getconn(), pmdetails);

            MessageBox.Show(recordCnt2 + " record has been inserted !!");
        }