/// <summary> /// Get flights by origin country from the data base /// </summary> /// <param name="countryCode"></param> /// <returns></returns> public IList <FlightRazor> GetFlightsByOriginCountryAndDestination(long origin, long destination) { List <FlightRazor> flights = new List <FlightRazor>(); using (SqlConnection conn = new SqlConnection(FlyingCenterConfig.ConString)) { SqlCommand cmd = new SqlCommand("GET_FLIGHTS_BY_ORIGIN_COUNTRY_AND_DESTINATION_COUNTRY_ID", conn); cmd.Parameters.Add(new SqlParameter("@ORIGIN_COUNTRY_CODE", origin)); cmd.Parameters.Add(new SqlParameter("@DESTINATION_COUNTRY_CODE", destination)); cmd.Connection.Open(); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default); while (reader.Read() == true) { FlightRazor flight = new FlightRazor { ID = (Int64)reader["ID"], AirlineName = (string)reader["AIRLINE_NAME"], AirlineNameAndFlightID = $"{(string)reader["AIRLINE_NAME"]} {(Int64)reader["ID"]}", OriginCountry = (string)reader["ORIGIN_COUNTRY"], DestinationCountry = (string)reader["DEST_COUNTRY"], RemainingTickets = (int)reader["REMAINING_TICKETS"], DepartureTime = (DateTime)reader["DEPARTURE_TIME_DATE_TIME"] }; flights.Add(flight); } return(flights); } }
/// <summary> /// Get all flights that will land in the upcoming 12 hours or landed in the last 4 hours /// </summary> /// <returns></returns> public IList <FlightRazor> LandingFlights() { List <FlightRazor> flightsResults = new List <FlightRazor>(); using (SqlConnection conn = new SqlConnection(FlyingCenterConfig.ConString)) { SqlCommand cmd = new SqlCommand("RAZOR_LANDING_FLIGHTS", conn); cmd.Connection.Open(); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default); while (reader.Read() == true) { FlightRazor flight = new FlightRazor { ID = (Int64)reader["ID"], AirlineName = (string)reader["AIRLINE_NAME"], AirlineNameAndFlightID = $"{(string)reader["AIRLINE_NAME"]} {(Int64)reader["ID"]}", OriginCountry = (string)reader["ORIGIN_COUNTRY"], DestinationCountry = (string)reader["DEST_COUNTRY"], RemainingTickets = (int)reader["REMAINING_TICKETS"], LandingTime = (DateTime)reader["LANDING_TIME_DATE_TIME"] }; //flight.Airline_Pic = $"Src/Images/Logos/{flight.AirlineName}.png"; flightsResults.Add(flight); } return(flightsResults); } }