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