Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to I use TryParse in a linq query of xml data?

Tags:

c#

xml

linq

I'm working with in memory xml of daily stock market data, and I'm getting the value "8/221/19055" for one of the dates. I see that TryParse is likely my best bet to check for a valid date, but the MSDN doc seems light on an explanation of the 2nd parameter "out DateTime result." How can I use it in my linq query below?

var makeInfo =
         from s in doc.Descendants("quote")
         where s.Element("LastTradeDate") != null
                && s.Attribute("symbol") != null
         let dateStr = s.Element("LastTradeDate").Value
         where !string.IsNullOrEmpty(dateStr)
                && DateTime.Parse(dateStr, enUS) == targetDate
         select new DailyPricingVolDP((string)s.Attribute("symbol"),
                                      (DateTime)s.Element("LastTradeDate"),
                                      (double)s.Element("Open"),
                                      (double)s.Element("DaysHigh"),
                                      (double)s.Element("DaysLow"),  
                                      (double)s.Element("LastTradePriceOnly"),
                                       (long)s.Element("Volume"));
like image 593
StatsViaCsh Avatar asked Jan 25 '12 13:01

StatsViaCsh


2 Answers

Func<string, DateTime?> tryToGetDate =
        value =>
            {
                DateTime dateValue;
                return DateTime.TryParse(value, out dateValue) ? (DateTime?) dateValue : null;
            };

    var makeInfo =
         from s in doc.Descendants("quote")
         where s.Element("LastTradeDate") != null
                && s.Attribute("symbol") != null
         let dateStr = s.Element("LastTradeDate").Value
         let dateValue = tryToGetDate(dateStr)
         where dateValue != null && (DateTime)dateValue == targetDate
         select .... etc etc
like image 108
Jeno Laszlo Avatar answered Oct 18 '22 17:10

Jeno Laszlo


To eliminate out parameter of TryParse you can abstract entire parsing in the generic delegate like standard Converter<TInput, TOutput>:

Converter<string, DateTime> converter = (str) =>
                {
                    DateTime dateTime;
                    if (!DateTime.TryParse(str, out dateTime))
                    {
                       // custom business logic for such cases
                       dateTime = DateTime.MinValue;
                    }

                    return dateTime;
                };

or in case you need passing in more parameters use Func<string, string, DateTime>, it is up to you, implementation (string to date parsing logic) is up to you as well.

Then use in the query:

converter(rawString) == targetDate
like image 3
sll Avatar answered Oct 18 '22 17:10

sll