How to save XML SOAP web Service Response in C#

Question

1.00/5 (1 vote)

See more:

This is an XML SOAP web Service Response, i want to store all the values in database and again fetch to the webpage. but this XML is not able to pass through DataSet shows Error

The table (item) cannot be the child table to itself in nested relations.

Please help. or any other way to show values on Web pages.

HTML

<soapenv:envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <soapenv:body>
    <ota_airlowfaresearchrs version="2.001" xmlns="http://www.opentravel.org/OTA/2003/05" xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
      <success />
      <priceditineraries>
        <priceditinerary farequotepriceditinerary="false" faretype="Refundable" matrixfare="true" origindestinationrph="DELBOMSG109SG20130420" returnonly="false" seattosell="40" sequencenumber="1.0" suppliersystem="SGNAV">
          <airitinerary suppliersystem="SGNAV">
            <origindestinationoptions>
              <origindestinationoption duration="02:05:00" farebasiscode="F" flightid="DELBOMSG109SG" returnonly="false" suppliercode="SGAPI" suppliersystem="SGNAV" uniqueidentifier="1.0">
                <flightsegment arrivaldatetime="2013-04-20T12:15:00" datewindow="" departuredatetime="2013-04-20T10:10:00" duration="02:05:00" flightnumber="109" ltd="SGAPI" numberinparty="DELBOM" resbookdesigcode="F" status="40" stopquantity="0" validconnectionind="SGAPI">
                  <bookingclassavail faretype="J" resbookdesigcode="F" />
                  <departureairport airportname="Indira Gandhi" cityname="New Delhi" codecontext="IATA" locationcode="DEL" />
                  <arrivalairport airportname="Chatrapati Shivaji" cityname="Mumbai" codecontext="IATA" locationcode="BOM" />
                  <equipment airequiptype="737" />
                  <marketingairline code="SG" codecontext="IATA" matrixcode="SG" name="Spice Jet" ytairlinecode="SG" />
                </flightsegment>
                <FormData>
                  <item>
                    <SelectedFareCode>F</SelectedFareCode>
                    <fares>
                      <item>
                        <BaseAmount>
                          <amount>920.0</amount>
                          <currencycode>INR</currencycode>
                        </BaseAmount>
                        <passengertypecode>ADT</passengertypecode>
                        <meal />
                        <faregroup>R</faregroup>
                        <tosell>40</tosell>
                        <cabin>1</cabin>
                        <farecode>F</farecode>
                      </item>
                    </fares>
                    <flights>
                      <item>
                        <arrivaldatetime>2013-04-20T12:15:00.000Z</arrivaldatetime>
                        <opsuffix />
                        <numberofstops>0</numberofstops>
                        <departuredatetime>2013-04-20T10:10:00.000Z</departuredatetime>
                        <aircrafttype>737</aircrafttype>
                        <departureterminal />
                        <overnight>false</overnight>
                        <status />
                        <origin>DEL</origin>
                        <arrivalterminal />
                        <servicetype>J</servicetype>
                        <arrivaltimeoffset>+0530</arrivaltimeoffset>
                        <destination>BOM</destination>
                        <flightlegs>
                          <item>
                            <irregularoperationindicator />
                            <remarks></remarks>
                            <flightdesignator>SG  109</flightdesignator>
                            <scheduleddeparturetime>2013-04-20T10:10:00.000Z</scheduleddeparturetime>
                            <scheduledarrivaltime>2013-04-20T12:15:00.000Z</scheduledarrivaltime>
                            <lid>189</lid>
                            <departuredate>2013-04-20T10:10:00.000Z</departuredate>
                            <sold>0</sold>
                            <departureairport>DEL</departureairport>
                            <opsuffix />
                            <flightdetail />
                            <aircrafttype>737</aircrafttype>
                            <departureterminal>1D</departureterminal>
                            <overnight>false</overnight>
                            <status>false</status>
                            <arrivalterminal>1D</arrivalterminal>
                            <aircraftcode>737-800</aircraftcode>
                            <servicetype>J</servicetype>
                            <arrivaltimeoffset>+0530</arrivaltimeoffset>
                            <jointopdesig />
                            <capacity>189</capacity>
                            <departuretimeoffset>+0530</departuretimeoffset>
                            <arrivalairport>BOM</arrivalairport>
                          </item>
                        </flightlegs>
                        <departuretimeoffset>+0530</departuretimeoffset>
                        <flightnumber>109</flightnumber>
                        <carriercode>SG</carriercode>
                      </item>
                    </flights>
                  </item>
                  <faredifference>
                    <totalfare adt="1" basefare="920-ADT 920.0" chd="0" cabin="Economy" hostname="railserver" inf="0" rbd="J - F - 40" tax="PSF-0YQ-2850UDF-0YR-187WC-0TF-0OC-891">4848</totalfare>
                  </faredifference>
                  <ticketinginfo deliverymethod="EMAIL" tickettimelimit="" tickettype="eTicket" ticketingstatus="" eticketnumber="">
                    <ticketadvisory language="English" />
                  </ticketinginfo>
                  <agentmarkup>
                    <airlines>
                      <airline>
                        <code>6E</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      </airline>
                      <airline>
                        <code>9H</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>9W</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>AI</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>DN</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>3250.0000</surcharge>
                      </airline>
                      <airline>
                        <code>G8</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      </airline>
                      <airline>
                        <code>I7</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IC</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IT</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>S2</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>SG</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2000.0000</surcharge>
                      </airline>
                      <others>
                        <code />
                        <GDS>1</GDS>
                        <WholeSalerFees>0</WholeSalerFees>
                        <CommissionType>C</CommissionType>
                        <ApplyOn>B</ApplyOn>
                        <Amount>0.0000</Amount>
                      </Others>
                    </Airlines>
                  </AgentMarkup>
                </FormData>
                <FormData/>
              </OriginDestinationOption>
            </OriginDestinationOptions>
          </AirItinerary>
          <AirItineraryPricingInfo UniqueIdentifier="1.0">
            <ItinTotalFare>
              <BaseFare Amount="920" CurrencyCode="INR"/>
              <Taxes>
                <Tax Amount="0" CurrencyCode="INR" Description="Passenger Service Fee" FareBasisCode="F" TaxCode="PSF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="2850" CurrencyCode="INR" Description="Fuel Surcharge" FareBasisCode="F" TaxCode="YQ" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="User Development Fee" FareBasisCode="F" TaxCode="UDF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="187" CurrencyCode="INR" Description="Congestion Fee" FareBasisCode="F" TaxCode="YR" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="Web transaction Charges" FareBasisCode="F" TaxCode="WC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="Transaction Fee" FareBasisCode="F" TaxCode="TF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="891" CurrencyCode="INR" Description="Other Charges" FareBasisCode="F" TaxCode="OC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
              </Taxes>
              <TotalFare Amount="4848" CurrencyCode="INR"/>
              <ServiceTax Amount="0" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0"/>
              <Fees>
                <Fee Amount="0"/>
                <Fee Amount="0" FeeCode="YatraLCCSurcharge"/>
              </Fees>
              <Markups>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0  wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0% on base fare for client -  1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0% on fuel surcharge 2850 -for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0 on base fare for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="P"/>
              </Markups>
            </ItinTotalFare>
            <PTC_FareBreakdowns>
              <PTC_FareBreakdown>
                <PassengerTypeQuantity Code="ADT" Quantity="1"/>
                <FareBasisCodes>
                  <FareBasisCode BaseFareRefundperPAX="170" CancelAmtValue="750" FareType="Refundable" RefundType="A" ResBookDesigCode="Economy" YatraOfflineFee="310" YatraOnlineFee="200">XXXXX</FareBasisCode>
                </FareBasisCodes>
                <PassengerFare>
                  <BaseFare Amount="920.0" CurrencyCode="INR"/>
                  <Taxes>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Passenger Service Fee" FareBasisCode="F" TaxCode="PSF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="2850" Code="ADT" CurrencyCode="INR" Description="Fuel Surcharge" FareBasisCode="F" TaxCode="YQ" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="User Development Fee" FareBasisCode="F" TaxCode="UDF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="187" Code="ADT" CurrencyCode="INR" Description="Congestion Fee" FareBasisCode="F" TaxCode="YR" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Web transaction Charges" FareBasisCode="F" TaxCode="WC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Transaction Fee" FareBasisCode="F" TaxCode="TF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="891" Code="ADT" CurrencyCode="INR" Description="Other Charges" FareBasisCode="F" TaxCode="OC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                  </Taxes>
                  <TotalFare Amount="4848" CurrencyCode="INR"/>
                  <ServiceTax Amount="0" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0"/>
                  <Markups>
                    <Markup Amount="0.0000" CurrencyCode="INR" Description="0.0  wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C"/>
                    <Markup Amount="0" CurrencyCode="INR" Description="0.0 % on base fare  for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                    <Markup Amount="0" Description="0.0% on fule surcharge  2850.0for client1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                    <Markup Amount="0" CurrencyCode="INR" Description="0.0 on base fare for client1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="P"/>
                  </Markups>
                </PassengerFare>
                <RefundInfo BaseFareRefundperPAX="170" CancelAmtValue="750" FareBasisUsed="-" RefundType="F" ResBookDesigCode="-" YatraOfflineFee="310" YatraOnlineFee="200"/>
              </PTC_FareBreakdown>
            </PTC_FareBreakdowns>
          </AirItineraryPricingInfo>
          <TicketingInfo DeliveryMethod="EMAIL" TicketTimeLimit="" TicketType="eTicket" TicketingStatus="" eTicketNumber="">
            <TicketAdvisory Language="English"/>
          </TicketingInfo>
        </PricedItinerary>
        
        <PricedItinerary FareQuotePricedItinerary="false" FareType="Refundable" OriginDestinationRPH="DELBOMSG852SG20130420" ReturnOnly="false" SeatToSell="33" SequenceNumber="1.0" SupplierSystem="SGNAV">
          <AirItinerary SupplierSystem="SGNAV">
            <OriginDestinationOptions>
              <OriginDestinationOption Duration="02:10:00" FareBasisCode="F" FlightID="DELBOMSG852SG" ReturnOnly="false" SupplierCode="SGAPI" SupplierSystem="SGNAV" UniqueIdentifier="1.0">
                <FlightSegment ArrivalDateTime="2013-04-20T17:20:00" DateWindow="" DepartureDateTime="2013-04-20T15:10:00" Duration="02:10:00" FlightNumber="852" LTD="SGAPI" NumberInParty="DELBOM" ResBookDesigCode="F" Status="33"
								               StopQuantity="0" ValidConnectionInd="SGAPI">
                  <BookingClassAvail FareType="J" ResBookDesigCode="F"/>
                  <DepartureAirport AirPortName="Indira Gandhi" CityName="New Delhi" CodeContext="IATA" LocationCode="DEL"/>
                  <ArrivalAirport AirPortName="Chatrapati Shivaji" CityName="Mumbai" CodeContext="IATA" LocationCode="BOM"/>
                  <Equipment AirEquipType="737"/>
                  <MarketingAirline Code="SG" CodeContext="IATA" MatrixCode="SG" Name="Spice Jet" YTAirlineCode="SG"/>
                </FlightSegment>
                <FormData>
                  <item>
                    <SelectedFareCode>F</SelectedFareCode>
                    <Fares>
                      <item>
                        <BaseAmount>
                          <Amount>920.0</Amount>
                          <CurrencyCode>INR</CurrencyCode>
                        </BaseAmount>
                        <PassengerTypeCode>ADT</PassengerTypeCode>
                        <Meal/>
                        <FareGroup>R</FareGroup>
                        <ToSell>33</ToSell>
                        <Cabin>1</Cabin>
                        <FareCode>F</FareCode>
                      </item>
                    </Fares>
                    <Flights>
                      <item>
                        <ArrivalDateTime>2013-04-20T17:20:00.000Z</ArrivalDateTime>
                        <OpSuffix/>
                        <NumberOfStops>0</NumberOfStops>
                        <DepartureDateTime>2013-04-20T15:10:00.000Z</DepartureDateTime>
                        <AircraftType>737</AircraftType>
                        <DepartureTerminal/>
                        <Overnight>false</Overnight>
                        <Status/>
                        <Origin>DEL</Origin>
                        <ArrivalTerminal/>
                        <ServiceType>J</ServiceType>
                        <ArrivalTimeOffset>+0530</ArrivalTimeOffset>
                        <Destination>BOM</Destination>
                        <FlightLegs>
                          <item>
                            <IrregularOperationIndicator/>
                            <Remarks></Remarks>
                            <FlightDesignator>SG  852</FlightDesignator>
                            <ScheduledDepartureTime>2013-04-20T15:10:00.000Z</ScheduledDepartureTime>
                            <ScheduledArrivalTime>2013-04-20T17:20:00.000Z</ScheduledArrivalTime>
                            <Lid>189</Lid>
                            <DepartureDate>2013-04-20T15:10:00.000Z</DepartureDate>
                            <Sold>2</Sold>
                            <DepartureAirport>DEL</DepartureAirport>
                            <OpSuffix/>
                            <FlightDetail/>
                            <AircraftType>737</AircraftType>
                            <DepartureTerminal>1D</DepartureTerminal>
                            <Overnight>false</Overnight>
                            <Status>false</Status>
                            <ArrivalTerminal>1D</ArrivalTerminal>
                            <AircraftCode>737-800</AircraftCode>
                            <ServiceType>J</ServiceType>
                            <ArrivalTimeOffset>+0530</ArrivalTimeOffset>
                            <JointOpDesig/>
                            <Capacity>189</Capacity>
                            <DepartureTimeOffset>+0530</DepartureTimeOffset>
                            <ArrivalAirport>BOM</ArrivalAirport>
                          </item>
                        </FlightLegs>
                        <DepartureTimeOffset>+0530</DepartureTimeOffset>
                        <FlightNumber>852</FlightNumber>
                        <CarrierCode>SG</CarrierCode>
                      </item>
                    </Flights>
                  </item>
                  <FareDifference>
                    <TotalFare ADT="1" BaseFare="920-ADT 920.0" CHD="0" Cabin="Economy" HostName="railserver" INF="0" Rbd="J - F - 33" Tax="PSF-0YQ-2850UDF-0YR-187WC-0TF-0OC-891">4848</TotalFare>
                  </FareDifference>
                  <TicketingInfo DeliveryMethod="EMAIL" TicketTimeLimit="" TicketType="eTicket" TicketingStatus="" eTicketNumber="">
                    <TicketAdvisory Language="English"/>
                  </TicketingInfo>
                  <AgentMarkup>
                    <Airlines>
                      <Airline>
                        <Code>6E
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      
                      <airline>
                        <code>9H</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>9W</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>AI</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>DN</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>3250.0000</surcharge>
                      </airline>
                      <airline>
                        <code>G8</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      </airline>
                      <airline>
                        <code>I7</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IC</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IT</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>S2</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>SG</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2000.0000</surcharge>
                      </airline>
                      <others>
                        <code />
                        <GDS>1</GDS>
                        <WholeSalerFees>0</WholeSalerFees>
                        <CommissionType>C</CommissionType>
                        <ApplyOn>B</ApplyOn>
                        <Amount>0.0000</Amount>
                      </Others>
                    </Airlines>
                  </AgentMarkup>
                </FormData>
                <FormData/>
              </OriginDestinationOption>
            </OriginDestinationOptions>
          </AirItinerary>
          <AirItineraryPricingInfo UniqueIdentifier="1.0">
            <ItinTotalFare>
              <BaseFare Amount="920" CurrencyCode="INR"/>
              <Taxes>
                <Tax Amount="0" CurrencyCode="INR" Description="Passenger Service Fee" FareBasisCode="F" TaxCode="PSF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="2850" CurrencyCode="INR" Description="Fuel Surcharge" FareBasisCode="F" TaxCode="YQ" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="User Development Fee" FareBasisCode="F" TaxCode="UDF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="187" CurrencyCode="INR" Description="Congestion Fee" FareBasisCode="F" TaxCode="YR" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="Web transaction Charges" FareBasisCode="F" TaxCode="WC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="Transaction Fee" FareBasisCode="F" TaxCode="TF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="891" CurrencyCode="INR" Description="Other Charges" FareBasisCode="F" TaxCode="OC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
              </Taxes>
              <TotalFare Amount="4848" CurrencyCode="INR"/>
              <ServiceTax Amount="0" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0"/>
              <Fees>
                <Fee Amount="0"/>
                <Fee Amount="0" FeeCode="YatraLCCSurcharge"/>
              </Fees>
              <Markups>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0  wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0% on base fare for client -  1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0% on fuel surcharge 2850 -for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0 on base fare for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="P"/>
              </Markups>
            </ItinTotalFare>
            <PTC_FareBreakdowns>
              <PTC_FareBreakdown>
                <PassengerTypeQuantity Code="ADT" Quantity="1"/>
                <FareBasisCodes>
                  <FareBasisCode BaseFareRefundperPAX="170" CancelAmtValue="750" FareType="Refundable" RefundType="A" ResBookDesigCode="Economy" YatraOfflineFee="310" YatraOnlineFee="200">XXXXX</FareBasisCode>
                </FareBasisCodes>
                <PassengerFare>
                  <BaseFare Amount="920.0" CurrencyCode="INR"/>
                  <Taxes>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Passenger Service Fee" FareBasisCode="F" TaxCode="PSF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="2850" Code="ADT" CurrencyCode="INR" Description="Fuel Surcharge" FareBasisCode="F" TaxCode="YQ" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="User Development Fee" FareBasisCode="F" TaxCode="UDF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="187" Code="ADT" CurrencyCode="INR" Description="Congestion Fee" FareBasisCode="F" TaxCode="YR" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Web transaction Charges" FareBasisCode="F" TaxCode="WC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Transaction Fee" FareBasisCode="F" TaxCode="TF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="891" Code="ADT" CurrencyCode="INR" Description="Other Charges" FareBasisCode="F" TaxCode="OC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                  </Taxes>
                  <TotalFare Amount="4848" CurrencyCode="INR"/>
                  <ServiceTax Amount="0" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0"/>
                  <Markups>
                    <Markup Amount="0.0000" CurrencyCode="INR" Description="0.0  wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C"/>
                    <Markup Amount="0" CurrencyCode="INR" Description="0.0 % on base fare  for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                    <Markup Amount="0" Description="0.0% on fule surcharge  2850.0for client1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                    <Markup Amount="0" CurrencyCode="INR" Description="0.0 on base fare for client1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="P"/>
                  </Markups>
                </PassengerFare>
                <RefundInfo BaseFareRefundperPAX="170" CancelAmtValue="750" FareBasisUsed="-" RefundType="F" ResBookDesigCode="-" YatraOfflineFee="310" YatraOnlineFee="200"/>
              </PTC_FareBreakdown>
            </PTC_FareBreakdowns>
          </AirItineraryPricingInfo>
          <TicketingInfo DeliveryMethod="EMAIL" TicketTimeLimit="" TicketType="eTicket" TicketingStatus="" eTicketNumber="">
            <TicketAdvisory Language="English"/>
          </TicketingInfo>
        </PricedItinerary>
        
        <PricedItinerary FareQuotePricedItinerary="true" FareType="Refundable" OriginDestinationRPH="DELBOMSG131SG20130420" ReturnOnly="false" SeatToSell="38" SequenceNumber="1.0" SupplierSystem="SGNAV">
          <AirItinerary SupplierSystem="SGNAV">
            <OriginDestinationOptions>
              <OriginDestinationOption Duration="01:45:00" FareBasisCode="F" FlightID="DELBOMSG131SG" ReturnOnly="false" SupplierCode="SGAPI" SupplierSystem="SGNAV" UniqueIdentifier="1.0">
                <FlightSegment ArrivalDateTime="2013-04-20T07:40:00" DateWindow="" DepartureDateTime="2013-04-20T05:55:00" Duration="01:45:00" FlightNumber="131" LTD="SGAPI" NumberInParty="DELBOM" ResBookDesigCode="F" Status="38"
								               StopQuantity="0" ValidConnectionInd="SGAPI">
                  <BookingClassAvail FareType="J" ResBookDesigCode="F"/>
                  <DepartureAirport AirPortName="Indira Gandhi" CityName="New Delhi" CodeContext="IATA" LocationCode="DEL"/>
                  <ArrivalAirport AirPortName="Chatrapati Shivaji" CityName="Mumbai" CodeContext="IATA" LocationCode="BOM"/>
                  <Equipment AirEquipType="737"/>
                  <MarketingAirline Code="SG" CodeContext="IATA" MatrixCode="SG" Name="Spice Jet" YTAirlineCode="SG"/>
                </FlightSegment>
                <FormData>
                  <item>
                    <SelectedFareCode>F</SelectedFareCode>
                    <Fares>
                      <item>
                        <BaseAmount>
                          <Amount>920.0</Amount>
                          <CurrencyCode>INR</CurrencyCode>
                        </BaseAmount>
                        <PassengerTypeCode>ADT</PassengerTypeCode>
                        <Meal/>
                        <FareGroup>R</FareGroup>
                        <ToSell>38</ToSell>
                        <Cabin>1</Cabin>
                        <FareCode>F</FareCode>
                      </item>
                    </Fares>
                    <Flights>
                      <item>
                        <ArrivalDateTime>2013-04-20T07:40:00.000Z</ArrivalDateTime>
                        <OpSuffix/>
                        <NumberOfStops>0</NumberOfStops>
                        <DepartureDateTime>2013-04-20T05:55:00.000Z</DepartureDateTime>
                        <AircraftType>737</AircraftType>
                        <DepartureTerminal/>
                        <Overnight>false</Overnight>
                        <Status/>
                        <Origin>DEL</Origin>
                        <ArrivalTerminal/>
                        <ServiceType>J</ServiceType>
                        <ArrivalTimeOffset>+0530</ArrivalTimeOffset>
                        <Destination>BOM</Destination>
                        <FlightLegs>
                          <item>
                            <IrregularOperationIndicator/>
                            <Remarks></Remarks>
                            <FlightDesignator>SG  131</FlightDesignator>
                            <ScheduledDepartureTime>2013-04-20T05:55:00.000Z</ScheduledDepartureTime>
                            <ScheduledArrivalTime>2013-04-20T07:40:00.000Z</ScheduledArrivalTime>
                            <Lid>189</Lid>
                            <DepartureDate>2013-04-20T05:55:00.000Z</DepartureDate>
                            <Sold>2</Sold>
                            <DepartureAirport>DEL</DepartureAirport>
                            <OpSuffix/>
                            <FlightDetail/>
                            <AircraftType>737</AircraftType>
                            <DepartureTerminal>1D</DepartureTerminal>
                            <Overnight>false</Overnight>
                            <Status>false</Status>
                            <ArrivalTerminal>1D</ArrivalTerminal>
                            <AircraftCode>737-800</AircraftCode>
                            <ServiceType>J</ServiceType>
                            <ArrivalTimeOffset>+0530</ArrivalTimeOffset>
                            <JointOpDesig/>
                            <Capacity>189</Capacity>
                            <DepartureTimeOffset>+0530</DepartureTimeOffset>
                            <ArrivalAirport>BOM</ArrivalAirport>
                          </item>
                        </FlightLegs>
                        <DepartureTimeOffset>+0530</DepartureTimeOffset>
                        <FlightNumber>131</FlightNumber>
                        <CarrierCode>SG</CarrierCode>
                      </item>
                    </Flights>
                  </item>
                  <FareDifference>
                    <TotalFare ADT="1" BaseFare="920-ADT 920.0" CHD="0" Cabin="Economy" HostName="railserver" INF="0" Rbd="J - F - 38" Tax="PSF-0YQ-2850UDF-0YR-187WC-0TF-0OC-891">4848</TotalFare>
                  </FareDifference>
                  <TicketingInfo DeliveryMethod="EMAIL" TicketTimeLimit="" TicketType="eTicket" TicketingStatus="" eTicketNumber="">
                    <TicketAdvisory Language="English"/>
                  </TicketingInfo>
                  <AgentMarkup>
                    <Airlines>
                      <Airline>
                        <Code>6E
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      
                      <airline>
                        <code>9H</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>9W</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>AI</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>DN</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>3250.0000</surcharge>
                      </airline>
                      <airline>
                        <code>G8</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      </airline>
                      <airline>
                        <code>I7</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IC</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IT</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>S2</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>SG</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2000.0000</surcharge>
                      </airline>
                      <others>
                        <code />
                        <GDS>1</GDS>
                        <WholeSalerFees>0</WholeSalerFees>
                        <CommissionType>C</CommissionType>
                        <ApplyOn>B</ApplyOn>
                        <Amount>0.0000</Amount>
                      </Others>
                    </Airlines>
                  </AgentMarkup>
                </FormData>
                <FormData/>
              </OriginDestinationOption>
            </OriginDestinationOptions>
          </AirItinerary>
          <AirItineraryPricingInfo UniqueIdentifier="1.0">
            <ItinTotalFare>
              <BaseFare Amount="920" CurrencyCode="INR"/>
              <Taxes>
                <Tax Amount="0" CurrencyCode="INR" Description="Passenger Service Fee" FareBasisCode="F" TaxCode="PSF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="2850" CurrencyCode="INR" Description="Fuel Surcharge" FareBasisCode="F" TaxCode="YQ" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="User Development Fee" FareBasisCode="F" TaxCode="UDF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="187" CurrencyCode="INR" Description="Congestion Fee" FareBasisCode="F" TaxCode="YR" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="Web transaction Charges" FareBasisCode="F" TaxCode="WC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="0" CurrencyCode="INR" Description="Transaction Fee" FareBasisCode="F" TaxCode="TF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                <Tax Amount="891" CurrencyCode="INR" Description="Other Charges" FareBasisCode="F" TaxCode="OC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
              </Taxes>
              <TotalFare Amount="4848" CurrencyCode="INR"/>
              <ServiceTax Amount="0" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0"/>
              <Fees>
                <Fee Amount="0"/>
                <Fee Amount="0" FeeCode="YatraLCCSurcharge"/>
              </Fees>
              <Markups>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0  wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0% on base fare for client -  1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0% on fuel surcharge 2850 -for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                <Markup Amount="0" CurrencyCode="INR" Description="0.0 on base fare for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="P"/>
              </Markups>
            </ItinTotalFare>
            <PTC_FareBreakdowns>
              <PTC_FareBreakdown>
                <PassengerTypeQuantity Code="ADT" Quantity="1"/>
                <FareBasisCodes>
                  <FareBasisCode BaseFareRefundperPAX="170" CancelAmtValue="750" FareType="Refundable" RefundType="A" ResBookDesigCode="Economy" YatraOfflineFee="310" YatraOnlineFee="200">XXXXX</FareBasisCode>
                </FareBasisCodes>
                <PassengerFare>
                  <BaseFare Amount="920.0" CurrencyCode="INR"/>
                  <Taxes>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Passenger Service Fee" FareBasisCode="F" TaxCode="PSF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="2850" Code="ADT" CurrencyCode="INR" Description="Fuel Surcharge" FareBasisCode="F" TaxCode="YQ" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="User Development Fee" FareBasisCode="F" TaxCode="UDF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="187" Code="ADT" CurrencyCode="INR" Description="Congestion Fee" FareBasisCode="F" TaxCode="YR" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Web transaction Charges" FareBasisCode="F" TaxCode="WC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="0" Code="ADT" CurrencyCode="INR" Description="Transaction Fee" FareBasisCode="F" TaxCode="TF" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                    <Tax Amount="891" Code="ADT" CurrencyCode="INR" Description="Other Charges" FareBasisCode="F" TaxCode="OC" TaxGroupCode="SF" TaxGroupName="Taxes &amp; Fees"/>
                  </Taxes>
                  <TotalFare Amount="4848" CurrencyCode="INR"/>
                  <ServiceTax Amount="0" Currency="INR" Description="Service Tax" ServiceTaxCode="ST" ServiceTaxRate="0"/>
                  <Markups>
                    <Markup Amount="0.0000" CurrencyCode="INR" Description="0.0  wholesalerfees for client 1152" MarkupCode="DisplayMarkup" MarkupType="W" Type="C"/>
                    <Markup Amount="0" CurrencyCode="INR" Description="0.0 % on base fare  for client - 1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                    <Markup Amount="0" Description="0.0% on fule surcharge  2850.0for client1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="C"/>
                    <Markup Amount="0" CurrencyCode="INR" Description="0.0 on base fare for client1152" MarkupCode="DisplayMarkup" MarkupType="M" Type="P"/>
                  </Markups>
                </PassengerFare>
                <RefundInfo BaseFareRefundperPAX="170" CancelAmtValue="750" FareBasisUsed="-" RefundType="F" ResBookDesigCode="-" YatraOfflineFee="310" YatraOnlineFee="200"/>
              </PTC_FareBreakdown>
            </PTC_FareBreakdowns>
          </AirItineraryPricingInfo>
          <TicketingInfo DeliveryMethod="EMAIL" TicketTimeLimit="" TicketType="eTicket" TicketingStatus="" eTicketNumber="">
            <TicketAdvisory Language="English"/>
          </TicketingInfo>
        </PricedItinerary>
        
        <PricedItinerary CompositeFlightNumber="AI" CountCompositeFlightNumber="1" FareType="Non-Refundable" InboundSegmentReference="1" MatrixFare="true" Mode="" OriginDestinationRPH="DELBOMAI688AI20130420" OutboundSegmentReference="1" RecommendationRPH="1" Refundable="true" ReturnOnly="false" SequenceNumber="1.0" SupplierCode="1AWS">
          <AirItinerary SupplierSystem="Amadeus">
            <OriginDestinationOptions>
              <OriginDestinationOption Duration="01:55:00" FlightID="DELBOMAI688AI" MajorityCarrier="AI" ReturnOnly="false" SupplierCode="1AWS" SupplierSystem="Amadeus" UniqueIdentifier="1.0">
                <FlightSegment ArrivalDateTime="2013-04-20T07:55:00" CabinCode="Y" DeliveryMethod="Courier" DepartureDateTime="2013-04-20T06:00:00" Duration="01:55:00" FlightNumber="688" LTD="1AWS" LineNumber="Y" NumberInParty="DELBOM"
								               RPH="1" ResBookDesigCode="E" TicketType="Physical" ValidConnectionInd="1AWS">
                  <DepartureAirport AirPortName="Indira Gandhi" CityName="New Delhi" LocationCode="DEL" Terminal="3"/>
                  <ArrivalAirport AirPortName="Chatrapati Shivaji" CityName="Mumbai" LocationCode="BOM" Terminal="1A"/>
                  <OperatingAirline Code="AI"/>
                  <BookingClassAvail FareType="RP" ResBookDesigCode="E" ResBookDesigQuantity="9" Status="9" WebFareName="EAP30"/>
                  <Equipment AirEquipType="321"/>
                  <MarketingAirline Code="AI" MatrixCode="AI" Name="Air India" YTAirlineCode="AI"/>
                  <ValidatingCarrier Code="AI"/>
                </FlightSegment>
                <FormData>
                  <FBC Destination="BOM" FlightNumber="688" LineNumber="Y" Origin="DEL" SeatToSell="9" WebFareName="EAP30"/>
                  <FareDifference>
                    <TotalFare ADT="1" BaseFare="1150-ADT 920.0" CHD="0" Cabin="Economy" HostName="railserver" INF="0" Rbd="RP - E - " Tax="TTL-3919">5081</TotalFare>
                  </FareDifference>
                  <TicketingInfo DeliveryMethod="Courier" TicketTimeLimit="2012-09-24" TicketType="Physical"/>
                  <AgentMarkup>
                    <Airlines>
                      <Airline>
                        <Code>6E
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      
                      <airline>
                        <code>9H</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>9W</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>AI</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>DN</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>3250.0000</surcharge>
                      </airline>
                      <airline>
                        <code>G8</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2700.0000</surcharge>
                      </airline>
                      <airline>
                        <code>I7</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>M</commissiontype>
                        <applyon>BF</applyon>
                        <amount>6.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>0.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IC</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>IT</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>S2</code>
                        <gds>1</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>1100.0000</surcharge>
                      </airline>
                      <airline>
                        <code>SG</code>
                        <gds>0</gds>
                        <wholesalerfees>0.0000</wholesalerfees>
                        <wholesalerfeestype>F</wholesalerfeestype>
                        <commissiontype>C</commissiontype>
                        <applyon>BF</applyon>
                        <amount>0.0000</amount>
                        <type>P</type>
                        <discountplb>0.0000</discountplb>
                        <discountplbtype>F</discountplbtype>
                        <discountplbon />
                        <surcharge>2000.0000</surcharge>
                      </airline>
                      <others>
                        <code />
                        <gds>1</gds>
                        <wholesalerfees>0</wholesalerfees>
                        <commissiontype>C</commissiontype>
                        <applyon>B</applyon>
                        <amount>0.0000</amount>
                      </others>
                    </others></others></others></airlines>
                  </agentmarkup>
                </FormData>
                <FormData/>
              </origindestinationoption>
            </origindestinationoptions>
          </airitinerary>
          <airitinerarypricinginfo uniqueidentifier="1.0">
            <itintotalfare negotiatedfare="No">
              <BaseFare Amount="1150" CurrencyCode="INR"/>
              <taxes>
                <tax amount="3919" currencycode="INR" taxcode="TTL" />
              </taxes>
              <totalfare amount="5081" currencycode="INR" />
              <fees>
                <fee amount="0" />
                <fee amount="0" feecode="YatraLCCSurcharge" />
              </fees>
              <servicetax amount="12" currency="INR" description="Service Tax" servicetaxcode="ST" servicetaxrate="0.01" />
              <markups>
                <markup amount="0" currencycode="INR" description="0.0  wholesalerfees for client 1152" markupcode="DisplayMarkup" markuptype="W" type="C" />
                <markup amount="0" currencycode="INR" description="0.0% on base fare for client -  1152" markupcode="DisplayMarkup" markuptype="M" type="C" />
                <markup amount="0" currencycode="INR" description="0.0% on fuel surcharge 0 -for client - 1152" markupcode="DisplayMarkup" markuptype="M" type="C" />
                <markup amount="0" currencycode="INR" description="0.0 on base fare for client - 1152" markupcode="DisplayMarkup" markuptype="M" type="P" />
              </markups>
            </itintotalfare>
            <ptc_farebreakdowns>
              <ptc_farebreakdown>
                <passengertypequantity code="ADT" quantity="1.0" />
                <farebasiscodes>
                  <farebasiscode basefarerefundperpax="0" cancelamtvalue="1150" faretype="Non-Refundable" refundtype="P" resbookdesigcode="-" segmentrph="" yatraofflinefee="310" yatraonlinefee="200">XXXXX</farebasiscode>
                </farebasiscodes>
                <passengerfare>
                  <BaseFare Amount="1150" CurrencyCode="INR"/>
                  <taxes>
                    <tax amount="3919" currencycode="INR" taxcode="TTL" />
                  </taxes>
                  <totalfare amount="5081" currencycode="INR" />
                  <servicetax amount="12" currency="INR" description="Service Tax" servicetaxcode="ST" servicetaxrate="0.01" />
                  <markups>
                    <markup amount="0.0000" currencycode="INR" description="0.0  wholesalerfees for client 1152" markupcode="DisplayMarkup" markuptype="W" type="C" />
                    <markup amount="0" currencycode="INR" description="0.0 % on base fare  for client - 1152" markupcode="DisplayMarkup" markuptype="M" type="C" />
                    <markup amount="0" description="0.0% on fule surcharge  0.0for client1152" markupcode="DisplayMarkup" markuptype="M" type="C" />
                    <markup amount="0" currencycode="INR" description="0.0 on base fare for client1152" markupcode="DisplayMarkup" markuptype="M" type="P" />
                  </markups>
                </passengerfare>
                <refundinfo basefarerefundperpax="0" cancelamtvalue="1150" farebasisused="XXXXX" refundtype="F" resbookdesigcode="-" yatraofflinefee="310" yatraonlinefee="200" />
              </ptc_farebreakdown>
            </ptc_farebreakdowns>
            <fareinfos>
              <fareinfo>
                <farereference>EAP30</farereference>
                <filingairline code="ZZ" />
                <departureairport locationcode="DEL" />
                <arrivalairport locationcode="BOM" />
              </fareinfo>
            </fareinfos>
          </airitinerarypricinginfo>
          <ticketinginfo deliverymethod="Courier" tickettimelimit="2012-09-24" tickettype="Physical" />
          <notes>PENALTY APPLIES</notes>
          <notes>LAST TKT DTE24SEP12 - SEE ADV PURCHASE</notes>
        </priceditinerary>

      </priceditineraries>
    </ota_airlowfaresearchrs>
  </soapenv:body>
