private void button3_Click(object sender, EventArgs e)
{
RunnerMenu f = new RunnerMenu("a");
f.Show();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection("server=(localdb)\\MSSQLLocalDB;Trusted_Connection=yes;database=marathon;connection timeout=30");
conn.Open();
string mail = textBox1.Text;
SqlCommand comm = new SqlCommand("SELECT * FROM [dbo].[User] where Email='" + mail + "'", conn);
SqlDataReader reader = comm.ExecuteReader();
bool check = false;
string role = "";
while (reader.Read())
{
string pass = reader["Password"].ToString();
if (pass == textBox2.Text)
{
check = true;
}
role = reader["RoleId"].ToString();
}
if (check)
{
switch (role)
{
case "R": RunnerMenu f = new RunnerMenu(textBox1.Text); f.Show(); this.Close(); f.label2.Text = mail; break;
case "A": AdminMenu f1 = new AdminMenu(); f1.Show(); this.Close(); break;
case "C": CoordinatorMenu f2 = new CoordinatorMenu(); f2.Show(); this.Close(); break;
default: MessageBox.Show("Ошибка");
break;
}
}
conn.Close();
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}
