private void TecAdd()
{
Action action = () =>
{
if (tbTecName.Text.Length == 0)
{
tbTecName.BackColor = Color.Red;
}
else
{
tbTecName.BackColor = Color.White;
ArrayList Checkarray = new ArrayList();
Checkarray.Add("\'" + tbTecName.Text + "\'");
Function_class UQCheck = new Function_class("Tec_Name_UQ_Check", Function_class.Function_Result.scalar, Checkarray);
if (UQCheck.Regtable.Rows[0][0].ToString() == "False")
{
MessageBox.Show("Технология с таким названием уже существует!", "Arizona Database", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
ArrayList array = new ArrayList();
Procedure_Class tecInsert = new Procedure_Class();
array.Add(tbTecName.Text);
array.Add(nudTecEfficiency.Value.ToString());
array.Add(tbTecAbout.Text);
tecInsert.procedure_Execution("Tec_Insert", array);
TecLoad();
}
}
};
Invoke(action);
}
private void GetDates()
{
Action action = () =>
{
if (orderList.Rows.Count > 0)
{
min = dtpStart.Value;
max = dtpStart.Value;
foreach (DataRow row in orderList.Rows)
{
ArrayList mintime = new ArrayList();
mintime.Add(row[0]);
mintime.Add(row[2]);
Function_class minTimeCount = new Function_class("Order_Count_Check_MAX", Function_class.Function_Result.scalar, mintime);
Double minAdd = Convert.ToDouble(minTimeCount.Regtable.Rows[0][0]);
min = min.AddDays(minAdd);
mintime.Clear();
}
foreach (DataRow row in orderList.Rows)
{
ArrayList maxtime = new ArrayList();
maxtime.Add(row[0]);
maxtime.Add(row[2]);
Function_class maxTimeCount = new Function_class("Order_Count_Check_MIN", Function_class.Function_Result.scalar, maxtime);
max = max.AddDays(Convert.ToDouble(maxTimeCount.Regtable.Rows[0][0]));
maxtime.Clear();
}
}
lblDate.Text = String.Format("Минимальная дата = {0}, Оптимальная дата = {1}", (min.Day.ToString() + "." + min.Month.ToString() + "." + min.Year.ToString()), (max.Day.ToString() + "." + max.Month.ToString() + "." + max.Year.ToString()));
dtpEnd.Value = min;
};
Invoke(action);
}
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;
}
}
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);
}