private void savePass(string newLogin, string newName)
{
newPassword = txtNewPassword.Text;
string encryptedNewPassword;
currentUserID = User.returnUser;
EncryptionDecryptionServices encryptPassword = new EncryptionDecryptionServices();
encryptedNewPassword = encryptPassword.Encrypt(newPassword);
SaveNewPass savePassword = new SaveNewPass(newLogin, newName, encryptedNewPassword, currentUserID);
int saveResult = savePassword.PasswordSaver();
switch (saveResult)
{
case 0:
MessageBox.Show("Saved Successfully!");
break;
case 1:
MessageBox.Show("Unable to connect to database.");
break;
case 2:
MessageBox.Show("Save Unsuccessful.");
break;
}
}
public Dictionary <String, List <String> > returnPasswords()
{
SqlConnection connection;
SqlDataReader dataReader;
Dictionary <String, List <String> > passwordsList;
using (connection = new SqlConnection())
{
connection.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\dusti\source\repos\PasswordGenerator\PasswordGenerator\bin\Debug\Passwords.mdf;Integrated Security=True";
try
{
connection.Open();
}
catch
{
String[] noDBConnection = new string[0];
}
SqlCommand sqlCheck = new SqlCommand($"SELECT * FROM dbo.Passwords WHERE userid = @0", connection);
sqlCheck.Parameters.AddWithValue("0", userID);
dataReader = sqlCheck.ExecuteReader();
passwordsList = new Dictionary <String, List <String> >();
while (dataReader.Read())
{
string decryptedPassword;
EncryptionDecryptionServices decryptPassword = new EncryptionDecryptionServices();
decryptedPassword = decryptPassword.Decrypt(dataReader.GetString(0));
List <String> interiorList = new List <String>();
interiorList.Add(decryptedPassword);
interiorList.Add(dataReader.GetString(2));
passwordsList.Add(dataReader.GetString(1), interiorList);
}
}
return(passwordsList);
}
