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