private void Get_Documents_inf_Load(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_info_all);
bs_login.DataSource = dt;
bs_KL.DataSource = dt2;
dt = DB.LoadTable("SELECT Т_Клиент.ID_Клиента as aa, Т_Клиент.ФИО as bb FROM Т_Клиент", "Т_Клиент");
dt2 = DB.LoadTable($"SELECT * FROM Т_Клиент WHERE ФИО = {comboBox_Klient.Text}", "Т_Клиент");
QuicklyChangeDB.ComboSettings(dt, "ФИО", "ID_Клиента", comboBox_Klient);
}
private void Search_Adm_Load(object sender, EventArgs e)
{
bindingNavigator1.Visible = false;
//Запрос для вытягивания списка таблиц
dtQuery = DB.LoadTable($"select TABLE_NAME from INFORMATION_SCHEMA.TABLES", "Load_all_tables");
//Заполнение combobox списком таблиц
QuicklyChangeDB.ComboSettings(dtQuery, "TABLE_NAME", "TABLE_NAME", combo_objectSearch);
}
private void Inform_Load(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_KL_DOG);
grid_KL_DOG.Visible = false;
QuicklyChangeDB.TextBox(bs_Client, "ФИО", text_fio);
QuicklyChangeDB.TextBox(bs_Client, "Адрес", text_adres);
QuicklyChangeDB.TextBox(bs_Client, "Реквизиты банка", text_rec);
QuicklyChangeDB.TextBox(bs_Client, "ID_Клиента", textBox_KL);
QuicklyChangeDB.Picturebox("Image", pic_client, bs_Client, "Фото", true);
}
private void button2_Click(object sender, EventArgs e)
{
if (grid_curator.Columns.Contains("Information"))
{
grid_curator.Columns.Remove("Information");
}
//For Tables T_Position
bs_Dol.DataSource = DB.ds.Tables["Т_Должность"];
grid_curator.DataSource = bs_Dol;
//GridViewStyles.GridClear(grid_for_all);
bindingNavigator1.BindingSource = bs_Dol;
QuicklyChangeDB.GridVisible(new string[] { "ID_Должности" }, grid_curator);
}
private void button_see_client_Click_1(object sender, EventArgs e)
{
if (grid_curator.Columns.Contains("Del"))
{
grid_curator.Columns.Remove("Del");
}
//For Tables T_Client
DataTable dt = DB.ds.Tables["Т_Клиент"];
bs_Client.DataSource = DB.ds.Tables["Т_Клиент"];
grid_curator.DataSource = bs_Client;
bindingNavigator1.BindingSource = bs_Client;
QuicklyChangeDB.GridVisible(new string[] { "Фото", "ID_Клиента" }, grid_curator);
}
private void button_client_Click(object sender, EventArgs e)
{
GridViewStyles.ButtonGrid("Information", "Inf", "Подробнее", grid_for_all, inf);
GridViewStyles.ButtonGrid("Del", "Delite", "Удалить", grid_for_all, inf);
//For Tables T_Client
DataTable dt = DB.ds.Tables["Т_Клиент"];
bs_Client.DataSource = DB.ds.Tables["Т_Клиент"];
grid_for_all.DataSource = bs_Client;
bindingNavigator1.BindingSource = bs_Client;
QuicklyChangeDB.GridVisible(new string [] { "Фото", "ID_Клиента" }, grid_for_all);
}
private void button3_Click(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_for_all);
if (grid_for_all.Columns.Contains("Information") && grid_for_all.Columns.Contains("Del") && grid_for_all.Columns.Contains("ChangeContext"))
{
grid_for_all.Columns.Remove("Information");
grid_for_all.Columns.Remove("Del");
grid_for_all.Columns.Remove("ChangeContext");
}
grid_for_all.DataSource = bs_curator;
bindingNavigator1.BindingSource = bs_curator;
QuicklyChangeDB.GridVisible(new string[] { "ID_Куратора", "Должность" }, grid_for_all);
}
private void button4_Click(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_curator);
if (grid_curator.Columns.Contains("Information") && grid_curator.Columns.Contains("Del") && grid_curator.Columns.Contains("ChangeContext"))
{
grid_curator.Columns.Remove("Information");
grid_curator.Columns.Remove("Del");
grid_curator.Columns.Remove("ChangeContext");
}
//For Tables Т_Языки_прог
grid_curator.DataSource = bs_language;
//GridViewStyles.GridClear(grid_for_all);
bindingNavigator1.BindingSource = bs_language;
QuicklyChangeDB.GridVisible(new string[] { "КодЯзыка" }, grid_curator);
}
private void button_Dol_Click(object sender, EventArgs e)
{
GridViewStyles.ButtonGrid("ChangeContext", "Изменить", "Изменить", grid_for_all, izm);
if (grid_for_all.Columns.Contains("Information") && grid_for_all.Columns.Contains("Del"))
{
grid_for_all.Columns.Remove("Information");
grid_for_all.Columns.Remove("Del");
}
//For Tables T_Position
bs_Dol.DataSource = DB.ds.Tables["Т_Должность"];
grid_for_all.DataSource = bs_Dol;
bindingNavigator1.BindingSource = bs_Dol;
QuicklyChangeDB.GridVisible(new string[] { "ID_Должности" }, grid_for_all);
}
private void Form1_Load(object sender, EventArgs e)
{
//* in password
text_password.UseSystemPasswordChar = true;
ToolTip tip = new ToolTip();
tip.Active.ToString();
tip.BackColor = System.Drawing.Color.BlueViolet;
tip.SetToolTip(text_password, "Обязательное поле для ввода!");
BindingSource bs_login = new BindingSource();
dt = DB.LoadTable("SELECT * FROM Login", "Login");
bs_login.DataSource = dt;
QuicklyChangeDB.ComboSettings(dt, "Access_rights", "ID_rights", combo_login);
}
private void Add_Dogovora_Load(object sender, EventArgs e)
{
BindingSource bs_language = new BindingSource();
BindingSource bs_curator = new BindingSource();
BindingSource bs_sotr = new BindingSource();
bs_language.DataSource = dt_lang;
bs_curator.DataSource = dt_curator;
bs_sotr.DataSource = dt_sotr;
dt_lang = DB.LoadTable("SELECT Т_Языки_прог.КодЯзыка as aa, Т_Языки_прог.Язык as bb FROM Т_Языки_прог", "Т_Языки_прог");
dt_curator = DB.LoadTable("SELECT Т_Кураторы.ID_Куратора as aa, Т_Кураторы.ФИО as bb FROM Т_Кураторы", "Т_Кураторы");
dt_sotr = DB.LoadTable("SELECT Т_Штат_сотрудников.ID_сотрудника as aa, Т_Штат_сотрудников.ФИО as bb FROM Т_Штат_сотрудников", "Т_Штат_сотрудников");
QuicklyChangeDB.ComboSettings(dt_lang, "Язык", "КодЯзыка", comboBox_language_dog);
QuicklyChangeDB.ComboSettings(dt_curator, "ФИО", "ID_Куратора", combo_Curator);
QuicklyChangeDB.ComboSettings(dt_sotr, "ФИО", "ID_сотрудника", comboBox_sotryd_dog);
}
private void button1_Click(object sender, EventArgs e)
{
using (myCreatePO_projectEntities context = new myCreatePO_projectEntities())
{
var x = from z in context.Т_ВидыРабот
select z.Нормо_часов;
}
if (grid_curator.Columns.Contains("Information") && grid_curator.Columns.Contains("Del") && grid_curator.Columns.Contains("ChangeContext"))
{
grid_curator.Columns.Remove("Information");
grid_curator.Columns.Remove("Del");
grid_curator.Columns.Remove("ChangeContext");
}
//For Tables Т_Договора Архив
bs_work.DataSource = DB.ds.Tables["Т_ВидыРабот"];
grid_curator.DataSource = bs_work;
bindingNavigator1.BindingSource = bs_work;
QuicklyChangeDB.GridVisible(new string[] { "ID_Работы", "Сумма_руб" }, grid_curator);
}
private void Add_Dogovora_EditStep_Load(object sender, EventArgs e)
{
QuicklyChangeDB.TextBox(bs_Dog, "Название_договора", textBox_Dog);
}
private void test_insert_position_Load(object sender, EventArgs e)
{
QuicklyChangeDB.TextBox(bs_position, "Должность", text_insert_posisiton);
}
