public static bool delete(Administrateur admin) { bool res = false; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "DELETE FROM administration WHERE idA = @idA"; cmd.Parameters.AddWithValue("@idA", admin.Id); cmd.Connection = Connexion.getInstance(); try { cmd.ExecuteNonQuery(); cmd = null; res = true; } catch (Exception ex) { Console.WriteLine("Erreur de ExecuteNonQuery : " + ex.Message); } return(res); }
public static void create(Administrateur admin) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO administration(nom, prenom, mail, mdp) " + "VALUES(@nom, @prenom, @mail, @mdp)"; cmd.Parameters.AddWithValue("@nom", admin.Nom); cmd.Parameters.AddWithValue("@prenom", admin.Prenom); cmd.Parameters.AddWithValue("@mail", admin.Mail); cmd.Parameters.AddWithValue("@mdp", admin.Motdepasse); cmd.Connection = Connexion.getInstance(); try { cmd.ExecuteNonQuery(); cmd = null; } catch (Exception ex) { Console.WriteLine("Erreur de ExecuteNonQuery : " + ex.Message); } }