/*
* Function: GetFlightPlanById
* Description: Gets the FlightPlan from DB by flight ID.
*/
public FlightPlan GetFlightPlanById(string id)
{
FlightPlan flightPlan = null;
// Connection Opened //
_conn.Open();
var cmd = _conn.CreateCommand();
cmd.CommandText = @"SELECT * FROM flights
WHERE flight_name = '" + id + "' LIMIT 1";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var flightPk = (int)(long)At("flight_id", reader);
var passengers = (int)(long)At("passengers", reader);
var company = (string)At("company", reader);
var coord = new Coordinate(At("longitude", reader), At("latitude", reader));
var initialLocation = new InitialLocation(coord,
(string)At("takeoff", reader));
var segments = GetSegmentsByFlightPk(flightPk);
flightPlan = new FlightPlan(passengers, company, initialLocation, segments);
}
}
// Connection Closed //
_conn.Close();
return(flightPlan);
}
private void SetGetFlightPlanOutput()
{
InitialLocation initialLocation = new InitialLocation(34, 34, "2020-05-30T08:30:00Z");
var segments = new List <Segment> {
new Segment(35, 35, 100),
new Segment(36, 36, 20)
};
_getFlightPlanByIdOutput = new FlightPlan(222, "External Deafult Airlines", initialLocation, segments);
}
