public static void GetRecette() { // on prepare la requête String sql = "SELECT * FROM kaikai"; using (MySqlCommand command = new MySqlCommand(sql, connection)) { command.Connection.Open(); // On exécute la requête using (DbDataReader dbReader = command.ExecuteReader()) { while (dbReader.Read()) { int Id = dbReader.GetInt32(0); string Nom = dbReader.GetString(1); string Image = dbReader.GetString(2); string Categorie = dbReader.GetString(3); int NbPersonne = dbReader.GetInt32(4); string Ingredients = dbReader.GetString(5); string Preparation = dbReader.GetString(6); Recette rp = new Recette(Nom, Image, Categorie, NbPersonne, Ingredients, Preparation); rp.Id = Id; Business.Recettes.Add(rp); } } command.Connection.Close(); } }
public static bool InsertRecette(Recette r) { string sql = "INSERT INTO recette(id, Nom, Image, Categorie, NbPersonne, Ingredients, Preparation) " + "VALUES(@id, @Nom, @Image, @Categorie, @NbPersonne,@Ingredients, @Preparation)"; using (MySqlCommand cmd = new MySqlCommand(sql, connection)) { cmd.Connection.Open(); cmd.Parameters.AddWithValue("@id", null); cmd.Parameters.AddWithValue("@Nom", r.Nom); cmd.Parameters.AddWithValue("@Image", r.Image); cmd.Parameters.AddWithValue("@Categorie", r.Categorie); cmd.Parameters.AddWithValue("@NbPersonne", r.NbPersonne); cmd.Parameters.AddWithValue("@Ingredients", r.Ingredients); cmd.Parameters.AddWithValue("@Preparation", r.Preparation); bool result = cmd.ExecuteNonQuery() == 1; cmd.Connection.Close(); return(result); } }
public static bool UpdateRecette(Recette r) { string sql = "UPDATE kaikai SET Nom=@Nom, Image=@Image, Categorie=@Categorie, NbPersonne=@NbPersonne, Ingredients=@Ingredients, Preparation=@Preparation" + " Where id=@id"; using (MySqlCommand cmd = new MySqlCommand(sql, connection)) { cmd.Connection.Open(); cmd.Parameters.AddWithValue("@id", r.Id); cmd.Parameters.AddWithValue("@Nom", r.Nom); cmd.Parameters.AddWithValue("@Image", r.Image); cmd.Parameters.AddWithValue("@Categorie", r.Categorie); cmd.Parameters.AddWithValue("@NbPersonne", r.NbPersonne); cmd.Parameters.AddWithValue("@Ingredients", r.Ingredients); cmd.Parameters.AddWithValue("@Preparation", r.Preparation); bool result = cmd.ExecuteNonQuery() == 1; cmd.Connection.Close(); return(result); } }