private void backButton_Click(object sender, EventArgs e) //Нажатие на кнопку "Назад", возвращение на окно координатора
{
runnerManagerForm.ActiveForm.Hide();
coordinatorForm form = new coordinatorForm();
form.Show();
}
private void logoutButton_Click(object sender, EventArgs e)
{
sponsorshipViewForm.ActiveForm.Hide();
coordinatorForm form = new coordinatorForm();
form.Show();
}
private void loginButton_Click(object sender, EventArgs e) //Нажатие на кнопку "Login", проверка введенных данных в базе данных и переход на форму, согласно роли пользователя
{
try
{
connectionSql.Open();
dataAdapter = new SqlDataAdapter($"SELECT [Email], [Password], [RoleId] FROM [dbo].[User] WHERE [Email] = '{emailTextBox.Text}' and [Password] = '{passwordTextBox.Text}'", connectionSql);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
table = dataSet.Tables[0];
if (table.Rows.Count != 0)
{
email = emailTextBox.Text;
DataRow dataRow = table.Rows[0];
if (dataRow[2].ToString() == "A")
{
authorizationForm.ActiveForm.Hide();
adminForm form = new adminForm();
form.Show();
}
if (dataRow[2].ToString() == "C")
{
authorizationForm.ActiveForm.Hide();
coordinatorForm form = new coordinatorForm();
form.Show();
}
if (dataRow[2].ToString() == "R")
{
authorizationForm.ActiveForm.Hide();
runnerForm form = new runnerForm();
form.Show();
}
}
else
{
MessageBox.Show("Неверный логин или пароль");
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
connectionSql.Close();
}
}
