private void SaveBill() { try { if (lblGrandTotal.Text == "0.00") { MessageBox.Show("Please add atleast one service for patient and retry again!", "Information Required", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (txtName.Text == "") { MessageBox.Show("Please enter the patient id and retry again!", "Information Required", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } Conn obCon = new Conn(); SqlConnection ob = new SqlConnection(obCon.strCon); SqlCommand cmd = new SqlCommand("SP_SAVE_tblOPBill", ob); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BillID", SqlDbType.VarChar, 50); cmd.Parameters.Add("@BillDate", SqlDbType.VarChar, 50); cmd.Parameters.Add("@SubTotal", SqlDbType.Float); cmd.Parameters.Add("@Discount", SqlDbType.Float); cmd.Parameters.Add("@Recieved", SqlDbType.Float); cmd.Parameters.Add("@Exchanged", SqlDbType.Float); cmd.Parameters.Add("@GrandTotal", SqlDbType.Float); cmd.Parameters.Add("@PatientName", SqlDbType.VarChar, 50); cmd.Parameters.Add("@Age", SqlDbType.VarChar, 50); cmd.Parameters.Add("@Sex", SqlDbType.VarChar, 50); cmd.Parameters[0].Value = txtBillNo.Text; cmd.Parameters[1].Value = dateTimePicker1.Text; cmd.Parameters[2].Value = txtSubTotal.Text; cmd.Parameters[3].Value = txtDiscount.Text; cmd.Parameters[4].Value = txtRecieved.Text; cmd.Parameters[5].Value = txtExchanged.Text; cmd.Parameters[6].Value = lblGrandTotal.Text; cmd.Parameters[7].Value = txtName.Text; cmd.Parameters[8].Value = txtAge.Text; if (optMale.Checked == true) { cmd.Parameters[9].Value = "Male"; } else if (optFemale.Checked == true) { cmd.Parameters[9].Value = "Female"; } ob.Open(); cmd.ExecuteNonQuery(); ob.Close(); SaveService(); SavePatient(); DialogResult dr = MessageBox.Show("Bill created successfully! Do you want to print it?", "Print", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { ReportViewer.ViewReport frm = new GHospital_Care.ReportViewer.ViewReport("OPBill", txtBillNo.Text); frm.Show(); } SetNew(); } catch (Exception error) { MessageBox.Show("Failed to save bill! " + error.Message.ToString(), "Failed", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnPrint_Click(object sender, EventArgs e) { ReportViewer.ViewReport frm = new GHospital_Care.ReportViewer.ViewReport("OPBill", txtBillNo.Text); frm.Show(); }