private void CbFill()
{
Table_Class tableClass = new Table_Class("SELECT [ID_Kachestvo],[Nazv_Kachestvo] FROM [Restoran].[dbo].[Kachestvo]");
comboBox1.DataSource = tableClass.table.DefaultView;
comboBox1.ValueMember = "ID_Kachestvo";
comboBox1.DisplayMember = "Nazv_Kachestvo";
}
private void filll()
{
Table_Class tablePos = new Table_Class("select [ID_Position], [Position_Name] from [dbo].[Position]");
tbPosition.DataSource = tablePos.table.DefaultView;
tbPosition.DisplayMember = "Position_Name";
tbPosition.ValueMember = "ID_Position";
}
private void CbFill()
{
Table_Class tableClass2 = new Table_Class("SELECT ID_Tovara, Name_of_Tovar FROM dbo.Spisok_Tovarov");
comboBox2.DataSource = tableClass2.table.DefaultView;
comboBox2.ValueMember = "ID_Tovara";
comboBox2.DisplayMember = "Name_of_Tovar";
}
private void DgFill()
{
var table_class = new Table_Class("SELECT [ID_Otdela] ,[Nazvanie_Otdela] as \"НазваниеОтдела\"," +
"[Number_Otdela] as \"НомерОтдела\" FROM [Restoran].[dbo].[Otdel]");
dataGridView1.DataSource = table_class.table.DefaultView;
dataGridView1.Columns[0].Visible = false;
}
private void CbFill()
{
Table_Class tableClass = new Table_Class("SELECT ID_Otdela, Nazvanie_Otdela FROM dbo.Otdel");
comboBox1.DataSource = tableClass.table.DefaultView;
comboBox1.ValueMember = "ID_Otdela";
comboBox1.DisplayMember = "Nazvanie_Otdela";
}
private void DgFill()
{
string sqlstr = "SELECT " +
"ID_Check, " +
"Nomer_Check as Товар " +
"FROM [Check] ";
var table_class = new Table_Class(sqlstr);
dataGridView1.DataSource = table_class.table.DefaultView;
}
private void DgFill()
{
var table_class = new Table_Class("SELECT [ID_Tovara],[Name_of_Tovar] as \"Имя Товара\",[Number_of_Tovar] as \"Номер Товара\"" +
",[Date_Postavka] as \"Дата Поставки Товара\",[Srok_Godnosti] as \"СрокГодности\", " +
"[Nazv_Kachestvo] as \"Название Качества\", [ID_Kachestvo] FROM [Restoran].[dbo].[Spisok_Tovarov] inner join" +
" [Restoran].[dbo].[Kachestvo] on [Restoran].[dbo].[Spisok_Tovarov].[Kachestvo_ID] = [Restoran].[dbo].[Kachestvo].[ID_Kachestvo]");
dataGridView1.DataSource = table_class.table.DefaultView;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[6].Visible = false;
}
private void gridFill()
{
Action action = () =>
{
Table_Class table = new Table_Class("SELECT [ID_Position] as \'Номер должности\', [Position_Name] as \'Наименование\' FROM [dbo].[Position]");
table.Dependency.OnChange += Dependency_OnChange;
dataGridView1.DataSource = table.table.DefaultView;
};
Invoke(action);
}
private void DgFill()
{
//string sqlstr = "SELECT " +
//"ID_Education, " +
//"Type_of_Education as Образование " +
//"FROM Education ";
var table_class = new Table_Class(sqlstr);
dataGridView1.DataSource = table_class.table.DefaultView;
dataGridView1.Columns[0].Visible = false;
}
private void gridFill()
{
Action action = () =>
{
Table_Class table = new Table_Class("SELECT [ID_Type_of_Product] as \'Номер\', [Type_of_Product] as \'Тип товара\'" +
" FROM [dbo].[Type_of_Product]");
table.Dependency.OnChange += Dependency_OnChange;
dataGridView1.DataSource = table.table.DefaultView;
};
Invoke(action);
}
private void DgFill()
{
table_class1 = new Table_Class("SELECT [ID_Zakaza] as \"Код заказа\",[Summa_Zakaza] as \"СуммаЗаказа\",[Number_of_Stol] as \"НомерСтола\"," +
" [Name_Sotrudnika] as \"ФамилияСотрудника\", [Name_of_Tovar] as \"ИмяТовара\", [ID_Tovara], [ID_Sotrudnika]" +
" FROM [Restoran].[dbo].[Zakaz] inner join [Restoran].[dbo].[Sotrudniki] on" +
" [Restoran].[dbo].[Zakaz].[Sotrudnika_ID] = [Restoran].[dbo].[Sotrudniki].[ID_Sotrudnika] " +
"inner join [Restoran].[dbo].[Spisok_Tovarov] on [Restoran].[dbo].[Zakaz].[Tovar_ID] = [Restoran].[dbo].[Spisok_Tovarov].[ID_Tovara]" +
$" WHERE [ID_Zakaza] = {Program.GotovZakaz}");
dataGridView1.DataSource = table_class1.table.DefaultView;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
}
private void gridFill()
{
Action action = () =>
{
Table_Class table = new Table_Class("SELECT [ID_Client] as \'Номер\', [Client_Name] as \'Имя\'" +
", [Client_MiddleName] as \'Отчество\', [Client_LastName] as\'Фамилия\', [Discount] as \'Скидка\' FROM [dbo].[Client]");
table.Dependency.OnChange += Dependency_OnChange;
dataGridView1.DataSource = table.table.DefaultView;
};
Invoke(action);
}
private void DgFill()
{
var table_class = new Table_Class("SELECT ID_Sotrudnika, [Name_Sotrudnika] as \"Фамилия\" ," +
"[Midlle_Name_Sotrudnika] as \"Имя\",[Last_Name_Sotrudnika] as \"Отчество\",[Birhady_Date_Sotrudnika] as \"Дата Рождения\"" +
",[Document_Series] as \"Серия Паспорта\" " +
",[Document_Number] as \"Номер Паспорта\",[Sotrudnika_Login] as \"Логин\",[Sotrudnika_Password] as \"Пароль\", " +
"[Nazvanie_Otdela] as \"Название Отдела\", Otdel_ID FROM [Restoran].[dbo].[Sotrudniki] INNER JOIN [Restoran].[dbo].[Otdel] ON " +
"[Restoran].[dbo].[Sotrudniki].[Otdel_ID] = [Restoran].[dbo].[Otdel].[ID_Otdela]");
dataGridView1.DataSource = table_class.table.DefaultView;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[10].Visible = false;
}
public void Update()
{
var qwertyLOGPASKlient = $"SELECT * FROM dbo.Klient WHERE ID_Klient = {ID_Klient}";
var ProverkaKlient = new Table_Class(qwertyLOGPASKlient);
ID_Klient = Convert.ToInt32(ProverkaKlient.table.Rows[0][0]);
First_Name_Klient = Convert.ToString(ProverkaKlient.table.Rows[0][1]);
Name_Klient = Convert.ToString(ProverkaKlient.table.Rows[0][2]);
Middle_Name_Klient = Convert.ToString(ProverkaKlient.table.Rows[0][3]);
Klient_Login = Convert.ToString(ProverkaKlient.table.Rows[0][4]);
Klient_Password = Convert.ToString(ProverkaKlient.table.Rows[0][5]);
Klient_Logical_Delete = Convert.ToBoolean(ProverkaKlient.table.Rows[0][6]);
}
private void DgFill()
{
ID_Товар = -1;
string sqlstr = "select ID_Goods_Klient_Check, Goods.Name_of_Goods from dbo.Goods_Klient_Check " +
"inner join dbo.Goods on dbo.Goods_Klient_Check.Goods_ID = dbo.Goods.ID_Goods " +
"where dbo.Goods_Klient_Check.Klient_ID = " + Program.IDKlient +
"and " +
"dbo.Goods_Klient_Check.Check_ID = " + ID_Check;
table_class = new Table_Class(sqlstr);
dataGridViewЗаказ.DataSource = table_class.table.DefaultView;
}
protected void Search(object sender, EventArgs e)
{
Table_Class search_one = new Table_Class();
StringBuilder sbTable = new StringBuilder();
String a = search_one.Inquire();
var jArray = MySqlFunctions.string_to_array(a);
sbTable.Append("<table><thead>");
sbTable.Append("<tr><th>");
sbTable.Append("课程名");
sbTable.Append("</th><th>");
sbTable.Append("课程号");
sbTable.Append("</th><th>");
sbTable.Append("教师名");
sbTable.Append("</th><th>");
sbTable.Append("学分");
sbTable.Append("</th><th>");
sbTable.Append("考试时间");
sbTable.Append("</th></tr>");
sbTable.Append("</thead><tbody>");
for (int i = 0; i < jArray.Count; i++)
{
var jObject = MySqlFunctions.string_to_jobj(jArray[i].ToString());
List <String> list = new List <string>();
String class_name = jObject[Table_Class.Name.class_name].ToString();
list.Add(class_name);
String class_id = jObject[Table_Class.Name.class_id].ToString();
list.Add(class_id);
String teachername = jObject[Table_Class.Name.teachername].ToString();
list.Add(teachername);
String test_time = jObject[Table_Class.Name.test_time].ToString();
list.Add(test_time);
String class_grade = jObject[Table_Class.Name.class_grade].ToString();
list.Add(class_grade);
sbTable.Append("<tr><th>");
sbTable.Append(class_name);
sbTable.Append("</th><th>");
sbTable.Append(class_id);
sbTable.Append("</th><th>");
sbTable.Append(teachername);
sbTable.Append("</th><th>");
sbTable.Append(class_grade);
sbTable.Append("</th><th>");
sbTable.Append(test_time);
sbTable.Append("</th></tr>");
show.InnerHtml = sbTable.ToString();
}
sbTable.Append("</tbody>");
}
private void DgFill()
{
//string sqlstr = "SELECT [ID_Klient] , " +
// "[First_Name_Klient] as Фамилия, " +
// "[Name_Klient] as Имя, " +
// "[Middle_Name_Klient] as Отчество, " +
// "[Klient_Login] as Логин, " +
// "[Klient_Password] as Пароль, " +
// "[Klient_Logical_Delete] as Удаление " +
// "FROM [dbo].[Klient]";
var table_class = new Table_Class(sqlstr);
dataGridView1.DataSource = table_class.table.DefaultView;
dataGridView1.Columns[0].Visible = false;
}
private void ChartFill()
{
Table_Class table_Class = new Table_Class("select [ID_Employee], [Employee_Name], [Employee_MiddleName], " +
"[Employee_Lastname], [Login_Employee], [Password_Employee] " +
" from [dbo].[Employee]");
chrExpensens.DataSource = table_Class.table.DefaultView.ToTable();
try
{
chrExpensens.Series["srExpens"].XValueMember = (table_Class.table.Rows[0][0]).ToString();
chrExpensens.Series["srExpens"].YValueMembers = (table_Class.table.Rows[0][1]).ToString();
chrExpensens.DataBind();
}
catch { }
}
private void gridFill()
{
Action action = () =>
{
Table_Class table = new Table_Class("SELECT [ID_Storage] as \'Номер\', [Storage_Place] as \'Место хранения\'," +
"[Product_Name] as \'Товар\' FROM [dbo].[Storage] INNER JOIN [dbo].[Product] on [dbo].[Storage].[Product_ID] = " +
"[dbo].[Product].[ID_Product]");
Table_Class tableProduct = new Table_Class("SELECT [ID_Product], [Product_Name] FROM [dbo].[Product]");
cbProduct.DataSource = tableProduct.table.DefaultView;
cbProduct.DisplayMember = "Product_Name";
cbProduct.ValueMember = "ID_Product";
table.Dependency.OnChange += Dependency_OnChange;
dataGridView1.DataSource = table.table.DefaultView;
};
Invoke(action);
}
private void DgFill()
{
string sqlstr = "SELECT " +
"ID_Goods_Klient_Check, " +
"Klient.First_Name_Klient as Клиент, " +
"Goods.Name_of_Goods as Товар, " +
"Goods_ID, Klient_ID " +
"FROM Goods_Klient_Check " +
"INNER JOIN Goods ON ID_Goods = Goods_ID " +
"INNER JOIN Klient ON ID_Klient = Klient_ID ";
var table_class = new Table_Class(sqlstr);
dataGridView1.DataSource = table_class.table.DefaultView;
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].Visible = false;
}
private void gridFill()
{
Action action = () =>
{
Table_Class table = new Table_Class("SELECT [ID_Product] as \'Номер\', [Product_Name] as \'Наименование\'" +
", [Product_Amount] as \'Количество\', [Product_Price] as\'Цена\', [Type_of_Product] as \'Тип\' FROM [dbo].[Product] INNER JOIN [dbo].[Type_of_Product] ON [dbo].[Product].[Type_of_Product_ID]= " +
"[dbo].[Type_of_Product].[ID_Type_of_Product]");
Table_Class tableType = new Table_Class("SELECT [ID_Type_of_Product], [Type_of_Product] FROM [dbo].[Type_of_Product]");
cbType.DataSource = tableType.table.DefaultView;
cbType.DisplayMember = "Type_of_Product";
cbType.ValueMember = "ID_Type_of_Product";
table.Dependency.OnChange += Dependency_OnChange;
dataGridView1.DataSource = table.table.DefaultView;
};
Invoke(action);
}
//Выход из окна
private void button1_Click(object sender, EventArgs e)
{
string Login = tbUser_Login.Text;
string Password = tbUser_Password.Text;
var qwertyLOGPASSotr = $"SELECT ID_Employee FROM dbo.Employee WHERE Employee_Login = '******' AND Employee_Password = '******'";
var ProverkaSotr = new Table_Class(qwertyLOGPASSotr);
var qwertyLOGPASKlient = $"SELECT * FROM dbo.Klient WHERE Klient_Login = '******' AND Klient_Password = '******'";
//SELECT ID_Klient FROM dbo.Klient WHERE Klient_Login = '******' AND Klient_Password = '******'
var ProverkaKlient = new Table_Class(qwertyLOGPASKlient);
if (ProverkaSotr.table.Rows.Count != 0)
{
//Program.Dostup = Convert.ToInt32(Proverka.table.Rows[0][0].ToString());
Program.IDSotr = Convert.ToInt32(ProverkaSotr.table.Rows[0][0].ToString());
new MainForm().Show();
Visible = false;
ShowInTaskbar = false;
}
else if (ProverkaKlient.table.Rows.Count != 0)
{
Program.IDKlient = Convert.ToInt32(ProverkaKlient.table.Rows[0][0].ToString());
Program.modelKlient = new ModelKlient(
Convert.ToInt32(ProverkaKlient.table.Rows[0][0]),
Convert.ToString(ProverkaKlient.table.Rows[0][1]),
Convert.ToString(ProverkaKlient.table.Rows[0][2]),
Convert.ToString(ProverkaKlient.table.Rows[0][3]),
Convert.ToString(ProverkaKlient.table.Rows[0][4]),
Convert.ToString(ProverkaKlient.table.Rows[0][5]),
Convert.ToBoolean(ProverkaKlient.table.Rows[0][6])
);
new Personal_Profile_Klient().Show();
//new Goods_Klient_Check().Show();
Visible = false;
ShowInTaskbar = false;
}
else
{
MessageBox.Show("Не правильно введен логин или пароль!", "Мвидео", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
}
}
private void btStag_Click(object sender, RoutedEventArgs e)
{
Table_Class tableClass = new Table_Class($"SELECT dbo.Proverka_Procenta({tbStajer.Text})");
if (Convert.ToInt32(tableClass.table.Rows[0][0]) == 100)
{
tbStajer.IsEnabled = false;
List <TextBox> tb = new List <TextBox>()
{
tbFam, tbIm, tbOtch, tbdate_Rojd, tbSer_Pas, tbNum_Pas, tbLogin
};
Table_Class dtStagirovka = new Table_Class("SELECT Stajirovka.First_Name_Stajera, Stajirovka.Middle_Name_Stajera, " +
"Stajirovka.Last_Name_Stajera, Stajirovka.Pasport_Series_Stajera, Stajirovka.Pasport_Number_Stajera " +
"FROM dbo.Stajirovka " +
$"WHERE ID_Stajirovka = {tbStajer.Text}");
int i = 0;
foreach (TextBox textBox in tb)
{
textBox.IsEnabled = true;
}
foreach (TextBox textBox in tb.GetRange(0, 6))
{
if (textBox.Name != tbdate_Rojd.Name)
{
textBox.Text = dtStagirovka.table.Rows[0][i].ToString();
i++;
}
}
tbPassword.IsEnabled = true;
tbConfPassword.IsEnabled = true;
btReg.IsEnabled = true;
}
else
{
MessageBox.Show("Вы не полностью прошли стажировку!!!", "ИНЖПРОМТОРГ", MessageBoxButton.OK,
MessageBoxImage.Warning);
MainWindow mainWindow = new MainWindow();
mainWindow.Show();
Visibility = Visibility.Collapsed;
}
}
/// <summary>
/// Метод вывод данных из БД на форму
/// </summary>
private void Klient_Data_Fill()
{
Action action = () =>
{
//Выгрузка данных о авторизированном клиенте
Table_Class table_Class = new Table_Class("select [Employee_Name], [Employee_MiddleName], " +
"[Employee_Lastname], [Position_Name], [Login_Employee], [Password_Employee] " +
" from [dbo].[Employee] INNER JOIN" +
"[dbo].[Position] ON [dbo].[Employee].[Position_ID]= [dbo].[Position].[ID_Position] where [dbo].[Employee].[ID_Employee] = " + Program.intID);
Table_Class tablePos = new Table_Class("select [ID_Position], [Position_Name] from [dbo].[Position]");
tbPosition.DataSource = tablePos.table.DefaultView;
tbPosition.DisplayMember = "Position_Name";
tbPosition.ValueMember = "ID_Position";
//Организация прослушивания сервера
table_Class.Dependency.OnChange += Dependency_OnChange;
//Присоение значений из table класса DateTable
//Значений 0 строки и с 0 по шестой столбец
Klient_First_Name = table_Class.table.Rows[0][2].ToString();
Klient_Name = table_Class.table.Rows[0][0].ToString();
Klient_Middle_Name = table_Class.table.Rows[0][1].ToString();
Login = table_Class.table.Rows[0][4].ToString();
Password = table_Class.table.Rows[0][5].ToString();
position = table_Class.table.Rows[0][3].ToString();
//Перезапись значений в надписях форме
lblKlient_Surname.Text = "Фамилия: " + Klient_First_Name;
lblKlient_Name.Text = "Имя: " + Klient_Name;
lblKlient_Middlename.Text = "Отчество: " + Klient_Middle_Name;
lblKlient_Create.Text = "" + Card_Create;
tbFirst_Name.Text = Klient_First_Name;
tbName.Text = Klient_Name;
tbMiddle_Name.Text = Klient_Middle_Name;
tbLogin.Text = Login;
lbPosition.Text = "Должность:" + position;
ChartFill();
};
Invoke(action);
//tbPosition.SelectedValue = "ID_Position";
//dtpStartDate.Value = Convert.ToDateTime(Card_Create);
}
private void DgFill()
{
var table_class1 = new Table_Class("SELECT [ID_Zakaza] as \"Код заказа\",[Summa_Zakaza] as \"СуммаЗаказа\",[Number_of_Stol] as \"НомерСтола\"," +
" [Name_Sotrudnika] as \"ФамилияСотрудника\", [Name_of_Tovar] as \"ИмяТовара\", [ID_Tovara], [ID_Sotrudnika]" +
" FROM [Restoran].[dbo].[Zakaz] inner join [Restoran].[dbo].[Sotrudniki] on" +
" [Restoran].[dbo].[Zakaz].[Sotrudnika_ID] = [Restoran].[dbo].[Sotrudniki].[ID_Sotrudnika] " +
"inner join [Restoran].[dbo].[Spisok_Tovarov] on [Restoran].[dbo].[Zakaz].[Tovar_ID] = [Restoran].[dbo].[Spisok_Tovarov].[ID_Tovara]");
dataGridView1.DataSource = table_class1.table.DefaultView;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
var table_class = new Table_Class("SELECT [ID_Tovara],[Name_of_Tovar] as \"Имя Товара\",[Number_of_Tovar] as \"Номер Товара\"" +
",[Date_Postavka] as \"Дата Поставки Товара\",[Srok_Godnosti] as \"Срок Годности\", " +
"[Nazv_Kachestvo] as \"Название Качества\", [ID_Kachestvo] FROM [Restoran].[dbo].[Spisok_Tovarov] inner join" +
" [Restoran].[dbo].[Kachestvo] on [Restoran].[dbo].[Spisok_Tovarov].[Kachestvo_ID] = [Restoran].[dbo].[Kachestvo].[ID_Kachestvo]");
dataGridView2.DataSource = table_class.table.DefaultView;
dataGridView2.Columns[0].Visible = false;
dataGridView2.Columns[6].Visible = false;
}
/// <summary>
/// Метод обращения к любой хранимой процедуре Microsoft SQL Server
/// </summary>
/// <param name="Procedure_name">Водимое название процедуры из БД</param>
/// <param name="fileld_value">Не типизированная коллекция значений приложения</param>
public void procedure_Execution(string Procedure_name, ArrayList fileld_value)
{
//Запрос на вывод списка параметров, конкретной хранимолй процедуры
//в зависимости от введённого разработчиком названия Stored Procedure
Table_Class table = new Table_Class(string.Format("select name from sys.parameters " +
"where " +
"object_id =" +
" (select object_id from sys.procedures where name = '{0}')", Procedure_name));
try
{
//Настройка SQLCommand для работы с хранимыми процедурами
command.CommandType = CommandType.StoredProcedure;
//Присвоение в текст команды названия хранимой процедуры
command.CommandText = string.Format("[dbo].[{0}]", Procedure_name);
//Отчистка параметров
command.Parameters.Clear();
for (int i = 0; i < table.table.Rows.Count; i++)
{
//Сопоставление значений коллекций в значения параметров
command.Parameters.AddWithValue(table.table.Rows[i][0].ToString(),
fileld_value[i]);
}
//Объявление события на перехват сообщений из БД
Configuration_class.connection.InfoMessage += Connection_InfoMessage;
//Открытие подключения
Configuration_class.connection.Open();
//Выполнение запроса процедуры
command.ExecuteNonQuery();
}
catch
{
}
finally
{
//Закрытие подключения
Configuration_class.connection.Close();
}
}
private void DgFill()
{
string sqlstr = "SELECT " +
"ID_Employee, " +
"Education.Type_of_Education as Образование, " +
"Position.Type_of_Position as Должность, " +
"Data_Recruitment as Дата_приема_на_работу, " +
"First_Name as Фамилия, Name_Employee as Имя, Middle_Name as Отчество, Employee_Login as Логин, Employee_Password as Пароль, " +
"Education_ID, Position_ID " +
"FROM Employee " +
"INNER JOIN Education ON ID_Education = Education_ID " +
"INNER JOIN Position ON ID_Position = Position_ID " +
"INNER JOIN Recruitment ON ID_Recruitment = Recruitment_ID";
var table_class = new Table_Class(sqlstr);
dataGridView1.DataSource = table_class.table.DefaultView;
//var v = table_class.table.Rows[3].ItemArray[3];
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
string Login = tbLogin.Text;
string Password = tbPassword.Text;
var Proverka = new Table_Class($"SELECT Otdel_ID, ID_Sotrudnika FROM dbo.Sotrudniki WHERE Sotrudnika_Login = '******' AND Sotrudnika_Password = '******'");
try
{
if (Proverka.table.Rows[0][0] != DBNull.Value)
{
Program.Dostup = Convert.ToInt32(Proverka.table.Rows[0][0].ToString());
Program.IDSotr = Convert.ToInt32(Proverka.table.Rows[0][1].ToString());
new MainPage().Show();
Visible = false;
ShowInTaskbar = false;
}
}
catch
{
MessageBox.Show("Не правильно введен логин или пароль!", "Ресторан", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
}
}
private void btEnter_Click(object sender, RoutedEventArgs e)
{
string Login = tbLogin.Text;
string Password = tbPassword.Password;
Table_Class @class = new Table_Class($"select ID_Sotrudnika, Sotrudnika_Password from Sotrudniki where Sotrudnika_Login = '******' ");
try
{
if (@class.table.Rows[0][0] != DBNull.Value)
{
HashClass hashClass = new HashClass();
bool Proverka = hashClass.VerifyHashedPassword(@class.table.Rows[0][1].ToString(), Password);
if (Proverka)
{
Table_Class tableClass = new Table_Class($"select dbo.Auth('{Login}','{@class.table.Rows[0][1]}')");
string Acess = tableClass.table.Rows[0][0].ToString();
App.intID = @class.table.Rows[0][0].ToString();
MessageBox.Show("Vse zbs", "ИНЖПРОМТОРГ", MessageBoxButton.OK,
MessageBoxImage.Warning);
}
else
{
MessageBox.Show("Не правильно введен логин или пароль!!!", "ИНЖПРОМТОРГ", MessageBoxButton.OK,
MessageBoxImage.Warning);
tbPassword.Password = "";
}
}
}
catch
{
MessageBox.Show("Не правильно введен логин или пароль!!!", "ИНЖПРОМТОРГ", MessageBoxButton.OK,
MessageBoxImage.Warning);
tbPassword.Password = "";
}
}
/// <summary>
/// Вызов перегрузки класса с функциями Microsoft SQL Server
/// для функций которые имеют в себе формальные параметры
/// </summary>
/// <param name="Function_name">Название функции</param>
/// <param name="type_function">Тип функции:
/// table или scalar</param>
/// <param name="parametrs">Не типизированный список
/// передаваемых параметров</param>
public Function_Class(string Function_name, string type_function,
ArrayList parametrs)
{
//Объявление строковой переменной для формирования запроса
string query = "";
try
{
//Проверка на тип функции
switch (type_function)
{
case "scalar":
//Формирование первой части скалярного запроса
query = string.Format(@"select [dbo].[{0}](",
Function_name);
break;
case "table":
//Формирование первой части табличного запроса
query = string.Format(@"select * from [dbo].[{0}](",
Function_name);
break;
}
//Строковая переменная колекции параметров
//Вторая часть любого запроса
string list_param = "";
//Условие на проверку количества параметров
switch (parametrs.Count)
{
case 1:
//В случае если параметр один запрос завершается
list_param += parametrs[0].ToString() + ")";
break;
default:
//Перебор всех параметров из коллекции ArrayList
foreach (object param in parametrs)
{
//Присвоение в строковую переменную
//полученный список параметров из перегрузки
list_param += param + ",";
}
//Удаление из получееной строки поледней запятой
list_param =
list_param.Remove(list_param.Length - 1, 1);
//Закрывающая скобка запрпоса обращения
//к функции
list_param += ")";
break;
}
//Конкатенирование первой и второй части запроса
query += list_param;
//Занесение запроса в класс Table_Data
Table_Class table = new Table_Class(query);
//Присвоение результирующей таблицы в выходную таблицу
Restable = table.table;
}
catch
{
}
}
