public Gamme Get(int id) { Gamme g = null; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = @"SELECT Identifiant, Libelle FROM Gamme WHERE Identifiant = @identifiant"; command.Parameters.AddWithValue("@identifiant", id); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); g = new Gamme(); g.Identifiant = (int)reader["Identifiant"]; g.Libelle = reader["Libelle"] is System.DBNull ? null : reader["Libelle"].ToString(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(g); }
public List <Gamme> GetAll() { List <Gamme> gammes = new List <Gamme>(); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "SELECT Identifiant, Libelle FROM Gamme"; try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Gamme g = new Gamme(); g.Identifiant = (int)reader["Identifiant"]; g.Libelle = reader["Libelle"] is System.DBNull ? null : reader["Libelle"].ToString(); gammes.Add(g); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(gammes); }