public int WriteFlight(Flight f)
{
var cmd = new MySqlCommand(@"INSERT INTO flight (pilot, tailnumber, type, crew,
departure_airport, departure_time, arrival_airport, arrival_time,
landings_day, landings_night, pic_time, dual_time, night_time, ifr_time, remarks)
VALUES (1, @tailnumber, @type, @crew, @departure_airport, @departure_time,
@arrival_airport, @arrival_time, @landings_day, @landings_night, @pic_time, @dual_time,
@night_time, @ifr_time, @remarks);", db);
cmd.Parameters.AddWithValue("tailnumber", f.Tailnumber);
cmd.Parameters.AddWithValue("type", f.Type);
cmd.Parameters.AddWithValue("crew", f.Crew);
cmd.Parameters.AddWithValue("departure_airport", airports[f.DepartureAirport].Id);
cmd.Parameters.AddWithValue("departure_time", f.DepartureTime);
cmd.Parameters.AddWithValue("arrival_airport", airports[f.DestinationAirport].Id);
cmd.Parameters.AddWithValue("arrival_time", f.ArrivalTime);
cmd.Parameters.AddWithValue("landings_day", f.DayLandings);
cmd.Parameters.AddWithValue("landings_night", f.NightLandings);
cmd.Parameters.AddWithValue("pic_time", f.PICTime.TotalMinutes);
cmd.Parameters.AddWithValue("dual_time", f.DualTime.TotalMinutes);
cmd.Parameters.AddWithValue("night_time", f.NightTime.TotalMinutes);
cmd.Parameters.AddWithValue("ifr_time", f.IFRTime.TotalMinutes);
cmd.Parameters.AddWithValue("remarks", f.Remarks);
return cmd.ExecuteNonQuery();
}
static void WriteFlight(Flight f)
{
System.Console.WriteLine($"{f.DepartureTime:yyyy-MM-dd} {f.Tailnumber,-6} {f.Type}, {f.DepartureAirport} {f.DepartureTime:hh:mm} {f.DestinationAirport} {f.ArrivalTime:hh:mm} {f.DayLandings} {f.FlightTime.TotalHours:00}:{f.FlightTime.Minutes:00}");
}
static double Distance(Flight f, Dictionary<string, Airport> airports)
{
var from = airports[f.DepartureAirport];
var to = airports[f.DestinationAirport];
return from.Location.GetDistanceTo(to.Location) / 1852.0;
}
private Flight ReadFlight(MySqlDataReader reader)
{
var flight = new Flight
{
Id = reader.GetInt32("id"),
Tailnumber = reader.GetString("tailnumber"),
Type = reader.GetString("type"),
Crew = reader.GetString("crew"),
DepartureAirport = reader.GetString("departure_airport"),
DepartureTime = reader.GetDateTime("departure_time"),
DestinationAirport = reader.GetString("arrival_airport"),
ArrivalTime = reader.GetDateTime("arrival_time"),
DayLandings = reader.GetInt32("landings_day"),
NightLandings = reader.GetInt32("landings_night"),
PICTime = TimeSpan.FromMinutes(reader.GetInt32("pic_time")),
DualTime = TimeSpan.FromMinutes(reader.GetInt32("dual_time")),
NightTime = TimeSpan.FromMinutes(reader.GetInt32("night_time")),
IFRTime = TimeSpan.FromMinutes(reader.GetInt32("ifr_time")),
Remarks = reader.GetString("remarks")
};
flight.FlightTime = flight.ArrivalTime - flight.DepartureTime;
return flight;
}
