CODEWITHSUNDEEP
c#collectionssql-order-by
Hallaghan
Hallaghan

Reputation: 1941

Order List by Date and Time (in string format)

Probably what I'm asking is quite simple but I don't seem to be getting this one out. I have a list of elements containing a Date field and a Time field. The Date field is a regular DateTime and the Time field is a string. Time is formatted like HH:mm and ranges in 24h.

Ordering my list by Date is simple by doing List.OrderBy(e => e.Date), but I don't seem to be able to later order it by Time so that the order of the records is according the date and the time.

I tried this out but it's probably a big mistake!

    List = List.OrderBy(e => e.EstimatedDate).OrderBy(e => new TimeSpan(int.Parse(e.EstimatedTime.Substring(0,e.EstimatedTime.LastIndexOf(":"))),int.Parse(e.EstimatedTime.Substring(e.EstimatedTime.LastIndexOf(":")+1)),0).TotalMinutes);

I hope someone can help me out with this one.

Upvotes: 8

Views: 37188

Answers (3)

Roger
Roger

Reputation: 1082

You know ThenBy() ?

List = List.OrderBy(DATE).ThenBy(Time)

Upvotes: 2

decyclone
decyclone

Reputation: 30830

why not try something like following:

List.OrderBy(e => e.Date).ThenBy(e => DateTime.Parse(e.Time));
// May need to change DateTime.Parse(e.Time) with appropriate conversion code

Upvotes: 4

Marc Gravell
Marc Gravell

Reputation: 1062600

You want OrderBy(...).ThenBy(...); and also - not that if the time is in HH:mm you don't have to parse it - you can just sort it alphabetically, i.e.

List = List.OrderBy(e => e.EstimatedDate).ThenBy(e => e.EstimatedTime).ToList();

or via LINQ:

List = (from e in List
        orderby e.EstimatedDate, e.EstimatedTime
        select e).ToList();

Upvotes: 17

Related Questions