[This is preliminary documentation and is subject to change.]

The CommonDB type exposes the following members.

Constructors

  NameDescription
Public methodCommonDB

Methods

  NameDescription
Public methodAddOutputParameterOverloaded.
Public methodAddParameterOverloaded.
Protected methodAddParametersOverloaded.
Public methodArchiveItem
Archives either a particular timesheet or an expense based on the application id provided.
Public methodClearParameters
Clear all the sql stored procedure parameters
(Inherited from OfficeClipDB.)
Public methodClose
Close the connection, data adapter and the command
(Inherited from OfficeClipDB.)
Public methodCommit
Commits the transaction
(Inherited from OfficeClipDB.)
Public methodDeletePayrollCategory
Deletes the payroll category
Public methodDeleteTeRates
Delete the rate
Public methodDispose
disposes the object for garbage collection
(Inherited from OfficeClipDB.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodExecuteNonQueryOverloaded.
Protected methodExecuteReader
Executes the sql datareader
(Inherited from OfficeClipDB.)
Protected methodExecuteScalar
Executes the query that returns a single valur
(Inherited from OfficeClipDB.)
Protected methodFill
Fills the dataset
(Inherited from OfficeClipDB.)
Protected methodFinalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetDCAAHistory
Gets the DCAA history
Public methodGetHashCode
Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table.
(Inherited from Object.)
Public methodGetInBoxOutBoxList
Gets all the inbox and outbox items for both the time and expenses.
Public methodGetParameterCount
Gets the parameter count
(Inherited from OfficeClipDB.)
Public methodGetParameterValue
Gets the value of the parameter
(Inherited from OfficeClipDB.)
Public methodGetPayrollList
Gets the payroll list
Public methodGetPayrollOverheads
Returns the payroll overheads
Public methodGetTERates
Gets the rates for all the user in the group
Public methodGetTEReadonly
Gets the Timesheet/Expense Readonly status
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodInit
Initialize the connection parameters
(Inherited from OfficeClipDB.)
Public methodInitTransactionOverloaded.
Public methodInsertPayrollCategory
Inserts a new payroll category for a group
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodRollback
Rolls back the transaction
(Inherited from OfficeClipDB.)
Public methodSetParameterValue
Sets the parameter value of the sql parameter to a known value
(Inherited from OfficeClipDB.)
Protected methodSetSPCommandOverloaded.
Protected methodSetSPDataAdapter
Sets the stored procedure data adapter
(Inherited from OfficeClipDB.)
Public methodToString
Returns a String that represents the current Object.
(Inherited from Object.)
Public methodUpdatePayrollCategory
Updates a payroll category
Public methodUpdateTeRates
Updates the billing rates
Public methodUpdTePayrollOverheadsOverloaded.

Properties

  NameDescription
Public propertyConnectionString
Gets the OfficeClip.DBLayer.ConnectionString property encapsulates a callout to the ASP+ Config System to obtain the database connection string for the application.
(Inherited from OfficeClipDB.)
Protected propertyDBConnString
The database connection string that is only available within the framework of the DBLayer. This should only be set through a constructor so this is not available outside the DBLayer. A default conection string is assumed if not set.
(Inherited from OfficeClipDB.)

See Also