protected void btnAgentLogin_Click(object sender, EventArgs e) { try { ClsBAL objManabusBAL = new ClsBAL(); objManabusBAL.userName = Convert.ToString(txtAgentName.Text); objManabusBAL.password = Convert.ToString(txtAgentPassword.Text); if (objManabusBAL.CheckUser() == "Valid User") { if (Session["Role"] != null) { if (Session["Role"].ToString() == "Agent") { System.Data.DataSet ds = objManabusBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["Balance"] = ds.Tables[0].Rows[0]["Balance"].ToString(); Session["View"] = "AgentView"; string ss = ds.Tables[0].Rows[0]["Status"].ToString(); if (ss.ToUpper().ToString() != "HOLD") { Response.Redirect("~/Default.aspx", false); } else { lblEmpMsg.Text = "Your account is on HOLD. Please contact the administrator."; lblEmpMsg.ForeColor = System.Drawing.Color.Red; Session["UserID"] = null; } } else { lblEmpMsg.Text = "UserName / Password Is Incorrect."; lblEmpMsg.ForeColor = System.Drawing.Color.Red; } } } else { lblEmpMsg.Text = "UserName / Password Is Incorrect."; lblEmpMsg.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { lblMsg.Text = ex.Message; throw ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { objResult.ReferanceId = txtBookingRefNo.Text; objResult.EmailId = txtEmailId.Text; objResult.ScreenInd = blossom.GetCancellationdetails; _objDataSet = (DataSet)objResult.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables[0].Rows[0]["Status"].ToString() == "Canceled") { lblCancel.Text = "Ticket Has been already cancelled"; lblCancel.ForeColor = System.Drawing.Color.Red; return; } string actualfare = _objDataSet.Tables[0].Rows[0]["BasicFare"].ToString(); comm = 10.0; double cancellationAmount = Convert.ToDouble(actualfare) * comm / 100; double refundTotalAmount = Convert.ToDouble(actualfare) - cancellationAmount; ClsBAL objBAL; objBAL = new ClsBAL(); objBAL.AdjustAgentBalance1(txtBookingRefNo.Text.Trim().ToString(), Convert.ToDouble(refundTotalAmount), Convert.ToDouble(cancellationAmount), 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.ToString(); Session["Balance"] = balance; string str=objBAL.Updatecancelstatus(txtBookingRefNo.Text,"Canceled"); lblCancel.Text = str; lblCancel.ForeColor = System.Drawing.Color.Green; txtEmailId.Text = txtBookingRefNo.Text = ""; } else { lblCancel.Text = "Invalid Ref/EmailId"; } }
protected void btnGo_Click(object sender, EventArgs e) { try { string refno = GenerateCabRef(); if (Session["TravelDate"].ToString() != null && Session["CardetailsId"].ToString() != null) { objPsgDtl.ScreenInd = blossom.InsertPassengerDetails; objPsgDtl.TravelDate = Session["TravelDate"].ToString(); objPsgDtl.CarDetailsId = Convert.ToInt32(Session["CardetailsId"].ToString()); objPsgDtl.Name = txtName.Text.ToString(); objPsgDtl.Address = txtAddress.Text.ToString(); objPsgDtl.City = txtCity.Text.ToString(); objPsgDtl.State = DDLState.SelectedValue.ToString(); objPsgDtl.ZipCode = txtZipCode.Text.ToString(); objPsgDtl.Country = txtCountry.Text.ToString(); objPsgDtl.EmailId = txtEMailId.Text.ToString(); objPsgDtl.MobileNo = txtMobileNo.Text.ToString(); objPsgDtl.LandMark = txtLandMark.Text.ToString(); objPsgDtl.city_car = Session["CityName"].ToString(); objPsgDtl.Status = "Blocked"; objPsgDtl.CarName = CarName.Text.ToString(); Session["Amount"] = BasicPrice.Text; //objPsgDtl.Status = txtStatus.Text.ToString(); // objPsgDtl.BasicPrice =Convert.ToDouble(txtBasicPrice.Text); // objPsgDtl.BookingType = txtBookingType.Text.ToString(); objPsgDtl.PickUpTime = DDLPickUpTime.SelectedValue.ToString(); objPsgDtl.Basicfare = BasicPrice.Text; if (Session["UserId"] != null) { if (Session["Role"].ToString() == "Agent") { Class1 objBal = new Class1(); DataSet objDataSet = new DataSet(); objBal.ScreenInd = Master123.gettopmarkup; objBal.Agentid = Convert.ToInt32(Session["UserID"].ToString()); objBal.Type = "Cabs"; objDataSet = (DataSet)objBal.fnGetData(); string markUpAmount = "0"; ViewState["MarkUp"] = markUpAmount; if (objDataSet != null) { if (objDataSet.Tables.Count > 0) { markUpAmount = objDataSet.Tables[0].Rows[0]["MarkUpAmount"].ToString(); ViewState["MarkUp"] = markUpAmount; } } double actualfare = Convert.ToDouble(Session["Amount"]); double totalfare = actualfare + Convert.ToDouble(markUpAmount); objPsgDtl.TotalFare = totalfare.ToString(); } else { objPsgDtl.TotalFare = BasicPrice.Text; } } else { objPsgDtl.TotalFare = BasicPrice.Text; } if (Session["UserId"] != null) { objPsgDtl.AgentId = Session["UserId"].ToString(); objPsgDtl.AgentName = Session["UserName"].ToString(); objPsgDtl.Role = Session["Role"].ToString(); } else { objPsgDtl.Role = "Guest"; } Session["refno"] = refno; objPsgDtl.ReferanceId = refno; objPsgDtl.CreatedBy = 1; if (objPsgDtl.fnInsertRecord() == true) { GetMail(); lblMsg.Text = "Record Inserted Successfully"; str = "SUCCESS"; } if (Session["UserId"]!=null) { if (Session["Role"].ToString() == "User") { if (str == "SUCCESS") { Response.Redirect("~/Pay.aspx?val=car", false); } } } if(Session["UserId"]==null) { if (str == "SUCCESS") { Response.Redirect("~/Pay.aspx?val=car", false); } else { lblText.Text = "Booking is failed.Please try later"; } } else if (Session["UserId"] != null && Session["Role"].ToString()=="Admin") { if (Session["Role"].ToString() == "Admin") { Response.Redirect("~/CarTicket.aspx", false); } } else { if (Session["Role"] != null) { if (Session["Role"].ToString() == "Agent") { ClsBAL objBal = new ClsBAL(); DataSet dsBalance = objBal.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBal.GetCommissionSlab(Session["Role"].ToString(), "Car", ""); // Change it string commisionPercentage = string.Empty; if (dsCommSlab != null) { if (dsCommSlab.Tables[0].Rows.Count > 0) { commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it } else { commisionPercentage = "0"; } } else { commisionPercentage = "0"; } string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string TotalFare = BasicPrice.Text; string actualFare = TotalFare; 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)) { string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), refno, Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionPercentage_Agent"])); 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 = balanceAgent; Session["Balance"] = balanceAgent; Response.Redirect("~/CarTicket.aspx", false); } else { lblMsg.Text = "Your balance is too low to book the ticket.So,please contact administrator"; return; } } } } } } catch (Exception ex) { lblMsg.Text = ex.Message; throw; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.UserAgent.IndexOf("AppleWebKit") > 0) { Request.Browser.Adapters.Clear(); } ClsBAL objManabusBAL = new ClsBAL(); //if (!IsPostBack) { string page = Request.Url.ToString().ToLower(); //if (Session["UserID"] != null && Session["Role"] != null) //{ if (Session["UserID"].ToString() != "INVALID USER" && Session["Role"].ToString() == "Agent") { if (Session["UserName"] != null) { if (page.Contains("frmflightsavailability.aspx")) { pnlflights.Visible = true; Menu1.Visible = false; pnlhotels.Visible = false; } else if (page.Contains("default.aspx")) { pnlflights.Visible = false; Menu1.Visible = true; pnlhotels.Visible = false; } else if (page.Contains("selectbus.aspx") || page.Contains("custinfo.aspx") || page.Contains("redirectbus.aspx")) { pnlflights.Visible = false; Menu1.Visible = true; pnlhotels.Visible = false; } if (page.Contains("frmintflightsavailability.aspx")) { pnlflights.Visible = true; Menu1.Visible = false; pnlhotels.Visible = false; } if (page.Contains("hotels.aspx")) { pnlflights.Visible = false; Menu1.Visible = false; pnlhotels.Visible = true; } lblUsername.Text = "Welcome <b>" + Session["UserName"].ToString() + " </b>"; System.Data.DataSet ds = objManabusBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); Session["Balance"] = ds.Tables[0].Rows[0]["Balance"].ToString(); Session["BusAgentStatus"] = ds.Tables[0].Rows[0]["Buses"].ToString(); Session["HotelsAgentStatus"] = ds.Tables[0].Rows[0]["Hotels"].ToString(); Session["RechargeAgentStatus"] = ds.Tables[0].Rows[0]["Recharge"].ToString(); Session["InterNationalFlightsAgentStatus"] = ds.Tables[0].Rows[0]["InterNationalFlights"].ToString(); Session["DomesticFlighsAgentStatus"] = ds.Tables[0].Rows[0]["DomesticFlighs"].ToString(); lblBalance.Text = "" + Session["Balance"].ToString(); } if (!IsPostBack) { imgAgentLogo.ImageUrl = "~/ActualImage.ashx?ID=" + Session["UserID"].ToString(); if (Session["View"].ToString() == "AgentView") { CustomerView.Visible = false; AgentView.Visible = true; } else if (Session["View"].ToString() == "CustomerView") { CustomerView.Visible = true; AgentView.Visible = false; } } } else { Response.Redirect("~/Default.aspx", false); Session["UserID"] = null; } } //else //{ // Response.Redirect("~/Default.aspx", false); //} // } }
protected void Button2_Click(object sender, EventArgs e) { ClsBAL objManabusBAL = new ClsBAL(); objManabusBAL.userName = Convert.ToString(txtEmpLoginName.Text); objManabusBAL.password = Convert.ToString(txtEmpPassword.Text); if (objManabusBAL.CheckUser() == "Valid User") { if (Session["Role"] != null) { if (Session["Role"].ToString() == "Employee" || Session["Role"].ToString() == "BSD"||Session["Role"].ToString() == "CSE") { System.Data.DataSet ds = objManabusBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["Balance"] = ds.Tables[0].Rows[0]["Balance"].ToString(); Session["View"] = "AgentView"; string ss = ds.Tables[0].Rows[0]["Status"].ToString(); if (ss.ToUpper().ToString() != "HOLD") { Response.Redirect("~/Users/AdminDb/AdminDb.aspx", false); } else { lblEmpMsg.Text = "Your account is on HOLD. Please contact the administrator."; lblEmpMsg.ForeColor = System.Drawing.Color.Red; Session["UserID"] = null; } } } } else { lblEmpMsg.Text = "UserName/Password Incorrect."; lblEmpMsg.ForeColor = System.Drawing.Color.Red; Session["Role"] = null; Session["UserID"] = null; } }
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 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 DataCardRecharge() { try { getip(); string MobileNumber, Provider, balance, Email; _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getagentDatacardrecharge; _objMasters.Parameter = "RequestID"; _objMasters.RequestID = Session["Order_Id"].ToString(); _objDataSet = new DataSet(); _objDataSet = (DataSet)_objMasters.fnGetData(); if (_objDataSet != null) { if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { MobileNumber = _objDataSet.Tables[0].Rows[0]["MobileNo"].ToString(); Provider = _objDataSet.Tables[0].Rows[0]["Provider_Name"].ToString(); balance = _objDataSet.Tables[0].Rows[0]["Amount"].ToString(); Email = _objDataSet.Tables[0].Rows[0]["E_Mail"].ToString(); //-----------Gettinh the commission of agent for a network----- // _objMaster = new clsMasters(); _objMaster.ScreenInd = Masters.GetCommisionByNetwork; _objMaster.NetworkName = Session["NetWorkName"].ToString(); if (Session["Role"].ToString() == "Agent") { _objMaster.Type = "AG"; } _objMaster.UserID = Convert.ToInt32(Session["UserID"].ToString()); _objDataSet = (DataSet)_objMaster.fnGetData(); if (_objDataSet.Tables.Count > 0) { if (_objDataSet.Tables[0].Rows.Count > 0) { Commission = Convert.ToDecimal(_objDataSet.Tables[0].Rows[0]["AgentCommission"].ToString()); } } decimal rechargeAmount = Convert.ToDecimal(Session["RRechargeAmount"]); decimal DeductAmountOnCommission = (rechargeAmount * Commission) / (100); decimal deductamount = rechargeAmount - DeductAmountOnCommission; //----------end------- # region Mobile code string all = "10118" + Session["Order_Id"] + Session["RProviderName"] + "|" + Session["RMobileNumber"] + "|" + Session["RRechargeAmount"] + "A8JW8FX7KQ7PY5ZT2S1V"; string pwhash = FormsAuthentication.HashPasswordForStoringInConfigFile(all, "sha1"); HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://www.payintegra.com/RechargeService"); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; string postData = "PartnerId=10118&TransId=" + Session["Order_Id"] + "&Message=" + Session["RProviderName"] + "|" + Session["RMobileNumber"] + "|" + Session["RRechargeAmount"] + "&Hash=" + pwhash; byte[] bytes = Encoding.UTF8.GetBytes(postData); request.ContentLength = bytes.Length; Stream requestStream = request.GetRequestStream(); requestStream.Write(bytes, 0, bytes.Length); WebResponse response = request.GetResponse(); Stream stream = response.GetResponseStream(); StreamReader reader = new StreamReader(stream); var result = reader.ReadToEnd(); string[] s = result.Split('|'); stream.Dispose(); reader.Dispose(); if (s[0].ToString().Trim() == "100" && s[4].ToString().Trim() == "Transaction Successful") { #region Insert Data into Database //getstatus(); //if (Session["GetStatus"].ToString() == "Success ") //{ AdminiBalance(); Session["TranscationId"] = s[1].ToString(); _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getrecharge3; _objMasters.Parameter = "update"; _objMasters.RequestID = Session["Order_Id"].ToString(); _objMasters.TransactionID = Convert.ToString(s[1].ToString()); Session["TransactionID"] = Convert.ToString(s[1].ToString()); _objMasters.Amount = Convert.ToDouble(balance); _objMasters.UserID = Convert.ToInt32(Session["UserID"]); _objMasters.AgentCommission = DeductAmountOnCommission; _objMasters.Status = "SUCCESS"; Session["Status"] = "Recharge successfully"; _objMasters.IP = ipaddr; _objMasters.A_Amount = Convert.ToDecimal(Session["FinalAdminBalance"].ToString()); if (_objMasters.fnUpdateRecord() == true) { Mpe1.Show(); lblMessage.Text = "Recharge has Been Success"; try { string body = "<html xmlns='http://www.w3.org/1999/xhtml'><head><title></title></head><body>" + "<table width='700' border='0' cellspacing='0' cellpadding='0' style='font-family: Verdana;font-size: smaller; margin-left: 1px; margin-right: 1px; padding-bottom: 10px;'><tr>" + "<td valign='top' width='100%'>" + "<table width='100%'><tr><td valign='top'" + " <img src='http://lovejourney.in/images/ban.jpg' /></td> </tr></table> </td></tr>" + " <tr><td align='left' valign='top' style='height: 0px; background-color: #860f2b;'></td></tr>" + "<tr><td align='left' valign='top' style='padding-left: 10px;'>Dear User, </td></tr>" + "<tr><td align='left' valign='top' style='padding-left: 10px;'>Your TransactionID .<span style='font-weight: 600;'>" + Session["TransactionID"] + " " + "& Your request Id is " + "" + Session["Order_Id"] + " </span></td></tr>" + "<tr><td><table><tr><td align='right' valign='top' style='padding-right: 100px; background-color: #F1F1F1'><span style='color: #860f2b; font-weight: 600;'> Mobile Number:</span>" + MobileNumber + "</td>" + "<td align='right' valign='top' style='padding-right: 100px; background-color: #F1F1F1'><span style='color: #860f2b; font-weight: 600;'>Amount:</span>" + balance + "</td></tr></table></td></tr>" + "<tr><td align='left' width='100%' valign='top'><table><tr><td align='center' width='100%' valign='top' style='background-color: #860f2b; color: White;' colspan='2'><b>Contact Us</b></td></tr>" + "<tr><td align='left' valign='top' style='background-color: #EFEFEF;'><table><tr><td align='right' valign='top'><span style='color: #860f2b;'>Support</span> </td> " + "<td align='left' valign='top'> Visit our Knowledge Base / FAQs for quick answers Log a query or problem at My Helpdesk </td></tr> " + "<tr><td align='right' valign='top'></td>"</tr></table></td>" + "<td align='left' valign='top' style='background-color: #EFEFEF;'><table><tr><td align='left' valign='top'> <span style='color: #860f2b;'>Sales Support</span></td> " + "<td align='left' valign='top'> </td></tr>" + "<tr><td align='left' valign='top' style='padding-left: 20px;'></td></tr>" + "<tr><td align='left' valign='top' style='padding-left: 20px; background-color: #860f2b color: White;'></td></tr>" + "</table></body></html>" + "<br />Again, we thank you for registering with <b>www.lovejourney.in</b> and please " + "do not hesitate to write to us at <a href='mailto:[email protected]'>Mail</a>" + "if you have any questions.<br /><br />Best Regards,<br /><a href='http://www.lovejourney.in'>lovejourney.in</a> " + "<br /><br />"; MailSender.SendEmail("*****@*****.**", "*****@*****.**", "*****@*****.**", "LoveJourney-Recharge", body); } catch (Exception ex) { //LogError("redirect.aspx", "Mail", DateTime.Now, ex.Message.ToString()); // Response.Redirect("Error.aspx", false); } try { //string strUrl = "http://sms.i2space.in/WebServiceSMS.aspx?User=i2space1&passwd=smsc&mobilenumber=" + MobileNumber + //"&message= Thank You for using lovejourney.in to Recharge Mobile no" + MobileNumber + " for Rs" + " " + balance + "& your order Num is" + "" + Session["TransactionID"] + "" + "for Queries ,Email us at [email protected]" + //"&sid=LoveJourney&mtype=N"; //HttpWebRequest oReq1 = null; //HttpWebResponse oRes1 = null; //StreamReader oStream1 = null; //oReq1 = (HttpWebRequest)WebRequest.Create(strUrl); //oReq1.Method = "GET"; //oReq1.Timeout = 10000; //oRes1 = (HttpWebResponse)oReq1.GetResponse(); //oStream1 = new StreamReader(oRes1.GetResponseStream(), Encoding.GetEncoding(1252)); //string strMessage1 = oStream1.ReadToEnd().ToString(); } catch (ArgumentException ex) { //LogError("redirect.aspx", "sms", DateTime.Now, ex.Message.ToString()); // Response.Redirect("Error.aspx", false); } //_objMaster = new clsMasters(); //_objMaster.ScreenInd = Masters.deductagentbalance; //_objMaster.UserID = Convert.ToInt32(Session["UserID"]); //_objMaster.A_Amount = deductamount; //_objMaster.fnUpdateRecord(); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(deductamount), Convert.ToInt32(Session["UserID"].ToString()), Session["TransactionID"].ToString().Trim(), Convert.ToDouble(Session["RRechargeAmount"].ToString()), Convert.ToDouble(DeductAmountOnCommission), Convert.ToInt32(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 = balanceAgent; Session["Balance"] = balanceAgent; Response.Redirect("~/Agent/Recharge/RechargeSucces.aspx", false); #endregion } // } } else { AdminiBalance(); _objMasters = new clsMasters(); _objMasters.ScreenInd = Masters.getrecharge3; _objMasters.Parameter = "update"; _objMasters.RequestID = Session["Order_Id"].ToString(); _objMasters.TransactionID = Convert.ToString(s[1].ToString()); Session["TransactionID"] = Convert.ToString(s[1].ToString()); _objMasters.Amount = Convert.ToDouble(balance); _objMasters.UserID = Convert.ToInt32(Session["UserID"]); _objMasters.Status = "Failure"; Session["Status"] = "Recharge Failure"; _objMasters.A_Amount = Convert.ToDecimal(Session["FinalAdminBalance"].ToString()); _objMasters.IP = ipaddr; Session["errorcode"] = s[0].ToString(); Session["errorDecsription"] = s[4].ToString(); _objMasters.fnUpdateRecord(); Response.Redirect("~/Agent/Recharge/Failure.aspx", false); } } } else { Mpe1.Show(); lblMessage.Text = "Recharge Has Been Failed Please Try Again Later"; } #endregion } else { Mpe1.Show(); lblMessage.Text = "Recharge Has Been Failed Please Try Again Later"; } } catch (Exception ex) { //LogError("Masters/Recharge.aspx", "DataCardRecharge", DateTime.Now, ex.Message.ToString()); throw ex; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.UserAgent.IndexOf("AppleWebKit") > 0) { Request.Browser.Adapters.Clear(); } ClsBAL objManabusBAL = new ClsBAL(); //if (!IsPostBack) { if (Session["UserID"] != null && Session["Role"] != null) { if (Session["UserID"].ToString() != "INVALID USER" && Session["Role"].ToString() == "Agent") { if (Session["UserName"] != null) { lblUsername.Text = "Welcome <b>" + Session["UserName"].ToString() + " </b>"; System.Data.DataSet ds = objManabusBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["Balance"] = ds.Tables[0].Rows[0]["Balance"].ToString(); Session["BusAgentStatus"] = ds.Tables[0].Rows[0]["Buses"].ToString(); Session["HotelsAgentStatus"] = ds.Tables[0].Rows[0]["Hotels"].ToString(); Session["RechargeAgentStatus"] = ds.Tables[0].Rows[0]["Recharge"].ToString(); Session["InterNationalFlightsAgentStatus"] = ds.Tables[0].Rows[0]["InterNationalFlights"].ToString(); Session["DomesticFlighsAgentStatus"] = ds.Tables[0].Rows[0]["DomesticFlighs"].ToString(); lblBalance.Text = "" + Session["Balance"].ToString(); } if (!IsPostBack) { imgAgentLogo.ImageUrl = "~/ActualImage.ashx?ID=" + Session["UserID"].ToString(); if (Session["View"].ToString() == "AgentView") { CustomerView.Visible = false; AgentView.Visible = true; } else if (Session["View"].ToString() == "CustomerView") { CustomerView.Visible = true; AgentView.Visible = false; } } } else { Response.Redirect("~/Default.aspx", false); } } else { Response.Redirect("~/Default.aspx", false); } } }
protected void btnBook_Click(object sender, EventArgs e) { try { if (Session["UserID"] == null) { Response.Redirect("~/Default.aspx", false); return; } dsFilghts = (DataSet)Session["dsDomFlights"]; #region Variables string FlightSegmentsID = string.Empty; string originDestination_Id = string.Empty; string fareDetailsId = string.Empty; string TotalFare = string.Empty; /*FlightsSegment*/ string AirEquipType = string.Empty; string ArrivalAirportCode = string.Empty; string ArrivalDateTime = string.Empty; string DepartureAirportCode = string.Empty; string DepartureDateTime = string.Empty; string FlightNumber = string.Empty; string OperatingAirlineCode = string.Empty; string OperatingAirlineFlightNumber = string.Empty; string RPH = string.Empty; string StopQuantity = string.Empty; string airLineName = string.Empty; string airportTax = string.Empty; string imageFileName = string.Empty; string BookingClassAvailability = string.Empty; string BookingClassResBookDesigCode = string.Empty; string adultFare = string.Empty; string bookingclass = string.Empty; string childFare = string.Empty; string classType = string.Empty; string farebasiscode = string.Empty; string infantfare = string.Empty; string Rule = string.Empty; string adultCommission = string.Empty; string childCommission = string.Empty; string commissionOnTCharge = string.Empty; string Discount = string.Empty; string airportTaxChild = string.Empty; string airportTaxInfant = string.Empty; string adultTaxBreakup = string.Empty; string childTaxBreakup = string.Empty; string infantTaxBreakup = string.Empty; string octax = string.Empty; string id = string.Empty; string key = string.Empty; string TCharge = string.Empty; string TMarkup = string.Empty; string TSdiscount = string.Empty; string TPartnerCommission = string.Empty; string actualBaseFare = string.Empty; string tax = string.Empty; string Stax = string.Empty; string SCharge = string.Empty; string TDiscount = string.Empty; #endregion DataTable dtFlightsSegment = dsFilghts.Tables[9]; if (dtFlightsSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightsSegment.Select("FlightSegment_ID=" + Convert.ToInt32(lblFlightSegmentId1.Text)); FlightSegmentsID = rowFilghtSegment[0]["FlightSegments_Id"].ToString(); AirEquipType = rowFilghtSegment[0]["AirEquipType"].ToString(); ArrivalAirportCode = rowFilghtSegment[0]["ArrivalAirportCode"].ToString(); ArrivalDateTime = rowFilghtSegment[0]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFilghtSegment[0]["DepartureAirportCode"].ToString(); DepartureDateTime = rowFilghtSegment[0]["DepartureDateTime"].ToString(); FlightNumber = rowFilghtSegment[0]["FlightNumber"].ToString(); OperatingAirlineCode = rowFilghtSegment[0]["OperatingAirlineCode"].ToString(); OperatingAirlineFlightNumber = rowFilghtSegment[0]["OperatingAirlineFlightNumber"].ToString(); RPH = rowFilghtSegment[0]["RPH"].ToString(); StopQuantity = rowFilghtSegment[0]["StopQuantity"].ToString(); airLineName = rowFilghtSegment[0]["airLineName"].ToString(); airportTax = rowFilghtSegment[0]["airportTax"].ToString(); imageFileName = rowFilghtSegment[0]["imageFileName"].ToString(); Discount = rowFilghtSegment[0]["Discount"].ToString(); airportTaxChild = rowFilghtSegment[0]["airportTaxChild"].ToString(); airportTaxInfant = rowFilghtSegment[0]["airportTaxInfant"].ToString(); adultTaxBreakup = rowFilghtSegment[0]["adultTaxBreakup"].ToString(); childTaxBreakup = rowFilghtSegment[0]["childTaxBreakup"].ToString(); infantTaxBreakup = rowFilghtSegment[0]["infantTaxBreakup"].ToString(); octax = rowFilghtSegment[0]["octax"].ToString(); } DataTable dtFlightSegments = dsFilghts.Tables[8]; if (dtFlightSegments.Rows.Count > 0) { DataRow[] rowFilghtSegments = dtFlightSegments.Select("FlightSegments_Id=" + FlightSegmentsID); originDestination_Id = rowFilghtSegments[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtFareDetails = dsFilghts.Tables[5]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("OriginDestinationOption_Id=" + originDestination_Id); fareDetailsId = rowFareDetails[0]["FareDetails_Id"].ToString(); } DataTable dtNonChargeableFares = dsFilghts.Tables[7]; if (dtNonChargeableFares.Rows.Count > 0) { DataRow[] rowNonChargeableFareDetails = dtNonChargeableFares.Select("FareDetails_Id=" + fareDetailsId); TCharge = rowNonChargeableFareDetails[0]["TCharge"].ToString(); TMarkup = rowNonChargeableFareDetails[0]["TMarkup"].ToString(); TSdiscount = rowNonChargeableFareDetails[0]["TSdiscount"].ToString(); } DataTable dtChargeableFares = dsFilghts.Tables[6]; if (dtChargeableFares.Rows.Count > 0) { DataRow[] rowChargeableFareDetails = dtChargeableFares.Select("FareDetails_Id=" + fareDetailsId); TPartnerCommission = rowChargeableFareDetails[0]["TPartnerCommission"].ToString(); actualBaseFare = rowChargeableFareDetails[0]["ActualBaseFare"].ToString(); tax = rowChargeableFareDetails[0]["Tax"].ToString(); Stax = rowChargeableFareDetails[0]["Stax"].ToString(); SCharge = rowChargeableFareDetails[0]["SCharge"].ToString(); TDiscount = rowChargeableFareDetails[0]["TDiscount"].ToString(); TotalFare = (Convert.ToDecimal(actualBaseFare) + Convert.ToDecimal(tax) + Convert.ToDecimal(Stax) + Convert.ToDecimal(TCharge) + Convert.ToDecimal(TMarkup)).ToString();//+ Convert.ToDecimal(SCharge) + Convert.ToDecimal(TDiscount) } DataTable dtBookingClass = dsFilghts.Tables[10]; if (dtBookingClass.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass.Select("FlightSegment_ID=" + Convert.ToInt32(lblFlightSegmentId1.Text)); BookingClassAvailability = rowBookingClass[0]["Availability"].ToString(); BookingClassResBookDesigCode = rowBookingClass[0]["ResBookDesigCode"].ToString(); } DataTable dtBookingFareRules = dsFilghts.Tables[11]; if (dtBookingFareRules.Rows.Count > 0) { DataRow[] rowBookingFareRules = dtBookingFareRules.Select("FlightSegment_ID=" + Convert.ToInt32(lblFlightSegmentId1.Text)); adultFare = rowBookingFareRules[0]["adultFare"].ToString(); bookingclass = rowBookingFareRules[0]["bookingclass"].ToString(); farebasiscode = rowBookingFareRules[0]["farebasiscode"].ToString(); Rule = rowBookingFareRules[0]["Rule"].ToString().Replace("<br>", ""); adultCommission = rowBookingFareRules[0]["adultCommission"].ToString(); childCommission = rowBookingFareRules[0]["childCommission"].ToString(); infantfare = (infantCnt > 0) ? rowBookingFareRules[0]["infantfare"].ToString() : "1"; classType = rowBookingFareRules[0]["classType"].ToString(); childFare = (childCnt > 0) ? rowBookingFareRules[0]["childFare"].ToString() : "1"; commissionOnTCharge = rowBookingFareRules[0]["commissionOnTCharge"].ToString(); } DataTable dtOriginDestinationOption = dsFilghts.Tables[4]; if (dtOriginDestinationOption.Rows.Count > 0) { DataRow[] rowOriginDestinationOption = dtOriginDestinationOption.Select("OriginDestinationOption_Id=" + originDestination_Id); id = rowOriginDestinationOption[0]["id"].ToString(); key = rowOriginDestinationOption[0]["key"].ToString(); } if (Session["Role"].ToString() == "User") { #region SaveRequestToDBBeforePG string refNo = Common.GetFlightsReferenceNo("LJDF"); Session["Order_Id"] = refNo.ToString(); FlightBAL objFlightBal = new FlightBAL(); objFlightBal.ReferenceNo = refNo; objFlightBal.TransId = string.Empty; objFlightBal.Status = "Pending"; objFlightBal.AdultPax = Convert.ToInt32(Session["adultcnt"]); objFlightBal.InfantPax = Convert.ToInt32(Session["infantCnt"]); objFlightBal.ChildPax = Convert.ToInt32(Session["childCnt"]); objFlightBal.Origin_Destination_Id = id; objFlightBal.Origin_Destination_Key = key; objFlightBal.ActualBasefare = Convert.ToDecimal(actualBaseFare); objFlightBal.Tax = Convert.ToDecimal(tax); objFlightBal.STax = Convert.ToDecimal(Stax); objFlightBal.Scharge = Convert.ToDecimal(SCharge); objFlightBal.TDiscount = Convert.ToDecimal(TDiscount); objFlightBal.TPartnerCommission = Convert.ToDecimal(TPartnerCommission); objFlightBal.TCharge = Convert.ToDecimal(TCharge); objFlightBal.TMarkUp = Convert.ToDecimal(TMarkup); objFlightBal.TSDiscount = Convert.ToDecimal(TSdiscount); string givenName = string.Empty; string surName = string.Empty; string namereference = string.Empty; string psgrType = string.Empty; string Age = string.Empty; string customerInfo = string.Empty; Table tbladults1 = (Table)this.UpdatePanel1.FindControl("tblAdults"); for (int l = 1; l <= Convert.ToInt32(Session["adultcnt"]); l++) { TextBox txtFn = (TextBox)tbladults1.FindControl("txtFn" + l); TextBox txtLn = (TextBox)tbladults1.FindControl("txtLn" + l); DropDownList ddlTitle = (DropDownList)tbladults1.FindControl("ddlTitle" + l); if (customerInfo == string.Empty) { customerInfo = ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Adt" + "|" + "-"; } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Adt" + "|" + "-"; } // xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } Table tblChild1 = (Table)this.UpdatePanel1.FindControl("tblChild"); for (int j = 1; j <= Convert.ToInt32(Session["childCnt"]); j++) { TextBox txtFn = (TextBox)tblChild1.FindControl("txtCFn" + j); TextBox txtLn = (TextBox)tblChild1.FindControl("txtCLn" + j); DropDownList ddlTitle = (DropDownList)tblChild1.FindControl("ddlCTitle" + j); TextBox txtBirthDate = (TextBox)tblChild1.FindControl("txtCBirthDate" + j); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); if (customerInfo == string.Empty) { customerInfo = ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Chd" + "|" + age + "|" + txtBirthDate.Text.ToString(); } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Chd" + "|" + age + "|" + txtBirthDate.Text.ToString(); } // xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>chd</psgrtype></CustomerInfo>"; } Table tblInfants1 = (Table)this.UpdatePanel1.FindControl("tblInfants"); for (int k = 1; k <= Convert.ToInt32(Session["infantCnt"]); k++) { TextBox txtFn = (TextBox)tblInfants1.FindControl("txtIFn" + k); TextBox txtLn = (TextBox)tblInfants1.FindControl("txtILn" + k); DropDownList ddlTitle = (DropDownList)tblInfants1.FindControl("ddlITitle" + k); TextBox txtBirthDate = (TextBox)tblInfants1.FindControl("txtIBirthDate" + k); string age = string.Empty; if (txtBirthDate != null) age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); else age = "0"; if (customerInfo == string.Empty) { customerInfo = ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Inf" + "|" + age + "|" + txtBirthDate.Text.ToString(); } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Inf" + "|" + age + "|" + txtBirthDate.Text.ToString(); } // xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>inf</psgrtype></CustomerInfo>"; } objFlightBal.Address = txtCity.Text + "," + txtState.Text + "," + ddlcountry.SelectedValue + "," + txtPostalCode.Text + ","; objFlightBal.Customer_Details = customerInfo; //objFlightBal.Customer_Details = "Mr.|rajini|reguri|Adt|"; objFlightBal.telephone = txtPhoneNum.Text; objFlightBal.emailAddress = lblEmailAddress.Text = txtEmailID.Text; objFlightBal.TripMode = "One"; objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); objFlightBal.Type = "User"; objFlightBal.id = id; objFlightBal.key = key; DataTable dtflightBookingId = objFlightBal.AddDomesticFlightBooking(objFlightBal); string flightBookingId = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); Session["BookingID"] = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); objFlightBal.FlightBookingID = flightBookingId.ToString(); objFlightBal.AirEquipType = AirEquipType; objFlightBal.ArrivalAirportCode = ArrivalAirportCode; objFlightBal.ArrivalDateTime = ArrivalDateTime; objFlightBal.DepartureAirportCode = DepartureAirportCode; objFlightBal.DepartureDateTime = DepartureDateTime; objFlightBal.FlightNumber = FlightNumber; objFlightBal.OperatingAirlineCode = OperatingAirlineCode; objFlightBal.OperatingAirlineFlightNumber = OperatingAirlineFlightNumber; objFlightBal.RPH = RPH; objFlightBal.StopQuantity = StopQuantity; objFlightBal.airlineName = airLineName; objFlightBal.airportTax = airportTax; objFlightBal.imageFileName = imageFileName; objFlightBal.Discount = Discount; objFlightBal.airportTaxChild = airportTaxChild; objFlightBal.airportTaxInfant = airportTaxInfant; objFlightBal.adultTaxBreakUp = adultTaxBreakup; objFlightBal.ChildTaxBreakUp = childTaxBreakup; objFlightBal.InfantTaxBreakUp = infantTaxBreakup; objFlightBal.ocTax = octax; objFlightBal.Availability = BookingClassAvailability; objFlightBal.ResBookingCode = BookingClassResBookDesigCode; objFlightBal.adultFare = adultFare; objFlightBal.bookingClass = bookingclass; objFlightBal.ChildFare = childFare; objFlightBal.ClassType = classType; objFlightBal.farebasisCode = farebasiscode; objFlightBal.infantFare = infantfare; objFlightBal.Fare_Rule = Rule; objFlightBal.adultCommission = adultCommission; objFlightBal.childCommission = childCommission; objFlightBal.CommissionOnTCharge = commissionOnTCharge; objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); bool res = objFlightBal.AddDomesticFlightBookingsegments(objFlightBal); if (res) { try { if (Page.IsValid) { Response.Redirect("~/pay.aspx?val=Dom", false); } else { lblMsg.Text = "Enter Valid Data"; lblMsg.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { // LogError("frmSearchBus.aspx", "paymentgateway", DateTime.Now, ex.Message.ToString()); // lblMsg1.Visible = true; // lblMsg1.Text = "Error in the payment gateway"; } } #endregion } else { #region Pricing String XMLPricing = "<pricingrequest><onwardFlights><OriginDestinationOption><FareDetails><ChargeableFares><ActualBaseFare>" + actualBaseFare + "</ActualBaseFare><Tax>" + tax + "</Tax> <STax>" + Stax + "</STax><SCharge>" + SCharge + "</SCharge> <TDiscount>" + TDiscount + "</TDiscount><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TCharge + "</TCharge> <TMarkup>" + TMarkup + "</TMarkup><TSdiscount>" + TDiscount + "</TSdiscount> </NonchargeableFares></FareDetails> <FlightSegments> <FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><RPH>" + RPH + "</RPH> <StopQuantity>" + StopQuantity + "</StopQuantity><airLineName>" + airLineName + "</airLineName><airportTax>" + airportTax + "</airportTax><imageFileName>" + imageFileName + "</imageFileName> <BookingClass><Availability>" + BookingClassAvailability + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCode + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFare + "</adultFare><bookingclass>" + bookingclass + "</bookingclass> <childFare>" + childFare + "</childFare><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><infantfare>" + infantfare + "</infantfare> <Rule>" + Rule.Replace("<br>","") + "</Rule><adultCommission>" + adultCommission + "</adultCommission><childCommission>" + childCommission + "</childCommission><commissionOnTCharge>" + commissionOnTCharge + "</commissionOnTCharge></BookingClassFare> <Discount>" + Discount + "</Discount><airportTaxChild>" + airportTaxChild + "</airportTaxChild><airportTaxInfant>" + airportTaxInfant + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakup + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakup + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakup + "</infantTaxBreakup><octax>" + octax + "</octax> </FlightSegment> </FlightSegments><id>" + id + "</id><key>" + key + "</key> </OriginDestinationOption></onwardFlights><returnFlights/> <telePhone>" + txtPhoneNum.Text + "</telePhone><email>" + txtEmailID.Text + "</email> <creditcardno></creditcardno><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooFWS1.1</Clienttype><AdultPax>" + Session["adultcnt"].ToString() + "</AdultPax><ChildPax>" + Session["childCnt"].ToString() + "</ChildPax><InfantPax>" + Session["infantCnt"].ToString() + "</InfantPax></pricingrequest>"; DataSet dsFlightPricing = objFlights.GetPricingDetails(XMLPricing.Replace("<br>","")); if (!dsFlightPricing.Tables[0].Columns.Contains("error")) { DataTable dtFlightSegment = dsFlightPricing.Tables["FlightSegment"]; string PricingFlightSegmentsId = dsFlightPricing.Tables["FlightSegment"].Rows[0]["FlightSegments_Id"].ToString(); DataTable dtchangeFlightSegments = dsFlightPricing.Tables[6]; if (dtchangeFlightSegments.Rows.Count > 0) { DataRow[] rowchangeFilghtSegments = dtchangeFlightSegments.Select("FlightSegments_Id=" + PricingFlightSegmentsId); originDestination_Id = rowchangeFilghtSegments[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtchangeFareDetails = dsFlightPricing.Tables[3]; if (dtchangeFareDetails.Rows.Count > 0) { DataRow[] rowchangeFareDetails = dtchangeFareDetails.Select("OriginDestinationOption_Id=" + originDestination_Id); fareDetailsId = rowchangeFareDetails[0]["FareDetails_Id"].ToString(); } DataTable dtchangeprice = dsFlightPricing.Tables[4]; DataTable dtchangepriceNon = dsFlightPricing.Tables[5]; if (dtchangeprice.Rows.Count > 0) { DataRow[] rowchangeprices = dtchangeprice.Select("FareDetails_Id=" + fareDetailsId); DataRow[] rowchangepricesNon = dtchangepriceNon.Select("FareDetails_Id=" + fareDetailsId); TPartnerCommission = rowchangeprices[0]["TPartnerCommission"].ToString(); actualBaseFare = rowchangeprices[0]["ActualBaseFare"].ToString(); tax = rowchangeprices[0]["Tax"].ToString(); Stax = rowchangeprices[0]["Stax"].ToString(); SCharge = rowchangeprices[0]["SCharge"].ToString(); TDiscount = rowchangeprices[0]["TDiscount"].ToString(); TotalFare = (Convert.ToDecimal(actualBaseFare) + Convert.ToDecimal(tax) + Convert.ToDecimal(Stax) + Convert.ToDecimal(rowchangepricesNon[0]["TCharge"].ToString()).ToString() + Convert.ToDecimal(rowchangepricesNon[0]["TMarkup"].ToString()).ToString()); //+ Convert.ToDecimal(TDiscount)).ToString()+.ToDecimal(SCharge) ; } } #endregion string refNo = Common.GetFlightsReferenceNo("LJDF"); String xmlRequestData = "<Bookingrequest><onwardFlights><OriginDestinationOption><FareDetails> <ChargeableFares><ActualBaseFare>" + actualBaseFare + "</ActualBaseFare> <Tax>" + tax + "</Tax><STax>" + Stax + "</STax> <SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TCharge + "</TCharge> <TMarkup>" + TMarkup + "</TMarkup><TSdiscount>" + TSdiscount + "</TSdiscount> </NonchargeableFares></FareDetails>"; xmlRequestData = xmlRequestData + "<FlightSegments> <FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><RPH>" + RPH + "</RPH> <StopQuantity>" + StopQuantity + "</StopQuantity><airLineName>" + airLineName + "</airLineName><airportTax>" + airportTax + "</airportTax><imageFileName>" + imageFileName + "</imageFileName>"; xmlRequestData = xmlRequestData + "<BookingClass><Availability>" + BookingClassAvailability + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCode + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFare + "</adultFare><bookingclass>" + bookingclass + "</bookingclass> <childFare>" + childFare + "</childFare><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><infantfare>" + infantfare + "</infantfare> <Rule>" + Rule + "</Rule><adultCommission>" + adultCommission + "</adultCommission><childCommission>" + childCommission + "</childCommission><commissionOnTCharge>" + commissionOnTCharge + "</commissionOnTCharge></BookingClassFare>"; xmlRequestData = xmlRequestData + "<Discount>" + Discount + "</Discount><airportTaxChild>" + airportTaxChild + "</airportTaxChild><airportTaxInfant>" + airportTaxInfant + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakup + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakup + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakup + "</infantTaxBreakup><octax>" + octax + "</octax> </FlightSegment> </FlightSegments>"; xmlRequestData = xmlRequestData + "<id>" + id + "</id><key>" + key + "</key> </OriginDestinationOption></onwardFlights><returnFlights/><personName>"; // Dynamic generation of names of adults, infants , Child Table tbladults = (Table)this.UpdatePanel1.FindControl("tblAdults"); for (int i = 1; i <= Convert.ToInt32(Session["adultcnt"]); i++) { TextBox txtFn = (TextBox)tbladults.FindControl("txtFn" + i); TextBox txtLn = (TextBox)tbladults.FindControl("txtLn" + i); DropDownList ddlTitle = (DropDownList)tbladults.FindControl("ddlTitle" + i); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } Table tblChild = (Table)this.UpdatePanel1.FindControl("tblChild"); for (int i = 1; i <= Convert.ToInt32(Session["childCnt"]) ; i++) { TextBox txtFn = (TextBox)tblChild.FindControl("txtCFn" + i); TextBox txtLn = (TextBox)tblChild.FindControl("txtCLn" + i); DropDownList ddlTitle = (DropDownList)tblChild.FindControl("ddlCTitle" + i); TextBox txtBirthDate = (TextBox)tblChild.FindControl("txtCBirthDate" + i); DateTime strdate = Convert.ToDateTime(txtBirthDate.Text); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>chd</psgrtype></CustomerInfo>"; } Table tblInfants = (Table)this.UpdatePanel1.FindControl("tblInfants"); for (int i = 1; i <= Convert.ToInt32(Session["infantCnt"]) ; i++) { TextBox txtFn = (TextBox)tblInfants.FindControl("txtIFn" + i); TextBox txtLn = (TextBox)tblInfants.FindControl("txtILn" + i); DropDownList ddlTitle = (DropDownList)tblInfants.FindControl("ddlITitle" + i); TextBox txtBirthDate = (TextBox)tblInfants.FindControl("txtIBirthDate" + i); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>inf</psgrtype></CustomerInfo>"; } xmlRequestData = xmlRequestData + "</personName><telePhone><phoneNumber>" + txtMobileNo.Text + "</phoneNumber></telePhone><email><emailAddress>" + txtEmailID.Text + "</emailAddress></email><creditcardno>4111111111111111</creditcardno><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword> <partnerRefId>" + refNo + "</partnerRefId> <Clienttype>ArzooFWS1.1</Clienttype><AdultPax>" + ddlAdult.SelectedItem.Value + "</AdultPax><ChildPax>" + ddlChild.SelectedItem.Value + "</ChildPax><InfantPax>" + ddlInfant.SelectedItem.Value + "</InfantPax></Bookingrequest>"; DataSet dsBookingResponse = new DataSet(); #region CSE if (Session["Role"].ToString() == "CSE") { if (chkonbehalfof.Checked == true) { ListItem value = ddlagent1.Items.FindByText(txtagentname.Text.ToString()); if (value != null) { ddlagent1.SelectedItem.Value = value.Value; Session["AgentId_Agent"] = ddlagent1.SelectedItem.Value; DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(ddlagent1.SelectedValue)); DataSet dsCommSlab = objBAL.GetCommissionSlab("Agent", "DomesticFlights", airLineName.ToString()); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string actualFare = TotalFare; 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)) { dsBookingResponse = objFlights.GetBookingDetails(xmlRequestData.Replace("<br>", "")); } else { mp3.Show(); lblerror.Text = "Please contact administrator"; return; } } else { mp3.Show(); lblerror.Text = "Agent Username Does not exists"; return; } } else { dsBookingResponse = objFlights.GetBookingDetails(xmlRequestData.Replace("<br>", "")); } } #endregion #region Agent else if (Session["Role"].ToString() == "Agent") { DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "DomesticFlights", airLineName.ToString()); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string actualFare = TotalFare; 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)) { dsBookingResponse = objFlights.GetBookingDetails(xmlRequestData.Replace("<br>", "")); } else { mp3.Show(); lblerror.Text = "Please Contact administrator"; return; } } #endregion else { dsBookingResponse = objFlights.GetBookingDetails(xmlRequestData.Replace("<br>", "")); } string error = string.Empty; // If there is any Error -- We wont get the transid instead we get error if (dsBookingResponse.Tables[0].Columns.Contains("transid")) { transId = dsBookingResponse.Tables[0].Rows[0]["transid"].ToString(); #region SaveResponse FlightBAL objFlightBal = new FlightBAL(); objFlightBal.ReferenceNo = refNo; objFlightBal.TransId = transId; objFlightBal.Status = dsBookingResponse.Tables["Bookingresponse"].Rows[0]["status"].ToString(); objFlightBal.AdultPax = Convert.ToInt32(dsBookingResponse.Tables["Bookingresponse"].Rows[0]["AdultPax"].ToString()); objFlightBal.InfantPax = Convert.ToInt32(dsBookingResponse.Tables["Bookingresponse"].Rows[0]["InfantPax"].ToString()); objFlightBal.ChildPax = Convert.ToInt32(dsBookingResponse.Tables["Bookingresponse"].Rows[0]["ChildPax"].ToString()); objFlightBal.Origin_Destination_Id = dsBookingResponse.Tables["originDestinationOption"].Rows[0]["id"].ToString(); objFlightBal.Origin_Destination_Key = dsBookingResponse.Tables["originDestinationOption"].Rows[0]["key"].ToString(); objFlightBal.ActualBasefare = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["ActualBasefare"].ToString()); objFlightBal.Tax = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["Tax"].ToString()); objFlightBal.STax = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["STax"].ToString()); objFlightBal.Scharge = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["Scharge"].ToString()); objFlightBal.TDiscount = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["TDiscount"].ToString()); objFlightBal.TPartnerCommission = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["TPartnerCommission"].ToString()); objFlightBal.TCharge = Convert.ToDecimal(dsBookingResponse.Tables["NonChargeableFares"].Rows[0]["TCharge"].ToString()); objFlightBal.TMarkUp = Convert.ToDecimal(dsBookingResponse.Tables["NonChargeableFares"].Rows[0]["TMarkUp"].ToString()); objFlightBal.TSDiscount = Convert.ToDecimal(dsBookingResponse.Tables["NonChargeableFares"].Rows[0]["TSDiscount"].ToString()); string givenName = string.Empty; string surName = string.Empty; string namereference = string.Empty; string psgrType = string.Empty; string Age = string.Empty; string customerInfo = string.Empty; for (int i = 0; i < dsBookingResponse.Tables["CustomerInfo"].Rows.Count; i++) { givenName = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["givenName"].ToString(); surName = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["surName"].ToString(); namereference = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["nameReference"].ToString(); string[] str = namereference.ToString().Split(','); if (str[0].ToString() == "C") { psgrType = "Child"; Age = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["age"].ToString(); } else if (str[0].ToString() == "I") { psgrType = "Infant"; Age = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["age"].ToString(); } else { psgrType = "Adult"; } // psgrType = "";// dsBookingResponse.Tables["CustomerInfo"].Rows[i]["psgrtype"].ToString(); if (psgrType.ToString() != "Adult") { if (psgrType.ToString() == "Child") { if (customerInfo == string.Empty) { customerInfo = str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } else { customerInfo = customerInfo + ";" + str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } } else { if (customerInfo == string.Empty) { customerInfo = str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age + "M"; } else { customerInfo = customerInfo + ";" + str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age + "M"; } } } else { if (customerInfo == string.Empty) { customerInfo = str[0].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + "-"; } else { customerInfo = customerInfo + ";" + str[0].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + "-"; } } } objFlightBal.Customer_Details = customerInfo; objFlightBal.telephone = dsBookingResponse.Tables["telePhone"].Rows[0]["PhoneNumber"].ToString(); objFlightBal.emailAddress = lblEmailAddress.Text = dsBookingResponse.Tables["email"].Rows[0]["emailAddress"].ToString(); objFlightBal.TripMode = "One"; objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); if (Session["Role"].ToString() == "CSE") { if (chkonbehalfof.Checked == true) { objFlightBal.CreatedBy = Convert.ToInt32(Session["AgentId_Agent"]); string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); string[] commPerRet = Session["CommisionPercentage_AgentRet"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["AgentId_Agent"].ToString()), refNo, Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToDouble(commPer[0])); objBAL = new ClsBAL(); DataSet dsBalanceA = objBAL.GetAgentByUserId(Convert.ToInt32(Session["AgentId_Agent"].ToString())); string balanceAgent = dsBalanceA.Tables[0].Rows[0]["Balance"].ToString(); Session["Balance"] = balanceAgent; } else { } } else if (Session["Role"].ToString() == "Agent") { string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), refNo, Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionPercentage_Agent"])); 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; } // bool res = objFlightBal.AddDomesticFlightBooking(objFlightBal); DataTable dtflightBookingId = objFlightBal.AddDomesticFlightBooking(objFlightBal); string flightBookingId = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); objFlightBal.FlightBookingID = flightBookingId.ToString(); if (dsBookingResponse.Tables["FlightSegment"].Rows.Count > 0) { for (int j = 0; j < dsBookingResponse.Tables["FlightSegment"].Rows.Count; j++) { objFlightBal.AirEquipType = dsBookingResponse.Tables["FlightSegment"].Rows[j]["AirEquipType"].ToString(); objFlightBal.ArrivalAirportCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ArrivalAirportCode"].ToString(); objFlightBal.ArrivalDateTime = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ArrivalDateTime"].ToString(); objFlightBal.DepartureAirportCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DepartureAirportCode"].ToString(); objFlightBal.DepartureDateTime = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DepartureDateTime"].ToString(); objFlightBal.FlightNumber = dsBookingResponse.Tables["FlightSegment"].Rows[j]["FlightNumber"].ToString(); objFlightBal.OperatingAirlineCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["OperatingAirlineCode"].ToString(); objFlightBal.OperatingAirlineFlightNumber = dsBookingResponse.Tables["FlightSegment"].Rows[j]["OperatingAirlineFlightNumber"].ToString(); objFlightBal.RPH = dsBookingResponse.Tables["FlightSegment"].Rows[j]["RPH"].ToString(); objFlightBal.StopQuantity = dsBookingResponse.Tables["FlightSegment"].Rows[j]["StopQuantity"].ToString(); objFlightBal.airlineName = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airlineName"].ToString(); objFlightBal.airportTax = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airportTax"].ToString(); objFlightBal.imageFileName = dsBookingResponse.Tables["FlightSegment"].Rows[j]["imageFileName"].ToString(); objFlightBal.Discount = dsBookingResponse.Tables["FlightSegment"].Rows[j]["Discount"].ToString(); objFlightBal.airportTaxChild = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airportTaxChild"].ToString(); objFlightBal.airportTaxInfant = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airportTaxInfant"].ToString(); objFlightBal.adultTaxBreakUp = dsBookingResponse.Tables["FlightSegment"].Rows[j]["adultTaxBreakUp"].ToString(); objFlightBal.ChildTaxBreakUp = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ChildTaxBreakUp"].ToString(); objFlightBal.InfantTaxBreakUp = dsBookingResponse.Tables["FlightSegment"].Rows[j]["InfantTaxBreakUp"].ToString(); objFlightBal.ocTax = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ocTax"].ToString(); objFlightBal.Availability = dsBookingResponse.Tables["BookingClass"].Rows[j]["Availability"].ToString(); objFlightBal.ResBookingCode = dsBookingResponse.Tables["BookingClass"].Rows[j]["ResBookDesigCode"].ToString(); objFlightBal.adultFare = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["adultFare"].ToString(); objFlightBal.bookingClass = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["bookingClass"].ToString(); objFlightBal.ChildFare = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["ChildFare"].ToString(); objFlightBal.ClassType = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["ClassType"].ToString(); objFlightBal.farebasisCode = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["farebasisCode"].ToString(); objFlightBal.infantFare = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["infantFare"].ToString(); objFlightBal.Fare_Rule = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["Rule"].ToString(); objFlightBal.adultCommission = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["adultCommission"].ToString(); objFlightBal.childCommission = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["childCommission"].ToString(); objFlightBal.CommissionOnTCharge = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["CommissionOnTCharge"].ToString(); objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); if (Session["Role"].ToString() == "CSE") { if (chkonbehalfof.Checked == true) { objFlightBal.CreatedBy = Convert.ToInt32(Session["AgentId_Agent"]); } } bool res = objFlightBal.AddDomesticFlightBookingsegments(objFlightBal); if (res) { GetBookingStatus(refNo); GetDetailsForPrint(objFlightBal.ReferenceNo.ToString()); } #endregion else { error = dsBookingResponse.Tables[0].Rows[0]["error"].ToString(); lblStatus.Text = error; } } lbtnmail.Visible = false; pnlSearch.Visible = false; pnlPassengerDet.Visible = false; lblStatus.Visible = true; lblStatus.Text = "Ticket has been booked successfully. Reference Number is : " + objFlightBal.ReferenceNo.ToString(); lblStatus.ForeColor = System.Drawing.Color.Green; lbtnmail_Click1(sender, e); } } else { mp3.Show(); lblerror.Text = dsBookingResponse.Tables[0].Rows[0]["error"].ToString(); if (lblerror.Text == "Insufficient Funds") { lblerror.Text = "Please Contact administrator"; } } } } catch (Exception ex) { } }
DataSet GetAgentByUserId(int id) { try { ClsBAL objManabusBal = new ClsBAL(); return objManabusBal.GetAgentByUserId(id); } catch (Exception ex) { lblMsg.InnerHtml = ex.Message; throw; } }
protected void CancelKesineniTickets(string CancelType, string SeatNos) { try { if (ViewState["dsticketdetails"] != null) { DataTable dt = (DataTable)ViewState["dsticketdetails"]; int BookingId = Convert.ToInt32(dt.Rows[0]["BookingId"].ToString()); int tentativeId = Convert.ToInt32(dt.Rows[0]["TentativeId"].ToString()); string EmailId = dt.Rows[0]["EmailId"].ToString(); string cancelllationId = dt.Rows[0]["CancellationId"].ToString(); string CancelledSaets = dt.Rows[0]["CancelledSeats"].ToString(); string pnrNumberKesineni = dt.Rows[0]["PNRNumber"].ToString().Trim().ToString(); string firstNameKesineni = dt.Rows[0]["FullName"].ToString(); string lastNameKesineni = dt.Rows[0]["FullName"].ToString(); DateTime DOJ = Convert.ToDateTime(dt.Rows[0]["DateOfJourney"].ToString()); string dateOfJourneyKesineni = DOJ.ToString("MM/dd/yyyy"); string seatNumberListKesineni = dt.Rows[0]["SeatNos"].ToString(); if (CancelType == "Total Cancellation") { DataSet dsKesineni = objKesineniAPILayer.CancelTickets(pnrNumberKesineni, firstNameKesineni, lastNameKesineni, dateOfJourneyKesineni, SeatNos); #region total Cancellation if (dsKesineni != null) { if (dsKesineni.Tables[0].Rows.Count > 0 && dsKesineni.Tables[0].Columns.Count > 2) { double grandTotalRefund = Convert.ToDouble(dsKesineni.Tables[0].Rows[0]["GrandTotalRefunded"].ToString()); double cancellationCharges = Convert.ToDouble(dsKesineni.Tables[0].Rows[0]["CancellationCharges"].ToString()); DataSet dsKesineni1 = objKesineniAPILayer.ConfirmCancelTickets(pnrNumberKesineni, firstNameKesineni, lastNameKesineni, dateOfJourneyKesineni, SeatNos); if (dsKesineni1 != null) { if (dsKesineni1.Tables.Count > 0) { if (dsKesineni1.Tables[0].Columns.Count > 1 && dsKesineni1.Tables[0].Rows.Count > 0) { AddCancellation(BookingId, tentativeId, SeatNos, EmailId, Convert.ToString(grandTotalRefund), Convert.ToString(Convert.ToDouble(grandTotalRefund) + Convert.ToDouble(cancellationCharges)), "", 0); objBAL = new ClsBAL(); objBAL.AdjustAgentBalance(txtMBRefNo.Text.Trim().ToString(), Convert.ToDouble(grandTotalRefund), Convert.ToDouble(cancellationCharges), Convert.ToInt32(Session["UserID"])); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = balance; Session["Balance"] = balance; txtEmailID.Text = txtMBRefNo.Text = ""; } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } } #endregion } else if (CancelType == "Partial Cancellation") { DataSet dsKesineni = objKesineniAPILayer.CancelTickets(pnrNumberKesineni, firstNameKesineni, lastNameKesineni, dateOfJourneyKesineni, SeatNos); #region PartialCancellation if (dsKesineni != null) { if (dsKesineni.Tables[0].Rows.Count > 0 && dsKesineni.Tables[0].Columns.Count > 2) { double grandTotalRefundp = Convert.ToDouble(dsKesineni.Tables[0].Rows[0]["GrandTotalRefunded"].ToString()); double cancellationChargesp = Convert.ToDouble(dsKesineni.Tables[0].Rows[0]["CancellationCharges"].ToString()); DataSet dsKesineni1 = objKesineniAPILayer.ConfirmCancelTickets(pnrNumberKesineni, firstNameKesineni, lastNameKesineni, dateOfJourneyKesineni, SeatNos); if (dsKesineni1 != null) { if (dsKesineni1.Tables.Count > 0) { if (dsKesineni1.Tables[0].Columns.Count > 1 && dsKesineni1.Tables[0].Rows.Count > 0) { if (cancelllationId != "" && CancelledSaets != "") { UpdateCancelltion(Convert.ToInt32(cancelllationId), SeatNos, Convert.ToString(grandTotalRefundp), Convert.ToString(cancellationChargesp)); } else if (cancelllationId == "" && CancelledSaets == "") { AddCancellation(BookingId, tentativeId, SeatNos, EmailId, Convert.ToString(grandTotalRefundp), Convert.ToString(cancellationChargesp), "", 0); } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } } #endregion } } } catch (Exception ex) { throw ex; } }
protected void CancelBitlaTickets(string CancelType, string SeatNos) { try { if (ViewState["dsticketdetails"] != null) { DataTable dt = (DataTable)ViewState["dsticketdetails"]; int BookingId = Convert.ToInt32(dt.Rows[0]["BookingId"].ToString()); int tentativeId = Convert.ToInt32(dt.Rows[0]["TentativeId"].ToString()); string EmailId = dt.Rows[0]["EmailId"].ToString(); string Name = dt.Rows[0]["FullName"].ToString(); string ticketNumberBitla = dt.Rows[0]["PNRNumber"].ToString(); string seatNumbersBitla = dt.Rows[0]["SeatNos"].ToString(); string cancelllationId = dt.Rows[0]["CancellationId"].ToString(); string CancelledSaets = dt.Rows[0]["CancelledSeats"].ToString(); if (CancelType == "Total Cancellation") { objBitlaAPILayer.TicketNumber = ticketNumberBitla; objBitlaAPILayer.SeatNumbers = SeatNos; DataSet dsBitla = objBitlaAPILayer.IsTicketCancellable(); #region Cancellation if (dsBitla != null) { if (dsBitla.Tables[0].Rows.Count > 0 && dsBitla.Tables[0].Columns.Count > 2) { string refundAmount = dsBitla.Tables[0].Rows[0]["refund_amount"].ToString(); string cancellationCharges = dsBitla.Tables[0].Rows[0]["cancellation_charges"].ToString(); if (dsBitla.Tables[0].Rows[0]["is_cancellable"].ToString().ToUpper().ToString() == "TRUE") { objBitlaAPILayer.TicketNumber = ticketNumberBitla; DataSet dsBitla1 = objBitlaAPILayer.CancelTicket(); if (dsBitla1 != null) { if (dsBitla1.Tables.Count > 0) { if (dsBitla1.Tables[0].Columns.Count > 1 && dsBitla1.Tables[0].Rows.Count > 0) { AddCancellation(BookingId, tentativeId, SeatNos, EmailId, refundAmount, Convert.ToString(Convert.ToDouble(refundAmount) + Convert.ToDouble(cancellationCharges)), "Bitla", hour); Mail(dt.Rows[0]["EmailId"].ToString(), dt.Rows[0]["PGMBRefNo"].ToString()); objBAL = new ClsBAL(); objBAL.AdjustAgentBalance(txtMBRefNo.Text.Trim().ToString(), Convert.ToDouble(refundAmount), Convert.ToDouble(cancellationCharges), Convert.ToInt32(Session["UserID"])); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = balance; Session["Balance"] = balance; txtEmailID.Text = txtMBRefNo.Text = ""; } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } else { lblMsg.Text = "Already cancelled "; } } else { lblMsg.Text = "Already cancelled "; } } #endregion } else if (CancelType == "Partial Cancellation") { objBitlaAPILayer.TicketNumber = ticketNumberBitla; objBitlaAPILayer.SeatNumbers = SeatNos; DataSet dsBitla = objBitlaAPILayer.IsTicketCancellable(); #region PartialCancellation if (dsBitla != null) { if (dsBitla.Tables[0].Rows.Count > 0 && dsBitla.Tables[0].Columns.Count > 2) { string refundAmount = dsBitla.Tables[0].Rows[0]["refund_amount"].ToString(); string cancellationCharges = dsBitla.Tables[0].Rows[0]["cancellation_charges"].ToString(); if (dsBitla.Tables[0].Rows[0]["is_cancellable"].ToString() == "true") { objBitlaAPILayer.TicketNumber = ticketNumberBitla; DataSet dsBitla1 = objBitlaAPILayer.CancelPartialTicket(); if (dsBitla1 != null) { if (dsBitla1.Tables.Count > 0) { if (dsBitla1.Tables[0].Columns.Count > 1 && dsBitla1.Tables[0].Rows.Count > 0) { if (cancelllationId != "" && CancelledSaets != "") { UpdateCancelltion(Convert.ToInt32(cancelllationId), SeatNos, refundAmount, cancellationCharges); } else if (cancelllationId == "" && CancelledSaets == "") { AddCancellation(BookingId, tentativeId, SeatNos, EmailId, refundAmount, Convert.ToString(Convert.ToDouble(refundAmount) + Convert.ToDouble(cancellationCharges)), "Bitla", hour); } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } } else { lblMsg.Text = "Already cancelled "; } } #endregion } } } catch (Exception ex) { throw ex; } }
protected void btnSignIn_Click(object sender, EventArgs e) { try { if (Session["UserID"] != null) { DataSet dsticketdetails = CheckTicketID(); if (CheckStatus) { if (dsticketdetails != null) { int BookingId = Convert.ToInt32(dsticketdetails.Tables[0].Rows[0]["BookingId"].ToString()); int tentativeId = Convert.ToInt32(dsticketdetails.Tables[0].Rows[0]["TentativeId"].ToString()); string EmailId = dsticketdetails.Tables[0].Rows[0]["EmailId"].ToString(); string Name = dsticketdetails.Tables[0].Rows[0]["FullName"].ToString(); string seatnumbers = dsticketdetails.Tables[0].Rows[0]["SeatNos"].ToString(); string totalfareabhi = dsticketdetails.Tables[0].Rows[0]["TotalFare"].ToString(); string ticketNumberBitla = dsticketdetails.Tables[0].Rows[0]["PNRNumber"].ToString(); string BoardingPointName = dsticketdetails.Tables[0].Rows[0]["BoardingPointName"].ToString(); string DateofJourney = dsticketdetails.Tables[0].Rows[0]["DateOfJourney"].ToString(); string[] dd = DateofJourney.Split(' '); string[] bd = BoardingPointName.Split('-'); string dateofjourney = dd[0]; string datenow = dd[0] + "" + bd[1]; string APIName = dsticketdetails.Tables[0].Rows[0]["APIName"].ToString(); lblCode.Text = GenerateRandomCode(); TimeSpan s = DateTime.Parse(datenow) - DateTime.Now; if (s.Days > 0) { dayhours = Convert.ToInt32(s.Days) * 24; } if (s.Minutes > 30) { hour = dayhours + s.Hours + 1; } if (s.Minutes <= 30) { hour = dayhours + s.Hours; } if (hour > 0) { Session["NameMail"] = Name; Session["EmailIdMail"] = EmailId; #region Kesineni if (dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "Kesineni") { ViewState["APIName"] = "Kesineni"; rbtnlstCancelType.Visible = gvPartialCancellation.Visible = btnConfrmCancel.Visible = false; gvPartialCancellation.DataSource = dsticketdetails.Tables[1]; gvPartialCancellation.DataBind(); ViewState["dsticketdetails"] = dsticketdetails.Tables[0]; btnConfrmCancel_Click(sender, e); } #endregion #region AbhiBus else if (dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "SVR" || dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "KAVERI" || dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "RAJESH" || dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "SAIANJANA" || dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "KALLADA") { string ticketNumberAbhiBus = dsticketdetails.Tables[0].Rows[0]["PNRNumber"].ToString(); //cancelTicket ClientAPIList objClientAPIList = new ClientAPIList(); objClientAPIList = GetAPIProvidersList(ConsumerKey, ConsumerSecret); ClientAPIDetails objClientAPIDetails = objClientAPIList.SingleOrDefault(element => element.ProviderName == dsticketdetails.Tables[0].Rows[0]["APIName"].ToString()); //objClientAPIList.ElementAt(resultSet - 1) LJ.CLB.Buses.AbhibusAPI obj = new LJ.CLB.Buses.AbhibusAPI(); DataTable dtAbhiBus = obj.cancelTicket(objClientAPIDetails.APIURL, objClientAPIDetails.ConsumerKey, ticketNumberAbhiBus); if (dtAbhiBus != null) { if (dtAbhiBus.Rows.Count > 0) { if (dtAbhiBus.Rows[0]["status"].ToString().ToUpper().Trim().ToString() == "SUCCESS") { string totalRefundAmount = dtAbhiBus.Rows[0]["total_refund_amount"].ToString(); string canpercentage = dtAbhiBus.Rows[0]["cancellation_parcentage"].ToString(); string[] canindec = canpercentage.Split('%'); double cancelcharges = Convert.ToDouble(totalfareabhi) * (Convert.ToDouble(canindec[0].ToString()) / 100); AddCancellation(BookingId, tentativeId, seatnumbers, EmailId, Convert.ToString(Convert.ToDouble(totalfareabhi) - cancelcharges), Convert.ToString(totalfareabhi), APIName, hour); Mail(dsticketdetails.Tables[0].Rows[0]["EmailId"].ToString(), dsticketdetails.Tables[0].Rows[0]["PGMBRefNo"].ToString()); objBAL = new ClsBAL(); objBAL.AdjustAgentBalance(txtMBRefNo.Text.Trim().ToString(), Convert.ToDouble(Convert.ToDouble(totalfareabhi) - cancelcharges), Convert.ToDouble(cancelcharges), Convert.ToInt32(Session["UserID"])); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = balance; Session["Balance"] = balance; txtEmailID.Text = txtMBRefNo.Text = ""; } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } } #endregion #region Kallada if (dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "kallada") { string ticketNumberkallada = dsticketdetails.Tables[0].Rows[0]["PNRNumber"].ToString(); DataTable dtkallada = objkalladaAPILayer.CancellationConfirmation(ticketNumberkallada); if (dtkallada != null) { if (dtkallada.Rows.Count > 0) { if (dtkallada.Rows[0]["status"].ToString() == "Success") { string totalRefundAmount = dtkallada.Rows[0]["total_refund_amount"].ToString(); string canpercentage = dtkallada.Rows[0]["cancellation_parcentage"].ToString(); string[] canindec = canpercentage.Split('%'); double cancelcharges = Convert.ToDouble(totalfareabhi) * (Convert.ToDouble(canindec[0].ToString()) / 100); DataTable dtKallada1 = objkalladaAPILayer.TicketCancellation(ticketNumberkallada); if (dtKallada1.Rows.Count > 0 && dtKallada1.Columns.Count > 1) { if (dtKallada1.Rows[0]["status"].ToString().ToUpper().Trim().ToString() != "FAIL") { AddCancellation(BookingId, tentativeId, seatnumbers, EmailId, Convert.ToString(Convert.ToDouble(totalfareabhi) - cancelcharges), Convert.ToString(totalfareabhi), APIName, hour); objBAL = new ClsBAL(); objBAL.AdjustAgentBalance(txtMBRefNo.Text.Trim().ToString(), Convert.ToDouble(Convert.ToDouble(totalfareabhi) - cancelcharges), Convert.ToDouble(cancelcharges), Convert.ToInt32(Session["UserID"])); } else { lblMsg.Text = "Ticket cancelled failed."; } DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = balance; Session["Balance"] = balance; txtEmailID.Text = txtMBRefNo.Text = ""; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; lblMsg.ForeColor = System.Drawing.Color.Red; } } #endregion #region Bitla else if (dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "BITLA") { ViewState["APIName"] = "Bitla"; rbtnlstCancelType.Visible = gvPartialCancellation.Visible = btnConfrmCancel.Visible = false; gvPartialCancellation.DataSource = dsticketdetails.Tables[1]; gvPartialCancellation.DataBind(); ViewState["dsticketdetails"] = dsticketdetails.Tables[0]; btnConfrmCancel_Click(sender, e); } #endregion #region TicketGoose else if (dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "TICKETGOOSE") { ViewState["APIName"] = "TicketGoose"; string ticketNumber = dsticketdetails.Tables[0].Rows[0]["PNRNumber"].ToString(); string[] seatNos = dsticketdetails.Tables[0].Rows[0]["SeatNos"].ToString().Split(','); DataTable dt = objTicketGooseAPILayer.CancelTicket(ticketNumber, seatNos); if (dt != null) { if (dt.Rows.Count > 0) { if (dt.Rows[0]["Status"].ToString() == "Success") { DataTable dtt = objTicketGooseAPILayer.ConfirmTicketCancellation(ticketNumber, seatNos); if (dtt != null) { if (dtt.Rows.Count > 0) { if (dtt.Rows[0]["Status"].ToString() == "Success") { string refAmount = dtt.Rows[0]["refundAmount"].ToString(); AddCancellation(BookingId, tentativeId, seatnumbers, EmailId, refAmount, Convert.ToString(Convert.ToDouble(totalfareabhi)), APIName, hour); Mail(dsticketdetails.Tables[0].Rows[0]["EmailId"].ToString(), dsticketdetails.Tables[0].Rows[0]["PGMBRefNo"].ToString()); objBAL = new ClsBAL(); objBAL.AdjustAgentBalance(txtMBRefNo.Text.Trim().ToString(), Convert.ToDouble(refAmount), Convert.ToDouble(Convert.ToDouble(totalfareabhi) - Convert.ToDouble(refAmount)), Convert.ToInt32(Session["UserID"])); } else { lblMsg.Text = "Ticket cancelled failed. Try Again"; } DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = balance; Session["Balance"] = balance; txtEmailID.Text = txtMBRefNo.Text = ""; } } } } } } #endregion #region EasyBus else if (dsticketdetails.Tables[0].Rows[0]["APIName"].ToString() == "EASYBUS") { string ticketNumberEasybus = dsticketdetails.Tables[0].Rows[0]["PNRNumber"].ToString(); //cancelTicket ClientAPIList objClientAPIList = new ClientAPIList(); objClientAPIList = GetAPIProvidersList(ConsumerKey, ConsumerSecret); ClientAPIDetails objClientAPIDetails = objClientAPIList.SingleOrDefault(element => element.ProviderName == dsticketdetails.Tables[0].Rows[0]["APIName"].ToString()); //objClientAPIList.ElementAt(resultSet - 1) LJ.CLB.Buses.EasybusAPI obj = new LJ.CLB.Buses.EasybusAPI(); DataTable dtEasybus = obj.cancelTicket(objClientAPIDetails.APIURL, objClientAPIDetails.ConsumerKey, ticketNumberEasybus, seatnumbers, dateofjourney); if (dtEasybus != null) { if (dtEasybus.Rows.Count > 0) { if (dtEasybus.Rows[0]["Message"].ToString() == "Your Ticket has been cancelled") { string totalRefundAmount = totalfareabhi; string canpercentage = "10"; string[] canindec = canpercentage.Split('%'); double cancelcharges = Convert.ToDouble(totalfareabhi) * (Convert.ToDouble(canindec[0].ToString()) / 100); AddCancellation(BookingId, tentativeId, seatnumbers, EmailId, Convert.ToString(Convert.ToDouble(totalfareabhi) - cancelcharges), Convert.ToString(totalfareabhi), APIName, hour); Mail(dsticketdetails.Tables[0].Rows[0]["EmailId"].ToString(), dsticketdetails.Tables[0].Rows[0]["PGMBRefNo"].ToString()); objBAL = new ClsBAL(); objBAL.AdjustAgentBalance(txtMBRefNo.Text.Trim().ToString(), Convert.ToDouble(totalRefundAmount), Convert.ToDouble(Convert.ToDouble(totalfareabhi) - Convert.ToDouble(totalRefundAmount)), Convert.ToInt32(Session["UserID"])); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = balance; Session["Balance"] = balance; txtEmailID.Text = txtMBRefNo.Text = ""; } } } } #endregion } else { tdmsg.Visible = true; //tdmsg.Style.Add("background-color:#E77471;", ""); lblMainMsg.Text = "Invalid Ref No."; lblMainMsg.ForeColor = System.Drawing.Color.Maroon; txtMBRefNo.Text = ""; } } else { tdmsg.Visible = true; //tdmsg.Style.Add("background-color:#E77471;", ""); lblMainMsg.Text = "Invalid Ref No."; lblMainMsg.ForeColor = System.Drawing.Color.Maroon; txtMBRefNo.Text = ""; } } else { tdmsg.Visible = true; //tdmsg.Style.Add("background-color:#E77471;", ""); lblMainMsg.Text = "Invalid Ref No."; lblMainMsg.ForeColor = System.Drawing.Color.Maroon; txtMBRefNo.Text = ""; } } } catch (Exception ex) { lblMsg.Text = ex.Message; throw ex; } }
protected void btnProceedToPayment_Click(object sender, EventArgs e) { try { if (cbxAgree.Checked == false) { lblMsg.Text = "please check the Terms & conditions."; return; } int? createdBy = null; if (Session["UserID"] != null) { createdBy = Convert.ToInt32(Session["UserID"].ToString()); } else { createdBy = 0; } if (Session["RedBusBookingDetails"] != null) { BookingDetails = (String[])Session["RedBusBookingDetails"]; // string gridviewdata = client.getBoardingPoint(BookingDetails[4].Split('~')[1]); // DataTable dtOnwardBoardingInfo = convertJsonStringToDataSet(gridviewdata).Tables[0]; string boardinginf = BookingDetails[4].ToString(); string strOnwardBoardingInfo = string.Empty; if (BookingDetails[19].ToString().Trim() == "TICKETGOOSE") { strOnwardBoardingInfo = Convert.ToString(BookingDetails[4].Split('~')[0]); } else { strOnwardBoardingInfo = Convert.ToString(BookingDetails[4]); } // string strOnwardBoardingInfo = dtOnwardBoardingInfo.Rows[0]["address"].ToString() + "," + // dtOnwardBoardingInfo.Rows[0]["landmark"].ToString(); String referenceNumber = ""; String referenceNumberReturn = ""; referenceNumber = GenerateManabusRefNo(); string provider = BookingDetails[19].ToString(); if (BookingDetails[5].ToLower().Contains("single")) { Session["Ticketrefno"] = referenceNumber; } Session["Order_Id"] = referenceNumber; Session["Amount"] = lblTotalAmountPayable.Text; string phoneno; //SingleTrip if (BookingDetails[5].ToLower().Contains("single")) { #region onwardTrip String nameList = ""; String genderList = ""; String titleList = ""; String ageList = ""; int countlist = 0; foreach (RepeaterItem item in rptPassengersonward.Items) { DropDownList ddlrptr = (DropDownList)item.FindControl("ddlGender"); TextBox txtPassengerNamerptr = (TextBox)item.FindControl("txtPassengerName"); TextBox txtAgerptr = (TextBox)item.FindControl("txtAge"); phoneno = txtPhoneNo.Text; if (countlist == 0) { ++countlist; nameList += txtPassengerNamerptr.Text; titleList += ddlrptr.SelectedItem.Value.ToString(); ageList += txtAgerptr.Text; genderList += ddlrptr.SelectedItem.Text.ToString(); } else { ++countlist; nameList += "," + txtPassengerNamerptr.Text; titleList += "," + ddlrptr.SelectedItem.Value.ToString(); ageList += "," + txtAgerptr.Text; genderList += "," + ddlrptr.SelectedItem.Text.ToString(); } } String passengerDetailsonward = ""; string bookingid = ""; string boarding = lblBoardingPoint.ToolTip.ToString(); BlockSeats blockseats = new BlockSeats(); blockseats.SourceId = int.Parse(BookingDetails[10]); blockseats.DestinationId = int.Parse(BookingDetails[11]); blockseats.TripId = BookingDetails[12]; blockseats.JourneyDate = BookingDetails[1]; blockseats.BoardingId = BookingDetails[4].Split('~')[1]; blockseats.NoOfSeats = countlist; blockseats.SeatNo = BookingDetails[2]; blockseats.Title = titleList; blockseats.Name = nameList; blockseats.Age = ageList; blockseats.Sex = genderList; blockseats.Address = txtAddress.Text; blockseats.BookingRefNo = referenceNumber; blockseats.IdCardType = ddlIDType.SelectedItem.Text; blockseats.IdCardNo = txtIDNumber.Text; blockseats.IdCardIssuedBy = txtIdIssuedBY.Text; blockseats.MobileNo = txtPhoneNo.Text; blockseats.EmergencyMobileNo = txtPhoneNo.Text; blockseats.EmailId = txtEmailId.Text; blockseats.ProviderName = BookingDetails[19].ToString(); blockseats.BookingId = bookingid; string blockresult = client.blockTicket(blockseats); DataSet ds = convertJsonStringToDataSet(blockresult); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Columns.Contains("Status")) { if (ds.Tables[0].Rows[0]["Status"].ToString().ToUpper() == "SUCCESS") { if (ds.Tables[0].Columns.Contains("BookingID")) { blockseats.BookingId = ds.Tables[0].Rows[0]["BookingID"].ToString(); lblMsg.Text = Convert.ToString(ds.Tables[0].Rows[0]["Status"]); } } else { lblMsg.Text = ds.Tables[0].Rows[0]["message"].ToString(); return; } } } } if (Session["UserID"] != null) { if (Session["Role"].ToString() == "Agent") { ClsBAL objBAL = new ClsBAL(); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"])); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "Bus", provider); // Change it if (dsCommSlab != null) { if (dsCommSlab.Tables[0].Rows.Count > 0) { string commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); //string commisionPercentage = dsBalance.Tables[0].Rows[0]["CommisionPercentage"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string actualFare; string deductAmount; string commisionFare; if (ViewState["MarkUp"] != null) { double Am = Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) - Convert.ToDouble(ViewState["MarkUp"].ToString()); actualFare = Am.ToString(); deductAmount = Convert.ToString(Convert.ToDouble(actualFare.ToString()) - ((Convert.ToDouble(actualFare.ToString()) * Convert.ToDouble(commisionPercentage)) / 100)); commisionFare = Convert.ToString(Convert.ToDouble(actualFare.ToString()) - Convert.ToDouble(deductAmount)); } else { actualFare = lblTotalAmountPayable.Text.ToString(); deductAmount = Convert.ToString(Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) - ((Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) * Convert.ToDouble(commisionPercentage)) / 100)); commisionFare = Convert.ToString(Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) - Convert.ToDouble(deductAmount)); } Session["AgentId_Agent"] = agentId; Session["ActualFare_Agent"] = actualFare; Session["CommisionFare_Agent"] = commisionFare; Session["CommisionPercentage_Agent"] = commisionPercentage; Session["DeductAmount_Agent"] = deductAmount; Session["Markup"] = ViewState["MarkUp"]; if (Convert.ToDouble(balance) >= Convert.ToDouble(deductAmount)) { bool b = objBAL.UpdateAgentBalance(Convert.ToInt32(agentId), Convert.ToDouble(deductAmount), Convert.ToDouble(commisionFare)); //UpdateagentBalance,@RefundAmount } else { lblMsg.Text = "You dont have enough balance to book a ticket."; return; } } else { lblMsg.Text = "Please Contact administrater "; return; } } } } Session["blockseats"] = blockseats; if (lblMsg.Text.ToString().ToUpper() == "SUCCESS" && lblMsg.Text.ToString().ToLower() != "tentative booking failed") { string[] strDate = BookingDetails[1].Trim().ToString().Split('-'); dt = Convert.ToDateTime(strDate[2] + "-" + strDate[1] + "-" + strDate[0]); int countpassengers = 0; foreach (RepeaterItem item in rptPassengersonward.Items) { DropDownList ddlrptr = (DropDownList)item.FindControl("ddlGender"); Label lblSeatNorptr = (Label)item.FindControl("lblSeatNo"); TextBox txtPassengerNamerptr = (TextBox)item.FindControl("txtPassengerName"); TextBox txtAgerptr = (TextBox)item.FindControl("txtAge"); if (countpassengers == 0) { ++countpassengers; passengerDetailsonward += lblSeatNorptr.Text + "-" + ddlrptr.SelectedItem.Value + "-" + txtPassengerNamerptr.Text + "-" + txtAgerptr.Text; } else { ++countpassengers; passengerDetailsonward += "," + lblSeatNorptr.Text + "-" + ddlrptr.SelectedItem.Value + "-" + txtPassengerNamerptr.Text + "-" + txtAgerptr.Text; } } } string[] str = new string[1]; str[0] = " to"; //BookingDetails[4].Split('-')[7].Split('~')[1] String[] cities = BookingDetails[0].ToString().Split(str, StringSplitOptions.None); res = InsertTentativeBooking(referenceNumber, Convert.ToString(Session["Ticketrefno"]), blockseats.BookingId, lblMsg.Text.ToString(), "", "", null, provider , BookingDetails[15].ToString(), BookingDetails[14].ToString(), dt , Convert.ToInt32(BookingDetails[10].ToString()), cities[0].ToString() , Convert.ToInt32(BookingDetails[11].ToString()), cities[1].ToString() , lblSeatNos.Text.ToString(), rptPassengersonward.Items.Count,Convert.ToDecimal(ViewState["MarkUp"].ToString()), Convert.ToDecimal(lblFare.Text.Trim().ToString()), null , strOnwardBoardingInfo, BookingDetails[4].Split('-')[0].ToString() + "-" + BookingDetails[4].Split('-')[BookingDetails[4].Split('-').Length - 1].ToString().Split('~')[0].ToString(), nameList, 20, "M", txtPhoneNo.Text.ToString() , txtEmailId.Text.ToString(), txtAddress.Text.ToString() , "", null, 0, 0, "Online", "Cash", "Oneway", createdBy, "Online", "", passengerDetailsonward , ddlIDType.SelectedItem.Text.ToString(), txtIDNumber.Text.ToString(), "", provider, Convert.ToDouble(Session["CommisionFare_Agent"]), blockseats.TripId, blockseats.Title, Convert.ToString(blockseats.BoardingId)); if (res == true) { if (Session["UserID"] != null) { if (Session["Role"].ToString() == "Admin" || Session["Role"].ToString() == "CSE") { lblMsg.Text = client.bookTicket(blockseats); DataSet dsbook = convertJsonStringToDataSet(lblMsg.Text); if (dsbook != null) { if (dsbook.Tables[0].Rows.Count > 0) { if (dsbook.Tables[0].Columns.Contains("APIPNR")) { lblMsg.Text = dsbook.Tables[0].Rows[0]["APIPNR"].ToString(); } } } if (Convert.ToString(dsbook.Tables[0].Rows[0]["APIPNR"]) == "SUCCESS" || Convert.ToString(dsbook.Tables[0].Rows[0]["Status"]).ToUpper() == "SUCCESS") { if (lblMsg.Text.ToString().Split(' ').Length == 1) { InsertBookedTicketDetails(referenceNumber, lblMsg.Text.ToString()); Response.Redirect("redirectbus.aspx", false); } } else { return; //Booking Failed. } } else if (Session["Role"].ToString() == "Agent") { lblMsg.Text = client.bookTicket(blockseats); DataSet dsbook = convertJsonStringToDataSet(lblMsg.Text); if (dsbook != null) { if (dsbook.Tables[0].Rows.Count > 0) { if (dsbook.Tables[0].Columns.Contains("APIPNR")) { lblMsg.Text = dsbook.Tables[0].Rows[0]["APIPNR"].ToString(); } } } if (Convert.ToString(dsbook.Tables[0].Rows[0]["APIPNR"]) == "SUCCESS" || Convert.ToString(dsbook.Tables[0].Rows[0]["Status"]).ToUpper() == "SUCCESS") { if (lblMsg.Text.ToString().Split(' ').Length == 1) { InsertBookedTicketDetails(referenceNumber, lblMsg.Text.ToString()); Response.Redirect("redirectbus.aspx", false); } } else { return; //Booking Failed. } } else if (Convert.ToDouble(lblTotalAmountPayable.Text) == Convert.ToDouble(0)) { lblMsg.Text = client.bookTicket(blockseats); DataSet dsbook = convertJsonStringToDataSet(lblMsg.Text); if (dsbook != null) { if (dsbook.Tables[0].Rows.Count > 0) { if (dsbook.Tables[0].Columns.Contains("APIPNR")) { lblMsg.Text = dsbook.Tables[0].Rows[0]["APIPNR"].ToString(); } } } if (Convert.ToString(dsbook.Tables[0].Rows[0]["APIPNR"]) == "SUCCESS" || Convert.ToString(dsbook.Tables[0].Rows[0]["Status"]).ToUpper() == "SUCCESS") { if (lblMsg.Text.ToString().Split(' ').Length == 1) { InsertBookedTicketDetails(referenceNumber, lblMsg.Text.ToString()); Response.Redirect("redirectbus.aspx", false); } } else { return; //Booking Failed. } } else if (Session["Role"].ToString() == "User") { Server.Transfer("Pay.aspx?val=bus"); } } else { // Response.Redirect("redirectbus.aspx?Refno=" + Session["Ticketrefno"].ToString(), false); Response.Redirect("Pay.aspx?val=bus", false); } } #endregion } } else { Response.Redirect("~/Default.aspx", false); } } catch (Exception ex) { lblMsg.Text = ex.ToString(); } }
private void saveround(object sender, EventArgs e) { try { DataSet ds = new DataSet(); FlightBAL objFlightsBal = new FlightBAL(); string ReferenceNo = Convert.ToString(Session["Order_Id"]); DataSet dtid = objFlightsBal.IGetInternationalFlightDetails(ReferenceNo); id1 = dtid.Tables[0].Rows[0]["id"].ToString(); key = dtid.Tables[0].Rows[0]["Key1"].ToString(); string[] strfare = dtid.Tables[0].Rows[0]["ActualBasefare"].ToString().Split('.'); actualBaseFare = strfare[0].ToString(); string[] strtax = dtid.Tables[0].Rows[0]["Tax"].ToString().Split('.'); tax = strtax[0].ToString(); string[] strstax = dtid.Tables[0].Rows[0]["STax"].ToString().Split('.'); Stax = strstax[0].ToString(); string[] strscharge = dtid.Tables[0].Rows[0]["Scharge"].ToString().Split('.'); SCharge = strscharge[0].ToString(); string[] strtdis = dtid.Tables[0].Rows[0]["TDiscount"].ToString().Split('.'); TDiscount = strtdis[0].ToString(); string[] strtcomm = dtid.Tables[0].Rows[0]["TPartnerCommission"].ToString().Split('.'); TPartnerCommission = strtcomm[0].ToString(); string[] strtsdis = dtid.Tables[0].Rows[0]["TSDiscount"].ToString().Split('.'); TSdiscount = strtsdis[0].ToString(); string[] strmark = dtid.Tables[0].Rows[0]["TMarkUp"].ToString().Split('.'); TMarkup = strmark[0].ToString(); string[] strtcharge = dtid.Tables[0].Rows[0]["TCharge"].ToString().Split('.'); TCharge = strtcharge[0].ToString(); idRet = dtid.Tables[0].Rows[0]["idRet"].ToString(); keyRet = dtid.Tables[0].Rows[0]["Key1Ret"].ToString(); string[] strfareRet = dtid.Tables[0].Rows[0]["ActualBasefareRet"].ToString().Split('.'); actualBaseFareRet = strfareRet[0].ToString(); string[] strtaxRet = dtid.Tables[0].Rows[0]["TaxRet"].ToString().Split('.'); taxRet = strtaxRet[0].ToString(); string[] strstaxRet = dtid.Tables[0].Rows[0]["STaxRet"].ToString().Split('.'); StaxRet = strstaxRet[0].ToString(); string[] strschargeRet = dtid.Tables[0].Rows[0]["SchargeRet"].ToString().Split('.'); SChargeRet = strschargeRet[0].ToString(); string[] strtdisRet = dtid.Tables[0].Rows[0]["TDiscountRet"].ToString().Split('.'); TDiscountRet = strtdisRet[0].ToString(); string[] strtcommRet = dtid.Tables[0].Rows[0]["TPartnerCommissionRet"].ToString().Split('.'); TPartnerCommissionRet = strtcommRet[0].ToString(); string[] strtsdisRet = dtid.Tables[0].Rows[0]["TSDiscountRet"].ToString().Split('.'); TSdiscountRet = strtsdisRet[0].ToString(); string[] strmarkRet = dtid.Tables[0].Rows[0]["TMarkUpRet"].ToString().Split('.'); TMarkupRet = strmarkRet[0].ToString(); string[] strtchargeRet = dtid.Tables[0].Rows[0]["TChargeRet"].ToString().Split('.'); TChargeRet = strtchargeRet[0].ToString(); // octax = dtid.Tables[0].Rows[0]["Octax"].ToString(); Customer_Details = dtid.Tables[0].Rows[0]["Customer_Details"].ToString(); telephone = dtid.Tables[0].Rows[0]["telephone"].ToString(); emailAddress = dtid.Tables[0].Rows[0]["emailAddress"].ToString(); adultcnt = Convert.ToInt32(dtid.Tables[0].Rows[0]["AdultPax"]); infantCnt = Convert.ToInt32(dtid.Tables[0].Rows[0]["InfantPax"]); childCnt = Convert.ToInt32(dtid.Tables[0].Rows[0]["ChildPax"]); refNo = dtid.Tables[0].Rows[0]["ReferenceNo"].ToString(); string ReferenceNo1 = dtid.Tables[0].Rows[0]["Dom_Booking_Id"].ToString(); DataSet dsdbsave = objFlightsBal.GetInternationalFlightDetailsI1(ReferenceNo1); //1st row AirEquipType = dsdbsave.Tables[0].Rows[0]["AirEquipType"].ToString(); ArrivalAirportCode = dsdbsave.Tables[0].Rows[0]["ArrivalAirportCode"].ToString(); // ArrivalAirportName = dsdbsave.Tables[0].Rows[0]["ArrivalAirportName"].ToString(); ArrivalDateTime = dsdbsave.Tables[0].Rows[0]["ArrivalDateTime"].ToString(); DepartureAirportCode = dsdbsave.Tables[0].Rows[0]["DepartureAirportCode"].ToString(); // DepartureAirportName = dsdbsave.Tables[0].Rows[0]["DepartureAirportName"].ToString(); DepartureDateTime = dsdbsave.Tables[0].Rows[0]["DepartureDateTime"].ToString(); FlightNumber = dsdbsave.Tables[0].Rows[0]["FlightNumber"].ToString(); // MarketingAirlineCode = dsdbsave.Tables[0].Rows[0]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = dsdbsave.Tables[0].Rows[0]["OperatingAirlineCode"].ToString(); airLineName = dsdbsave.Tables[0].Rows[0]["airlineName"].ToString(); OperatingAirlineFlightNumber = dsdbsave.Tables[0].Rows[0]["OperatingAirlineFlightNumber"].ToString(); RPH = dsdbsave.Tables[0].Rows[0]["RPH"].ToString(); StopQuantity = dsdbsave.Tables[0].Rows[0]["StopQuantity"].ToString(); airportTax = dsdbsave.Tables[0].Rows[0]["airportTax"].ToString(); imageFileName = dsdbsave.Tables[0].Rows[0]["imageFileName"].ToString(); string[] strdis = dsdbsave.Tables[0].Rows[0]["Discount"].ToString().Split('.'); Discount = strdis[0].ToString(); airportTaxChild = dsdbsave.Tables[0].Rows[0]["airportTaxChild"].ToString(); airportTaxInfant = dsdbsave.Tables[0].Rows[0]["airportTaxInfant"].ToString(); airportTaxChild = dsdbsave.Tables[0].Rows[0]["airportTaxChild"].ToString(); airportTaxInfant = dsdbsave.Tables[0].Rows[0]["airportTaxInfant"].ToString(); childTaxBreakup = dsdbsave.Tables[0].Rows[0]["ChildTaxBreakUp"].ToString(); infantTaxBreakup = dsdbsave.Tables[0].Rows[0]["InfantTaxBreakUp"].ToString(); adultTaxBreakup = dsdbsave.Tables[0].Rows[0]["adultTaxBreakUp"].ToString(); octax = dsdbsave.Tables[0].Rows[0]["ocTax"].ToString(); BookingClassResBookDesigCode = dsdbsave.Tables[0].Rows[0]["ResBookingCode"].ToString(); string[] stradultfare = dsdbsave.Tables[0].Rows[0]["adultFare"].ToString().Split('.'); adultFare = stradultfare[0].ToString(); BookingClassAvailability = dsdbsave.Tables[0].Rows[0]["Availability"].ToString(); string[] strchildfare = dsdbsave.Tables[0].Rows[0]["ChildFare"].ToString().Split('.'); childFare = strchildfare[0].ToString(); bookingclass = dsdbsave.Tables[0].Rows[0]["bookingClass"].ToString(); classType = dsdbsave.Tables[0].Rows[0]["ClassType"].ToString(); farebasiscode = dsdbsave.Tables[0].Rows[0]["farebasisCode"].ToString(); string[] strinffare = dsdbsave.Tables[0].Rows[0]["infantFare"].ToString().Split('.'); infantfare = strinffare[0].ToString(); Rule = dsdbsave.Tables[0].Rows[0]["Fare_Rule"].ToString(); string[] stradultcomm = dsdbsave.Tables[0].Rows[0]["adultCommission"].ToString().Split('.'); adultCommission = stradultcomm[0].ToString(); string[] strchildcomm = dsdbsave.Tables[0].Rows[0]["childCommission"].ToString().Split('.'); childCommission = strchildcomm[0].ToString(); string[] strcommoncharge = dsdbsave.Tables[0].Rows[0]["CommissionOnTCharge"].ToString().Split('.'); commissionOnTCharge = strcommoncharge[0].ToString(); //2nd row AirEquipTypeRet = dsdbsave.Tables[0].Rows[1]["AirEquipType"].ToString(); ArrivalAirportCodeRet = dsdbsave.Tables[0].Rows[1]["ArrivalAirportCode"].ToString(); // ArrivalAirportName = dsdbsave.Tables[0].Rows[0]["ArrivalAirportName"].ToString(); ArrivalDateTimeRet = dsdbsave.Tables[0].Rows[1]["ArrivalDateTime"].ToString(); DepartureAirportCodeRet = dsdbsave.Tables[0].Rows[1]["DepartureAirportCode"].ToString(); // DepartureAirportName = dsdbsave.Tables[0].Rows[0]["DepartureAirportName"].ToString(); DepartureDateTimeRet = dsdbsave.Tables[0].Rows[1]["DepartureDateTime"].ToString(); FlightNumberRet = dsdbsave.Tables[0].Rows[1]["FlightNumber"].ToString(); // MarketingAirlineCode = dsdbsave.Tables[0].Rows[0]["MarketingAirlineCode"].ToString(); OperatingAirlineCodeRet = dsdbsave.Tables[0].Rows[1]["OperatingAirlineCode"].ToString(); airLineNameRet = dsdbsave.Tables[0].Rows[1]["airlineName"].ToString(); OperatingAirlineFlightNumberRet = dsdbsave.Tables[0].Rows[1]["OperatingAirlineFlightNumber"].ToString(); RPHRet = dsdbsave.Tables[0].Rows[1]["RPH"].ToString(); StopQuantityRet = dsdbsave.Tables[0].Rows[1]["StopQuantity"].ToString(); airportTaxRet = dsdbsave.Tables[0].Rows[1]["airportTax"].ToString(); imageFileNameRet = dsdbsave.Tables[0].Rows[1]["imageFileName"].ToString(); string[] strdisRet = dsdbsave.Tables[0].Rows[1]["Discount"].ToString().Split('.'); DiscountRet = strdisRet[0].ToString(); airportTaxChildRet = dsdbsave.Tables[0].Rows[1]["airportTaxChild"].ToString(); airportTaxInfantRet = dsdbsave.Tables[0].Rows[1]["airportTaxInfant"].ToString(); airportTaxChildRet = dsdbsave.Tables[0].Rows[1]["airportTaxChild"].ToString(); airportTaxInfantRet = dsdbsave.Tables[0].Rows[1]["airportTaxInfant"].ToString(); childTaxBreakupRet = dsdbsave.Tables[0].Rows[1]["ChildTaxBreakUp"].ToString(); infantTaxBreakupRet = dsdbsave.Tables[0].Rows[1]["InfantTaxBreakUp"].ToString(); adultTaxBreakupRet = dsdbsave.Tables[0].Rows[0]["adultTaxBreakUp"].ToString(); octaxRet = dsdbsave.Tables[0].Rows[1]["ocTax"].ToString(); BookingClassResBookDesigCodeRet = dsdbsave.Tables[0].Rows[1]["ResBookingCode"].ToString(); string[] stradultretfare = dsdbsave.Tables[0].Rows[1]["adultFare"].ToString().Split('.'); adultFareRet = stradultretfare[0].ToString(); BookingClassAvailabilityRet = dsdbsave.Tables[0].Rows[1]["Availability"].ToString(); string[] strchildretfare = dsdbsave.Tables[0].Rows[1]["ChildFare"].ToString().Split('.'); childFareRet = strchildretfare[0].ToString(); bookingclassRet = dsdbsave.Tables[0].Rows[1]["bookingClass"].ToString(); classTypeRet = dsdbsave.Tables[0].Rows[1]["ClassType"].ToString(); farebasiscodeRet = dsdbsave.Tables[0].Rows[1]["farebasisCode"].ToString(); string[] strinfantfareret = dsdbsave.Tables[0].Rows[1]["infantFare"].ToString().Split('.'); infantfareRet = strinfantfareret[0].ToString(); RuleRet = dsdbsave.Tables[0].Rows[1]["Fare_Rule"].ToString(); string[] stracr = dsdbsave.Tables[0].Rows[1]["adultCommission"].ToString().Split('.'); adultCommissionRet = stracr[0].ToString(); string[] strccr = dsdbsave.Tables[0].Rows[1]["childCommission"].ToString().Split('.'); childCommissionRet = strccr[0].ToString(); string[] ctcr = dsdbsave.Tables[0].Rows[1]["CommissionOnTCharge"].ToString().Split('.'); commissionOnTChargeRet = ctcr[0].ToString(); //String XMLPricing = "<pricingrequest><onwardFlights><OriginDestinationOption><FareDetails><ChargeableFares><ActualBaseFare>" + actualBaseFare + "</ActualBaseFare><Tax>" + tax + "</Tax> <STax>" + Stax + "</STax><SCharge>" + SCharge + "</SCharge> <TDiscount>" + TDiscount + "</TDiscount><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TCharge + "</TCharge> <TMarkup>" + TMarkup + "</TMarkup><TSdiscount>" + TDiscount + "</TSdiscount> </NonchargeableFares></FareDetails> <FlightSegments> <FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><RPH>" + RPH + "</RPH> <StopQuantity>" + StopQuantity + "</StopQuantity><airLineName>" + airLineName + "</airLineName><airportTax>" + airportTax + "</airportTax><imageFileName>" + imageFileName + "</imageFileName> <BookingClass><Availability>" + BookingClassAvailability + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCode + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFare + "</adultFare><bookingclass>" + bookingclass + "</bookingclass> <childFare>" + childFare + "</childFare><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><infantfare>" + infantfare + "</infantfare> <Rule>" + Rule + "</Rule><adultCommission>" + adultCommission + "</adultCommission><childCommission>" + childCommission + "</childCommission><commissionOnTCharge>" + commissionOnTCharge + "</commissionOnTCharge></BookingClassFare> <Discount>" + Discount + "</Discount><airportTaxChild>" + airportTaxChild + "</airportTaxChild><airportTaxInfant>" + airportTaxInfant + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakup + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakup + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakup + "</infantTaxBreakup><octax>" + octax + "</octax> </FlightSegment> </FlightSegments><id>" + id + "</id><key>" + key + "</key> </OriginDestinationOption></onwardFlights><returnFlights/> <telePhone>" + txtPhoneNum.Text + "</telePhone><email>" + txtEmailID.Text + "</email> <creditcardno></creditcardno><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooFWS1.1</Clienttype><AdultPax>" + adultcnt + "</AdultPax><ChildPax>" + childCnt + "</ChildPax><InfantPax>" + infantCnt + "</InfantPax></pricingrequest>"; //DataSet dsFlightPricing = objFlights.GetPricingDetails(XMLPricing); #region Pricing String XMLPricing = "<pricingrequest><onwardFlights><OriginDestinationOption><FareDetails><ChargeableFares><ActualBaseFare>" + actualBaseFare + "</ActualBaseFare><Tax>" + tax + "</Tax> <STax>" + Stax + "</STax><SCharge>" + SCharge + "</SCharge> <TDiscount>" + TDiscount + "</TDiscount><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TCharge + "</TCharge> <TMarkup>" + TMarkup + "</TMarkup><TSdiscount>" + TDiscount + "</TSdiscount> </NonchargeableFares></FareDetails> <FlightSegments> <FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><RPH>" + RPH + "</RPH> <StopQuantity>" + StopQuantity + "</StopQuantity><airLineName>" + airLineName + "</airLineName><airportTax>" + airportTax + "</airportTax><imageFileName>" + imageFileName + "</imageFileName> <BookingClass><Availability>" + BookingClassAvailability + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCode + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFare + "</adultFare><bookingclass>" + bookingclass + "</bookingclass> <childFare>" + childFare + "</childFare><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><infantfare>" + infantfare + "</infantfare> <Rule>" + Rule + "</Rule><adultCommission>" + adultCommission + "</adultCommission><childCommission>" + childCommission + "</childCommission><commissionOnTCharge>" + commissionOnTCharge + "</commissionOnTCharge></BookingClassFare> <Discount>" + Discount + "</Discount><airportTaxChild>" + airportTaxChild + "</airportTaxChild><airportTaxInfant>" + airportTaxInfant + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakup + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakup + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakup + "</infantTaxBreakup><octax>" + octax + "</octax> </FlightSegment> </FlightSegments><id>" + id1 + "</id><key>" + key + "</key> </OriginDestinationOption></onwardFlights>"; XMLPricing = XMLPricing + "<returnFlights><OriginDestinationOption><FareDetails><ChargeableFares><ActualBaseFare>" + actualBaseFareRet + "</ActualBaseFare><Tax>" + taxRet + "</Tax> <STax>" + StaxRet + "</STax><SCharge>" + SChargeRet + "</SCharge> <TDiscount>" + TDiscountRet + "</TDiscount><TPartnerCommission>" + TPartnerCommissionRet + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TChargeRet + "</TCharge> <TMarkup>" + TMarkupRet + "</TMarkup><TSdiscount>" + TDiscountRet + "</TSdiscount> </NonchargeableFares></FareDetails> <FlightSegments> <FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><RPH>" + RPHRet + "</RPH> <StopQuantity>" + StopQuantityRet + "</StopQuantity><airLineName>" + airLineNameRet + "</airLineName><airportTax>" + airportTaxRet + "</airportTax><imageFileName>" + imageFileNameRet + "</imageFileName> <BookingClass><Availability>" + BookingClassAvailabilityRet + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCodeRet + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFareRet + "</adultFare><bookingclass>" + bookingclassRet + "</bookingclass> <childFare>" + childFareRet + "</childFare><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><infantfare>" + infantfareRet + "</infantfare> <Rule>" + RuleRet + "</Rule><adultCommission>" + adultCommissionRet + "</adultCommission><childCommission>" + childCommissionRet + "</childCommission><commissionOnTCharge>" + commissionOnTChargeRet + "</commissionOnTCharge></BookingClassFare> <Discount>" + DiscountRet + "</Discount><airportTaxChild>" + airportTaxChildRet + "</airportTaxChild><airportTaxInfant>" + airportTaxInfantRet + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakupRet + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakupRet + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakupRet + "</infantTaxBreakup><octax>" + octaxRet + "</octax> </FlightSegment> </FlightSegments><id>" + idRet + "</id><key>" + keyRet + "</key> </OriginDestinationOption></returnFlights>"; XMLPricing = XMLPricing + "<telePhone>" + telephone + "</telePhone><email>" + emailAddress + "</email> <creditcardno></creditcardno><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooFWS1.1</Clienttype><AdultPax>" + adultcnt + "</AdultPax><ChildPax>" + childCnt + "</ChildPax><InfantPax>" + infantCnt + "</InfantPax></pricingrequest>"; DataSet dsFlightPricing = objFlights.GetPricingDetails(XMLPricing); if (dsFlightPricing.Tables.Count > 0) { if (!dsFlightPricing.Tables[0].Columns.Contains("error")) { string ReturnFlightId = dsFlightPricing.Tables["returnFlights"].Rows[0]["ReturnFlights_Id"].ToString(); DataTable dtchangeFlightSegments = dsFlightPricing.Tables["originDestinationoption"]; if (dtchangeFlightSegments.Rows.Count > 0) { DataRow[] rowchangeFilghtSegments = dtchangeFlightSegments.Select("ReturnFlights_Id=" + ReturnFlightId); originDestination_IdRet = rowchangeFilghtSegments[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtchangeFareDetails = dsFlightPricing.Tables[3]; if (dtchangeFareDetails.Rows.Count > 0) { DataRow[] rowchangeFareDetails = dtchangeFareDetails.Select("OriginDestinationOption_Id=" + originDestination_IdRet); fareDetailsIdRet = rowchangeFareDetails[0]["FareDetails_Id"].ToString(); } DataTable dtchangeprice = dsFlightPricing.Tables[4]; DataTable dtNonchangeprice = dsFlightPricing.Tables[5]; if (dtchangeprice.Rows.Count > 0) { DataRow[] rowchangeprices = dtchangeprice.Select("FareDetails_Id=" + fareDetailsIdRet); DataRow[] rowNonchangeprices = dtNonchangeprice.Select("FareDetails_Id=" + fareDetailsIdRet); TPartnerCommissionRet = rowchangeprices[0]["TPartnerCommission"].ToString(); actualBaseFareRet = rowchangeprices[0]["ActualBaseFare"].ToString(); taxRet = rowchangeprices[0]["Tax"].ToString(); StaxRet = rowchangeprices[0]["Stax"].ToString(); SChargeRet = rowchangeprices[0]["SCharge"].ToString(); TDiscountRet = rowchangeprices[0]["TDiscount"].ToString(); TChargeRet = rowNonchangeprices[0]["TCharge"].ToString(); TotalFare = (Convert.ToDecimal(actualBaseFareRet) + Convert.ToDecimal(taxRet) + Convert.ToDecimal(StaxRet) + Convert.ToDecimal(TChargeRet) + Convert.ToDecimal(rowNonchangeprices[0]["TMarkup"])).ToString();//+ Convert.ToDecimal(SChargeRet) + Convert.ToDecimal(TDiscountRet) } } } #endregion refNo = Convert.ToString(Session["Order_Id"]); String xmlRequestData = "<Bookingrequest><onwardFlights><OriginDestinationOption><FareDetails> <ChargeableFares><ActualBaseFare>" + actualBaseFare + "</ActualBaseFare> <Tax>" + tax + "</Tax><STax>" + Stax + "</STax> <SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TCharge + "</TCharge> <TMarkup>" + TMarkup + "</TMarkup><TSdiscount>" + TSdiscount + "</TSdiscount> </NonchargeableFares></FareDetails>"; xmlRequestData = xmlRequestData + "<FlightSegments> <FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><RPH>" + RPH + "</RPH> <StopQuantity>" + StopQuantity + "</StopQuantity><airLineName>" + airLineName + "</airLineName><airportTax>" + airportTax + "</airportTax><imageFileName>" + imageFileName + "</imageFileName>"; xmlRequestData = xmlRequestData + "<BookingClass><Availability>" + BookingClassAvailability + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCode + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFare + "</adultFare><bookingclass>" + bookingclass + "</bookingclass> <childFare>" + childFare + "</childFare><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><infantfare>" + infantfare + "</infantfare> <Rule>" + Rule + "</Rule><adultCommission>" + adultCommission + "</adultCommission><childCommission>" + childCommission + "</childCommission><commissionOnTCharge>" + commissionOnTCharge + "</commissionOnTCharge></BookingClassFare>"; xmlRequestData = xmlRequestData + "<Discount>" + Discount + "</Discount><airportTaxChild>" + airportTaxChild + "</airportTaxChild><airportTaxInfant>" + airportTaxInfant + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakup + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakup + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakup + "</infantTaxBreakup><octax>" + octax + "</octax> </FlightSegment> </FlightSegments>"; xmlRequestData = xmlRequestData + "<id>" + id1 + "</id><key>" + key + "</key> </OriginDestinationOption></onwardFlights>"; xmlRequestData = xmlRequestData + "<returnFlights><OriginDestinationOption><FareDetails> <ChargeableFares><ActualBaseFare>" + actualBaseFareRet + "</ActualBaseFare> <Tax>" + taxRet + "</Tax><STax>" + StaxRet + "</STax> <SCharge>" + SChargeRet + "</SCharge><TDiscount>" + TDiscountRet + "</TDiscount><TPartnerCommission>" + TPartnerCommissionRet + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TChargeRet + "</TCharge> <TMarkup>" + TMarkupRet + "</TMarkup><TSdiscount>" + TSdiscountRet + "</TSdiscount> </NonchargeableFares></FareDetails>"; xmlRequestData = xmlRequestData + "<FlightSegments> <FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><RPH>" + RPHRet + "</RPH> <StopQuantity>" + StopQuantityRet + "</StopQuantity><airLineName>" + airLineNameRet + "</airLineName><airportTax>" + airportTaxRet + "</airportTax><imageFileName>" + imageFileNameRet + "</imageFileName>"; xmlRequestData = xmlRequestData + "<BookingClass><Availability>" + BookingClassAvailabilityRet + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCodeRet + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFareRet + "</adultFare><bookingclass>" + bookingclassRet + "</bookingclass> <childFare>" + childFareRet + "</childFare><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><infantfare>" + infantfareRet + "</infantfare> <Rule>" + RuleRet + "</Rule><adultCommission>" + adultCommissionRet + "</adultCommission><childCommission>" + childCommissionRet + "</childCommission><commissionOnTCharge>" + commissionOnTChargeRet + "</commissionOnTCharge></BookingClassFare>"; xmlRequestData = xmlRequestData + "<Discount>" + DiscountRet + "</Discount><airportTaxChild>" + airportTaxChildRet + "</airportTaxChild><airportTaxInfant>" + airportTaxInfantRet + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakupRet + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakupRet + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakupRet + "</infantTaxBreakup><octax>" + octaxRet + "</octax> </FlightSegment> </FlightSegments>"; xmlRequestData = xmlRequestData + "<id>" + idRet + "</id><key>" + keyRet + "</key> </OriginDestinationOption></returnFlights>"; xmlRequestData = xmlRequestData + "<personName>"; // Dynamic generation of names of adults, infants , Child #region old //Table tbladults = (Table)this.UpdatePanel1.FindControl("tblAdults"); //for (int i = 1; i <= adultcnt; i++) //{ // TextBox txtFn = (TextBox)tbladults.FindControl("txtFn" + i); // TextBox txtLn = (TextBox)tbladults.FindControl("txtLn" + i); // DropDownList ddlTitle = (DropDownList)tbladults.FindControl("ddlTitle" + i); // xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; //} //Table tblChild = (Table)this.UpdatePanel1.FindControl("tblChild"); //for (int i = 1; i <= childCnt; i++) //{ // TextBox txtFn = (TextBox)tblChild.FindControl("txtCFn" + i); // TextBox txtLn = (TextBox)tblChild.FindControl("txtCLn" + i); // DropDownList ddlTitle = (DropDownList)tblChild.FindControl("ddlCTitle" + i); // TextBox txtBirthDate = (TextBox)tblChild.FindControl("txtCBirthDate" + i); // string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); // xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>chd</psgrtype></CustomerInfo>"; //} //Table tblInfants = (Table)this.UpdatePanel1.FindControl("tblInfants"); //for (int i = 1; i <= infantCnt; i++) //{ // TextBox txtFn = (TextBox)tblInfants.FindControl("txtIFn" + i); // TextBox txtLn = (TextBox)tblInfants.FindControl("txtILn" + i); // DropDownList ddlTitle = (DropDownList)tblInfants.FindControl("ddlITitle" + i); // TextBox txtBirthDate = (TextBox)tblInfants.FindControl("txtIBirthDate" + i); // string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); // xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>inf</psgrtype></CustomerInfo>"; //} #endregion string strname = dtid.Tables[0].Rows[0]["Customer_Details"].ToString(); string[] strrows = strname.ToString().Split(';'); int id = strrows.Count(); for (int m = 0; m < id; m++) { if (strrows[m].ToUpper().Contains("ADT")) { string[] stradt = strrows[m].ToString().Split('|'); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + stradt[1].ToString() + "</givenName><surName>" + stradt[2].ToString() + "</surName><nameReference>" + stradt[0].ToString() + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } if (strrows[m].ToUpper().Contains("CHD")) { string[] strchd = strrows[m].ToString().Split('|'); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + strchd[1].ToString() + "</givenName><surName>" + strchd[2].ToString() + "</surName><nameReference>" + strchd[0].ToString() + "</nameReference><dob>" + strchd[5].ToString() + "</dob><age>" + strchd[4].ToString() + "</age><psgrtype>chd</psgrtype></CustomerInfo>"; } if (strrows[m].ToUpper().Contains("INF")) { string[] strinf = strrows[m].ToString().Split('|'); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + strinf[1].ToString() + "</givenName><surName>" + strinf[2].ToString() + "</surName><nameReference>" + strinf[0].ToString() + "</nameReference><dob>" + strinf[5].ToString() + "</dob><age>" + strinf[4].ToString() + "</age><psgrtype>inf</psgrtype></CustomerInfo>"; } } xmlRequestData = xmlRequestData + "</personName><telePhone><phoneNumber>" + telephone + "</phoneNumber></telePhone><email><emailAddress>" + emailAddress + "</emailAddress></email><creditcardno>4111111111111111</creditcardno><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword> <partnerRefId>" + refNo + "</partnerRefId> <Clienttype>ArzooFWS1.1</Clienttype><AdultPax>" + Session["adultcnt"].ToString() + "</AdultPax><ChildPax>" + Session["childCnt"].ToString() + "</ChildPax><InfantPax>" + Session["infantCnt"].ToString() + "</InfantPax></Bookingrequest>"; DataSet dsBookingResponse = new DataSet(); //DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); //string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); //string commisionPercentage = dsBalance.Tables[0].Rows[0]["CommisionPercentage"].ToString(); //string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); //string actualFare = lblTotalOnwardReturn.Text; //string deductAmount = Convert.ToString(Convert.ToDouble(actualFare.ToString()) - // ((Convert.ToDouble(actualFare.ToString()) * Convert.ToInt32(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)) //{ dsBookingResponse = objFlights.GetBookingDetails(xmlRequestData); //} //else { return; } string error = string.Empty; // If there is any Error -- We wont get the transid instead we get error if (dsBookingResponse.Tables[0].Columns.Contains("transid")) { transId = dsBookingResponse.Tables[0].Rows[0]["transid"].ToString(); //DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), // Convert.ToInt32(Session["UserID"].ToString()), refNo, Convert.ToDouble(Session["ActualFare_Agent"].ToString()), // Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToInt32(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; // #region SaveResponse #region Dedcuting the amount from the agent and DB's balance after booking if (Session["UserID"] != null) { if (Session["Role"] != null) { if (Session["Role"].ToString() == "Agent" || Session["Role"].ToString() == "Distributor") { string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), refNo, Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionPercentage_Agent"])); 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 = balanceAgent; Session["Balance"] = balanceAgent; } else if (Session["Role"].ToString() == "User") { DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble("0.00"), Convert.ToInt32(Session["UserID"].ToString()), refNo, Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } else if (Session["Role"].ToString() == "Admin") { DeductAgentBalance(0, Convert.ToDouble("0.00"), Convert.ToInt32(Session["UserID"].ToString()), refNo, Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } } } else if (Session["Role"] == null) { DeductAgentBalance(0, Convert.ToDouble("0.00"), 0, refNo, Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } #endregion FlightBAL objFlightBal = new FlightBAL(); objFlightBal.ReferenceNo = refNo; objFlightBal.TransId = transId; objFlightBal.Status = dsBookingResponse.Tables["Bookingresponse"].Rows[0]["status"].ToString(); if (objFlightBal.Status == "SUCCESS") { objFlightsBal.UpdateDomesticFlightBooking(objFlightBal); GetBookingStatus(objFlightBal.ReferenceNo); } else { objFlightsBal.UpdateDomesticFlightBooking(objFlightBal); } GetDetailsForPrint(Convert.ToString(Session["Order_Id"])); lbtnmail.Visible = false; pnlSearch.Visible = false; lbtnmail_Click1(sender, e); pnlPassengerDet.Visible = false; lblStatus.Visible = true; lblStatus.Text = "Ticket has been booked successfully. Reference Number is : " + Convert.ToString(Session["Order_Id"]); lblStatus.ForeColor = System.Drawing.Color.Green; // Response.Redirect("Pay.aspx", false); } else { lblStatus.Text = dsBookingResponse.Tables[0].Rows[0]["Error"].ToString(); lblStatus.Visible = true; } } catch (Exception ex) { } }
protected void btnRoundTripSubmit_Click(object sender, EventArgs e) { try { try { // if (Session["UserID"] == null) { Response.Redirect("~/Default.aspx", false); return; } #region Variables string FlightSegmentsID = string.Empty; string originDestination_Id = string.Empty; string fareDetailsId = string.Empty; string TotalFare = string.Empty; string AirEquipType = string.Empty; string ArrivalAirportCode = string.Empty; string ArrivalDateTime = string.Empty; string DepartureAirportCode = string.Empty; string DepartureDateTime = string.Empty; string FlightNumber = string.Empty; string OperatingAirlineCode = string.Empty; string OperatingAirlineFlightNumber = string.Empty; string RPH = string.Empty; string StopQuantity = string.Empty; string airLineName = string.Empty; string airportTax = string.Empty; string imageFileName = string.Empty; string BookingClassAvailability = string.Empty; string BookingClassResBookDesigCode = string.Empty; string adultFare = string.Empty; string bookingclass = string.Empty; string childFare = string.Empty; string classType = string.Empty; string farebasiscode = string.Empty; string infantfare = string.Empty; string Rule = string.Empty; string adultCommission = string.Empty; string childCommission = string.Empty; string commissionOnTCharge = string.Empty; string Discount = string.Empty; string airportTaxChild = string.Empty; string airportTaxInfant = string.Empty; string adultTaxBreakup = string.Empty; string childTaxBreakup = string.Empty; string infantTaxBreakup = string.Empty; string octax = string.Empty; string id = string.Empty; string key = string.Empty; string TCharge = string.Empty; string TMarkup = string.Empty; string TSdiscount = string.Empty; string TPartnerCommission = string.Empty; string actualBaseFare = string.Empty; string tax = string.Empty; string Stax = string.Empty; string SCharge = string.Empty; string TDiscount = string.Empty; string responseDepartId = string.Empty; string responseReturnId = string.Empty; string OriginDestinationOptionsId = string.Empty; #endregion dsFilghts = (DataSet)Session["dsDomFlights"]; DataTable dtFlightSegment = dsFilghts.Tables["FlightSegment"]; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFlightSegment = dtFlightSegment.Select("FlightSegment_Id=" + lblonwardFlightSegmentId.Text); AirEquipType = rowFlightSegment[0]["AirEquipType"].ToString(); ArrivalAirportCode = rowFlightSegment[0]["ArrivalAirportCode"].ToString(); ArrivalDateTime = rowFlightSegment[0]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFlightSegment[0]["DepartureAirportCode"].ToString(); DepartureDateTime = rowFlightSegment[0]["DepartureDateTime"].ToString(); FlightNumber = rowFlightSegment[0]["FlightNumber"].ToString(); OperatingAirlineCode = rowFlightSegment[0]["OperatingAirlineCode"].ToString(); OperatingAirlineFlightNumber = rowFlightSegment[0]["OperatingAirlineFlightNumber"].ToString(); RPH = rowFlightSegment[0]["RPH"].ToString(); StopQuantity = rowFlightSegment[0]["StopQuantity"].ToString(); airLineName = rowFlightSegment[0]["airLineName"].ToString(); airportTax = rowFlightSegment[0]["airportTax"].ToString(); imageFileName = rowFlightSegment[0]["imageFileName"].ToString(); Discount = rowFlightSegment[0]["Discount"].ToString(); airportTaxChild = rowFlightSegment[0]["airportTaxChild"].ToString(); airportTaxInfant = rowFlightSegment[0]["airportTaxInfant"].ToString(); adultTaxBreakup = rowFlightSegment[0]["adultTaxBreakup"].ToString(); childTaxBreakup = rowFlightSegment[0]["childTaxBreakup"].ToString(); infantTaxBreakup = rowFlightSegment[0]["infantTaxBreakup"].ToString(); octax = rowFlightSegment[0]["octax"].ToString(); FlightSegmentsID = rowFlightSegment[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegments = dsFilghts.Tables["FlightSegments"]; if (dtFlightSegments.Rows.Count > 0) { DataRow[] rowFlightSegments = dtFlightSegments.Select("FlightSegments_Id=" + FlightSegmentsID); originDestination_Id = rowFlightSegments[0]["originDestinationoption_Id"].ToString(); } DataTable dtoriginDestinationoption = dsFilghts.Tables["originDestinationoption"]; if (dtoriginDestinationoption.Rows.Count > 0) { DataRow[] roworiginDestinationoption = dtoriginDestinationoption.Select("originDestinationoption_Id=" + originDestination_Id); id = roworiginDestinationoption[0]["id"].ToString(); key = roworiginDestinationoption[0]["key"].ToString(); } DataTable dtFareDetails = dsFilghts.Tables["FareDetails"]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("originDestinationoption_Id=" + originDestination_Id); fareDetailsId = rowFareDetails[0]["FareDetails_Id"].ToString(); } DataTable dtChargeableFares = dsFilghts.Tables["ChargeableFares"]; if (dtChargeableFares.Rows.Count > 0) { DataRow[] rowChargeableFares = dtChargeableFares.Select("FareDetails_Id=" + fareDetailsId); actualBaseFare = rowChargeableFares[0]["ActualBaseFare"].ToString(); tax = rowChargeableFares[0]["tax"].ToString(); Stax = rowChargeableFares[0]["Stax"].ToString(); SCharge = rowChargeableFares[0]["SCharge"].ToString(); TDiscount = rowChargeableFares[0]["TDiscount"].ToString(); TPartnerCommission = rowChargeableFares[0]["TPartnerCommission"].ToString(); } DataTable dtNonChargeableFares = dsFilghts.Tables["NonChargeableFares"]; if (dtNonChargeableFares.Rows.Count > 0) { DataRow[] rowNonChargeableFares = dtNonChargeableFares.Select("FareDetails_Id=" + fareDetailsId); TCharge = rowNonChargeableFares[0]["TCharge"].ToString(); TSdiscount = rowNonChargeableFares[0]["TSdiscount"].ToString(); TMarkup = rowNonChargeableFares[0]["TMarkup"].ToString(); } DataTable dtBookingClass = dsFilghts.Tables["BookingClass"]; if (dtBookingClass.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass.Select("FlightSegment_Id=" + lblonwardFlightSegmentId.Text); BookingClassAvailability = rowBookingClass[0]["Availability"].ToString(); BookingClassResBookDesigCode = rowBookingClass[0]["ResBookDesigCode"].ToString(); } DataTable dtBookingClassfare = dsFilghts.Tables["BookingClassFare"]; if (dtBookingClassfare.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassfare.Select("FlightSegment_Id=" + lblonwardFlightSegmentId.Text); adultFare = rowBookingClassFare[0]["adultFare"].ToString(); if (dtBookingClassfare.Columns.Contains("childFare")) { childFare = rowBookingClassFare[0]["childFare"].ToString(); } if (dtBookingClassfare.Columns.Contains("infantfare")) { infantfare = rowBookingClassFare[0]["infantfare"].ToString(); } bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString().Replace("<", "<").Replace(">", ">"); adultCommission = rowBookingClassFare[0]["adultCommission"].ToString(); childCommission = rowBookingClassFare[0]["childCommission"].ToString(); commissionOnTCharge = rowBookingClassFare[0]["commissionOnTCharge"].ToString(); } #region ReturnOriginDestionOptionDetails DataTable dtFlightSegmentRet = dsFilghts.Tables["FlightSegment"]; if (dtFlightSegmentRet.Rows.Count > 0) { DataRow[] rowFlightSegmentRet = dtFlightSegmentRet.Select("FlightSegment_Id=" + lblReturnFlightSegment.Text); AirEquipTypeRet = rowFlightSegmentRet[0]["AirEquipType"].ToString(); ArrivalAirportCodeRet = rowFlightSegmentRet[0]["ArrivalAirportCode"].ToString(); ArrivalDateTimeRet = rowFlightSegmentRet[0]["ArrivalDateTime"].ToString(); DepartureAirportCodeRet = rowFlightSegmentRet[0]["DepartureAirportCode"].ToString(); DepartureDateTimeRet = rowFlightSegmentRet[0]["DepartureDateTime"].ToString(); FlightNumberRet = rowFlightSegmentRet[0]["FlightNumber"].ToString(); OperatingAirlineCodeRet = rowFlightSegmentRet[0]["OperatingAirlineCode"].ToString(); OperatingAirlineFlightNumberRet = rowFlightSegmentRet[0]["OperatingAirlineFlightNumber"].ToString(); RPHRet = rowFlightSegmentRet[0]["RPH"].ToString(); StopQuantityRet = rowFlightSegmentRet[0]["StopQuantity"].ToString(); airLineNameRet = rowFlightSegmentRet[0]["airLineName"].ToString(); airportTaxRet = rowFlightSegmentRet[0]["airportTax"].ToString(); imageFileNameRet = rowFlightSegmentRet[0]["imageFileName"].ToString(); DiscountRet = rowFlightSegmentRet[0]["Discount"].ToString(); airportTaxChildRet = rowFlightSegmentRet[0]["airportTaxChild"].ToString(); airportTaxInfantRet = rowFlightSegmentRet[0]["airportTaxInfant"].ToString(); adultTaxBreakupRet = rowFlightSegmentRet[0]["adultTaxBreakup"].ToString(); childTaxBreakupRet = rowFlightSegmentRet[0]["childTaxBreakup"].ToString(); infantTaxBreakupRet = rowFlightSegmentRet[0]["infantTaxBreakup"].ToString(); octaxRet = rowFlightSegmentRet[0]["octax"].ToString(); FlightSegmentsIDRet = rowFlightSegmentRet[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegmentsRet = dsFilghts.Tables["FlightSegments"]; if (dtFlightSegmentsRet.Rows.Count > 0) { DataRow[] rowFlightSegmentsRet = dtFlightSegmentsRet.Select("FlightSegments_Id=" + FlightSegmentsIDRet); originDestination_IdRet = rowFlightSegmentsRet[0]["originDestinationoption_Id"].ToString(); } DataTable dtoriginDestinationoptionRet = dsFilghts.Tables["originDestinationoption"]; if (dtoriginDestinationoptionRet.Rows.Count > 0) { DataRow[] roworiginDestinationoptionRet = dtoriginDestinationoptionRet.Select("originDestinationoption_Id=" + originDestination_IdRet); idRet = roworiginDestinationoptionRet[0]["id"].ToString(); keyRet = roworiginDestinationoptionRet[0]["key"].ToString(); } DataTable dtFareDetailsRet = dsFilghts.Tables["FareDetails"]; if (dtFareDetailsRet.Rows.Count > 0) { DataRow[] rowFareDetailsRet = dtFareDetailsRet.Select("originDestinationoption_Id=" + originDestination_IdRet); fareDetailsIdRet = rowFareDetailsRet[0]["FareDetails_Id"].ToString(); } DataTable dtChargeableFaresRet = dsFilghts.Tables["ChargeableFares"]; if (dtChargeableFaresRet.Rows.Count > 0) { DataRow[] rowChargeableFaresRet = dtChargeableFaresRet.Select("FareDetails_Id=" + fareDetailsIdRet); actualBaseFareRet = rowChargeableFaresRet[0]["ActualBaseFare"].ToString(); taxRet = rowChargeableFaresRet[0]["tax"].ToString(); StaxRet = rowChargeableFaresRet[0]["Stax"].ToString(); SChargeRet = rowChargeableFaresRet[0]["SCharge"].ToString(); TDiscountRet = rowChargeableFaresRet[0]["TDiscount"].ToString(); TPartnerCommissionRet = rowChargeableFaresRet[0]["TPartnerCommission"].ToString(); } DataTable dtNonChargeableFaresRet = dsFilghts.Tables["NonChargeableFares"]; if (dtNonChargeableFaresRet.Rows.Count > 0) { DataRow[] rowNonChargeableFaresRet = dtNonChargeableFaresRet.Select("FareDetails_Id=" + fareDetailsIdRet); TChargeRet = rowNonChargeableFaresRet[0]["TCharge"].ToString(); TSdiscountRet = rowNonChargeableFaresRet[0]["TSdiscount"].ToString(); TMarkupRet = rowNonChargeableFaresRet[0]["TMarkup"].ToString(); } DataTable dtBookingClassRet = dsFilghts.Tables["BookingClass"]; if (dtBookingClassRet.Rows.Count > 0) { DataRow[] rowBookingClassRet = dtBookingClassRet.Select("FlightSegment_Id=" + lblReturnFlightSegment.Text); BookingClassAvailabilityRet = rowBookingClassRet[0]["Availability"].ToString(); BookingClassResBookDesigCodeRet = rowBookingClassRet[0]["ResBookDesigCode"].ToString(); } DataTable dtBookingClassfareRet = dsFilghts.Tables["BookingClassFare"]; if (dtBookingClassfareRet.Rows.Count > 0) { DataRow[] rowBookingClassFareRet = dtBookingClassfareRet.Select("FlightSegment_Id=" + lblReturnFlightSegment.Text); adultFareRet = rowBookingClassFareRet[0]["adultFare"].ToString(); if (dtBookingClassfareRet.Columns.Contains("childFare")) { childFareRet = rowBookingClassFareRet[0]["childFare"].ToString(); } if (dtBookingClassfareRet.Columns.Contains("infantfare")) { infantfareRet = rowBookingClassFareRet[0]["infantfare"].ToString(); } bookingclassRet = rowBookingClassFareRet[0]["bookingclass"].ToString(); classTypeRet = rowBookingClassFareRet[0]["classType"].ToString(); farebasiscodeRet = rowBookingClassFareRet[0]["farebasiscode"].ToString(); RuleRet = rowBookingClassFareRet[0]["Rule"].ToString().Replace("<", "<").Replace(">", ">"); adultCommissionRet = rowBookingClassFareRet[0]["adultCommission"].ToString(); childCommissionRet = rowBookingClassFareRet[0]["childCommission"].ToString(); commissionOnTChargeRet = rowBookingClassFareRet[0]["commissionOnTCharge"].ToString(); } // string flightBookingId = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); // Session["BookingID"] = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); string refNo = Common.GetFlightsReferenceNo("LJDF"); Session["Order_Id"] = refNo.ToString(); FlightBAL objFlightBal = new FlightBAL(); objFlightBal.ReferenceNo = refNo; objFlightBal.TransId = string.Empty; objFlightBal.Status = "Pending"; objFlightBal.AdultPax = Convert.ToInt32(ddlAdult.SelectedValue); objFlightBal.InfantPax = Convert.ToInt32(ddlInfant.SelectedValue); objFlightBal.ChildPax = Convert.ToInt32(ddlChild.SelectedValue); objFlightBal.Origin_Destination_Id = id; objFlightBal.Origin_Destination_Key = key; objFlightBal.ActualBasefare = Convert.ToDecimal(actualBaseFare); objFlightBal.Tax = Convert.ToDecimal(tax); objFlightBal.STax = Convert.ToDecimal(Stax); objFlightBal.Scharge = Convert.ToDecimal(SCharge); objFlightBal.TDiscount = Convert.ToDecimal(TDiscount); objFlightBal.TPartnerCommission = Convert.ToDecimal(TPartnerCommission); objFlightBal.TCharge = Convert.ToDecimal(TCharge); objFlightBal.TMarkUp = Convert.ToDecimal(TMarkup); objFlightBal.TSDiscount = Convert.ToDecimal(TSdiscount); objFlightBal.ActualBasefareRet = Convert.ToDecimal(actualBaseFareRet); objFlightBal.TaxRet = Convert.ToDecimal(taxRet); objFlightBal.STaxRet = Convert.ToDecimal(StaxRet); objFlightBal.SchargeRet = Convert.ToDecimal(SChargeRet); objFlightBal.TDiscountRet = Convert.ToDecimal(TDiscountRet); objFlightBal.TPartnerCommissionRet = Convert.ToDecimal(TPartnerCommissionRet); objFlightBal.TChargeRet = Convert.ToDecimal(TChargeRet); objFlightBal.TMarkUpRet = Convert.ToDecimal(TMarkupRet); objFlightBal.TSDiscountRet = Convert.ToDecimal(TSdiscountRet); string givenName = string.Empty; string surName = string.Empty; string namereference = string.Empty; string psgrType = string.Empty; string Age = string.Empty; string customerInfo = string.Empty; #region customer Table tbladults1 = (Table)this.UpdatePanel1.FindControl("tblAdults"); for (int l = 1; l <= Convert.ToInt32(Session["adultcnt"]); l++) { TextBox txtFn = (TextBox)tbladults1.FindControl("txtFn" + l); TextBox txtLn = (TextBox)tbladults1.FindControl("txtLn" + l); DropDownList ddlTitle = (DropDownList)tbladults1.FindControl("ddlTitle" + l); if (customerInfo == string.Empty) { customerInfo = ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Adt" + "|" + "-"; } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Adt" + "|" + "-"; } // xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } Table tblChild1 = (Table)this.UpdatePanel1.FindControl("tblChild"); for (int j = 1; j <= Convert.ToInt32(Session["childCnt"]); j++) { TextBox txtFn = (TextBox)tblChild1.FindControl("txtCFn" + j); TextBox txtLn = (TextBox)tblChild1.FindControl("txtCLn" + j); DropDownList ddlTitle = (DropDownList)tblChild1.FindControl("ddlCTitle" + j); TextBox txtBirthDate = (TextBox)tblChild1.FindControl("txtCBirthDate" + j); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); if (customerInfo == string.Empty) { customerInfo = ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Chd" + "|" + age + "|" + txtBirthDate.Text.ToString(); } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Chd" + "|" + age + "|" + txtBirthDate.Text.ToString(); } // xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>chd</psgrtype></CustomerInfo>"; } Table tblInfants1 = (Table)this.UpdatePanel1.FindControl("tblInfants"); for (int k = 1; k <= Convert.ToInt32(Session["infantCnt"]); k++) { TextBox txtFn = (TextBox)tblInfants1.FindControl("txtIFn" + k); TextBox txtLn = (TextBox)tblInfants1.FindControl("txtILn" + k); DropDownList ddlTitle = (DropDownList)tblInfants1.FindControl("ddlITitle" + k); TextBox txtBirthDate = (TextBox)tblInfants1.FindControl("txtIBirthDate" + k); string age = string.Empty; if (txtBirthDate != null) age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); else age = "0"; if (customerInfo == string.Empty) { customerInfo = ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Inf" + "|" + age + "|" + txtBirthDate.Text.ToString(); } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "Inf" + "|" + age + "|" + txtBirthDate.Text.ToString(); } // xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>inf</psgrtype></CustomerInfo>"; } #endregion objFlightBal.Address = txtCity.Text + "," + txtState.Text + "," + ddlcountry.SelectedValue + "," + txtPostalCode.Text + ","; objFlightBal.Customer_Details = customerInfo; //objFlightBal.Customer_Details = "Mr.|rajini|reguri|Adt|"; objFlightBal.telephone = txtMobileNum.Text; objFlightBal.emailAddress = lblEmailAddress.Text = txtEmailID.Text; objFlightBal.TripMode = "Round"; objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); if (Session["Role"] == null) { objFlightBal.Type = "Guest"; } else { objFlightBal.Type = Session["Role"].ToString(); } objFlightBal.id = id; objFlightBal.key = key; objFlightBal.idRet = idRet; objFlightBal.keyRet = keyRet; DataTable dtflightBookingId = objFlightBal.AddDomesticFlightBooking(objFlightBal); string flightBookingId = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); Session["BookingID"] = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); objFlightBal.FlightBookingID = flightBookingId.ToString(); objFlightBal.AirEquipType = AirEquipType; objFlightBal.ArrivalAirportCode = ArrivalAirportCode; objFlightBal.ArrivalDateTime = ArrivalDateTime; objFlightBal.DepartureAirportCode = DepartureAirportCode; objFlightBal.DepartureDateTime = DepartureDateTime; objFlightBal.FlightNumber = FlightNumber; objFlightBal.OperatingAirlineCode = OperatingAirlineCode; objFlightBal.OperatingAirlineFlightNumber = OperatingAirlineFlightNumber; objFlightBal.RPH = RPH; objFlightBal.StopQuantity = StopQuantity; objFlightBal.airlineName = airLineName; objFlightBal.airportTax = airportTax; objFlightBal.imageFileName = imageFileName; objFlightBal.Discount = Discount; objFlightBal.airportTaxChild = airportTaxChild; objFlightBal.airportTaxInfant = airportTaxInfant; objFlightBal.adultTaxBreakUp = adultTaxBreakup; objFlightBal.ChildTaxBreakUp = childTaxBreakup; objFlightBal.InfantTaxBreakUp = infantTaxBreakup; objFlightBal.ocTax = octax; objFlightBal.Availability = BookingClassAvailability; objFlightBal.ResBookingCode = BookingClassResBookDesigCode; objFlightBal.adultFare = adultFare; objFlightBal.bookingClass = bookingclass; objFlightBal.ChildFare = childFare; objFlightBal.ClassType = classType; objFlightBal.farebasisCode = farebasiscode; objFlightBal.infantFare = infantfare; objFlightBal.Fare_Rule = Rule; objFlightBal.adultCommission = adultCommission; objFlightBal.childCommission = childCommission; objFlightBal.CommissionOnTCharge = commissionOnTCharge; objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); bool res = objFlightBal.AddDomesticFlightBookingsegments(objFlightBal); objFlightBal.FlightBookingID = flightBookingId.ToString(); objFlightBal.AirEquipType = AirEquipTypeRet; objFlightBal.ArrivalAirportCode = ArrivalAirportCodeRet; objFlightBal.ArrivalDateTime = ArrivalDateTimeRet; objFlightBal.DepartureAirportCode = DepartureAirportCodeRet; objFlightBal.DepartureDateTime = DepartureDateTimeRet; objFlightBal.FlightNumber = FlightNumberRet; objFlightBal.OperatingAirlineCode = OperatingAirlineCodeRet; objFlightBal.OperatingAirlineFlightNumber = OperatingAirlineFlightNumberRet; objFlightBal.RPH = RPHRet; objFlightBal.StopQuantity = StopQuantityRet; objFlightBal.airlineName = airLineNameRet; objFlightBal.airportTax = airportTaxRet; objFlightBal.imageFileName = imageFileNameRet; objFlightBal.Discount = DiscountRet; objFlightBal.airportTaxChild = airportTaxChildRet; objFlightBal.airportTaxInfant = airportTaxInfantRet; objFlightBal.adultTaxBreakUp = adultTaxBreakupRet; objFlightBal.ChildTaxBreakUp = childTaxBreakupRet; objFlightBal.InfantTaxBreakUp = infantTaxBreakupRet; objFlightBal.ocTax = octaxRet; objFlightBal.Availability = BookingClassAvailabilityRet; objFlightBal.ResBookingCode = BookingClassResBookDesigCodeRet; objFlightBal.adultFare = adultFareRet; objFlightBal.bookingClass = bookingclassRet; objFlightBal.ChildFare = childFareRet; objFlightBal.ClassType = classTypeRet; objFlightBal.farebasisCode = farebasiscodeRet; objFlightBal.infantFare = infantfareRet; objFlightBal.Fare_Rule = RuleRet; objFlightBal.adultCommission = adultCommissionRet; objFlightBal.childCommission = childCommissionRet; objFlightBal.CommissionOnTCharge = commissionOnTChargeRet; objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); res = objFlightBal.AddDomesticFlightBookingsegments(objFlightBal); if (res) { try { // Response.Redirect("~/pay.aspx?val=Dom", false); #region Checking the roles and booking the tickets TotalFare = (Convert.ToDouble(lblTotalAmtreturn) + Convert.ToDouble(lblTotalAmt)).ToString(); Session["Amount"] = TotalFare; if (Session["Role"] == null) { Response.Redirect("~/pay.aspx?val=Dom", false); } else if (Session["Role"].ToString() == "User") { objBAL = new ClsBAL(); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["AgentId_Agent"] = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); Response.Redirect("~/pay.aspx?val=Dom", false); } else if (Session["Role"].ToString() == "Admin") { saveround(sender, e); } else if (Session["Role"].ToString() == "Agent") { DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "DomesticFlights", airLineName.ToString()); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); TotalFare = (Convert.ToDouble(lblTotalAmtreturn.Text) + Convert.ToDouble(lblTotalAmt.Text)).ToString(); string actualFare = TotalFare; 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)) { saveround(sender, e); } else { mp3.Show(); lblerror.Text = "Your balance is too low to book the ticket.So,please contact administrator"; return; } } else if (Session["Role"].ToString() == "Distributor") { DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "DomesticFlights", airLineName.ToString()); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); TotalFare = (Convert.ToDouble(lblTotalAmtreturn.Text) + Convert.ToDouble(lblTotalAmt.Text)).ToString(); string actualFare = TotalFare; 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)) { saveround(sender, e); } else { mp3.Show(); lblerror.Text = "Your balance is too low to book the ticket.So, please contact administrator"; return; } } #endregion } catch (Exception ex) { // LogError("frmSearchBus.aspx", "paymentgateway", DateTime.Now, ex.Message.ToString()); // lblMsg1.Visible = true; // lblMsg1.Text = "Error in the payment gateway"; } } #endregion } catch (NullReferenceException) { Response.Redirect("~/Default.aspx", false); } } catch (Exception ex) { mp3.Show(); lblerror.Text = ex.Message; } }
protected void btnDepositSubmit_Click(object sender, EventArgs e) { try { objBal = new ClsBAL(); ListItem value = ddlAgents.Items.FindByText(txtAgents.Text.ToString()); if (value == null) { ddlAgents.SelectedIndex = 0; lblMsg.InnerHtml = "The Agent Username does not exists."; txtAgentName.Focus(); txtAgentName.Text = ""; } else { if (Session["Role"].ToString() == "Admin") { ddlAgents.SelectedItem.Value = value.Value; string msg = objBal.AddAgentDeposit(Convert.ToInt32(ddlAgents.SelectedItem.Value.ToString()) , Convert.ToDouble(txtAmount.Text.ToString()), txtDepositDetails.Text.Trim().ToString(), Convert.ToInt32(Session["UserID"].ToString()) , rbtnType.SelectedItem.Text.ToString(), txtTransactionNo.Text.Trim().ToString(), txtReason.Text.Trim()); BindDeposits(); DeductAgentBalance(Convert.ToInt32(ddlAgents.SelectedItem.Value), Convert.ToDouble(0.00), Convert.ToInt32(Userid), rbtnType.SelectedItem.Text.ToString(), Convert.ToDouble(txtAmount.Text.ToString()), Convert.ToDouble(0.00), Convert.ToInt32(0.00)); System.Data.DataSet ds = objBal.GetAgentById(Convert.ToInt32(ddlAgents.SelectedItem.Value.ToString())); string body = "Dear " + ds.Tables[0].Rows[0]["UserName"].ToString() + ", <br/> " + "Rs. " + txtAmount.Text.ToString() + "/- amount has been credited in your account. <br/><br/> Thanks, <br/>Love Journey Team"; bool res = Mailsender.SendEmail(ds.Tables[0].Rows[0]["EmailId"].ToString(), "", "", "Deposit Details", body); lblMsg.InnerHtml = msg; BindDeposits(); txtAmount.Text = txtDepositDetails.Text = txtTransactionNo.Text = txtReason.Text = ""; rbtnType.SelectedIndex = -1; } else if (Session["Role"].ToString() == "Distributor") { if (Convert.ToDouble(Session["Balance"].ToString()) >= Convert.ToDouble(txtAmount.Text.ToString())) { ddlAgents.SelectedItem.Value = value.Value; string msg = objBal.AddAgentDeposit(Convert.ToInt32(ddlAgents.SelectedItem.Value.ToString()) , Convert.ToDouble(txtAmount.Text.ToString()), txtDepositDetails.Text.Trim().ToString(), Convert.ToInt32(Session["UserID"].ToString()) , rbtnType.SelectedItem.Text.ToString(), txtTransactionNo.Text.Trim().ToString(), txtReason.Text.Trim()); BindDeposits(); DeductAgentBalance(Convert.ToInt32(ddlAgents.SelectedItem.Value), Convert.ToDouble(0.00), Convert.ToInt32(Userid), rbtnType.SelectedItem.Text.ToString(), Convert.ToDouble(txtAmount.Text.ToString()), Convert.ToDouble(0.00), Convert.ToInt32(0.00)); lblMsg.InnerHtml = msg; if (msg == "Inserted Successfully.") { objBal.deductDistributorbalance(Convert.ToInt32(Session["UserID"].ToString()), Convert.ToDouble(txtAmount.Text.ToString()), "Deduct"); ClsBAL objBAL = new ClsBAL(); System.Data.DataSet dataset = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["Balance"] = dataset.Tables[0].Rows[0]["Balance"].ToString(); Label balance = (Label)this.Master.FindControl("lblDbBal"); balance.Text = "Your balance is : " + " " + Session["Balance"].ToString(); } System.Data.DataSet ds = objBal.GetAgentById(Convert.ToInt32(ddlAgents.SelectedItem.Value.ToString())); string body = "Dear " + ds.Tables[0].Rows[0]["UserName"].ToString() + ", <br/> " + "Rs. " + txtAmount.Text.ToString() + "/- amount has been credited in your account. <br/><br/> Thanks, <br/>Love Journey Team"; bool res = Mailsender.SendEmail(ds.Tables[0].Rows[0]["EmailId"].ToString(), "", "", "Deposit Details", body); BindDeposits(); txtAmount.Text = txtDepositDetails.Text = txtTransactionNo.Text = txtReason.Text = ""; rbtnType.SelectedIndex = -1; } else { lblMsg.InnerHtml = "Your balance should be greater than the adding amount."; } } } } catch (Exception ex) { lblMsg.InnerHtml = ex.Message; } }
protected void btnGet_Click(object sender, EventArgs e) { try { DataSet dsGetTransId = new DataSet(); dsGetTransId = objFlightBal.GetTransID(txtBookingReferenceNo.Text); transId = dsGetTransId.Tables[0].Rows[0]["transid"].ToString(); if (transId != "") { String xmlCancelReqStatus = "<EticketCanStatusReq><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooFWS1.0</Clienttype><transid>" + transId + "</transid><partnerRefId></partnerRefId><CancellationId></CancellationId></EticketCanStatusReq>"; DataSet dsCancelStatusResponse = objFlights.GetCancelTicketStatus(xmlCancelReqStatus); //DataSet dsCancelStatusResponse = new DataSet(); //dsCancelStatusResponse.ReadXml("F:\\Projects\\Love Journey\\Cancel_Domestic_Static_Response.xml"); if (dsCancelStatusResponse != null) { objFlightBal.Status = dsCancelStatusResponse.Tables["Cancellation"].Rows[0]["CancellationStatus"].ToString(); objFlightBal.TransId = dsCancelStatusResponse.Tables["EticketCanStatusRes"].Rows[0]["transid"].ToString(); objFlightBal.ReferenceNo = txtBookingReferenceNo.Text; objFlightBal.CancellationProcessDateTime = dsCancelStatusResponse.Tables["Cancellation"].Rows[0]["CancellationProcessDateTime"].ToString(); objFlightBal.CancellationCharges = dsCancelStatusResponse.Tables["Cancellation"].Rows[0]["CancellationCharges"].ToString(); objFlightBal.RefundStatus = dsCancelStatusResponse.Tables["Cancellation"].Rows[0]["RefundStatus"].ToString(); objFlightBal.FinalRefundAmount = dsCancelStatusResponse.Tables["Cancellation"].Rows[0]["FinalRefundAmount"].ToString(); objFlightBal.RefundDateTime = dsCancelStatusResponse.Tables["Cancellation"].Rows[0]["RefundDateTime"].ToString(); bool res = objFlightBal.UpdateDomesticFlightCancelStatus(objFlightBal); ClsBAL objBAL = new ClsBAL(); objBAL.AdjustAgentBalance(txtBookingReferenceNo.Text.Trim().ToString(), Convert.ToDouble(objFlightBal.FinalRefundAmount), Convert.ToDouble(objFlightBal.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; if (res) { lblStatus.Text = "Updated the status"; lblStatus.ForeColor = System.Drawing.Color.Green; lblStatus.Visible = true; } } } else { lblStatus.Text = "Invalid Request"; } } catch (Exception ex) { } }
protected void lnkICICI_Click(object sender, EventArgs e) { ClsBAL objBAL = new ClsBAL(); System.Data.DataSet ds = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["Name"] = ds.Tables[0].Rows[0]["AgentName"].ToString(); Response.Redirect("~/Agent/Bus/ICICIBankPaySlip.aspx?Name=" + Session["Name"].ToString() + "&Code=" + Session["UserName"].ToString(), false); }
protected void getbalance() { try { objBAL = new ClsBAL(); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["AgentBalance"] = Convert.ToDecimal(dsBalance.Tables[0].Rows[0]["Balance"].ToString()); Session["CommisionPercentage_Agent"] = dsBalance.Tables[0].Rows[0]["CommisionPercentage"].ToString(); Session["AgentId_Agent"] = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); } catch (Exception ex) { } }
protected void lnksbi_Click(object sender, EventArgs e) { //Response.Redirect("~/Agent/Bus/SBIPaySlip.aspx?Name=" + Session["Name"].ToString() + "&Code=" + Session["UserName"].ToString(), false); //try //{ // // GetDetailsForPrint(Refno); // Response.Clear(); // Response.Buffer = true; // Response.AddHeader("content-disposition", "attachment;filename=SBIpayinSlip.doc"); // Response.Charset = ""; // Response.ContentType = "application/vnd.ms-word"; // StringWriter sw = new StringWriter(); // HtmlTextWriter hw = new HtmlTextWriter(sw); // pnlsbi.RenderControl(hw); // Response.Output.Write(sw.ToString()); // Response.Flush(); // Response.End(); //} //catch (System.Threading.ThreadAbortException lException) //{ // // do nothing //} ClsBAL objBAL = new ClsBAL(); System.Data.DataSet ds = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["Name"] = ds.Tables[0].Rows[0]["AgentName"].ToString(); Response.Redirect("~/Agent/Bus/SBIPaySlip.aspx?Name=" + Session["Name"].ToString() + "&Code=" + Session["UserName"].ToString(), false); }
protected void Mail(string mailId, string refNo) { try { objBAL = new ClsBAL(); System.Data.DataSet ds = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); if (mailId != "") { string body = "Your (" + refNo + ") ticket has been cancelled."; bool res = Mailsender.SendEmail(mailId, "", "", "Ticket Cancelled Details", body); if (res) { lblMsg.Text = "Ticket Details has been sent to your mail.Please check."; lblMsg.ForeColor = System.Drawing.Color.Green; } else { } } } catch (Exception ex) { throw ex; } }
protected void save(object sender, EventArgs e) { try { DataSet dsBookingResponse = new DataSet(); // dsBookingResponse = (DataSet)Session["Response"]; dsBookingResponse = method(); Session["Response"] = null; FlightBAL objFlightBal = new FlightBAL(); if (dsBookingResponse.Tables.Count > 0) { if (dsBookingResponse.Tables["BookingResponse"].Rows.Count > 0) { if (Session["UserID"] != null && Session["Role"] != null) { #region Dedcuting the amount from the agent and DB's balance after booking if (Session["Role"].ToString() == "Agent" || Session["Role"].ToString() == "Distributor") { string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), Session["Order_Id"].ToString(), Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionPercentage_Agent"])); 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 = balanceAgent; Session["Balance"] = balanceAgent; } else if (Session["Role"].ToString() == "User") { DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble("0.00"), Convert.ToInt32(Session["UserID"].ToString()), Session["Order_Id"].ToString(), Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } else if (Session["Role"].ToString() == "Admin") { DeductAgentBalance(0, Convert.ToDouble("0.00"), Convert.ToInt32(Session["UserID"].ToString()), Session["Order_Id"].ToString(), Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } #endregion } else if (Session["Role"] == null) { DeductAgentBalance(0, Convert.ToDouble("0.00"), 0, Session["Order_Id"].ToString(), Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } objFlightBal.ReferenceNo = Convert.ToString(Session["Order_Id"]);// Common.GetFlightsReferenceNo("LJIF"); objFlightBal.TransId = dsBookingResponse.Tables["BookingResponse"].Rows[0]["transid"].ToString(); objFlightBal.Status = dsBookingResponse.Tables["BookingResponse"].Rows[0]["status"].ToString(); // objFlightBal.AdultPax = Convert.ToInt32(dsBookingResponse.Tables["BookingResponse"].Rows[0]["noadults"].ToString()); //objFlightBal.InfantPax = Convert.ToInt32(dsBookingResponse.Tables["BookingResponse"].Rows[0]["noinfant"].ToString()); //objFlightBal.ChildPax = Convert.ToInt32(dsBookingResponse.Tables["BookingResponse"].Rows[0]["nochild"].ToString()); //objFlightBal.Origin_Destination_Id = dsBookingResponse.Tables["OriginDestinationOption"].Rows[0]["id"].ToString(); //objFlightBal.Origin_Destination_Key = dsBookingResponse.Tables["OriginDestinationOption"].Rows[0]["key"].ToString(); //objFlightBal.ActualBasefare = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["ActualBasefare"].ToString()); // objFlightBal.Tax = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["Tax"].ToString()); // objFlightBal.STax = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["STax"].ToString()); // objFlightBal.TCharge = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TCharge"].ToString()); // objFlightBal.Scharge = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["Scharge"].ToString()); //objFlightBal.TDiscount = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TDiscount"].ToString()); // objFlightBal.TMarkUp = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TMarkUp"].ToString()); // objFlightBal.TPartnerCommission = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TPartnerCommission"].ToString()); // objFlightBal.TSDiscount = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TSDiscount"].ToString()); // objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); // objFlightBal.TripMode = "One"; objFlightBal.UpdateDInternationalFlightBooking(objFlightBal); // string flightBookingId = Session["BookingID"].ToString(); //dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); //Do the Insert of Flgiht Segment // objFlightBal.FlightBookingID = flightBookingId.ToString(); if (dsBookingResponse.Tables["FlightSegment"].Rows.Count > 0) { for (int j = 0; j < dsBookingResponse.Tables["FlightSegment"].Rows.Count; j++) { //objFlightBal.Customer_Details = customerInfo; objFlightBal.FlightBookingID = Convert.ToString(Session["BookingID"]); objFlightBal.bookingClass = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["bookingClass"].ToString(); objFlightBal.ClassType = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["ClassType"].ToString(); objFlightBal.farebasisCode = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["farebasisCode"].ToString(); objFlightBal.Fare_Rule = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["Rule"].ToString(); objFlightBal.PsgrType = dsBookingResponse.Tables["psgr"].Rows[j]["PsgrType"].ToString(); objFlightBal.BaseFare = dsBookingResponse.Tables["psgr"].Rows[j]["BaseFare"].ToString(); objFlightBal.psgrTax = dsBookingResponse.Tables["psgr"].Rows[j]["Tax"].ToString(); objFlightBal.BagInfo = dsBookingResponse.Tables["psgr"].Rows[j]["BagInfo"].ToString(); bool res1 = objFlightBal.UpdateInternationalFlightSegment(objFlightBal); if (res1) { GetDetailsForPrint(Convert.ToString(Session["Order_Id"])); lbtnmail.Visible = false; pnlSearch.Visible = false; pnlIntPassengerDet.Visible = false; lblMsg.Visible = true; lblMsg.Text = "Ticket has been booked successfully. Reference Number is : " + objFlightBal.ReferenceNo.ToString(); lblMsg.ForeColor = System.Drawing.Color.Green; pnlViewticket.Visible = true; } } lbtnmail_Click1(sender, e); } } } } catch (NullReferenceException) { Response.Redirect("~/Default.aspx", false); } }
void Mail(string mailId) { try { objBAL = new ClsBAL(); System.Data.DataSet ds = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); { string body = getHTML(pnlTicket); bool res = Mailsender.SendEmail(mailId, "", "", "Ticket Details", body); if (res) { lblMsg.Text = "Ticket Details has been sent to your mail. Please check."; lblMsg.ForeColor = System.Drawing.Color.Green; } } } catch (Exception ex) { throw ex; } }
protected void btnIntBookRoundTrip_Click(object sender, EventArgs e) { try { GetRoundtripIntBookingRequest(); Session["Amount"] = lblTotalAmt.Text; if (Session["result"].ToString() == "true") { #region Checking the roles and booking the tickets if (Session["Role"] == null) { Response.Redirect("~/pay.aspx?val=true", false); } else if (Session["Role"].ToString() == "User") { objBAL = new ClsBAL(); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["AgentId_Agent"] = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); Response.Redirect("~/pay.aspx?val=true", false); } else if (Session["Role"].ToString() == "Admin") { saveround(sender, e); } else if (Session["Role"].ToString() == "Agent") { DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "DomesticFlights", lblairline.Text.ToString()); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string actualFare = lblTotalAmt.Text; 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)) { saveround(sender, e); } else { mp3.Show(); lblerror.Text = "Your balance is too low to book the ticket.So,please contact administrator"; return; } } else if (Session["Role"].ToString() == "Distributor") { DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "DomesticFlights", lblairline.Text.ToString()); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string actualFare = lblTotalAmt.Text; 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)) { saveround(sender, e); } else { mp3.Show(); lblerror.Text = "Your balance is too low to book the ticket.So, please contact administrator"; return; } } #endregion } } catch (NullReferenceException) { Response.Redirect("~/Default.aspx", false); } }
protected void btnRoundTripSubmit_Click(object sender, EventArgs e) { try { if (Session["UserID"] == null) { Response.Redirect("~/Default.aspx", false); return; } #region Variables string FlightSegmentsID = string.Empty; string originDestination_Id = string.Empty; string fareDetailsId = string.Empty; string TotalFare = string.Empty; string AirEquipType = string.Empty; string ArrivalAirportCode = string.Empty; string ArrivalDateTime = string.Empty; string DepartureAirportCode = string.Empty; string DepartureDateTime = string.Empty; string FlightNumber = string.Empty; string OperatingAirlineCode = string.Empty; string OperatingAirlineFlightNumber = string.Empty; string RPH = string.Empty; string StopQuantity = string.Empty; string airLineName = string.Empty; string airportTax = string.Empty; string imageFileName = string.Empty; string BookingClassAvailability = string.Empty; string BookingClassResBookDesigCode = string.Empty; string adultFare = string.Empty; string bookingclass = string.Empty; string childFare = string.Empty; string classType = string.Empty; string farebasiscode = string.Empty; string infantfare = string.Empty; string Rule = string.Empty; string adultCommission = string.Empty; string childCommission = string.Empty; string commissionOnTCharge = string.Empty; string Discount = string.Empty; string airportTaxChild = string.Empty; string airportTaxInfant = string.Empty; string adultTaxBreakup = string.Empty; string childTaxBreakup = string.Empty; string infantTaxBreakup = string.Empty; string octax = string.Empty; string id = string.Empty; string key = string.Empty; string TCharge = string.Empty; string TMarkup = string.Empty; string TSdiscount = string.Empty; string TPartnerCommission = string.Empty; string actualBaseFare = string.Empty; string tax = string.Empty; string Stax = string.Empty; string SCharge = string.Empty; string TDiscount = string.Empty; string responseDepartId = string.Empty; string responseReturnId = string.Empty; string OriginDestinationOptionsId = string.Empty; string FlightSegmentsIDRet = string.Empty; string originDestination_IdRet = string.Empty; string fareDetailsIdRet = string.Empty; string TotalFareRet = string.Empty; string AirEquipTypeRet = string.Empty; string ArrivalAirportCodeRet = string.Empty; string ArrivalDateTimeRet = string.Empty; string DepartureAirportCodeRet = string.Empty; string DepartureDateTimeRet = string.Empty; string FlightNumberRet = string.Empty; string OperatingAirlineCodeRet = string.Empty; string OperatingAirlineFlightNumberRet = string.Empty; string RPHRet = string.Empty; string StopQuantityRet = string.Empty; string airLineNameRet = string.Empty; string airportTaxRet = string.Empty; string imageFileNameRet = string.Empty; string BookingClassAvailabilityRet = string.Empty; string BookingClassResBookDesigCodeRet = string.Empty; string adultFareRet = string.Empty; string bookingclassRet = string.Empty; string childFareRet = string.Empty; string classTypeRet = string.Empty; string farebasiscodeRet = string.Empty; string infantfareRet = string.Empty; string RuleRet = string.Empty; string adultCommissionRet = string.Empty; string childCommissionRet = string.Empty; string commissionOnTChargeRet = string.Empty; string DiscountRet = string.Empty; string airportTaxChildRet = string.Empty; string airportTaxInfantRet = string.Empty; string adultTaxBreakupRet = string.Empty; string childTaxBreakupRet = string.Empty; string infantTaxBreakupRet = string.Empty; string octaxRet = string.Empty; string idRet = string.Empty; string keyRet = string.Empty; string TChargeRet = string.Empty; string TMarkupRet = string.Empty; string TSdiscountRet = string.Empty; string TPartnerCommissionRet = string.Empty; string actualBaseFareRet = string.Empty; string taxRet = string.Empty; string StaxRet = string.Empty; string SChargeRet = string.Empty; string TDiscountRet = string.Empty; string responseDepartIdRet = string.Empty; string responseReturnIdRet = string.Empty; string OriginDestinationOptionsIdRet = string.Empty; #endregion DataTable dtFlightSegment = dsFilghts.Tables["FlightSegment"]; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFlightSegment = dtFlightSegment.Select("FlightSegment_Id=" + lblonwardFlightSegmentId.Text); AirEquipType = rowFlightSegment[0]["AirEquipType"].ToString(); ArrivalAirportCode = rowFlightSegment[0]["ArrivalAirportCode"].ToString(); ArrivalDateTime = rowFlightSegment[0]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFlightSegment[0]["DepartureAirportCode"].ToString(); DepartureDateTime = rowFlightSegment[0]["DepartureDateTime"].ToString(); FlightNumber = rowFlightSegment[0]["FlightNumber"].ToString(); OperatingAirlineCode = rowFlightSegment[0]["OperatingAirlineCode"].ToString(); OperatingAirlineFlightNumber = rowFlightSegment[0]["OperatingAirlineFlightNumber"].ToString(); RPH = rowFlightSegment[0]["RPH"].ToString(); StopQuantity = rowFlightSegment[0]["StopQuantity"].ToString(); airLineName = rowFlightSegment[0]["airLineName"].ToString(); airportTax = rowFlightSegment[0]["airportTax"].ToString(); imageFileName = rowFlightSegment[0]["imageFileName"].ToString(); Discount = rowFlightSegment[0]["Discount"].ToString(); airportTaxChild = rowFlightSegment[0]["airportTaxChild"].ToString(); airportTaxInfant = rowFlightSegment[0]["airportTaxInfant"].ToString(); adultTaxBreakup = rowFlightSegment[0]["adultTaxBreakup"].ToString(); childTaxBreakup = rowFlightSegment[0]["childTaxBreakup"].ToString(); infantTaxBreakup = rowFlightSegment[0]["infantTaxBreakup"].ToString(); octax = rowFlightSegment[0]["octax"].ToString(); FlightSegmentsID = rowFlightSegment[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegments = dsFilghts.Tables["FlightSegments"]; if (dtFlightSegments.Rows.Count > 0) { DataRow[] rowFlightSegments = dtFlightSegments.Select("FlightSegments_Id=" + FlightSegmentsID); originDestination_Id = rowFlightSegments[0]["originDestinationoption_Id"].ToString(); } DataTable dtoriginDestinationoption = dsFilghts.Tables["originDestinationoption"]; if (dtoriginDestinationoption.Rows.Count > 0) { DataRow[] roworiginDestinationoption = dtoriginDestinationoption.Select("originDestinationoption_Id=" + originDestination_Id); id = roworiginDestinationoption[0]["id"].ToString(); key = roworiginDestinationoption[0]["key"].ToString(); } DataTable dtFareDetails = dsFilghts.Tables["FareDetails"]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("originDestinationoption_Id=" + originDestination_Id); fareDetailsId = rowFareDetails[0]["FareDetails_Id"].ToString(); } DataTable dtChargeableFares = dsFilghts.Tables["ChargeableFares"]; if (dtChargeableFares.Rows.Count > 0) { DataRow[] rowChargeableFares = dtChargeableFares.Select("FareDetails_Id=" + fareDetailsId); actualBaseFare = rowChargeableFares[0]["ActualBaseFare"].ToString(); tax = rowChargeableFares[0]["tax"].ToString(); Stax = rowChargeableFares[0]["Stax"].ToString(); SCharge = rowChargeableFares[0]["SCharge"].ToString(); TDiscount = rowChargeableFares[0]["TDiscount"].ToString(); TPartnerCommission = rowChargeableFares[0]["TPartnerCommission"].ToString(); } DataTable dtNonChargeableFares = dsFilghts.Tables["NonChargeableFares"]; if (dtNonChargeableFares.Rows.Count > 0) { DataRow[] rowNonChargeableFares = dtNonChargeableFares.Select("FareDetails_Id=" + fareDetailsId); TCharge = rowNonChargeableFares[0]["TCharge"].ToString(); TSdiscount = rowNonChargeableFares[0]["TSdiscount"].ToString(); TMarkup = rowNonChargeableFares[0]["TMarkup"].ToString(); } DataTable dtBookingClass = dsFilghts.Tables["BookingClass"]; if (dtBookingClass.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass.Select("FlightSegment_Id=" + lblonwardFlightSegmentId.Text); BookingClassAvailability = rowBookingClass[0]["Availability"].ToString(); BookingClassResBookDesigCode = rowBookingClass[0]["ResBookDesigCode"].ToString(); } DataTable dtBookingClassfare = dsFilghts.Tables["BookingClassFare"]; if (dtBookingClassfare.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassfare.Select("FlightSegment_Id=" + lblonwardFlightSegmentId.Text); adultFare = rowBookingClassFare[0]["adultFare"].ToString(); if (dtBookingClassfare.Columns.Contains("childFare")) { childFare = rowBookingClassFare[0]["childFare"].ToString(); } if (dtBookingClassfare.Columns.Contains("infantfare")) { infantfare = rowBookingClassFare[0]["infantfare"].ToString(); } bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString().Replace("<", "<").Replace(">", ">"); adultCommission = rowBookingClassFare[0]["adultCommission"].ToString(); childCommission = rowBookingClassFare[0]["childCommission"].ToString(); commissionOnTCharge = rowBookingClassFare[0]["commissionOnTCharge"].ToString(); } #region ReturnOriginDestionOptionDetails DataTable dtFlightSegmentRet = dsFilghts.Tables["FlightSegment"]; if (dtFlightSegmentRet.Rows.Count > 0) { DataRow[] rowFlightSegmentRet = dtFlightSegmentRet.Select("FlightSegment_Id=" + lblReturnFlightSegment.Text); AirEquipTypeRet = rowFlightSegmentRet[0]["AirEquipType"].ToString(); ArrivalAirportCodeRet = rowFlightSegmentRet[0]["ArrivalAirportCode"].ToString(); ArrivalDateTimeRet = rowFlightSegmentRet[0]["ArrivalDateTime"].ToString(); DepartureAirportCodeRet = rowFlightSegmentRet[0]["DepartureAirportCode"].ToString(); DepartureDateTimeRet = rowFlightSegmentRet[0]["DepartureDateTime"].ToString(); FlightNumberRet = rowFlightSegmentRet[0]["FlightNumber"].ToString(); OperatingAirlineCodeRet = rowFlightSegmentRet[0]["OperatingAirlineCode"].ToString(); OperatingAirlineFlightNumberRet = rowFlightSegmentRet[0]["OperatingAirlineFlightNumber"].ToString(); RPHRet = rowFlightSegmentRet[0]["RPH"].ToString(); StopQuantityRet = rowFlightSegmentRet[0]["StopQuantity"].ToString(); airLineNameRet = rowFlightSegmentRet[0]["airLineName"].ToString(); airportTaxRet = rowFlightSegmentRet[0]["airportTax"].ToString(); imageFileNameRet = rowFlightSegmentRet[0]["imageFileName"].ToString(); DiscountRet = rowFlightSegmentRet[0]["Discount"].ToString(); airportTaxChildRet = rowFlightSegmentRet[0]["airportTaxChild"].ToString(); airportTaxInfantRet = rowFlightSegmentRet[0]["airportTaxInfant"].ToString(); adultTaxBreakupRet = rowFlightSegmentRet[0]["adultTaxBreakup"].ToString(); childTaxBreakupRet = rowFlightSegmentRet[0]["childTaxBreakup"].ToString(); infantTaxBreakupRet = rowFlightSegmentRet[0]["infantTaxBreakup"].ToString(); octaxRet = rowFlightSegmentRet[0]["octax"].ToString(); FlightSegmentsIDRet = rowFlightSegmentRet[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegmentsRet = dsFilghts.Tables["FlightSegments"]; if (dtFlightSegmentsRet.Rows.Count > 0) { DataRow[] rowFlightSegmentsRet = dtFlightSegmentsRet.Select("FlightSegments_Id=" + FlightSegmentsIDRet); originDestination_IdRet = rowFlightSegmentsRet[0]["originDestinationoption_Id"].ToString(); } DataTable dtoriginDestinationoptionRet = dsFilghts.Tables["originDestinationoption"]; if (dtoriginDestinationoptionRet.Rows.Count > 0) { DataRow[] roworiginDestinationoptionRet = dtoriginDestinationoptionRet.Select("originDestinationoption_Id=" + originDestination_IdRet); idRet = roworiginDestinationoptionRet[0]["id"].ToString(); keyRet = roworiginDestinationoptionRet[0]["key"].ToString(); } DataTable dtFareDetailsRet = dsFilghts.Tables["FareDetails"]; if (dtFareDetailsRet.Rows.Count > 0) { DataRow[] rowFareDetailsRet = dtFareDetailsRet.Select("originDestinationoption_Id=" + originDestination_IdRet); fareDetailsIdRet = rowFareDetailsRet[0]["FareDetails_Id"].ToString(); } DataTable dtChargeableFaresRet = dsFilghts.Tables["ChargeableFares"]; if (dtChargeableFaresRet.Rows.Count > 0) { DataRow[] rowChargeableFaresRet = dtChargeableFaresRet.Select("FareDetails_Id=" + fareDetailsIdRet); actualBaseFareRet = rowChargeableFaresRet[0]["ActualBaseFare"].ToString(); taxRet = rowChargeableFaresRet[0]["tax"].ToString(); StaxRet = rowChargeableFaresRet[0]["Stax"].ToString(); SChargeRet = rowChargeableFaresRet[0]["SCharge"].ToString(); TDiscountRet = rowChargeableFaresRet[0]["TDiscount"].ToString(); TPartnerCommissionRet = rowChargeableFaresRet[0]["TPartnerCommission"].ToString(); } DataTable dtNonChargeableFaresRet = dsFilghts.Tables["NonChargeableFares"]; if (dtNonChargeableFaresRet.Rows.Count > 0) { DataRow[] rowNonChargeableFaresRet = dtNonChargeableFaresRet.Select("FareDetails_Id=" + fareDetailsIdRet); TChargeRet = rowNonChargeableFaresRet[0]["TCharge"].ToString(); TSdiscountRet = rowNonChargeableFaresRet[0]["TSdiscount"].ToString(); TMarkupRet = rowNonChargeableFaresRet[0]["TMarkup"].ToString(); } DataTable dtBookingClassRet = dsFilghts.Tables["BookingClass"]; if (dtBookingClassRet.Rows.Count > 0) { DataRow[] rowBookingClassRet = dtBookingClassRet.Select("FlightSegment_Id=" + lblReturnFlightSegment.Text); BookingClassAvailabilityRet = rowBookingClassRet[0]["Availability"].ToString(); BookingClassResBookDesigCodeRet = rowBookingClassRet[0]["ResBookDesigCode"].ToString(); } DataTable dtBookingClassfareRet = dsFilghts.Tables["BookingClassFare"]; if (dtBookingClassfareRet.Rows.Count > 0) { DataRow[] rowBookingClassFareRet = dtBookingClassfareRet.Select("FlightSegment_Id=" + lblReturnFlightSegment.Text); adultFareRet = rowBookingClassFareRet[0]["adultFare"].ToString(); if (dtBookingClassfareRet.Columns.Contains("childFare")) { childFareRet = rowBookingClassFareRet[0]["childFare"].ToString(); } if (dtBookingClassfareRet.Columns.Contains("infantfare")) { infantfareRet = rowBookingClassFareRet[0]["infantfare"].ToString(); } bookingclassRet = rowBookingClassFareRet[0]["bookingclass"].ToString(); classTypeRet = rowBookingClassFareRet[0]["classType"].ToString(); farebasiscodeRet = rowBookingClassFareRet[0]["farebasiscode"].ToString(); RuleRet = rowBookingClassFareRet[0]["Rule"].ToString().Replace("<", "<").Replace(">", ">"); adultCommissionRet = rowBookingClassFareRet[0]["adultCommission"].ToString(); childCommissionRet = rowBookingClassFareRet[0]["childCommission"].ToString(); commissionOnTChargeRet = rowBookingClassFareRet[0]["commissionOnTCharge"].ToString(); } #endregion #region Pricing #region Pricing String XMLPricing = "<pricingrequest><onwardFlights><OriginDestinationOption><FareDetails><ChargeableFares><ActualBaseFare>" + actualBaseFare + "</ActualBaseFare><Tax>" + tax + "</Tax> <STax>" + Stax + "</STax><SCharge>" + SCharge + "</SCharge> <TDiscount>" + TDiscount + "</TDiscount><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TCharge + "</TCharge> <TMarkup>" + TMarkup + "</TMarkup><TSdiscount>" + TDiscount + "</TSdiscount> </NonchargeableFares></FareDetails> <FlightSegments> <FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><RPH>" + RPH + "</RPH> <StopQuantity>" + StopQuantity + "</StopQuantity><airLineName>" + airLineName + "</airLineName><airportTax>" + airportTax + "</airportTax><imageFileName>" + imageFileName + "</imageFileName> <BookingClass><Availability>" + BookingClassAvailability + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCode + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFare + "</adultFare><bookingclass>" + bookingclass + "</bookingclass> <childFare>" + childFare + "</childFare><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><infantfare>" + infantfare + "</infantfare> <Rule>" + Rule + "</Rule><adultCommission>" + adultCommission + "</adultCommission><childCommission>" + childCommission + "</childCommission><commissionOnTCharge>" + commissionOnTCharge + "</commissionOnTCharge></BookingClassFare> <Discount>" + Discount + "</Discount><airportTaxChild>" + airportTaxChild + "</airportTaxChild><airportTaxInfant>" + airportTaxInfant + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakup + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakup + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakup + "</infantTaxBreakup><octax>" + octax + "</octax> </FlightSegment> </FlightSegments><id>" + id + "</id><key>" + key + "</key> </OriginDestinationOption></onwardFlights>"; XMLPricing = XMLPricing + "<returnFlights><OriginDestinationOption><FareDetails><ChargeableFares><ActualBaseFare>" + actualBaseFareRet + "</ActualBaseFare><Tax>" + taxRet + "</Tax> <STax>" + StaxRet + "</STax><SCharge>" + SChargeRet + "</SCharge> <TDiscount>" + TDiscountRet + "</TDiscount><TPartnerCommission>" + TPartnerCommissionRet + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TChargeRet + "</TCharge> <TMarkup>" + TMarkupRet + "</TMarkup><TSdiscount>" + TDiscountRet + "</TSdiscount> </NonchargeableFares></FareDetails> <FlightSegments> <FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><RPH>" + RPHRet + "</RPH> <StopQuantity>" + StopQuantityRet + "</StopQuantity><airLineName>" + airLineNameRet + "</airLineName><airportTax>" + airportTaxRet + "</airportTax><imageFileName>" + imageFileNameRet + "</imageFileName> <BookingClass><Availability>" + BookingClassAvailabilityRet + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCodeRet + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFareRet + "</adultFare><bookingclass>" + bookingclassRet + "</bookingclass> <childFare>" + childFareRet + "</childFare><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><infantfare>" + infantfareRet + "</infantfare> <Rule>" + RuleRet + "</Rule><adultCommission>" + adultCommissionRet + "</adultCommission><childCommission>" + childCommissionRet + "</childCommission><commissionOnTCharge>" + commissionOnTChargeRet + "</commissionOnTCharge></BookingClassFare> <Discount>" + DiscountRet + "</Discount><airportTaxChild>" + airportTaxChildRet + "</airportTaxChild><airportTaxInfant>" + airportTaxInfantRet + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakupRet + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakupRet + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakupRet + "</infantTaxBreakup><octax>" + octaxRet + "</octax> </FlightSegment> </FlightSegments><id>" + idRet + "</id><key>" + keyRet + "</key> </OriginDestinationOption></returnFlights>"; XMLPricing = XMLPricing + "<telePhone>" + txtPhoneNum.Text + "</telePhone><email>" + txtEmailID.Text + "</email> <creditcardno></creditcardno><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooFWS1.1</Clienttype><AdultPax>" + Session["adultcnt"].ToString() + "</AdultPax><ChildPax>" + Session["childCnt"].ToString() + "</ChildPax><InfantPax>" + Session["infantCnt"].ToString() + "</InfantPax></pricingrequest>"; DataSet dsFlightPricing = objFlights.GetPricingDetails(XMLPricing.Replace("<br>","")); if (!dsFlightPricing.Tables[0].Columns.Contains("error")) { string ReturnFlightId = dsFlightPricing.Tables["returnFlights"].Rows[0]["ReturnFlights_Id"].ToString(); DataTable dtchangeFlightSegments = dsFlightPricing.Tables["originDestinationoption"]; if (dtchangeFlightSegments.Rows.Count > 0) { DataRow[] rowchangeFilghtSegments = dtchangeFlightSegments.Select("ReturnFlights_Id=" + ReturnFlightId); originDestination_IdRet = rowchangeFilghtSegments[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtchangeFareDetails = dsFlightPricing.Tables[3]; if (dtchangeFareDetails.Rows.Count > 0) { DataRow[] rowchangeFareDetails = dtchangeFareDetails.Select("OriginDestinationOption_Id=" + originDestination_IdRet); fareDetailsIdRet = rowchangeFareDetails[0]["FareDetails_Id"].ToString(); } DataTable dtchangeprice = dsFlightPricing.Tables[4]; if (dtchangeprice.Rows.Count > 0) { DataRow[] rowchangeprices = dtchangeprice.Select("FareDetails_Id=" + fareDetailsIdRet); TPartnerCommissionRet = rowchangeprices[0]["TPartnerCommission"].ToString(); actualBaseFareRet = rowchangeprices[0]["ActualBaseFare"].ToString(); taxRet = rowchangeprices[0]["Tax"].ToString(); StaxRet = rowchangeprices[0]["Stax"].ToString(); SChargeRet = rowchangeprices[0]["SCharge"].ToString(); TDiscountRet = rowchangeprices[0]["TDiscount"].ToString(); TotalFare = (Convert.ToDecimal(actualBaseFare) + Convert.ToDecimal(tax) + Convert.ToDecimal(Stax).ToString()) ;//+ Convert.ToDecimal(SCharge) - Convert.ToDecimal(TDiscount)).ToString(); } } #endregion #endregion string refNo = Common.GetFlightsReferenceNo("LJDF"); String xmlRequestData = "<Bookingrequest><onwardFlights><OriginDestinationOption><FareDetails> <ChargeableFares><ActualBaseFare>" + actualBaseFare + "</ActualBaseFare> <Tax>" + tax + "</Tax><STax>" + Stax + "</STax> <SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TCharge + "</TCharge> <TMarkup>" + TMarkup + "</TMarkup><TSdiscount>" + TSdiscount + "</TSdiscount> </NonchargeableFares></FareDetails>"; xmlRequestData = xmlRequestData + "<FlightSegments> <FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><RPH>" + RPH + "</RPH> <StopQuantity>" + StopQuantity + "</StopQuantity><airLineName>" + airLineName + "</airLineName><airportTax>" + airportTax + "</airportTax><imageFileName>" + imageFileName + "</imageFileName>"; xmlRequestData = xmlRequestData + "<BookingClass><Availability>" + BookingClassAvailability + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCode + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFare + "</adultFare><bookingclass>" + bookingclass + "</bookingclass> <childFare>" + childFare + "</childFare><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><infantfare>" + infantfare + "</infantfare> <Rule>" + Rule + "</Rule><adultCommission>" + adultCommission + "</adultCommission><childCommission>" + childCommission + "</childCommission><commissionOnTCharge>" + commissionOnTCharge + "</commissionOnTCharge></BookingClassFare>"; xmlRequestData = xmlRequestData + "<Discount>" + Discount + "</Discount><airportTaxChild>" + airportTaxChild + "</airportTaxChild><airportTaxInfant>" + airportTaxInfant + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakup + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakup + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakup + "</infantTaxBreakup><octax>" + octax + "</octax> </FlightSegment> </FlightSegments>"; xmlRequestData = xmlRequestData + "<id>" + id + "</id><key>" + key + "</key> </OriginDestinationOption></onwardFlights>"; xmlRequestData = xmlRequestData + "<returnFlights><OriginDestinationOption><FareDetails> <ChargeableFares><ActualBaseFare>" + actualBaseFareRet + "</ActualBaseFare> <Tax>" + taxRet + "</Tax><STax>" + StaxRet + "</STax> <SCharge>" + SChargeRet + "</SCharge><TDiscount>" + TDiscountRet + "</TDiscount><TPartnerCommission>" + TPartnerCommissionRet + "</TPartnerCommission></ChargeableFares> <NonchargeableFares><TCharge>" + TChargeRet + "</TCharge> <TMarkup>" + TMarkupRet + "</TMarkup><TSdiscount>" + TSdiscountRet + "</TSdiscount> </NonchargeableFares></FareDetails>"; xmlRequestData = xmlRequestData + "<FlightSegments> <FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><RPH>" + RPHRet + "</RPH> <StopQuantity>" + StopQuantityRet + "</StopQuantity><airLineName>" + airLineNameRet + "</airLineName><airportTax>" + airportTaxRet + "</airportTax><imageFileName>" + imageFileNameRet + "</imageFileName>"; xmlRequestData = xmlRequestData + "<BookingClass><Availability>" + BookingClassAvailabilityRet + "</Availability><ResBookDesigCode>" + BookingClassResBookDesigCodeRet + "</ResBookDesigCode> </BookingClass><BookingClassFare> <adultFare>" + adultFareRet + "</adultFare><bookingclass>" + bookingclassRet + "</bookingclass> <childFare>" + childFareRet + "</childFare><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><infantfare>" + infantfareRet + "</infantfare> <Rule>" + RuleRet + "</Rule><adultCommission>" + adultCommissionRet + "</adultCommission><childCommission>" + childCommissionRet + "</childCommission><commissionOnTCharge>" + commissionOnTChargeRet + "</commissionOnTCharge></BookingClassFare>"; xmlRequestData = xmlRequestData + "<Discount>" + DiscountRet + "</Discount><airportTaxChild>" + airportTaxChildRet + "</airportTaxChild><airportTaxInfant>" + airportTaxInfantRet + "</airportTaxInfant><adultTaxBreakup>" + adultTaxBreakupRet + "</adultTaxBreakup><childTaxBreakup>" + childTaxBreakupRet + "</childTaxBreakup><infantTaxBreakup>" + infantTaxBreakupRet + "</infantTaxBreakup><octax>" + octaxRet + "</octax> </FlightSegment> </FlightSegments>"; xmlRequestData = xmlRequestData + "<id>" + idRet + "</id><key>" + keyRet + "</key> </OriginDestinationOption></returnFlights>"; xmlRequestData = xmlRequestData + "<personName>"; // Dynamic generation of names of adults, infants , Child Table tbladults = (Table)this.UpdatePanel1.FindControl("tblAdults"); for (int i = 1; i <= Convert.ToInt32(Session["adultcnt"]); i++) { TextBox txtFn = (TextBox)tbladults.FindControl("txtFn" + i); TextBox txtLn = (TextBox)tbladults.FindControl("txtLn" + i); DropDownList ddlTitle = (DropDownList)tbladults.FindControl("ddlTitle" + i); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } Table tblChild = (Table)this.UpdatePanel1.FindControl("tblChild"); for (int i = 1; i <= Convert.ToInt32(Session["childCnt"]); i++) { TextBox txtFn = (TextBox)tblChild.FindControl("txtCFn" + i); TextBox txtLn = (TextBox)tblChild.FindControl("txtCLn" + i); DropDownList ddlTitle = (DropDownList)tblChild.FindControl("ddlCTitle" + i); TextBox txtBirthDate = (TextBox)tblChild.FindControl("txtCBirthDate" + i); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>chd</psgrtype></CustomerInfo>"; } Table tblInfants = (Table)this.UpdatePanel1.FindControl("tblInfants"); for (int i = 1; i <= Convert.ToInt32(Session["infantCnt"]); i++) { TextBox txtFn = (TextBox)tblInfants.FindControl("txtIFn" + i); TextBox txtLn = (TextBox)tblInfants.FindControl("txtILn" + i); DropDownList ddlTitle = (DropDownList)tblInfants.FindControl("ddlITitle" + i); TextBox txtBirthDate = (TextBox)tblInfants.FindControl("txtIBirthDate" + i); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); xmlRequestData = xmlRequestData + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><dob>" + txtBirthDate.Text + "</dob><age>" + age + "</age><psgrtype>inf</psgrtype></CustomerInfo>"; } xmlRequestData = xmlRequestData + "</personName><telePhone><phoneNumber>" + txtMobileNo.Text + "</phoneNumber></telePhone><email><emailAddress>" + txtEmailID.Text + "</emailAddress></email><creditcardno>4111111111111111</creditcardno><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword> <partnerRefId>" + refNo + "</partnerRefId> <Clienttype>ArzooFWS1.1</Clienttype><AdultPax>" + ddlAdult.SelectedItem.Value + "</AdultPax><ChildPax>" + ddlChild.SelectedItem.Value + "</ChildPax><InfantPax>" + ddlInfant.SelectedItem.Value + "</InfantPax></Bookingrequest>"; DataSet dsBookingResponse = new DataSet(); DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "DomesticFlights", airLineName.ToString()); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string actualFare = lblTotalOnwardReturn.Text; 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; //Return Deduct DataSet dsCommSlabRet = objBAL.GetCommissionSlab(Session["Role"].ToString(), "DomesticFlights", airLineNameRet.ToString()); // Change it string commisionPercentageRet = string.Empty; if (dsCommSlabRet.Tables[0].Rows.Count > 0) commisionPercentageRet = dsCommSlabRet.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentageRet = "0"; string actualFareRet = lblTotalOnwardReturn.Text; string deductAmountRet = Convert.ToString(Convert.ToDouble(actualFareRet.ToString()) - ((Convert.ToDouble(actualFareRet.ToString()) * Convert.ToDouble(commisionPercentageRet)) / 100)); string commisionFareRet = Convert.ToString(Convert.ToDouble(actualFareRet.ToString()) - Convert.ToDouble(deductAmountRet)); Session["ActualFare_AgentRet"] = actualFareRet; Session["CommisionFare_AgentRet"] = commisionFareRet; Session["CommisionPercentage_AgentRet"] = commisionPercentageRet; Session["DeductAmount_AgentRet"] = deductAmountRet; //End Of ReturnDeduct if (Convert.ToDouble(balance) >= (Convert.ToDouble(deductAmount) + Convert.ToDouble(deductAmountRet))) { dsBookingResponse = objFlights.GetBookingDetails(xmlRequestData.Replace("<br>","")); } else { return; } string error = string.Empty; // If there is any Error -- We wont get the transid instead we get error if (dsBookingResponse.Tables[0].Columns.Contains("transid")) { transId = dsBookingResponse.Tables[0].Rows[0]["transid"].ToString(); string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); string[] commPerRet = Session["CommisionPercentage_AgentRet"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), refNo, Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToInt32(commPer[0])); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_AgentRet"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), refNo, Convert.ToDouble(Session["ActualFare_AgentRet"].ToString()), Convert.ToDouble(Session["CommisionFare_AgentRet"].ToString()), Convert.ToInt32(commPerRet[0])); 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; #region SaveResponse FlightBAL objFlightBal = new FlightBAL(); objFlightBal.ReferenceNo = refNo; objFlightBal.TransId = transId; objFlightBal.Status = dsBookingResponse.Tables["Bookingresponse"].Rows[0]["status"].ToString(); objFlightBal.AdultPax = Convert.ToInt32(dsBookingResponse.Tables["Bookingresponse"].Rows[0]["AdultPax"].ToString()); objFlightBal.InfantPax = Convert.ToInt32(dsBookingResponse.Tables["Bookingresponse"].Rows[0]["InfantPax"].ToString()); objFlightBal.ChildPax = Convert.ToInt32(dsBookingResponse.Tables["Bookingresponse"].Rows[0]["ChildPax"].ToString()); objFlightBal.Origin_Destination_Id = dsBookingResponse.Tables["originDestinationOption"].Rows[0]["id"].ToString(); objFlightBal.Origin_Destination_Key = dsBookingResponse.Tables["originDestinationOption"].Rows[0]["key"].ToString(); objFlightBal.ActualBasefare = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["ActualBasefare"].ToString()); objFlightBal.Tax = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["Tax"].ToString()); objFlightBal.STax = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["STax"].ToString()); objFlightBal.Scharge = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["Scharge"].ToString()); objFlightBal.TDiscount = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["TDiscount"].ToString()); objFlightBal.TPartnerCommission = Convert.ToDecimal(dsBookingResponse.Tables["ChargeableFares"].Rows[0]["TPartnerCommission"].ToString()); objFlightBal.TCharge = Convert.ToDecimal(dsBookingResponse.Tables["NonChargeableFares"].Rows[0]["TCharge"].ToString()); objFlightBal.TMarkUp = Convert.ToDecimal(dsBookingResponse.Tables["NonChargeableFares"].Rows[0]["TMarkUp"].ToString()); objFlightBal.TSDiscount = Convert.ToDecimal(dsBookingResponse.Tables["NonChargeableFares"].Rows[0]["TSDiscount"].ToString()); //added objFlightBal.ActualBasefareRet = Convert.ToDecimal(actualBaseFareRet); objFlightBal.TaxRet = Convert.ToDecimal(taxRet); objFlightBal.STaxRet = Convert.ToDecimal(StaxRet); objFlightBal.SchargeRet = Convert.ToDecimal(SChargeRet); objFlightBal.TDiscountRet = Convert.ToDecimal(TDiscountRet); objFlightBal.TPartnerCommissionRet = Convert.ToDecimal(TPartnerCommissionRet); objFlightBal.TChargeRet = Convert.ToDecimal(TChargeRet); objFlightBal.TMarkUpRet = Convert.ToDecimal(TMarkupRet); objFlightBal.TSDiscountRet = Convert.ToDecimal(TSdiscountRet); string givenName = string.Empty; string surName = string.Empty; string namereference = string.Empty; string psgrType = string.Empty; string Age = string.Empty; string customerInfo = string.Empty; for (int i = 0; i < dsBookingResponse.Tables["CustomerInfo"].Rows.Count; i++) { givenName = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["givenName"].ToString(); surName = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["surName"].ToString(); namereference = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["nameReference"].ToString(); // psgrType = "adt"; //dsBookingResponse.Tables["CustomerInfo"].Rows[i]["psgrtype"].ToString(); string[] str = namereference.ToString().Split(','); if (str[0].ToString() == "C") { psgrType = "Child"; Age = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["age"].ToString(); } else if (str[0].ToString() == "I") { psgrType = "Infant"; Age = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["age"].ToString(); } else { psgrType = "Adult"; } // psgrType = "";// dsBookingResponse.Tables["CustomerInfo"].Rows[i]["psgrtype"].ToString(); if (psgrType.ToString() != "Adult") { if (psgrType.ToString() == "Child") { if (customerInfo == string.Empty) { customerInfo = str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } else { customerInfo = customerInfo + ";" + str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } } else { if (customerInfo == string.Empty) { customerInfo = str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age + "M"; } else { customerInfo = customerInfo + ";" + str[1].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age + "M"; } } } else { if (customerInfo == string.Empty) { customerInfo = str[0].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + "-"; } else { customerInfo = customerInfo + ";" + str[0].ToString() + "|" + givenName + "|" + surName + "|" + psgrType + "|" + "-"; } } //if (customerInfo == string.Empty) //{ // customerInfo = namereference + "|" + givenName + "|" + surName + "|" + psgrType; //} //else //{ // customerInfo = customerInfo + ";" + namereference + "|" + givenName + "|" + surName + "|" + psgrType; //} } objFlightBal.Customer_Details = customerInfo; objFlightBal.telephone = dsBookingResponse.Tables["telePhone"].Rows[0]["PhoneNumber"].ToString(); objFlightBal.emailAddress = lblEmailAddress.Text = dsBookingResponse.Tables["email"].Rows[0]["emailAddress"].ToString(); objFlightBal.TripMode = "Round"; objFlightBal.idRet = idRet; objFlightBal.keyRet = keyRet; DataTable dtflightBookingId = objFlightBal.AddDomesticFlightBooking(objFlightBal); string flightBookingId = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); objFlightBal.FlightBookingID = flightBookingId.ToString(); if (dsBookingResponse.Tables["FlightSegment"].Rows.Count > 0) { for (int j = 0; j < dsBookingResponse.Tables["FlightSegment"].Rows.Count; j++) { objFlightBal.AirEquipType = dsBookingResponse.Tables["FlightSegment"].Rows[j]["AirEquipType"].ToString(); objFlightBal.ArrivalAirportCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ArrivalAirportCode"].ToString(); objFlightBal.ArrivalDateTime = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ArrivalDateTime"].ToString(); objFlightBal.DepartureAirportCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DepartureAirportCode"].ToString(); objFlightBal.DepartureDateTime = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DepartureDateTime"].ToString(); objFlightBal.FlightNumber = dsBookingResponse.Tables["FlightSegment"].Rows[j]["FlightNumber"].ToString(); objFlightBal.OperatingAirlineCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["OperatingAirlineCode"].ToString(); objFlightBal.OperatingAirlineFlightNumber = dsBookingResponse.Tables["FlightSegment"].Rows[j]["OperatingAirlineFlightNumber"].ToString(); objFlightBal.RPH = dsBookingResponse.Tables["FlightSegment"].Rows[j]["RPH"].ToString(); objFlightBal.StopQuantity = dsBookingResponse.Tables["FlightSegment"].Rows[j]["StopQuantity"].ToString(); objFlightBal.airlineName = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airlineName"].ToString(); objFlightBal.airportTax = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airportTax"].ToString(); objFlightBal.imageFileName = dsBookingResponse.Tables["FlightSegment"].Rows[j]["imageFileName"].ToString(); objFlightBal.Discount = dsBookingResponse.Tables["FlightSegment"].Rows[j]["Discount"].ToString(); objFlightBal.airportTaxChild = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airportTaxChild"].ToString(); objFlightBal.airportTaxInfant = dsBookingResponse.Tables["FlightSegment"].Rows[j]["airportTaxInfant"].ToString(); objFlightBal.adultTaxBreakUp = dsBookingResponse.Tables["FlightSegment"].Rows[j]["adultTaxBreakUp"].ToString(); objFlightBal.ChildTaxBreakUp = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ChildTaxBreakUp"].ToString(); objFlightBal.InfantTaxBreakUp = dsBookingResponse.Tables["FlightSegment"].Rows[j]["InfantTaxBreakUp"].ToString(); objFlightBal.ocTax = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ocTax"].ToString(); objFlightBal.Availability = dsBookingResponse.Tables["BookingClass"].Rows[j]["Availability"].ToString(); objFlightBal.ResBookingCode = dsBookingResponse.Tables["BookingClass"].Rows[j]["ResBookDesigCode"].ToString(); objFlightBal.adultFare = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["adultFare"].ToString(); objFlightBal.bookingClass = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["bookingClass"].ToString(); objFlightBal.ChildFare = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["ChildFare"].ToString(); objFlightBal.ClassType = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["ClassType"].ToString(); objFlightBal.farebasisCode = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["farebasisCode"].ToString(); objFlightBal.infantFare = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["infantFare"].ToString(); objFlightBal.Fare_Rule = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["Rule"].ToString(); objFlightBal.adultCommission = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["adultCommission"].ToString(); objFlightBal.childCommission = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["childCommission"].ToString(); objFlightBal.CommissionOnTCharge = dsBookingResponse.Tables["BookingClassFare"].Rows[j]["CommissionOnTCharge"].ToString(); objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); bool res = objFlightBal.AddDomesticFlightBookingsegments(objFlightBal); if (res) { GetBookingStatus(refNo); GetDetailsForPrint(objFlightBal.ReferenceNo.ToString()); } #endregion else { error = dsBookingResponse.Tables[0].Rows[0]["error"].ToString(); lblStatus.Text = error; lblStatus.ForeColor = System.Drawing.Color.Red; } } lbtnmail.Visible = false; lbtnmail_Click1(sender, e); pnlPassengerDet.Visible = false; lblStatus.Visible = true; lblStatus.Text = "Ticket has been booked successfully. Reference Number is : " + objFlightBal.ReferenceNo.ToString(); lblStatus.ForeColor = System.Drawing.Color.Green; } } else { lblStatus.Text = dsBookingResponse.Tables[0].Rows[0]["Error"].ToString(); if (lblStatus.Text == "Insufficient Funds") { lblStatus.Text = "Please Contact administrator"; } lblStatus.Visible = true; } } catch (Exception ex) { } }
private void saveround(object sender, EventArgs e) { try { DataSet dsBookingResponse = new DataSet(); dsBookingResponse = methodround(); #region Save Response FlightBAL objFlightBal = new FlightBAL(); if (dsBookingResponse.Tables.Count > 0) { if (dsBookingResponse.Tables["BookingResponse"].Rows.Count > 0) { #region Dedcuting the amount from the agent and DB's balance after booking if (Session["UserID"] != null) { if (Session["Role"] != null) { if (Session["Role"].ToString() == "Agent" || Session["Role"].ToString() == "Distributor") { string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), Session["Order_Id"].ToString(), Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionPercentage_Agent"])); 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 = balanceAgent; Session["Balance"] = balanceAgent; } else if (Session["Role"].ToString() == "User") { DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble("0.00"), Convert.ToInt32(Session["UserID"].ToString()), Session["Order_Id"].ToString(), Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } else if (Session["Role"].ToString() == "Admin") { DeductAgentBalance(0, Convert.ToDouble("0.00"), Convert.ToInt32(Session["UserID"].ToString()), Session["Order_Id"].ToString(), Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } } } else if (Session["Role"] == null) { DeductAgentBalance(0, Convert.ToDouble("0.00"), 0, Session["Order_Id"].ToString(), Convert.ToDouble(Session["Amount"].ToString()), Convert.ToDouble("0.00"), Convert.ToDouble("0.00")); } #endregion objFlightBal.ReferenceNo = Convert.ToString(Session["Order_Id"]);// Common.GetFlightsReferenceNo("LJIF"); objFlightBal.TransId = dsBookingResponse.Tables["BookingResponse"].Rows[0]["transid"].ToString(); objFlightBal.Status = dsBookingResponse.Tables["BookingResponse"].Rows[0]["status"].ToString(); objFlightBal.UpdateDInternationalFlightBooking(objFlightBal); GetDetailsForPrint(Convert.ToString(Session["Order_Id"])); lbtnmail.Visible = false; lbtnmail_Click1(sender, e); pnlSearch.Visible = false; pnlViewticket.Visible = true; pnlIntPassengerDet.Visible = false; lblMsg.Visible = true; lblMsg.Text = "Ticket has been booked successfully. Reference Number is : " + Convert.ToString(Session["Order_Id"]); lblMsg.ForeColor = System.Drawing.Color.Green; } } #endregion } catch (NullReferenceException) { Response.Redirect("~/Default.aspx", false); //throw ex; } }
protected void btnIntBook_Click(object sender, EventArgs e) { if (Session["UserID"] == null) { Response.Redirect("~/Default.aspx", false); return; } ClsBAL objBAL = new ClsBAL(); DataSet dsBookingResponse = new DataSet(); //if (Session["Role"].ToString() == "Agent") //{ DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "InterNationalFlights",lblairline.Text); // Change it string commisionPercentage = string.Empty; if (dsCommSlab.Tables[0].Rows.Count > 0) commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it else commisionPercentage = "0"; string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString(); // string commisionPercentage = dsBalance.Tables[0].Rows[0]["CommisionPercentage"].ToString(); string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString(); string actualFare = Session["TotalFare"].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)) { dsBookingResponse = GetIntBookingRequest(); } else { lblMsg.Text = "Please contact administrator."; return; } //} //else if (Session["Role"].ToString() == "User") //{ //} #region Save Response FlightBAL objFlightBal = new FlightBAL(); if (dsBookingResponse.Tables.Count > 0) { if (dsBookingResponse.Tables["BookingResponse"].Rows.Count > 0) { objFlightBal.ReferenceNo = Common.GetFlightsReferenceNo("LJIF"); objFlightBal.TransId = dsBookingResponse.Tables["BookingResponse"].Rows[0]["transid"].ToString(); objFlightBal.Status = dsBookingResponse.Tables["BookingResponse"].Rows[0]["status"].ToString(); objFlightBal.AdultPax = Convert.ToInt32(dsBookingResponse.Tables["BookingResponse"].Rows[0]["noadults"].ToString()); objFlightBal.InfantPax = Convert.ToInt32(dsBookingResponse.Tables["BookingResponse"].Rows[0]["noinfant"].ToString()); objFlightBal.ChildPax = Convert.ToInt32(dsBookingResponse.Tables["BookingResponse"].Rows[0]["nochild"].ToString()); objFlightBal.Origin_Destination_Id = dsBookingResponse.Tables["OriginDestinationOption"].Rows[0]["id"].ToString(); objFlightBal.Origin_Destination_Key = dsBookingResponse.Tables["OriginDestinationOption"].Rows[0]["key"].ToString(); objFlightBal.ActualBasefare = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["ActualBasefare"].ToString()); objFlightBal.Tax = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["Tax"].ToString()); objFlightBal.STax = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["STax"].ToString()); objFlightBal.TCharge = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TCharge"].ToString()); objFlightBal.Scharge = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["Scharge"].ToString()); objFlightBal.TDiscount = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TDiscount"].ToString()); objFlightBal.TMarkUp = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TMarkUp"].ToString()); objFlightBal.TPartnerCommission = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TPartnerCommission"].ToString()); objFlightBal.TSDiscount = Convert.ToDecimal(dsBookingResponse.Tables["FareDetails"].Rows[0]["TSDiscount"].ToString()); objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); objFlightBal.TripMode = "One"; DataTable dtflightBookingId = objFlightBal.AddDInternationalFlightBooking(objFlightBal); string flightBookingId = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); //Do the Insert of Flgiht Segment objFlightBal.FlightBookingID = flightBookingId.ToString(); if (dsBookingResponse.Tables["FlightSegment"].Rows.Count > 0) { for (int j = 0; j < dsBookingResponse.Tables["FlightSegment"].Rows.Count; j++) { objFlightBal.AirEquipType = dsBookingResponse.Tables["FlightSegment"].Rows[j]["AirEquipType"].ToString(); objFlightBal.ArrivalAirportCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ArrivalAirportCode"].ToString(); objFlightBal.ArrivalAirportName = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ArrivalAirportName"].ToString(); objFlightBal.ArrivalDateTime = dsBookingResponse.Tables["FlightSegment"].Rows[j]["ArrivalDateTime"].ToString(); objFlightBal.DepartureAirportCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DepartureAirportCode"].ToString(); objFlightBal.DepartureAirportName = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DepartureAirportName"].ToString(); objFlightBal.DepartureDateTime = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DepartureDateTime"].ToString(); objFlightBal.FlightNumber = dsBookingResponse.Tables["FlightSegment"].Rows[j]["FlightNumber"].ToString(); objFlightBal.MarketingAirlineCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["MarketingAirlineCode"].ToString(); objFlightBal.OperatingAirlineCode = dsBookingResponse.Tables["FlightSegment"].Rows[j]["OperatingAirlineCode"].ToString(); objFlightBal.OperatingAirlineName = dsBookingResponse.Tables["FlightSegment"].Rows[j]["OperatingAirlineName"].ToString(); objFlightBal.OperatingAirlineFlightNumber = dsBookingResponse.Tables["FlightSegment"].Rows[j]["OperatingAirlineFlightNumber"].ToString(); objFlightBal.NumStops = dsBookingResponse.Tables["FlightSegment"].Rows[j]["NumStops"].ToString(); objFlightBal.LinkSellAgrmnt = dsBookingResponse.Tables["FlightSegment"].Rows[j]["LinkSellAgrmnt"].ToString(); objFlightBal.Conx = dsBookingResponse.Tables["FlightSegment"].Rows[j]["Conx"].ToString(); objFlightBal.AirpChg = dsBookingResponse.Tables["FlightSegment"].Rows[j]["AirpChg"].ToString(); objFlightBal.InsideAvailOption = dsBookingResponse.Tables["FlightSegment"].Rows[j]["InsideAvailOption"].ToString(); objFlightBal.GenTrafRestriction = dsBookingResponse.Tables["FlightSegment"].Rows[j]["GenTrafRestriction"].ToString(); objFlightBal.DaysOperates = dsBookingResponse.Tables["FlightSegment"].Rows[j]["DaysOperates"].ToString(); objFlightBal.JrnyTm = dsBookingResponse.Tables["FlightSegment"].Rows[j]["JrnyTm"].ToString(); objFlightBal.EndDt = dsBookingResponse.Tables["FlightSegment"].Rows[j]["EndDt"].ToString(); objFlightBal.StartTerminal = dsBookingResponse.Tables["FlightSegment"].Rows[j]["StartTerminal"].ToString(); objFlightBal.EndTerminal = dsBookingResponse.Tables["FlightSegment"].Rows[j]["EndTerminal"].ToString(); objFlightBal.FltTm = dsBookingResponse.Tables["FlightSegment"].Rows[j]["FltTm"].ToString(); objFlightBal.LSAInd = dsBookingResponse.Tables["FlightSegment"].Rows[j]["LSAInd"].ToString(); objFlightBal.Mile = dsBookingResponse.Tables["FlightSegment"].Rows[j]["Mile"].ToString(); objFlightBal.Availability = dsBookingResponse.Tables["BookingClass"].Rows[j]["Availability"].ToString(); objFlightBal.BIC = dsBookingResponse.Tables["BookingClass"].Rows[j]["BIC"].ToString(); objFlightBal.emailAddress = dsBookingResponse.Tables["email"].Rows[0]["emailAddress"].ToString(); objFlightBal.telephone = dsBookingResponse.Tables["telephone"].Rows[0]["PhoneNumber"].ToString(); objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); string givenName = string.Empty; string surName = string.Empty; string namereference = string.Empty; string psgrType = string.Empty; string customerInfo = string.Empty; string Age = string.Empty; for (int i = 0; i < dsBookingResponse.Tables["CustomerInfo"].Rows.Count; i++) { givenName = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["givenName"].ToString(); surName = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["surName"].ToString(); namereference = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["nameReference"].ToString(); psgrType = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["psgrtype"].ToString(); if (dsBookingResponse.Tables["CustomerInfo"].Columns.Contains("age")) { Age = dsBookingResponse.Tables["CustomerInfo"].Rows[i]["age"].ToString(); if (customerInfo == string.Empty) { customerInfo = namereference + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } else { customerInfo = customerInfo + ";" + namereference + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } } else { Age = "-"; if (customerInfo == string.Empty) { customerInfo = namereference + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } else { customerInfo = customerInfo + ";" + namereference + "|" + givenName + "|" + surName + "|" + psgrType + "|" + Age; } } } objFlightBal.Customer_Details = customerInfo; objFlightBal.bookingClass = dsBookingResponse.Tables["BookingClassFare"].Rows[0]["bookingClass"].ToString(); objFlightBal.ClassType = dsBookingResponse.Tables["BookingClassFare"].Rows[0]["ClassType"].ToString(); objFlightBal.farebasisCode = dsBookingResponse.Tables["BookingClassFare"].Rows[0]["farebasisCode"].ToString(); objFlightBal.Fare_Rule = dsBookingResponse.Tables["BookingClassFare"].Rows[0]["Rule"].ToString(); objFlightBal.PsgrType = dsBookingResponse.Tables["psgr"].Rows[0]["PsgrType"].ToString(); objFlightBal.BaseFare = dsBookingResponse.Tables["psgr"].Rows[0]["BaseFare"].ToString(); objFlightBal.psgrTax = dsBookingResponse.Tables["psgr"].Rows[0]["Tax"].ToString(); objFlightBal.BagInfo = dsBookingResponse.Tables["psgr"].Rows[0]["BagInfo"].ToString(); bool res1 = objFlightBal.AddInternationalFlightSegment(objFlightBal); if (res1) { string[] commPer = Session["CommisionPercentage_Agent"].ToString().Split('.'); DeductAgentBalance(Convert.ToInt32(Session["AgentId_Agent"].ToString()), Convert.ToDouble(Session["DeductAmount_Agent"].ToString()), Convert.ToInt32(Session["UserID"].ToString()), objFlightBal.ReferenceNo.ToString(), Convert.ToDouble(Session["ActualFare_Agent"].ToString()), Convert.ToDouble(Session["CommisionFare_Agent"].ToString()), Convert.ToInt32(commPer[0])); 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; GetIntBookingStatus(objFlightBal.ReferenceNo.ToString()); GetDetailsForPrint(objFlightBal.ReferenceNo.ToString()); } } lbtnmail.Visible = false; pnlIntPassengerDet.Visible = false; lblMsg.Visible = true; lblMsg.Text = "Ticket has been booked successfully. Reference Number is : " + objFlightBal.ReferenceNo.ToString(); lblMsg.ForeColor = System.Drawing.Color.Green; lbtnmail_Click1(sender, e); } } } #endregion }
protected void btnDepositUpdate_Click(object sender, EventArgs e) { try { ClsBAL objBAL = new ClsBAL(); System.Data.DataSet ds1 = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); string balance = ds1.Tables[0].Rows[0]["Balance"].ToString(); if ((Convert.ToDecimal(balance)) > ((Convert.ToDecimal(txtDepositAmount.Text.ToString()) + 25))) { if ((Convert.ToDecimal(txtDepositAmount.Text.ToString()) >= Convert.ToDecimal("1000")) && (Convert.ToDecimal(txtDepositAmount.Text.ToString())) <= Convert.ToDecimal("25000")) { clsMasters _objmasters = new clsMasters(); _objmasters.ScreenInd = Masters.Dmr; _objmasters.Amount1 = (Convert.ToDecimal(txtDepositAmount.Text.ToString())); _objmasters.ExtraCharges = Convert.ToDecimal("25"); _objmasters.Date = txtChequeIssueDate.Text.ToString(); _objmasters.Accountholdername = txtholdername.Text; _objmasters.Accountnumber = txtaccountnumber.Text; _objmasters.IFSCCode = ifsccode.Text; _objmasters.BankName = txtbankname.Text; _objmasters.BranchName = txtbranchname.Text; _objmasters.SenderName = txtsendername.Text; _objmasters.MobileNumber = txtMobileNumber.Text; _objmasters.Status = "No"; _objmasters.CreatedBy = Session["UserID"].ToString(); ClsBAL objBAL1 = new ClsBAL(); System.Data.DataSet ds = objBAL1.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); _objmasters.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["AgentId"].ToString()); if (_objmasters.fnInsertRecord() == true) { lblmsg.Text = "Your request submitted succesfully."; lblmsg.ForeColor = System.Drawing.Color.Green; ClsBAL objBAL2 = new ClsBAL(); System.Data.DataSet ds2 = objBAL2.GetAgentByUserId(Convert.ToInt32(Session["UserID"].ToString())); Session["Balance"] = ds2.Tables[0].Rows[0]["Balance"].ToString(); Label lbl = (Label)this.Master.FindControl("lblBalance"); lbl.Text = Session["Balance"].ToString(); // ClsBAL objBal1 = new ClsBAL(); // string msg = objBal1.DeductAgentDeposit(Convert.ToInt32(Session["UserID"].ToString()) //, Convert.ToDouble(txtDepositAmount.Text.ToString()), "", Convert.ToInt32(Session["UserID"].ToString()) //, "Dmr", "", ""); } } else { lblmsg.Text = "Your transaction amount should be minimum 1000 and maximum 25000."; lblmsg.ForeColor = System.Drawing.Color.Red; } } else { lblmsg.Text = "Your balance should be greater than the transfer amount. "; lblmsg.ForeColor = System.Drawing.Color.Red; } } catch (Exception ex) { lblmsg.Text = ex.Message; lblmsg.ForeColor = System.Drawing.Color.Red; } }