public void Autorization(string usr_id, string usr_pass) { try { _RI = new Reg(); _RI.Set_Connection(); _RI.Connection.Open(); _CmdSql = new SqlCommand(user_id + usr_id + "' and Password = '******'", _RI.Connection); Program.USERID = Convert.ToInt32(_CmdSql.ExecuteScalar().ToString()); _CmdSql = new SqlCommand(sy_access + Program.USERID, _RI.Connection); Program.SYSACCESS = Convert.ToInt32(_CmdSql.ExecuteScalar().ToString()); SqlCommand PSACCESSCmd = new SqlCommand(ps_access + Program.USERID, _RI.Connection); SqlCommand AOACCESSCmd = new SqlCommand(ao_access + Program.USERID, _RI.Connection); SqlCommand UOACCESSCmd = new SqlCommand(uo_access + Program.USERID, _RI.Connection); SqlCommand ZAGZACCESSCmd = new SqlCommand(zags_access + Program.USERID, _RI.Connection); SqlCommand OFMSACCESSCmd = new SqlCommand(ofms_access + Program.USERID, _RI.Connection); SqlCommand SZACCESSCmd = new SqlCommand(sz_access + Program.USERID, _RI.Connection); SqlCommand FIOSOTRCmd = new SqlCommand(user_fio + Program.USERID, _RI.Connection); Program.FIOSOTR = FIOSOTRCmd.ExecuteScalar().ToString(); Program.PSACCESS = Convert.ToInt32(PSACCESSCmd.ExecuteScalar().ToString()); Program.AOACCESS = Convert.ToInt32(AOACCESSCmd.ExecuteScalar().ToString()); Program.UOACCESS = Convert.ToInt32(UOACCESSCmd.ExecuteScalar().ToString()); Program.ZAGZACCESS = Convert.ToInt32(ZAGZACCESSCmd.ExecuteScalar().ToString()); Program.OFMSACCESS = Convert.ToInt32(OFMSACCESSCmd.ExecuteScalar().ToString()); Program.SZACCESS = Convert.ToInt32(SZACCESSCmd.ExecuteScalar().ToString()); _RI.Connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void get_role_void(string value) { int ps, ao, uo, sz, of, za; _RI = new Reg(); _RI.Set_Connection(); _RI.Connection.Open(); SqlCommand PSA_cmd = new SqlCommand(ps_access_value + value + "'", _RI.Connection); SqlCommand AOA_cmd = new SqlCommand(ao_access_value + value + "'", _RI.Connection); SqlCommand UOA_cmd = new SqlCommand(uo_access_value + value + "'", _RI.Connection); SqlCommand SZA_cmd = new SqlCommand(sz_access_value + value + "'", _RI.Connection); SqlCommand OFMSA_cmd = new SqlCommand(ofms_access_value + value + "'", _RI.Connection); SqlCommand ZAGSA_cmd = new SqlCommand(zags_access_value + value + "'", _RI.Connection); ps = Convert.ToInt16(PSA_cmd.ExecuteScalar().ToString()); ao = Convert.ToInt16(AOA_cmd.ExecuteScalar().ToString()); uo = Convert.ToInt16(UOA_cmd.ExecuteScalar().ToString()); sz = Convert.ToInt16(SZA_cmd.ExecuteScalar().ToString()); of = Convert.ToInt16(OFMSA_cmd.ExecuteScalar().ToString()); za = Convert.ToInt16(ZAGSA_cmd.ExecuteScalar().ToString()); Program.RG_PSA = ps; Program.RG_AOA = ao; Program.RG_UOA = uo; Program.RG_SZA = sz; Program.RG_OFMSA = of; Program.RG_ZAGSA = za; _RI.Connection.Close(); }
public void Role_delete_void(int ID) { _RI = new Reg(); _RI.Set_Connection(); _RI.Connection.Open(); SqlCommand StrPrc = new SqlCommand("Role_delete", _RI.Connection); StrPrc.CommandType = CommandType.StoredProcedure; StrPrc.Parameters.AddWithValue("@id_Role", ID); StrPrc.ExecuteNonQuery(); _RI.Connection.Close(); }
public void Sotr_Select_void() { _RI = new Reg(); _RI.Set_Connection(); _RI.Connection.Open(); SqlCommand Sotr_Select = new SqlCommand("select [id_Sotr], [f_Sotr], [i_Sotr], [o_Sotr], [Password], [Login], " + "[E_mail], [System_Access], [Role_id] from [MFC].[dbo].[Sotr]", _RI.Connection); SqlDataReader tableReader = Sotr_Select.ExecuteReader(); DataTable Table = new DataTable(); Table.Load(tableReader); Program.Sotr_Select = Table; _RI.Connection.Close(); }
public void Role_Select_void() { _RI = new Reg(); _RI.Set_Connection(); _RI.Connection.Open(); SqlCommand Role_Select = new SqlCommand("select [id_Role], [Name_Role], [Pasportni], [Abonentski], [Univerrsal], [OFMS], [ZAGS], [Soc_Zashch]" + "from [MFC].[dbo].[Role]", _RI.Connection); SqlDataReader tableReader = Role_Select.ExecuteReader(); DataTable Table = new DataTable(); Table.Load(tableReader); Program.Role_Select = Table; _RI.Connection.Close(); }
public void Role_add_void(string value, int AOID, int PSID, int UOID, int OFMSID, int ZAGSID, int SZID) { _RI = new Reg(); _RI.Set_Connection(); _RI.Connection.Open(); SqlCommand StrPrc = new SqlCommand("Role_add", _RI.Connection); StrPrc.CommandType = CommandType.StoredProcedure; StrPrc.Parameters.AddWithValue("@Name_Role", value); StrPrc.Parameters.AddWithValue("@Abonentski", AOID); StrPrc.Parameters.AddWithValue("@Pasportni", PSID); StrPrc.Parameters.AddWithValue("@Univerrsal", UOID); StrPrc.Parameters.AddWithValue("@OFMS", OFMSID); StrPrc.Parameters.AddWithValue("@ZAGS", ZAGSID); StrPrc.Parameters.AddWithValue("@Soc_Zashch", SZID); StrPrc.ExecuteNonQuery(); _RI.Connection.Close(); }
public void Sotr_add_void(string FV, string IV, string OV, string PV, string LV, string EMV, int RV, int SID) { _RI = new Reg(); _RI.Set_Connection(); _RI.Connection.Open(); SqlCommand StrPrc = new SqlCommand("Sotr_add", _RI.Connection); StrPrc.CommandType = CommandType.StoredProcedure; StrPrc.Parameters.AddWithValue("@f_Sotr", FV); StrPrc.Parameters.AddWithValue("@i_Sotr", IV); StrPrc.Parameters.AddWithValue("@o_Sotr", OV); StrPrc.Parameters.AddWithValue("@Password", PV); StrPrc.Parameters.AddWithValue("@Login", LV); StrPrc.Parameters.AddWithValue("@E_Mail", EMV); StrPrc.Parameters.AddWithValue("@System_Access", SID); StrPrc.Parameters.AddWithValue("@Role_id", RV); StrPrc.ExecuteNonQuery(); _RI.Connection.Close(); }
private void button2_Click(object sender, EventArgs e) { try { _RI = new Reg(); _RI.Set_Connection(); //Установка соединения с базой _RI.Connection.Open(); //Открытие соединения SqlDataAdapter auth = new SqlDataAdapter("SELECT COUNT(*) FROM DBO.sotr WHERE login = '******' and password = '******'", _RI.Connection); //Запрос на вывод количества строк, где поля логин и пароль соответствуют значениям из текстового поля 1 и 2 _RI.Connection.Close(); //Закрытие соединения DataTable dt = new DataTable(); //Создание экзампляра объекта DataTable auth.Fill(dt); //Заполнение таблицы данными, полученными из запроса if (dt.Rows[0][0].ToString() == "1") //Если в первой ячейке таблицы содержиться 1, то { _CBD = new ControlBD(); //Объявление экземпляра класса ControlBD _CBD.Autorization(textBox1.Text, Crypt_Class.Encrypt(textBox2.Text)); //Вызов метода Autorization, передача в метод значений из текстового поля 1 и 2 MessageBox.Show("Добро пожаловать, " + Program.FIOSOTR); switch (Program.SYSACCESS) //Проверка значения из переменной SYSACCESS в классе Program { case 0: //если 0 switch (Program.PSACCESS) //Проверка значения из переменной PSACCESS в классе Program { case 1: //если 1 _RI.Connection.Close(); //Закрытие соединения с базой PasportnStol passtol = new PasportnStol(); //Объявление экземпляра класса PasportnStol passtol.Show(); //Вызов формы this.Close(); //Закрытие текущей формы break; } switch (Program.AOACCESS) { case 1: _RI.Connection.Close(); Abonent_Otdel ao_otdel = new Abonent_Otdel(); ao_otdel.Show(); this.Close(); break; } switch (Program.UOACCESS) { case 1: _RI.Connection.Close(); Universal uo_otdel = new Universal(); uo_otdel.Show(); this.Close(); break; } switch (Program.OFMSACCESS) { case 1: _RI.Connection.Close(); OFMS ofms = new OFMS(); ofms.Show(); this.Close(); break; } switch (Program.ZAGZACCESS) { case 1: _RI.Connection.Close(); ZAGS zags = new ZAGS(); zags.Show(); this.Close(); break; } switch (Program.SZACCESS) { case 1: _RI.Connection.Close(); SocZashch sz_otdel = new SocZashch(); sz_otdel.Show(); this.Close(); break; } break; case 1: _RI.Connection.Close(); Program.ADMINACCESS = false; Program.BACKTOADMIN = true; MainForm MF = new MainForm(); MF.Show(); this.Close(); break; case 2: _RI.Connection.Close(); Program.ADMINACCESS = true; Program.BACKTOADMIN = true; MainForm MainForm = new MainForm(); MainForm.Show(); this.Close(); break; } } else { MessageBox.Show("Указанной связки Логин-Пароль не существует"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } _RI.Connection.Close(); }