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