private void MakeNewPassword()
{
string newPass;
Console.WriteLine("Enter new password: "******"UPDATE sql3346222.userCredentials SET Password=(@Password)" +
" WHERE TrainerName = (@Username);";
//execute the query
MySqlCommand query = new MySqlCommand(plainTextQuery, Connection);
query.Parameters.Add(@"@Password", MySqlDbType.Text);
query.Parameters[@"@Password"].Value = Hashedpass;
query.Parameters.Add(@"@Username", MySqlDbType.VarChar);
query.Parameters[@"@Username"].Value = TrainerName;
MySqlDataReader rdr = query.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(rdr[0] + " -- " + rdr[1]);
}
rdr.Close();
Connection.Close();
Console.WriteLine("Password reset!");
}
//This is a private helper method that uses hashing alg to hash the nwe Password
public string UserPasswordHash(string thePass)
{
string Hashedpass;
var sendToHashPasswordAlg = new HashingAlg(thePass);
Hashedpass = sendToHashPasswordAlg.getHash();
Hashedpass = sendToHashPasswordAlg.addSecret(Hashedpass);
return(Hashedpass);
}
