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

The PunchDB type exposes the following members.

Constructors

  NameDescription
Public methodPunchDB
Default Constructor

Methods

  NameDescription
Protected methodAddBreakNote
Adds the notes for break time
Protected methodAddHistoryNote
Adds the notes for history
Public methodAddOutputParameterOverloaded.
Public methodAddParameterOverloaded.
Protected methodAddParametersOverloaded.
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 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 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 methodGetParameterCount
Gets the parameter count
(Inherited from OfficeClipDB.)
Public methodGetParameterValue
Gets the value of the parameter
(Inherited from OfficeClipDB.)
Public methodGetPunchDayOverloaded.
Public methodGetPunchDays
Gets the punch days information in a dataset
Public methodGetPunchDaysByMultipleUsers
Gets the punch days for multiple users
Public methodGetPunchHistory
Gets the punch history
Protected methodGetPunchLimitFromData
Gets the punch limit from data
Public methodGetPunchRows
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.
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodInit
Initialize the connection parameters
(Inherited from OfficeClipDB.)
Public methodInitTransactionOverloaded.
Public methodInsertHistory
Insert the history
Protected methodIsBreakFromData
Checks if there is break information
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodPunchIn
Gets the punch in time
Public methodPunchOut
Gets the punch out time
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.)
Public methodSetPunchDay
Sets the punch day
Public methodSetPunchHistory
Sets the punch history
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.)

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