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