</soapenv:envelope>

Posted 30-Jul-14 1:04am

Shyam Kishor Mishra

Updated 30-Jul-14 4:41am

RaisKazi

v3

Add a Solution

Comments

ZurdoDev 30-Jul-14 7:24am

Just save it to the db and then parse as needed.

Shyam Kishor Mishra 31-Jul-14 5:22am

I am not able to save the data. that i want to ask from you all dear. please tell me the procedure. please

ZurdoDev 31-Jul-14 7:05am

Why can't you save the data? Do you know how to work with SqlConnection, SqlCommand, etc?

Shyam Kishor Mishra 31-Jul-14 12:30pm

yah, I know the SqlConnection, SqlCommand.. but i am new to XML and its handling. i try to parse the XMl as
DataSet ds = new DataSet();
ds.ReadXml(MapPath("faresearch.xml"));
GridView2.DataSource = ds;
GridView2.DataBind();

But this shows error as
The table (item) cannot be the child table to itself in nested relations.

johannesnestler 30-Jul-14 10:42am

don't save the Soap-message - save the data!

Shyam Kishor Mishra 31-Jul-14 5:21am

I am not able to save the data. that i want to ask from you all dear. please tell me the procedure.

johannesnestler 31-Jul-14 8:14am

Hi Shyam,

