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