C#: how to read attributes of xml elements and subelements

Question

i have an xml file with the structure in the appendix. I'm trying to write a function in C#, which should do the following: arrange all elements and sub-elements in different lists so that for each component (comp) and each box (cast) the geometric parameters (GeoVar) and the prop parameters (prop) are read out and that they are subordinate to the cast or comp or product. This must be done via the PNr. how can I assign the PNr from the parent element to the GeoVar element or prop element? I don't know how to do that! Thank you for your help...

desired result:

image

user_5015238 · Answer

Here is a recursive algorithm that creates a dictionary.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Xml;
using System.Xml.Linq;

namespace ConsoleApplication186
{
    class Program
    {
        const string FILENAME = @"c:	emp	est.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);
            XElement root = doc.Root;
            Product.GetTree(null,root, null);

            Dictionary dict = Product.products
                .GroupBy(x => x.PNr, y => y)
                .ToDictionary(x => x.Key, y => y.FirstOrDefault());

        }
    }
    public class Product
    {
        public static List products { get; set; }

        public Product parent { get; set; }
        public string name { get; set; }
        public string PNr { get; set; }
        public string typ { get; set; }
        public Dictionary geoVar { get; set; }
        public Dictionary prop { get; set; }
        public List casts { get; set; }
        public List components { get; set; }

        public static void GetTree(Product newProduct , XElement element, Product parent)
        {
            if (products == null) products = new List();
            if (newProduct == null) newProduct = new Product();
            products.Add(newProduct);
            newProduct.parent = parent;
            newProduct.name = (string)element.Attribute("name");
            newProduct.PNr = (string)element.Attribute("PNr");
            newProduct.typ = (string)element.Attribute("typ");

            newProduct.geoVar = element.Element("GeoVar").Elements()
                .GroupBy(x => x.Name.LocalName, y => y)
                .ToDictionary(x => x.Key, y => (decimal)y.FirstOrDefault());

            newProduct.prop = element.Element("Prop").Elements()
                .GroupBy(x => x.Name.LocalName, y => y)
                .ToDictionary(x => x.Key, y => (string)y.FirstOrDefault());

            foreach (XElement comp in element.Elements("Cast"))
            {
                if (newProduct.casts == null) newProduct.casts = new List();
                Product cast = new Product();
                newProduct.casts.Add(cast);
                GetTree(cast, comp, newProduct);
            }
            foreach (XElement comp in element.Elements("Comp"))
            {
                if (newProduct.components == null) newProduct.components = new List();
                Product component = new Product();
                newProduct.components.Add(component);
                GetTree(component, comp, newProduct);
            }
        }
    }

}

C#: how to read attributes of xml elements and subelements

1 Answers