[This is preliminary documentation and is subject to change.]
The PunchDB type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
| PunchDB |
Default Constructor
|
Methods
| Name | Description | |
|---|---|---|
| AddBreakNote |
Adds the notes for break time
| |
| AddHistoryNote |
Adds the notes for history
| |
| AddOutputParameter | Overloaded. | |
| AddParameter | Overloaded. | |
| AddParameters | Overloaded. | |
| 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.) | |
| 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.) | |
| 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.) | |
| GetParameterCount |
Gets the parameter count
(Inherited from OfficeClipDB.) | |
| GetParameterValue |
Gets the value of the parameter
(Inherited from OfficeClipDB.) | |
| GetPunchDay | Overloaded. | |
| GetPunchDays |
Gets the punch days information in a dataset
| |
| GetPunchDaysByMultipleUsers |
Gets the punch days for multiple users
| |
| GetPunchHistory |
Gets the punch history
| |
| GetPunchLimitFromData |
Gets the punch limit from data
| |
| GetPunchRows |
Gets the punch rows. Also adds the rows to fill out the holes. For example if we are looking on a weekly
punchcard and somebody has not punched on a particular day, this function supplies the additional records.
| |
| GetType | Gets the Type of the current instance. (Inherited from Object.) | |
| Init |
Initialize the connection parameters
(Inherited from OfficeClipDB.) | |
| InitTransaction | Overloaded. | |
| InsertHistory |
Insert the history
| |
| IsBreakFromData |
Checks if there is break information
| |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
| PunchIn |
Gets the punch in time
| |
| PunchOut |
Gets the punch out time
| |
| Rollback |
Rolls back the transaction
(Inherited from OfficeClipDB.) | |
| SetParameterValue |
Sets the parameter value of the sql parameter to a known value
(Inherited from OfficeClipDB.) | |
| SetPunchDay |
Sets the punch day
| |
| SetPunchHistory |
Sets the punch history
| |
| SetSPCommand | Overloaded. | |
| SetSPDataAdapter |
Sets the stored procedure data adapter
(Inherited from OfficeClipDB.) | |
| ToString | Returns a String that represents the current Object. (Inherited from Object.) |
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.) |
