private void btnDentalTreatmentDelete_Click_1(object sender, EventArgs e)
{
TreatmentDBO tdbo = new TreatmentDBO();
string treatmentcode = txtDentalTreatmentTreatmentCode.Text;
string treatmenttype = txtDentalTreatmentTreatmentType.Text;
string treatmentdetails = txtDentalTreatmentTreatmentDetails.Text;
string doctorid = txtDentalTreatmentDoctorID.Text;
string patientid = txtDentalTreatmentPatientID.Text;
int standardfee = int.Parse(txtDentalTreatmentStandardFee.Text.Trim());
int doctorscharge = int.Parse(txtDentalTreatmentDoctorsCharge.Text.Trim());
Treatment treatment = new Treatment(treatmentcode, treatmenttype, treatmentdetails, doctorid, patientid, standardfee, doctorscharge);
tdbo.deleteTreatmentInfo(treatment);
MessageBox.Show("The dental treatment record & it's information has been removed.", "Delete Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
txtDentalTreatmentTreatmentCode.Text = ""; txtDentalTreatmentTreatmentDetails.Text = ""; txtDentalTreatmentDoctorID.Text = ""; txtDentalTreatmentPatientID.Text = ""; txtDentalTreatmentStandardFee.Text = ""; txtDentalTreatmentDoctorsCharge.Text = ""; lblDentalTreatmentDoctorName.Text = ""; lblDentalTreatmentPatientName.Text = ""; txtDentalTreatmentTreatmentType.SelectedItem = null;
}
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);
}
}
public Treatment findCharges(string treatmentcode)
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from dental_treatment where treatmentcode='" + treatmentcode + "'", conn);
SqlDataReader rd = cmd.ExecuteReader();
Treatment treatment = null;
while (rd.Read())
{
string tcode = rd[0].ToString();
string ttype = rd[1].ToString();
string tdetails = rd[2].ToString();
string tdid = rd[3].ToString();
string tpid = rd[4].ToString();
int tstdfee = int.Parse(rd[5].ToString());
int tdocfee = int.Parse(rd[6].ToString());
treatment = new Treatment(tcode, ttype, tdetails, tdid, tpid, tstdfee, tdocfee);
}
conn.Close();
return(treatment);
}
private void btnDentalTreatmentSave_Click_1(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtDentalTreatmentDoctorID.Text))
{
MessageBox.Show("The Doctor's ID should be entered.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrWhiteSpace(txtDentalTreatmentPatientID.Text))
{
MessageBox.Show("The Patient's ID should be entered.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrWhiteSpace(txtDentalTreatmentTreatmentType.Text))
{
MessageBox.Show("The type of dental treatment should be selected.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
TreatmentDBO tdbo = new TreatmentDBO();
string treatmentcode = txtDentalTreatmentTreatmentCode.Text;
string treatmenttype = txtDentalTreatmentTreatmentType.Text;
string treatmentdetails = txtDentalTreatmentTreatmentDetails.Text;
string doctorid = txtDentalTreatmentDoctorID.Text;
string patientid = txtDentalTreatmentPatientID.Text;
int standardfee = int.Parse(txtDentalTreatmentStandardFee.Text.Trim());
int doctorscharge = int.Parse(txtDentalTreatmentDoctorsCharge.Text.Trim());
Treatment treatment = new Treatment(treatmentcode, treatmenttype, treatmentdetails, doctorid, patientid, standardfee, doctorscharge);
tdbo.treatmentInfo(treatment);
MessageBox.Show("The patient's dental treatment information was added successfully.", "Save Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex2)
{
MessageBox.Show("This Treatment Code has already been entered.", "Duplicate Entry", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnPaymentSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtPaymentInvoiceNo.Text))
{
MessageBox.Show("An Invoice No should be entered.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrWhiteSpace(txtPaymentTreatmentCode.Text))
{
MessageBox.Show("The treatment ID should be entered.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrWhiteSpace(txtPaymentPatientID.Text))
{
MessageBox.Show("The patient's ID should be entered.", "Warning!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string patientid = txtPaymentPatientID.Text;
int registrationfee = 0;
if (chkboxPaymentNewPatient.Checked == true)
{
PatientDBO pdbo2 = new PatientDBO();
Patient patient = pdbo2.findPatient(patientid);
lblPaymentRegistrationFee.Text = "Registration Fee:- " + patient.getRegistrationFee().ToString();
registrationfee = patient.getRegistrationFee();
}
else if (chkboxPaymentNewPatient.Checked == false)
{
lblPaymentRegistrationFee.Text = " ";
registrationfee = 0;
}
;
string treatmentcode = txtPaymentTreatmentCode.Text;
TreatmentDBO tdbo = new TreatmentDBO();
Treatment treatment = tdbo.findCharges(treatmentcode);
lblPaymentDoctorsCharge.Text = "Doctor's charge:- " + treatment.getDoctorsCharge().ToString();
lblPaymentStandardFee.Text = "Treatment Standard Fee:- " + treatment.getStandardFee().ToString();
lblPaymentTotalCharge.Text = "Total Charge:- " + (treatment.getDoctorsCharge() + registrationfee + treatment.getStandardFee()).ToString();
int doctorscharge = treatment.getDoctorsCharge();
int treatmentfee = treatment.getStandardFee();
int totalcharge = treatment.getDoctorsCharge() + treatment.getStandardFee() + registrationfee;
try
{
PaymentDBO pdbo = new PaymentDBO();
string invoiceno = txtPaymentInvoiceNo.Text;
//string patientid = txtPaymentPatientID.Text; (temp)
string paymentmode = "None"; if (rdobtnPaymentCash.Checked == true)
{
paymentmode = "Cash";
}
else if (rdobtnPaymentCreditCard.Checked == true)
{
paymentmode = "Credit Card";
}
else if (rdobtnPaymentCheque.Checked == true)
{
paymentmode = "Cheque";
}
;
Payment payment = new Payment(invoiceno, treatmentcode, patientid, paymentmode, doctorscharge, treatmentfee, totalcharge, registrationfee);
pdbo.paymentInfo(payment);
MessageBox.Show("Payment information has been recorded successfully.", "Save Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex2)
{
MessageBox.Show("This Invoice ID has already been generated.", "Duplicate Entry", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void insertTreatment(Treatment w)
{
string SqlStr = string.Format("insert into Treatments(Idtreatment, IdCustomer, NameCustomer, IdWorker, NameWorker,Time, Date,IdCar,KindCar,Total)values({0},{1},'{2}',{3},'{4}','{5}','{6}',{7},'{8}',{9})", w.Id, w.CustometId, w.CustomerName, w.WorkerId, w.WorkerName, w.Date, w.Time, w.CarId, w.CarKind, w.Total);
InsDelUpd(SqlStr);
}
