using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

public class Earthquake
{
  public double Magnitude { get; set; }
  public string Location { get; set; }
  public string Latitude { get; set; }
  public string Longitude { get; set; }
  public double depth { get; set; }
  public DateTime date { get; set; }
  public string EventID { get; set; }
  public string URL { get; set; }
  public Earthquake()
    : this(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty)
  { }

  public Earthquake(string magna, string locate, string lat, string longi, string dept, string dat, string Event, string website)
  {
    Magnitude = Convert.ToDouble(magna);
    Location = locate;
    Latitude = lat;
    Longitude = longi;
    depth = Convert.ToDouble(dept);
    date = Convert.ToDateTime(dat);
    EventID = Event;
    URL = website;
  }

}

public class ManageData
{
  public void getData()
  {
    var Quakes = new List<Earthquake>();

    string[] text = File.ReadAllLines(@"Earthquakes.csv");
    foreach (string line in text)
    {
      string[] myColumns = line.Split(',');
      Earthquake earth = new Earthquake(myColumns[0], myColumns[1], myColumns[2], myColumns[3], myColumns[4], myColumns[5], myColumns[6], myColumns[7]);
      //here i want to put each data in the Earthquake class
      Quakes.Add(earth);
    }

    //Now for the sorting bit
    var QuakesSortedByDepth = Quakes.OrderBy(q => q.depth);
  }


}