private void Enrigstrer_Click(object sender, RoutedEventArgs e) { methodes m = new WpfApplication12.methodes(); string motdepass = this.user.getmotdepasse(); SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); con.Open(); SqlDataReader adapter; SqlCommand cmd = new SqlCommand("Select * From Utilisateurs Where Pseudo='" + Pseudo2.Text + "'", con); adapter = cmd.ExecuteReader(); if (adapter.Read() && (int)(adapter["id_utilisateur"]) != user.getid_utilis()) { pseu_ext.Visibility = System.Windows.Visibility.Visible; } else { if ((Password.Password != "") && (Password2.Password != "")) { if (Password.Password == user.getmotdepasse()) { MessageBoxResult reslt = MessageBox.Show("Voulez-vous vraiment modifier vos informations", "Confirmation", MessageBoxButton.YesNo); if (reslt == MessageBoxResult.Yes) { motdepass = Password2.Password; user.Modifer_utilisateur(this.user, Nom2.Text, Prenom2.Text, motdepass, Pseudo2.Text); user.modifier_utilis(user, this.user.getid_utilis()); con.Close(); } } else { incorect.Visibility = Visibility.Visible; } } else { MessageBoxResult reslt = MessageBox.Show("Voulez-vous vraiment modifier vos informations", "Confirmation", MessageBoxButton.YesNo); if (reslt == MessageBoxResult.Yes) { user.Modifer_utilisateur(this.user, Nom2.Text, Prenom2.Text, motdepass, Pseudo2.Text); user.modifier_utilis(user, this.user.getid_utilis()); con.Close(); } } } }
/* public void Modifier_pseudo(utilisateur_class user, string pseudo) * { * user.setpseudo(pseudo); * } * public void Modifier_motdepasse(utilisateur_class user, string mot_de_passe) * { * user.setmotdepasse(mot_de_passe); * }*/ public void modifier_utilis(utilisateur user, int id_utilis) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); String query = "update Utilisateurs set Nom=@nom,Prenom=@prenom,Pseudo=@pseudo,Mpasse=@motdepasse WHERE Id_utilisateur=@id"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.Parameters.AddWithValue("@id", id_utilis.ToString()); cmd.Parameters.AddWithValue("@nom", user.getnom()); cmd.Parameters.AddWithValue("@prenom", user.getprenom()); cmd.Parameters.AddWithValue("@pseudo", user.getpseudo()); cmd.Parameters.AddWithValue("@motdepasse", user.getmotdepasse()); cmd.ExecuteNonQuery(); con.Close(); }
public User_Affichage(utilisateur use) { this.user = use; InitializeComponent(); Nom2.Text = user.getnom(); Prenom2.Text = user.getprenom(); Pseudo2.Text = user.getpseudo(); motpass = user.getmotdepasse(); Enrigstrer.Visibility = Visibility.Collapsed; Annuler.Visibility = Visibility.Collapsed; Nouveau_mot_de_passe.Visibility = System.Windows.Visibility.Collapsed; Ancien_mot_de_passe.Visibility = System.Windows.Visibility.Collapsed; Password.Visibility = System.Windows.Visibility.Collapsed; Password2.Visibility = System.Windows.Visibility.Collapsed; }