public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CRReciptPayment rpt = new CRReciptPayment();
rpt.Site = this.Site;
return(rpt);
}
private void pbSave_Click(object sender, EventArgs e)
{
if (txtMoney.Text == "" || txtChange.Text == "")
{
MessageBox.Show("Please fill in the data");
}
else if (Convert.ToDouble(txtMoney.Text) < Convert.ToDouble(txtTotalPayment.Text))
{
MessageBox.Show("less money");
}
else
{
DialogResult dialogResult = MessageBox.Show("Do You Want To Save the Data ?", "Save", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
string info = "";
try
{
info = con.openconnection();
if (info == "OK")
{
string query = "update Patient.Payment set isPay = '1' where Id_Payment = @idpayment";
SqlCommand com = new SqlCommand(query, con.con);
//com.Parameters.AddWithValue("@ispay", "1");
com.Parameters.AddWithValue("@idpayment", txtIdPayment.Text);
if (com.ExecuteNonQuery() > 0)
{
info = "OK";
MessageBox.Show("Success Save data");
FCashierReciptPayment fcrp = new FCashierReciptPayment();
CRReciptPayment crrp = new CRReciptPayment();
TextObject totreatment = (TextObject)crrp.ReportDefinition.Sections["Section2"].ReportObjects["IdTreatment"];
totreatment.Text = txtIdTreatment.Text;
TextObject topatientname = (TextObject)crrp.ReportDefinition.Sections["Section2"].ReportObjects["PatientName"];
topatientname.Text = txtPatientName.Text;
TextObject todoctorname = (TextObject)crrp.ReportDefinition.Sections["Section2"].ReportObjects["DoctorName"];
todoctorname.Text = txtDoctorName.Text;
TextObject todiagnose = (TextObject)crrp.ReportDefinition.Sections["Section2"].ReportObjects["Diagnose"];
todiagnose.Text = txtDiagnose.Text;
//details drug
TextObject topaydrug = (TextObject)crrp.ReportDefinition.Sections["Section4"].ReportObjects["PaymentDrug"];
topaydrug.Text = txtPaymentDrug.Text;
TextObject topaydoc = (TextObject)crrp.ReportDefinition.Sections["Section4"].ReportObjects["PaymentDoctor"];
topaydoc.Text = txtPaymentDoctor.Text;
TextObject totalpay = (TextObject)crrp.ReportDefinition.Sections["Section4"].ReportObjects["TotalPayment"];
totalpay.Text = txtTotalPayment.Text;
TextObject tomoney = (TextObject)crrp.ReportDefinition.Sections["Section4"].ReportObjects["Moneyy"];
tomoney.Text = txtMoney.Text;
TextObject tochange = (TextObject)crrp.ReportDefinition.Sections["Section4"].ReportObjects["Changee"];
tochange.Text = txtChange.Text;
/*
* string query1 = "select a.Id_RecipeDetail, b.DrugName, a.Qty, a.Dose from Recipe.RecipeDetail a join Recipe.Drug b on a.Id_Drug = b.Id_Drug join Recipe.Recipe c on c.Id_Recipe = a.Id_Recipe join Patient.Treatment x on x.Id_Recipe = c.Id_Recipe where Id_Treatment = '" + txtIdTreatment.Text + "'";
* SqlCommand com1 = new SqlCommand(query1, con.con);
* SqlDataReader dr1 = com1.ExecuteReader();
* if (dr1.HasRows)
* {
* DataTable dt = new DataTable();
* dt.Load(dr1);
* }
*/
fcrp.crViewPayment.ReportSource = crrp;
fcrp.crViewPayment.Refresh();
fcrp.Show();
this.Hide();
txtTotalPayment.Clear();
txtPaymentDrug.Clear();
txtPaymentDoctor.Clear();
txtIdTreatment.Clear();
txtIdPayment.Clear();
txtPatientName.Clear();
txtDoctorName.Clear();
txtDiagnose.Clear();
txtDateTreatment.Clear();
txtMoney.Focus();
//txtIdPayment.Text = autoid();
}
else
{
info = "Gagal";
}
}
if (con.closeconnection() == "OK")
{
info = "OK";
}
}
catch (Exception xe)
{
MessageBox.Show(xe.Message);
}
}
}
}
