/// <summary>
///
/// </summary>
/// <returns></returns>
public IList <PasswordSafe> Get()
{
IList <PasswordSafe> records = null;
try
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = new SqlCommand(Query.GET_PASSWORD_SAFE_RECORDS, sqlConnection))
{
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader != null)
{
records = new List <PasswordSafe>();
while (reader.Read())
{
PasswordSafe record = new PasswordSafe();
record.PasswordSafeId = GetInt(reader["PasswordSafeId"]);
record.ServiceName = GetString(reader["ServiceName"]);
record.Username = GetString(reader["Username"]);
record.Password = GetString(reader["Password"]);
record.ServiceType = GetString(reader["ServiceType"]);
record.SecurityQuestion1 = GetString(reader["SQ1"]);
record.SecurityAnswer1 = GetString(reader["SA1"]);
record.SecurityQuestion2 = GetString(reader["SQ2"]);
record.SecurityAnswer2 = GetString(reader["SA2"]);
record.SecurityQuestion3 = GetString(reader["SQ3"]);
record.SecurityAnswer3 = GetString(reader["SA3"]);
records.Add(record);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(records);
}
private void passwordTextBox_TextChanged(object sender, TextChangedEventArgs e)
{
if (passwordTextBox.Text == "")
{
passwordCorrectCheckLabel.Content = "";
}
PasswordSafe safe = new PasswordSafe(passwordTextBox.Text);
if (PasswordFormatCheck(passwordTextBox.Text))
{
switch (safe.CheckAll())
{
case PasswordSafe.SafePower.Bad:
passwordCorrectCheckLabel.Foreground = new SolidColorBrush(Colors.Red);
passwordCorrectCheckLabel.Content = "Не безопасный пароль";
break;
case PasswordSafe.SafePower.Normal:
passwordCorrectCheckLabel.Foreground = new SolidColorBrush(Colors.Orange);
passwordCorrectCheckLabel.Content = "Умеренный пароль";
break;
case PasswordSafe.SafePower.Good:
passwordCorrectCheckLabel.Foreground = new SolidColorBrush(Colors.YellowGreen);
passwordCorrectCheckLabel.Content = "Безопасный пароль";
break;
case PasswordSafe.SafePower.Excelent:
passwordCorrectCheckLabel.Foreground = new SolidColorBrush(Colors.Green);
passwordCorrectCheckLabel.Content = "Очень безопасный пароль";
break;
}
}
else
{
passwordCorrectCheckLabel.Foreground = new SolidColorBrush(Colors.Red);
passwordCorrectCheckLabel.Content = "Пароль не может быть меньше 4 или больше 100 символов";
}
}