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()); } }