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