query xml data to text output

using System.Xml.Linq;

// Load the XML document 
XDocument xdoc = XDocument.Load("80018210.xml");
// Get reference to root element
XElement root = xdoc.Root;

// Get all the unique LNNUMs in the documents
List<String> uniqueLNNUMs = (from LNNUM in root.Descendants("LNNUM")
                             select LNNUM.Value).Distinct().ToList();

// Display all the unique LNNUMs
foreach (var lnnum in uniqueLNNUMs)
{
    Console.WriteLine(lnnum);
}

Select allOpen in new window

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

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
        }
        public List<string> createUniqueLNNUMlist(string filename)
        {
            // Load the XML document 
            XDocument xdoc = XDocument.Load(filename);
            // Get reference to root element
            XElement root = xdoc.Root;

            // Get all the unique LNNUMs in the documents
            List<string> uniqueLNNUMs = (from LNNUM in root.Descendants("LNNUM")
                                         select LNNUM.Value).Distinct().ToList();

            // Display all the unique LNNUMs
            foreach (var lnnum in uniqueLNNUMs)
            {
                Console.WriteLine(lnnum);
            }
            return uniqueLNNUMs;
        }
    }
}

Select allOpen in new window

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

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a List of String variable to hold the return value and
            // call the method to fill it.
            List<String> lnnumList = createUniqueLNNUMlist(""D:\\Program Files\\DCS.NET\\Data\\80018210.xml"");

            // When creating a Console program during development put this ReadLine before
            // the program exits so that the Console window does not close until you are
            // ready then press the return key on the keyboard
            Console.ReadLine();
        }

        // If this function is NOT made static then an instance of the class containing the method
        // will need to be created. So I am making this method static so that we can just us it in Main.
        public static List<string> createUniqueLNNUMlist(string filename)
        {
            // Load the XML document 
            XDocument xdoc = XDocument.Load(filename);
            // Get reference to root element
            XElement root = xdoc.Root;

            // Get all the unique LNNUMs in the documents
            List<string> uniqueLNNUMs = (from LNNUM in root.Descendants("LNNUM")
                                         select LNNUM.Value).Distinct().ToList();

            // Display all the unique LNNUMs
            foreach (var lnnum in uniqueLNNUMs)
            {
                Console.WriteLine(lnnum);
            }
            return uniqueLNNUMs;
        }
    }
}

Select allOpen in new window

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

namespace ConsoleApplication4
{
    class Program
    {
        private static XDocument xdoc;
        private static XElement root;

        static void Main(string[] args)
        {
            // Load the XML document 
            xdoc = XDocument.Load("80018210.xml");
            // Get reference to root element
            root = xdoc.Root;

            // Get all the unique LNNUMs in the documents
            List<String> lnnumList = createUniqueLNNUMlist();
            // Get 450 record types
            List<RecordType450> R450 = Get450Record();
            foreach (RecordType450 rec in R450)
            {
                Console.WriteLine(rec.ToString());
            }

            // Is here to stop the program from terminating press enter to continue
            Console.ReadLine();
        }

        // If this function is NOT made static then an instance of the class containing the method
        // will need to be created. So I am making this method static so that we can just us it in Main.
        public static List<string> createUniqueLNNUMlist()
        {
            // Get all the unique LNNUMs in the documents
            List<string> uniqueLNNUMs = (from LNNUM in root.Descendants("LNNUM")
                                         select LNNUM.Value).Distinct().ToList();

            // Display all the unique LNNUMs
            foreach (var lnnum in uniqueLNNUMs)
            {
                Console.WriteLine(lnnum);
            }
            return uniqueLNNUMs;
        }

