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; }