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