        public static List<RecordType450> Get450Record()
        {
            //List<String> results = new List<string>();
            List<RecordType450> R450 = 
                (from loc in root.Descendants("Location").Elements("Movements").Elements("Movement")
                 where loc.Element("MCODE").Value == "5"
                 group loc by loc.Parent.Parent.Element("LNNUM").Value into locGroup
                 select new RecordType450
                 {
                     LNNUM = locGroup.Key,
                     EMILES = Math.Round(locGroup.Sum( em => Decimal.Parse( em.Element("EMILES").Value)), 1),
                     EndTest = locGroup.Select( s => s.Parent.Parent.Elements("Movement")).Count(),
                     CarID = "??????",
                     Defects = root.Descendants("Locations").Elements("Location").Where(mc => mc.Element("Movements").Element("Movement").Element("MCODE").Value == "5").Elements("Defects").Elements("Defect").Count()
                 }).ToList();
            return R450;
        }
    }

    // The query in method Get450Record() uses this class to create a return type of the query
    public class RecordType450
    {
        private String type = "450";
        public String Type { get { return type; } }
        public String LNNUM { get; set; }
        public Decimal EMILES { get; set; }
        public Int32 EndTest { get; set; }
        public String CarID { get; set; }
        public Int32 Defects { get; set; }

        public override string ToString()
        {
            return String.Format("{0},{1},{2},{3},{4}", Type, LNNUM, EMILES, CarID, EndTest);
        }
    }
}

Select allOpen in new window

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

namespace ConsoleApplication4
{
    class Program
    {
        private static XDocument xdoc;
        private static XElement root;

        static void Main(string[] args)
        {
            // Load the XML document 
            xdoc = XDocument.Load("80018210.xml");
            // Get reference to root element
            root = xdoc.Root;

            // Get all the unique LNNUMs in the documents
            List<String> lnnumList = createUniqueLNNUMlist();
            // Get 450 record types
            List<RecordType450> R450 = Get450Record();
            foreach (RecordType450 rec in R450)
            {
                Console.WriteLine(rec.ToString());
            }

            // Is here to stop the program from terminating press enter to continue
            Console.ReadLine();
        }

        // If this function is NOT made static then an instance of the class containing the method
        // will need to be created. So I am making this method static so that we can just us it in Main.
        public static List<string> createUniqueLNNUMlist()
        {
            // Get all the unique LNNUMs in the documents
            List<string> uniqueLNNUMs = (from LNNUM in root.Descendants("LNNUM")
                                         select LNNUM.Value).Distinct().ToList();

            // Display all the unique LNNUMs
            foreach (var lnnum in uniqueLNNUMs)
            {
                Console.WriteLine(lnnum);
            }
            return uniqueLNNUMs;
        }

        public static List<RecordType450> Get450Record()
        {
            //List<String> results = new List<string>();
            List<RecordType450> R450 = 
                (from loc in root.Descendants("Location").Elements("Movements").Elements("Movement")
                 where loc.Element("MCODE").Value == "5"
                 group loc by loc.Parent.Parent.Element("LNNUM").Value into locGroup
                 select new RecordType450
                 {
                     LNNUM = locGroup.Key,
                     EMILES = Math.Round(locGroup.Sum( em => Decimal.Parse( em.Element("EMILES").Value)), 1),
                     EndTest = locGroup.Select( s => s.Parent.Parent.Elements("Movement")).Count(),
                     CarID = locGroup.FirstOrDefault().Parent.Parent.Parent.Parent.Element("RPTID").Value.Substring(0, 3),
                     Defects = root.Descendants("Locations").Elements("Location").Where(mc => mc.Element("Movements").Element("Movement").Element("MCODE").Value == "5").Elements("Defects").Elements("Defect").Count()
                 }).ToList();
            return R450;
        }
    }

    // The query in method Get450Record() uses this class to create a return type of the query
    public class RecordType450
    {
        private String type = "450";
        public String Type { get { return type; } }
        public String LNNUM { get; set; }
        public Decimal EMILES { get; set; }
        public Int32 EndTest { get; set; }
        public String CarID { get; set; }
        public Int32 Defects { get; set; }

        public override string ToString()
        {
            return String.Format("{0},{1},{2},{3},{4}", Type, LNNUM, EMILES, CarID, EndTest);
        }
    }
}

Select allOpen in new window

RDate = DateTime.Parse(locGroup.FirstOrDefault().Parent.Parent.Parent.Parent.Element("DATE").Value).ToString("yyyyMMdd")

Select allOpen in new window