private void button1_Click(object sender, EventArgs e)
{
coordinators c = new coordinators();
c.Show();
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
int login = 0;
string role = "";
using (SqlConnection conn = new
SqlConnection(марафон2.Properties.Settings.Default.MaraphonConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT Count(*) FROM [User] WHERE Email='" + textBox1.Text + "'AND Password = '******'";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
login = Convert.ToInt32(reader[0]);
}
conn.Close();
conn.Open();
SqlCommand cmd1 = conn.CreateCommand();
cmd1.CommandText = "SELECT RoleId FROM [User] WHERE Email='" + textBox1.Text + "'AND Password = '******'";
SqlDataReader reader1 = cmd1.ExecuteReader();
while (reader1.Read())
{
role = reader1[0].ToString();
}
conn.Close();
}
if (login == 1)
{
{
File.WriteAllText("Resources/login.txt", textBox1.Text);
if (role == "R")
{
runner Runner = new runner();
Runner.Show();
this.Hide();
}
else
{
if (role == "A")
{
admin Admin = new admin();
Admin.Show();
this.Hide();
}
else
{
if (role == "C")
{
coordinators Coordinator = new coordinators();
Coordinator.Show();
this.Hide();
}
}
}
}
}
else
{
MessageBox.Show("Не правильный логин/пароль.");
}
}
