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