private void button2_Click(object sender, EventArgs e)
{
SqlConnClass scc = new SqlConnClass();
AuthorizForm af = this;
scc.auth(textBox1.Text, textBox2.Text, af);
}
private void button4_Click(object sender, EventArgs e)
{
ActiveForm.Hide();
AuthorizForm af = new AuthorizForm();
af.ShowDialog();
Close();
}
public void auth(string email, string password, AuthorizForm ar)
{
string connStr = "server=localhost;user=root;database=pafenov;password="******"SELECT Password, Email,RoleId FROM user";
MySqlCommand command = new MySqlCommand(sql, conn);
MySqlDataReader reader = command.ExecuteReader();
bool pass = false;
bool em = false;
bool runner = false;
bool admn = false;
bool coord = false;
while (reader.Read())
{
if (reader[1].ToString() == email)
{
em = true;
if (reader[0].ToString() == password)
{
pass = true;
if (reader[2].ToString() == "R")
{
runner = true;
}
else
{
if (reader[2].ToString() == "A")
{
admn = true;
}
else
{
if (reader[2].ToString() == "C")
{
}
}
}
}
}
}
reader.Close();
if (em == true)
{
if (pass == true)
{
if (runner == true)
{
string sql2 = "SELECT RunnerId FROM runner WHERE Email='" + email + "'";
command = new MySqlCommand(sql2, conn);
int id = Convert.ToInt32(command.ExecuteScalar());
ar.Hide();
RunnerMenu rm = new RunnerMenu(id);
//conn.Close();
rm.ShowDialog();
conn.Close();
ar.Close();
}
if (admn == true)
{
ar.Hide();
AdminMenuForm amf = new AdminMenuForm();
amf.ShowDialog();
//reader.Close();
conn.Close();
ar.Close();
}
if (coord == true)
{
ar.Hide();
CoordMenuForm cmf = new CoordMenuForm();
cmf.ShowDialog();
//reader.Close();
conn.Close();
ar.Close();
}
}
}
if (em == false)
{
MessageBox.Show("Неверный email!");
}
else
{
if (pass == false)
{
MessageBox.Show("Неверный пароль!");
}
}
//reader.Close();
conn.Close();
}