// переход на форму Меню бегуна
private void SwitchFormMenu()
{
ActiveForm.Hide();
FormMenuRunner formMenuRunner = new FormMenuRunner();
formMenuRunner.ShowDialog();
Close();
}
private async void BtnLogin_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtEmail.Text) && !string.IsNullOrEmpty(txtPassword.Text))
{
try
{
string query = "SELECT * FROM [UserPersonalInformation] WHERE Email = '" + txtEmail.Text.Trim() + "' and [Password] = '" + txtPassword.Text.Trim() + "'";
//string query1 = "SELECT * FROM [Administration] WHERE Email = '" + txtEmail.Text.Trim() + "' and [Password] = '" + txtPassword.Text.Trim() + "'";
using (SqlConnection connection = new SqlConnection(Connection.GetSetring()))
{
await connection.OpenAsync();
SqlCommand command = new SqlCommand(query, connection);
//SqlCommand command1 = new SqlCommand(query1, connection);
SqlDataReader dataReader = command.ExecuteReader();
//SqlDataReader dataReader1 = command1.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
email = dataReader["Email"].ToString();
}
ActiveForm.Hide();
FormMenuRunner runner = new FormMenuRunner();
runner.ShowDialog();
Close();
}
//else if (dataReader1.HasRows)
//{
// while (dataReader1.Read())
// {
// email = dataReader1["Email"].ToString();
// }
// ActiveForm.Hide();
// FormAdmin admin = new FormAdmin();
// admin.ShowDialog();
// Close();
//}
else
{
MessageBox.Show("Не верный Email или Пароль. Пожалуйста, повторите попытку!", "Уведомление системы!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Уведомление системы!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Заполните поля!", "Уведомление системы!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}