private void Button_Click_1(object sender, RoutedEventArgs e)
{
string[] text_Box_input = new string[] { ID_EMP.Text.Split()[0], Nam.Text, Capac.Text, Descr.Text, Cost.Text };
string sql = "INSERT INTO dbo.Rooms (";
Query_input Query = new Query_input();
Query.sql_build_input(sql, query_input_name, text_Box_input);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
string[] text_Box_input = new string[] { ID_Cli.Text.Split()[0], ID_Ser.Text.Split()[0], Cos.Text };
string sql = "INSERT INTO dbo.[Services provided to the client] (";
Query_input Query = new Query_input();
Query.sql_build_input(sql, query_input_name, text_Box_input);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
string[] text_Box_input = new string[] { Nam.Text, Desc.Text, Cos.Text };
string sql = "INSERT INTO dbo.Services (";
Query_input Query = new Query_input();
Query.sql_build_input(sql, query_input_name, text_Box_input);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
string[] text_Box_input = new string[] { Job.Text, Dut.Text, Requie.Text, Salary.Text };
string sql = "INSERT INTO dbo.Positionen (";
Query_input Query = new Query_input();
Query.sql_build_input(sql, query_input_name, text_Box_input);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
string[] text_Box_input = new string[] { help.Text.Split()[0], ID_NUM.Text.Split()[0], Family.Text, Imia.Text, Othestvo.Text, Registered.Text, Ceria.Text, ID_P.Text,
Podrazdelenia.Text, Date.Text, Is_Date.Text, Date_Vi.Text, Data_Za.Text };
string sql = "INSERT INTO dbo.Clients (";
Query_input Query = new Query_input();
Query.sql_build_input(sql, query_input_name, text_Box_input);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
string[] text_Box_input = new string[] { help.Text.Split()[0], Familya.Text, Imia.Text, Otchestvo.Text, Let.Text, Pol.Text, Registered.Text,
Actual.Text, Ceria.Text, ID.Text, Podrazdelenia.Text, Date.Text, Vidol.Text, Telephone.Text };
string sql = "INSERT INTO dbo.Staff (";
Query_input Query = new Query_input();
Query.sql_build_input(sql, query_input_name, text_Box_input);
}