Task |
Helper class to load tables from Excel, CSV or external data sources and to execute SQL statements, used from Razor scripts of report tasks
Inheritance HierarchyNamespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 10.0.1.0+a44cd3a7f03c2bf3cdbd971a878c679e40bed08a
SyntaxC#
public class TaskHelper
The TaskHelper type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | TaskHelper | Constructor from a report task |
Properties| Name | Description | |
|---|---|---|
 | DatabaseHelper | TaskDatabaseHelper of the task, initialized with the default configuration of the task connection database type |
| Task | Current report task |
| TaskConnection | Connection of the current task |
Methods| Name | Description | |
|---|---|---|
| CheckForNewFileSource | Returns true if the source file is more recent than its copy in the load folder, meaning the file must be loaded again |
| CreateMSSQLIndex | Create (or re-create) an index on a MSSQL table |
| DesignMyRazorScript | Sandbox method used to code, compile and debug a task Razor script within Visual Studio |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| ExecuteMSSQLFile | Execute a .sql file |
| ExecuteMSSQLScripts | Execute .sql files located in a directory |
| ExecuteNonQuery(String, Boolean) | Execute a SQL statement on the task connection (or on all the connections of the source) |
| ExecuteNonQuery(MetaConnection, String, String) | Execute a SQL statement on a given connection. Several statements may be executed using a commands separator. |
| ExecuteProcess | Execute a process and log its output. An exception is thrown if the process writes to the standard error. |
| ExecuteScalar(String) | Execute a SQL statement on the task connection and return the first column of the first row of the result |
| ExecuteScalar(MetaConnection, String) | Execute a SQL statement on a given connection and return the first column of the first row of the result |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetDbCommand | Returns a DbCommand for the task connection |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| LoadDataTable(String) | Load a DataTable from the task connection using a SQL SELECT statement |
| LoadDataTable(MetaConnection, String) | Load a DataTable from a given connection using a SQL SELECT statement |
| LoadStringList(String) | Load a list of strings from the task connection using a SQL SELECT statement (first column of the result) |
| LoadStringList(MetaConnection, String) | Load a list of strings from a given connection using a SQL SELECT statement (first column of the result) |
| LoadTable | Load a DataTable in the database (drop, create and insert). Returns the number of rows inserted. |
| LoadTableFromCSV(String, String, NullableChar, Boolean, Boolean, Encoding) | Load a table from a CSV file into the database |
| LoadTableFromCSV(String, String, String, NullableChar, Boolean, Boolean, Encoding, Boolean) | Load a table from a CSV file into the database if the file has changed since the last load (or if forceLoad is true) |
| LoadTableFromDataSource | Load a table from a report data source into the database using a SQL SELECT statement |
| LoadTableFromExcel(String, String, String, Boolean, Int32, Int32, Int32, Int32, Boolean) | Load a table from an Excel tab into the database. If the tab name is empty or contains a wildcard, all matching tabs are loaded. Returns the number of rows inserted. |
| LoadTableFromExcel(String, String, String, String, Boolean, Int32, Int32, Int32, Int32, Boolean, Boolean) | Load a table from an Excel tab into the database. A start row, and/or column can be specified. An end column can be specified. |
| LoadTableFromExternalSource | Load a table from an external connection into the database using a SQL SELECT statement. Optional check SELECT statements may be specified to skip the load if the data are identical. |
| LoadTablesFromExcel(String, String, String, Boolean) | Load all Excel files located in a directory into tables, using the tab name as table name. |
| LoadTablesFromExcel(String, String, String, String, Boolean) | Load tables from Excel tabs (one table per tab) |
| LogMessage | Log a message in the report execution log |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| RefreshRepositoryEnums | Refresh the dynamic enumerated lists of all the repository data sources and save the sources (a source name may be specified to filter) |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
See Also