using System;

using System.Linq;

using System.Xml.Linq;

using Newtonsoft.Json;

​

// https://stackoverflow.com/questions/78421023/

​

public class Program

{

    public static void Main()

    {

        var xmlDoc2 = XDocument.Parse(XmlText);

​

        var results1 =

            xmlDoc2.Descendants("build")

            .SelectMany(b => b.Descendants("Process")

            .Select(p => new

            {

                buildMach = b.Element("BuildMachine").Value,

                p1 = p.Element("ProcessName").Value,

                startTimeHeader = p.Element("startTimeHeader").Value,

                conditions = p.Descendants("Condition")

                    .Select(c => new

                    {

                        cName = c.Attribute("name").Value,

                        cValue = c.Attribute("value").Value

                    })

                    .ToList(),

                successCriteria = p.Descendants("SuccessCriteria")

                    .Select(sc => new

                    {

                        f1 = sc.Element("field").Value,

                        c1 = sc.Element("comparison").Value,

                        v1 = sc.Element("value").Value

                    })

                    .ToList()

            })).ToList();

        Console.WriteLine("Results 1 (LINQ method syntax):");

        foreach (var result in results1)

        {

            Console.WriteLine(JsonConvert.SerializeObject(result));

        }

        Console.WriteLine("");

​

        // LINQ query syntax

        var results2 = (

            from b in xmlDoc2.Descendants("build")

            from p in b.Descendants("Process")

            select new {

                buildMach = b.Element("BuildMachine").Value,

                p1 = p.Element("ProcessName").Value,

                startTimeHeader = p.Element("startTimeHeader").Value,

                conditions = (

                    from c in p.Descendants("Condition")

                    select new

                    {

                        cName = c.Attribute("name").Value,

                        cValue = c.Attribute("value").Value

                    })

                    .ToList(),

                successCriteria = (

                    from sc in p.Descendants("SuccessCriteria")

                    select new

                    {

                        f1 = sc.Element("field").Value,

                        c1 = sc.Element("comparison").Value,

                        v1 = sc.Element("value").Value

                    })

                    .ToList()

            })

            .ToList();

        Console.WriteLine("Results 2 (LINQ query syntax):");

        foreach (var result in results2)

        {

            Console.WriteLine(JsonConvert.SerializeObject(result));

        }

        Console.WriteLine("");

        Console.WriteLine("Done");

    }

​

    // Posted sample, - corrected for unquoted attribute values

    public static string XmlText = @"<?xml version=""1.0"" encoding=""UTF-8""?>

<BuildVerification>

    <codeFreezeTime>19:00</codeFreezeTime>

    <build>

        <BuildMachine>mach31</BuildMachine>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\R\filename1.cs"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison> 

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\R\filename2.cs"">

                        </Condition>

                    </Conditions>

                        <SuccessCriteria>

                            <field>Status</field>

                            <comparison>equal</comparison>

                            <value>Success</value>

                        </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\R\filename3.h"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                            <field>Status</field>

                            <comparison>equal</comparison>

                            <value>Success</value>

                    </SuccessCriteria>

            </Process>

​

        </build>

        <build>

        <BuildMachine>mach46</BuildMachine>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\filename4.cs"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison> 

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\fiename5.h"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\filename6.cs"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                            <field>Status</field>

                            <comparison>equal</comparison>

                            <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\D\filename7.cs"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison> 

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\K\filename8.cs"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\K\filename9.h"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\K\filename11.cs"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison> <!--can't use >= here -->

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\filename22.cs"">   

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinFileVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='VersionFile' value=""\\view\Build_NightlyDeveloper\K\filename33.cs"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinISProjectVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='ProductName' value=""P1"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinISProjectVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='ProductName' value=""P2"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>SpinISProjectVersionStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='ProductName' value=""P3"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>GetSWStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='DestinationPath' value=""D:\Builds\Retail\nightly"">

                        </Condition>

                        <Condition

                            name='DestinationPath' value=""D:\Builds\Retail\nightly"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison>

                        <value>Successful</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>ParseISLogStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='Nightly' value=""D:\nightly V17"">

                            </Condition>

                        <Condition

                            name='Projects' value=""33"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison> 

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>ParseISLogStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='Nightly' value=""D:\nightly V17 partb"">

                        </Condition>

                        <Condition

                            name='Projects' value=""8"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison> 

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>ParseISLogStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='BuildProject' value=""DInstallerBuild"">

                        </Condition>

                        <Condition

                            name='BaseBuildArea' value=""D:\R_Builds\K\v2.1\nightly"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                        <field>Status</field>

                        <comparison>equal</comparison> 

                        <value>Success</value>

                    </SuccessCriteria>

            </Process>

            <Process>

                <ProcessName>ParseISLogStats</ProcessName>

                <startTimeHeader>StartTime</startTimeHeader>

                    <Conditions>

                        <Condition

                            name='BuildProject' value=""KInstallerBuild"">

                        </Condition>

                        <Condition

                            name='BaseBuildArea' value=""D:\R_Builds\K\v2.1\nightly"">

                        </Condition>

                    </Conditions>

                    <SuccessCriteria>

                            <field>Status</field>

                            <comparison>equal</comparison> 

                            <value>Success</value>

                    </SuccessCriteria>

            </Process>

​

        </build>

    </BuildVerification>";

}