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