It seems you don't get it :-). How should someone know WHY you are not able to save the data. Some possible reasons come to my mind - but why should I guess? Tell me what hinders you, and I (we) will try to help. It could be you know nothing about databases or that you just can't configure it, you may don't know how to handle the XML in the first place, ... - you see - These are the interesting things you should tell us. A dump of your Soap message doesn't help to understand why you can't do the "Job" - which seems pretty straight forward to me...
Kind regards Johannes

Shyam Kishor Mishra 31-Jul-14 9:23am

i am trying to use XmlDocument class

XmlDocument xDoc = new XmlDocument();
xDoc.Load(MapPath("FareSearch.xml"));
XmlNodeList item = xDoc.GetElementsByTagName("item");
string abc = item[0].InnerXml;

and yes, I am new to XML, so please help me

johannesnestler 31-Jul-14 11:01am

Ok - so some thoughts: I'd start by thinking about how to store the data in your database. Should the data be "searchable" and "editable" by your application (or in the database), or is it just a store to put the XML as a whole and read it some time later? If the former is the case, you have to design a database schema according to the data from the Soap message, if the later a XMLfile field in the database will do it. In the case 1 where you create a dataschema, also think about how to represent the data in your C# code (you could use OR-Mappers like Entity-Framework or LinqToSql, or roll your own "mapping"). If you created/generated such a model the last step would be read (and maybe also write) it to XML. (I'd use LinqToXML for this, but you could use XMLSerialization as it seems you do now). So maybe you can answer my questions first, so I get a clearer picture about the whole task. If you then have any problems with the XML-reading itself I should be able to help you with some example code.

Shyam Kishor Mishra 31-Jul-14 12:02pm

I am really thank full to you. I want to store the data in the data base and it should be searchable so that i can show some particular data value in to any dataview. Same like this URL(All flight details section)(http://goo.gl/KAxjRy)

johannesnestler 31-Jul-14 13:25pm

Hi Shyam Kishor,

So in this case you have to model the database Schema corresponding to the data from the message (create tables, Relations). The process could be patially(or completly) automated. It depends if you want to add this data to a "new" database and if you have a Schema for the XML file (this would Show you all constraints (max string length etc.) and all the possible values. My thinking goes like this: If I have the Schema a corresponding class model can be generated with .net tools (e.g if you add any XML-Schema to a WCF project this happens. If you are free to create a new database (could be possible to work with an existing one too - it depends), you could go for the "code first" approach and use EntityFramework to work out the database scheme from the object model (that you ideally generated from the XML Schema). This way nearly no manual coding is needed. Tell me if you understand what I think (my English is maybe not the best too - sorry for that) and what you think is possible for you. Other from that the "Manual" way seems not too difficult either, but it involves a lot of coding (and time)

Kind regards
Johannes

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)