[This is preliminary documentation and is subject to change.]
The CommonDB type exposes the following members.
Constructors
Name | Description | |
---|---|---|
![]() | CommonDB |
Methods
Name | Description | |
---|---|---|
![]() | AddOutputParameter | Overloaded. |
![]() | AddParameter | Overloaded. |
![]() | AddParameters | Overloaded. |
![]() | ArchiveItem |
Archives either a particular timesheet or an expense based on the application id provided.
|
![]() | ClearParameters |
Clear all the sql stored procedure parameters
(Inherited from OfficeClipDB.) |
![]() | Close |
Close the connection, data adapter and the command
(Inherited from OfficeClipDB.) |
![]() | Commit |
Commits the transaction
(Inherited from OfficeClipDB.) |
![]() | DeletePayrollCategory |
Deletes the payroll category
|
![]() | DeleteTeRates |
Delete the rate
|
![]() | Dispose |
disposes the object for garbage collection
(Inherited from OfficeClipDB.) |
![]() | Equals | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
![]() | ExecuteNonQuery | Overloaded. |
![]() | ExecuteReader |
Executes the sql datareader
(Inherited from OfficeClipDB.) |
![]() | ExecuteScalar |
Executes the query that returns a single valur
(Inherited from OfficeClipDB.) |
![]() | Fill |
Fills the dataset
(Inherited from OfficeClipDB.) |
![]() | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetDCAAHistory |
Gets the DCAA history
|
![]() | GetHashCode | 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.) |
![]() | GetInBoxOutBoxList |
Gets all the inbox and outbox items for both the time and expenses.
|
![]() | GetParameterCount |
Gets the parameter count
(Inherited from OfficeClipDB.) |
![]() | GetParameterValue |
Gets the value of the parameter
(Inherited from OfficeClipDB.) |
![]() | GetPayrollList |
Gets the payroll list
|
![]() | GetPayrollOverheads |
Returns the payroll overheads
|
![]() | GetTERates |
Gets the rates for all the user in the group
|
![]() | GetTEReadonly |
Gets the Timesheet/Expense Readonly status
|
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | Init |
Initialize the connection parameters
(Inherited from OfficeClipDB.) |
![]() | InitTransaction | Overloaded. |
![]() | InsertPayrollCategory |
Inserts a new payroll category for a group
|
![]() | MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | Rollback |
Rolls back the transaction
(Inherited from OfficeClipDB.) |
![]() | SetParameterValue |
Sets the parameter value of the sql parameter to a known value
(Inherited from OfficeClipDB.) |
![]() | SetSPCommand | Overloaded. |
![]() | SetSPDataAdapter |
Sets the stored procedure data adapter
(Inherited from OfficeClipDB.) |
![]() | ToString | Returns a String that represents the current Object. (Inherited from Object.) |
![]() | UpdatePayrollCategory |
Updates a payroll category
|
![]() | UpdateTeRates |
Updates the billing rates
|
![]() | UpdTePayrollOverheads | Overloaded. |
Properties
Name | Description | |
---|---|---|
![]() | ConnectionString |
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.) |
![]() | DBConnString |
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.) |