private void RefundViewbtn_Click(object sender, EventArgs e) { if (RefundViewrbtn.Checked == true) { BalloonKingdomDataSetTableAdapters.Rental_RefundTableAdapter rf = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Rental_RefundTableAdapter(); DataTable datatable = rf.View(); RefundMasterlist rpt = new RefundMasterlist(); RefundView view = new RefundView(); view.SetDataSource(datatable); rpt.RefundViewAll(view); rpt.Show(); } else { if (RefundCOFtxt.Text != "") { int a = Convert.ToInt32(RefundCOFtxt.Text); BalloonKingdomDataSetTableAdapters.Rental_RefundTableAdapter rf = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Rental_RefundTableAdapter(); DataTable datatable = rf.Refund(a); RefundMasterlist rpt = new RefundMasterlist(); RefundView view = new RefundView(); view.SetDataSource(datatable); rpt.RefundViewAll(view); rpt.Show(); } else { MessageBox.Show("Enter COF number first.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void ProcRefundBtn_Click(object sender, EventArgs e) { SqlCommand getref = new SqlCommand("Select distinct [Refund Amount] from [Rental Checklist] where [COF Number]=" + "'" + COFNumCHLbl.Text + "'", conn); double refun = Convert.ToDouble(getref.ExecuteScalar()); string id; int id2 = 0, a = 0; SqlCommand cmd5 = new SqlCommand("Select * from [Rental Refund]", conn); SqlDataReader dr8 = cmd5.ExecuteReader(); while (dr8.Read()) { id = dr8["Rental Refund ID"].ToString(); id2 = Convert.ToInt32(id); if (a < id2) { a = id2; } } dr8.Close(); a++; BalloonKingdomDataSetTableAdapters.Rental_RefundTableAdapter addref = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Rental_RefundTableAdapter(); addref.AddRentalRefund(a, Convert.ToInt32(COFNumCHLbl.Text), DateTime.Today, DateTime.Today, Convert.ToDecimal(refun), Convert.ToDecimal(RentAmtLbl.Text)); }