using System;

using System.Xml;

using System.Xml.Serialization;

using System.IO;

public class Program

{

    public static readonly string INPUT = @"<ImportSession>

  <Batches>

    <Batch Name='MSG_SaintGobainPam_20210118' Description='SaintGobain_20210118' BatchClassName='SAINTGOBAIN - Faturas Notas' Processed='1'>

      <BatchFields>

        <BatchField Name='CAPALOTE' Value='0' />

        <BatchField Name='NCONTENTOR' Value='0' />

      </BatchFields>

      <Documents>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047804' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047804.pdf' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047842' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047842.pdf' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047843' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047843.pdf' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047849' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047849.pdf' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047853' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047853.pdf' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047854' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047854.pdf' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047855' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047855.pdf' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047860' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047860.pdf' ErrorCode='20' ErrorMessage='Illegal file format (\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047860.pdf)' />

          </Pages>

        </Document>

        <Document FormTypeName='DOC_SaintGobain_Faturas_Notas'>

          <IndexFields>

            <IndexField Name='ETIQUETA' Value='ZE80047861' />

          </IndexFields>

          <Pages>

            <Page ImportFileName='\\umm\c$\acxmlaid\SaintGobain\20210118\ZE80047861.pdf' />

          </Pages>

        </Document>

      </Documents>

    </Batch>

  </Batches>

</ImportSession>";

    public static void Main()

    {

        XmlSerializer serializer = new XmlSerializer(typeof(ImportSession));

        MemoryStream stream = new MemoryStream();

        using StreamWriter sw = new StreamWriter(stream);

        sw.Write(INPUT);

        sw.Flush();

        stream.Position = 0;

        // ^^ You provide a file stream, of course ...

        ImportSession session = (ImportSession)serializer.Deserialize(stream);

        foreach( Batch batch in session.Batches )

        {

            foreach( Document doc in batch.Documents )

            {

                foreach( Page page in doc.Pages )

                {

                    // Your DB-Insert here.

                    Console.WriteLine(

                        "BatchName='{0}', BatchDescription='{1}', BatchClassName='{2}', " + 

                        "ImportFileName={3}, ErrorMessage={4}, HasError={5}, Processed={6}",

                        batch.Name, batch.Description, batch.BatchClassName,

                        page.ImportFileName, page.ErrorMessage, page.HasError, batch.Processed

                    );

                }

            }

        }

    }

}

​

public class ImportSession

{

    public Batch[] Batches {get; set;}

}

​

public class Batch

{

    [XmlAttribute]

    public string Name {get; set;}

    [XmlAttribute]

    public string Description {get; set;}

    [XmlAttribute]

    public string BatchClassName {get; set;}

    [XmlAttribute]

    public bool Processed {get; set;}

    // Let's ignore BatchFields for now

    public Document[] Documents {get; set;}

}

​

public class Document

{

    [XmlAttribute]

    public string FormTypeName {get; set;}

    public IndexField[] IndexFields {get; set;}

    public Page[] Pages {get; set;}

}

​

public class IndexField

{

    [XmlAttribute]

    public string Name {get; set;}

    [XmlAttribute]

    public string Value {get; set;}

}

​

public class Page

{

    [XmlAttribute]

    public string ImportFileName{get; set;}

    [XmlAttribute]

    public string ErrorCode {get; set;}

    [XmlAttribute]

    public string ErrorMessage {get; set;}

    [XmlIgnore]

    public bool HasError => !string.IsNullOrWhiteSpace(ErrorMessage);

}

​