public void sql_build_Change(string sql, TextBox ID, string text_ID, CheckBox [] array_check, string[] t_box_name, string[] query_input_name, Grid Grid_Change)
{
for (int i = 0; i < array_check.Length; i++)
{
if (array_check[i].IsChecked == true)
{
TextBox text_Box = (TextBox)Grid_Change.FindName(t_box_name[i]);
if (text_Box == null)
{
MessageBox.Show("Поле не были созданы и не были заполнены", "Уведомление");
break;
}
if (text_Box.Text.Trim() == string.Empty)
{
MessageBox.Show("Поле было пустое", "Уведомление");
}
else
{
sql += query_input_name[i] + "=" + string.Format("\'{0}\'", text_Box.Text) + ",";
}
}
}
if (sql.EndsWith(","))
{
sql = sql.Remove(sql.Length - 1);
}
sql += text_ID + ID.Text + ";";
Query_input Query = new Query_input();
Query.input(sql);
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
string sql = "UPDATE dbo.[Services provided to the client] SET ";
string text_ID = " WHERE ID_Client = ";
CheckBox[] array_check = new CheckBox[] { Check_ID_Cliet, Check_ID_Serv, Check_Costs };
for (int i = 0; i < array_check.Length; i++)
{
if (array_check[i].IsChecked == true)
{
TextBox text_Box = (TextBox)Grid_Change.FindName(t_box_name[i]);
if (text_Box == null)
{
MessageBox.Show("Поле не были созданы и не были заполнены", "Уведомление");
break;
}
if (text_Box.Text.Trim() == string.Empty)
{
}
else
{
sql += query_input_name[i] + "=" + string.Format("\'{0}\'", text_Box.Text) + ",";
}
}
}
if (sql.EndsWith(","))
{
sql = sql.Remove(sql.Length - 1);
}
sql += text_ID + Services_ID.Text + " and ";
sql += "ID_Services = " + Client_ID.Text + ";";
Query_input Query = new Query_input();
Query.input(sql);
}
public void sql_build_input(string sql, string [] query_input_name, string[] text_Box_input)
{
Query_input Query = new Query_input();
for (int i = 0; i < query_input_name.Length; i++)
{
sql += query_input_name[i] + ",";
}
if (sql.EndsWith(","))
{
sql = sql.Remove(sql.Length - 1);
}
sql += ") values (";
for (int i = 0; i < text_Box_input.Length; i++)
{
if (text_Box_input[i].Trim() == string.Empty)
{
}
else
{
sql += string.Format("\'{0}\'", text_Box_input[i]) + ",";
}
}
if (sql.EndsWith(","))
{
sql = sql.Remove(sql.Length - 1);
}
sql += ")";
Query.input(sql);
}
public void delete(string sql, TextBox Delet, string db)
{
if (Delet.Text.Trim() == string.Empty)
{
MessageBox.Show("Поле удаление пустое", "Уведомление");
}
else
{
Query_input Query = new Query_input();
Query.input(sql);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
string sql_query = SQL.Text;
string db = "";
string dbo = "";
string[] exp = sql_query.ToLower().Split(' ');
string[] array_db = new string[] { "Staff", "Positionen", "Client", "Rooms", "Services", "Services provided to the client",
"staff", "positionen", "client", "rooms", "services", "services provided to the client" };
string[] array_dbo = new string[] { "dbo.[Staff]", "dbo.[Positionen]", "dbo.[Client]", "dbo.[Rooms]", "dbo.[Services]", "dbo.[Services provided to the client]",
"dbo.[staff]", "dbo.[positionen]", "dbo.[client]", "dbo.[rooms]", "dbo.[services]", "dbo.[services provided to the client]" };
for (int i = 0; i < array_db.Length; i++)
{
if (sql_query.Contains(array_db[i]))
{
db += array_db[i];
}
if (sql_query.Contains(array_dbo[i]))
{
dbo += array_db[i];
}
}
foreach (string i in exp)
{
if (i == "GRANT SELECT")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
if (i == "select")
{
sql_query = SQL.Text;
Query_output Query = new Query_output();
Query.Output(sql_query, db, table);
break;
}
if (i == "select*from")
{
sql_query = SQL.Text;
Query_output Query = new Query_output();
Query.Output(sql_query, db, table);
break;
}
if (i == "alter")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
if (i == "insert")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
if (i == "drop")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
if (i == "update")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
if (i == "delete")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
if (i == "exec")
{
sql_query = SQL.Text;
Query_output Query = new Query_output();
Query.Output(sql_query, db, table);
break;
}
if (i == "create")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
if (i == "execute")
{
sql_query = SQL.Text;
Query_input Query = new Query_input();
Query.input(sql_query);
break;
}
else
{
MessageBox.Show("Запрос задан не верно или данная команда не используется в интерфейсе", "Уведомление");
break;
}
}
}