Austin
Austin

Reputation: 15

c# Web Service Sorting Result

I am trying to sort this select by vehicle.DateRegistered but its really confusing me and nothing i seem to do works. Any help would be much appreciated.

 var lookupValues = vehicles
            .Select(vehicle =>
                new LookupValue()
                {
                    Id = vehicle.Id,
                    Description = vehicle.RegistrationNumber + " " +vehicle.DateRegistered.ToString("dd/mm/yyyy"),
                    Data = Json.GetString(vehicle),
                    Active = true
                });
        return lookupValues;

Thanks Austin

Upvotes: 0

Views: 251

Answers (3)

Bernard
Bernard

Reputation: 17261

var lookupValues = vehicles
        .OrderBy(vehicle => vehicle.DateRegistered)
        .Select(vehicle =>
            new LookupValue()
            {
                Id = vehicle.Id,
                Description = vehicle.RegistrationNumber + " " +vehicle.DateRegistered.ToString("dd/mm/yyyy"),
                Data = Json.GetString(vehicle),
                Active = true
            });
    return lookupValues;

Upvotes: 1

Aghilas Yakoub
Aghilas Yakoub

Reputation: 28970

You can try with this code - based on OrderBy Linq operator

lookupValues.OrderBy(a=> a.DateRegistered);

Nota : Add DateRegistered in your selector

Or also you can use this

var lookupValues = vehicles

                .OrderBy(a => a.DateRegistered) 
                .Select(vehicle =>
                new LookupValue()
                {
                    Id = vehicle.Id,
                    Description = vehicle.RegistrationNumber + " " +vehicle.DateRegistered.ToString("dd/mm/yyyy"),
                    Data = Json.GetString(vehicle),
                    Active = true
                });
        return lookupValues;

Nota : you define direction of order : descending or ascending

Upvotes: 1

zeebonk
zeebonk

Reputation: 5034

Use the OrderBy extension method:

var lookupValues = vehicles.OrderBy(v => v.DateRegistered).Select(.....);

Upvotes: 3

Related Questions