private DataSet GetRoundtripIntBookingRequest() { DataSet dsResponse = new DataSet(); dsIntFlights = (DataSet)Session["dsIntFlights"]; string result = string.Empty; try { #region Variables string str = string.Empty; string FlightSegmentsID = string.Empty; string DepartureAirportCode = string.Empty; string ArrivalDateTime = string.Empty; string DepartureAirportName = string.Empty; string DepartureDateTime = string.Empty; string FlightNumber = string.Empty; string MarketingAirlineCode = string.Empty; string OperatingAirlineCode = string.Empty; string OperatingAirlineName = string.Empty; string OperatingAirlineFlightNumber = string.Empty; string NumStops = string.Empty; string LinkSellAgrmnt = string.Empty; string Conx = string.Empty; string AirpChg = string.Empty; string InsideAvailOption = string.Empty; string GenTrafRestriction = string.Empty; string DaysOperates = string.Empty; string JrnyTm = string.Empty; string EndDt = string.Empty; string StartTerminal = string.Empty; string EndTerminal = string.Empty; string FltTm = string.Empty; string LSAInd = string.Empty; string Mile = string.Empty; string Availability = string.Empty; string BIC = string.Empty; string bookingclass = string.Empty; string classType = string.Empty; string farebasiscode = string.Empty; string Rule = string.Empty; string PsgrType = string.Empty; string BaseFare = string.Empty; string Tax = string.Empty; string BagInfo = string.Empty; string AirEquipType = string.Empty; string ArrivalAirportCode = string.Empty; string ArrivalAirportName = string.Empty; string return1 = string.Empty; string id = string.Empty; string key = string.Empty; string ActualBaseFare = string.Empty; string FareTax = string.Empty; string STax = string.Empty; string TCharge = string.Empty; string SCharge = string.Empty; string TDiscount = string.Empty; string TMarkup = string.Empty; string TPartnerCommission = string.Empty; string TSdiscount = string.Empty; string FarePsgrType = string.Empty; string FareBaseFare = string.Empty; string FareTax1 = string.Empty; string Country = string.Empty; string Amt = string.Empty; string ocTax = string.Empty; string onwardId = string.Empty; string OriginDestinationOption_Id = string.Empty; string FareDetails_id = string.Empty; string FareBreakUp_Id = string.Empty; string FareAry_id = string.Empty; string FareId = string.Empty; string bookingclassFareId = string.Empty; string psgrBreakUp_Id = string.Empty; string psgrAy_id = string.Empty; string country = string.Empty; string taxAmt = string.Empty; string taxData = string.Empty; string taxDataAry_id = string.Empty; string returnId = string.Empty; string FlightSegmentsIDRet = string.Empty; string DepartureAirportCodeRet = string.Empty; string ArrivalDateTimeRet = string.Empty; string DepartureAirportNameRet = string.Empty; string DepartureDateTimeRet = string.Empty; string FlightNumberRet = string.Empty; string MarketingAirlineCodeRet = string.Empty; string OperatingAirlineCodeRet = string.Empty; string OperatingAirlineNameRet = string.Empty; string OperatingAirlineFlightNumberRet = string.Empty; string NumStopsRet = string.Empty; string LinkSellAgrmntRet = string.Empty; string ConxRet = string.Empty; string AirpChgRet = string.Empty; string InsideAvailOptionRet = string.Empty; string GenTrafRestrictionRet = string.Empty; string DaysOperatesRet = string.Empty; string JrnyTmRet = string.Empty; string EndDtRet = string.Empty; string StartTerminalRet = string.Empty; string EndTerminalRet = string.Empty; string FltTmRet = string.Empty; string LSAIndRet = string.Empty; string MileRet = string.Empty; string AvailabilityRet = string.Empty; string BICRet = string.Empty; string bookingclassRet = string.Empty; string classTypeRet = string.Empty; string farebasiscodeRet = string.Empty; string RuleRet = string.Empty; string PsgrTypeRet = string.Empty; string BaseFareRet = string.Empty; string TaxRet = string.Empty; string BagInfoRet = string.Empty; string AirEquipTypeRet = string.Empty; string ArrivalAirportCodeRet = string.Empty; string ArrivalAirportNameRet = string.Empty; string idRet = string.Empty; string keyRet = string.Empty; string ActualBaseFareRet = string.Empty; string FareTaxRet = string.Empty; string STaxRet = string.Empty; string TChargeRet = string.Empty; string SChargeRet = string.Empty; string TDiscountRet = string.Empty; string TMarkupRet = string.Empty; string TPartnerCommissionRet = string.Empty; string TSdiscountRet = string.Empty; string FarePsgrTypeRet = string.Empty; string FareBaseFareRet = string.Empty; string FareTax1Ret = string.Empty; string CountryRet = string.Empty; string AmtRet = string.Empty; string ocTaxRet = string.Empty; string onwardIdRet = string.Empty; string OriginDestinationOption_IdRet = string.Empty; string FareDetails_idRet = string.Empty; string FareBreakUp_IdRet = string.Empty; string FareAry_idRet = string.Empty; string FareIdRet = string.Empty; string bookingclassFareIdRet = string.Empty; string psgrBreakUp_IdRet = string.Empty; string psgrAy_idRet = string.Empty; string countryRet = string.Empty; string taxAmtRet = string.Empty; string taxDataRet = string.Empty; string taxDataAry_idRet = string.Empty; string returnIdRet = string.Empty; string taxdatapsgr = string.Empty; string taxdatapsgrRet = string.Empty; #endregion #region Pricing DataTable dtPricingreqOriginDestinationOption = dsIntFlights.Tables["OriginDestinationOption"]; if (dtPricingreqOriginDestinationOption.Rows.Count > 0) { DataRow[] rowOriginDestinationOption = dtPricingreqOriginDestinationOption.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); id = rowOriginDestinationOption[0]["id"].ToString(); key = rowOriginDestinationOption[0]["key"].ToString(); } //Get Details From roundtrip response DataTable dtPricingreqFareDetails = dsIntFlights.Tables["FareDetails"]; if (dtPricingreqFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtPricingreqFareDetails.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } DataTable dtPricingreqFareBreakUp = dsIntFlights.Tables["FareBreakUp"]; if (dtPricingreqFareBreakUp.Rows.Count > 0) { DataRow[] rowFareBreakUp = dtPricingreqFareBreakUp.Select("FareDetails_Id=" + FareDetails_id); FareBreakUp_Id = rowFareBreakUp[0]["FareBreakUp_Id"].ToString(); } DataTable dtPricingreqFareAry = dsIntFlights.Tables["FareAry"]; if (dtPricingreqFareAry.Rows.Count > 0) { DataRow[] rowFareAry = dtPricingreqFareAry.Select("FareBreakUp_Id=" + FareBreakUp_Id); FareAry_id = rowFareAry[0]["FareAry_id"].ToString(); } DataTable dtPricingreqFare = dsIntFlights.Tables["Fare"]; if (dtPricingreqFare.Rows.Count > 0) { DataRow[] rowFare = dtPricingreqFare.Select("FareAry_id=" + FareAry_id); PsgrType = rowFare[0]["PsgrType"].ToString(); BaseFare = rowFare[0]["BaseFare"].ToString(); FareTax = rowFare[0]["Tax"].ToString(); FareId = rowFare[0]["Fare_Id"].ToString(); } if (dtPricingreqFare.Rows.Count > 0) { DataRow[] rowFare = dtPricingreqFare.Select("FareAry_id=" + FareAry_id); foreach (DataRow row in rowFare) { if (row.Table.Rows.Count == 0) { str = "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax></Fare>"; } else { str = str + "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax></Fare>";//<TaxDataAry>" + str + "</TaxDataAry> } } } FlightBAL objFlightsBal = new FlightBAL(); string xmlpricingrequestforInt = "<PriceRequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>" + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>";//<Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax></Fare> xmlpricingrequestforInt = xmlpricingrequestforInt + "<onward><FlightSegments>"; DataTable dtpricingreqOnward = dsIntFlights.Tables["Onward"]; if (dtpricingreqOnward.Rows.Count > 0) { DataRow[] rowOnward = dtpricingreqOnward.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); onwardId = rowOnward[0]["onward_id"].ToString(); } DataTable dtpricingreqFlightSegments = dsIntFlights.Tables["FlightSegments"]; if (dtpricingreqFlightSegments.Rows.Count > 0) { DataRow[] rowFlightSegments = dtpricingreqFlightSegments.Select("onward_id=" + onwardId); FlightSegmentsID = rowFlightSegments[0]["FlightSegments_Id"].ToString(); } DataTable dtpricingreqFlightSegment = dsIntFlights.Tables["FlightSegment"]; DataTable dtpricingreqBookingClass = dsIntFlights.Tables["BookingClass"]; DataTable dtpricingreqBookingClassFare = dsIntFlights.Tables["BookingClassFare"]; DataTable dtpricingreqPsgrBreakUp = dsIntFlights.Tables["PsgrBreakUp"]; DataTable dtpricingreqPsgrAry = dsIntFlights.Tables["PsgrAry"]; DataTable dtpricingreqPsgr = dsIntFlights.Tables["Psgr"]; DataTable dtpricingreqTaxDataAry = dsIntFlights.Tables["TaxDataAry"]; DataTable dtpricingreqTaxData = dsIntFlights.Tables["TaxData"]; if (dtpricingreqFlightSegment.Rows.Count > 0) { DataRow[] rowFlightSegment = dtpricingreqFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); for (int i = 0; i < rowFlightSegment.Length; i++) { AirEquipType = rowFlightSegment[i]["AirEquipType"].ToString(); ArrivalAirportCode = rowFlightSegment[i]["ArrivalAirportCode"].ToString(); ArrivalAirportName = rowFlightSegment[i]["ArrivalAirportName"].ToString(); ArrivalDateTime = rowFlightSegment[i]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFlightSegment[i]["DepartureAirportCode"].ToString(); DepartureAirportName = rowFlightSegment[i]["DepartureAirportName"].ToString(); DepartureDateTime = rowFlightSegment[i]["DepartureDateTime"].ToString(); FlightNumber = rowFlightSegment[i]["FlightNumber"].ToString(); MarketingAirlineCode = rowFlightSegment[i]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = rowFlightSegment[i]["OperatingAirlineCode"].ToString(); OperatingAirlineName = rowFlightSegment[i]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = rowFlightSegment[i]["OperatingAirlineFlightNumber"].ToString(); NumStops = rowFlightSegment[i]["NumStops"].ToString(); LinkSellAgrmnt = rowFlightSegment[i]["LinkSellAgrmnt"].ToString(); Conx = rowFlightSegment[i]["Conx"].ToString(); AirpChg = rowFlightSegment[i]["AirpChg"].ToString(); InsideAvailOption = rowFlightSegment[i]["InsideAvailOption"].ToString(); GenTrafRestriction = rowFlightSegment[i]["GenTrafRestriction"].ToString(); DaysOperates = rowFlightSegment[i]["DaysOperates"].ToString(); JrnyTm = rowFlightSegment[i]["JrnyTm"].ToString(); EndDt = rowFlightSegment[i]["EndDt"].ToString(); StartTerminal = rowFlightSegment[i]["StartTerminal"].ToString(); EndTerminal = rowFlightSegment[i]["EndTerminal"].ToString(); FltTm = rowFlightSegment[i]["FltTm"].ToString(); LSAInd = rowFlightSegment[i]["LSAInd"].ToString(); Mile = rowFlightSegment[i]["Mile"].ToString(); if (dtpricingreqBookingClass.Rows.Count > 0) { DataRow[] rowBookingClass = dtpricingreqBookingClass.Select("FlightSegment_Id=" + rowFlightSegment[i]["FlightSegment_Id"].ToString()); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } if (dtpricingreqBookingClassFare.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtpricingreqBookingClassFare.Select("FlightSegment_Id=" + rowFlightSegment[i]["FlightSegment_Id"].ToString()); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); if (dtpricingreqBookingClassFare.Columns.Contains("bookingclassFare_Id")) { bookingclassFareId = rowBookingClassFare[0]["bookingclassFare_Id"].ToString(); } } if (dtpricingreqBookingClassFare.Columns.Contains("bookingclassFare_Id")) { if (dtpricingreqPsgrBreakUp.Rows.Count > 0) { DataRow[] rowPsgrBreakUp = dtpricingreqPsgrBreakUp.Select("bookingclassFare_Id=" + bookingclassFareId); psgrBreakUp_Id = rowPsgrBreakUp[0]["psgrBreakUp_Id"].ToString(); } if (dtpricingreqPsgrAry.Rows.Count > 0) { DataRow[] rowPsgrAry = dtpricingreqPsgrAry.Select("psgrBreakUp_Id=" + psgrBreakUp_Id); psgrAy_id = rowPsgrAry[0]["psgrAry_Id"].ToString(); } if (dtpricingreqPsgr.Rows.Count > 0) { DataRow[] rowPsgr = dtpricingreqPsgr.Select("psgrAry_Id=" + psgrAy_id); FarePsgrType = rowPsgr[0]["psgrType"].ToString(); FareBaseFare = rowPsgr[0]["BaseFare"].ToString(); FareTax1 = rowPsgr[0]["Tax"].ToString(); BagInfo = rowPsgr[0]["BagInfo"].ToString(); } if (dtpricingreqPsgr.Rows.Count > 0) { DataRow[] rowPsgr = dtpricingreqPsgr.Select("psgrAry_Id=" + psgrAy_id); foreach (DataRow rows in rowPsgr) { if (rows.Table.Rows.Count == 0) { taxdatapsgr = "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; } else { taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; } } } } if (dtpricingreqTaxDataAry.Rows.Count > 0) { DataRow[] rowTaxDataAry = dtpricingreqTaxDataAry.Select("Fare_id=" + FareId); taxDataAry_id = rowTaxDataAry[0]["TaxdataAry_Id"].ToString(); } if (dtpricingreqTaxData.Rows.Count > 0) { DataRow[] rowTaxData = dtpricingreqTaxData.Select("TaxdataAry_Id=" + taxDataAry_id); for (int j = 0; j < rowTaxData.Length; j++) { if (rowTaxData.Length == 0) { taxData = "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; } else { taxData = taxData + "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; } } } xmlpricingrequestforInt = xmlpricingrequestforInt + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtpricingreqBookingClassFare.Columns.Contains("bookingclassFare_Id")) { xmlpricingrequestforInt = xmlpricingrequestforInt + "<PsgrBreakup><PsgrAry>" + taxdatapsgr + "</PsgrAry></PsgrBreakup>"; } xmlpricingrequestforInt = xmlpricingrequestforInt + "</BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr> } } xmlpricingrequestforInt = xmlpricingrequestforInt + "</FlightSegments></onward><Return><FlightSegments>"; DataTable dtpricingreqReturn = dsIntFlights.Tables["Return"]; if (dtpricingreqReturn.Rows.Count > 0) { DataRow[] rowReturn = dtpricingreqReturn.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); returnId = rowReturn[0]["return_id"].ToString(); } DataTable dtpricingreqFlightSegmentsRet = dsIntFlights.Tables["FlightSegments"]; if (dtpricingreqFlightSegmentsRet.Rows.Count > 0) { DataRow[] rowFlightSegmentsRet = dtpricingreqFlightSegmentsRet.Select("return_id=" + returnId); FlightSegmentsIDRet = rowFlightSegmentsRet[0]["FlightSegments_Id"].ToString(); } DataTable dtpricingreqFlightSegmentRet = dsIntFlights.Tables["FlightSegment"]; DataTable dtpricingreqBookingClassRet = dsIntFlights.Tables["BookingClass"]; DataTable dtpricingreqBookingClassFareRet = dsIntFlights.Tables["BookingClassFare"]; DataTable dtpricingreqPsgrBreakUpRet = dsIntFlights.Tables["PsgrBreakUp"]; DataTable dtpricingreqPsgrAryRet = dsIntFlights.Tables["PsgrAry"]; DataTable dtpricingreqPsgrRet = dsIntFlights.Tables["Psgr"]; DataTable dtpricingreqTaxDataAryRet = dsIntFlights.Tables["TaxDataAry"]; DataTable dtpricingreqTaxDataRet = dsIntFlights.Tables["TaxData"]; if (dtpricingreqFlightSegmentRet.Rows.Count > 0) { DataRow[] rowFlightSegmentRet = dtpricingreqFlightSegmentRet.Select("FlightSegments_Id=" + FlightSegmentsIDRet); for (int i = 0; i < rowFlightSegmentRet.Length; i++) { AirEquipTypeRet = rowFlightSegmentRet[i]["AirEquipType"].ToString(); ArrivalAirportCodeRet = rowFlightSegmentRet[i]["ArrivalAirportCode"].ToString(); ArrivalAirportNameRet = rowFlightSegmentRet[i]["ArrivalAirportName"].ToString(); ArrivalDateTimeRet = rowFlightSegmentRet[i]["ArrivalDateTime"].ToString(); DepartureAirportCodeRet = rowFlightSegmentRet[i]["DepartureAirportCode"].ToString(); DepartureAirportNameRet = rowFlightSegmentRet[i]["DepartureAirportName"].ToString(); DepartureDateTimeRet = rowFlightSegmentRet[i]["DepartureDateTime"].ToString(); FlightNumberRet = rowFlightSegmentRet[i]["FlightNumber"].ToString(); MarketingAirlineCodeRet = rowFlightSegmentRet[i]["MarketingAirlineCode"].ToString(); OperatingAirlineCodeRet = rowFlightSegmentRet[i]["OperatingAirlineCode"].ToString(); OperatingAirlineNameRet = rowFlightSegmentRet[i]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumberRet = rowFlightSegmentRet[i]["OperatingAirlineFlightNumber"].ToString(); NumStopsRet = rowFlightSegmentRet[i]["NumStops"].ToString(); LinkSellAgrmntRet = rowFlightSegmentRet[i]["LinkSellAgrmnt"].ToString(); ConxRet = rowFlightSegmentRet[i]["Conx"].ToString(); AirpChgRet = rowFlightSegmentRet[i]["AirpChg"].ToString(); InsideAvailOptionRet = rowFlightSegmentRet[i]["InsideAvailOption"].ToString(); GenTrafRestrictionRet = rowFlightSegmentRet[i]["GenTrafRestriction"].ToString(); DaysOperatesRet = rowFlightSegmentRet[i]["DaysOperates"].ToString(); JrnyTmRet = rowFlightSegmentRet[i]["JrnyTm"].ToString(); EndDtRet = rowFlightSegmentRet[i]["EndDt"].ToString(); StartTerminalRet = rowFlightSegmentRet[i]["StartTerminal"].ToString(); EndTerminalRet = rowFlightSegmentRet[i]["EndTerminal"].ToString(); FltTmRet = rowFlightSegmentRet[i]["FltTm"].ToString(); LSAIndRet = rowFlightSegmentRet[i]["LSAInd"].ToString(); MileRet = rowFlightSegmentRet[i]["Mile"].ToString(); if (dtpricingreqBookingClassRet.Rows.Count > 0) { DataRow[] rowBookingClassRet = dtpricingreqBookingClassRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); AvailabilityRet = rowBookingClassRet[0]["Availability"].ToString(); BICRet = rowBookingClassRet[0]["BIC"].ToString(); } if (dtpricingreqBookingClassFareRet.Rows.Count > 0) { DataRow[] rowBookingClassFareRet = dtpricingreqBookingClassFareRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); bookingclassRet = rowBookingClassFareRet[0]["bookingclass"].ToString(); classTypeRet = rowBookingClassFareRet[0]["classType"].ToString(); farebasiscodeRet = rowBookingClassFareRet[0]["farebasiscode"].ToString(); RuleRet = rowBookingClassFareRet[0]["Rule"].ToString(); if (dtpricingreqBookingClassFareRet.Columns.Contains("bookingclassFare_Id")) { bookingclassFareIdRet = rowBookingClassFareRet[0]["bookingclassFare_Id"].ToString(); } } if (dtpricingreqBookingClassFareRet.Columns.Contains("bookingclassFare_Id")) { if (dtpricingreqPsgrBreakUpRet.Rows.Count > 0) { DataRow[] rowPsgrBreakUpRet = dtpricingreqPsgrBreakUpRet.Select("bookingclassFare_Id=" + bookingclassFareIdRet); psgrBreakUp_IdRet = rowPsgrBreakUpRet[0]["psgrBreakUp_Id"].ToString(); } if (dtpricingreqPsgrAryRet.Rows.Count > 0) { DataRow[] rowPsgrAryRet = dtpricingreqPsgrAryRet.Select("psgrBreakUp_Id=" + psgrBreakUp_IdRet); psgrAy_idRet = rowPsgrAryRet[0]["psgrAry_Id"].ToString(); } if (dtpricingreqPsgrRet.Rows.Count > 0) { DataRow[] rowPsgrRet = dtpricingreqPsgrRet.Select("psgrAry_Id=" + psgrAy_idRet); FarePsgrTypeRet = rowPsgrRet[0]["psgrType"].ToString(); FareBaseFareRet = rowPsgrRet[0]["BaseFare"].ToString(); FareTax1Ret = rowPsgrRet[0]["Tax"].ToString(); BagInfoRet = rowPsgrRet[0]["BagInfo"].ToString(); } if (dtpricingreqPsgrRet.Rows.Count > 0) { DataRow[] rowPsgr = dtpricingreqPsgrRet.Select("psgrAry_Id=" + psgrAy_idRet); foreach (DataRow rows in rowPsgr) { if (rows.Table.Rows.Count == 0) { taxdatapsgrRet = "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; } else { taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; } } } } //if (dtTaxDataAryRet.Rows.Count > 0) //{ // DataRow[] rowTaxDataAryRet = dtTaxDataAryRet.Select("Fare_id=" + FareIdRet); // taxDataAry_id = rowTaxDataAryRet[0]["TaxdataAry_Id"].ToString(); //} //if (dtTaxDataRet.Rows.Count > 0) //{ // DataRow[] rowTaxDataRet = dtTaxDataRet.Select("TaxdataAry_Id=" + taxDataAry_idRet); // for (int j = 0; j < rowTaxDataRet.Length; j++) // { // if (rowTaxDataRet.Length == 0) // { // taxDataRet = "<TaxData><Country>" + rowTaxDataRet[j]["Country"].ToString() + "</Country><Amt>" + rowTaxDataRet[j]["Amt"].ToString() + "</Amt></TaxData>"; // } // else // { // taxDataRet = taxDataRet + "<TaxData><Country>" + rowTaxDataRet[j]["Country"].ToString() + "</Country><Amt>" + rowTaxDataRet[j]["Amt"].ToString() + "</Amt></TaxData>"; // } // } //} xmlpricingrequestforInt = xmlpricingrequestforInt + "<FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportNameRet + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportNameRet + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<MarketingAirlineCode>" + MarketingAirlineCodeRet + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineNameRet + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><NumStops>" + NumStopsRet + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmntRet + "</LinkSellAgrmnt><Conx>" + ConxRet + "</Conx><AirpChg>" + AirpChgRet + "</AirpChg><InsideAvailOption>" + InsideAvailOptionRet + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestrictionRet + "</GenTrafRestriction><DaysOperates>" + DaysOperatesRet + "</DaysOperates><JrnyTm>" + JrnyTmRet + "</JrnyTm><EndDt>" + EndDtRet + "</EndDt><StartTerminal>" + StartTerminalRet + "</StartTerminal><EndTerminal>" + EndTerminalRet + "</EndTerminal>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<FltTm>" + FltTmRet + "</FltTm><LSAInd>" + LSAIndRet + "</LSAInd><Mile>" + MileRet + "</Mile><BookingClass><Availability>" + AvailabilityRet + "</Availability><BIC>" + BICRet + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclassRet + "</bookingclass><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><Rule>" + RuleRet.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtpricingreqBookingClassFareRet.Columns.Contains("bookingclassFare_Id")) { xmlpricingrequestforInt = xmlpricingrequestforInt + "<PsgrBreakup><PsgrAry>" + taxdatapsgrRet + "</PsgrAry></PsgrBreakup>"; } xmlpricingrequestforInt = xmlpricingrequestforInt + "</BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrTypeRet + "</PsgrType><BaseFare>" + FareBaseFareRet + "</BaseFare><Tax>" + FareTax1Ret + "</Tax><BagInfo></BagInfo></Psgr> } } xmlpricingrequestforInt = xmlpricingrequestforInt + "</FlightSegments></Return><id>" + id + "</id><key>" + key + "</key>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "</OriginDestinationOption></PriceRequest>"; // <FlightSegment><AirEquipType>744</AirEquipType><ArrivalAirportCode>LHR</ArrivalAirportCode><ArrivalAirportName>LONDON<BR> (HEATHROW)</ArrivalAirportName><ArrivalDateTime>2010-02-24T06:55:00</ArrivalDateTime><DepartureAirportCode>BOM</DepartureAirportCode><DepartureAirportName>MUMBAI<BR>(CHHATRAPATI SHIVAJI INTERNATIONAL)</DepartureAirportName><DepartureDateTime>2010-02-24T02:45:00</DepartureDateTime><FlightNumber>138</FlightNumber><MarketingAirlineCode>BA</MarketingAirlineCode><OperatingAirlineCode>BA</OperatingAirlineCode><OperatingAirlineName>British Airways </OperatingAirlineName><OperatingAirlineFlightNumber>138</OperatingAirlineFlightNumber><NumStops>0</NumStops>" + // "<LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>9</Availability><BIC>N</BIC></BookingClass><BookingClassFare><bookingclass>N</bookingclass><classType>Economy</classType><farebasiscode>NLRCAS|RP|V-BA|BOM-JFK</farebasiscode><Rule></Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>32000</BaseFare><Tax>21675</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment><FlightSegment>" + // "<AirEquipType>777</AirEquipType><ArrivalAirportCode>JFK</ArrivalAirportCode><ArrivalAirportName>NEW YORK<BR>(JOHN F KENNEDY INTL)</ArrivalAirportName><ArrivalDateTime>2010-02-24T13:55:00</ArrivalDateTime><DepartureAirportCode>LHR</DepartureAirportCode><DepartureAirportName>LONDON<BR> (HEATHROW)</DepartureAirportName><DepartureDateTime>2010-02-24T11:00:00</DepartureDateTime><FlightNumber>175</FlightNumber><MarketingAirlineCode>BA</MarketingAirlineCode><OperatingAirlineCode>BA</OperatingAirlineCode><OperatingAirlineName>British Airways </OperatingAirlineName><OperatingAirlineFlightNumber>175</OperatingAirlineFlightNumber><NumStops>0</NumStops>" + // "<LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>9</Availability><BIC>N</BIC></BookingClass><BookingClassFare><bookingclass>N</bookingclass><classType>Economy</classType><farebasiscode>NLRCAS|RP|V-BA|BOM-JFK</farebasiscode><Rule></Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>32000</BaseFare><Tax>21675</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment></FlightSegments></onward>" + // "<Return><FlightSegments><FlightSegment><AirEquipType>777</AirEquipType><ArrivalAirportCode>LHR</ArrivalAirportCode><ArrivalAirportName>LONDON<BR> (HEATHROW)</ArrivalAirportName><ArrivalDateTime>2010-02-26T07:50:00</ArrivalDateTime><DepartureAirportCode>JFK</DepartureAirportCode><DepartureAirportName>NEW YORK<BR>(JOHN F KENNEDY INTL)</DepartureAirportName><DepartureDateTime>2010-02-25T19:40:00</DepartureDateTime><FlightNumber>176</FlightNumber> //<MarketingAirlineCode>BA</MarketingAirlineCode><OperatingAirlineCode>BA</OperatingAirlineCode>" + // " <OperatingAirlineName>British Airways </OperatingAirlineName><OperatingAirlineFlightNumber>176</OperatingAirlineFlightNumber> //<NumStops>0</NumStops><LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>9</Availability><BIC>N</BIC></BookingClass><BookingClassFare><bookingclass>N</bookingclass><classType>Economy</classType><farebasiscode>NLRCAS|RP|V-BA|JFK-BOM</farebasiscode>" + // "<Rule></Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>32000</BaseFare><Tax>21675</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment><FlightSegment><AirEquipType>744</AirEquipType><ArrivalAirportCode>BOM</ArrivalAirportCode><ArrivalAirportName>MUMBAI<BR>(CHHATRAPATI SHIVAJI INTERNATIONAL)</ArrivalAirportName><ArrivalDateTime>2010-02-27T00:45:00</ArrivalDateTime><DepartureAirportCode>LHR</DepartureAirportCode><DepartureAirportName>LONDON<BR>(HEATHROW)</DepartureAirportName><DepartureDateTime>2010-02-26T10:30:00</DepartureDateTime><FlightNumber>139</FlightNumber><MarketingAirlineCode>BA</MarketingAirlineCode><OperatingAirlineCode>BA</OperatingAirlineCode>" + // " <OperatingAirlineName>British Airways </OperatingAirlineName><OperatingAirlineFlightNumber>139</OperatingAirlineFlightNumber><NumStops>0</NumStops><LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>9</Availability><BIC>N</BIC></BookingClass><BookingClassFare><bookingclass>N</bookingclass><classType>Economy</classType><farebasiscode>NLRCAS|RP|V-BA|JFK-BOM</farebasiscode><Rule></Rule>" + //" <PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>32000</BaseFare><Tax>21675</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment></FlightSegments></Return><id>arzoo35</id><key>pG4C0YQykzzTREhDdDdZxah4nJ/Bta4FgUl36m3L9/Vn4uu9m7LCssMPJ4Xz20E7cCU/hS9xGEdUAkpDcwlKw=</key></OriginDestinationOption></PriceRequest>"; DataSet dsPricingResponse = objFlightsBal.GetDatasetFromAPI(xmlpricingrequestforInt, "http://live.arzoo.com:9302/Pricing"); if (!dsPricingResponse.Tables[0].Columns.Contains("error")) { DataTable dtpricingresFareDetails = dsPricingResponse.Tables["FareDetails"]; if (dtpricingresFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtpricingresFareDetails.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } } #endregion string ref1 = Common.GetFlightsReferenceNo("LJIF"); string xmlRequest = "<Bookingrequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><creditcardno></creditcardno><PartnerreferenceID>" + ref1 + "</PartnerreferenceID>"; xmlRequest = xmlRequest + "<personName>"; // Dynamic generation of names of adults, infants , Child Table tbladults = (Table)this.UpdatePanel2.FindControl("tblAdultsInt"); for (int i = 1; i <= Convert.ToInt32(Session["adultCntInt"]); i++) { TextBox txtFn = (TextBox)tbladults.FindControl("txtFnInt" + i); TextBox txtLn = (TextBox)tbladults.FindControl("txtLnInt" + i); DropDownList ddlTitle = (DropDownList)tbladults.FindControl("ddlTitleInt" + i); xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } Table tblChild = (Table)this.UpdatePanel2.FindControl("tblChildInt"); for (int i = 1; i <= Convert.ToInt32(Session["childCntInt"]); i++) { TextBox txtFn = (TextBox)tblChild.FindControl("txtCFnInt" + i); TextBox txtLn = (TextBox)tblChild.FindControl("txtCLnInt" + i); DropDownList ddlTitle = (DropDownList)tblChild.FindControl("ddlCTitleInt" + i); TextBox txtBirthDate = (TextBox)tblChild.FindControl("txtCBirthDateInt" + i); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); //if (Convert.ToInt32(age) > 5) //{ // Literal lit = new Literal(); // lit.Text = "age is null"; // this.Page.Controls.Add(lit); // break; //} 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 tblInfants = (Table)this.UpdatePanel2.FindControl("tblInfantsInt"); for (int i = 1; i <= Convert.ToInt32(Session["infantCntInt"]); i++) { TextBox txtFn = (TextBox)tblInfants.FindControl("txtIFnInt" + i); TextBox txtLn = (TextBox)tblInfants.FindControl("txtILnInt" + i); DropDownList ddlTitle = (DropDownList)tblInfants.FindControl("ddlITitleInt" + i); TextBox txtBirthDate = (TextBox)tblInfants.FindControl("txtIBirthDateInt" + i); string age = string.Empty; if (txtBirthDate != null) age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); else age = "0"; 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>"; } DataTable dtOriginDestinationOption = dsIntFlights.Tables["OriginDestinationOption"]; if (dtOriginDestinationOption.Rows.Count > 0) { DataRow[] rowOriginDestinationOption = dtOriginDestinationOption.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); id = rowOriginDestinationOption[0]["id"].ToString(); key = rowOriginDestinationOption[0]["key"].ToString(); } //Get Details From roundtrip response DataTable dtFareDetails = dsIntFlights.Tables["FareDetails"]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } DataTable dtFareBreakUp = dsIntFlights.Tables["FareBreakUp"]; if (dtFareBreakUp.Rows.Count > 0) { DataRow[] rowFareBreakUp = dtFareBreakUp.Select("FareDetails_Id=" + FareDetails_id); FareBreakUp_Id = rowFareBreakUp[0]["FareBreakUp_Id"].ToString(); } DataTable dtFareAry = dsIntFlights.Tables["FareAry"]; if (dtFareAry.Rows.Count > 0) { DataRow[] rowFareAry = dtFareAry.Select("FareBreakUp_Id=" + FareBreakUp_Id); FareAry_id = rowFareAry[0]["FareAry_id"].ToString(); } DataTable dtFare = dsIntFlights.Tables["Fare"]; if (dtFare.Rows.Count > 0) { DataRow[] rowFare = dtFare.Select("FareAry_id=" + FareAry_id); PsgrType = rowFare[0]["PsgrType"].ToString(); BaseFare = rowFare[0]["BaseFare"].ToString(); FareTax = rowFare[0]["Tax"].ToString(); FareId = rowFare[0]["Fare_Id"].ToString(); } xmlRequest = xmlRequest + "</personName><telePhone><phoneNumber>" + txtMobileNumInt.Text + "</phoneNumber></telePhone><email><emailAddress>" + txtEmailIDInt.Text + "</emailAddress></email>"; xmlRequest = xmlRequest + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>";//<Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax> xmlRequest = xmlRequest + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails><onward><FlightSegments>"; DataTable dtOnward = dsIntFlights.Tables["Onward"]; if (dtOnward.Rows.Count > 0) { DataRow[] rowOnward = dtOnward.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); onwardId = rowOnward[0]["onward_id"].ToString(); } DataTable dtFlightSegments = dsIntFlights.Tables["FlightSegments"]; if (dtFlightSegments.Rows.Count > 0) { DataRow[] rowFlightSegments = dtFlightSegments.Select("onward_id=" + onwardId); FlightSegmentsID = rowFlightSegments[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegment = dsIntFlights.Tables["FlightSegment"]; DataTable dtBookingClass = dsIntFlights.Tables["BookingClass"]; DataTable dtBookingClassFare = dsIntFlights.Tables["BookingClassFare"]; DataTable dtPsgrBreakUp = dsIntFlights.Tables["PsgrBreakUp"]; DataTable dtPsgrAry = dsIntFlights.Tables["PsgrAry"]; DataTable dtPsgr = dsIntFlights.Tables["Psgr"]; DataTable dtTaxDataAry = dsIntFlights.Tables["TaxDataAry"]; DataTable dtTaxData = dsIntFlights.Tables["TaxData"]; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFlightSegment = dtFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); for (int i = 0; i < rowFlightSegment.Length; i++) { AirEquipType = rowFlightSegment[i]["AirEquipType"].ToString(); ArrivalAirportCode = rowFlightSegment[i]["ArrivalAirportCode"].ToString(); ArrivalAirportName = rowFlightSegment[i]["ArrivalAirportName"].ToString(); ArrivalDateTime = rowFlightSegment[i]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFlightSegment[i]["DepartureAirportCode"].ToString(); DepartureAirportName = rowFlightSegment[i]["DepartureAirportName"].ToString(); DepartureDateTime = rowFlightSegment[i]["DepartureDateTime"].ToString(); FlightNumber = rowFlightSegment[i]["FlightNumber"].ToString(); MarketingAirlineCode = rowFlightSegment[i]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = rowFlightSegment[i]["OperatingAirlineCode"].ToString(); OperatingAirlineName = rowFlightSegment[i]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = rowFlightSegment[i]["OperatingAirlineFlightNumber"].ToString(); NumStops = rowFlightSegment[i]["NumStops"].ToString(); LinkSellAgrmnt = rowFlightSegment[i]["LinkSellAgrmnt"].ToString(); Conx = rowFlightSegment[i]["Conx"].ToString(); AirpChg = rowFlightSegment[i]["AirpChg"].ToString(); InsideAvailOption = rowFlightSegment[i]["InsideAvailOption"].ToString(); GenTrafRestriction = rowFlightSegment[i]["GenTrafRestriction"].ToString(); DaysOperates = rowFlightSegment[i]["DaysOperates"].ToString(); JrnyTm = rowFlightSegment[i]["JrnyTm"].ToString(); EndDt = rowFlightSegment[i]["EndDt"].ToString(); StartTerminal = rowFlightSegment[i]["StartTerminal"].ToString(); EndTerminal = rowFlightSegment[i]["EndTerminal"].ToString(); FltTm = rowFlightSegment[i]["FltTm"].ToString(); LSAInd = rowFlightSegment[i]["LSAInd"].ToString(); Mile = rowFlightSegment[i]["Mile"].ToString(); if (dtBookingClass.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass.Select("FlightSegment_Id=" + rowFlightSegment[i]["FlightSegment_Id"].ToString()); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } if (dtBookingClassFare.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare.Select("FlightSegment_Id=" + rowFlightSegment[i]["FlightSegment_Id"].ToString()); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { bookingclassFareId = rowBookingClassFare[0]["bookingclassFare_Id"].ToString(); } } if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { if (dtPsgrBreakUp.Rows.Count > 0) { DataRow[] rowPsgrBreakUp = dtPsgrBreakUp.Select("bookingclassFare_Id=" + bookingclassFareId); psgrBreakUp_Id = rowPsgrBreakUp[0]["psgrBreakUp_Id"].ToString(); } if (dtPsgrAry.Rows.Count > 0) { DataRow[] rowPsgrAry = dtPsgrAry.Select("psgrBreakUp_Id=" + psgrBreakUp_Id); psgrAy_id = rowPsgrAry[0]["psgrAry_Id"].ToString(); } if (dtPsgr.Rows.Count > 0) { DataRow[] rowPsgr = dtPsgr.Select("psgrAry_Id=" + psgrAy_id); FarePsgrType = rowPsgr[0]["psgrType"].ToString(); FareBaseFare = rowPsgr[0]["BaseFare"].ToString(); FareTax1 = rowPsgr[0]["Tax"].ToString(); BagInfo = rowPsgr[0]["BagInfo"].ToString(); } } if (dtTaxDataAry.Rows.Count > 0) { DataRow[] rowTaxDataAry = dtTaxDataAry.Select("Fare_id=" + FareId); taxDataAry_id = rowTaxDataAry[0]["TaxdataAry_Id"].ToString(); } if (dtTaxData.Rows.Count > 0) { DataRow[] rowTaxData = dtTaxData.Select("TaxdataAry_Id=" + taxDataAry_id); for (int j = 0; j < rowTaxData.Length; j++) { if (rowTaxData.Length == 0) { taxData = "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; } else { taxData = taxData + "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; } } } xmlRequest = xmlRequest + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; xmlRequest = xmlRequest + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; xmlRequest = xmlRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { xmlRequest = xmlRequest + "<PsgrBreakup><PsgrAry>" + taxdatapsgr + "</PsgrAry></PsgrBreakup>"; } xmlRequest = xmlRequest + "</BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr> } } xmlRequest = xmlRequest + "</FlightSegments></onward><Return><FlightSegments>"; DataTable dtReturn = dsIntFlights.Tables["Return"]; if (dtReturn.Rows.Count > 0) { DataRow[] rowReturn = dtReturn.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); returnId = rowReturn[0]["return_id"].ToString(); } DataTable dtFlightSegmentsRet = dsIntFlights.Tables["FlightSegments"]; if (dtFlightSegmentsRet.Rows.Count > 0) { DataRow[] rowFlightSegmentsRet = dtFlightSegmentsRet.Select("return_id=" + returnId); FlightSegmentsIDRet = rowFlightSegmentsRet[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegmentRet = dsIntFlights.Tables["FlightSegment"]; DataTable dtBookingClassRet = dsIntFlights.Tables["BookingClass"]; DataTable dtBookingClassFareRet = dsIntFlights.Tables["BookingClassFare"]; DataTable dtPsgrBreakUpRet = dsIntFlights.Tables["PsgrBreakUp"]; DataTable dtPsgrAryRet = dsIntFlights.Tables["PsgrAry"]; DataTable dtPsgrRet = dsIntFlights.Tables["Psgr"]; DataTable dtTaxDataAryRet = dsIntFlights.Tables["TaxDataAry"]; DataTable dtTaxDataRet = dsIntFlights.Tables["TaxData"]; if (dtFlightSegmentRet.Rows.Count > 0) { DataRow[] rowFlightSegmentRet = dtFlightSegmentRet.Select("FlightSegments_Id=" + FlightSegmentsIDRet); for (int i = 0; i < rowFlightSegmentRet.Length; i++) { AirEquipTypeRet = rowFlightSegmentRet[i]["AirEquipType"].ToString(); ArrivalAirportCodeRet = rowFlightSegmentRet[i]["ArrivalAirportCode"].ToString(); ArrivalAirportNameRet = rowFlightSegmentRet[i]["ArrivalAirportName"].ToString(); ArrivalDateTimeRet = rowFlightSegmentRet[i]["ArrivalDateTime"].ToString(); DepartureAirportCodeRet = rowFlightSegmentRet[i]["DepartureAirportCode"].ToString(); DepartureAirportNameRet = rowFlightSegmentRet[i]["DepartureAirportName"].ToString(); DepartureDateTimeRet = rowFlightSegmentRet[i]["DepartureDateTime"].ToString(); FlightNumberRet = rowFlightSegmentRet[i]["FlightNumber"].ToString(); MarketingAirlineCodeRet = rowFlightSegmentRet[i]["MarketingAirlineCode"].ToString(); OperatingAirlineCodeRet = rowFlightSegmentRet[i]["OperatingAirlineCode"].ToString(); OperatingAirlineNameRet = rowFlightSegmentRet[i]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumberRet = rowFlightSegmentRet[i]["OperatingAirlineFlightNumber"].ToString(); NumStopsRet = rowFlightSegmentRet[i]["NumStops"].ToString(); LinkSellAgrmntRet = rowFlightSegmentRet[i]["LinkSellAgrmnt"].ToString(); ConxRet = rowFlightSegmentRet[i]["Conx"].ToString(); AirpChgRet = rowFlightSegmentRet[i]["AirpChg"].ToString(); InsideAvailOptionRet = rowFlightSegmentRet[i]["InsideAvailOption"].ToString(); GenTrafRestrictionRet = rowFlightSegmentRet[i]["GenTrafRestriction"].ToString(); DaysOperatesRet = rowFlightSegmentRet[i]["DaysOperates"].ToString(); JrnyTmRet = rowFlightSegmentRet[i]["JrnyTm"].ToString(); EndDtRet = rowFlightSegmentRet[i]["EndDt"].ToString(); StartTerminalRet = rowFlightSegmentRet[i]["StartTerminal"].ToString(); EndTerminalRet = rowFlightSegmentRet[i]["EndTerminal"].ToString(); FltTmRet = rowFlightSegmentRet[i]["FltTm"].ToString(); LSAIndRet = rowFlightSegmentRet[i]["LSAInd"].ToString(); MileRet = rowFlightSegmentRet[i]["Mile"].ToString(); if (dtBookingClassRet.Rows.Count > 0) { DataRow[] rowBookingClassRet = dtBookingClassRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); AvailabilityRet = rowBookingClassRet[0]["Availability"].ToString(); BICRet = rowBookingClassRet[0]["BIC"].ToString(); } if (dtBookingClassFareRet.Rows.Count > 0) { DataRow[] rowBookingClassFareRet = dtBookingClassFareRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); bookingclassRet = rowBookingClassFareRet[0]["bookingclass"].ToString(); classTypeRet = rowBookingClassFareRet[0]["classType"].ToString(); farebasiscodeRet = rowBookingClassFareRet[0]["farebasiscode"].ToString(); RuleRet = rowBookingClassFareRet[0]["Rule"].ToString(); if (dtBookingClassFareRet.Columns.Contains("bookingclassFare_Id")) { bookingclassFareIdRet = rowBookingClassFareRet[0]["bookingclassFare_Id"].ToString(); } } if (dtBookingClassFareRet.Columns.Contains("bookingclassFare_Id")) { if (dtPsgrBreakUpRet.Rows.Count > 0) { DataRow[] rowPsgrBreakUpRet = dtPsgrBreakUpRet.Select("bookingclassFare_Id=" + bookingclassFareIdRet); psgrBreakUp_IdRet = rowPsgrBreakUpRet[0]["psgrBreakUp_Id"].ToString(); } if (dtPsgrAryRet.Rows.Count > 0) { DataRow[] rowPsgrAryRet = dtPsgrAryRet.Select("psgrBreakUp_Id=" + psgrBreakUp_IdRet); psgrAy_idRet = rowPsgrAryRet[0]["psgrAry_Id"].ToString(); } if (dtPsgrRet.Rows.Count > 0) { DataRow[] rowPsgrRet = dtPsgrRet.Select("psgrAry_Id=" + psgrAy_idRet); FarePsgrTypeRet = rowPsgrRet[0]["psgrType"].ToString(); FareBaseFareRet = rowPsgrRet[0]["BaseFare"].ToString(); FareTax1Ret = rowPsgrRet[0]["Tax"].ToString(); BagInfoRet = rowPsgrRet[0]["BagInfo"].ToString(); } } //if (dtTaxDataAryRet.Rows.Count > 0) //{ // DataRow[] rowTaxDataAryRet = dtTaxDataAryRet.Select("Fare_id=" + FareIdRet); // taxDataAry_id = rowTaxDataAryRet[0]["TaxdataAry_Id"].ToString(); //} //if (dtTaxDataRet.Rows.Count > 0) //{ // DataRow[] rowTaxDataRet = dtTaxDataRet.Select("TaxdataAry_Id=" + taxDataAry_idRet); // for (int j = 0; j < rowTaxDataRet.Length; j++) // { // if (rowTaxDataRet.Length == 0) // { // taxDataRet = "<TaxData><Country>" + rowTaxDataRet[j]["Country"].ToString() + "</Country><Amt>" + rowTaxDataRet[j]["Amt"].ToString() + "</Amt></TaxData>"; // } // else // { // taxDataRet = taxDataRet + "<TaxData><Country>" + rowTaxDataRet[j]["Country"].ToString() + "</Country><Amt>" + rowTaxDataRet[j]["Amt"].ToString() + "</Amt></TaxData>"; // } // } //} xmlRequest = xmlRequest + "<FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportNameRet + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportNameRet + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber>"; xmlRequest = xmlRequest + "<MarketingAirlineCode>" + MarketingAirlineCodeRet + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineNameRet + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><NumStops>" + NumStopsRet + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmntRet + "</LinkSellAgrmnt><Conx>" + ConxRet + "</Conx><AirpChg>" + AirpChgRet + "</AirpChg><InsideAvailOption>" + InsideAvailOptionRet + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestrictionRet + "</GenTrafRestriction><DaysOperates>" + DaysOperatesRet + "</DaysOperates><JrnyTm>" + JrnyTmRet + "</JrnyTm><EndDt>" + EndDtRet + "</EndDt><StartTerminal>" + StartTerminalRet + "</StartTerminal><EndTerminal>" + EndTerminalRet + "</EndTerminal>"; xmlRequest = xmlRequest + "<FltTm>" + FltTmRet + "</FltTm><LSAInd>" + LSAIndRet + "</LSAInd><Mile>" + MileRet + "</Mile><BookingClass><Availability>" + AvailabilityRet + "</Availability><BIC>" + BICRet + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclassRet + "</bookingclass><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><Rule>" + RuleRet.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtBookingClassFareRet.Columns.Contains("bookingclassFare_Id")) { xmlRequest = xmlRequest + "<PsgrBreakup><PsgrAry>" + taxdatapsgrRet + "</PsgrAry></PsgrBreakup>"; } xmlRequest = xmlRequest + "</BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrTypeRet + "</PsgrType><BaseFare>" + FareBaseFareRet + "</BaseFare><Tax>" + FareTax1Ret + "</Tax><BagInfo></BagInfo></Psgr> } } xmlRequest = xmlRequest + "</FlightSegments></Return><id>" + id + "</id><key>" + key + "</key>"; xmlRequest = xmlRequest + "</OriginDestinationOption></Bookingrequest>"; StringBuilder stt = new StringBuilder(); stt.Append("xmlRequest"); stt.Append("="); stt.Append(Server.UrlEncode(xmlRequest)); byte[] requestData = Encoding.UTF8.GetBytes(stt.ToString()); HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://live.arzoo.com:9302/Booking"); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; request.Accept = "application/json"; request.ContentLength = requestData.Length; using (Stream requestStream = request.GetRequestStream()) { requestStream.Write(requestData, 0, requestData.Length); } using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { using (Stream stream = response.GetResponseStream()) { using (StreamReader reader = new StreamReader(stream, Encoding.ASCII)) result = reader.ReadToEnd(); XmlDocument doc = new XmlDocument(); doc.LoadXml(result); XmlNodeReader xmlReader = new XmlNodeReader(doc); dsResponse.ReadXml(xmlReader); } } } catch (Exception ex) { // throw; } return dsResponse; }
private DataSet GetIntBookingRequest() { DataSet ds = new DataSet(); dsIntFlights = (DataSet)Session["dsIntFlights"]; #region Variables string str = string.Empty; string FlightSegmentsID = string.Empty; string DepartureAirportCode = string.Empty; string ArrivalDateTime = string.Empty; string DepartureAirportName = string.Empty; string DepartureDateTime = string.Empty; string FlightNumber = string.Empty; string MarketingAirlineCode = string.Empty; string OperatingAirlineCode = string.Empty; string OperatingAirlineName = string.Empty; string OperatingAirlineFlightNumber = string.Empty; string NumStops = string.Empty; string LinkSellAgrmnt = string.Empty; string Conx = string.Empty; string AirpChg = string.Empty; string InsideAvailOption = string.Empty; string GenTrafRestriction = string.Empty; string DaysOperates = string.Empty; string JrnyTm = string.Empty; string EndDt = string.Empty; string StartTerminal = string.Empty; string EndTerminal = string.Empty; string FltTm = string.Empty; string LSAInd = string.Empty; string Mile = string.Empty; string Availability = string.Empty; string BIC = string.Empty; string bookingclass = string.Empty; string classType = string.Empty; string farebasiscode = string.Empty; string Rule = string.Empty; string PsgrType = string.Empty; string BaseFare = string.Empty; string Tax = string.Empty; string BagInfo = string.Empty; string AirEquipType = string.Empty; string ArrivalAirportCode = string.Empty; string ArrivalAirportName = string.Empty; string return1 = string.Empty; string id = string.Empty; string key = string.Empty; string ActualBaseFare = string.Empty; string FareTax = string.Empty; string STax = string.Empty; string TCharge = string.Empty; string SCharge = string.Empty; string TDiscount = string.Empty; string TMarkup = string.Empty; string TPartnerCommission = string.Empty; string TSdiscount = string.Empty; string FarePsgrType = string.Empty; string FareBaseFare = string.Empty; string FareTax1 = string.Empty; string Country = string.Empty; string Amt = string.Empty; string ocTax = string.Empty; string onwardId = string.Empty; string OriginDestinationOption_Id = string.Empty; string FareDetails_id = string.Empty; string FareBreakUp_Id = string.Empty; string FareAry_id = string.Empty; string FareId = string.Empty; string bookingclassFareId = string.Empty; string psgrBreakUp_Id = string.Empty; string psgrAy_id = string.Empty; string country = string.Empty; string taxAmt = string.Empty; string taxData = string.Empty; string taxDataAry_id = string.Empty; string CFareId = string.Empty; string CPsgrType = string.Empty; string CBaseFare = string.Empty; string CFareTax = string.Empty; string IFareId = string.Empty; string IPsgrType = string.Empty; string IBaseFare = string.Empty; string IFareTax = string.Empty; string CFarePsgrType = string.Empty; string CFareBaseFare = string.Empty; string CFareTax1 = string.Empty; string CBagInfo = string.Empty; string IFarePsgrType = string.Empty; string IFareBaseFare = string.Empty; string IFareTax1 = string.Empty; string IBagInfo = string.Empty; string taxdatapsgr = string.Empty; #endregion try { string result = null; DataTable dtFlightSegment = dsIntFlights.Tables[12]; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightSegment.Select("FlightSegment_ID=" + Convert.ToInt32(lblIntFlightSegmentId.Text)); FlightSegmentsID = rowFilghtSegment[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegments = dsIntFlights.Tables[11]; if (dtFlightSegments.Rows.Count > 0) { DataRow[] rowFilghtSegments = dtFlightSegments.Select("FlightSegments_ID=" + FlightSegmentsID); onwardId = rowFilghtSegments[0]["Onward_Id"].ToString(); } DataTable dtOnward = dsIntFlights.Tables[10]; if (dtOnward.Rows.Count > 0) { DataRow[] rowOnward = dtOnward.Select("Onward_Id=" + onwardId); OriginDestinationOption_Id = rowOnward[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtOriginDestinationOption = dsIntFlights.Tables[3]; if (dtOriginDestinationOption.Rows.Count > 0) { DataRow[] rowOriginDestinationOption = dtOriginDestinationOption.Select("OriginDestinationOption_Id=" + OriginDestinationOption_Id); return1 = rowOriginDestinationOption[0]["Return"].ToString(); id = rowOriginDestinationOption[0]["id"].ToString(); key = rowOriginDestinationOption[0]["key"].ToString(); } DataTable dtFareDetails = dsIntFlights.Tables[4]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("OriginDestinationOption_Id=" + OriginDestinationOption_Id); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } DataTable dtFareBreakUp = dsIntFlights.Tables[5]; if (dtFareBreakUp.Rows.Count > 0) { DataRow[] rowFareBreakUp = dtFareBreakUp.Select("FareDetails_Id=" + FareDetails_id); FareBreakUp_Id = rowFareBreakUp[0]["FareBreakUp_Id"].ToString(); } DataTable dtFareAry = dsIntFlights.Tables[6]; if (dtFareAry.Rows.Count > 0) { DataRow[] rowFareAry = dtFareAry.Select("FareBreakUp_Id=" + FareBreakUp_Id); FareAry_id = rowFareAry[0]["FareAry_id"].ToString(); } DataTable dtFare = dsIntFlights.Tables[7]; if (dtFare.Rows.Count > 0) { DataRow[] rowFare = dtFare.Select("FareAry_id=" + FareAry_id); PsgrType = rowFare[0]["PsgrType"].ToString(); BaseFare = rowFare[0]["BaseFare"].ToString(); FareTax = rowFare[0]["Tax"].ToString(); FareId = rowFare[0]["Fare_Id"].ToString(); //child //CPsgrType = rowFare[1]["PsgrType"].ToString(); //CBaseFare = rowFare[1]["BaseFare"].ToString(); //CFareTax = rowFare[1]["Tax"].ToString(); //CFareId = rowFare[1]["Fare_Id"].ToString(); ////infant //IPsgrType = rowFare[2]["PsgrType"].ToString(); //IBaseFare = rowFare[2]["BaseFare"].ToString(); //IFareTax = rowFare[2]["Tax"].ToString(); //IFareId = rowFare[2]["Fare_Id"].ToString(); } DataTable dtBookingClass = dsIntFlights.Tables[13]; if (dtBookingClass.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass.Select("FlightSegment_Id=" + lblIntFlightSegmentId.Text); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } DataTable dtBookingClassFare = dsIntFlights.Tables[14]; if (dtBookingClassFare.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare.Select("FlightSegment_Id=" + lblIntFlightSegmentId.Text); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { bookingclassFareId = rowBookingClassFare[0]["bookingclassFare_Id"].ToString(); } } if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { DataTable dtPsgrBreakUp = dsIntFlights.Tables[15]; if (dtPsgrBreakUp.Rows.Count > 0) { DataRow[] rowPsgrBreakUp = dtPsgrBreakUp.Select("bookingclassFare_Id=" + bookingclassFareId); psgrBreakUp_Id = rowPsgrBreakUp[0]["psgrBreakUp_Id"].ToString(); } DataTable dtPsgrAry = dsIntFlights.Tables[16]; if (dtPsgrAry.Rows.Count > 0) { DataRow[] rowPsgrAry = dtPsgrAry.Select("psgrBreakUp_Id=" + psgrBreakUp_Id); psgrAy_id = rowPsgrAry[0]["psgrAry_Id"].ToString(); } DataTable dtPsgr = dsIntFlights.Tables[17]; if (dtPsgr.Rows.Count > 0) { DataRow[] rowPsgr = dtPsgr.Select("psgrAry_Id=" + psgrAy_id); FarePsgrType = rowPsgr[0]["psgrType"].ToString(); FareBaseFare = rowPsgr[0]["BaseFare"].ToString(); FareTax1 = rowPsgr[0]["Tax"].ToString(); BagInfo = rowPsgr[0]["BagInfo"].ToString(); //child //CFarePsgrType = rowPsgr[1]["psgrType"].ToString(); //CFareBaseFare = rowPsgr[1]["BaseFare"].ToString(); //CFareTax1 = rowPsgr[1]["Tax"].ToString(); //CBagInfo = rowPsgr[1]["BagInfo"].ToString(); ////infant //IFarePsgrType = rowPsgr[2]["psgrType"].ToString(); //IFareBaseFare = rowPsgr[2]["BaseFare"].ToString(); //IFareTax1 = rowPsgr[2]["Tax"].ToString(); //IBagInfo = rowPsgr[2]["BagInfo"].ToString(); } if (dtPsgr.Rows.Count > 0) { DataRow[] rowPsgr = dtPsgr.Select("psgrAry_Id=" + psgrAy_id); foreach (DataRow rows in rowPsgr) { if (rows.Table.Rows.Count == 0) { taxdatapsgr = "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } else { taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } } } } // <Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr> DataTable dtTaxDataAry = dsIntFlights.Tables[8]; if (dtTaxDataAry.Rows.Count > 0) { DataRow[] rowTaxDataAry = dtTaxDataAry.Select("Fare_id=" + FareId); taxDataAry_id = rowTaxDataAry[0]["TaxdataAry_Id"].ToString(); } DataTable dtTaxData = dsIntFlights.Tables[9]; if (dtTaxData.Rows.Count > 0) { DataRow[] rowTaxData = dtTaxData.Select("TaxdataAry_Id=" + taxDataAry_id); for (int j = 0; j < rowTaxData.Length; j++) { if (rowTaxData.Length == 0) { taxData = "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; } else { taxData = taxData + "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; //ravi // taxData = taxData + "<Fare><PsgrType>" + dtFare.Rows[j]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dtFare.Rows[j]["BaseFare"].ToString() + "</BaseFare><Tax>" + dtFare.Rows[j]["Tax"].ToString() + "</Tax><TaxDataAry><TaxData><Country>" + rowTaxData[0]["Country"].ToString() + "</Country><Amt>" + rowTaxData[0]["Amt"].ToString() + "</Amt></TaxData><TaxData><Country>" + rowTaxData[1]["Country"].ToString() + "</Country><Amt>" + rowTaxData[1]["Amt"].ToString() + "</Amt></TaxData><TaxData><Country>" + rowTaxData[2]["Country"].ToString() + "</Country><Amt>" + rowTaxData[2]["Amt"].ToString() + "</Amt></TaxData></TaxDataAry></Fare>"; } } } if (dtFare.Rows.Count > 0) { DataRow[] rowFare = dtFare.Select("FareAry_id=" + FareAry_id); foreach (DataRow row in rowFare) { if (row.Table.Rows.Count == 0) { str = "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax><TaxDataAry>" + taxData + "</TaxDataAry></Fare>"; } else { str = str + "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax><TaxDataAry>" + taxData + "</TaxDataAry></Fare>"; } } } FlightBAL objFlightsBal = new FlightBAL(); #region Pricing // string XmlPricingRequest = "<PriceRequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax></Fare></FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>"; string XmlPricingRequest = "<PriceRequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>" + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>"; XmlPricingRequest = XmlPricingRequest + "<onward><FlightSegments>"; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); for (int j = 0; j < rowFilghtSegment.Length; j++) { AirEquipType = rowFilghtSegment[j]["AirEquipType"].ToString(); ArrivalAirportCode = rowFilghtSegment[j]["ArrivalAirportCode"].ToString(); ArrivalAirportName = rowFilghtSegment[j]["ArrivalAirportName"].ToString(); ArrivalDateTime = rowFilghtSegment[j]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFilghtSegment[j]["DepartureAirportCode"].ToString(); DepartureAirportName = rowFilghtSegment[j]["DepartureAirportName"].ToString(); DepartureDateTime = rowFilghtSegment[j]["DepartureDateTime"].ToString(); FlightNumber = rowFilghtSegment[j]["FlightNumber"].ToString(); MarketingAirlineCode = rowFilghtSegment[j]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = rowFilghtSegment[j]["OperatingAirlineCode"].ToString(); OperatingAirlineName = rowFilghtSegment[j]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = rowFilghtSegment[j]["OperatingAirlineFlightNumber"].ToString(); NumStops = rowFilghtSegment[j]["NumStops"].ToString(); LinkSellAgrmnt = rowFilghtSegment[j]["LinkSellAgrmnt"].ToString(); Conx = rowFilghtSegment[j]["Conx"].ToString(); AirpChg = rowFilghtSegment[j]["AirpChg"].ToString(); InsideAvailOption = rowFilghtSegment[j]["InsideAvailOption"].ToString(); GenTrafRestriction = rowFilghtSegment[j]["GenTrafRestriction"].ToString(); DaysOperates = rowFilghtSegment[j]["DaysOperates"].ToString(); JrnyTm = rowFilghtSegment[j]["JrnyTm"].ToString(); EndDt = rowFilghtSegment[j]["EndDt"].ToString(); StartTerminal = rowFilghtSegment[j]["StartTerminal"].ToString(); EndTerminal = rowFilghtSegment[j]["EndTerminal"].ToString(); FltTm = rowFilghtSegment[j]["FltTm"].ToString(); LSAInd = rowFilghtSegment[j]["LSAInd"].ToString(); Mile = rowFilghtSegment[j]["Mile"].ToString(); DataTable dtBookingClass1 = dsIntFlights.Tables[13]; if (dtBookingClass1.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } DataTable dtBookingClassFare1 = dsIntFlights.Tables[14]; if (dtBookingClassFare1.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); } XmlPricingRequest = XmlPricingRequest + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; XmlPricingRequest = XmlPricingRequest + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; // XmlPricingRequest = XmlPricingRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>"; XmlPricingRequest = XmlPricingRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { XmlPricingRequest = XmlPricingRequest + "<PsgrBreakup><PsgrAry>" + taxdatapsgr + "</PsgrAry></PsgrBreakup>"; } XmlPricingRequest = XmlPricingRequest + "</BookingClassFare></FlightSegment>"; } } XmlPricingRequest = XmlPricingRequest + "</FlightSegments></onward><Return>" + return1 + "</Return><id>" + id + "</id><key>" + key + "</key>"; XmlPricingRequest = XmlPricingRequest + "</OriginDestinationOption></PriceRequest>"; // XmlPricingRequest = "<PriceRequest><noadults>1</noadults><nochild>0</nochild><noinfant>0</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><OriginDestinationOption><FareDetails><ActualBaseFare>1200</ActualBaseFare><Tax>2434</Tax><STax>15</STax><TCharge>0</TCharge><SCharge>0</SCharge><TDiscount>0</TDiscount><TMarkup>0</TMarkup><TPartnerCommission>0</TPartnerCommission><TSdiscount>0</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>ADT</PsgrType><BaseFare>1200</BaseFare><Tax>2434</Tax></Fare></FareAry></FareBreakup><ocTax>0</ocTax></FareDetails><onward><FlightSegments><FlightSegment><AirEquipType>319</AirEquipType><ArrivalAirportCode>BOM</ArrivalAirportCode><ArrivalAirportName>MUMBAI</ArrivalAirportName><ArrivalDateTime>2012-11-22T08:20:00</ArrivalDateTime><DepartureAirportCode>BLR</DepartureAirportCode><DepartureAirportName>BANGALORE</DepartureAirportName><DepartureDateTime>2012-11-22T06:45:00</DepartureDateTime><FlightNumber>640</FlightNumber><MarketingAirlineCode>AI</MarketingAirlineCode><OperatingAirlineCode>AI</OperatingAirlineCode><OperatingAirlineName>Air India </OperatingAirlineName><OperatingAirlineFlightNumber>640</OperatingAirlineFlightNumber><NumStops>0</NumStops><LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm>95</JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>95</FltTm><LSAInd>NR</LSAInd><Mile>0</Mile><BookingClass><Availability>9</Availability><BIC>E</BIC></BookingClass><BookingClassFare><bookingclass>E</bookingclass><classType>Economy</classType><farebasiscode>2vRNmb/yC+cens5pMtaPkYnDM963BJmv</farebasiscode><Rule>Cancellation Penalty: All bookings done are subject to the cancellation penalty levied by the respective airline.<br>In addition to the airline''s cancellation penalty, we charge a service fee of Rs. 200 per passenger for all cancellations.|Date Change Penalty: In addition to the airline''s date change penalty, we charge a service fee of Rs. 250 per passenger for any date changes.|</Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>1200</BaseFare><Tax>2434</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment></FlightSegments></onward><Return></Return><id>arzoo13</id><key>zWbxBFyA059f68R2DgKcVEb0gG2ZuxB2ESt+/BTgCLzQweTiPhdGIWgoifR/a2Cj9x+aTfz36efDvXFXubDdI3wdmkWLxP8GZ+Lq5Tx3+M+2Q/P5Ci0UbF/rxHYOApxUDGWf4lPayrbQweTiPhdGIWgoifR/a2Cj6xVBmZQfx+ONy3thiCpYihRRnjyQGrh7hXWLu9m7LCssMPJ4Xz20E7cCU/hS9xGE+mdK+SICvYvDvXFXubDdIyuoEEf9FbAN4z7uuUBbuJV0ouCOH4QaD+k2w/1qSPBE4z7uuUBbuJVNq/UVRvg/WtDB5OI+F0YhaCiJ9H9rYKNiGWZ6hnYEx2fi6uU8d/jPAJdXKqYIvc6k7AR2V9RC8mLW1E7VsZRB6xVBmZQfx+ONy3thiCpYikgRopJOZai5w71xV7mw3SOesti0ItOrM+qV6E/q3ryX4z7uuUBbuJVda06JiVzmQbdnNHyB7CF7LlNKor8yYnvQweTiPhdGIWgoifR/a2CjIMslYqDKLY23AlP4UvcRhGj3lQ/u1K004z7uuUBbuJXZbs/Nj1KYstDB5OI+F0YhaCiJ9H9rYKN0T/ucEjF5PZ1wvmyPYreXJCBv6x4bv/pu0YP7Nu5g2NDB5OI+F0YhaCiJ9H9rYKOhL5P5CPMmfY3Le2GIKliKHFNpSrtt65mFdYu72bssK5KdnOzPZf54twJT+FL3EYTpQH95xm5Uz1e19n1oIAdmy0wCTwW+1dqVswhkwvUGUDOPZa2xmRkUvCTUhkR0CW/QweTiPhdGIT52/cnXSmDtDgDBTfsCDU1n4urlPHf4z7ZD8/kKLRRsX+vEdg4CnFQMZZ/iU9rKttDB5OI+F0YhPnb9yddKYO0kSKl1oUnxcdDB5OI+F0YhaCiJ9H9rYKNPW37Oq/0IzMO9cVe5sN0jIVA6RFn+Em3QweTiPhdGIWgoifR/a2CjfXbFNbiqMm99r9ByVqdVqiM7V96J</key></OriginDestinationOption></PriceRequest>"; DataSet dsPricingResponse = objFlightsBal.GetDatasetFromAPI(XmlPricingRequest, "http://live.arzoo.com:9302/Pricing"); if (dsPricingResponse.Tables[0].Rows[0]["error"] == string.Empty) { // DataTable dtpricingflightsegment = dsPricingResponse.Tables DataTable dtpricingFlightSegment = dsPricingResponse.Tables["FlightSegment"]; if (dtpricingFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtpricingFlightSegment.Select("FlightSegment_ID=" + Convert.ToInt32(lblIntFlightSegmentId.Text)); FlightSegmentsID = rowFilghtSegment[0]["FlightSegments_Id"].ToString(); } DataTable dtpricingFlightSegments = dsPricingResponse.Tables["FlightSegments"]; if (dtpricingFlightSegments.Rows.Count > 0) { DataRow[] rowFilghtSegments = dtpricingFlightSegments.Select("FlightSegments_ID=" + FlightSegmentsID); onwardId = rowFilghtSegments[0]["Onward_Id"].ToString(); } DataTable dtpricingOnward = dsPricingResponse.Tables["onward"]; if (dtpricingOnward.Rows.Count > 0) { DataRow[] rowOnward = dtpricingOnward.Select("Onward_Id=" + onwardId); OriginDestinationOption_Id = rowOnward[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtpricingFareDetails = dsIntFlights.Tables["FareDetails"]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("OriginDestinationOption_Id=" + OriginDestinationOption_Id); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } } #endregion string ref1 = Common.GetFlightsReferenceNo("LJIF"); string xmlRequest = "<Bookingrequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><creditcardno></creditcardno><PartnerreferenceID>" + ref1 + "</PartnerreferenceID>"; xmlRequest = xmlRequest + "<personName>"; // Dynamic generation of names of adults, infants , Child Table tbladults = (Table)this.UpdatePanel2.FindControl("tblAdultsInt"); for (int i = 1; i <= Convert.ToInt32(Session["adultCntInt"]); i++) { TextBox txtFn = (TextBox)tbladults.FindControl("txtFnInt" + i); TextBox txtLn = (TextBox)tbladults.FindControl("txtLnInt" + i); DropDownList ddlTitle = (DropDownList)tbladults.FindControl("ddlTitleInt" + i); xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } Table tblChild = (Table)this.UpdatePanel2.FindControl("tblChildInt"); for (int i = 1; i <= Convert.ToInt32(Session["childCntInt"]); i++) { TextBox txtFn = (TextBox)tblChild.FindControl("txtCFnInt" + i); TextBox txtLn = (TextBox)tblChild.FindControl("txtCLnInt" + i); DropDownList ddlTitle = (DropDownList)tblChild.FindControl("ddlCTitleInt" + i); TextBox txtBirthDate = (TextBox)tblChild.FindControl("txtCBirthDateInt" + i); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); //if (Convert.ToInt32(age) > 5) //{ // Literal lit = new Literal(); // lit.Text = txtFn.Text + " Age between 3 - 5 yrs."; // this.Controls.Add(lit); // break; //} 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 tblInfants = (Table)this.UpdatePanel2.FindControl("tblInfantsInt"); for (int i = 1; i <= Convert.ToInt32(Session["infantCntInt"]); i++) { TextBox txtFn = (TextBox)tblInfants.FindControl("txtIFnInt" + i); TextBox txtLn = (TextBox)tblInfants.FindControl("txtILnInt" + i); DropDownList ddlTitle = (DropDownList)tblInfants.FindControl("ddlITitleInt" + i); TextBox txtBirthDate = (TextBox)tblInfants.FindControl("txtIBirthDateInt" + i); string age = string.Empty; if (txtBirthDate != null) age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); else age = "0"; //if (Convert.ToInt32(age) == 12) //{ // Literal lit = new Literal(); // lit.Text = txtFn.Text + " Age should be below 1 yr."; // this.Controls.Add(lit); // break; //} 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>"; } xmlRequest = xmlRequest + "</personName><telePhone><phoneNumber>" + txtMobileNumInt.Text + "</phoneNumber></telePhone><email><emailAddress>" + txtEmailIDInt.Text + "</emailAddress></email>"; //xmlRequest = xmlRequest + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax><TaxDataAry>"; //xmlRequest = xmlRequest + taxData + "</TaxDataAry></Fare></FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails><onward><FlightSegments>"; xmlRequest = xmlRequest + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>"; xmlRequest = xmlRequest + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails><onward><FlightSegments>"; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); for (int j = 0; j < rowFilghtSegment.Length; j++) { AirEquipType = rowFilghtSegment[j]["AirEquipType"].ToString(); ArrivalAirportCode = rowFilghtSegment[j]["ArrivalAirportCode"].ToString(); ArrivalAirportName = rowFilghtSegment[j]["ArrivalAirportName"].ToString(); ArrivalDateTime = rowFilghtSegment[j]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFilghtSegment[j]["DepartureAirportCode"].ToString(); DepartureAirportName = rowFilghtSegment[j]["DepartureAirportName"].ToString(); DepartureDateTime = rowFilghtSegment[j]["DepartureDateTime"].ToString(); FlightNumber = rowFilghtSegment[j]["FlightNumber"].ToString(); MarketingAirlineCode = rowFilghtSegment[j]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = rowFilghtSegment[j]["OperatingAirlineCode"].ToString(); OperatingAirlineName = rowFilghtSegment[j]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = rowFilghtSegment[j]["OperatingAirlineFlightNumber"].ToString(); NumStops = rowFilghtSegment[j]["NumStops"].ToString(); LinkSellAgrmnt = rowFilghtSegment[j]["LinkSellAgrmnt"].ToString(); Conx = rowFilghtSegment[j]["Conx"].ToString(); AirpChg = rowFilghtSegment[j]["AirpChg"].ToString(); InsideAvailOption = rowFilghtSegment[j]["InsideAvailOption"].ToString(); GenTrafRestriction = rowFilghtSegment[j]["GenTrafRestriction"].ToString(); DaysOperates = rowFilghtSegment[j]["DaysOperates"].ToString(); JrnyTm = rowFilghtSegment[j]["JrnyTm"].ToString(); EndDt = rowFilghtSegment[j]["EndDt"].ToString(); StartTerminal = rowFilghtSegment[j]["StartTerminal"].ToString(); EndTerminal = rowFilghtSegment[j]["EndTerminal"].ToString(); FltTm = rowFilghtSegment[j]["FltTm"].ToString(); LSAInd = rowFilghtSegment[j]["LSAInd"].ToString(); Mile = rowFilghtSegment[j]["Mile"].ToString(); DataTable dtBookingClass1 = dsIntFlights.Tables[13]; if (dtBookingClass1.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } DataTable dtBookingClassFare1 = dsIntFlights.Tables[14]; if (dtBookingClassFare1.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); } xmlRequest = xmlRequest + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; xmlRequest = xmlRequest + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; xmlRequest = xmlRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { xmlRequest = xmlRequest + "<PsgrBreakup><PsgrAry><Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup>"; } xmlRequest = xmlRequest + "</BookingClassFare></FlightSegment>"; } } xmlRequest = xmlRequest + "</FlightSegments></onward><Return>" + return1 + "</Return><id>" + id + "</id><key>" + key + "</key>"; xmlRequest = xmlRequest + "</OriginDestinationOption></Bookingrequest>"; #region Unwanted Code //xmlRequest = "<Bookingrequest><noadults>1</noadults><nochild>0</nochild><noinfant>0</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid>"; //xmlRequest = xmlRequest + "<Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><creditcardno></creditcardno><PartnerreferenceID>" + ref1 + "</PartnerreferenceID><personName><CustomerInfo><givenName>Bindu</givenName> <surName>B</surName>"; //xmlRequest = xmlRequest + "<nameReference>Mrs.</nameReference>"; //xmlRequest = xmlRequest + "<psgrtype>adt</psgrtype>"; //xmlRequest = xmlRequest + "</CustomerInfo>"; //xmlRequest = xmlRequest + "</personName>"; //xmlRequest = xmlRequest + "<telePhone>"; //xmlRequest = xmlRequest + "<phoneNumber>9701213996</phoneNumber>"; //xmlRequest = xmlRequest + "</telePhone>"; //xmlRequest = xmlRequest + "<email>"; //xmlRequest = xmlRequest + "<emailAddress>[email protected]</emailAddress>"; //xmlRequest = xmlRequest + "</email>"; //xmlRequest = xmlRequest + "<OriginDestinationOption>"; //xmlRequest = xmlRequest + "<FareDetails>"; //xmlRequest = xmlRequest + "<ActualBaseFare>21250</ActualBaseFare>"; //xmlRequest = xmlRequest + "<Tax>19675</Tax>"; //xmlRequest = xmlRequest + "<STax>264</STax>"; //xmlRequest = xmlRequest + "<TCharge>0</TCharge>"; //xmlRequest = xmlRequest + "<SCharge>0</SCharge>"; //xmlRequest = xmlRequest + "<TDiscount>0</TDiscount>"; //xmlRequest = xmlRequest + "<TMarkup>0</TMarkup>"; //xmlRequest = xmlRequest + "<TPartnerCommission>0</TPartnerCommission>"; //xmlRequest = xmlRequest + "<TSdiscount>0</TSdiscount>"; //xmlRequest = xmlRequest + "<FareBreakup>"; //xmlRequest = xmlRequest + "<FareAry>"; //xmlRequest = xmlRequest + "<Fare>"; //xmlRequest = xmlRequest + "<PsgrType>ADT</PsgrType>"; //xmlRequest = xmlRequest + "<BaseFare>21250</BaseFare>"; //xmlRequest = xmlRequest + "<Tax>19675</Tax>"; //xmlRequest = xmlRequest + "<TaxDataAry>"; //xmlRequest = xmlRequest + "<TaxData>"; //xmlRequest = xmlRequest + "<Country>YQ</Country>"; //xmlRequest = xmlRequest + "<Amt>0</Amt>"; //xmlRequest = xmlRequest + "</TaxData>"; //xmlRequest = xmlRequest + "<TaxData>"; //xmlRequest = xmlRequest + "<Country>WO</Country>"; //xmlRequest = xmlRequest + "<Amt>7108</Amt>"; //xmlRequest = xmlRequest + "</TaxData>"; //xmlRequest = xmlRequest + "<TaxData>"; //xmlRequest = xmlRequest + "<Country>Other</Country>"; //xmlRequest = xmlRequest + "<Amt>12567</Amt>"; //xmlRequest = xmlRequest + "</TaxData>"; //xmlRequest = xmlRequest + "</TaxDataAry>"; //xmlRequest = xmlRequest + "</Fare>"; //xmlRequest = xmlRequest + "</FareAry>"; //xmlRequest = xmlRequest + "</FareBreakup>"; //xmlRequest = xmlRequest + "<ocTax>0</ocTax>"; //xmlRequest = xmlRequest + "</FareDetails>"; //xmlRequest = xmlRequest + "<onward>"; //xmlRequest = xmlRequest + "<FlightSegments>"; //xmlRequest = xmlRequest + "<FlightSegment>"; //xmlRequest = xmlRequest + "<AirEquipType>744</AirEquipType>"; //xmlRequest = xmlRequest + "<ArrivalAirportCode>LHR</ArrivalAirportCode>"; //xmlRequest = xmlRequest + "<ArrivalAirportName>London</ArrivalAirportName>"; //xmlRequest = xmlRequest + "<ArrivalDateTime>2012-11-19T13:25:00</ArrivalDateTime>"; //xmlRequest = xmlRequest + "<DepartureAirportCode>BLR</DepartureAirportCode>"; //xmlRequest = xmlRequest + "<DepartureAirportName>BANGALORE</DepartureAirportName>"; //xmlRequest = xmlRequest + "<DepartureDateTime>2012-11-19T07:50:00</DepartureDateTime>"; //xmlRequest = xmlRequest + "<FlightNumber>6656</FlightNumber>"; //xmlRequest = xmlRequest + "<MarketingAirlineCode>AA</MarketingAirlineCode>"; //xmlRequest = xmlRequest + "<OperatingAirlineCode>BA</OperatingAirlineCode>"; //xmlRequest = xmlRequest + "<OperatingAirlineName>American Airlines </OperatingAirlineName>"; //xmlRequest = xmlRequest + "<OperatingAirlineFlightNumber>6656</OperatingAirlineFlightNumber>"; //xmlRequest = xmlRequest + "<NumStops>0</NumStops>"; //xmlRequest = xmlRequest + "<LinkSellAgrmnt />"; //xmlRequest = xmlRequest + "<Conx>N</Conx>"; //xmlRequest = xmlRequest + "<AirpChg>N</AirpChg>"; //xmlRequest = xmlRequest + "<InsideAvailOption>C</InsideAvailOption>"; //xmlRequest = xmlRequest + "<GenTrafRestriction>?</GenTrafRestriction>"; //xmlRequest = xmlRequest + "<DaysOperates>NA</DaysOperates>"; //xmlRequest = xmlRequest + "<JrnyTm>665</JrnyTm>"; //xmlRequest = xmlRequest + "<EndDt />"; //xmlRequest = xmlRequest + "<StartTerminal />"; //xmlRequest = xmlRequest + "<EndTerminal />"; //xmlRequest = xmlRequest + "<FltTm>665</FltTm>"; //xmlRequest = xmlRequest + "<LSAInd>R</LSAInd>"; //xmlRequest = xmlRequest + "<Mile>0</Mile>"; //xmlRequest = xmlRequest + "<BookingClass>"; //xmlRequest = xmlRequest + "<Availability>1</Availability>"; //xmlRequest = xmlRequest + "<BIC>S</BIC>"; //xmlRequest = xmlRequest + "</BookingClass>"; //xmlRequest = xmlRequest + "<BookingClassFare>"; //xmlRequest = xmlRequest + "<bookingclass>S</bookingclass>"; //xmlRequest = xmlRequest + "<classType>Economy</classType>"; //xmlRequest = xmlRequest + "<farebasiscode>ZeHo17My7PSA3CBU2WO9J34bX8FEuX61F9zkShsUkYU=</farebasiscode>"; //xmlRequest = xmlRequest + "<Rule>Cancellation Penalty: All bookings done are subject to the cancellation penalty levied by the respective airline.<br>In addition to the airline''s cancellation penalty, we charge a service fee of Rs. 200 per passenger for all cancellations.|Date Change Penalty: In addition to the airline''s date change penalty, we charge a service fee of Rs. 250 per passenger for any date changes.|</Rule>"; //xmlRequest = xmlRequest + "<PsgrBreakup>"; //xmlRequest = xmlRequest + "<PsgrAry>"; //xmlRequest = xmlRequest + "<Psgr>"; //xmlRequest = xmlRequest + "<PsgrType>ADT</PsgrType>"; //xmlRequest = xmlRequest + "<BaseFare>21250</BaseFare>"; //xmlRequest = xmlRequest + "<Tax>19675</Tax>"; //xmlRequest = xmlRequest + "<BagInfo />"; //xmlRequest = xmlRequest + "</Psgr>"; //xmlRequest = xmlRequest + "</PsgrAry>"; //xmlRequest = xmlRequest + "</PsgrBreakup>"; //xmlRequest = xmlRequest + "</BookingClassFare>"; //xmlRequest = xmlRequest + "</FlightSegment>"; //xmlRequest = xmlRequest + "<FlightSegment>"; //xmlRequest = xmlRequest + "<AirEquipType>777</AirEquipType>"; //xmlRequest = xmlRequest + "<ArrivalAirportCode>JFK</ArrivalAirportCode>"; //xmlRequest = xmlRequest + "<ArrivalAirportName>NEW YORK</ArrivalAirportName>"; //xmlRequest = xmlRequest + "<ArrivalDateTime>2012-11-19T18:10:00</ArrivalDateTime>"; //xmlRequest = xmlRequest + "<DepartureAirportCode>LHR</DepartureAirportCode>"; //xmlRequest = xmlRequest + "<DepartureAirportName>London</DepartureAirportName>"; //xmlRequest = xmlRequest + "<DepartureDateTime>2012-11-19T15:15:00</DepartureDateTime>"; //xmlRequest = xmlRequest + "<FlightNumber>6134</FlightNumber>"; //xmlRequest = xmlRequest + "<MarketingAirlineCode>AA</MarketingAirlineCode>"; //xmlRequest = xmlRequest + "<OperatingAirlineCode>BA</OperatingAirlineCode>"; //xmlRequest = xmlRequest + "<OperatingAirlineName>American Airlines </OperatingAirlineName>"; //xmlRequest = xmlRequest + "<OperatingAirlineFlightNumber>6134</OperatingAirlineFlightNumber>"; //xmlRequest = xmlRequest + "<NumStops>0</NumStops>"; //xmlRequest = xmlRequest + "<LinkSellAgrmnt />"; //xmlRequest = xmlRequest + "<Conx>N</Conx>"; //xmlRequest = xmlRequest + "<AirpChg>N</AirpChg>"; //xmlRequest = xmlRequest + "<InsideAvailOption>C</InsideAvailOption>"; //xmlRequest = xmlRequest + "<GenTrafRestriction>?</GenTrafRestriction>"; //xmlRequest = xmlRequest + "<DaysOperates>NA</DaysOperates>"; //xmlRequest = xmlRequest + "<JrnyTm>985</JrnyTm>"; //xmlRequest = xmlRequest + "<EndDt />"; //xmlRequest = xmlRequest + "<StartTerminal />"; //xmlRequest = xmlRequest + "<EndTerminal />"; //xmlRequest = xmlRequest + "<FltTm>985</FltTm>"; //xmlRequest = xmlRequest + "<LSAInd>R</LSAInd>"; //xmlRequest = xmlRequest + "<Mile>0</Mile>"; //xmlRequest = xmlRequest + "<BookingClass>"; //xmlRequest = xmlRequest + "<Availability>7</Availability>"; //xmlRequest = xmlRequest + "<BIC>S</BIC>"; //xmlRequest = xmlRequest + "</BookingClass>"; //xmlRequest = xmlRequest + "<BookingClassFare>"; //xmlRequest = xmlRequest + "<bookingclass>S</bookingclass>"; //xmlRequest = xmlRequest + "<classType>Economy</classType>"; //xmlRequest = xmlRequest + "<farebasiscode>ZeHo17My7PSA3CBU2WO9J34bX8FEuX61F9zkShsUkYU=</farebasiscode>"; //xmlRequest = xmlRequest + "<Rule>Cancellation Penalty: All bookings done are subject to the cancellation penalty levied by the respective airline.<br>In addition to the airline''s cancellation penalty, we charge a service fee of Rs. 200 per passenger for all cancellations.|Date Change Penalty: In addition to the airline''s date change penalty, we charge a service fee of Rs. 250 per passenger for any date changes.|</Rule>"; //xmlRequest = xmlRequest + "<PsgrBreakup>"; //xmlRequest = xmlRequest + "<PsgrAry>"; //xmlRequest = xmlRequest + "<Psgr>"; //xmlRequest = xmlRequest + "<PsgrType>ADT</PsgrType>"; //xmlRequest = xmlRequest + "<BaseFare>21250</BaseFare>"; //xmlRequest = xmlRequest + "<Tax>19675</Tax>"; //xmlRequest = xmlRequest + "<BagInfo />"; //xmlRequest = xmlRequest + "</Psgr>"; //xmlRequest = xmlRequest + "</PsgrAry>"; //xmlRequest = xmlRequest + "</PsgrBreakup>"; //xmlRequest = xmlRequest + "</BookingClassFare>"; //xmlRequest = xmlRequest + "</FlightSegment>"; //xmlRequest = xmlRequest + "</FlightSegments>"; //xmlRequest = xmlRequest + "</onward>"; //xmlRequest = xmlRequest + "<Return />"; //xmlRequest = xmlRequest + "<id>arzoo13</id>"; //xmlRequest = xmlRequest + "<key>"; //xmlRequest = xmlRequest + "zWbxBFyA059f68R2DgKcVEb0gG2ZuxB2eOVHvZcIhsrrFUGZlB/H443Le2GIKliKcDol4S0eYt5n"; //xmlRequest = xmlRequest + "4urlPHf4zwkxESOCSurS2zJT2fsu8E6Ny3thiCpYihRRnjyQGrh7hXWLu9m7LCssMPJ4Xz20E7cC"; //xmlRequest = xmlRequest + "U/hS9xGE+mdK+SICvYvDvXFXubDdIyuoEEf9FbAN4z7uuUBbuJWfy8uNPG/9b2fi6uU8d/jPtkPz"; //xmlRequest = xmlRequest + "+QotFGxf68R2DgKcVAxln+JT2sq20MHk4j4XRiE+dv3J10pg7QerGRHTwDoP0MHk4j4XRiFoKIn0"; //xmlRequest = xmlRequest + "f2tgo/6/bBnC356utwJT+FL3EYQxhMrs9+Ll73qUfflxOSlgjct7YYgqWIooknPUNPq0fsMbz0mC"; //xmlRequest = xmlRequest + "CnYdPxS/giio89vDvXFXubDdI5p3QtIQ6TM+X+vEdg4CnFSHVzKRaecmxRqaN5ZXELxy0MHk4j4X"; //xmlRequest = xmlRequest + "RiFoKIn0f2tgo08iYOkW5WfDVAdtvjUETBAUbFQMZCvw/rcCU/hS9xGEV/KirOjbVWVf68R2DgKc"; //xmlRequest = xmlRequest + "VIdXMpFp5ybFFnoP/rNoJySNy3thiCpYinP52+a6dCWv4z7uuUBbuJUr4zgoGssePSsZx2FQz4Qz"; //xmlRequest = xmlRequest + "Mi4GIKZ/bQN5v2nhdWyUxWkXlLIRnKfWBOVnFhmDx7P+RkIizk8EmY3Le2GIKliKvHScqTjHzQGF"; //xmlRequest = xmlRequest + "dYu72bssK9yA/LGYY4DttwJT+FL3EYR8llOd/AvvBcO9cVe5sN0jaHWZ74lyniM+CXHuBVUeI0eC"; //xmlRequest = xmlRequest + "jTlyW+v3IvPKAXmAs/XjPu65QFu4lRIiMi13yfqv0MHk4j4XRiFoKIn0f2tgo3rxF/w/vseO0MHk"; //xmlRequest = xmlRequest + "4j4XRiFoKIn0f2tgo08iYOkW5WfDtBFngPW6tS4UbFQMZCvw/rcCU/hS9xGEPmH+rCYA9GVn4url"; //xmlRequest = xmlRequest + "PHf4z/KpTLVv6TwZmq/OLBKU+urDvXFXubDdI76GeeoT8f7/mZIC7bwXLBPEyJNwmQ0Hhl/rxHYO"; //xmlRequest = xmlRequest + "ApxUwsS2F117BWpVx8rwsmCp/7cCU/hS9xGEO2M3JTnaOUPjPu65QFu4lcYxXFxB1Lxm2zJT2fsu"; //xmlRequest = xmlRequest + "8E6Ny3thiCpYiskg7jRgjK6SgNO9QJL9N+kUA6rZxn6L2roVT2rwaaIHT9JeYXDjtB74LCthwRi6"; //xmlRequest = xmlRequest + "QuM+7rlAW7iVci/YXLUgYhtn4urlPHf4z0sauaT5dh0YX+vEdg4CnFRm6meIMgjYjdDB5OI+F0Yh"; //xmlRequest = xmlRequest + "aCiJ9H9rYKMzmFBNkf0Z9F/rxHYOApxU8q6B7/fP8qZn4urlPHf4z6xCf1SAy2vSGs5/DTSC7BXj"; //xmlRequest = xmlRequest + "Pu65QFu4lXSi4I4fhBoPMaaYjNFAcsm3AlP4UvcRhPpnSvkiAr2Lw71xV7mw3SMrqBBH/RWwDeM+"; //xmlRequest = xmlRequest + "7rlAW7iVdKLgjh+EGg9kUDg3MAXg5eM+7rlAW7iV3nbymUm4szIU66LMw4VmWYV1i7vZuywr4wJX"; //xmlRequest = xmlRequest + "2WV2PV5f68R2DgKcVAxln+JT2sq20MHk4j4XRiEuvf9jqO9829DB5OI+F0YhE8ZmQzVYvJbgy4cv"; //xmlRequest = xmlRequest + "1MfIol/rxHYOApxUuPBYmR6Sgw5f68R2DgKcVCB0cQSVLEagT+e92o4/qz5f68R2DgKcVMcBF2dl"; //xmlRequest = xmlRequest + "btCnrziqklPvBLLl8OEMpKE9Rrqlvng58vzQsS7VmIqni8k6cEhUG/jNng=="; //xmlRequest = xmlRequest + "</key>"; //xmlRequest = xmlRequest + "</OriginDestinationOption>"; //xmlRequest = xmlRequest + "</Bookingrequest>"; #endregion StringBuilder stt = new StringBuilder(); stt.Append("xmlRequest"); stt.Append("="); stt.Append(Server.UrlEncode(xmlRequest)); byte[] requestData = Encoding.UTF8.GetBytes(stt.ToString()); HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://live.arzoo.com:9302/Booking"); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; request.Accept = "application/json"; request.ContentLength = requestData.Length; using (Stream requestStream = request.GetRequestStream()) { requestStream.Write(requestData, 0, requestData.Length); } using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { using (Stream stream = response.GetResponseStream()) { using (StreamReader reader = new StreamReader(stream, Encoding.ASCII)) result = reader.ReadToEnd(); XmlDocument doc = new XmlDocument(); doc.LoadXml(result); XmlNodeReader xmlReader = new XmlNodeReader(doc); ds.ReadXml(xmlReader); } } //result = "<Bookingresponse><OriginDestinationOption><FareDetails><ActualBaseFare>85035</ActualBaseFare><Tax>4079</Tax><STax>1055</STax><TCharge>0</TCharge><SCharge>0</SCharge><TDiscount>0</TDiscount><TMarkup>150</TMarkup><TPartnerCommission>0</TPartnerCommission><TSdiscount>0</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>ADT</PsgrType><BaseFare>85035</BaseFare><Tax>4079</Tax></Fare></FareAry></FareBreakup></FareDetails><onward><FlightSegments><FlightSegment><AirEquipType>77W</AirEquipType><ArrivalAirportCode>LHR</ArrivalAirportCode><ArrivalAirportName>LONDON<BR> (HEATHROW)</ArrivalAirportName><ArrivalDateTime>2010-02-26T06:35:00</ArrivalDateTime><DepartureAirportCode>BOM</DepartureAirportCode><DepartureAirportName>MUMBAI<BR> (CHHATRAPATI SHIVAJI INTERNATIONAL)</DepartureAirportName><DepartureDateTime>2010-02-26T02:05:00</DepartureDateTime><FlightNumber>4131</FlightNumber><MarketingAirlineCode>BD</MarketingAirlineCode><OperatingAirlineCode>BD</OperatingAirlineCode><OperatingAirlineName>British Midland</OperatingAirlineName><OperatingAirlineFlightNumber>4131</OperatingAirlineFlightNumber><NumStops>0</NumStops><LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>9</Availability><BIC>Y</BIC></BookingClass><BookingClassFare><bookingclass>Y</bookingclass><classType>Economy</classType><farebasiscode>rb8QAsvpFIPpZo9gBUBg+6BMOP0MtJ7L</farebasiscode><Rule></Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>85035</BaseFare><Tax>4079</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment><FlightSegment><AirEquipType>346</AirEquipType><ArrivalAirportCode>JFK</ArrivalAirportCode><ArrivalAirportName>NEW YORK<BR> (JOHN F KENNEDY INTL)</ArrivalAirportName><ArrivalDateTime>2010-02-26T12:20:00</ArrivalDateTime><DepartureAirportCode>LHR</DepartureAirportCode><DepartureAirportName>LONDON<BR> (HEATHROW)</DepartureAirportName><DepartureDateTime>2010-02-26T09:20:00</DepartureDateTime><FlightNumber>8223</FlightNumber><MarketingAirlineCode>CO</MarketingAirlineCode><OperatingAirlineCode>CO</OperatingAirlineCode><OperatingAirlineName>Continental Airlines </OperatingAirlineName><OperatingAirlineFlightNumber>8223</OperatingAirlineFlightNumber><NumStops>0</NumStops><LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>4</Availability><BIC>L</BIC></BookingClass><BookingClassFare><bookingclass>L</bookingclass><classType>Economy</classType><farebasiscode>rb8QAsvpFIPpZo9gBUBg+6BMOP0MtJ7L</farebasiscode><Rule></Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>85035</BaseFare><Tax>4079</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment></FlightSegments></onward><Return/><id>arzoo100</id><key>ayCbutV8CZjQweTiPhdGIT52/cnXSmDtWDF6uoVa0Yx+dIrODcZqUYV1i7vZuywrXxtmsFOjbi9n4urlPHf4zxGFVKSEVPuglBZfw/aOkGOFdYu72bssKyww8nhfPbQTtwJT+FL3EYT6Z0r5IgK9i8O9cVe5sN0jK6gQR/0VsA3jPu65QFu4leESvkw2tYVo0MHk4j4XRiFoKIn0f2tgo+sVQZmUH8fjjct7YYgqWIoUUZ48kBq4e/0pg3DmQVVVo2Q3a0AUQSXLUP1Wu6PBd4V1i7vZuywrSdRter3iPenjPu65QFu4lbsv+JV45WPGtyljvg7883Sh2gnY0OmCJCn868u75ToLhXWLu9m7LCuMmusGneSEdRuxNaSOsudhnGqNtXQ916PjPu65QFu4lU2r9RVG+D9a0MHk4j4XRiFoKIn0f2tgozK2rkfhSWEWx6xZaH0ssx82RPW27flqmu5f2a5HBe02z/lJy0jWbT0M1G6o3Y+hzWfi6uU8d/jPAJdXKqYIvc5G93zQPY0iVQD8L1fsyfdm6xVBmZQfx+ONy3thiCpYihlAiI3xsTJF4z7uuUBbuJUEGsOfbTr3UF/rxHYOApxUsDfYCka6IQumFoD34DG1PbcCU/hS9xGEMwKsr63khSb3Qspj6nxBZe9bfmEZ7GUgEriX6+12U2wkVz4JY1XabcCU/hS9xGEcUGtscRHmuLDvXFXubDdIz12g5QheQXO4z7uuUBbuJVmadCAqLb2y2fi6uU8d/jPS1i6Qoti3wtoJoL9ZE4l6rEu1ZiKp4vJfk8fwf1jcc9f68R2DgKcVK1lGTAnSPxSl9HJUgz+eC+FdYu72bssKzNAqSxshbWRYUz9VFYzmixqeExNPowVA78GaMTl9BYe0fUDu2DE3rHDvXFXubDdI3dYiTg2zkNgU+gGkoFGtlfAPC2FpjoIsV/rxHYOApxURZOpRI/EzoEVg7MnTiMjPoV1i7vZuywrp7AOSJb8tei2GAYztr4tGO6Udvv6goYtX+vEdg4CnFThuwJPu5BuYitpzzDzl21bJ/v5/y98kwILsR2pjhA21YV1i7vZuywrGJgEwhHzH+9n4urlPHf4zwMsIQITsGsy0MHk4j4XRiFoKIn0f2tgowznwUkbWS71w71xV7mw3SOi9DZLo5De59CaB/YiXgfO40U/DdrAcfnP5jcg4z9RPIZB8/lb/sd5w71xV7mw3SNZoQyFRfkMl+M+7rlAW7iVOm7uM/9yhhNn4urlPHf4z7kR+x0lYQ5LX+vEdg4CnFRKt+2PZYo+CjOuGPE4fK4oZ+Lq5Tx3+M9KeFGbag7+buM+7rlAW7iVdKLgjh+EGg8Mv3JUr8Yz2NNESEN0N1nFqHicn8G1rgW8dJypOMfNAYV1i7vZuywrLDDyeF89tBO3AlP4UvcRhPpnSvkiAr2L00RIQ3Q3WcWoeJyfwbWuBfSvd+pfPzkTw71xV7mw3SNdcG/zHitfN1rAgZFeAikBjct7YYgqWIpXyYBKr/eg5uM+7rlAW7iVygQsiztYTQ9f68R2DgKcVBCq+RQJHE/z</key></OriginDestinationOption><telePhone><phoneNumber>9879961339</phoneNumber></telePhone><email><emailAddress>[email protected]</emailAddress></email><noadults>1</noadults><nochild>0</nochild><noinfant>0</noinfant><Clientid>Given By Arzoo.com</Clientid><Clienttype>ArzooINTLWS1.0</Clienttype><creditcardno>1234567890123456</creditcardno><error></error><personName><CustomerInfo><givenName>Sagar</givenName><surName>Arora</surName><nameReference>Mr.</nameReference><psgrtype>adt</psgrtype></CustomerInfo></personName><status>SUCCESS</status><transid>A396009</transid></Bookingresponse>"; // XmlDocument doc = new XmlDocument(); // doc.LoadXml(result); // XmlNodeReader xmlReader = new XmlNodeReader(doc); // ds.ReadXml(xmlReader); } catch (Exception ex) { if (ex.Message.Contains("409")) { lblerror.Text = "Please contact administrator"; lblerror.Visible = true; } } return ds; }
private DataSet GetIntBookingRequest() { DataSet ds = new DataSet(); #region Variables string str = string.Empty; string FlightSegmentsID = string.Empty; string DepartureAirportCode = string.Empty; string ArrivalDateTime = string.Empty; string DepartureAirportName = string.Empty; string DepartureDateTime = string.Empty; string FlightNumber = string.Empty; string MarketingAirlineCode = string.Empty; string OperatingAirlineCode = string.Empty; string OperatingAirlineName = string.Empty; string OperatingAirlineFlightNumber = string.Empty; string NumStops = string.Empty; string LinkSellAgrmnt = string.Empty; string Conx = string.Empty; string AirpChg = string.Empty; string InsideAvailOption = string.Empty; string GenTrafRestriction = string.Empty; string DaysOperates = string.Empty; string JrnyTm = string.Empty; string EndDt = string.Empty; string StartTerminal = string.Empty; string EndTerminal = string.Empty; string FltTm = string.Empty; string LSAInd = string.Empty; string Mile = string.Empty; string Availability = string.Empty; string BIC = string.Empty; string bookingclass = string.Empty; string classType = string.Empty; string farebasiscode = string.Empty; string Rule = string.Empty; string PsgrType = string.Empty; string BaseFare = string.Empty; string Tax = string.Empty; string BagInfo = string.Empty; string AirEquipType = string.Empty; string ArrivalAirportCode = string.Empty; string ArrivalAirportName = string.Empty; string return1 = string.Empty; string id = string.Empty; string key = string.Empty; string ActualBaseFare = string.Empty; string FareTax = string.Empty; string STax = string.Empty; string TCharge = string.Empty; string SCharge = string.Empty; string TDiscount = string.Empty; string TMarkup = string.Empty; string TPartnerCommission = string.Empty; string TSdiscount = string.Empty; string FarePsgrType = string.Empty; string FareBaseFare = string.Empty; string FareTax1 = string.Empty; string Country = string.Empty; string Amt = string.Empty; string ocTax = string.Empty; string onwardId = string.Empty; string OriginDestinationOption_Id = string.Empty; string FareDetails_id = string.Empty; string FareBreakUp_Id = string.Empty; string FareAry_id = string.Empty; string FareId = string.Empty; string bookingclassFareId = string.Empty; string psgrBreakUp_Id = string.Empty; string psgrAy_id = string.Empty; string country = string.Empty; string taxAmt = string.Empty; string taxData = string.Empty; string taxDataAry_id = string.Empty; string faretype = string.Empty; string CFareId = string.Empty; string CPsgrType = string.Empty; string CBaseFare = string.Empty; string CFareTax = string.Empty; string IFareId = string.Empty; string IPsgrType = string.Empty; string IBaseFare = string.Empty; string IFareTax = string.Empty; string CFarePsgrType = string.Empty; string CFareBaseFare = string.Empty; string CFareTax1 = string.Empty; string CBagInfo = string.Empty; string IFarePsgrType = string.Empty; string IFareBaseFare = string.Empty; string IFareTax1 = string.Empty; string IBagInfo = string.Empty; string taxdatapsgr = string.Empty; #endregion try { dsIntFlights = (DataSet)Session["dsIntFlights"]; string result = null; DataTable dtFlightSegment = dsIntFlights.Tables[12]; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightSegment.Select("FlightSegment_ID=" + Convert.ToInt32(lblIntFlightSegmentId.Text)); FlightSegmentsID = rowFilghtSegment[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegments = dsIntFlights.Tables[11]; if (dtFlightSegments.Rows.Count > 0) { DataRow[] rowFilghtSegments = dtFlightSegments.Select("FlightSegments_ID=" + FlightSegmentsID); onwardId = rowFilghtSegments[0]["Onward_Id"].ToString(); } DataTable dtOnward = dsIntFlights.Tables[10]; if (dtOnward.Rows.Count > 0) { DataRow[] rowOnward = dtOnward.Select("Onward_Id=" + onwardId); OriginDestinationOption_Id = rowOnward[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtOriginDestinationOption = dsIntFlights.Tables[3]; if (dtOriginDestinationOption.Rows.Count > 0) { DataRow[] rowOriginDestinationOption = dtOriginDestinationOption.Select("OriginDestinationOption_Id=" + OriginDestinationOption_Id); return1 = rowOriginDestinationOption[0]["Return"].ToString(); id = rowOriginDestinationOption[0]["id"].ToString(); key = rowOriginDestinationOption[0]["key"].ToString(); } DataTable dtFareDetails = dsIntFlights.Tables[4]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("OriginDestinationOption_Id=" + OriginDestinationOption_Id); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } DataTable dtFareBreakUp = dsIntFlights.Tables[5]; if (dtFareBreakUp.Rows.Count > 0) { DataRow[] rowFareBreakUp = dtFareBreakUp.Select("FareDetails_Id=" + FareDetails_id); FareBreakUp_Id = rowFareBreakUp[0]["FareBreakUp_Id"].ToString(); } DataTable dtFareAry = dsIntFlights.Tables[6]; if (dtFareAry.Rows.Count > 0) { DataRow[] rowFareAry = dtFareAry.Select("FareBreakUp_Id=" + FareBreakUp_Id); FareAry_id = rowFareAry[0]["FareAry_id"].ToString(); } DataTable dtFare = dsIntFlights.Tables[7]; if (dtFare.Rows.Count > 0) { DataRow[] rowFare = dtFare.Select("FareAry_id=" + FareAry_id); PsgrType = rowFare[0]["PsgrType"].ToString(); BaseFare = rowFare[0]["BaseFare"].ToString(); FareTax = rowFare[0]["Tax"].ToString(); FareId = rowFare[0]["Fare_Id"].ToString(); Session["FareId"] = FareId.ToString(); foreach (DataRow dr in rowFare) { if (faretype == "") { faretype = dr["PsgrType"].ToString() + "," + dr["BaseFare"].ToString() + "," + dr["Tax"].ToString(); } else { faretype = faretype + ";" + dr["PsgrType"].ToString() + "," + dr["BaseFare"].ToString() + "," + dr["Tax"].ToString() + ";"; } } } DataTable dtBookingClass = dsIntFlights.Tables[13]; if (dtBookingClass.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass.Select("FlightSegment_Id=" + lblIntFlightSegmentId.Text); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } DataTable dtBookingClassFare = dsIntFlights.Tables[14]; if (dtBookingClassFare.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare.Select("FlightSegment_Id=" + lblIntFlightSegmentId.Text); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { bookingclassFareId = rowBookingClassFare[0]["bookingclassFare_Id"].ToString(); } } //Non Mandatory fields if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { DataTable dtPsgrBreakUp = dsIntFlights.Tables[15]; if (dtPsgrBreakUp.Rows.Count > 0) { DataRow[] rowPsgrBreakUp = dtPsgrBreakUp.Select("bookingclassFare_Id=" + bookingclassFareId); psgrBreakUp_Id = rowPsgrBreakUp[0]["psgrBreakUp_Id"].ToString(); } DataTable dtPsgrAry = dsIntFlights.Tables[16]; if (dtPsgrAry.Rows.Count > 0) { DataRow[] rowPsgrAry = dtPsgrAry.Select("psgrBreakUp_Id=" + psgrBreakUp_Id); psgrAy_id = rowPsgrAry[0]["psgrAry_Id"].ToString(); } DataTable dtPsgr = dsIntFlights.Tables[17]; if (dtPsgr.Rows.Count > 0) { DataRow[] rowPsgr = dtPsgr.Select("psgrAry_Id=" + psgrAy_id); FarePsgrType = rowPsgr[0]["psgrType"].ToString(); FareBaseFare = rowPsgr[0]["BaseFare"].ToString(); FareTax1 = rowPsgr[0]["Tax"].ToString(); BagInfo = rowPsgr[0]["BagInfo"].ToString(); //child //CFarePsgrType = rowPsgr[1]["psgrType"].ToString(); //CFareBaseFare = rowPsgr[1]["BaseFare"].ToString(); //CFareTax1 = rowPsgr[1]["Tax"].ToString(); //CBagInfo = rowPsgr[1]["BagInfo"].ToString(); ////infant //IFarePsgrType = rowPsgr[2]["psgrType"].ToString(); //IFareBaseFare = rowPsgr[2]["BaseFare"].ToString(); //IFareTax1 = rowPsgr[2]["Tax"].ToString(); //IBagInfo = rowPsgr[2]["BagInfo"].ToString(); } if (dtPsgr.Rows.Count > 0) { DataRow[] rowPsgr = dtPsgr.Select("psgrAry_Id=" + psgrAy_id); foreach (DataRow rows in rowPsgr) { if (rows.Table.Rows.Count == 0) { taxdatapsgr = "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } else { taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } } } } // <Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr> DataTable dtTaxDataAry = dsIntFlights.Tables[8]; if (dtTaxDataAry.Rows.Count > 0) { DataRow[] rowTaxDataAry = dtTaxDataAry.Select("Fare_id=" + FareId); taxDataAry_id = rowTaxDataAry[0]["TaxdataAry_Id"].ToString(); } DataTable dtTaxData = dsIntFlights.Tables[9]; if (dtTaxData.Rows.Count > 0) { DataRow[] rowTaxData = dtTaxData.Select("TaxdataAry_Id=" + taxDataAry_id); for (int j = 0; j < rowTaxData.Length; j++) { if (rowTaxData.Length == 0) { taxData = "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; } else { taxData = taxData + "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; //ravi // taxData = taxData + "<Fare><PsgrType>" + dtFare.Rows[j]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dtFare.Rows[j]["BaseFare"].ToString() + "</BaseFare><Tax>" + dtFare.Rows[j]["Tax"].ToString() + "</Tax><TaxDataAry><TaxData><Country>" + rowTaxData[0]["Country"].ToString() + "</Country><Amt>" + rowTaxData[0]["Amt"].ToString() + "</Amt></TaxData><TaxData><Country>" + rowTaxData[1]["Country"].ToString() + "</Country><Amt>" + rowTaxData[1]["Amt"].ToString() + "</Amt></TaxData><TaxData><Country>" + rowTaxData[2]["Country"].ToString() + "</Country><Amt>" + rowTaxData[2]["Amt"].ToString() + "</Amt></TaxData></TaxDataAry></Fare>"; } } } if (dtFare.Rows.Count > 0) { DataRow[] rowFare = dtFare.Select("FareAry_id=" + FareAry_id); foreach (DataRow row in rowFare) { if (row.Table.Rows.Count == 0) { str = "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax><TaxDataAry>" + taxData + "</TaxDataAry></Fare>"; } else { str = str + "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax><TaxDataAry>" + taxData + "</TaxDataAry></Fare>"; } } } bool res1 = false; if (Session["Role"].ToString() == "User") { //ravi db save FlightBAL objFlightBal = new FlightBAL(); String RefNo = Common.GetFlightsReferenceNo("LJIF"); Session["Order_Id"] = RefNo.ToString(); objFlightBal.ReferenceNo = RefNo.ToString(); objFlightBal.TransId = "0"; objFlightBal.Status = "Pending"; objFlightBal.AdultPax = Convert.ToInt32(Session["adultCntInt"]); objFlightBal.InfantPax = Convert.ToInt32(Session["infantCntInt"]); objFlightBal.ChildPax = Convert.ToInt32(Session["childCntInt"]); 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.TCharge = Convert.ToDecimal(TCharge); objFlightBal.Scharge = Convert.ToDecimal(SCharge); objFlightBal.TDiscount = Convert.ToDecimal(TDiscount); objFlightBal.TMarkUp = Convert.ToDecimal(TMarkup); objFlightBal.TPartnerCommission = Convert.ToDecimal(TPartnerCommission); objFlightBal.TSDiscount = Convert.ToDecimal(TSdiscount); objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); objFlightBal.TripMode = "One"; objFlightBal.ocTax = ocTax; objFlightBal.Return = return1; objFlightBal.id = id; objFlightBal.key = key; DataTable dtflightBookingId = objFlightBal.AddDInternationalFlightBooking(objFlightBal); Session["BookingID"] = dtflightBookingId.Rows[0]["FlightBookingID"].ToString(); //fegments string customerInfo = string.Empty; Table tbladults = (Table)this.UpdatePanel2.FindControl("tblAdultsInt"); for (int l = 1; l <= Convert.ToInt32(Session["adultCntInt"]); l++) { TextBox txtFn = (TextBox)tbladults.FindControl("txtFnInt" + l); TextBox txtLn = (TextBox)tbladults.FindControl("txtLnInt" + l); DropDownList ddlTitle = (DropDownList)tbladults.FindControl("ddlTitleInt" + 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 tblChild = (Table)this.UpdatePanel2.FindControl("tblChildInt"); for (int j = 1; j <= Convert.ToInt32(Session["childCntInt"]); j++) { TextBox txtFn = (TextBox)tblChild.FindControl("txtCFnInt" + j); TextBox txtLn = (TextBox)tblChild.FindControl("txtCLnInt" + j); DropDownList ddlTitle = (DropDownList)tblChild.FindControl("ddlCTitleInt" + j); TextBox txtBirthDate = (TextBox)tblChild.FindControl("txtCBirthDateInt" + 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; } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "chd" + "|" + age + "|" + txtBirthDate.Text; } // 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 tblInfants = (Table)this.UpdatePanel2.FindControl("tblInfantsInt"); for (int k = 1; k <= Convert.ToInt32(Session["infantCntInt"]); k++) { TextBox txtFn = (TextBox)tblInfants.FindControl("txtIFnInt" + k); TextBox txtLn = (TextBox)tblInfants.FindControl("txtILnInt" + k); DropDownList ddlTitle = (DropDownList)tblInfants.FindControl("ddlITitleInt" + k); TextBox txtBirthDate = (TextBox)tblInfants.FindControl("txtIBirthDateInt" + 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; } else { customerInfo = customerInfo + ";" + ddlTitle.SelectedItem.Text + "|" + txtFn.Text + "|" + txtLn.Text + "|" + "inf" + "|" + age + "|" + txtBirthDate.Text; } // 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>"; } if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); for (int j = 0; j < rowFilghtSegment.Length; j++) { AirEquipType = rowFilghtSegment[j]["AirEquipType"].ToString(); ArrivalAirportCode = rowFilghtSegment[j]["ArrivalAirportCode"].ToString(); ArrivalAirportName = rowFilghtSegment[j]["ArrivalAirportName"].ToString(); ArrivalDateTime = rowFilghtSegment[j]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFilghtSegment[j]["DepartureAirportCode"].ToString(); DepartureAirportName = rowFilghtSegment[j]["DepartureAirportName"].ToString(); DepartureDateTime = rowFilghtSegment[j]["DepartureDateTime"].ToString(); FlightNumber = rowFilghtSegment[j]["FlightNumber"].ToString(); MarketingAirlineCode = rowFilghtSegment[j]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = rowFilghtSegment[j]["OperatingAirlineCode"].ToString(); OperatingAirlineName = rowFilghtSegment[j]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = rowFilghtSegment[j]["OperatingAirlineFlightNumber"].ToString(); NumStops = rowFilghtSegment[j]["NumStops"].ToString(); LinkSellAgrmnt = rowFilghtSegment[j]["LinkSellAgrmnt"].ToString(); Conx = rowFilghtSegment[j]["Conx"].ToString(); AirpChg = rowFilghtSegment[j]["AirpChg"].ToString(); InsideAvailOption = rowFilghtSegment[j]["InsideAvailOption"].ToString(); GenTrafRestriction = rowFilghtSegment[j]["GenTrafRestriction"].ToString(); DaysOperates = rowFilghtSegment[j]["DaysOperates"].ToString(); JrnyTm = rowFilghtSegment[j]["JrnyTm"].ToString(); EndDt = rowFilghtSegment[j]["EndDt"].ToString(); StartTerminal = rowFilghtSegment[j]["StartTerminal"].ToString(); EndTerminal = rowFilghtSegment[j]["EndTerminal"].ToString(); FltTm = rowFilghtSegment[j]["FltTm"].ToString(); LSAInd = rowFilghtSegment[j]["LSAInd"].ToString(); Mile = rowFilghtSegment[j]["Mile"].ToString(); DataTable dtBookingClass1 = dsIntFlights.Tables[13]; if (dtBookingClass1.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } DataTable dtBookingClassFare1 = dsIntFlights.Tables[14]; if (dtBookingClassFare1.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); } // bookingclass = rowFilghtSegment[j]["LSAInd"].ToString(); // classType = rowFilghtSegment[j]["Mile"].ToString(); objFlightBal.FlightBookingID = dtflightBookingId.Rows[0]["FlightBookingID"].ToString();//Convert.ToString(Session["BookingID"]); objFlightBal.AirEquipType = AirEquipType; objFlightBal.ArrivalAirportCode = ArrivalAirportCode; objFlightBal.ArrivalAirportName = ArrivalAirportName; objFlightBal.ArrivalDateTime = ArrivalDateTime; objFlightBal.DepartureAirportCode = DepartureAirportCode; objFlightBal.DepartureAirportName = DepartureAirportName; objFlightBal.DepartureDateTime = DepartureDateTime; objFlightBal.FlightNumber = FlightNumber; objFlightBal.MarketingAirlineCode = MarketingAirlineCode; objFlightBal.OperatingAirlineCode = OperatingAirlineCode; objFlightBal.OperatingAirlineName = OperatingAirlineName; objFlightBal.OperatingAirlineFlightNumber = OperatingAirlineFlightNumber; objFlightBal.NumStops = NumStops; objFlightBal.LinkSellAgrmnt = LinkSellAgrmnt; objFlightBal.Conx = Conx; objFlightBal.AirpChg = AirpChg; objFlightBal.InsideAvailOption = InsideAvailOption; objFlightBal.GenTrafRestriction = GenTrafRestriction; objFlightBal.DaysOperates = DaysOperates; objFlightBal.JrnyTm = JrnyTm; objFlightBal.EndDt = EndDt; objFlightBal.StartTerminal = StartTerminal; objFlightBal.EndTerminal = EndTerminal; objFlightBal.FltTm = FltTm; objFlightBal.LSAInd = LSAInd; objFlightBal.Mile = Mile; objFlightBal.Availability = Availability; objFlightBal.BIC = BIC; objFlightBal.emailAddress = txtEmailIDInt.Text.Trim(); Session["EmailID"] = txtEmailIDInt.Text.Trim(); objFlightBal.telephone = txtMobileNumberInt.Text; Session["MobileNo"] = txtMobileNumberInt.Text; objFlightBal.CreatedBy = Convert.ToInt32(Session["UserID"]); objFlightBal.Customer_Details = customerInfo; objFlightBal.Address = txtCityInt.Text + "," + txtStateInt.Text + "," + ddlCountryInt.SelectedValue + "," + txtPostalCodeInt.Text + ","; Session["customerInfo"] = customerInfo; Session["Address"] = txtCityInt.Text + "," + txtStateInt.Text + "," + ddlCountryInt.SelectedValue + "," + txtPostalCodeInt.Text + ","; objFlightBal.bookingClass = bookingclass; objFlightBal.ClassType = classType; objFlightBal.farebasisCode = farebasiscode; objFlightBal.Fare_Rule = Rule; objFlightBal.PsgrType = FarePsgrType; objFlightBal.BaseFare = FareBaseFare; objFlightBal.psgrTax = FareTax1; objFlightBal.BagInfo = BagInfo; objFlightBal.FarePsgrType = faretype; res1 = objFlightBal.AddInternationalFlightSegment(objFlightBal); } } if (res1 == true) { Response.Redirect("~/pay.aspx?val=true", false); } //db save end } else { FlightBAL objFlightsBal = new FlightBAL(); #region Pricing // string XmlPricingRequest = "<PriceRequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax></Fare></FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>"; string XmlPricingRequest = "<PriceRequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>" + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>"; XmlPricingRequest = XmlPricingRequest + "<onward><FlightSegments>"; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); for (int j = 0; j < rowFilghtSegment.Length; j++) { AirEquipType = rowFilghtSegment[j]["AirEquipType"].ToString(); ArrivalAirportCode = rowFilghtSegment[j]["ArrivalAirportCode"].ToString(); ArrivalAirportName = rowFilghtSegment[j]["ArrivalAirportName"].ToString(); ArrivalDateTime = rowFilghtSegment[j]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFilghtSegment[j]["DepartureAirportCode"].ToString(); DepartureAirportName = rowFilghtSegment[j]["DepartureAirportName"].ToString(); DepartureDateTime = rowFilghtSegment[j]["DepartureDateTime"].ToString(); FlightNumber = rowFilghtSegment[j]["FlightNumber"].ToString(); MarketingAirlineCode = rowFilghtSegment[j]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = rowFilghtSegment[j]["OperatingAirlineCode"].ToString(); OperatingAirlineName = rowFilghtSegment[j]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = rowFilghtSegment[j]["OperatingAirlineFlightNumber"].ToString(); NumStops = rowFilghtSegment[j]["NumStops"].ToString(); LinkSellAgrmnt = rowFilghtSegment[j]["LinkSellAgrmnt"].ToString(); Conx = rowFilghtSegment[j]["Conx"].ToString(); AirpChg = rowFilghtSegment[j]["AirpChg"].ToString(); InsideAvailOption = rowFilghtSegment[j]["InsideAvailOption"].ToString(); GenTrafRestriction = rowFilghtSegment[j]["GenTrafRestriction"].ToString(); DaysOperates = rowFilghtSegment[j]["DaysOperates"].ToString(); JrnyTm = rowFilghtSegment[j]["JrnyTm"].ToString(); EndDt = rowFilghtSegment[j]["EndDt"].ToString(); StartTerminal = rowFilghtSegment[j]["StartTerminal"].ToString(); EndTerminal = rowFilghtSegment[j]["EndTerminal"].ToString(); FltTm = rowFilghtSegment[j]["FltTm"].ToString(); LSAInd = rowFilghtSegment[j]["LSAInd"].ToString(); Mile = rowFilghtSegment[j]["Mile"].ToString(); DataTable dtBookingClass1 = dsIntFlights.Tables[13]; if (dtBookingClass1.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } DataTable dtBookingClassFare1 = dsIntFlights.Tables[14]; if (dtBookingClassFare1.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); } XmlPricingRequest = XmlPricingRequest + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; XmlPricingRequest = XmlPricingRequest + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; // XmlPricingRequest = XmlPricingRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>"; XmlPricingRequest = XmlPricingRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { XmlPricingRequest = XmlPricingRequest + "<PsgrBreakup><PsgrAry>" + taxdatapsgr + "</PsgrAry></PsgrBreakup>"; } XmlPricingRequest = XmlPricingRequest + "</BookingClassFare></FlightSegment>"; } } XmlPricingRequest = XmlPricingRequest + "</FlightSegments></onward><Return>" + return1 + "</Return><id>" + id + "</id><key>" + key + "</key>"; XmlPricingRequest = XmlPricingRequest + "</OriginDestinationOption></PriceRequest>"; DataSet dsPricingResponse = objFlightsBal.GetDatasetFromAPI(XmlPricingRequest, "http://live.arzoo.com:9302/Pricing"); if (dsPricingResponse.Tables[0].Rows[0]["error"] == string.Empty) { // DataTable dtpricingflightsegment = dsPricingResponse.Tables DataTable dtpricingFlightSegment = dsPricingResponse.Tables["FlightSegment"]; if (dtpricingFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtpricingFlightSegment.Select("FlightSegment_ID=" + Convert.ToInt32(lblIntFlightSegmentId.Text)); FlightSegmentsID = rowFilghtSegment[0]["FlightSegments_Id"].ToString(); } DataTable dtpricingFlightSegments = dsPricingResponse.Tables["FlightSegments"]; if (dtpricingFlightSegments.Rows.Count > 0) { DataRow[] rowFilghtSegments = dtpricingFlightSegments.Select("FlightSegments_ID=" + FlightSegmentsID); onwardId = rowFilghtSegments[0]["Onward_Id"].ToString(); } DataTable dtpricingOnward = dsPricingResponse.Tables["onward"]; if (dtpricingOnward.Rows.Count > 0) { DataRow[] rowOnward = dtpricingOnward.Select("Onward_Id=" + onwardId); OriginDestinationOption_Id = rowOnward[0]["OriginDestinationOption_Id"].ToString(); } DataTable dtpricingFareDetails = dsIntFlights.Tables["FareDetails"]; if (dtFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtFareDetails.Select("OriginDestinationOption_Id=" + OriginDestinationOption_Id); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } } #endregion string ref1 = Common.GetFlightsReferenceNo("LJIF"); string xmlRequest = "<Bookingrequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><creditcardno></creditcardno><PartnerreferenceID>" + ref1 + "</PartnerreferenceID>"; xmlRequest = xmlRequest + "<personName>"; // Dynamic generation of names of adults, infants , Child Table tbladults = (Table)this.UpdatePanel2.FindControl("tblAdultsInt"); for (int i = 1; i <= Convert.ToInt32(Session["adultCntInt"]); i++) { TextBox txtFn = (TextBox)tbladults.FindControl("txtFnInt" + i); TextBox txtLn = (TextBox)tbladults.FindControl("txtLnInt" + i); DropDownList ddlTitle = (DropDownList)tbladults.FindControl("ddlTitleInt" + i); xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + txtFn.Text + "</givenName><surName>" + txtLn.Text + "</surName><nameReference>" + ddlTitle.SelectedItem.Value + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } Table tblChild = (Table)this.UpdatePanel2.FindControl("tblChildInt"); for (int i = 1; i <= Convert.ToInt32(Session["childCntInt"]); i++) { TextBox txtFn = (TextBox)tblChild.FindControl("txtCFnInt" + i); TextBox txtLn = (TextBox)tblChild.FindControl("txtCLnInt" + i); DropDownList ddlTitle = (DropDownList)tblChild.FindControl("ddlCTitleInt" + i); TextBox txtBirthDate = (TextBox)tblChild.FindControl("txtCBirthDateInt" + i); string age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); //if (Convert.ToInt32(age) > 5) //{ // Literal lit = new Literal(); // lit.Text = txtFn.Text + " Age between 3 - 5 yrs."; // this.Controls.Add(lit); // break; //} 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 tblInfants = (Table)this.UpdatePanel2.FindControl("tblInfantsInt"); for (int i = 1; i <= Convert.ToInt32(Session["infantCntInt"]); i++) { TextBox txtFn = (TextBox)tblInfants.FindControl("txtIFnInt" + i); TextBox txtLn = (TextBox)tblInfants.FindControl("txtILnInt" + i); DropDownList ddlTitle = (DropDownList)tblInfants.FindControl("ddlITitleInt" + i); TextBox txtBirthDate = (TextBox)tblInfants.FindControl("txtIBirthDateInt" + i); string age = string.Empty; if (txtBirthDate != null) age = (DateTime.Now.Year - Convert.ToDateTime(txtBirthDate.Text).Year).ToString(); else age = "0"; //if (Convert.ToInt32(age) == 12) //{ // Literal lit = new Literal(); // lit.Text = txtFn.Text + " Age should be below 1 yr."; // this.Controls.Add(lit); // break; //} 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>"; } xmlRequest = xmlRequest + "</personName><telePhone><phoneNumber>" + txtMobileNumInt.Text + "</phoneNumber></telePhone><email><emailAddress>" + txtEmailIDInt.Text + "</emailAddress></email>"; //xmlRequest = xmlRequest + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax><TaxDataAry>"; //xmlRequest = xmlRequest + taxData + "</TaxDataAry></Fare></FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails><onward><FlightSegments>"; xmlRequest = xmlRequest + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>"; xmlRequest = xmlRequest + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails><onward><FlightSegments>"; if (dtFlightSegment.Rows.Count > 0) { DataRow[] rowFilghtSegment = dtFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); for (int j = 0; j < rowFilghtSegment.Length; j++) { AirEquipType = rowFilghtSegment[j]["AirEquipType"].ToString(); ArrivalAirportCode = rowFilghtSegment[j]["ArrivalAirportCode"].ToString(); ArrivalAirportName = rowFilghtSegment[j]["ArrivalAirportName"].ToString(); ArrivalDateTime = rowFilghtSegment[j]["ArrivalDateTime"].ToString(); DepartureAirportCode = rowFilghtSegment[j]["DepartureAirportCode"].ToString(); DepartureAirportName = rowFilghtSegment[j]["DepartureAirportName"].ToString(); DepartureDateTime = rowFilghtSegment[j]["DepartureDateTime"].ToString(); FlightNumber = rowFilghtSegment[j]["FlightNumber"].ToString(); MarketingAirlineCode = rowFilghtSegment[j]["MarketingAirlineCode"].ToString(); OperatingAirlineCode = rowFilghtSegment[j]["OperatingAirlineCode"].ToString(); OperatingAirlineName = rowFilghtSegment[j]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = rowFilghtSegment[j]["OperatingAirlineFlightNumber"].ToString(); NumStops = rowFilghtSegment[j]["NumStops"].ToString(); LinkSellAgrmnt = rowFilghtSegment[j]["LinkSellAgrmnt"].ToString(); Conx = rowFilghtSegment[j]["Conx"].ToString(); AirpChg = rowFilghtSegment[j]["AirpChg"].ToString(); InsideAvailOption = rowFilghtSegment[j]["InsideAvailOption"].ToString(); GenTrafRestriction = rowFilghtSegment[j]["GenTrafRestriction"].ToString(); DaysOperates = rowFilghtSegment[j]["DaysOperates"].ToString(); JrnyTm = rowFilghtSegment[j]["JrnyTm"].ToString(); EndDt = rowFilghtSegment[j]["EndDt"].ToString(); StartTerminal = rowFilghtSegment[j]["StartTerminal"].ToString(); EndTerminal = rowFilghtSegment[j]["EndTerminal"].ToString(); FltTm = rowFilghtSegment[j]["FltTm"].ToString(); LSAInd = rowFilghtSegment[j]["LSAInd"].ToString(); Mile = rowFilghtSegment[j]["Mile"].ToString(); DataTable dtBookingClass1 = dsIntFlights.Tables[13]; if (dtBookingClass1.Rows.Count > 0) { DataRow[] rowBookingClass = dtBookingClass1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); Availability = rowBookingClass[0]["Availability"].ToString(); BIC = rowBookingClass[0]["BIC"].ToString(); } DataTable dtBookingClassFare1 = dsIntFlights.Tables[14]; if (dtBookingClassFare1.Rows.Count > 0) { DataRow[] rowBookingClassFare = dtBookingClassFare1.Select("FlightSegment_Id=" + rowFilghtSegment[j]["FlightSegment_Id"].ToString()); bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); classType = rowBookingClassFare[0]["classType"].ToString(); farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); Rule = rowBookingClassFare[0]["Rule"].ToString(); } xmlRequest = xmlRequest + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; xmlRequest = xmlRequest + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; xmlRequest = xmlRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule>"; if (dtBookingClassFare.Columns.Contains("bookingclassFare_Id")) { xmlRequest = xmlRequest + "<PsgrBreakup><PsgrAry><Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup>"; } xmlRequest = xmlRequest + "</BookingClassFare></FlightSegment>"; } } xmlRequest = xmlRequest + "</FlightSegments></onward><Return>" + return1 + "</Return><id>" + id + "</id><key>" + key + "</key>"; xmlRequest = xmlRequest + "</OriginDestinationOption></Bookingrequest>"; StringBuilder stt = new StringBuilder(); stt.Append("xmlRequest"); stt.Append("="); stt.Append(Server.UrlEncode(xmlRequest)); // stt.Append((xmlRequest).Replace("+", "%2B")); byte[] requestData = Encoding.UTF8.GetBytes(stt.ToString()); //byte[] requestData = System.Text.Encoding.UTF8.GetBytes(xmlRequest.Replace("+","%2B")); HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://live.arzoo.com:9302/Booking"); //request.Accept = @"text/plain,application/xml"; //request.ContentType = @"application/xml"; //request.Method = @"POST"; request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; request.Accept = "application/json"; // request.Accept = "en-us,en;q=0.5"; //request.ContentType = "multipart/form-data"; request.ContentLength = requestData.Length; using (Stream requestStream = request.GetRequestStream()) { requestStream.Write(requestData, 0, requestData.Length); } using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { using (Stream stream = response.GetResponseStream()) { using (StreamReader reader = new StreamReader(stream, Encoding.ASCII)) result = reader.ReadToEnd(); XmlDocument doc = new XmlDocument(); doc.LoadXml(result); XmlNodeReader xmlReader = new XmlNodeReader(doc); ds.ReadXml(xmlReader); } } //result = "<Bookingresponse><OriginDestinationOption><FareDetails><ActualBaseFare>85035</ActualBaseFare><Tax>4079</Tax><STax>1055</STax><TCharge>0</TCharge><SCharge>0</SCharge><TDiscount>0</TDiscount><TMarkup>150</TMarkup><TPartnerCommission>0</TPartnerCommission><TSdiscount>0</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>ADT</PsgrType><BaseFare>85035</BaseFare><Tax>4079</Tax></Fare></FareAry></FareBreakup></FareDetails><onward><FlightSegments><FlightSegment><AirEquipType>77W</AirEquipType><ArrivalAirportCode>LHR</ArrivalAirportCode><ArrivalAirportName>LONDON<BR> (HEATHROW)</ArrivalAirportName><ArrivalDateTime>2010-02-26T06:35:00</ArrivalDateTime><DepartureAirportCode>BOM</DepartureAirportCode><DepartureAirportName>MUMBAI<BR> (CHHATRAPATI SHIVAJI INTERNATIONAL)</DepartureAirportName><DepartureDateTime>2010-02-26T02:05:00</DepartureDateTime><FlightNumber>4131</FlightNumber><MarketingAirlineCode>BD</MarketingAirlineCode><OperatingAirlineCode>BD</OperatingAirlineCode><OperatingAirlineName>British Midland</OperatingAirlineName><OperatingAirlineFlightNumber>4131</OperatingAirlineFlightNumber><NumStops>0</NumStops><LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>9</Availability><BIC>Y</BIC></BookingClass><BookingClassFare><bookingclass>Y</bookingclass><classType>Economy</classType><farebasiscode>rb8QAsvpFIPpZo9gBUBg+6BMOP0MtJ7L</farebasiscode><Rule></Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>85035</BaseFare><Tax>4079</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment><FlightSegment><AirEquipType>346</AirEquipType><ArrivalAirportCode>JFK</ArrivalAirportCode><ArrivalAirportName>NEW YORK<BR> (JOHN F KENNEDY INTL)</ArrivalAirportName><ArrivalDateTime>2010-02-26T12:20:00</ArrivalDateTime><DepartureAirportCode>LHR</DepartureAirportCode><DepartureAirportName>LONDON<BR> (HEATHROW)</DepartureAirportName><DepartureDateTime>2010-02-26T09:20:00</DepartureDateTime><FlightNumber>8223</FlightNumber><MarketingAirlineCode>CO</MarketingAirlineCode><OperatingAirlineCode>CO</OperatingAirlineCode><OperatingAirlineName>Continental Airlines </OperatingAirlineName><OperatingAirlineFlightNumber>8223</OperatingAirlineFlightNumber><NumStops>0</NumStops><LinkSellAgrmnt></LinkSellAgrmnt><Conx>N</Conx><AirpChg>N</AirpChg><InsideAvailOption>C</InsideAvailOption><GenTrafRestriction>?</GenTrafRestriction><DaysOperates>NA</DaysOperates><JrnyTm></JrnyTm><EndDt></EndDt><StartTerminal></StartTerminal><EndTerminal></EndTerminal><FltTm>0</FltTm><LSAInd>R</LSAInd><Mile>0</Mile><BookingClass><Availability>4</Availability><BIC>L</BIC></BookingClass><BookingClassFare><bookingclass>L</bookingclass><classType>Economy</classType><farebasiscode>rb8QAsvpFIPpZo9gBUBg+6BMOP0MtJ7L</farebasiscode><Rule></Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>ADT</PsgrType><BaseFare>85035</BaseFare><Tax>4079</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment></FlightSegments></onward><Return/><id>arzoo100</id><key>ayCbutV8CZjQweTiPhdGIT52/cnXSmDtWDF6uoVa0Yx+dIrODcZqUYV1i7vZuywrXxtmsFOjbi9n4urlPHf4zxGFVKSEVPuglBZfw/aOkGOFdYu72bssKyww8nhfPbQTtwJT+FL3EYT6Z0r5IgK9i8O9cVe5sN0jK6gQR/0VsA3jPu65QFu4leESvkw2tYVo0MHk4j4XRiFoKIn0f2tgo+sVQZmUH8fjjct7YYgqWIoUUZ48kBq4e/0pg3DmQVVVo2Q3a0AUQSXLUP1Wu6PBd4V1i7vZuywrSdRter3iPenjPu65QFu4lbsv+JV45WPGtyljvg7883Sh2gnY0OmCJCn868u75ToLhXWLu9m7LCuMmusGneSEdRuxNaSOsudhnGqNtXQ916PjPu65QFu4lU2r9RVG+D9a0MHk4j4XRiFoKIn0f2tgozK2rkfhSWEWx6xZaH0ssx82RPW27flqmu5f2a5HBe02z/lJy0jWbT0M1G6o3Y+hzWfi6uU8d/jPAJdXKqYIvc5G93zQPY0iVQD8L1fsyfdm6xVBmZQfx+ONy3thiCpYihlAiI3xsTJF4z7uuUBbuJUEGsOfbTr3UF/rxHYOApxUsDfYCka6IQumFoD34DG1PbcCU/hS9xGEMwKsr63khSb3Qspj6nxBZe9bfmEZ7GUgEriX6+12U2wkVz4JY1XabcCU/hS9xGEcUGtscRHmuLDvXFXubDdIz12g5QheQXO4z7uuUBbuJVmadCAqLb2y2fi6uU8d/jPS1i6Qoti3wtoJoL9ZE4l6rEu1ZiKp4vJfk8fwf1jcc9f68R2DgKcVK1lGTAnSPxSl9HJUgz+eC+FdYu72bssKzNAqSxshbWRYUz9VFYzmixqeExNPowVA78GaMTl9BYe0fUDu2DE3rHDvXFXubDdI3dYiTg2zkNgU+gGkoFGtlfAPC2FpjoIsV/rxHYOApxURZOpRI/EzoEVg7MnTiMjPoV1i7vZuywrp7AOSJb8tei2GAYztr4tGO6Udvv6goYtX+vEdg4CnFThuwJPu5BuYitpzzDzl21bJ/v5/y98kwILsR2pjhA21YV1i7vZuywrGJgEwhHzH+9n4urlPHf4zwMsIQITsGsy0MHk4j4XRiFoKIn0f2tgowznwUkbWS71w71xV7mw3SOi9DZLo5De59CaB/YiXgfO40U/DdrAcfnP5jcg4z9RPIZB8/lb/sd5w71xV7mw3SNZoQyFRfkMl+M+7rlAW7iVOm7uM/9yhhNn4urlPHf4z7kR+x0lYQ5LX+vEdg4CnFRKt+2PZYo+CjOuGPE4fK4oZ+Lq5Tx3+M9KeFGbag7+buM+7rlAW7iVdKLgjh+EGg8Mv3JUr8Yz2NNESEN0N1nFqHicn8G1rgW8dJypOMfNAYV1i7vZuywrLDDyeF89tBO3AlP4UvcRhPpnSvkiAr2L00RIQ3Q3WcWoeJyfwbWuBfSvd+pfPzkTw71xV7mw3SNdcG/zHitfN1rAgZFeAikBjct7YYgqWIpXyYBKr/eg5uM+7rlAW7iVygQsiztYTQ9f68R2DgKcVBCq+RQJHE/z</key></OriginDestinationOption><telePhone><phoneNumber>9879961339</phoneNumber></telePhone><email><emailAddress>[email protected]</emailAddress></email><noadults>1</noadults><nochild>0</nochild><noinfant>0</noinfant><Clientid>Given By Arzoo.com</Clientid><Clienttype>ArzooINTLWS1.0</Clienttype><creditcardno>1234567890123456</creditcardno><error></error><personName><CustomerInfo><givenName>Sagar</givenName><surName>Arora</surName><nameReference>Mr.</nameReference><psgrtype>adt</psgrtype></CustomerInfo></personName><status>SUCCESS</status><transid>A396009</transid></Bookingresponse>"; // XmlDocument doc = new XmlDocument(); // doc.LoadXml(result); // XmlNodeReader xmlReader = new XmlNodeReader(doc); // ds.ReadXml(xmlReader); } } catch (Exception ex) { if (ex.Message.Contains("409")) { lblerror.Text = "Please contact administrator"; lblerror.Visible = true; } } return ds; }
protected void GetIntBookingStatus(string refNo) { try { DataSet ds = new DataSet(); FlightBAL objFlightBal = new FlightBAL(); string result = string.Empty; string EticketDetailsId = string.Empty; string givenName = string.Empty; string surName = string.Empty; string nameReference = string.Empty; string psgrType = string.Empty; string originDestinationOptionId = string.Empty; string onwardId = string.Empty; string FlightSegmentsId = string.Empty; string FlightSegmentId = string.Empty; string eticketdto_Id = string.Empty; string AirlinePNR = string.Empty; // ConfirmationId string GDFPNRNumber = string.Empty; //PNRNumber string eticketNo = string.Empty; string flightUid = string.Empty; string passuid = string.Empty; DataSet dsGetTransId = new DataSet(); dsGetTransId = objFlightBal.GetIntTransID(refNo); transId = dsGetTransId.Tables[0].Rows[0]["transid"].ToString(); String xmlRequest = "<EticketRequest><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><transid>" + transId + "</transid></EticketRequest>"; ds = objFlightBal.GetDatasetFromAPI(xmlRequest, "http://live.arzoo.com:9302/BookingStatus"); if (ds.Tables["EticketDetails"].Columns.Contains("EticketDetails_Id")) { EticketDetailsId = ds.Tables["EticketDetails"].Rows[0]["EticketDetails_Id"].ToString(); DataTable dtOriginDestinationOption = (DataTable)ds.Tables["OriginDestinationOption"]; if (dtOriginDestinationOption.Rows.Count > 0) { DataRow[] rowOriginDestinationOption = dtOriginDestinationOption.Select("eticketDetails_Id=" + EticketDetailsId); originDestinationOptionId = rowOriginDestinationOption[0]["originDestinationOption_Id"].ToString(); } DataTable dtOnward = (DataTable)ds.Tables["onward"]; if (dtOnward.Rows.Count > 0) { DataRow[] rowOnward = dtOnward.Select("originDestinationOption_Id=" + originDestinationOptionId); onwardId = rowOnward[0]["Onward_Id"].ToString(); } DataTable dtFlightSegments = (DataTable)ds.Tables["FlightSegments"]; if (dtFlightSegments.Rows.Count > 0) { DataRow[] rowFlightSegments = dtFlightSegments.Select("Onward_Id=" + onwardId); FlightSegmentsId = rowFlightSegments[0]["FlightSegments_Id"].ToString(); } DataTable dtFlightSegment = (DataTable)ds.Tables["FlightSegment"]; if (dtFlightSegment.Rows.Count > 0) { for (int i = 0; i < dtFlightSegment.Rows.Count; i++) { DataRow[] rowFlightSegment = dtFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsId); FlightSegmentId = rowFlightSegment[i]["FlightSegment_Id"].ToString(); AirlinePNR = (AirlinePNR == "") ? rowFlightSegment[i]["confirmationid"].ToString() : AirlinePNR + "|" + rowFlightSegment[i]["confirmationid"].ToString(); GDFPNRNumber = (GDFPNRNumber == "") ? rowFlightSegment[i]["pnrnumber"].ToString() : GDFPNRNumber + "|" + rowFlightSegment[i]["pnrnumber"].ToString(); DataTable dtEticketDto = (DataTable)ds.Tables["Eticketdto"]; if (dtEticketDto.Rows.Count > 0) { DataRow[] rowEticketdto = dtEticketDto.Select("FlightSegment_Id=" + FlightSegmentId); eticketdto_Id = rowEticketdto[0]["eticketdto_id"].ToString(); eticketNo = (eticketNo == "") ? rowEticketdto[i]["eticketno"].ToString() : eticketNo + "|" + rowEticketdto[i]["eticketno"].ToString(); flightUid = (flightUid == "") ? rowEticketdto[i]["flightuid"].ToString() : flightUid + "|" + rowEticketdto[i]["flightuid"].ToString(); passuid = (passuid == "") ? rowEticketdto[i]["passuid"].ToString() : passuid + "|" + rowEticketdto[i]["passuid"].ToString(); } } } string status = ds.Tables[0].Rows[0]["status"].ToString(); objFlightBal.Status = status; objFlightBal.TransId = transId; objFlightBal.ReferenceNo = refNo; objFlightBal.AirlinePNR = AirlinePNR; objFlightBal.GDFPNRNo = GDFPNRNumber; objFlightBal.passuid = passuid; objFlightBal.Flightuid = flightUid; objFlightBal.eticketNo = eticketNo; if (objFlightBal.Status == "SUCCESS") { statusCnt++; if (statusCnt < 3) { GetIntBookingStatus(refNo); } else { bool res = objFlightBal.UpdateInternationalFlightBookingStatus(objFlightBal); if (res) { lblStatus.Text = "Your ticket status is " + objFlightBal.Status; lblStatus.ForeColor = System.Drawing.Color.Green; } } } } else { lblStatus.Text = "Your ticket is under booking process"; } } catch (Exception ex) { } }
private DataSet methodround() { try { #region Variables string str = string.Empty; string FlightSegmentsID = string.Empty; string DepartureAirportCode = string.Empty; string ArrivalDateTime = string.Empty; string DepartureAirportName = string.Empty; string DepartureDateTime = string.Empty; string FlightNumber = string.Empty; string MarketingAirlineCode = string.Empty; string OperatingAirlineCode = string.Empty; string OperatingAirlineName = string.Empty; string OperatingAirlineFlightNumber = string.Empty; string NumStops = string.Empty; string LinkSellAgrmnt = string.Empty; string Conx = string.Empty; string AirpChg = string.Empty; string InsideAvailOption = string.Empty; string GenTrafRestriction = string.Empty; string DaysOperates = string.Empty; string JrnyTm = string.Empty; string EndDt = string.Empty; string StartTerminal = string.Empty; string EndTerminal = string.Empty; string FltTm = string.Empty; string LSAInd = string.Empty; string Mile = string.Empty; string Availability = string.Empty; string BIC = string.Empty; string bookingclass = string.Empty; string classType = string.Empty; string farebasiscode = string.Empty; string Rule = string.Empty; string PsgrType = string.Empty; string BaseFare = string.Empty; string Tax = string.Empty; string BagInfo = string.Empty; string AirEquipType = string.Empty; string ArrivalAirportCode = string.Empty; string ArrivalAirportName = string.Empty; string return1 = string.Empty; string id = string.Empty; string key = string.Empty; string ActualBaseFare = string.Empty; string FareTax = string.Empty; string STax = string.Empty; string TCharge = string.Empty; string SCharge = string.Empty; string TDiscount = string.Empty; string TMarkup = string.Empty; string TPartnerCommission = string.Empty; string TSdiscount = string.Empty; string FarePsgrType = string.Empty; string FareBaseFare = string.Empty; string FareTax1 = string.Empty; string Country = string.Empty; string Amt = string.Empty; string ocTax = string.Empty; string onwardId = string.Empty; string OriginDestinationOption_Id = string.Empty; string FareDetails_id = string.Empty; string FareBreakUp_Id = string.Empty; string FareAry_id = string.Empty; string FareId = string.Empty; string bookingclassFareId = string.Empty; string psgrBreakUp_Id = string.Empty; string psgrAy_id = string.Empty; string country = string.Empty; string taxAmt = string.Empty; string taxData = string.Empty; string taxDataAry_id = string.Empty; string returnId = string.Empty; string FlightSegmentsIDRet = string.Empty; string DepartureAirportCodeRet = string.Empty; string ArrivalDateTimeRet = string.Empty; string DepartureAirportNameRet = string.Empty; string DepartureDateTimeRet = string.Empty; string FlightNumberRet = string.Empty; string MarketingAirlineCodeRet = string.Empty; string OperatingAirlineCodeRet = string.Empty; string OperatingAirlineNameRet = string.Empty; string OperatingAirlineFlightNumberRet = string.Empty; string NumStopsRet = string.Empty; string LinkSellAgrmntRet = string.Empty; string ConxRet = string.Empty; string AirpChgRet = string.Empty; string InsideAvailOptionRet = string.Empty; string GenTrafRestrictionRet = string.Empty; string DaysOperatesRet = string.Empty; string JrnyTmRet = string.Empty; string EndDtRet = string.Empty; string StartTerminalRet = string.Empty; string EndTerminalRet = string.Empty; string FltTmRet = string.Empty; string LSAIndRet = string.Empty; string MileRet = string.Empty; string AvailabilityRet = string.Empty; string BICRet = string.Empty; string bookingclassRet = string.Empty; string classTypeRet = string.Empty; string farebasiscodeRet = string.Empty; string RuleRet = string.Empty; string PsgrTypeRet = string.Empty; string BaseFareRet = string.Empty; string TaxRet = string.Empty; string BagInfoRet = string.Empty; string AirEquipTypeRet = string.Empty; string ArrivalAirportCodeRet = string.Empty; string ArrivalAirportNameRet = string.Empty; string idRet = string.Empty; string keyRet = string.Empty; string ActualBaseFareRet = string.Empty; string FareTaxRet = string.Empty; string STaxRet = string.Empty; string TChargeRet = string.Empty; string SChargeRet = string.Empty; string TDiscountRet = string.Empty; string TMarkupRet = string.Empty; string TPartnerCommissionRet = string.Empty; string TSdiscountRet = string.Empty; string FarePsgrTypeRet = string.Empty; string FareBaseFareRet = string.Empty; string FareTax1Ret = string.Empty; string CountryRet = string.Empty; string AmtRet = string.Empty; string ocTaxRet = string.Empty; string onwardIdRet = string.Empty; string OriginDestinationOption_IdRet = string.Empty; string FareDetails_idRet = string.Empty; string FareBreakUp_IdRet = string.Empty; string FareAry_idRet = string.Empty; string FareIdRet = string.Empty; string bookingclassFareIdRet = string.Empty; string psgrBreakUp_IdRet = string.Empty; string psgrAy_idRet = string.Empty; string countryRet = string.Empty; string taxAmtRet = string.Empty; string taxDataRet = string.Empty; string taxDataAry_idRet = string.Empty; string returnIdRet = string.Empty; string taxdatapsgr = string.Empty; string taxdatapsgrRet = string.Empty; #endregion #region old //DataTable dtPricingreqFare = dsIntFlights.Tables["Fare"]; //if (dtPricingreqFare.Rows.Count > 0) //{ // DataRow[] rowFare = dtPricingreqFare.Select("FareAry_id=" + FareAry_id); // foreach (DataRow row in rowFare) // { // if (row.Table.Rows.Count == 0) // { // str = "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax></Fare>"; // } // else // { // str = str + "<Fare><PsgrType>" + row["PsgrType"].ToString() + "</PsgrType><BaseFare>" + row["BaseFare"].ToString() + "</BaseFare><Tax>" + row["Tax"].ToString() + "</Tax></Fare>";//<TaxDataAry>" + str + "</TaxDataAry> // } // } //} //FlightBAL objFlightsBal = new FlightBAL(); //string xmlpricingrequestforInt = "<PriceRequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype>"; //xmlpricingrequestforInt = xmlpricingrequestforInt + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>" + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>";//<Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax></Fare> //xmlpricingrequestforInt = xmlpricingrequestforInt + "<onward><FlightSegments>"; //DataTable dtpricingreqOnward = dsIntFlights.Tables["Onward"]; //if (dtpricingreqOnward.Rows.Count > 0) //{ // DataRow[] rowOnward = dtpricingreqOnward.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); // onwardId = rowOnward[0]["onward_id"].ToString(); //} //DataTable dtpricingreqFlightSegments = dsIntFlights.Tables["FlightSegments"]; //if (dtpricingreqFlightSegments.Rows.Count > 0) //{ // DataRow[] rowFlightSegments = dtpricingreqFlightSegments.Select("onward_id=" + onwardId); // FlightSegmentsID = rowFlightSegments[0]["FlightSegments_Id"].ToString(); //} //DataTable dtpricingreqFlightSegment = dsIntFlights.Tables["FlightSegment"]; //DataTable dtpricingreqBookingClass = dsIntFlights.Tables["BookingClass"]; //DataTable dtpricingreqBookingClassFare = dsIntFlights.Tables["BookingClassFare"]; //DataTable dtpricingreqPsgrBreakUp = dsIntFlights.Tables["PsgrBreakUp"]; //DataTable dtpricingreqPsgrAry = dsIntFlights.Tables["PsgrAry"]; //DataTable dtpricingreqPsgr = dsIntFlights.Tables["Psgr"]; //DataTable dtpricingreqTaxDataAry = dsIntFlights.Tables["TaxDataAry"]; //DataTable dtpricingreqTaxData = dsIntFlights.Tables["TaxData"]; //if (dtpricingreqFlightSegment.Rows.Count > 0) //{ // DataRow[] rowFlightSegment = dtpricingreqFlightSegment.Select("FlightSegments_Id=" + FlightSegmentsID); // for (int i = 0; i < rowFlightSegment.Length; i++) // { // AirEquipType = rowFlightSegment[i]["AirEquipType"].ToString(); // ArrivalAirportCode = rowFlightSegment[i]["ArrivalAirportCode"].ToString(); // ArrivalAirportName = rowFlightSegment[i]["ArrivalAirportName"].ToString(); // ArrivalDateTime = rowFlightSegment[i]["ArrivalDateTime"].ToString(); // DepartureAirportCode = rowFlightSegment[i]["DepartureAirportCode"].ToString(); // DepartureAirportName = rowFlightSegment[i]["DepartureAirportName"].ToString(); // DepartureDateTime = rowFlightSegment[i]["DepartureDateTime"].ToString(); // FlightNumber = rowFlightSegment[i]["FlightNumber"].ToString(); // MarketingAirlineCode = rowFlightSegment[i]["MarketingAirlineCode"].ToString(); // OperatingAirlineCode = rowFlightSegment[i]["OperatingAirlineCode"].ToString(); // OperatingAirlineName = rowFlightSegment[i]["OperatingAirlineName"].ToString(); // OperatingAirlineFlightNumber = rowFlightSegment[i]["OperatingAirlineFlightNumber"].ToString(); // NumStops = rowFlightSegment[i]["NumStops"].ToString(); // LinkSellAgrmnt = rowFlightSegment[i]["LinkSellAgrmnt"].ToString(); // Conx = rowFlightSegment[i]["Conx"].ToString(); // AirpChg = rowFlightSegment[i]["AirpChg"].ToString(); // InsideAvailOption = rowFlightSegment[i]["InsideAvailOption"].ToString(); // GenTrafRestriction = rowFlightSegment[i]["GenTrafRestriction"].ToString(); // DaysOperates = rowFlightSegment[i]["DaysOperates"].ToString(); // JrnyTm = rowFlightSegment[i]["JrnyTm"].ToString(); // EndDt = rowFlightSegment[i]["EndDt"].ToString(); // StartTerminal = rowFlightSegment[i]["StartTerminal"].ToString(); // EndTerminal = rowFlightSegment[i]["EndTerminal"].ToString(); // FltTm = rowFlightSegment[i]["FltTm"].ToString(); // LSAInd = rowFlightSegment[i]["LSAInd"].ToString(); // Mile = rowFlightSegment[i]["Mile"].ToString(); // if (dtpricingreqBookingClass.Rows.Count > 0) // { // DataRow[] rowBookingClass = dtpricingreqBookingClass.Select("FlightSegment_Id=" + rowFlightSegment[i]["FlightSegment_Id"].ToString()); // Availability = rowBookingClass[0]["Availability"].ToString(); // BIC = rowBookingClass[0]["BIC"].ToString(); // } // if (dtpricingreqBookingClassFare.Rows.Count > 0) // { // DataRow[] rowBookingClassFare = dtpricingreqBookingClassFare.Select("FlightSegment_Id=" + rowFlightSegment[i]["FlightSegment_Id"].ToString()); // bookingclass = rowBookingClassFare[0]["bookingclass"].ToString(); // classType = rowBookingClassFare[0]["classType"].ToString(); // farebasiscode = rowBookingClassFare[0]["farebasiscode"].ToString(); // Rule = rowBookingClassFare[0]["Rule"].ToString(); // bookingclassFareId = rowBookingClassFare[0]["bookingclassFare_Id"].ToString(); // } // if (dtpricingreqPsgrBreakUp.Rows.Count > 0) // { // DataRow[] rowPsgrBreakUp = dtpricingreqPsgrBreakUp.Select("bookingclassFare_Id=" + bookingclassFareId); // psgrBreakUp_Id = rowPsgrBreakUp[0]["psgrBreakUp_Id"].ToString(); // } // if (dtpricingreqPsgrAry.Rows.Count > 0) // { // DataRow[] rowPsgrAry = dtpricingreqPsgrAry.Select("psgrBreakUp_Id=" + psgrBreakUp_Id); // psgrAy_id = rowPsgrAry[0]["psgrAry_Id"].ToString(); // } // if (dtpricingreqPsgr.Rows.Count > 0) // { // DataRow[] rowPsgr = dtpricingreqPsgr.Select("psgrAry_Id=" + psgrAy_id); // FarePsgrType = rowPsgr[0]["psgrType"].ToString(); // FareBaseFare = rowPsgr[0]["BaseFare"].ToString(); // FareTax1 = rowPsgr[0]["Tax"].ToString(); // BagInfo = rowPsgr[0]["BagInfo"].ToString(); // } // if (dtpricingreqTaxDataAry.Rows.Count > 0) // { // DataRow[] rowTaxDataAry = dtpricingreqTaxDataAry.Select("Fare_id=" + FareId); // taxDataAry_id = rowTaxDataAry[0]["TaxdataAry_Id"].ToString(); // } // if (dtpricingreqTaxData.Rows.Count > 0) // { // DataRow[] rowTaxData = dtpricingreqTaxData.Select("TaxdataAry_Id=" + taxDataAry_id); // for (int j = 0; j < rowTaxData.Length; j++) // { // if (rowTaxData.Length == 0) // { // taxData = "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; // } // else // { // taxData = taxData + "<TaxData><Country>" + rowTaxData[j]["Country"].ToString() + "</Country><Amt>" + rowTaxData[j]["Amt"].ToString() + "</Amt></TaxData>"; // } // } // } // if (dtpricingreqPsgr.Rows.Count > 0) // { // DataRow[] rowPsgr = dtpricingreqPsgr.Select("psgrAry_Id=" + psgrAy_id); // foreach (DataRow rows in rowPsgr) // { // if (rows.Table.Rows.Count == 0) // { // taxdatapsgr = "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; // } // else // { // taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; // } // } // } // xmlpricingrequestforInt = xmlpricingrequestforInt + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; // xmlpricingrequestforInt = xmlpricingrequestforInt + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; // xmlpricingrequestforInt = xmlpricingrequestforInt + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry>" + taxdatapsgr + "</PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr> // } //} #endregion DataSet ds = new DataSet(); FlightBAL objFlightsBal = new FlightBAL(); string ReferenceNo = Convert.ToString(Session["Order_Id"]); DataSet dtid = objFlightsBal.FGetInternationalFlightDetails(ReferenceNo); #region oneway // return1 = dtid.Tables[0].Rows[0]["Return1"].ToString(); id1 = dtid.Tables[0].Rows[0]["id"].ToString(); key = dtid.Tables[0].Rows[0]["Key1"].ToString(); string[] actualBaseFare = dtid.Tables[0].Rows[0]["ActualBasefare"].ToString().Split('.'); ActualBaseFare = actualBaseFare[0].ToString(); string[] tx = dtid.Tables[0].Rows[0]["Tax"].ToString().Split('.'); Tax = tx[0].ToString(); string[] stx = dtid.Tables[0].Rows[0]["STax"].ToString().Split('.'); STax = stx[0].ToString(); string[] schrge = dtid.Tables[0].Rows[0]["Scharge"].ToString().Split('.'); SCharge = schrge[0].ToString(); string[] tdis = dtid.Tables[0].Rows[0]["TDiscount"].ToString().Split('.'); TDiscount = tdis[0].ToString(); string[] tpartcomm = dtid.Tables[0].Rows[0]["TPartnerCommission"].ToString().Split('.'); TPartnerCommission = tpartcomm[0].ToString(); string[] tsdisc = dtid.Tables[0].Rows[0]["TSDiscount"].ToString().Split('.'); TSdiscount = tsdisc[0].ToString(); ocTax = dtid.Tables[0].Rows[0]["Octax"].ToString(); string[] tmrkup = dtid.Tables[0].Rows[0]["TMarkUp"].ToString().Split('.'); TMarkup = tmrkup[0].ToString(); string[] tchge = dtid.Tables[0].Rows[0]["TCharge"].ToString().Split('.'); TCharge = tchge[0].ToString(); string ReferenceNo1 = dtid.Tables[0].Rows[0]["Int_Booking_Id"].ToString(); DataSet dsdbsave = objFlightsBal.GetInternationalFlightDetails1(ReferenceNo1); if (dsdbsave.Tables.Count > 0) { if (dsdbsave.Tables[0].Rows.Count > 0) { //foreach (DataRow row in dsdbsave.Tables[0].Rows) //{ if (dsdbsave.Tables[0].Rows[0]["FarePsgrType"].ToString().Contains(";")) { rows = dsdbsave.Tables[0].Rows[0]["FarePsgrType"].ToString().Split(';'); int count = rows.Count(); for (int i = 0; i < count; i++) { if (rows[i].Contains("|")) { string[] str2 = rows[i].ToString().Split('|'); Irows = str2.ToString().Split(','); } else { Irows = rows[i].ToString().Split(','); } // Irows = rows.ToString().Split(','); if (str == "") { str = "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>"; //taxdatapsgr = "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[0]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[0]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[0]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } else { if (Irows[0].ToString() == "") { } else { str = str + "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>";//<TaxDataAry>" + str + "</TaxDataAry> // taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[0]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[0]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[0]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } } } } else { Irows = dsdbsave.Tables[0].Rows[0]["FarePsgrType"].ToString().Split(','); // Irows = rows.ToString().Split(','); if (str == "") { str = "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>"; //taxdatapsgr = "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[0]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[0]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[0]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } else { str = str + "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>";//<TaxDataAry>" + str + "</TaxDataAry> // taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[0]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[0]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[0]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgr = taxdatapsgr + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } } //} // string XmlPricingRequest = "<PriceRequest><noadults>" + ddlAdultsInt.SelectedValue + "</noadults><nochild>" + ddlChildsInt.SelectedValue + "</nochild><noinfant>" + ddlInfantsInt.SelectedValue + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax></Fare></FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>"; xmlpricingrequestforInt = "<PriceRequest><noadults>" + dtid.Tables[0].Rows[0]["AdultPax"].ToString() + "</noadults><nochild>" + dtid.Tables[0].Rows[0]["ChildPax"].ToString() + "</nochild><noinfant>" + dtid.Tables[0].Rows[0]["InfantPax"].ToString() + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>" + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<onward><FlightSegments>"; //foreach (DataRow row in dsdbsave.Tables[0].Rows) //{ 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(); OperatingAirlineName = dsdbsave.Tables[0].Rows[0]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = dsdbsave.Tables[0].Rows[0]["OperatingAirlineFlightNumber"].ToString(); NumStops = dsdbsave.Tables[0].Rows[0]["NumStops"].ToString(); LinkSellAgrmnt = dsdbsave.Tables[0].Rows[0]["LinkSellAgrmnt"].ToString(); Conx = dsdbsave.Tables[0].Rows[0]["Conx"].ToString(); AirpChg = dsdbsave.Tables[0].Rows[0]["AirpChg"].ToString(); InsideAvailOption = dsdbsave.Tables[0].Rows[0]["InsideAvailOption"].ToString(); GenTrafRestriction = dsdbsave.Tables[0].Rows[0]["GenTrafRestriction"].ToString(); DaysOperates = dsdbsave.Tables[0].Rows[0]["DaysOperates"].ToString(); JrnyTm = dsdbsave.Tables[0].Rows[0]["JrnyTm"].ToString(); EndDt = dsdbsave.Tables[0].Rows[0]["EndDt"].ToString(); StartTerminal = dsdbsave.Tables[0].Rows[0]["StartTerminal"].ToString(); EndTerminal = dsdbsave.Tables[0].Rows[0]["EndTerminal"].ToString(); FltTm = dsdbsave.Tables[0].Rows[0]["FltTm"].ToString(); LSAInd = dsdbsave.Tables[0].Rows[0]["LSAInd"].ToString(); Mile = dsdbsave.Tables[0].Rows[0]["Mile"].ToString(); Availability = dsdbsave.Tables[0].Rows[0]["Availability"].ToString(); BIC = dsdbsave.Tables[0].Rows[0]["BIC"].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(); Rule = dsdbsave.Tables[0].Rows[0]["Fare_Rule"].ToString(); FarePsgrType = dsdbsave.Tables[0].Rows[0]["PsgrType"].ToString(); FareBaseFare = dsdbsave.Tables[0].Rows[0]["BaseFare"].ToString(); FareTax1 = dsdbsave.Tables[0].Rows[0]["psgrTax"].ToString(); BagInfo = dsdbsave.Tables[0].Rows[0]["BagInfo"].ToString(); xmlpricingrequestforInt = xmlpricingrequestforInt + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; // xmlpricingrequestforInt = xmlpricingrequestforInt + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry><Psgr><PsgrType>" + FarePsgrType + "</PsgrType><BaseFare>" + FareBaseFare + "</BaseFare><Tax>" + FareTax1 + "</Tax><BagInfo></BagInfo></Psgr></PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry>" + taxdatapsgr + "</PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>"; // } } } #endregion xmlpricingrequestforInt = xmlpricingrequestforInt + "</FlightSegments></onward><Return><FlightSegments>"; #region old return //DataTable dtpricingreqReturn = dsIntFlights.Tables["Return"]; //if (dtpricingreqReturn.Rows.Count > 0) //{ // DataRow[] rowReturn = dtpricingreqReturn.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); // returnId = rowReturn[0]["return_id"].ToString(); //} //DataTable dtpricingreqFlightSegmentsRet = dsIntFlights.Tables["FlightSegments"]; //if (dtpricingreqFlightSegmentsRet.Rows.Count > 0) //{ // DataRow[] rowFlightSegmentsRet = dtpricingreqFlightSegmentsRet.Select("return_id=" + returnId); // FlightSegmentsIDRet = rowFlightSegmentsRet[0]["FlightSegments_Id"].ToString(); //} //DataTable dtpricingreqFlightSegmentRet = dsIntFlights.Tables["FlightSegment"]; //DataTable dtpricingreqBookingClassRet = dsIntFlights.Tables["BookingClass"]; //DataTable dtpricingreqBookingClassFareRet = dsIntFlights.Tables["BookingClassFare"]; //DataTable dtpricingreqPsgrBreakUpRet = dsIntFlights.Tables["PsgrBreakUp"]; //DataTable dtpricingreqPsgrAryRet = dsIntFlights.Tables["PsgrAry"]; //DataTable dtpricingreqPsgrRet = dsIntFlights.Tables["Psgr"]; //DataTable dtpricingreqTaxDataAryRet = dsIntFlights.Tables["TaxDataAry"]; //DataTable dtpricingreqTaxDataRet = dsIntFlights.Tables["TaxData"]; //if (dtpricingreqFlightSegmentRet.Rows.Count > 0) //{ // DataRow[] rowFlightSegmentRet = dtpricingreqFlightSegmentRet.Select("FlightSegments_Id=" + FlightSegmentsIDRet); // for (int i = 0; i < rowFlightSegmentRet.Length; i++) // { // AirEquipTypeRet = rowFlightSegmentRet[i]["AirEquipType"].ToString(); // ArrivalAirportCodeRet = rowFlightSegmentRet[i]["ArrivalAirportCode"].ToString(); // ArrivalAirportNameRet = rowFlightSegmentRet[i]["ArrivalAirportName"].ToString(); // ArrivalDateTimeRet = rowFlightSegmentRet[i]["ArrivalDateTime"].ToString(); // DepartureAirportCodeRet = rowFlightSegmentRet[i]["DepartureAirportCode"].ToString(); // DepartureAirportNameRet = rowFlightSegmentRet[i]["DepartureAirportName"].ToString(); // DepartureDateTimeRet = rowFlightSegmentRet[i]["DepartureDateTime"].ToString(); // FlightNumberRet = rowFlightSegmentRet[i]["FlightNumber"].ToString(); // MarketingAirlineCodeRet = rowFlightSegmentRet[i]["MarketingAirlineCode"].ToString(); // OperatingAirlineCodeRet = rowFlightSegmentRet[i]["OperatingAirlineCode"].ToString(); // OperatingAirlineNameRet = rowFlightSegmentRet[i]["OperatingAirlineName"].ToString(); // OperatingAirlineFlightNumberRet = rowFlightSegmentRet[i]["OperatingAirlineFlightNumber"].ToString(); // NumStopsRet = rowFlightSegmentRet[i]["NumStops"].ToString(); // LinkSellAgrmntRet = rowFlightSegmentRet[i]["LinkSellAgrmnt"].ToString(); // ConxRet = rowFlightSegmentRet[i]["Conx"].ToString(); // AirpChgRet = rowFlightSegmentRet[i]["AirpChg"].ToString(); // InsideAvailOptionRet = rowFlightSegmentRet[i]["InsideAvailOption"].ToString(); // GenTrafRestrictionRet = rowFlightSegmentRet[i]["GenTrafRestriction"].ToString(); // DaysOperatesRet = rowFlightSegmentRet[i]["DaysOperates"].ToString(); // JrnyTmRet = rowFlightSegmentRet[i]["JrnyTm"].ToString(); // EndDtRet = rowFlightSegmentRet[i]["EndDt"].ToString(); // StartTerminalRet = rowFlightSegmentRet[i]["StartTerminal"].ToString(); // EndTerminalRet = rowFlightSegmentRet[i]["EndTerminal"].ToString(); // FltTmRet = rowFlightSegmentRet[i]["FltTm"].ToString(); // LSAIndRet = rowFlightSegmentRet[i]["LSAInd"].ToString(); // MileRet = rowFlightSegmentRet[i]["Mile"].ToString(); // if (dtpricingreqBookingClassRet.Rows.Count > 0) // { // DataRow[] rowBookingClassRet = dtpricingreqBookingClassRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); // AvailabilityRet = rowBookingClassRet[0]["Availability"].ToString(); // BICRet = rowBookingClassRet[0]["BIC"].ToString(); // } // if (dtpricingreqBookingClassFareRet.Rows.Count > 0) // { // DataRow[] rowBookingClassFareRet = dtpricingreqBookingClassFareRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); // bookingclassRet = rowBookingClassFareRet[0]["bookingclass"].ToString(); // classTypeRet = rowBookingClassFareRet[0]["classType"].ToString(); // farebasiscodeRet = rowBookingClassFareRet[0]["farebasiscode"].ToString(); // RuleRet = rowBookingClassFareRet[0]["Rule"].ToString(); // bookingclassFareIdRet = rowBookingClassFareRet[0]["bookingclassFare_Id"].ToString(); // } // if (dtpricingreqPsgrBreakUpRet.Rows.Count > 0) // { // DataRow[] rowPsgrBreakUpRet = dtpricingreqPsgrBreakUpRet.Select("bookingclassFare_Id=" + bookingclassFareIdRet); // psgrBreakUp_IdRet = rowPsgrBreakUpRet[0]["psgrBreakUp_Id"].ToString(); // } // if (dtpricingreqPsgrAryRet.Rows.Count > 0) // { // DataRow[] rowPsgrAryRet = dtpricingreqPsgrAryRet.Select("psgrBreakUp_Id=" + psgrBreakUp_IdRet); // psgrAy_idRet = rowPsgrAryRet[0]["psgrAry_Id"].ToString(); // } // if (dtpricingreqPsgrRet.Rows.Count > 0) // { // DataRow[] rowPsgrRet = dtpricingreqPsgrRet.Select("psgrAry_Id=" + psgrAy_idRet); // FarePsgrTypeRet = rowPsgrRet[0]["psgrType"].ToString(); // FareBaseFareRet = rowPsgrRet[0]["BaseFare"].ToString(); // FareTax1Ret = rowPsgrRet[0]["Tax"].ToString(); // BagInfoRet = rowPsgrRet[0]["BagInfo"].ToString(); // } // if (dtpricingreqPsgrRet.Rows.Count > 0) // { // DataRow[] rowPsgr = dtpricingreqPsgrRet.Select("psgrAry_Id=" + psgrAy_idRet); // foreach (DataRow rows in rowPsgr) // { // if (rows.Table.Rows.Count == 0) // { // taxdatapsgrRet = "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; // } // else // { // taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + rows["psgrType"].ToString() + "</PsgrType><BaseFare>" + rows["BaseFare"].ToString() + "</BaseFare><Tax>" + rows["Tax"].ToString() + "</Tax><BagInfo>" + rows["BagInfo"].ToString() + "</BagInfo></Psgr>"; // } // } // } // xmlpricingrequestforInt = xmlpricingrequestforInt + "<FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportNameRet + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportNameRet + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber>"; // xmlpricingrequestforInt = xmlpricingrequestforInt + "<MarketingAirlineCode>" + MarketingAirlineCodeRet + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineNameRet + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><NumStops>" + NumStopsRet + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmntRet + "</LinkSellAgrmnt><Conx>" + ConxRet + "</Conx><AirpChg>" + AirpChgRet + "</AirpChg><InsideAvailOption>" + InsideAvailOptionRet + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestrictionRet + "</GenTrafRestriction><DaysOperates>" + DaysOperatesRet + "</DaysOperates><JrnyTm>" + JrnyTmRet + "</JrnyTm><EndDt>" + EndDtRet + "</EndDt><StartTerminal>" + StartTerminalRet + "</StartTerminal><EndTerminal>" + EndTerminalRet + "</EndTerminal>"; // xmlpricingrequestforInt = xmlpricingrequestforInt + "<FltTm>" + FltTmRet + "</FltTm><LSAInd>" + LSAIndRet + "</LSAInd><Mile>" + MileRet + "</Mile><BookingClass><Availability>" + AvailabilityRet + "</Availability><BIC>" + BICRet + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclassRet + "</bookingclass><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><Rule>" + RuleRet.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry>" + taxdatapsgrRet + "</PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrTypeRet + "</PsgrType><BaseFare>" + FareBaseFareRet + "</BaseFare><Tax>" + FareTax1Ret + "</Tax><BagInfo></BagInfo></Psgr> // } //} #endregion #region return //idRet = dtid.Tables[0].Rows[1]["id"].ToString(); //keyRet = dtid.Tables[0].Rows[1]["Key1"].ToString(); //ActualBaseFareRet = dtid.Tables[0].Rows[1]["ActualBasefare"].ToString(); //TaxRet = dtid.Tables[0].Rows[1]["Tax"].ToString(); //STaxRet = dtid.Tables[0].Rows[1]["STax"].ToString(); //SChargeRet = dtid.Tables[0].Rows[1]["Scharge"].ToString(); //TDiscountRet = dtid.Tables[0].Rows[1]["TDiscount"].ToString(); //TPartnerCommissionRet = dtid.Tables[0].Rows[1]["TPartnerCommission"].ToString(); //TSdiscountRet = dtid.Tables[0].Rows[1]["TSDiscount"].ToString(); //ocTaxRet = dtid.Tables[0].Rows[1]["Octax"].ToString(); //TMarkupRet = dtid.Tables[0].Rows[1]["TMarkUp"].ToString(); //TChargeRet = dtid.Tables[0].Rows[1]["TCharge"].ToString(); //string ReferenceNo2 = dtid.Tables[0].Rows[1]["Int_Booking_Id"].ToString(); //DataSet dsdbsaveRet = objFlightsBal.GetInternationalFlightDetails1(ReferenceNo2); if (dsdbsave.Tables.Count > 0) { if (dsdbsave.Tables[0].Rows.Count > 0) { //foreach (DataRow row in dsdbsave.Tables[0].Rows) //{ str = ""; if (dsdbsave.Tables[0].Rows[1]["FarePsgrType"].ToString().Contains(";")) { rows = dsdbsave.Tables[0].Rows[1]["FarePsgrType"].ToString().Split(';'); int count = rows.Count(); for (int i = 0; i < count; i++) { if (rows.Contains("|")) { string[] str2 = rows[i].ToString().Split('|'); Irows = str2.ToString().Split(','); } else { Irows = rows[i].ToString().Split(','); } // Irows = rows.ToString().Split(','); if (str == "") { str = "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>"; // taxdatapsgrRet = "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[1]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[1]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[1]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } else { if (Irows[0].ToString() == "") { } else { str = str + "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>";//<TaxDataAry>" + str + "</TaxDataAry> // taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[1]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[1]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[1]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } } } } else { Irows = dsdbsave.Tables[0].Rows[0]["FarePsgrType"].ToString().Split(','); // Irows = rows.ToString().Split(','); if (str == "") { str = "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>"; // taxdatapsgrRet = "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[1]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[1]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[1]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } else { str = str + "<Fare><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax></Fare>";//<TaxDataAry>" + str + "</TaxDataAry> // taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + dsdbsave.Tables[0].Rows[1]["PsgrType"].ToString() + "</PsgrType><BaseFare>" + dsdbsave.Tables[0].Rows[1]["BaseFare"].ToString() + "</BaseFare><Tax>" + dsdbsave.Tables[0].Rows[1]["psgrTax"].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; taxdatapsgrRet = taxdatapsgrRet + "<Psgr><PsgrType>" + Irows[0].ToString() + "</PsgrType><BaseFare>" + Irows[1].ToString() + "</BaseFare><Tax>" + Irows[2].ToString() + "</Tax><BagInfo></BagInfo></Psgr>"; } } // foreach (DataRow row in dsdbsave.Tables[0].Rows) //{ AirEquipTypeRet = dsdbsave.Tables[0].Rows[1]["AirEquipType"].ToString(); ArrivalAirportCodeRet = dsdbsave.Tables[0].Rows[1]["ArrivalAirportCode"].ToString(); ArrivalAirportNameRet = dsdbsave.Tables[0].Rows[1]["ArrivalAirportName"].ToString(); ArrivalDateTimeRet = dsdbsave.Tables[0].Rows[1]["ArrivalDateTime"].ToString(); DepartureAirportCodeRet = dsdbsave.Tables[0].Rows[1]["DepartureAirportCode"].ToString(); DepartureAirportNameRet = dsdbsave.Tables[0].Rows[1]["DepartureAirportName"].ToString(); DepartureDateTimeRet = dsdbsave.Tables[0].Rows[1]["DepartureDateTime"].ToString(); FlightNumberRet = dsdbsave.Tables[0].Rows[1]["FlightNumber"].ToString(); MarketingAirlineCodeRet = dsdbsave.Tables[0].Rows[1]["MarketingAirlineCode"].ToString(); OperatingAirlineCodeRet = dsdbsave.Tables[0].Rows[1]["OperatingAirlineCode"].ToString(); OperatingAirlineNameRet = dsdbsave.Tables[0].Rows[1]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumberRet = dsdbsave.Tables[0].Rows[1]["OperatingAirlineFlightNumber"].ToString(); NumStopsRet = dsdbsave.Tables[0].Rows[1]["NumStops"].ToString(); LinkSellAgrmntRet = dsdbsave.Tables[0].Rows[1]["LinkSellAgrmnt"].ToString(); ConxRet = dsdbsave.Tables[0].Rows[1]["Conx"].ToString(); AirpChgRet = dsdbsave.Tables[0].Rows[1]["AirpChg"].ToString(); InsideAvailOptionRet = dsdbsave.Tables[0].Rows[1]["InsideAvailOption"].ToString(); GenTrafRestrictionRet = dsdbsave.Tables[0].Rows[1]["GenTrafRestriction"].ToString(); DaysOperatesRet = dsdbsave.Tables[0].Rows[1]["DaysOperates"].ToString(); JrnyTmRet = dsdbsave.Tables[0].Rows[1]["JrnyTm"].ToString(); EndDtRet = dsdbsave.Tables[0].Rows[1]["EndDt"].ToString(); StartTerminalRet = dsdbsave.Tables[0].Rows[1]["StartTerminal"].ToString(); EndTerminalRet = dsdbsave.Tables[0].Rows[1]["EndTerminal"].ToString(); FltTmRet = dsdbsave.Tables[0].Rows[1]["FltTm"].ToString(); LSAIndRet = dsdbsave.Tables[0].Rows[1]["LSAInd"].ToString(); MileRet = dsdbsave.Tables[0].Rows[1]["Mile"].ToString(); AvailabilityRet = dsdbsave.Tables[0].Rows[1]["Availability"].ToString(); BICRet = dsdbsave.Tables[0].Rows[1]["BIC"].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(); RuleRet = dsdbsave.Tables[0].Rows[1]["Fare_Rule"].ToString(); FarePsgrTypeRet = dsdbsave.Tables[0].Rows[1]["PsgrType"].ToString(); FareBaseFareRet = dsdbsave.Tables[0].Rows[1]["BaseFare"].ToString(); FareTax1Ret = dsdbsave.Tables[0].Rows[1]["psgrTax"].ToString(); BagInfoRet = dsdbsave.Tables[0].Rows[1]["BagInfo"].ToString(); xmlpricingrequestforInt = xmlpricingrequestforInt + "<FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportNameRet + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportNameRet + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<MarketingAirlineCode>" + MarketingAirlineCodeRet + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineNameRet + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><NumStops>" + NumStopsRet + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmntRet + "</LinkSellAgrmnt><Conx>" + ConxRet + "</Conx><AirpChg>" + AirpChgRet + "</AirpChg><InsideAvailOption>" + InsideAvailOptionRet + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestrictionRet + "</GenTrafRestriction><DaysOperates>" + DaysOperatesRet + "</DaysOperates><JrnyTm>" + JrnyTmRet + "</JrnyTm><EndDt>" + EndDtRet + "</EndDt><StartTerminal>" + StartTerminalRet + "</StartTerminal><EndTerminal>" + EndTerminalRet + "</EndTerminal>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "<FltTm>" + FltTmRet + "</FltTm><LSAInd>" + LSAIndRet + "</LSAInd><Mile>" + MileRet + "</Mile><BookingClass><Availability>" + AvailabilityRet + "</Availability><BIC>" + BICRet + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclassRet + "</bookingclass><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><Rule>" + RuleRet.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry>" + taxdatapsgrRet + "</PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrTypeRet + "</PsgrType><BaseFare>" + FareBaseFareRet + "</BaseFare><Tax>" + FareTax1Ret + "</Tax><BagInfo></BagInfo></Psgr> #endregion xmlpricingrequestforInt = xmlpricingrequestforInt + "</FlightSegments></Return><id>" + id1 + "</id><key>" + key + "</key>"; xmlpricingrequestforInt = xmlpricingrequestforInt + "</OriginDestinationOption></PriceRequest>"; DataSet dsPricingResponse = objFlightsBal.GetDatasetFromAPI(xmlpricingrequestforInt, "http://59.162.33.102:9301/Pricing"); if (dsPricingResponse != null) { if (dsPricingResponse.Tables.Count > 0) { if (!dsPricingResponse.Tables[0].Columns.Contains("error")) { DataTable dtpricingresFareDetails = dsPricingResponse.Tables["FareDetails"]; if (dtpricingresFareDetails.Rows.Count > 0) { DataRow[] rowFareDetails = dtpricingresFareDetails.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); ActualBaseFare = rowFareDetails[0]["ActualBaseFare"].ToString(); Tax = rowFareDetails[0]["Tax"].ToString(); STax = rowFareDetails[0]["STax"].ToString(); TCharge = rowFareDetails[0]["TCharge"].ToString(); SCharge = rowFareDetails[0]["SCharge"].ToString(); TDiscount = rowFareDetails[0]["TDiscount"].ToString(); TMarkup = rowFareDetails[0]["TMarkup"].ToString(); TPartnerCommission = rowFareDetails[0]["TPartnerCommission"].ToString(); TSdiscount = rowFareDetails[0]["TSdiscount"].ToString(); ocTax = rowFareDetails[0]["ocTax"].ToString(); FareDetails_id = rowFareDetails[0]["FareDetails_id"].ToString(); } } } } } } #endregion string xmlRequest; #region new bookrequest onward string ref1 = Session["Order_Id"].ToString(); xmlRequest = "<Bookingrequest><noadults>" + dtid.Tables[0].Rows[0]["AdultPax"].ToString() + "</noadults><nochild>" + dtid.Tables[0].Rows[0]["ChildPax"].ToString() + "</nochild><noinfant>" + dtid.Tables[0].Rows[0]["InfantPax"].ToString() + "</noinfant><Clientid>" + FlightsConstants.USERID + "</Clientid><Clientpassword>" + FlightsConstants.PASSWORD + "</Clientpassword><Clienttype>ArzooINTLWS1.0</Clienttype><creditcardno></creditcardno><PartnerreferenceID>" + ref1 + "</PartnerreferenceID>"; xmlRequest = xmlRequest + "<personName>"; ///details changing // string strname = Convert.ToString(Session["customerInfo"]); string strname = dsdbsave.Tables[0].Rows[0]["CustomerDetails"].ToString(); string[] strrows = strname.ToString().Split(';'); int id2 = strrows.Count(); for (int m = 0; m < id2; m++) { if (strrows[m].Contains("adt")) { string[] stradt = strrows[m].ToString().Split('|'); xmlRequest = xmlRequest + "<CustomerInfo><givenName>" + stradt[1].ToString() + "</givenName><surName>" + stradt[2].ToString() + "</surName><nameReference>" + stradt[0].ToString() + "</nameReference><psgrtype>adt</psgrtype></CustomerInfo>"; } if (strrows[m].Contains("chd")) { string[] strchd = strrows[m].ToString().Split('|'); xmlRequest = xmlRequest + "<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].Contains("inf")) { string[] strinf = strrows[m].ToString().Split('|'); xmlRequest = xmlRequest + "<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>"; } } xmlRequest = xmlRequest + "</personName><telePhone><phoneNumber>" + dsdbsave.Tables[0].Rows[0]["Telephone"].ToString() + "</phoneNumber></telePhone><email><emailAddress>" + dsdbsave.Tables[0].Rows[0]["EmailAddress"].ToString() + "</emailAddress></email>"; //xmlRequest = xmlRequest + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry><Fare><PsgrType>" + PsgrType + "</PsgrType><BaseFare>" + BaseFare + "</BaseFare><Tax>" + FareTax + "</Tax><TaxDataAry>"; //xmlRequest = xmlRequest + taxData + "</TaxDataAry></Fare></FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails><onward><FlightSegments>"; xmlRequest = xmlRequest + "<OriginDestinationOption><FareDetails><ActualBaseFare>" + ActualBaseFare + "</ActualBaseFare><Tax>" + Tax + "</Tax><STax>" + STax + "</STax><TCharge>" + TCharge + "</TCharge><SCharge>" + SCharge + "</SCharge><TDiscount>" + TDiscount + "</TDiscount><TMarkup>" + TMarkup + "</TMarkup><TPartnerCommission>" + TPartnerCommission + "</TPartnerCommission><TSdiscount>" + TSdiscount + "</TSdiscount><FareBreakup><FareAry>"; xmlRequest = xmlRequest + str + "</FareAry></FareBreakup><ocTax>" + ocTax + "</ocTax></FareDetails><onward><FlightSegments>"; //foreach (DataRow row in dsdbsave.Tables[0].Rows) //{ 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(); OperatingAirlineName = dsdbsave.Tables[0].Rows[0]["OperatingAirlineName"].ToString(); OperatingAirlineFlightNumber = dsdbsave.Tables[0].Rows[0]["OperatingAirlineFlightNumber"].ToString(); NumStops = dsdbsave.Tables[0].Rows[0]["NumStops"].ToString(); LinkSellAgrmnt = dsdbsave.Tables[0].Rows[0]["LinkSellAgrmnt"].ToString(); Conx = dsdbsave.Tables[0].Rows[0]["Conx"].ToString(); AirpChg = dsdbsave.Tables[0].Rows[0]["AirpChg"].ToString(); InsideAvailOption = dsdbsave.Tables[0].Rows[0]["InsideAvailOption"].ToString(); GenTrafRestriction = dsdbsave.Tables[0].Rows[0]["GenTrafRestriction"].ToString(); DaysOperates = dsdbsave.Tables[0].Rows[0]["DaysOperates"].ToString(); JrnyTm = dsdbsave.Tables[0].Rows[0]["JrnyTm"].ToString(); EndDt = dsdbsave.Tables[0].Rows[0]["EndDt"].ToString(); StartTerminal = dsdbsave.Tables[0].Rows[0]["StartTerminal"].ToString(); EndTerminal = dsdbsave.Tables[0].Rows[0]["EndTerminal"].ToString(); FltTm = dsdbsave.Tables[0].Rows[0]["FltTm"].ToString(); LSAInd = dsdbsave.Tables[0].Rows[0]["LSAInd"].ToString(); Mile = dsdbsave.Tables[0].Rows[0]["Mile"].ToString(); Availability = dsdbsave.Tables[0].Rows[0]["Availability"].ToString(); BIC = dsdbsave.Tables[0].Rows[0]["BIC"].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(); Rule = dsdbsave.Tables[0].Rows[0]["Fare_Rule"].ToString(); FarePsgrType = dsdbsave.Tables[0].Rows[0]["PsgrType"].ToString(); FareBaseFare = dsdbsave.Tables[0].Rows[0]["BaseFare"].ToString(); FareTax1 = dsdbsave.Tables[0].Rows[0]["psgrTax"].ToString(); BagInfo = dsdbsave.Tables[0].Rows[0]["BagInfo"].ToString(); xmlRequest = xmlRequest + "<FlightSegment><AirEquipType>" + AirEquipType + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCode + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportName + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTime + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCode + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportName + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTime + "</DepartureDateTime><FlightNumber>" + FlightNumber + "</FlightNumber>"; xmlRequest = xmlRequest + "<MarketingAirlineCode>" + MarketingAirlineCode + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCode + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineName + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumber + "</OperatingAirlineFlightNumber><NumStops>" + NumStops + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmnt + "</LinkSellAgrmnt><Conx>" + Conx + "</Conx><AirpChg>" + AirpChg + "</AirpChg><InsideAvailOption>" + InsideAvailOption + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestriction + "</GenTrafRestriction><DaysOperates>" + DaysOperates + "</DaysOperates><JrnyTm>" + JrnyTm + "</JrnyTm><EndDt>" + EndDt + "</EndDt><StartTerminal>" + StartTerminal + "</StartTerminal><EndTerminal>" + EndTerminal + "</EndTerminal>"; xmlRequest = xmlRequest + "<FltTm>" + FltTm + "</FltTm><LSAInd>" + LSAInd + "</LSAInd><Mile>" + Mile + "</Mile><BookingClass><Availability>" + Availability + "</Availability><BIC>" + BIC + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclass + "</bookingclass><classType>" + classType + "</classType><farebasiscode>" + farebasiscode + "</farebasiscode><Rule>" + Rule.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry>" + taxdatapsgrRet + "</PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>"; // } #endregion xmlRequest = xmlRequest + "</FlightSegments></onward><Return><FlightSegments>"; #region old return //DataTable dtReturn = dsIntFlights.Tables["Return"]; //if (dtReturn.Rows.Count > 0) //{ // DataRow[] rowReturn = dtReturn.Select("OriginDestinationOption_Id=" + lblOriginDestinationRoundTrip.Text); // returnId = rowReturn[0]["return_id"].ToString(); //} //DataTable dtFlightSegmentsRet = dsIntFlights.Tables["FlightSegments"]; //if (dtFlightSegmentsRet.Rows.Count > 0) //{ // DataRow[] rowFlightSegmentsRet = dtFlightSegmentsRet.Select("return_id=" + returnId); // FlightSegmentsIDRet = rowFlightSegmentsRet[0]["FlightSegments_Id"].ToString(); //} //DataTable dtFlightSegmentRet = dsIntFlights.Tables["FlightSegment"]; //DataTable dtBookingClassRet = dsIntFlights.Tables["BookingClass"]; //DataTable dtBookingClassFareRet = dsIntFlights.Tables["BookingClassFare"]; //DataTable dtPsgrBreakUpRet = dsIntFlights.Tables["PsgrBreakUp"]; //DataTable dtPsgrAryRet = dsIntFlights.Tables["PsgrAry"]; //DataTable dtPsgrRet = dsIntFlights.Tables["Psgr"]; //DataTable dtTaxDataAryRet = dsIntFlights.Tables["TaxDataAry"]; //DataTable dtTaxDataRet = dsIntFlights.Tables["TaxData"]; //if (dtFlightSegmentRet.Rows.Count > 0) //{ // DataRow[] rowFlightSegmentRet = dtFlightSegmentRet.Select("FlightSegments_Id=" + FlightSegmentsIDRet); // for (int i = 0; i < rowFlightSegmentRet.Length; i++) // { // AirEquipTypeRet = rowFlightSegmentRet[i]["AirEquipType"].ToString(); // ArrivalAirportCodeRet = rowFlightSegmentRet[i]["ArrivalAirportCode"].ToString(); // ArrivalAirportNameRet = rowFlightSegmentRet[i]["ArrivalAirportName"].ToString(); // ArrivalDateTimeRet = rowFlightSegmentRet[i]["ArrivalDateTime"].ToString(); // DepartureAirportCodeRet = rowFlightSegmentRet[i]["DepartureAirportCode"].ToString(); // DepartureAirportNameRet = rowFlightSegmentRet[i]["DepartureAirportName"].ToString(); // DepartureDateTimeRet = rowFlightSegmentRet[i]["DepartureDateTime"].ToString(); // FlightNumberRet = rowFlightSegmentRet[i]["FlightNumber"].ToString(); // MarketingAirlineCodeRet = rowFlightSegmentRet[i]["MarketingAirlineCode"].ToString(); // OperatingAirlineCodeRet = rowFlightSegmentRet[i]["OperatingAirlineCode"].ToString(); // OperatingAirlineNameRet = rowFlightSegmentRet[i]["OperatingAirlineName"].ToString(); // OperatingAirlineFlightNumberRet = rowFlightSegmentRet[i]["OperatingAirlineFlightNumber"].ToString(); // NumStopsRet = rowFlightSegmentRet[i]["NumStops"].ToString(); // LinkSellAgrmntRet = rowFlightSegmentRet[i]["LinkSellAgrmnt"].ToString(); // ConxRet = rowFlightSegmentRet[i]["Conx"].ToString(); // AirpChgRet = rowFlightSegmentRet[i]["AirpChg"].ToString(); // InsideAvailOptionRet = rowFlightSegmentRet[i]["InsideAvailOption"].ToString(); // GenTrafRestrictionRet = rowFlightSegmentRet[i]["GenTrafRestriction"].ToString(); // DaysOperatesRet = rowFlightSegmentRet[i]["DaysOperates"].ToString(); // JrnyTmRet = rowFlightSegmentRet[i]["JrnyTm"].ToString(); // EndDtRet = rowFlightSegmentRet[i]["EndDt"].ToString(); // StartTerminalRet = rowFlightSegmentRet[i]["StartTerminal"].ToString(); // EndTerminalRet = rowFlightSegmentRet[i]["EndTerminal"].ToString(); // FltTmRet = rowFlightSegmentRet[i]["FltTm"].ToString(); // LSAIndRet = rowFlightSegmentRet[i]["LSAInd"].ToString(); // MileRet = rowFlightSegmentRet[i]["Mile"].ToString(); // if (dtBookingClassRet.Rows.Count > 0) // { // DataRow[] rowBookingClassRet = dtBookingClassRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); // AvailabilityRet = rowBookingClassRet[0]["Availability"].ToString(); // BICRet = rowBookingClassRet[0]["BIC"].ToString(); // } // if (dtBookingClassFareRet.Rows.Count > 0) // { // DataRow[] rowBookingClassFareRet = dtBookingClassFareRet.Select("FlightSegment_Id=" + rowFlightSegmentRet[i]["FlightSegment_Id"].ToString()); // bookingclassRet = rowBookingClassFareRet[0]["bookingclass"].ToString(); // classTypeRet = rowBookingClassFareRet[0]["classType"].ToString(); // farebasiscodeRet = rowBookingClassFareRet[0]["farebasiscode"].ToString(); // RuleRet = rowBookingClassFareRet[0]["Rule"].ToString(); // bookingclassFareIdRet = rowBookingClassFareRet[0]["bookingclassFare_Id"].ToString(); // } // if (dtPsgrBreakUpRet.Rows.Count > 0) // { // DataRow[] rowPsgrBreakUpRet = dtPsgrBreakUpRet.Select("bookingclassFare_Id=" + bookingclassFareIdRet); // psgrBreakUp_IdRet = rowPsgrBreakUpRet[0]["psgrBreakUp_Id"].ToString(); // } // if (dtPsgrAryRet.Rows.Count > 0) // { // DataRow[] rowPsgrAryRet = dtPsgrAryRet.Select("psgrBreakUp_Id=" + psgrBreakUp_IdRet); // psgrAy_idRet = rowPsgrAryRet[0]["psgrAry_Id"].ToString(); // } // if (dtPsgrRet.Rows.Count > 0) // { // DataRow[] rowPsgrRet = dtPsgrRet.Select("psgrAry_Id=" + psgrAy_idRet); // FarePsgrTypeRet = rowPsgrRet[0]["psgrType"].ToString(); // FareBaseFareRet = rowPsgrRet[0]["BaseFare"].ToString(); // FareTax1Ret = rowPsgrRet[0]["Tax"].ToString(); // BagInfoRet = rowPsgrRet[0]["BagInfo"].ToString(); // } // //if (dtTaxDataAryRet.Rows.Count > 0) // //{ // // DataRow[] rowTaxDataAryRet = dtTaxDataAryRet.Select("Fare_id=" + FareIdRet); // // taxDataAry_id = rowTaxDataAryRet[0]["TaxdataAry_Id"].ToString(); // //} // //if (dtTaxDataRet.Rows.Count > 0) // //{ // // DataRow[] rowTaxDataRet = dtTaxDataRet.Select("TaxdataAry_Id=" + taxDataAry_idRet); // // for (int j = 0; j < rowTaxDataRet.Length; j++) // // { // // if (rowTaxDataRet.Length == 0) // // { // // taxDataRet = "<TaxData><Country>" + rowTaxDataRet[j]["Country"].ToString() + "</Country><Amt>" + rowTaxDataRet[j]["Amt"].ToString() + "</Amt></TaxData>"; // // } // // else // // { // // taxDataRet = taxDataRet + "<TaxData><Country>" + rowTaxDataRet[j]["Country"].ToString() + "</Country><Amt>" + rowTaxDataRet[j]["Amt"].ToString() + "</Amt></TaxData>"; // // } // // } // //} // xmlRequest = xmlRequest + "<FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportNameRet + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportNameRet + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber>"; // xmlRequest = xmlRequest + "<MarketingAirlineCode>" + MarketingAirlineCodeRet + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineNameRet + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><NumStops>" + NumStopsRet + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmntRet + "</LinkSellAgrmnt><Conx>" + ConxRet + "</Conx><AirpChg>" + AirpChgRet + "</AirpChg><InsideAvailOption>" + InsideAvailOptionRet + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestrictionRet + "</GenTrafRestriction><DaysOperates>" + DaysOperatesRet + "</DaysOperates><JrnyTm>" + JrnyTmRet + "</JrnyTm><EndDt>" + EndDtRet + "</EndDt><StartTerminal>" + StartTerminalRet + "</StartTerminal><EndTerminal>" + EndTerminalRet + "</EndTerminal>"; // xmlRequest = xmlRequest + "<FltTm>" + FltTmRet + "</FltTm><LSAInd>" + LSAIndRet + "</LSAInd><Mile>" + MileRet + "</Mile><BookingClass><Availability>" + AvailabilityRet + "</Availability><BIC>" + BICRet + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclassRet + "</bookingclass><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><Rule>" + RuleRet.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry>" + taxdatapsgrRet + "</PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrTypeRet + "</PsgrType><BaseFare>" + FareBaseFareRet + "</BaseFare><Tax>" + FareTax1Ret + "</Tax><BagInfo></BagInfo></Psgr> // } //} #endregion #region bookrequest return xmlRequest = xmlRequest + "<FlightSegment><AirEquipType>" + AirEquipTypeRet + "</AirEquipType><ArrivalAirportCode>" + ArrivalAirportCodeRet + "</ArrivalAirportCode><ArrivalAirportName>" + ArrivalAirportNameRet + "</ArrivalAirportName><ArrivalDateTime>" + ArrivalDateTimeRet + "</ArrivalDateTime><DepartureAirportCode>" + DepartureAirportCodeRet + "</DepartureAirportCode><DepartureAirportName>" + DepartureAirportNameRet + "</DepartureAirportName><DepartureDateTime>" + DepartureDateTimeRet + "</DepartureDateTime><FlightNumber>" + FlightNumberRet + "</FlightNumber>"; xmlRequest = xmlRequest + "<MarketingAirlineCode>" + MarketingAirlineCodeRet + "</MarketingAirlineCode><OperatingAirlineCode>" + OperatingAirlineCodeRet + "</OperatingAirlineCode><OperatingAirlineName>" + OperatingAirlineNameRet + "</OperatingAirlineName><OperatingAirlineFlightNumber>" + OperatingAirlineFlightNumberRet + "</OperatingAirlineFlightNumber><NumStops>" + NumStopsRet + "</NumStops><LinkSellAgrmnt>" + LinkSellAgrmntRet + "</LinkSellAgrmnt><Conx>" + ConxRet + "</Conx><AirpChg>" + AirpChgRet + "</AirpChg><InsideAvailOption>" + InsideAvailOptionRet + "</InsideAvailOption><GenTrafRestriction>" + GenTrafRestrictionRet + "</GenTrafRestriction><DaysOperates>" + DaysOperatesRet + "</DaysOperates><JrnyTm>" + JrnyTmRet + "</JrnyTm><EndDt>" + EndDtRet + "</EndDt><StartTerminal>" + StartTerminalRet + "</StartTerminal><EndTerminal>" + EndTerminalRet + "</EndTerminal>"; xmlRequest = xmlRequest + "<FltTm>" + FltTmRet + "</FltTm><LSAInd>" + LSAIndRet + "</LSAInd><Mile>" + MileRet + "</Mile><BookingClass><Availability>" + AvailabilityRet + "</Availability><BIC>" + BICRet + "</BIC></BookingClass><BookingClassFare><bookingclass>" + bookingclassRet + "</bookingclass><classType>" + classTypeRet + "</classType><farebasiscode>" + farebasiscodeRet + "</farebasiscode><Rule>" + RuleRet.Replace("<", "<").Replace(">", ">") + "</Rule><PsgrBreakup><PsgrAry>" + taxdatapsgrRet + "</PsgrAry></PsgrBreakup></BookingClassFare></FlightSegment>";//<Psgr><PsgrType>" + FarePsgrTypeRet + "</PsgrType><BaseFare>" + FareBaseFareRet + "</BaseFare><Tax>" + FareTax1Ret + "</Tax><BagInfo></BagInfo></Psgr> xmlRequest = xmlRequest + "</FlightSegments></Return><id>" + id1 + "</id><key>" + key + "</key>"; xmlRequest = xmlRequest + "</OriginDestinationOption></Bookingrequest>"; #endregion DataSet dsResponse = new DataSet(); StringBuilder stt = new StringBuilder(); stt.Append("xmlRequest"); stt.Append("="); stt.Append(Server.UrlEncode(xmlRequest)); byte[] requestData = Encoding.UTF8.GetBytes(stt.ToString()); HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://live.arzoo.com:9302/Booking"); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; request.Accept = "application/json"; request.ContentLength = requestData.Length; using (Stream requestStream = request.GetRequestStream()) { requestStream.Write(requestData, 0, requestData.Length); } using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { using (Stream stream = response.GetResponseStream()) { using (StreamReader reader = new StreamReader(stream, Encoding.ASCII)) result = reader.ReadToEnd(); XmlDocument doc = new XmlDocument(); doc.LoadXml(result); XmlNodeReader xmlReader = new XmlNodeReader(doc); dsResponse.ReadXml(xmlReader); } } return dsResponse; } catch (Exception ex) { throw; } }