Interface IReportRuntime

Runtime for the payrun function ReportStartFunction

Inherited Members

IRuntime.GetTenantAttribute(string)

IRuntime.GetUserAttribute(string)

IRuntime.GetDerivedCulture(int, int)

IRuntime.GetDerivedCalendar(int, int)

IRuntime.GetCalendarDayCount(string, DateTime, DateTime, string)

IRuntime.IsCalendarWorkDay(string, DateTime)

IRuntime.GetPreviousWorkDays(string, DateTime)

IRuntime.GetNextWorkDays(string, DateTime)

IRuntime.GetCalendarPeriod(string, DateTime, int, string)

IRuntime.AddLog(int, string, string, string)

IRuntime.AddTask(string, string, DateTime, string, Dictionary<string, object>)

IRuntime.InvokeWebhook(string, string)

IRuntime.TenantId

IRuntime.TenantIdentifier

IRuntime.UserId

IRuntime.UserIdentifier

IRuntime.UserCulture

IRuntime.UserType

Namespace: PayrollEngine.Client.Scripting.Runtime

Assembly: PayrollEngine.Client.Scripting.dll

Syntax

public interface IReportRuntime : IRuntime

Properties

ReportName

Gets the report name

Declaration

string ReportName { get; }

Property Value

Type	Description
string

Methods

AddReportLog(string, string, DateTime?)

Add report log

Declaration

void AddReportLog(string message, string key = null, DateTime? reportDate = null)

Parameters

Type	Name	Description
string	message	The log message
string	key	The log key
DateTime?	reportDate	The report date (default: now)

ExecuteCollectorCustomResultQuery(string, int, int, Tuple<int?, string, string, string, long?, long?>)

Execute a collector custom result query on the Api web method

Declaration

