CODEWITHSUNDEEP
c#xmllinq
Dineshp
Dineshp

Reputation: 31

Child Nodes in XML File

I am trying to get the child nodes in my xml file and print it out..however i cannot. It is just printing one element instead of all. please help.

XDocument doc = XDocument.Load(GlobalClass.GlobalUrl);
XElement xelement = XElement.Load(GlobalClass.GlobalUrl);

var query = from nm in xelement.Elements("EmployeeFinance")
            where (int)nm.Element("EmpPersonal_Id") == empID
            select new AllowancePaid
            {
                Income_ID = (decimal)nm.Element("Allowance-Grade")
                                       .Element("Amount")
            };

var x = query.ToList();

foreach (var ele in x) {
    Debug.WriteLine(ele.Income_ID);
}

My XML File

<EmployeeFinance>
  <EmployeeEmploy_Id>4891</EmployeeEmploy_Id> 
  <EmpPersonal_Id>28407</EmpPersonal_Id> 
  <Employee_Number>11715</Employee_Number> 
  <Allowance-Grade>
    <Amount BenListID="32">6000.00</Amount> 
    <Amount BenListID="59">100000.00</Amount> 
  </Allowance-Grade>
</EmployeeFinance>

Adding the elements

var result = from element in doc.Descendants("EmployeeFinance")
             where int.Parse(element.Element("EmpPersonal_Id").Value) == tt.Employee_Personal_InfoEmp_id
             select element;
foreach (var ele in result)
{                                      
    ele.Element("Allowance-Grade")
       .Add(new XElement("Amount", new XAttribute("BenListID", tt.ID), tt.Amount));
    doc.Save(GlobalClass.GlobalUrl);
}

Upvotes: 0

Views: 272

Answers (2)

Davi Ruiz
Davi Ruiz

Reputation: 120

        XDocument xelement = XDocument.Parse(xml);

        var query = from nm in xelement.Elements("EmployeeFinance")
                    where (int)nm.Element("EmpPersonal_Id") == 28407
                    select new
                    {
                        Amounts = nm.Element("Allowance-Grade")
                                               .Elements("Amount")
                                               .Select(
                                               row =>
                                                   new {
                                                        id = row.Value
                                                   }
                                               ).ToList()
                    };

        var x = query.ToList();

        foreach (var ele in x)
        {
            foreach(var a in ele.Amounts)
                Console.WriteLine(a);
        }

Upvotes: 0

Damith
Damith

Reputation: 63065

problem is you selecting one amount node .Element("Amount") but there are many nodes. Change it to .Elements("Amount") and need to change few places. I haven't tested but logic should something like below will work `

var query = from nm in xelement.Elements("EmployeeFinance")
            where (int)nm.Element("EmpPersonal_Id") == empID
            select new AllowancePaid
            {
                AllowanceList = nm.Element("Allowance-Grade").Elements("Amount").Select( a=>(decimal)a.Value).ToList()

            };

foreach (var ele in query) {
    foreach (var a in ele.AllowanceList) {
      Debug.WriteLine(a);
     }
}

Upvotes: 2

Related Questions