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(); 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 !!"); }
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()); }