Reading specific task from XML with C#

Question

How we can read in a list the values from the target P (Price) from the following xml?

<D d="2012-11-01">
  <P t="00:00:00+01:00">39.90999985</P> 
  <P t="01:00:00+01:00">36.22999954</P> 
  <P t="02:00:00+01:00">29.44000053</P> 
</D>
<D d="2012-11-02">
  <P t="00:00:00+01:00">32.33000183</P> 
  <P t="01:00:00+01:00">29.12999916</P> 
  <P t="02:00:00+01:00">30.18000031</P> 
  <P t="03:00:00+01:00">29.12999916</P> 
</D>

I know the procedure (there are other topics here for this) in C# but i have the query of the chances inside the target P and D. Play this any role or if i read from target P it will read all the prices like the above xml file

 <D>
  <P>39.90999985</P> 
  <P>36.22999954</P> 
  <P>29.44000053</P> 
</D>

You may want to consider re-wording your question, I struggle to make sense of it. — Mike
– Mike, Commented Nov 2, 2012 at 11:35
I would say that you should re-structure the xml content if you have access or are responsible for the output. Date should an element, time should be the child and price a child node of time. — Derek
– Derek, Commented Nov 2, 2012 at 11:37
Yeah sorry! If you read just the target "P" from the first and the second xml file give the same result. So it does not play any role here the chanche of t in the target "P". Done/ — amigo
– amigo, Commented Nov 2, 2012 at 11:39

Markus Jarderot · Accepted Answer · 2012-11-02 12:05:53Z

class Price
{
    public DateTime? Timestamp { get; set; }
    public decimal Price { get; set; }
}

public IEnumerable<Price> GetPrices(XDocument document)
{
    return
        from d in document.Root.Elements("D")
        let date = d.Attribute("d")
        from p in d.Elements("P")
        let time = p.Attribute("t")
        select new Price
        {
            Timestamp = (date == null || time == null)
                ? (DateTime?) null
                : DateTime.Parse(date.Value + " " + time.Value),
            Price = Convert.ToDecimal(p.Value)
        };
}

Alternatively, using XmlSerializer (Assuming the root-element is named <Data>):

[XmlType]
public class Data : List<Day>
{   
}

[XmlType("D")]
public class Day
{
    [XmlAttribute("d")]
    public string Date { get; set; }

    [XmlElement("P")]
    public List<Price> Prices { get; set; }
}

public class Price
{
    [XmlAttribute("t")]
    public string Time { get; set; }

    [XmlText]
    public decimal Value { get; set; }
}

public Data ParseXml(TextReader reader)
{
    var ser = new XmlSerializer(typeof(Data));
    return (Data) ser.Deserialize(reader)
}

Collectives™ on Stack Overflow

Reading specific task from XML with C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related