Beispiel #1
0
        static void Main(string[] args)
        {
            //var csvImporter = new CSVImporter();
            //var flights = csvImporter.ParseFlights(File.ReadAllLines("sample.csv"));

            var db = new Database("Server=localhost;Database=flightlog;Uid=flightlog;Pwd=flightlog;");
            var flights = db.ReadFlights();

            foreach(var f in flights)
            {
                WriteFlight(f);
            }

            /*
            WriteTime("total", flights.Sum(f => f.Flighttime.TotalMinutes));
            WriteTime("pic", flights.Sum(f => f.PICTime.TotalMinutes));
            WriteTime("dual", flights.Sum(f => f.DualTime.TotalMinutes));
            WriteTime("ifr", flights.Sum(f => f.IFRTime.TotalMinutes));

            System.Console.WriteLine($"landings: {flights.Sum(f => f.DayLandings)}");

            foreach(var f in flights)
            {
                //WriteFlight(f);
            }

            /*
            var invalidFlightTime = flights.Where(f => f.ArrivalTime - f.DepartureTime != f.Flighttime);
            System.Console.WriteLine($"{invalidFlightTime.Count()} invalid flights:");

            var airports = new Dictionary<string, Airport>();
            foreach(var a in csvImporter.ParseAirports(File.ReadAllLines("airports.csv")))
            {
                airports.Add(a.IcaoCode, a);
            }

            System.Console.WriteLine("cross country flights:");
            var xcTime = TimeSpan.FromDays(0);

            foreach(var f in flights.Where(f => Distance(f, airports) >= 50))
            {
                System.Console.WriteLine($"{f.DepartureAirport}->{f.DestinationAirport}, {Distance(f, airports)}");
                xcTime += f.Flighttime;
            }

            WriteTime("cross country", xcTime.TotalMinutes);*/
        }
Beispiel #2
0
 public FlightController()
 {
     db = new Database("Server=localhost;Database=flightlog;Uid=flightlog;Pwd=flightlog;");
 }