not able to find elements with Descendants key words: XML->LINQ-C#

Question

0.00/5 (No votes)

See more:

Hi Firends,
My requirement is: I need to traverse through my xml and apply some search criteria. and save the result in a List.
My problem is : I not able to select all positions node by Descendants keyword.
Below is my required path
Envelope->Body->GetRequestedDataResponse->GetRequestedDataResult->Message->EBCMessageType->Message->NewDataSet->Positions
I am stuck with here var ac = doc.Root.Descendants("Positions")
please help.

My XML

XML

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
  <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <GetRequestedDataResponse xmlns="http://tempuri.org/">
      <GetRequestedDataResult>
        <ReferenceID xmlns="http://ebc.mssb.com">M99TzPSsNsKxIxfUfhG</ReferenceID>
        <ReceivedTime xmlns="http://ebc.mssb.com">2015-07-17T10:18:40.6321762-04:00</ReceivedTime>
        <CompletedTime xmlns="http://ebc.mssb.com">2015-07-17T10:18:41.4491762-04:00</CompletedTime>
        <StatusCode xmlns="http://ebc.mssb.com">Success</StatusCode>
        <Message xmlns="http://ebc.mssb.com">
          <EBCMessageType>
            <Message>{ CALL GETMM_ACCT_TURBPOS (RSGETMM_ACCT_TURBPOSFAWorkstation}</Message>
            <MessageType>COMMAND_STRING</MessageType>
          </EBCMessageType>
          <EBCMessageType>
            <Message>
              <NewDataSet>
              <Positions>
              <Office>101</Office>
              <Account>10239</Account>
              <AccruedInterest>25.32</AccruedInterest>
              <Cusip>asd</Cusip>
              <PriceFactor>1.0</PriceFactor>
               <Quantity>5</Quantity>
              </Positions>
                <Positions>
                  <Office>101</Office>
                  <Account>10269</Account>
                  <AccruedInterest>45.34</AccruedInterest>
                  <Cusip>pqr</Cusip>
                  <PriceFactor>1.0</PriceFactor>
                  <Quantity>45</Quantity>
                </Positions>            
              </NewDataSet>
            </Message>
            <MessageType>RAW_DATA</MessageType>
          </EBCMessageType>
        </Message>
        
      </GetRequestedDataResult>
    </GetRequestedDataResponse>
  </s:Body>
</s:Envelope>

c# code

C#

public static List<AccruedClass> validaccrued()
       {
           XDocument doc = XDocument.Load("SampleXML.xml");
           var ac = doc.Root.Descendants("Positions")
                        .Where(item => (float?)item.Element("AccruedInterest") != null && (float?)item.Element("AccruedInterest") > 0.0)
                         .Select(item => new AccruedClass
                         {
                             Cusip = item.Element("Cusip").Value != null ? item.Element("Cusip").Value : "",
                             // Symbol = item.Element("symbol").Value,
                             AccruedInterest = item.Element("AccruedInterest").Value != null ? Convert.ToDouble(item.Element("AccruedInterest").Value) : 0,
                             PriceFactor = item.Element("PriceFactor").Value != null ? Convert.ToDouble(item.Element("PriceFactor").Value) : 0,
                             Quantity = item.Element("Quantity").Value != null ? Convert.ToDouble(item.Element("Quantity").Value) : 0,
                         })
                         .ToList();
           List<AccruedClass> list_accr = ac.ToList<AccruedClass>();
           return list_accr;
       }

C#

static void Main(string[] args)
       {
           List<AccruedClass> ac = new List<AccruedClass>();
           ac = validaccrued();
       }

C#

public class AccruedClass
   {
       public string Cusip { get; set; }
       // public string Symbol { get; set; }
       public double AccruedInterest { get; set; }
       public double PriceFactor { get; set; }
       public double Quantity { get; set; }
       public double CalcAcc { get; set; }
   }

Posted 17-Jul-15 9:29am

jinesh sam

Updated 17-Jul-15 9:51am

v2

Add a Solution

1 solution

Add a Solution

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)

Matt T Heffron · Answer 1 · 2015-07-17T10:41:00

The problem is that the "Positions" elements are in a namespace, inherited from the enclosing <Message xmlns="http://ebc.mssb.com"> so change to include the namespace info:

C#

public static List<AccruedClass> validaccrued()
        {
            XDocument doc = XDocument.Load("SampleXML.xml");
            // This next string expression SHOULD be a single string
            // but CodeProject tries to be too smart and thinks it should be turned into an active link!
            XNamespace ns = "http"+"://ebc.mssb.com";   // assuming it doesn't vary from file to file...
            var ac = doc.Root.Descendants(ns + "Positions")
                         .Where(item => {
                                  float? accInt = (float?)item.Element("AccruedInterest");
                                  return accInt != null && accInt.Value > 0.0f;
                                })
                         // etc, same as before...