c# how do i sort a group of lists

dal · 22 Jun 2018 at 14:36

Hi all. I know this may not be the best way of doing this but I've got a small group of lists that represent aircraft data.
Which looks like this :

public List <string> AIRCRAFT_ID = new List<string>();
public List <int> ALTITUDE = new List<int>();
public List <int> passengers_on_board = new List<int> ();

So each element of the 3 lists represents one aircraft. This works fine when all I'm doing is adding aircraft to the list.

Now how would I get on if i wanted to sort the list based on say altitude because if I was to do something like :
ALTITUDE.sort .....

Then the other lists would be out of sync.

This is quite new to me so hopefully any help would be in laymans terms (if possible).

Regards

Quartz · 22 Jun 2018 at 14:55

You need one array with three items in each record.

Randomface74 · 22 Jun 2018 at 14:59

Step 1. Make a data table.
https://msdn.microsoft.com/en-us/library/system.data.datatable(v=vs.110).aspx

Step 2. Sort the data table.
https://stackoverflow.com/questions/9107916/sorting-rows-in-a-data-table

chroniclard · 22 Jun 2018 at 15:03

Class and linq.

public class Aircraft
{
public string AIRCRAFT_ID { get; set; }
public int ALTITUDE { get; set; }
public int passengers { get; set; }
}

var aircrafts = new List<Aircraft>();

aircrafts.Add(new Aircraft { AIRCRAFT_ID = "y", ALTITUDE = 1, passengers = 100 });
aircrafts.Add(new Aircraft { AIRCRAFT_ID = "a", ALTITUDE = 2, passengers = 200 });
aircrafts.Add(new Aircraft { AIRCRAFT_ID = "z", ALTITUDE = 2, passengers = 400 });

aircrafts = aircrafts.OrderBy(x => x.AIRCRAFT_ID).ToList();

Can also sort on multiple items.

aircrafts = aircrafts.OrderBy(x => x.AIRCRAFT_ID).ThenBy(x => x.passengers).ToList();

dal · 22 Jun 2018 at 16:07

cheers Ill take a look

dal · 24 Jun 2018 at 23:05

chroniclard said:
Class and linq.

public class Aircraft
{
public string AIRCRAFT_ID { get; set; }
public int ALTITUDE { get; set; }
public int passengers { get; set; }
}

var aircrafts = new List<Aircraft>();

aircrafts.Add(new Aircraft { AIRCRAFT_ID = "y", ALTITUDE = 1, passengers = 100 });
aircrafts.Add(new Aircraft { AIRCRAFT_ID = "a", ALTITUDE = 2, passengers = 200 });
aircrafts.Add(new Aircraft { AIRCRAFT_ID = "z", ALTITUDE = 2, passengers = 400 });

aircrafts = aircrafts.OrderBy(x => x.AIRCRAFT_ID).ToList();

Can also sort on multiple items.

aircrafts = aircrafts.OrderBy(x => x.AIRCRAFT_ID).ThenBy(x => x.passengers).ToList();

I've decided to go with this but how could I get the index of a certain record if I only had say the aircraft ID ?
Regards.

GravyMonster · 25 Jun 2018 at 08:41

Use FindIndex()

Code:

aircrafts.FindIndex(a => a.AIRCRAFT_ID == "y");

chroniclard · 25 Jun 2018 at 10:34

You can also just grab the whole class object with linq and access the relevant data that way.

var x = aircrafts.FirstOrDefault(a => a.AIRCRAFT_ID == "y");

can then do
x.ALTITUDE
or
x.passengers

also sort your variable names out

GravyMonster · 25 Jun 2018 at 14:01

chroniclard said:
also sort your variable names out

100% this. If you worked in my office you'd already have been yelled at

dal · 25 Jun 2018 at 20:31

Spunkey said:
100% this. If you worked in my office you'd already have been yelled at

dal · 25 Jun 2018 at 20:32

Spunkey said:
100% this. If you worked in my office you'd already have been yelled at

Lol cheers guys