private void BindTicketDetails()
{
FlightBAL objFlightsBAL = new FlightBAL();
DataSet dsFlights = new DataSet();
dsFlights = objFlightsBAL.GetCarDetaisl(txtRefNo.Text,"");
if (dsFlights.Tables[0].Rows.Count > 0)
{
//lblCarName.Text = dsFlights.Tables[0].Rows[1]["CarName"].ToString();
lblCarRefNo.Text = dsFlights.Tables[0].Rows[0]["ReferanceId"].ToString();
lblStatus.Text = dsFlights.Tables[0].Rows[0]["Status"].ToString();
//if (dsFlights.Tables[0].Rows[0]["ReferenceNo"].ToString() == "1")
//{
// lblStatus.Text ="Booked";
//}
lblAddress.Text = dsFlights.Tables[0].Rows[0]["Address"].ToString();
lblCity1.Text = dsFlights.Tables[0].Rows[0]["City_Car"].ToString();
lblJourneyDate.Text = dsFlights.Tables[0].Rows[0]["TravelDate"].ToString();
lblFirstName.Text = dsFlights.Tables[0].Rows[0]["Name"].ToString();
lblMobileNo.Text = dsFlights.Tables[0].Rows[0]["MobileNo"].ToString();
lblEmailId.Text = dsFlights.Tables[0].Rows[0]["EmailId"].ToString();
lblAdd.Text = dsFlights.Tables[0].Rows[0]["Address"].ToString();
lblCity.Text = dsFlights.Tables[0].Rows[0]["City"].ToString();
lblPinCode.Text = dsFlights.Tables[0].Rows[0]["ZipCode"].ToString();
lblState.Text = dsFlights.Tables[0].Rows[0]["State"].ToString();
lblPickupTime.Text = dsFlights.Tables[0].Rows[0]["PickupTime"].ToString();
lblCarName.Text = dsFlights.Tables[0].Rows[0]["CarName"].ToString();
}
}
protected void btnSignIn_Click(object sender, EventArgs e)
{
pnlFlightTicket.Visible = false;
pnlViewticket.Visible = false;
pnlhotelTicket.Visible = false;
Panel1.Visible = false;
Panel10.Visible = false;
if (ddlType.SelectedItem.Text == "Bus")
{
pnlFlightTicket.Visible = false;
pnlViewticket.Visible = false;
pnlhotelTicket.Visible = false;
Panel1.Visible = true;
try
{
#region Bitla
////objBitlaAPILayer.TicketNumber = txtMBRefNo.Text.ToString();
////DataSet dsBitla = objBitlaAPILayer.GetTicketDetails();
////GridView1.DataSource = dsBitla;
////GridView1.DataBind();
//#endregion
//#region Kesneni
//DataSet dsKesineni = objKesineniAPILayer.CancelTickets("843254",
// "RajuKatare", "RajuKatare", "05/25/2012", "2,1");
//GridView1.DataSource = dsKesineni;
//GridView1.DataBind();
//#endregion
//#region AbhiBus
//DataTable dsAbhiBus = objAbhiBusAPILayer.GetTicketInfo("RajuKatare");
//GridView1.DataSource = dsAbhiBus;
//GridView1.DataBind();
#endregion
objManabusBAL = new ClsBAL();
objManabusBAL.manabusRefNo = txtMBRefNo.Text;
ObjDataset = (DataSet)objManabusBAL.GetTicketIdByOnewayManabusRefNo();
if (ObjDataset != null)
{
if (ObjDataset.Tables.Count > 0)
{
if (ObjDataset.Tables[0].Rows.Count > 0)
{
string travelName = ObjDataset.Tables[0].Rows[0]["TravelOPName"].ToString();
string api = ObjDataset.Tables[0].Rows[0]["APIName"].ToString();
gvView.DataSource = ObjDataset.Tables[0];
GetCancellationPolicy(travelName);
if (api == "Kesineni")
{
imgKesineni.Visible = true;
}
gvView.DataBind();
Panel1.Visible = false;
pnlViewticket.Visible = true;
}
else
{
lblMsg.Text = "Invalid Ref NO";
lblMsg.ForeColor = System.Drawing.Color.Red;
Panel1.Visible = true;
pnlViewticket.Visible = false;
}
}
else
{
lblMsg.Text = "Invalid Ref NO";
lblMsg.ForeColor = System.Drawing.Color.Red;
Panel1.Visible = true;
pnlViewticket.Visible = false;
}
}
else
{
lblMsg.Text = "Invalid Ref NO";
lblMsg.ForeColor = System.Drawing.Color.Red;
Panel1.Visible = true;
pnlViewticket.Visible = false;
}
}
catch (Exception)
{
throw;
}
finally
{
if (ObjDataset != null)
{
ObjDataset = null;
}
}
}
else if (ddlType.SelectedItem.Text == "Flight")
{
pnlFlightTicket.Visible = true;
pnlViewticket.Visible = false;
pnlhotelTicket.Visible = false;
Panel1.Visible = false;
Panel10.Visible = false;
try
{
DataSet dsFlights = new DataSet();
FlightBAL objFlightsBAL = new FlightBAL();
dsFlights = objFlightsBAL.GetDomesticFlightDetails(txtMBRefNo.Text.Trim());
if (dsFlights.Tables[0].Rows.Count > 0)
{
string customerDetails = dsFlights.Tables[0].Rows[0]["Customer_Details"].ToString();
string[] strArryCustDet = customerDetails.Split('|');
lblName.Text = strArryCustDet[0] + strArryCustDet[1] + " " + strArryCustDet[2];
lblTel.Text = dsFlights.Tables[0].Rows[0]["telephone"].ToString();
lblEmailAddress.Text = dsFlights.Tables[0].Rows[0]["emailAddress"].ToString();
Session["EmailId"] = dsFlights.Tables[0].Rows[0]["emailAddress"].ToString();
lblPNR.Text = dsFlights.Tables[0].Rows[0]["ReferenceNo"].ToString();
lblOrigin.Text = dsFlights.Tables[0].Rows[0]["DepartureAirportCode"].ToString();
lblDestination.Text = dsFlights.Tables[0].Rows[0]["ArrivalAirportCode"].ToString();
lblAirlineName.Text = dsFlights.Tables[0].Rows[0]["airlineName"].ToString();
img.ImageUrl = dsFlights.Tables[0].Rows[0]["imageFileName"].ToString();
lblBookingTime.Text = dsFlights.Tables[0].Rows[0]["CreatedDate"].ToString();
lblFlightNumber.Text = dsFlights.Tables[0].Rows[0]["FlightNumber"].ToString();
string DepartureDatetime = dsFlights.Tables[0].Rows[0]["DepartureDateTime"].ToString();
string[] strArryDeptDatetime = DepartureDatetime.Split('T');
DateTime dt = Convert.ToDateTime(strArryDeptDatetime[0].ToString());
string date = dt.ToString("dd/MM/yyyy");
lblDepartureDate.Text = date.ToString();
// lblDepartureDate.Text = strArryDeptDatetime[0].ToString();
lblDepartureTime.Text = strArryDeptDatetime[1].ToString();
string ArrivalDatetime = dsFlights.Tables[0].Rows[0]["ArrivalDateTime"].ToString();
string[] strArrivalDatetime = ArrivalDatetime.Split('T');
DateTime dt1 = Convert.ToDateTime(strArrivalDatetime[0].ToString());
string date1 = dt1.ToString("dd/MM/yyyy");
lblArrivalDate.Text = date1.ToString();
// lblArrivalDate.Text = strArryDeptDatetime[0].ToString();
lblArrivalTime.Text = strArrivalDatetime[1].ToString();
lblPNRNo.Text = dsFlights.Tables[0].Rows[0]["ReferenceNo"].ToString();
lblAirlinePNR.Text = dsFlights.Tables[0].Rows[0]["AirlinePNR"].ToString();
lblPsngrMobileNo.Text = dsFlights.Tables[0].Rows[0]["telephone"].ToString();
string[] strCusDetArr = customerDetails.Split(';');
string indCustDet = string.Empty;
DataTable dtPsgrDet = new DataTable();
dtPsgrDet.Columns.Add("Name", typeof(string));
dtPsgrDet.Columns.Add("Type", typeof(string));
dtPsgrDet.Columns.Add("Age", typeof(string));
for (int i = 0; i < strCusDetArr.Length; i++)
{
indCustDet = strCusDetArr[i];
string[] strArryCustDet1 = indCustDet.Split('|');
DataRow dr = dtPsgrDet.NewRow();
dr["Name"] = strArryCustDet1[0] + strArryCustDet1[1] + " " + strArryCustDet1[2];
dr["Type"] = strArryCustDet1[3];
dr["Age"] = "-";
dtPsgrDet.Rows.Add(dr);
}
gdvPassengerDetails.DataSource = dtPsgrDet;
gdvPassengerDetails.DataBind();
lblPassengerType.Text = strArryCustDet[3];
lblPassengerCnt.Text = strCusDetArr.Length.ToString();
lblBasicFare.Text = dsFlights.Tables[0].Rows[0]["ActualBasefare"].ToString();
lblTaxes.Text = dsFlights.Tables[0].Rows[0]["Tax"].ToString();
string Tcharge = dsFlights.Tables[0].Rows[0]["Tcharge"].ToString();
lblServiceTax.Text = (Convert.ToDouble(dsFlights.Tables[0].Rows[0]["STax"]) + Convert.ToDouble(Tcharge) + Convert.ToDouble(dsFlights.Tables[0].Rows[0]["TMarkUp"])).ToString();
lblTotal.Text = (Convert.ToDouble(lblTaxes.Text) + Convert.ToDouble(lblServiceTax.Text) + Convert.ToDouble(lblBasicFare.Text)).ToString();
// + Convert.ToDouble(Tcharge)).ToString();
//- Convert.ToDouble(dsFlights.Tables[0].Rows[0]["TDiscount"].ToString())).ToString();
// pnlViewticket.Visible = true;
printroundtrip.Visible = false;
lblMsg.Text = "";
if (dsFlights.Tables[0].Rows.Count == 2)
{
//return
if (dsFlights.Tables[0].Rows.Count > 0)
{
lblMainMSg.Text = "";
printroundtrip.Visible = true;
lblAirlineNamereturn.Text = dsFlights.Tables[0].Rows[1]["airlineName"].ToString();
//img.ImageUrl = dsFlights.Tables[0].Rows[0]["imageFileName"].ToString();
lblFlightNumberreturn.Text = dsFlights.Tables[0].Rows[1]["FlightNumber"].ToString();
lblOriginRet.Text = dsFlights.Tables[0].Rows[1]["DepartureAirportCode"].ToString();
lblDestinationRet.Text = dsFlights.Tables[0].Rows[1]["ArrivalAirportCode"].ToString();
string DepartureDatetimeRet = dsFlights.Tables[0].Rows[1]["DepartureDateTime"].ToString();
string[] strArryDeptDatetimeRet = DepartureDatetimeRet.Split('T');
DateTime dt3 = Convert.ToDateTime(strArryDeptDatetimeRet[0].ToString());
string date3 = dt3.ToString("dd/MM/yyyy");
lblDepartureDatereturn.Text = date3.ToString();
// lblDepartureDatereturn.Text = dt3.ToLongDateString();
lblDepartureTimereturn.Text = strArryDeptDatetimeRet[1].ToString();
string ArrivalDatetimeRet = dsFlights.Tables[0].Rows[1]["ArrivalDateTime"].ToString();
string[] strArrivalDatetimeRet = ArrivalDatetimeRet.Split('T');
DateTime dt4 = Convert.ToDateTime(strArrivalDatetimeRet[0].ToString());
string date4 = dt4.ToString("dd/MM/yyyy");
lblArrivalDatereturn.Text = date4.ToString();
lblArrivalTimereturn.Text = strArrivalDatetimeRet[1].ToString();
// lblPNRNoreturn.Text = dsFlights.Tables[0].Rows[1]["ReferenceNo"].ToString();
string Afareret = dsFlights.Tables[0].Rows[0]["ActualBasefareRet"].ToString();
string Tret = dsFlights.Tables[0].Rows[0]["TaxRet"].ToString();
string Sts = (Convert.ToDouble(dsFlights.Tables[0].Rows[0]["STaxRet"]) + Convert.ToDouble(dsFlights.Tables[0].Rows[0]["TchargeRet"])).ToString();
string totret = (Convert.ToDouble(Afareret) + Convert.ToDouble(Tret) + Convert.ToDouble(Sts)).ToString(); //+ Convert.ToDouble(dsFlights.Tables[0].Rows[0]["Tcharge"].ToString())).ToString();
//- Convert.ToDouble(dsFlights.Tables[0].Rows[0]["TDiscountRet"].ToString())).ToString();
lblBasicFare.Text = (Convert.ToDecimal(lblBasicFare.Text) + Convert.ToDecimal(Afareret)).ToString();
lblTaxes.Text = (Convert.ToDecimal(lblTaxes.Text) + Convert.ToDecimal(Tret)).ToString();
lblServiceTax.Text = (Convert.ToDecimal(lblServiceTax.Text) + Convert.ToDecimal(Sts)).ToString();
lblTotal.Text = (Convert.ToDecimal(lblTotal.Text) + Convert.ToDecimal(totret)).ToString("####0.00");
}
}
}
else
{
lblMsg.Text = "Invalid Reference No";
lblMsg.ForeColor = System.Drawing.Color.Red;
pnlViewticket.Visible = false;
}
}
catch (Exception ex)
{
throw;
}
}
else if (ddlType.SelectedItem.Text == "Hotel")
{
pnlFlightTicket.Visible = false;
pnlViewticket.Visible = false;
pnlhotelTicket.Visible = true;
Panel1.Visible = false;
Panel10.Visible = false;
try
{
HotelBAL objTicket = new HotelBAL();
objTicket.ReferenceNo = txtMBRefNo.Text.ToString().Trim().ToString();
DataSet dsTicket = objTicket.GetHotelProvisional();
if (dsTicket == null) { lblMsg.Text = "Invalid Ref No."; return; }
if (dsTicket.Tables.Count == 0) { lblMsg.Text = "Invalid Ref No."; return; }
if (dsTicket.Tables[0].Rows.Count == 0) { lblMsg.Text = "Invalid Ref No."; return; }
DataRow drTicketRow = dsTicket.Tables[0].Rows[0];
lblHotelRefNo.Text = drTicketRow["ReferenceNo"].ToString();
lblStatus.Text = drTicketRow["Status"].ToString();
lblHotelName.Text = drTicketRow["HotelName"].ToString();
lblarzoorefno.Text = drTicketRow["BookingRefNo"].ToString();
lblAddress.Text = drTicketRow["HotelAddress"].ToString();
lblHotelCity.Text = drTicketRow["HotelCity"].ToString();
lblCheckIn.Text = drTicketRow["CheckInDate"].ToString();
lblCheckOut.Text = drTicketRow["CheckOutDate"].ToString();
lblRoomType.Text = drTicketRow["RoomType"].ToString();
lblStar.Text = drTicketRow["HotelStar"].ToString() + " Star";
lblNoOfRooms.Text = drTicketRow["NoOfRooms"].ToString();
lblPaxGreaterThan12.Text = drTicketRow["NoOfAdults"].ToString();
lblPaxLessThan12.Text = drTicketRow["NoOfChildren"].ToString();
lblBookedDate.Text = drTicketRow["BookedDate"].ToString();
lblHotelContactDetails.Text = drTicketRow["ContactNumbers"].ToString() + " , Fax Nos: " + drTicketRow["FaxNumbers"].ToString();
lblTotalPrice.Text = drTicketRow["HotelTotalFare"].ToString() + "~" + drTicketRow["HotelTotlaFareDetails"].ToString();/////////////
lblTitle.Text = drTicketRow["Title"].ToString();
lblFirstName.Text = drTicketRow["FirstName"].ToString();
lblMiddleName.Text = drTicketRow["MiddleName"].ToString();
lblLastName.Text = drTicketRow["LastName"].ToString();
lblMobileNo.Text = drTicketRow["MobileNumber"].ToString();
lblEmailId.Text = drTicketRow["EmailId"].ToString();
lblAdd.Text = drTicketRow["CustAddressLine"].ToString();
lblState.Text = drTicketRow["CustState"].ToString();
lblPinCode.Text = drTicketRow["CustZipCode"].ToString();
lblCity.Text = drTicketRow["CustCity"].ToString();
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
throw;
}
}
else if (ddlType.SelectedItem.Text == "Cabs")
{
pnlFlightTicket.Visible = false;
pnlViewticket.Visible = false;
pnlhotelTicket.Visible = false;
Panel1.Visible = false;
Panel10.Visible = false;
pnlCabTicket.Visible = true;
Panel2.Visible = true;
try
{
FlightBAL objFlightsBAL = new FlightBAL();
DataSet dsFlights = new DataSet();
dsFlights = objFlightsBAL.GetCarDetaisl(txtMBRefNo.Text, "");
if (dsFlights.Tables[0].Rows.Count > 0)
{
//lblCarName.Text = dsFlights.Tables[0].Rows[1]["CarName"].ToString();
lblCarRefNo.Text = dsFlights.Tables[0].Rows[0]["ReferanceId"].ToString();
lblCabstatus.Text = dsFlights.Tables[0].Rows[0]["Status"].ToString();
//if (dsFlights.Tables[0].Rows[0]["ReferenceNo"].ToString() == "1")
//{
// lblStatus.Text ="Booked";
//}
lblCabAddress.Text = dsFlights.Tables[0].Rows[0]["Address"].ToString();
lblCity1.Text = dsFlights.Tables[0].Rows[0]["City_Car"].ToString();
lblJourneyDate.Text = dsFlights.Tables[0].Rows[0]["TravelDate"].ToString();
lblCabName.Text = dsFlights.Tables[0].Rows[0]["CarName"].ToString();
lblCabMobile.Text = dsFlights.Tables[0].Rows[0]["MobileNo"].ToString();
lblCabEmail.Text = dsFlights.Tables[0].Rows[0]["EmailId"].ToString();
lblCabAddress1.Text = dsFlights.Tables[0].Rows[0]["Address"].ToString();
lblCabCity.Text = dsFlights.Tables[0].Rows[0]["City"].ToString();
lblCabPincode.Text = dsFlights.Tables[0].Rows[0]["ZipCode"].ToString();
lblCabState.Text = dsFlights.Tables[0].Rows[0]["State"].ToString();
lblPickupTime.Text = dsFlights.Tables[0].Rows[0]["PickupTime"].ToString();
lblCarName.Text = dsFlights.Tables[0].Rows[0]["CarName"].ToString();
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
throw;
}
}
}
private void car()
{
FlightBAL objTicket = new FlightBAL();
DataSet dsFlights = new DataSet();
Session["Order_Id"] = Session["refno"].ToString();
objTicket.RefNo = Session["Order_Id"].ToString();
DataSet dsTicket = objTicket.GetCarDetaisl(Session["refno"].ToString(), Session["CardetailsId"].ToString());
if (dsTicket != null)
{
Name = dsTicket.Tables[0].Rows[0]["Name"].ToString();
address = dsTicket.Tables[0].Rows[0]["Address"].ToString();
State = "AP";
City = "Hyderabad";
PostalCode = "500004";
Email = dsTicket.Tables[0].Rows[0]["EmailId"].ToString();
Mobilenumber = dsTicket.Tables[0].Rows[0]["MobileNo"].ToString();
Country = "IND";
val = "true";
}
}