public void AfficherRecette(int id, Recette r) { SqlCommand command = new SqlCommand("SELECT * FROM recette WHERE id=@id", Connection.Instance); command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int) { Value = r.Id }); command.Parameters.Add(new SqlParameter("@date", SqlDbType.Date) { Value = r.Date }); command.Parameters.Add(new SqlParameter("@NomUtilisateur", SqlDbType.VarChar) { Value = r.NomUtilisateur }); command.Parameters.Add(new SqlParameter("@NomRecette", SqlDbType.VarChar) { Value = r.NomRecette }); command.Parameters.Add(new SqlParameter("@NbPersonne", SqlDbType.Int) { Value = r.NbPersonne }); command.Parameters.Add(new SqlParameter("@Difficulte", SqlDbType.VarChar) { Value = r.Difficulte }); command.Parameters.Add(new SqlParameter("@Ingredient", SqlDbType.VarChar) { Value = r.Ingredient }); command.Parameters.Add(new SqlParameter("@Realisation", SqlDbType.VarChar) { Value = r.Realisation }); Connection.Instance.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { new Recette() { Id = reader.GetInt32(0), Date = reader.GetDateTime(1), NomUtilisateur = reader.GetString(2), NomRecette = reader.GetString(3), NbPersonne = reader.GetInt32(4), Difficulte = reader.GetString(5), Ingredient = reader.GetString(6), Realisation = reader.GetString(5) }; } return; }
public List <Recette> ConsulterListeRecette() { List <Recette> liste = new List <Recette>(); SqlCommand command = new SqlCommand("SELECT * FROM recette order by nomrecette ASC", Connection.Instance); Connection.Instance.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Recette r = new Recette() { Id = reader.GetInt32(0), NomRecette = reader.GetString(3), NbPersonne = reader.GetInt32(4), Difficulte = reader.GetString(5) }; liste.Add(r); } reader.Close(); command.Dispose(); Connection.Instance.Close(); return(liste); }