private void Adm_Load(object sender, EventArgs e)
{
buttonDog_Click(sender, e);
button_search_butn.Visible = false;
bs_login.DataSource = DB.ds.Tables["Login"];
GridViewStyles.ChancheViewGrid(grid_for_all);
#region
//using (contextstudent context = new contextstudent())
//{
// Student student = new Student
// {
// Name = "Зарина"
// };
// context.Студенты.Add(student);
// context.SaveChanges();
// grid_for_all.DataSource = context.Студенты.ToList();
//}
#endregion
bindingNavigator1.Visible = false;
//For Tables Т_Кураторы
bs_curator.DataSource = DB.ds.Tables["Т_Кураторы"];
//For Tables Т_Язык_программирования
bs_language.DataSource = DB.ds.Tables["Т_Языки_прог"];
}
private void Arch_Dogovora_Load(object sender, EventArgs e)
{
GridViewStyles.ButtonGrid("Edit", "Сдача в архив", "Корректировать", grid_Arch_Status, Archh);
GridViewStyles.ChancheViewGrid(grid_Arch_Status);
bs_dd.DataSource = DB.LoadTable($"SELECT Т_Договора.[№_Договора], Т_Договора.Название_договора, Т_Договора.[Дата составления], Т_Договора.Примечание FROM Т_Кураторы INNER JOIN Т_Договора ON Т_Кураторы.ID_Куратора = Т_Договора.Куратор_проекта", "T_Seen_Dogg");
grid_Arch_Status.DataSource = bs_dd;
}
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 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 button_Dog_Cur_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");
}
dt1 = DB.LoadTable($"SELECT Т_Договора.Название_договора, Т_Договора.[Дата составления], Т_Договора.Фактическа_Дата, Т_Договора.Штраф, Т_Договора.Примечание FROM Т_Договора", "Tип_дог");
grid_curator.DataSource = dt1;
}
private void buttonArhDog_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.Remove("Information");
grid_for_all.Columns.Remove("Del");
}
//For Tables Т_Договора Архив
bs_archDog.DataSource = DB.ds.Tables["Т_Договора Архив"];
grid_for_all.DataSource = bs_archDog;
//GridViewStyles.GridClear(grid_for_all);
bindingNavigator1.BindingSource = bs_archDog;
}
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 DateTimePicker1_ValueChanged(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_info_all);
BindingSource bs_dog = new BindingSource();
bs_dog.DataSource = dt;
dt3 = DB.LoadTable($"SELECT Т_Договора.Название_договора, Т_Договора.Дата составления, Т_Договора.Штраф, Т_Договора.Примечание FROM Т_Договора WHERE [Дата составления] = {dateTimePicker1.Value}", "Tип_дог");
grid_info_all.DataSource = dt3;
using (myCreatePO_projectEntities context = new myCreatePO_projectEntities())
{
var x = from z in context.Т_Договора
select z;
var t = from r in x
where r.Дата_составления == dateTimePicker1.Value
select r;
grid_info_all.DataSource = t.ToList();
}
}
private void Curator_Load(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_curator);
button_see_client_Click_1(sender, e);
}
private void Office_Load(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(gggg);
}
private void Language_ANL_Load(object sender, EventArgs e)
{
GridViewStyles.ChancheViewGrid(grid_analitik);
Button1_Click_1(sender, e);
}
