public void treatmentInfo(Treatment treatment) { try{ string tcode = treatment.getTreatmentCode(); string ttype = treatment.getTreatmentType(); string tdetails = treatment.getTreatmentDetails(); string tdid = treatment.getDoctorID(); string tpid = treatment.getPatientID(); int tstdfee = treatment.getStandardFee(); int tdocfee = treatment.getDoctorsCharge(); conn.Open(); SqlCommand cmd = new SqlCommand("insert into dental_treatment values('" + tcode + "','" + ttype + "','" + tdetails + "','" + tdid + "','" + tpid + "','" + tstdfee + "','" + tdocfee + "')", conn); cmd.ExecuteNonQuery(); } catch (Exception ex) { var sqlException = ex.InnerException as System.Data.SqlClient.SqlException; if (sqlException.Number == 2601 || sqlException.Number == 2627) { } conn.Close(); } }
public void deleteTreatmentInfo(Treatment treatment) { string tcode = treatment.getTreatmentCode(); string ttype = treatment.getTreatmentType(); string tdetails = treatment.getTreatmentDetails(); string tdid = treatment.getDoctorID(); string tpid = treatment.getPatientID(); int tstdfee = treatment.getStandardFee(); int tdocfee = treatment.getDoctorsCharge(); conn.Open(); SqlCommand cmd = new SqlCommand("delete from dental_treatment where treatmentcode='" + tcode + "'", conn); cmd.ExecuteNonQuery(); conn.Close(); }
public void updateTreatmentInfo(Treatment treatment) { string tcode = treatment.getTreatmentCode(); string ttype = treatment.getTreatmentType(); string tdetails = treatment.getTreatmentDetails(); string tdid = treatment.getDoctorID(); string tpid = treatment.getPatientID(); int tstdfee = treatment.getStandardFee(); int tdocfee = treatment.getDoctorsCharge(); conn.Open(); SqlCommand cmd = new SqlCommand("update dental_treatment set treatmentcode='" + tcode + "',treatmenttype='" + ttype + "',treatmentdetails='" + tdetails + "',doctorid='" + tdid + "',patientid='" + tpid + "',standardfee='" + tstdfee + "',doctorscharge='" + tdocfee + "' where treatmentcode='" + tcode + "'", conn); cmd.ExecuteNonQuery(); conn.Close(); }
private void btnDentalTreatmentSearch_Click(object sender, EventArgs e) { try { string treatmentcode = txtDentalTreatmentTreatmentCode.Text; TreatmentDBO tdbo = new TreatmentDBO(); Treatment treatment = tdbo.findTreatment(treatmentcode); txtDentalTreatmentTreatmentCode.Text = treatment.getTreatmentCode(); txtDentalTreatmentTreatmentType.Text = treatment.getTreatmentType(); txtDentalTreatmentTreatmentDetails.Text = treatment.getTreatmentDetails(); txtDentalTreatmentDoctorID.Text = treatment.getDoctorID(); txtDentalTreatmentPatientID.Text = treatment.getPatientID(); txtDentalTreatmentStandardFee.Text = treatment.getStandardFee().ToString(); txtDentalTreatmentDoctorsCharge.Text = treatment.getDoctorsCharge().ToString(); } catch (Exception ex) { MessageBox.Show("Couldn't find any matching dental treatment records.", "Incorrect Entry", MessageBoxButtons.OK, MessageBoxIcon.Error); } }