private void button11_Click(object sender, EventArgs e)
{
mMenu menu = new mMenu();
this.Hide();
menu.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);
* }
*/
}