private void Button_Click_3(object sender, RoutedEventArgs e)
{
string sql = "UPDATE dbo.Rooms SET ";
string text_ID = " WHERE ID_Numbers = ";
CheckBox[] array_check = new CheckBox[] { Check_ID_Emplo, Check_Name, Check_Capaci, Check_Descript, Check_Costs };
Query_input Query = new Query_input();
Query.sql_build_Change(sql, Staff_ID, text_ID, array_check, t_box_name, query_input_name, Grid_Change);
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
string sql = "UPDATE dbo.Positionen SET ";
string text_ID = " WHERE ID_Position = ";
CheckBox[] array_check = new CheckBox[] { Check_JOBS, Check_Duts, Check_Reque, Check_Sali };
Query_input Query = new Query_input();
Query.sql_build_Change(sql, Positionen_ID, text_ID, array_check, t_box_name, query_input_name, Grid_Change);
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
string sql = "UPDATE dbo.Clients SET ";
string text_ID = " WHERE ID_Client = ";
CheckBox[] array_check = new CheckBox[] { Check_ID_Sotr, Check_Numb, Check_Part, Check_Name, Check_Otchestvo, Check_Adress, Check_Ceri, Check_ID_PASS,
Check_Pod, Check_Date_of_issue, Check_Date_of_issue, Check_Date_vie, Check_Date_zas };
Query_input Query = new Query_input();
Query.sql_build_Change(sql, Client_ID, text_ID, array_check, t_box_name, query_input_name, Grid_Change);
}
private void Button_Click_4(object sender, RoutedEventArgs e)
{
string sql = "UPDATE dbo.Staff SET ";
string text_ID = " WHERE ID_Employee = ";
CheckBox[] array_check = new CheckBox[] { Check_ID_JOB, Check_Family, Check_Name, Check_Otchestvo, Check_Age, Check_SEX, Check_Adress, Check_Adress_Act, Check_Seria,
Check_ID_PASS, Check_Pod, Check_Date_of_issue, Check_Issued_by, Check_Phone };
Query_input Query = new Query_input();
Query.sql_build_Change(sql, Staff_ID, text_ID, array_check, t_box_name, query_input_name, Grid_Change);
}
