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());
        }
Beispiel #2
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            addPatient addPatient = new addPatient();

            addPatient.P_firstName        = tbFN.Text;
            addPatient.P_lastName         = tbLN.Text;
            addPatient.P_age              = int.Parse(lbAge.Text);
            addPatient.P_dob              = this.dtpDob.Value;
            addPatient.P_contact          = int.Parse(tbContact.Text);
            addPatient.P_emergencyContact = int.Parse(tbEmergency.Text);
            addPatient.P_gender           = cbGender.Text;
            addPatient.P_address          = tbAddress.Text;
            addPatient.P_bedNum           = int.Parse(tbBed.Text);
            addPatient.P_floor            = tbFloor.Text;
            addPatient.P_admission        = dtpAdmission.Value;

            addPatientHandler addPatientHandler = new addPatientHandler();
            int recordCnt = addPatientHandler.addNewPatient(databaseConnertor.getconn(), addPatient);

            MessageBox.Show(recordCnt + " record has been inserted !!");
        }
        private void btnRegister_Click(object sender, EventArgs e)
        {
            DatabaseConnertor databaseConnertor = new DatabaseConnertor();

            databaseConnertor.connect();

            addPatient addPatient = new addPatient();

            addPatient.P_firstName        = firstNameTB.Text;
            addPatient.P_lastName         = lastNameTB.Text;
            addPatient.P_age              = int.Parse(ageLabel.Text);
            addPatient.P_dob              = this.dobDTP.Value;
            addPatient.P_contact          = int.Parse(contactTB.Text);
            addPatient.P_emergencyContact = int.Parse(emergencyContactTB.Text);
            addPatient.P_gender           = genderCB.Text;
            addPatient.P_address          = addressTB.Text;
            addPatient.P_floor            = tbFloor.Text;
            addPatient.P_bedNum           = int.Parse(tbBed.Text);
            addPatient.P_admission        = this.dtpAdmission.Value;

            addPatientHandler addPatientHandler = new addPatientHandler();
            int recordCnt = addPatientHandler.addNewPatient(databaseConnertor.getconn(), addPatient);

            MessageBox.Show(recordCnt + " record has been inserted !!");
        }
Beispiel #4
0
        private void History_Load(object sender, EventArgs e)
        {
            DatabaseConnertor database = new DatabaseConnertor();

            database.connect();
            realtimeHandler realtimeHandler = new realtimeHandler();

            dgvHistory.DataSource = realtimeHandler.getAlldetails(database.getconn());

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

            dgvPatient.DataSource = addPatientHandler.getAllPatient(database.getconn());
        }