Sorting Array By Object's Values

Question

I have an object called RateQuote that has the following:

Name
Term
Miles

For example:

rate  = new RateQuote() {
  Term = 24,
  Miles = 120000,
  Name = '24 mo. / 120000 miles'
}

and

rate = new RateQuote() {
  Term = 24,
  Miles = 50000,
  Name = '24 mo. / 50000 miles'
}

and

rate = new RateQuote() {
  Term = 12,
  Miles = 50000,
  Name = '12 mo. / 50000 miles'
}

These RateQuote's are getting added to a RateQuote[] object:

  public void AddRate(RateQuote rate)
  {
      Rates = Rates.Concat(new RateQuote[] { rate }).ToArray();
  }

After they are added by the .Concat, how would I sort it? If my code adds the "24 mo. / 120000 miles" first, then the "24 mo. / 50,000 miles" second and then the "12 mo. / 50000 miles" last, I would want it to sort it so that it is in this order:

12 mo. / 50000
24 mo. / 50000
24 mo. / 120000

It should sort by months first, then miles. I am confused and would appreciate help. I know there is a .Sort function I can use, but not sure how to use it in this context. Thank you in advance for all of your help.

Would be much easier to sort before .Concat (using .OrderBy), if possible. And why wouldn't it be? — McGarnagle
– McGarnagle, Commented Nov 4, 2013 at 19:06
It's a very strange way to make dynamic array. Why don't you use List<RateQuote>? — Dennis
– Dennis, Commented Nov 4, 2013 at 19:08
@Dennis, the code I am working with was written by someone else. It's on my list of things to fix in the future. My company has a lot of things on our plate and changing this to a List<RateQuote> isn't on the top of the list right now. I have it on my list of things to fix when I can. Our code base is large and would take time to change right now. Thanks. — Turp
– Turp, Commented Nov 4, 2013 at 19:36

Habib · Accepted Answer · 2013-11-04 19:07:30Z

9

It appears you want to order first by Term and then by Miles. Then you can use:

var sorted = Rates
               .OrderBy(r=> r.Term)
               .ThenBy(r=> r.Miles)
               .ToArray();

answered Nov 4, 2013 at 19:07

Habib

224k30 gold badges420 silver badges446 bronze badges

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

3 Comments

Turp Over a year ago

This worked for me. Simple and sorted my list how it should.

Habib Over a year ago

@Turp, you are welcome, Also consider using List<RateQuote> instead of an array. You can always get an array back from the list by calling ToArray

Turp Over a year ago

I came into my Developer position with an application that already existed. I am slowly, but surely, correcting things like this to make our platform faster and enjoyable for all. This is on my list of things to do, but for now, I just had to sort this list before it was displayed. Due to compliance issues. Thanks!

FlyingStreudel · Accepted Answer · 2013-11-04 19:20:55Z

1

You could use linq, something like:

var orderedRates = rates.GroupBy(rq => rq.Term)
                       .OrderBy(g => g.Key)
                       .SelectMany(g => g.OrderBy(rq => rq.Miles))
                       .ToArray();

edited Nov 4, 2013 at 19:20

answered Nov 4, 2013 at 19:08

FlyingStreudel

4,5044 gold badges36 silver badges55 bronze badges

11 Comments

Harrison Over a year ago

this doesn't do what the OP is asking...Sort by Months first then by Miles

Chandan Kumar Over a year ago

@Harrison : please read the question properly and stop negative voting.

Turp Over a year ago

@FlyingStreudel, This method works as well. However, to be honest, I am not sure what the difference between yours and Habib's is. Yours just seems like a lot more code. Your thoughts on this?

FlyingStreudel Over a year ago

@Turp I didn't know ThenBy was an extension method :)

Habib Over a year ago

This is way complicated code to order an array based on two properties. You are first grouping and then flattening the collection, and that too for no reason. It makes the code hard to read and follow, and should be avoided in production.

|

Collectives™ on Stack Overflow

Sorting Array By Object's Values

2 Answers 2

3 Comments

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related