public List <Airline_Company> Reader(string query, string function) { List <Airline_Company> allAirlineCompanies = new List <Airline_Company>(); try { using (NpgsqlConnection connection = new NpgsqlConnection(Fligth_CenterAppConfig.ConnectionString)) { connection.Open(); using (NpgsqlCommand command = new NpgsqlCommand(_sp_name, connection)) { command.CommandText = using (NpgsqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Airline_Company a_c = new Airline_Company() { Id = (long)reader["id"], Name = (string)reader["name"], }; allAirlineCompanies.Add(a_c); } return(allAirlineCompanies); } } } } catch (Exception ex) { Fligth_CenterAppConfig._log.Error($"Connection failed.Exception: {ex}"); Console.WriteLine($"Connection failed.Exception: {ex}"); Console.ReadKey(); Environment.Exit(-1); return(null); } }
public void Update(Airline_Company t) { throw new NotImplementedException(); }
public void Add(Airline_Company t) { _sp_name = "sp_insert_company"; NonReader(_sp_name); }