/* * 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); }