private void LoginButton_Click(object sender, RoutedEventArgs e)
{
try
{
SqlConnection sqlCon = new SqlConnection(@"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = c:\users\андрей\documents\visual studio 2017\Projects\Info Banks of Moscow\Info Banks of Moscow\Database1.mdf; Integrated Security = True");
SqlDataAdapter sda = new SqlDataAdapter("Select Count (*) From [Table] where Login='******'and Password='******'", sqlCon);
SqlCommand sqlCommandPassword = new SqlCommand("Select Password From [Table] where Login='******'", sqlCon);
sqlCon.Open();
SqlDataReader sqlReaderPassword = sqlCommandPassword.ExecuteReader();
string[] hash = new string[1];
while (sqlReaderPassword.Read())
{
string _hash = sqlReaderPassword.GetString(0);
hash[0] = _hash;
}
sqlReaderPassword.Close();
sqlCon.Close();
DataTable Table = new DataTable();
sda.Fill(Table);
if ((Table.Rows[0][0].ToString() == "1") && (CalculateHash(PasswordBox.Password) == CalculateHash(hash[0])))
{
SqlCommand sqlCommand = new SqlCommand("Select Name From [Table] where Login='******'and Password='******'", sqlCon);
sqlCon.Open();
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
List <User> Users = new List <User>();
while (sqlReader.Read())
{
User authorisedUser = new User(sqlReader.GetString(0), LoginTextBox.Text);
Users.Add(authorisedUser);
}
FileStream fs = new FileStream("name.txt", FileMode.Create);
using (StreamWriter sw = new StreamWriter(fs))
{
sw.Write(LoginTextBox.Text + " " + Users[0].Name);
}
ProfilePage ProfilePage = new ProfilePage();
NavigationService.Navigate(ProfilePage);
}
else
{
MessageBox.Show("Пользователя с таким логином и паролем не существует", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch { MessageBox.Show("Что-то пошло не так...", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error); }
}
private void BackButton_Click(object sender, RoutedEventArgs e)
{
ProfilePage ProfilePage = new ProfilePage();
NavigationService.Navigate(ProfilePage);
}