private void connect1_Click(object sender, RoutedEventArgs e) { log_in a = new log_in(); a.Show(); this.Hide(); }
private void Button_Click_5(object sender, RoutedEventArgs e) { SqlConnection conn = new SqlConnection(conn_string); try { conn.Open(); String Query = "SELECT * FROM Profile WHERE UserName = '******'"; SqlCommand cmd = new SqlCommand(Query, conn); SqlDataReader rdr = cmd.ExecuteReader(); String salt; rdr.Read(); salt = rdr["Salt"].ToString(); rdr.Close(); String res = ash(pass_.Password, salt); Query = "SELECT * FROM Profile WHERE UserName = '******' and Password = '******'"; cmd = new SqlCommand(Query, conn); rdr = cmd.ExecuteReader(); if (rdr.Read()) { rdr.Close(); Query = "DELETE FROM Profile WHERE [UserName] = '" + log_in.user + "'"; cmd = new SqlCommand(Query, conn); rdr = cmd.ExecuteReader(); popup_supp.IsOpen = false; log_in log = new log_in(); log.Show(); log_in.main.Close(); } else { MessageBox.Show("Le mot de pass est incorrecte !"); } rdr.Close(); } finally { conn.Close(); } }
private void Valider2_Click(object sender, RoutedEventArgs e) { SqlConnection conn = new SqlConnection(conn_string); SqlDataReader rdr = null; try { if (this.pass1.Password.Equals(this.pass2.Password)) { conn.Open(); String Salt = CreateSalt(15); String p = ash(pass1.Password, Salt); String Query = ("UPDATE Profile SET PassWord = '******' , Salt= '" + Salt + "' WHERE UserName = '******'"); SqlCommand cmd = new SqlCommand(Query, conn); cmd.ExecuteNonQuery(); MessageBox.Show("Votre Mot de passe a ete reinitialiser !!"); log_in a = new log_in(); a.Show(); this.Close(); } else { MessageBox.Show("Failed !!"); } } finally { if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } } }
private void Check_Click(object sender, RoutedEventArgs e) { SqlConnection conn = new SqlConnection(conn_string); try { conn.Open(); String Salt = CreateSalt(15); String p = ash(Regetration1.pass, Salt); int value = 1; String Query = ("INSERT INTO Profile (Admin,UserName,PassWord,Q1,Q2,Q3,Salt) Values( '" + true + "','" + Regetration1.user + "' ,'" + p + "','" + ash(this.Q1.Password, Salt) + "','" + ash(this.Q2.Password, Salt) + "','" + ash(this.Q3.Password, Salt) + "','" + Salt + "')"); SqlCommand cmd = new SqlCommand(Query, conn); cmd.ExecuteNonQuery(); MessageBox.Show("Votre compte a été creé " + Regetration1.user); log_in a = new log_in(); a.Show(); this.Close(); } finally { conn.Close(); } }