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