private async void Button_Click(object sender, RoutedEventArgs e)
{
SqlConnection = new OleDbConnection(connectString);
await SqlConnection.OpenAsync();
OleDbDataReader sqlReader = null;
OleDbCommand command1 = new OleDbCommand("SELECT * FROM [Пользователи]", SqlConnection);
sqlReader = command1.ExecuteReader();
while (sqlReader.Read())
{
if (textBox.Text == Convert.ToString(sqlReader["Логин"]))
{
if (passwordBox.Password.ToString() == Convert.ToString(sqlReader["Пароль"]))
{
FirstPage o = new FirstPage();
o.Name = textBox.Text;
o.Show();
this.Hide();
return;
}
}
}
textBox.Background = Brushes.Red;
textBox.Opacity = 0.4;
passwordBox.Background = Brushes.Red;
passwordBox.Opacity = 0.4;
}
private void Button_Copy16_Click(object sender, RoutedEventArgs e)
{
FirstPage o = new FirstPage();
o.Show();
this.Hide();
}
private void Button_Copy_Click(object sender, RoutedEventArgs e)
{
FirstPage a = new FirstPage();
a.Name = this.Name;
a.Show();
this.Close();
}
private void Button_Copy16_Click_1(object sender, RoutedEventArgs e)
{
if (Convert.ToString(this.Tag) == "1")
{
FirstPage o = new FirstPage();
o.Show();
this.Hide();
}
else
{
TablePageClient o = new TablePageClient();
o.Show();
this.Hide();
}
}
private async void Button_Click(object sender, RoutedEventArgs e)
{
SqlConnection = new OleDbConnection(connectString);
await SqlConnection.OpenAsync();
OleDbDataReader sqlReader = null;
OleDbCommand command1 = new OleDbCommand("UPDATE [Пользователи] SET [Логин]=@LN, [Пароль]=@FN, ФИО=@Fam WHERE [Логин]=@1", SqlConnection);
command1.Parameters.AddWithValue("LN", textBox.Text);
command1.Parameters.AddWithValue("FN", passwordBox.Password.ToString());
command1.Parameters.AddWithValue("Fam", textBox_Copy.Text);
command1.Parameters.AddWithValue("1", this.Name);
if (textBox.Text != "")
{
if (passwordBox.Password.ToString() != "")
{
if (textBox_Copy.Text != "")
{
await command1.ExecuteNonQueryAsync();
MessageBox.Show("Данные пользователя успешно изменены");
FirstPage o = new FirstPage();
o.Name = this.Name;
o.Show();
this.Hide();
return;
}
}
}
textBox_Copy.Background = Brushes.Red;
textBox_Copy.Opacity = 0.4;
textBox.Background = Brushes.Red;
textBox.Opacity = 0.4;
passwordBox.Background = Brushes.Red;
passwordBox.Opacity = 0.4;
}