protected void Button2_Click(object sender, EventArgs e)
{
ct = new cancelticket();
ct.bookingid = txtbookid.Text;
if (CancelticketBO.validatebooking(ct.bookingid))
{
List <cancelticket> ct1 = CancelticketBO.bookingcancel(ct.bookingid);
DetailsView1.DataSource = ct1;
DetailsView1.DataBind();
}
else
{
Label1.Text = "Please Enter Correct Booking Number";
}
}
public static List <cancelticket> cancelbooking(SqlParameter p)
{
Con.Open();
cmd = new SqlCommand("sp_bookingdisplay", Con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(p);
SqlDataReader R = cmd.ExecuteReader();
List <cancelticket> L1 = new List <cancelticket>();
cancelticket F = null;
while (R.Read())
{
F = new cancelticket();
F.bookingid = R[0].ToString();
F.bookingdate = DateTime.Parse(R[1].ToString());
F.journeydate = DateTime.Parse(R[2].ToString());
F.from = R[3].ToString();
F.to = R[4].ToString();
F.totalfare = double.Parse(R[5].ToString());
}
Con.Close();
TimeSpan t = new TimeSpan();
t = F.journeydate.Subtract(DateTime.Now);
int days = t.Days;
if (days > 10)
{
F.cancellationcharge = (F.totalfare) * (0.1);
}
else if (days > 5 && days <= 10)
{
F.cancellationcharge = (F.totalfare) * (0.2);
}
else if (days > 1 && days < 5)
{
F.cancellationcharge = (F.totalfare) * (0.5);
}
F.refundamount = F.totalfare - F.cancellationcharge;
L1.Add(F);
return(L1);
}
