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