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;
}
}