MasterController Methods

Updates the database schema for all the registered customer databases.

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).

Performs a check in the application version versus the database version. Throws an exception in case of a mismatch.

Updates the database schema for the provided customer database.

Deletes old items in tblActLog.

Deletes old items in tblActLog.

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.

Returns the customer with the provided id. Can return null.

Returns the customer with the specified name or alias.

Returns the customer id from tblCustomer based on the name. Aliases in tblCustomerAuth.Alias is also searched.

Returns the customer name from tblCustomer in the master database.

Returns all the customers in the master database. Cached for 2 minutes

Returns a data reader with database file info

Multiple customers can be configured with the same database connection, for instance when setting up an external federated sign on in combination with an internal AD SSO. Some timer services should not service both customer entries so this method returns one customer object per distinct database connection

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!

The method retrieves the last logon time for users. Deleted users are shown. Inactive users are shown.

Returns a collection of all the master settings in tblMasterSetting in the master database

Returns the (singular) customer from tblCustomer. If tblCustomer contains more or less than 1 row an exception is thrown.

This method is fired up every now and then by the timer service. The implementation must be kept fast and without interfearing with the portal end user experience

This function is called as the first database function in a page view. It helps to clear invalid connections in the ADO.NET connection pool

Saves a ActivityLog into tblActLog.

Saves a single master setting to the database

Updates the Xml Schema dataobjects based on the xsd files on the disk.

Converts object to boolean.

Converts object to DateTime.

Converts object to integer.