How to sort XML content by 2 Attributes in C# using Linq?

Question

I'm new in C# and want to sort an XML in memory by START Attribute but I need to take into account that when START_PLUSDAY Attribute exists.

Here is my XML:

<SCHEDULE>
   <PROGS>
      <PROG START="07:00:00" END="08:00:00">
          <ID></ID>
          <DATA>...</DATA>
             <STUFF>...</STUFF>
      </PROG>
      <PROG START="01:00:00" START_PLUSDAY="1" END="02:00:00" END_PLUSDAY="1">
          <ID></ID>
          <DATA>...</DATA>
             <STUFF>...</STUFF>
      </PROG>
   </PROGS>
</SCHEDULE>

The result I want should look like this:

<SCHEDULE>
   <PROGS>
      <PROG START="07:00:00" END="08:00:00">
          <ID></ID>
          <DATA>...</DATA>
             <STUFF>...</STUFF>
      </PROG>
      <PROG START="01:00:00" START_PLUSDAY="1" END="02:00:00" END_PLUSDAY="1">
          <ID></ID>
          <DATA>...</DATA>
             <STUFF>...</STUFF>
      </PROG>
   </PROGS>
</SCHEDULE>

jdweng · Accepted Answer · 2021-03-05 09:24:23Z

1

Try following :

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

namespace ConsoleApplication1
{
    class Program
    {
        const string FILENAME = @"c:\temp\test.xml";
        static void Main(string[] args)
        {
            XDocument doc = XDocument.Load(FILENAME);

            XElement progs = doc.Descendants("PROGS").FirstOrDefault();

            List<XElement> sortedProg = progs.Elements("PROG")
                .OrderBy(x => (int?)x.Attribute("START_PLUSDAY"))
                .ThenBy(x => (DateTime)x.Attribute("START")).ToList();
            XElement newProgs = new XElement("PROGS", sortedProg);

            progs.ReplaceWith(newProgs);
        }
    }
}

answered Mar 5, 2021 at 9:24

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ziga Over a year ago

Brilliant. Thank you very much. For my use i can skip progs.ReplaceWith(newProgs); and just parse foreach (XElement xe in newProgs.Descendants("PROGRAMME")). Thanks again!!!

Collectives™ on Stack Overflow

How to sort XML content by 2 Attributes in C# using Linq?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related