public string InsertProvisional(string referenceNo, string hotelCity, DateTime checkIn, DateTime checkOut, int noOfRooms, int? noOfAdults
, int? noOfChildren, string roomStayCandidate, string hotelId, string webService, string ratePlanType, string roomTypeCode, string fromAllocation
, string allocationId, string roomType, string wsKey, string roomBasis, string title, string firstName, string middleName, string lastName
, string mobileNumber, string emailId, string custAddressLine, string custCity, string custZipCode, string custState, string custCountry, string comment
, int? createdBy, int? modifiedBy, string hotelName, string hotelAddress, string hotelStar, string hotelTotalFare, string hotelTotalFareDetails
, string hotelTotalFareAgent, string hotelTotalFareDetailsAgent, string markUpFareAgent)
{
try
{
string strReturn = "";
HotelBAL obj = new HotelBAL();
obj.ReferenceNo = referenceNo;
obj.HotelCity = hotelCity;
obj.CheckIn = checkIn;
obj.CheckOut = checkOut;
obj.NoOfRooms = noOfRooms;
obj.NoOfAdults = noOfAdults;
obj.NoOfChildren = noOfChildren;
obj.RoomStayCandidate = roomStayCandidate;
obj.HotelId = hotelId;
obj.WebService = webService;
obj.RatePlanType = ratePlanType;
obj.RoomTypeCode = roomTypeCode;
obj.FromAllocation = fromAllocation;
obj.AllocationId = allocationId;
obj.RoomType = roomType;
obj.WsKey = wsKey;
obj.RoomBasis = roomBasis;
obj.Title = title;
obj.FirstName = firstName;
obj.MiddleName = middleName;
obj.LastName = lastName;
obj.MobileNumber = mobileNumber;
obj.EmailId = emailId;
obj.CustAddressLine = custAddressLine;
obj.CustCity = custCity;
obj.CustZipCode = custZipCode;
obj.CustState = custState;
obj.CustCountry = custCountry;
obj.Comment = comment;
obj.CreatedBy = createdBy;
obj.ModifiedBy = modifiedBy;
obj.HotelName = hotelName;
obj.HotelAddress = hotelAddress;
obj.HotelStar = hotelStar;
obj.HotelTotalFare = hotelTotalFare;
obj.HotelTotlaFareDetails = hotelTotalFareDetails;
bool b = obj.AddHotelProvisionalAgent(hotelTotalFareAgent, hotelTotalFareDetailsAgent, markUpFareAgent);
if (b) { strReturn = "Success"; }
else { strReturn = ""; }
return strReturn;
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
throw;
}
}
public string InsertHotelBooking(int provisionalId, string wsKey, string extGuestTotal, string roomTotal, string serviceTaxTotal, string bookingStatus,
string bookingRemarks, string bookingRefNo, string bookingTrn, string discount, string contactNumbers, string faxNumbers, int? createdBy)
{
try
{
string strReturn = "";
HotelBAL objHBooking = new HotelBAL();
objHBooking.ProvisionalId = provisionalId;
objHBooking.WsKey = wsKey;
objHBooking.ExtGuestTotal = extGuestTotal;
objHBooking.RoomTotal = roomTotal;
objHBooking.ServiceTaxTotal = serviceTaxTotal;
objHBooking.BookingStatus = bookingStatus;
objHBooking.BookingRemarks = bookingRemarks;
objHBooking.BookingRefNo = bookingRefNo;
objHBooking.BookingTrn = bookingTrn;
objHBooking.Discount = discount;
objHBooking.ContactNumbers = contactNumbers;
objHBooking.FaxNumbers = faxNumbers;
objHBooking.CreatedBy = createdBy;
bool b = objHBooking.AddHotelBooking();
if (b) { strReturn = "Success"; }
else { strReturn = ""; }
return strReturn;
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
throw;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
HotelBAL objTicket = new HotelBAL();
objTicket.ReferenceNo = txtRefNo.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();
lblarzoorefno.Text = drTicketRow["BookingRefNo"].ToString();
lblStatus.Text = drTicketRow["Status"].ToString();
lblHotelName.Text = drTicketRow["HotelName"].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();
pnlViewTicket.Visible = true; pnl.Visible = false;
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
throw;
}
}
public string InsertCancellaion(string provisionalId)
{
try
{
string strReturn = "";
HotelBAL obj = new HotelBAL();
obj.ProvisionalId = Convert.ToInt32(provisionalId);
bool b = obj.AddHotelCancellation();
if (b) { strReturn = "Success"; } else { strReturn = ""; }
return strReturn;
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
throw;
}
}
public string InsertCancellaion(string provisionalId, string bookingId, double refundAmount, double cancellationCharges, int createdBy, string hotelCancellationId)
{
try
{
string strReturn = "";
HotelBAL obj = new HotelBAL();
obj.ProvisionalId = Convert.ToInt32(provisionalId);
obj.BookingId = Convert.ToInt32(bookingId);
obj.RefundAmount = refundAmount;
obj.CancellationCharges = cancellationCharges;
obj.CreatedBy = createdBy;
obj.HotelCancellationId = hotelCancellationId;
bool b = obj.AddHotelCancellation();
if (b) { strReturn = "Success"; } else { strReturn = ""; }
return strReturn;
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
objArzooHotelAPILayer = ArzooHotelFactoryManager.GetArzooHotelAPILayerObject();
objArzooHotelAPILayer.UserName = ArzooHotelConstants.USERNAME;
objArzooHotelAPILayer.UserId = ArzooHotelConstants.USERID;
objArzooHotelAPILayer.UserType = ArzooHotelConstants.USERTYPE;
objArzooHotelAPILayer.Password = ArzooHotelConstants.PASSWORD;
objArzooHotelAPILayer.PartnerId = ArzooHotelConstants.PARTNERID;
lblMsg.Text = "";
this.Page.Title = "LoveJourney - Hotel - Ticket";
if (!IsPostBack)
{
if (Session["HotelRefNo"] != null)
{
string strRefNo = Session["HotelRefNo"].ToString();
HotelBAL obj = new HotelBAL();
obj.ReferenceNo = strRefNo;
DataSet ds = obj.GetHotelProvisional();
if (ds != null)
{
string hotelId = ""; string webService = ""; string ratePlanCode = ""; string roomTypeCode = "";
string cityName = ""; string allocavailResult = "";
string allocidResult = ""; string fromDate = ""; string toDate = ""; string roomType = "";
string wsKey = ""; string roomBasis = ""; string title = "";
string firstName = ""; string middleName = ""; string lastName = ""; int noOfRooms = 0;
int[] noOfAdultsInARoom = null; int[] noOfChildsInARoom = null;
int[] firstChildAge = null; int[] secondChildAge = null;
string roomStayCandidate = "";
DataRow dr = ds.Tables[0].Rows[0];
hotelId = dr["HotelId"].ToString();
webService = dr["WebService"].ToString();
ratePlanCode = dr["RatePlanType"].ToString();
roomTypeCode = dr["RoomTypeCode"].ToString();
cityName = dr["HotelCity"].ToString();
allocavailResult = dr["FromAllocation"].ToString();
allocidResult = dr["AllocationId"].ToString();
roomType = dr["RoomType"].ToString();
firstName = dr["FirstName"].ToString();
middleName = dr["MiddleName"].ToString();
lastName = dr["LastName"].ToString();
wsKey = dr["WsKey"].ToString();
roomBasis = dr["RoomBasis"].ToString();
title = dr["Title"].ToString();
noOfRooms = Convert.ToInt32(dr["NoOfRooms"].ToString());
roomStayCandidate = dr["RoomStayCandidate"].ToString();
string[] strValues = roomStayCandidate.Split(':');
fromDate = ConvertDate(strValues[1].ToString());
fromDate = fromDate.Replace('-', '/');
toDate = ConvertDate(strValues[2].ToString());
toDate = toDate.Replace('-', '/');
noOfRooms = Convert.ToInt32(strValues[3].ToString());
noOfAdultsInARoom = new int[noOfRooms];
noOfChildsInARoom = new int[noOfRooms];
firstChildAge = new int[noOfRooms];
secondChildAge = new int[noOfRooms];
int j = 0;
for (int i = 0; i < noOfRooms; i++)
{
if (i == 0)
{
j = 0;
}
else
{
j = 4 * i;
}
noOfAdultsInARoom[i] = Convert.ToInt32(strValues[4 + j].ToString());
noOfChildsInARoom[i] = Convert.ToInt32(strValues[5 + j].ToString());
firstChildAge[i] = Convert.ToInt32(strValues[6 + j].ToString());
secondChildAge[i] = Convert.ToInt32(strValues[7 + j].ToString());
}
objBAL = new ClsBAL();
DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString()));
DataSet dsCommSlabRet = objBAL.GetCommissionSlab(Session["Role"].ToString(), "Hotels","");
string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString();
// string commisionPercentage = dsBalance.Tables[0].Rows[0]["CommisionPercentage"].ToString();
string commisionPercentage = dsCommSlabRet.Tables[0].Rows[0]["Commission"].ToString();
string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString();
string actualFare = dr["HotelTotalFare"].ToString().ToString();
string deductAmount = Convert.ToString(Convert.ToDouble(actualFare.ToString()) -
((Convert.ToDouble(actualFare.ToString()) * Convert.ToDouble(commisionPercentage)) / 100));
string commisionFare = Convert.ToString(Convert.ToDouble(actualFare.ToString()) - Convert.ToDouble(deductAmount));
Session["AgentId_Agent"] = agentId;
Session["ActualFare_Agent"] = actualFare;
Session["CommisionFare_Agent"] = commisionFare;
Session["CommisionPercentage_Agent"] = commisionPercentage;
Session["DeductAmount_Agent"] = deductAmount;
if (Convert.ToDouble(balance) >= Convert.ToDouble(deductAmount))
{
DataSet dsHotelBooking = objArzooHotelAPILayer.HotelBooking
(hotelId, webService, ratePlanCode, roomTypeCode, cityName, allocavailResult,
allocidResult, fromDate, toDate, roomType, wsKey, roomBasis, title, firstName, middleName, lastName, noOfRooms,
noOfAdultsInARoom, noOfChildsInARoom, firstChildAge, secondChildAge);
int provisionalId = Convert.ToInt32(dr["Id"].ToString());
if (!dsHotelBooking.Tables.Contains("HotelBooking"))
{ lblMsg.Text = "Failed to book the ticket."; return; }
if (dsHotelBooking.Tables["HotelBooking"].Rows.Count == 0)
{ lblMsg.Text = "Failed to book the ticket."; return; }
DataRow drr = dsHotelBooking.Tables["HotelBooking"].Rows[0];
wsKey = drr["wsKey"].ToString();
string extGuestTotal = drr["extGuestTotal"].ToString();
string roomTotal = drr["roomTotal"].ToString();
string serviceTaxTotal = drr["servicetaxTotal"].ToString();
string bookingStatus = drr["bookingstatus"].ToString();
string bookingRemarks = drr["bookingremarks"].ToString();
string bookingRefNo = drr["bookingref"].ToString();
string bookingTrn = drr["bookingTrn"].ToString();
string discount = drr["discount"].ToString();
string contactNumbers = drr["contactNumbers"].ToString();
string faxNumbers = drr["faxNumbers"].ToString();
if (drr["bookingstatus"].ToString() == "C")
{
string stt = "";
stt = InsertHotelBooking(provisionalId, wsKey, extGuestTotal, roomTotal, serviceTaxTotal, bookingStatus, bookingRemarks,
bookingRefNo, bookingTrn, discount, contactNumbers, faxNumbers, Convert.ToInt32(Session["UserID"].ToString()));
if (stt == "Success")
{
//lblMsg.Text = "Your ticket has been booked successfully. " + " BookingRefNo : " + Session["HotelRefNo"].ToString();
pnlTicket.Visible = true;
pnlOptions.Visible = true;
DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()),
Convert.ToInt32(Session["UserID"].ToString()), strRefNo, Convert.ToDouble(Session["ActualFare_Agent"].ToString()),
Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionPercentage_Agent"].ToString()));
objBAL = new ClsBAL();
DataSet dsBalanceA = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString()));
string balanceAgent = dsBalanceA.Tables[0].Rows[0]["Balance"].ToString();
Label lbl = (Label)this.Master.FindControl("lblBalance");
lbl.Text = balance;
Session["Balance"] = balanceAgent;
HotelBAL objTicket = new HotelBAL();
objTicket.ReferenceNo = strRefNo;
DataSet dsTicket = objTicket.GetHotelProvisional();
if (dsTicket != null)
{
DataRow drTicketRow = dsTicket.Tables[0].Rows[0];
lblHotelRefNo.Text = drTicketRow["ReferenceNo"].ToString();
lblarzoorefno.Text = drTicketRow["BookingRefNo"].ToString();
lblStatus.Text = drTicketRow["Status"].ToString();
lblHotelName.Text = drTicketRow["HotelName"].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();
SMS();
Mail(lblEmailId.Text.ToString());
}
}
else { lblMsg.Text = "Please Try Again."; }
}
else if (drr["bookingstatus"].ToString() == "E")
{
lblMsg.Text = "Failed to book the ticket.";
}
}
else
{
lblMsg.Text = "Your account does have the sufficient balance to book the ticket.";
pnlTicket.Visible = false;
}
Session["HotelRefNo"] = null;
}
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
if (Session["UserID"] != null)
{
if (ddlPageSize.SelectedIndex != 0)
{ gvBookings.AllowPaging = true; gvBookings.PageSize = Convert.ToInt32(ddlPageSize.SelectedItem.Text.ToString()); }
else
{ gvBookings.AllowPaging = false; }
HotelBAL obj = new HotelBAL();
if (txtfromdate.Text == "") { obj.CheckIn = null; }
else { obj.CheckIn = Convert.ToDateTime(txtfromdate.Text); }
if (txttodate.Text == "") { obj.CheckOut = null; }
else { obj.CheckOut = Convert.ToDateTime(txttodate.Text); }
if (ddlCity.Value != "line") { obj.HotelCity = ddlCity.Value.ToString(); }
if (txtEmailID.Text != "") { obj.EmailId = txtEmailID.Text; }
if (txtManabusRefNo.Text != "") { obj.ReferenceNo = txtManabusRefNo.Text; }
obj.UserId = Convert.ToInt32(Session["UserID"].ToString());
if (txtName.Text != "") { obj.FirstName = txtName.Text; }
if (txtContact.Text != "") { obj.MobileNumber = txtContact.Text; }
if (ddlStatus.SelectedItem.Text != "ALL") { obj.Status = ddlStatus.SelectedItem.Text; }
DataSet ObjDataset = (DataSet)obj.SearchHotelTickets();
gvBookings.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue);
gvBookings.DataSource = ObjDataset;
gvBookings.DataBind();
if (gvBookings.Rows.Count > 0) { btnExport.Visible = true; } else { btnExport.Visible = false; }
ViewState["Data"] = ObjDataset.Tables[0];
}
else { Response.Redirect("~/Default.aspx"); }
}
catch (Exception ex)
{
lblMsg.InnerHtml = ex.Message;
throw;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string bookingRef = "";
string emailId = "";
string lastName = "";
string webService = "";
string startDate = "";
string endDate = "";
HotelBAL obj = new HotelBAL();
obj.ReferenceNo = txtBookingRefNo.Text.ToString().Trim().ToString();
DataSet ds = obj.GetHotelProvisional();
if (ds == null)
{ lblMsg.Text = "Invalid reference number."; return; }
if (ds.Tables.Count == 0)
{ lblMsg.Text = "Invalid reference number."; return; }
if (ds.Tables[0].Rows.Count == 0)
{ lblMsg.Text = "Invalid reference number."; return; }
DataRow dr = ds.Tables[0].Rows[0];
emailId = dr["EmailId"].ToString();
lastName = dr["LastName"].ToString();
bookingRef = dr["BookingRefNo"].ToString();
webService = dr["WebService"].ToString();
startDate = ConvertDate(dr["CheckIn"].ToString());
endDate = ConvertDate1(dr["CheckOut"].ToString());
string status = dr["Status"].ToString();
double hotelTotalFare = Convert.ToDouble(dr["HotelTotalFare"].ToString());
if (status == "Cancelled") { lblMsg.Text = "Already this ticket has been cancelled."; return; }
DataSet dsHotelCancellation = objArzooHotelAPILayer.HotelCancellation(emailId, lastName, bookingRef, webService, startDate, endDate);
if (!dsHotelCancellation.Tables.Contains("HotelCancellation"))
{ lblMsg.Text = "Failed to cancel the ticket."; return; }
DataTable dtCancellation = dsHotelCancellation.Tables["HotelCancellation"];
if (dtCancellation.Rows.Count > 0)
{
DataRow item = dtCancellation.Rows[0];
string cancellationId = item["cancellationId"].ToString();
string refundTotalAmount = item["refundTotalAmount"].ToString();
string cancellationAmount = item["cancellationAmount"].ToString();
string success = item["success"].ToString();
string error = item["error"].ToString();
if (success != "" && cancellationId != "")
{
lblMsg.Text = "Status: " + "Ticket has been cancelled successfully.";
string provisionalId = dr["ProvisionalId"].ToString();
string bookingId = dr["BookingId"].ToString();
double cancellationCharges = hotelTotalFare - Convert.ToDouble(refundTotalAmount);
InsertCancellaion(provisionalId, bookingId, Convert.ToDouble(refundTotalAmount),
cancellationCharges, Convert.ToInt32(Session["UserID"].ToString()), cancellationId);
objBAL = new ClsBAL();
objBAL.AdjustAgentBalance(txtBookingRefNo.Text.Trim().ToString(),
Convert.ToDouble(refundTotalAmount), Convert.ToDouble(cancellationCharges),
Convert.ToInt32(Session["UserID"].ToString()));
DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString()));
string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString();
Label lbl = (Label)this.Master.FindControl("lblBalance");
lbl.Text = balance;
Session["Balance"] = balance;
txtBookingRefNo.Text = "";
}
else if (error != "") { lblMsg.Text = error.ToString(); }
else { lblMsg.Text = "Failed to cancel the ticket."; }
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
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;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string bookingRef = "";
string emailId = "";
string lastName = "";
string webService = "";
string startDate = "";
string endDate = "";
HotelBAL obj = new HotelBAL();
obj.ReferenceNo = txtBookingRefNo.Text.ToString();
DataSet ds = obj.GetHotelProvisional();
if (ds == null)
{ lblMsg.Text = "Invalid reference number."; return; }
if (ds.Tables.Count == 0)
{ lblMsg.Text = "Invalid reference number."; return; }
if (ds.Tables[0].Rows.Count == 0)
{ lblMsg.Text = "Invalid reference number."; return; }
DataRow dr = ds.Tables[0].Rows[0];
emailId = dr["EmailId"].ToString();
lastName = dr["LastName"].ToString();
bookingRef = dr["BookingRefNo"].ToString();
webService = dr["WebService"].ToString();
startDate = ConvertDate(dr["CheckIn"].ToString());
endDate = ConvertDate(dr["CheckOut"].ToString());
string status = dr["Status"].ToString();
if (status == "Cancelled") { lblMsg.Text = "Already this ticket has been cancelled."; return; }
if (emailId != txtEmailId.Text.Trim().ToString()) { lblMsg.Text = "Invalid email id."; return; }
DataSet dsHotelCancellation = objArzooHotelAPILayer.HotelCancellation(emailId, lastName, bookingRef, webService, startDate, endDate);
if (!dsHotelCancellation.Tables.Contains("HotelCancellation"))
{ lblMsg.Text = "Failed to cancel the ticket."; return; }
DataTable dtCancellation = dsHotelCancellation.Tables["HotelCancellation"];
if (dtCancellation.Rows.Count > 0)
{
DataRow item = dtCancellation.Rows[0];
string cancellationId = item["cancellationId"].ToString();
string refundTotalAmount = item["refundTotalAmount"].ToString();
string cancellationAmount = item["cancellationAmount"].ToString();
string success = item["success"].ToString();
string error = item["error"].ToString();
if (success != "")
{
lblMsg.Text = "Status: " + success;
string provisionalId = dr["ProvisionalId"].ToString();
InsertCancellaion(provisionalId);
}
else if (error != "") { lblMsg.Text = error.ToString(); }
else { lblMsg.Text = "Failed to cancel the ticket."; }
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void getUserDetailsHotels()
{
HotelBAL objTicket = new HotelBAL();
objTicket.ReferenceNo = Session["HotelRefNo"].ToString();
Session["Order_Id"] = Session["HotelRefNo"].ToString();
DataSet dsTicket = objTicket.GetHotelProvisional();
if (dsTicket != null)
{
Name = dsTicket.Tables[0].Rows[0]["FirstName"].ToString();
address = dsTicket.Tables[0].Rows[0]["CustAddressLine"].ToString();
State = dsTicket.Tables[0].Rows[0]["CustState"].ToString();
City = dsTicket.Tables[0].Rows[0]["CustCity"].ToString();
PostalCode = dsTicket.Tables[0].Rows[0]["CustZipCode"].ToString();
Email = dsTicket.Tables[0].Rows[0]["EmailId"].ToString();
Mobilenumber = dsTicket.Tables[0].Rows[0]["MobileNumber"].ToString();
Country = "IND";
//address=
val = "true";
}
}