internal static void Execute(string tableName, string columns, string values)
{
StringBuilder query = new StringBuilder();
query.Append($"INSERT INTO {tableName} ({columns}) ");
query.Append($"VALUES({values});");
SqlCommandExecuteQuery.Execute(query.ToString());
}
internal static void Execute(string tableName, string uuid)
{
StringBuilder query = new StringBuilder();
query.Append($"DELETE FROM {tableName} ");
query.Append($"WHERE uuid = '{uuid}'");
SqlCommandExecuteQuery.Execute(query.ToString());
}
internal static void Execute(string tableName, int id, string columnsAndValues)
{
StringBuilder query = new StringBuilder();
query.Append($"UPDATE {tableName} ");
query.Append($"SET {columnsAndValues} ");
query.Append($"WHERE id={id};");
SqlCommandExecuteQuery.Execute(query.ToString());
}