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