/* 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;
}
private void Annuler_Click(object sender, RoutedEventArgs e)
{
methodes m = new methodes();
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("Select * From Utilisateurs Where Id_utilisateur ='" + user.getid_utilis() + "'", con);
SqlDataReader myReader = cmd.ExecuteReader();
if (myReader.Read())
{
user.setnom(myReader["Nom"].ToString());
user.setprenom(myReader["Prenom"].ToString());
user.setpseudo(myReader["Pseudo"].ToString());
user.setmotdepasse(myReader["Mpasse"].ToString());
}
con.Close();
Nom2.Text = user.getnom();
Prenom2.Text = user.getprenom();
Pseudo2.Text = user.getpseudo();
}
