private void button2_Click(object sender, EventArgs e) { GlavM gm = new GlavM(); this.Hide(); gm.Show(); }
private void materialFlatButton1_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(); connection.ConnectionString = Program.connection; SqlCommand g_login = new SqlCommand("select ID_S from Sotr where LOGIN_S = '" + materialSingleLineTextField1.Text + "' and PAS_S = '" + materialSingleLineTextField2.Text + "'", connection); connection.Open(); SqlDataReader read_login = g_login.ExecuteReader(); if (read_login.HasRows == true) { read_login.Close(); MessageBox.Show("Вы успешно вошли в систему", "Авторизация", MessageBoxButtons.OK, MessageBoxIcon.Information); Program.login = g_login.ExecuteScalar().ToString(); SqlCommand AdminAccCmd = new SqlCommand(Admin_access + Program.login, connection); Program.Admin_access = Convert.ToInt32(AdminAccCmd.ExecuteScalar().ToString()); Access = Convert.ToInt32(AdminAccCmd.ExecuteScalar().ToString()); switch (Access) { case (1): mMenu main_form = new mMenu(); this.Close(); main_form.Show(); break; case (0): GlavM gv = new GlavM(); this.Close(); gv.Show(); break; } } else { MessageBox.Show("Пользователь с такими данными не найден в системе.\nПовторите попытку ввода.", "Ошибка авторизации", MessageBoxButtons.OK, MessageBoxIcon.Error); } /*SqlConnection connectio * n = new SqlConnection(); * connection.ConnectionString = Program.connection; * SqlCommand g_login = new SqlCommand("select ID_S from Sotr where LOGIN_S = '" + materialSingleLineTextField1.Text + "' and PAS_S = '" + materialSingleLineTextField2.Text + "'", connection); * connection.Open(); * SqlDataReader r_login = g_login.ExecuteReader(); * if (r_login.HasRows == true) * { * r_login.Close(); * MessageBox.Show("Вы вощли в систему", "Авторизация", MessageBoxButtons.OK, MessageBoxIcon.Information); * connection.Close(); * GlavM mg = new GlavM(); * this.Hide(); * mg.Show(); * } * else * { * MessageBox.Show("Пользователь с логином " + materialSingleLineTextField1.Text + " не найден в системе. Повторите попытку ввода.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); * } */ }