public void insertUsers(ClassRegister reg) { try { InitializeConnection(); string q = "insert into users(nom,telephone,name,password) value(@nom,@telephone,@name,@password)"; cmd = new MySqlCommand(q, con); cmd.Parameters.Add(new MySqlParameter("@nom", reg.Nom)); cmd.Parameters.Add(new MySqlParameter("@telephone", reg.Telephone)); cmd.Parameters.Add(new MySqlParameter("@name", reg.Users)); cmd.Parameters.Add(new MySqlParameter("@password", reg.Users)); cmd.ExecuteNonQuery(); MessageBox.Show("Creation de l'utilisateur avec succes"); }catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void modifierUsers(ClassRegister reg) { try { InitializeConnection(); string q = "update users set nom=@nom,telephone=@telephone,name=@name,password=@password where id=@id"; cmd = new MySqlCommand(q, con); cmd.Parameters.Add(new MySqlParameter("@id", reg.Id)); cmd.Parameters.Add(new MySqlParameter("@nom", reg.Nom)); cmd.Parameters.Add(new MySqlParameter("@telephone", reg.Telephone)); cmd.Parameters.Add(new MySqlParameter("@name", reg.Users)); cmd.Parameters.Add(new MySqlParameter("@password", reg.Users)); cmd.ExecuteNonQuery(); MessageBox.Show("Modification avec succes!!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void deleteLogin(ClassRegister reg) { try { InitializeConnection(); string q = "delete from users where id=@id"; cmd = new MySqlCommand(q, con); cmd.Parameters.Add(new MySqlParameter("@id", reg.Id)); DialogResult result = MessageBox.Show("Voulez-vous vraiment excuter cette operation ?", "Suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Suppression avec succes!!"); } } }catch (Exception ex) { MessageBox.Show(ex.Message); } }