SurveyController Class

Connection string for the database. Can be null.

DbCommandTimeout is applied to SqlCommand objects created using CreateSqlCommand(). The DbCommandTimeout value is (normally) passed on to other controllers created by the controller. If DbCommandTimeout is Zero then the DB default will be used as timeout.

Consider using CreateCommand() instead of accessing DbConnection directly. DbConnection and DbTransaction are either specified when constucting the controller or the controller constructs them itself (by using ConnectionString) when calling DoInConnection or DoInTransaction. If the caller specified DbConnection and DbTransaction when constucting the controller then the caller is responsible for the management of the connection.

Consider using CreateCommand() instead of accessing DbTransaction directly. DbConnection and DbTransaction are either specified when constucting the controller or the controller constructs them itself (by using ConnectionString) when calling DoInConnection or DoInTransaction. If the caller specified DbConnection and DbTransaction when constucting the controller then the caller is responsible for the management of the connection.

Factory class for creating controller instances.

Builds a cache key for use with GetFromCacheIfPresent. The cache key is not hashed because we have experienced a collision using GetHashCode() ie. the cache keys are quite long and there is a price in dictionary size in memory and in dictionary lookups.

Checks that the active user is allowed to perform an CRUD operation on a specific configuration object. (note: except that a Create operation is not for a specific object). Throws a SecurityException if not. Method can be used for all configuration objects that are represented by a ConfigurationObjectType (except those that have a compound key). Method checks auth role security as well as whether it is allowed to modify builtin/feature package objects.

Checks that the active user is allowed to Create a new - or Update an existing configuration object. Throws a SecurityException if not. Method can be used for all configuration objects that are represented by a ConfigurationObjectType (except those that have a compound key). Method checks auth role security as well as whether it is allowed to modify builtin/feature package objects.

Sets the survey status to "completed" and terminates the survey process.

Converts the integer id of an object to its transport-safe unique id (UId).

Converts a string representation of an integer or Guid id to an integer id.

Converts the transport-safe unique id (UId) of an object to its integer id.

Converts the transport-safe unique ids (UId) of a number of objects to integer ids.

Converts the integer ids of a number of objects to their transport-safe unique ids (UId).

Converts a list of scope variable values for the survey to a dictionary accepted by the QueryParameterHelper

Create a new SqlBulkCopy instance using the connection, transaction and timeout values from the controller

Executes an action that doesn't return a result. If no current connection exists, it will establish a connection to the database and close it afterwards. An existing connection will be reused. Inside the action, the connection is available as DbConnection.

Executes an action that doesn't return a result. If no current connection exists, it will establish a connection to the database and close it afterwards. Connection and Transaction are passed to delegate, to allow passing to other controllers An existing connection will be reused. Inside the action, the connection is available as DbConnection. To ensure a new connection set forceNew to true.

Executes an action and returns the result. If no current connection exists, it will establish a connection to the database and close it afterwards. An existing connection will be reused. Inside the action, the connection is available as DbConnection.

Executes an action (that doesn't return a result) in a transaction. If no current connection and/or transaction exists, it will establish it and commit and close it afterwards. An existing connection/transaction will be reused. Inside the action, the connection is available as DbConnection and the transaction as DbTransaction.

Executes an action in a transaction and returns the result. If no current connection and/or transaction exists, it will establish it and commit and close it afterwards. An existing connection/transaction will be reused. Inside the action, the connection is available as DbConnection and the transaction as DbTransaction.

Executes an action in a transaction and returns the result. Connection and Transaction are passed to delegate, to allow passing to other controllers If no current connection and/or transaction exists, it will establish it and commit and close it afterwards. An existing connection/transaction will be reused. Set forceNew to true to ensure new connection and transaction Inside the action, the connection is available as DbConnection and the transaction as DbTransaction.

The method can postpone a SQL transaction implemented by action if the method returns a default number, eg. 0. If the the action method throws a SQL transitent error, then the next call to action is also postponed.

The method can postpone a method invocation if the previous call returned a default number, eg. 0.

Executes a query with a scalar result.

Process survey objects that are created with the Generate in background flag. Generates the survey data and sends a notification to the user once it is completed.

(Inherited from ControllerBase.)

Retrieves some data from the cache or (if it is not there) executes an action and stores the result in the cache. Caching is not applied if the IgnoreCacheContext is used (depending on the parameter for it). Note: caching should only be used with great care as there are a number of potential issues involved in using it!

Returns the newest SurveyId for a from the provided object key

Gets the data version of an object.

Returns a dictionary with "scope variables" (that is, values for the scope variables) that the user has entered in the survey initiation form. The scope variables are stored in an xml format in the SURV_SCOPEVARS property on the survey object type.

Returns a dictionary with "survey settings" (that is, values for the survey settings) that the user has entered in the survey initiation form. The settings variables are stored in an xml format in the SURV_SETTINGS property on the survey object type.

Retrieves the "keys" of a number of survey objects

Gets all log entries for a number of survey objects.

Returns survey objects loaded based on provided params

Get the total number of survey objects for a user with filters applied

Returns the survey template stored (as xml) on a survey process instance target object.

(Inherited from ControllerBase.)

Increments the data version of an entity object. The data version is incremented in the db as well as on the object itself. Method is used to update the data version of an object when an aggregated object is created/modified/deleted. The purpose is to ensure that the id-based cache (in AppIdentity) is updated properly.

Increments the data version of an entity object in the db. Method is used to update the data version of an object when an aggregated object is created/modified/deleted. The purpose is to ensure that the id-based cache (in AppIdentity) is updated properly.

Generates survey object data (in tblSurveyObject) for a newly created survey data object.

Check whether the user is contained directly in the Survey admin property of the survey or in a referred user group

Perform post-routing actions when questions has been reassigned.

Creates a temporary db table with a single column and populates it with values.

If the action throws a transient sql error, the exception is eaten. An entry is written to the log with level Information. The entire exception is written to the log with level Debug.

Reassigns a number of survey objects to a set of users. All existing assignees are cleared.

(Re)assigns the activity that represents a workflow step to everyone who is assigned to one or more questions that are active in the workflow step.

Recalculates the assignees of all non-completed objects in a survey and reassigns the survey activities (if needed). Called from a CM that is executed by a timer.

Converts/transfers one or more specified uids in a loadoptions object to ids. The purpose is to enable caching as IEntityObjectsLoadOptions.IdList only works with ids (and not uids).

Called by the ws that is called from the browser when the user clicks "save". Also called when auto-completion is performed by a post-action handler. Validates that: - the active user is assigned to the specified survey objects. - the survey objects aren't marked as 'completed'.

Validates that the data version of an object corresponds to the data version in the DB. Method is used for validation before saving an object.

Gets survey object by key.

Converts object to boolean.

Converts object to DateTime.

Converts object to integer.