private void ClMainLoad()
{
Action action = () =>
{
Table_Class tableClient = new Table_Class(String.Format("SELECT [Client_Face_Firstname] + [Client_Face_Name] + [Client_Face_Patronymic] +\'(\' + (select [Client_Name] from [dbo].[Client] where [ID_Client] = [Client_ID]) +\')\',[Client_Face_Adress],[Client_Face_Password] FROM [dbo].[Client_Face] WHERE [ID_Client_Face] = {0}", Program.intID));
tbClient.Text = tableClient.table.Rows[0][0].ToString();
try
{
DES des = DES.Create();
byte[] key = Convert.FromBase64String("ybqAS+sVBLY=");
byte[] IV = Convert.FromBase64String("1mbClpyz5bU=");
des.Key = key;
des.IV = IV;
string loginout = Crypt_Class.SymmetricDecrypt(Convert.FromBase64String(tableClient.table.Rows[0][1].ToString()), des);
string passwdout = Crypt_Class.SymmetricDecrypt(Convert.FromBase64String(tableClient.table.Rows[0][2].ToString()), des);
tbLogin.Text = loginout;
tbPassword.Clear();
tbConfirm.Clear();
Login = loginout;
Password = passwdout;
}
catch
{
}
};
Invoke(action);
}
private void BtEnter_Click(object sender, RoutedEventArgs e)
{
Action action = () =>
{
ArrayList array = new ArrayList();
array.Add(App.intID);
array.Add(Surname);
array.Add(Name);
array.Add(Firstname);
array.Add(Recruitment);
array.Add(Exp);
DES des = DES.Create();
byte[] key = Convert.FromBase64String("WdbWuvWCHPc=");
byte[] IV = Convert.FromBase64String("RuBs2bQBW58=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbLogin.Text, des);
byte[] passwd = Crypt_Class.SymmetricEncrypt(tbPassword.Text, des);
array.Add(Convert.ToBase64String(login));
array.Add(Convert.ToBase64String(passwd));
array.Add(Pos);
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Staff_Update", array);
MessageBox.Show("Данные успешно изменены", "ParawosoffApp", MessageBoxButton.OK, MessageBoxImage.Information);
BasicsSelect();
this.Hide();
Owner.Show();
};
action.Invoke();
}
private void BtEnter_Click(object sender, EventArgs e)
{
//Проверка
switch (tbUserLogin.Text == "")
{
case true:
tbUserLogin.BackColor = Color.Red;
break;
case false:
tbUserLogin.BackColor = Color.White;
switch (tbUserPassword.Text == "")
{
case true:
tbUserPassword.BackColor = Color.Red;
break;
case false:
//Авторизация
tbUserPassword.BackColor = Color.White;
ArrayList AutorizData = new ArrayList();
DES des = DES.Create();
byte[] key = Convert.FromBase64String("ybqAS+sVBLY=");
byte[] IV = Convert.FromBase64String("1mbClpyz5bU=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbUserLogin.Text, des);
byte[] passwd = Crypt_Class.SymmetricEncrypt(tbUserPassword.Text, des);
AutorizData.Add("\'" + Convert.ToBase64String(login) + "\'");
AutorizData.Add("\'" + Convert.ToBase64String(passwd) + "\'");
tbUserLogin.Clear();
tbUserPassword.Clear();
Function_class function = new Function_class("Authorization", Function_class.Function_Result.table, AutorizData);
if (function.Regtable.Rows.Count > 0)
{
if ((function.Regtable.Rows[0][2].ToString() == "False") & (function.Regtable.Rows[0][3].ToString() == "False"))
{
Program.intID = function.Regtable.Rows[0][0].ToString();
Client_Interface client_Interface = new Client_Interface();
client_Interface.Owner = this;
client_Interface.Show();
this.Hide();
}
else
{
MessageBox.Show("Данный пользователь не найден. Пожалуйста, зарегестрируйтесь или введите правильные данные для продолжения.", "Arizona Client", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("Данный пользователь не найден. Пожалуйста, зарегестрируйтесь или введите правильные данные для продолжения.", "Arizona Client", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
break;
}
break;
}
}
public void Register_set(string DSvalue, string ICvalue, string UNvalue, string UPvalue)
{
RegistryKey Sale_Option = Registry.CurrentUser;
RegistryKey DBCon = Sale_Option.CreateSubKey("DB");
DBCon.SetValue("DS", Crypt_Class.Encrypt(DSvalue));
DBCon.SetValue("IC", Crypt_Class.Encrypt(ICvalue));
DBCon.SetValue("UN", Crypt_Class.Encrypt(UNvalue));
DBCon.SetValue("UP", Crypt_Class.Encrypt(UPvalue));
Register_get();
}
private void BtEnter_Click(object sender, RoutedEventArgs e)
{
Action action = () =>
{
Table_Class table = new Table_Class(String.Format("select count (*) from [dbo].[Staff] where [Login] = \'{0}\'", tbLogin.Text));
if (table.table.Rows[0][0].ToString() != "0")
{
MessageBox.Show("Этот логин использовать нельзя!", "ParawosoffApp", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
ArrayList staff = new ArrayList();
staff.Add(tbFirstName.Text);
staff.Add(tbName.Text);
staff.Add(tbPatronymic.Text);
staff.Add(tbExp.Text);
DES des = DES.Create();
byte[] key = Convert.FromBase64String("WdbWuvWCHPc=");
byte[] IV = Convert.FromBase64String("RuBs2bQBW58=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbLogin.Text, des);
byte[] passwd = Crypt_Class.SymmetricEncrypt(tbPassword.Text, des);
staff.Add(Convert.ToBase64String(login));
staff.Add(Convert.ToBase64String(passwd));
staff.Add(cbPosition.SelectedValue.ToString());
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Staff_Insert", staff);
Table_Class ID = new Table_Class("select [ID_Staff],[Timestamp] from [dbo].[Staff] WHERE [Timestamp] = (select MAX([Timestamp]) from [dbo].[Staff])");
ArrayList array = new ArrayList();
array.Add(String.Format("Приём на работу ({0})", ID.table.Rows[0][0].ToString()));
Table_Class pos = new Table_Class(String.Format("select [PositionName] from [dbo].[Position] where [ID_Position] = \'{0}\'", cbPosition.SelectedValue.ToString()));
array.Add(String.Format("Принять сотрудника {0} {1} {2} на должность {3}. Дата: {4}", tbFirstName.Text, tbName.Text, tbPatronymic.Text, pos.table.Rows[0][0].ToString(), ID.table.Rows[0][1].ToString()));
array.Add(ID.table.Rows[0][0].ToString());
procedure.procedure_Execution("Order_Insert", array);
this.Hide();
(Owner as ManagerInterface).TableRefresh();
Owner.Show();
}
};
action.Invoke();
}
public void Register_get()
{
try
{
RegistryKey Sale_Option = Registry.CurrentUser;
RegistryKey DBCon = Sale_Option.CreateSubKey("DB");
DS = Crypt_Class.Decrypt(DBCon.GetValue("DS").ToString());
IC = Crypt_Class.Decrypt(DBCon.GetValue("IC").ToString());
UN = Crypt_Class.Decrypt(DBCon.GetValue("UN").ToString());
UP = Crypt_Class.Decrypt(DBCon.GetValue("UP").ToString());
Set_Connection();
}
catch
{
RegistryKey Sale_Option = Registry.CurrentUser;
RegistryKey DBCon = Sale_Option.CreateSubKey("DB");
DBCon.SetValue("DS", "Empty");
DBCon.SetValue("IC", "Empty");
DBCon.SetValue("UN", "Empty");
DBCon.SetValue("UP", "Empty");
}
}
private void BasicsSelect()
{
Action action = () =>
{
Table_Class basics = new Table_Class(String.Format("SELECT [Surname],[Name],[Firstname],[Recruitment],[Exp],[Login],[Position_ID] FROM [dbo].[Staff] WHERE [ID_Staff] = {0}", App.intID));
Surname = basics.table.Rows[0][0].ToString();
Name = basics.table.Rows[0][1].ToString();
Firstname = basics.table.Rows[0][2].ToString();
Recruitment = basics.table.Rows[0][3].ToString();
Exp = basics.table.Rows[0][4].ToString();
Pos = basics.table.Rows[0][6].ToString();
DES des = DES.Create();
byte[] key = Convert.FromBase64String("WdbWuvWCHPc=");
byte[] IV = Convert.FromBase64String("RuBs2bQBW58=");
des.Key = key;
des.IV = IV;
string login = Crypt_Class.SymmetricDecrypt(Convert.FromBase64String(basics.table.Rows[0][5].ToString()), des);
tbLogin.Text = login;
tbPassword.Clear();
};
action.Invoke();
}
private void Autorization()
{
Action action = () =>
{
DES des = DES.Create();
byte[] key = Convert.FromBase64String("WdbWuvWCHPc=");
byte[] IV = Convert.FromBase64String("RuBs2bQBW58=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbLogin.Text, des);
byte[] passwd = Crypt_Class.SymmetricEncrypt(tbPassword.Password, des);
ArrayList array = new ArrayList();
array.Add(Convert.ToBase64String(login));
array.Add(Convert.ToBase64String(passwd));
tbLogin.Clear();
tbPassword.Clear();
Function_class autoriz = new Function_class("Autorization", Function_class.Function_Result.scalar, array);
if (autoriz.Regtable.Rows[0][0].ToString() == "-1")
{
MessageBox.Show("Учётная запись с такими параметрами не существует или является заблокированной!", "ParawosoffApp", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
App.intID = autoriz.Regtable.Rows[0][0].ToString();
Table_Class tablePos = new Table_Class(String.Format("select [Position_ID] from [dbo].[Staff] where [ID_Staff] = {0}", autoriz.Regtable.Rows[0][0].ToString()));
switch (tablePos.table.Rows[0][0].ToString())
{
case ("0"):
Selector selector = new Selector();
selector.Owner = this;
selector.Show();
this.Hide();
break;
case ("1"):
SaleInterface sale = new SaleInterface();
sale.Owner = this;
sale.Show();
this.Hide();
break;
case ("2"):
ManagerInterface manager = new ManagerInterface();
manager.Owner = this;
manager.Show();
this.Hide();
break;
case ("3"):
StoragerInterface storager = new StoragerInterface();
storager.Owner = this;
storager.Show();
this.Hide();
break;
case ("4"):
MarketerInterface marketer = new MarketerInterface();
marketer.Owner = this;
marketer.Show();
this.Hide();
break;
}
}
};
action.Invoke();
}
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();
}
private void button9_Click(object sender, EventArgs e)
{
switch (textBox4.Text == textBox5.Text)
{
case (true):
if ((dataGridView1.CurrentRow.Cells[0].Value != null) && (textBox1.Text != "") && (textBox2.Text != "") && (textBox4.Text != "") && (textBox5.Text != "") && (textBox7.Text != "") && (textBox8.Text != "") && (comboBox1.SelectedIndex >= 0) && (listBox1.SelectedIndex >= 0))
{
try
{
_CBD.Sotr_edit_void(Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()), textBox1.Text, textBox2.Text, textBox3.Text, Crypt_Class.Encrypt(textBox5.Text), textBox8.Text, textBox7.Text, Convert.ToInt32(listBox1.SelectedValue.ToString()), comboBox1.SelectedIndex);
Grid_Load();
}
catch (Exception ex)
{
_RI.Connection.Close();
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Не все поля заполнены!", "МФЦ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
break;
case (false):
textBox4.Clear();
textBox5.Clear();
MessageBox.Show("Пароли не совпадают!", "МФЦ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
break;
}
}
private void ClReg()
{
Action action = () =>
{
if (tbFirstname.Text.Length == 0)
{
tbFirstname.BackColor = Color.Red;
}
else
{
tbFirstname.BackColor = Color.White;
if (tbName.Text.Length == 0)
{
tbName.BackColor = Color.Red;
}
else
{
tbName.BackColor = Color.White;
if ((tbLogin.Text.Length == 0) | (tbLogin.Text.IndexOf('@') == -1) | (tbLogin.Text.IndexOf('.') == -1) | (tbLogin.Text.IndexOf('@') > tbLogin.Text.IndexOf('.')))
{
tbLogin.BackColor = Color.Red;
}
else
{
tbLogin.BackColor = Color.White;
ArrayList Checkarray = new ArrayList();
DES des = DES.Create();
byte[] key = Convert.FromBase64String("ybqAS+sVBLY=");
byte[] IV = Convert.FromBase64String("1mbClpyz5bU=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbLogin.Text, des);
Checkarray.Add("\'" + Convert.ToBase64String(login) + "\'");
Function_class UQCheck = new Function_class("Client_Face_Adress_UQ_Check", Function_class.Function_Result.scalar, Checkarray);
if (UQCheck.Regtable.Rows[0][0].ToString() == "False")
{
tbLogin.BackColor = Color.Red;
}
else
{
tbLogin.BackColor = Color.White;
if ((tbPassword.Text.Length < 6) | (tbPassword.Text.IndexOfAny(numbers) == -1) | (tbPassword.Text.IndexOfAny(ruLetters) != -1) | (tbPassword.Text != tbConfirm.Text))
{
tbPassword.BackColor = Color.Red;
}
else
{
tbPassword.BackColor = Color.Red;
ArrayList array = new ArrayList();
array.Add(tbName.Text);
array.Add(tbFirstname.Text);
array.Add(tbPatronymic.Text);
DES indes = DES.Create();
byte[] inkey = Convert.FromBase64String("ybqAS+sVBLY=");
byte[] inIV = Convert.FromBase64String("1mbClpyz5bU=");
indes.Key = inkey;
indes.IV = inIV;
byte[] inlogin = Crypt_Class.SymmetricEncrypt(tbLogin.Text, indes);
byte[] inpasswd = Crypt_Class.SymmetricEncrypt(tbPassword.Text, indes);
array.Add(Convert.ToBase64String(inlogin));
array.Add(Convert.ToBase64String(inpasswd));
array.Add(cbClient.SelectedValue);
array.Add("0");
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Client_Face_Insert", array);
this.Hide();
this.Owner.Show();
}
}
}
}
}
};
Invoke(action);
}
private void ClReg()
{
Action action = () =>
{
if ((tbLogin.Text.Length == 0) | (tbLogin.Text.IndexOf('@') == -1) | (tbLogin.Text.IndexOf('.') == -1) | (tbLogin.Text.IndexOf('@') > tbLogin.Text.IndexOf('.')))
{
tbLogin.BackColor = Color.Red;
}
else
{
tbLogin.BackColor = Color.White;
ArrayList Checkarray = new ArrayList();
DES des = DES.Create();
byte[] key = Convert.FromBase64String("ybqAS+sVBLY=");
byte[] IV = Convert.FromBase64String("1mbClpyz5bU=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbLogin.Text, des);
Checkarray.Add("\'" + Convert.ToBase64String(login) + "\'");
Function_class UQCheck = new Function_class("Client_Face_Adress_UQ_Check", Function_class.Function_Result.scalar, Checkarray);
if ((UQCheck.Regtable.Rows[0][0].ToString() == "False") & (tbLogin.Text == Login))
{
tbLogin.BackColor = Color.Red;
}
else
{
tbLogin.BackColor = Color.White;
if ((tbPassword.Text.Length < 6) | (tbPassword.Text.IndexOfAny(numbers) == -1) | (tbPassword.Text.IndexOfAny(ruLetters) != -1) | (tbPassword.Text != tbConfirm.Text))
{
tbPassword.BackColor = Color.Red;
if ((tbPassword.Text == tbConfirm.Text) & ((tbPassword.Text == Password) | (tbPassword.Text != "")))
{
tbPassword.BackColor = Color.White;
ArrayList array = new ArrayList();
array.Add(Program.intID);
Table_Class tableClient = new Table_Class(String.Format("SELECT [Client_Face_Name],[Client_Face_Firstname],[Client_Face_Patronymic],[Client_ID] FROM [dbo].[Client_Face] WHERE [ID_Client_Face] = {0}", Program.intID));
array.Add(tableClient.table.Rows[0][0].ToString());
array.Add(tableClient.table.Rows[0][1].ToString());
array.Add(tableClient.table.Rows[0][2].ToString());
DES indes = DES.Create();
byte[] inkey = Convert.FromBase64String("ybqAS+sVBLY=");
byte[] inIV = Convert.FromBase64String("1mbClpyz5bU=");
indes.Key = inkey;
indes.IV = inIV;
byte[] inlogin = Crypt_Class.SymmetricEncrypt(tbLogin.Text, indes);
byte[] inpasswd = Crypt_Class.SymmetricEncrypt(Password, indes);
array.Add(Convert.ToBase64String(inlogin));
array.Add(Convert.ToBase64String(inpasswd));
array.Add(tableClient.table.Rows[0][3].ToString());
array.Add("0");
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Client_Face_Update", array);
ClMainLoad();
}
}
else
{
tbPassword.BackColor = Color.White;
ArrayList array = new ArrayList();
array.Add(Program.intID);
Table_Class tableClient = new Table_Class(String.Format("SELECT [Client_Face_Name],[Client_Face_Firstname],[Client_Face_Patronymic],[Client_ID] FROM [dbo].[Client_Face] WHERE [ID_Client_Face] = {0}", Program.intID));
array.Add(tableClient.table.Rows[0][0].ToString());
array.Add(tableClient.table.Rows[0][1].ToString());
array.Add(tableClient.table.Rows[0][2].ToString());
DES indes = DES.Create();
byte[] inkey = Convert.FromBase64String("ybqAS+sVBLY=");
byte[] inIV = Convert.FromBase64String("1mbClpyz5bU=");
indes.Key = inkey;
indes.IV = inIV;
byte[] inlogin = Crypt_Class.SymmetricEncrypt(tbLogin.Text, indes);
byte[] inpasswd = Crypt_Class.SymmetricEncrypt(tbPassword.Text, indes);
array.Add(Convert.ToBase64String(inlogin));
array.Add(Convert.ToBase64String(inpasswd));
array.Add(tableClient.table.Rows[0][3].ToString());
array.Add("0");
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Client_Face_Update", array);
ClMainLoad();
}
}
}
};
Invoke(action);
}
