protected void btnSubmit_Click(object sender, EventArgs e)
{
Database.frmLogin obj = new Database.frmLogin();
int total = Convert.ToInt32(Price.Text.ToString()) * Convert.ToInt32(Tickets.Text.ToString());
int y = obj.Booking(Convert.ToInt32(PlaneNo.Text.ToString()), PlaneName.Text.ToString(), Departure.Text.ToString(), Destination.Text.ToString(), Convert.ToInt32(Price.Text.ToString()), CustomerName.Text.ToString(), Convert.ToInt32(Tickets.Text.ToString()), Sdate.Text.ToString(), total);
rslt.InnerHtml = "Ticket No is = " + y;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Database.frmLogin obj = new Database.frmLogin();
obj.sendMsg(Name.Text.ToString(), Email.Text.ToString(), Msg.Text.ToString());
rslt.InnerHtml = "Thanks for Contact Us we will give feed Back ";
Name.Text = "";
Email.Text = "";
Msg.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
Database.frmLogin obj = new Database.frmLogin();
DataTable tbl = new DataTable();
if (Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
tbl = obj.BookPlane(id);
if (tbl.Rows.Count > 0)
{
PlaneNo.Text = tbl.Rows[0]["PlaneNo"].ToString();
PlaneName.Text = tbl.Rows[0]["PlaneName"].ToString();
Departure.Text = tbl.Rows[0]["Departure"].ToString();
Destination.Text = tbl.Rows[0]["Destination"].ToString();
Price.Text = tbl.Rows[0]["Price"].ToString();
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Database.frmLogin obj = new Database.frmLogin();
if (obj.addPlane(Convert.ToInt32(PlaneNo.Text.ToString()), PlaneName.Text.ToString(), Departure.Text.ToString(), Destination.Text.ToString(), Convert.ToInt32(Price.Text.ToString())))
{
rslt.InnerHtml = "Record Saved";
}
else
{
rslt.InnerHtml = "check theRecord";
}
PlaneNo.Text = "";
PlaneName.Text = "";
Destination.Text = "";
Departure.Text = "";
Price.Text = "";
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
String Data = "<table><tr><td>Plane No</td><td>Plane Name</td><td>Departure</td><td>Destination</td><td>Price </td><td>Booking</td></tr>";
DataTable tbRecord = new DataTable();
Database.frmLogin obj = new Database.frmLogin();
tbRecord = obj.ViewSearchPlane(Departure.Text.ToString(), Destination.Text.ToString());
if (tbRecord.Rows.Count > 0)
{
for (int x = 0; x < tbRecord.Rows.Count; x++)
{
Data = Data + "<tr><td>" + tbRecord.Rows[x]["PlaneNo"] + "</td><td>" + tbRecord.Rows[x]["PlaneName"] + "</td><td>" + tbRecord.Rows[x]["Departure"] + "</td><td>" + tbRecord.Rows[x]["Destination"] + "</td><td>" + tbRecord.Rows[x]["Price"] + "</td><td><a href='Booking.aspx?id=" + tbRecord.Rows[x]["id"] + "' class='btn btn-primary'>Booking</a></td></tr>";
}
PlaneRecord.InnerHtml = Data;
}
else
{
PlaneRecord.InnerHtml = "Record Not Found";
}
}
