public IList <FlightView> GetFlightsViewByFilter(int flightNum, string originCoun, string destCoun, string airline, string searchType)
{
IList <FlightView> flights = new List <FlightView>();
using (SqlConnection conn = new SqlConnection(FlightCenterConfig.dbName))
{
SqlCommand cmd = new SqlCommand("GET_FLIGHT_BY_FILTER", conn);
cmd.Parameters.Add(new SqlParameter("@FlightNum", flightNum));
cmd.Parameters.Add(new SqlParameter("@OriginContryName", originCoun));
cmd.Parameters.Add(new SqlParameter("@DestinatonCountryName", destCoun));
cmd.Parameters.Add(new SqlParameter("@AirlineCompanyName", airline));
cmd.Parameters.Add(new SqlParameter("@SearchType", searchType));
cmd.Connection.Open();
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default);
while (reader.Read() == true)
{
FlightView flight = new FlightView
{
FlightNumber = (long)reader["FLIGHT_NUMBER"],
AirlineCompanyName = (string)reader["AirlineName"],
OriginCountryName = (string)reader["COMING_FROM"],
DestinationCountryName = (string)reader["FLIGHT_TO"],
DepartureTime = (DateTime)reader["DepartureTime"],
LandingTime = (DateTime)reader["LandingTime"],
};
flights.Add(flight);
}
cmd.Connection.Close();
return(flights);
}
}