DataTable ExecuteCollectorCustomResultQuery(string tableName, int payrollResultId, int collectorResultId, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
int	payrollResultId	The payroll result id
int	collectorResultId	The collector result id
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteCollectorResultQuery(string, int, Tuple<int?, string, string, string, long?, long?>)

Execute a collector result query on the Api web method

Declaration

DataTable ExecuteCollectorResultQuery(string tableName, int payrollResultId, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
int	payrollResultId	The payroll result id
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteCompanyCaseValueQuery(string, Tuple<int?, string, string, string, long?, long?>)

Execute company case value query on the Api web method

Declaration

DataTable ExecuteCompanyCaseValueQuery(string tableName, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteConsolidatedQuery(string, string, string, string, Dictionary<string, string>)

Executes a query across all provider tenants that have granted Consolidation permission to the current tenant via regulation sharing. For each share, the query is executed with the provider tenant's id and the results are merged into a single table. Use this in ReportEndFunction scripts to aggregate cross-tenant payroll results. Example: collecting COM-normalized results from NL and BE tenants into one table.

Declaration

DataTable ExecuteConsolidatedQuery(string tableName, string methodName, string culture, string mergeColumn, Dictionary<string, string> parameters)

Parameters

Type	Name	Description
string	tableName	Target table name for the merged result
string	methodName	The API query method name (e.g. QueryPayrollResultValues)
string	culture	The content culture
string	mergeColumn	Column used as primary key for merging — must be unique across all tenants
Dictionary<string, string>	parameters	Base query parameters; TenantId is overridden per share iteration

Returns

Type	Description
DataTable	Merged data table containing rows from all provider tenants, empty table when no shares exist

ExecuteEmployeeCaseValueQuery(string, int, Tuple<int?, string, string, string, long?, long?>)

Execute employee case value query on the Api web method

Declaration

DataTable ExecuteEmployeeCaseValueQuery(string tableName, int employeeId, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
int	employeeId	The employee id
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteGlobalCaseValueQuery(string, Tuple<int?, string, string, string, long?, long?>)

Execute global case value query on the Api web method

Declaration

DataTable ExecuteGlobalCaseValueQuery(string tableName, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteLookupValueQuery(int, string, string, string)

Query Json lookup values by lookup name

Declaration

Dictionary<string, string> ExecuteLookupValueQuery(int regulationId, string lookupName, string keyAttribute, string valueAttribute)

Parameters

Type	Name	Description
int	regulationId	The regulation id
string	lookupName	The lookup name
string	keyAttribute	The json object key attribute name
string	valueAttribute	The json object value attribute name

Returns

Type	Description
Dictionary<string, string>	The lookup values dictionary

ExecuteNationalCaseValueQuery(string, Tuple<int?, string, string, string, long?, long?>)

Execute national case value query on the Api web method

Declaration

DataTable ExecuteNationalCaseValueQuery(string tableName, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecutePayrollResultQuery(string, Tuple<int?, string, string, string, long?, long?>)

Execute a payroll result query on the Api web method

Declaration

DataTable ExecutePayrollResultQuery(string tableName, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecutePayrunResultQuery(string, int, Tuple<int?, string, string, string, long?, long?>)

Execute a payrun result query on the Api web method

Declaration

DataTable ExecutePayrunResultQuery(string tableName, int payrollResultId, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
int	payrollResultId	The payroll result id
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteQuery(string, string, string, Dictionary<string, string>)

Execute a query on the Api web method

Declaration

DataTable ExecuteQuery(string tableName, string methodName, string culture, Dictionary<string, string> parameters)

Parameters

Type	Name	Description
string	tableName	Target table name
string	methodName	The query name
string	culture	The content culture
Dictionary<string, string>	parameters	The method parameters

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteWageTypeCustomResultQuery(string, int, int, Tuple<int?, string, string, string, long?, long?>)

Execute a wage type custom result query on the Api web method

Declaration

DataTable ExecuteWageTypeCustomResultQuery(string tableName, int payrollResultId, int wageTypeResultId, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
int	payrollResultId	The payroll result id
int	wageTypeResultId	The wage type result id
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteWageTypeQuery(string, int, Tuple<int?, string, string, string, long?, long?>)

Execute a wage type query on the Api web method

Declaration

DataTable ExecuteWageTypeQuery(string tableName, int regulationId, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
int	regulationId	The regulation id
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

ExecuteWageTypeResultQuery(string, int, Tuple<int?, string, string, string, long?, long?>)

Execute a wage type result query on the Api web method

Declaration

DataTable ExecuteWageTypeResultQuery(string tableName, int payrollResultId, Tuple<int?, string, string, string, long?, long?> queryValues)

Parameters

Type	Name	Description
string	tableName	Target table name
int	payrollResultId	The payroll result id
Tuple<int?, string, string, string, long?, long?>	queryValues	The query

Returns

Type	Description
DataTable	Resulting data table, existing will be removed

GetParameter(string)

Get report parameter

Declaration

string GetParameter(string parameterName)

Parameters

Type	Name	Description
string	parameterName	The parameter name

Returns

Type	Description
string	The report parameter value as JSON

GetParameterAttribute(string, string)

Get report parameter attribute value

Declaration

object GetParameterAttribute(string parameterName, string attributeName)

Parameters

Type	Name	Description
string	parameterName	The parameter name
string	attributeName	Name of the attribute

Returns

Type	Description
object	The report attribute value

GetReportAttribute(string)

Get report attribute value

Declaration

object GetReportAttribute(string attributeName)

Parameters

Type	Name	Description
string	attributeName	Name of the attribute

Returns

Type	Description
object	The report attribute value

HasParameter(string)

Check for existing report parameter

Declaration

bool HasParameter(string parameterName)

Parameters

Type	Name	Description
string	parameterName	The parameter name

Returns

Type	Description
bool

ParameterHidden(string)

Test for hidden report parameter

Declaration

bool ParameterHidden(string parameterName)

Parameters

Type	Name	Description
string	parameterName	The parameter name

Returns

Type	Description
bool	True for hidden report attribute

SetParameterAttribute(string, string, object)

Set report attribute value

Declaration

void SetParameterAttribute(string parameterName, string attributeName, object value)

Parameters

Type	Name	Description
string	parameterName	The parameter name
string	attributeName	Name of the attribute
object	value	The attribute value

SetReportAttribute(string, object)

Set report attribute value

Declaration

void SetReportAttribute(string attributeName, object value)

Parameters

Type	Name	Description
string	attributeName	Name of the attribute
object	value	Attribute value

Extension Methods

ConsoleExtensions.WriteProperties(object, bool)

ValueTypeExtensions.GetValueType(object)

ObjectInfo.GetPropertyValue(object, string)

ObjectInfo.GetPropertyValue<T>(object, string, T)

ObjectInfo.ResolvePropertyValue(object, string)

ObjectInfo.SetPropertyValue(object, string, object)