Clear all the sql stored procedure parameters

Close the connection, data adapter and the command

Commits the transaction

Creates the DCAA string for logging history

Deletes a particular timesheet identified by timesheetId.

Deletes all the individual timesheet detail items corresponding to a particular timesheet identified by timesheetId.

disposes the object for garbage collection

Determines whether the specified Object is equal to the current Object.

Executes the sql datareader

Executes the query that returns a single valur

Exports a list of timesheets in the QuickBooks timer file format based on the mapping stored corresponding to a particular group.

Fills the dataset

Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

Gets the timesheet task information corresponding to the Active timesheet tasks corresponding to a particular group.

Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table.

Gets all the details of the most recent timesheet created for the a particular user for a particular group.

Gets the parameter count

Gets the value of the parameter

Gets a list of number of rows specified in the currently Active timesheet tasks in the current group.

Checks whether a timesheet has already been created for a given week starting date for a particular user corresponding to a particular group.

Gets a list of all Comments corresponding to a particular timesheet.

Gets the details of all the timesheet detail items for a particular timesheet identified by timesheetId.

Gets all the details corresponding to a particular timesheet identified by timesheetId.

Gets all the Comments corresponding to a particular timesheet identified by timesheetId.

Gets a list of number of rows specified in a particular timesheet tasks.

Gets a list of all the timesheets for a set of users between a given date range for a particular group.

Gets a set of timesheets which are ready to be exported which were created within a given Date range from a particular group.

Gets all the information related to a particular task identified by taskId.

Gets a set of timesheet task names corresponding to a particular group.

Gets a list of all Active tasks corresponding to a particular group.

Gets a set of timesheet tasks corresponding to a particular group.

List of timesheet tasks available for a group (used in rdl reports)

Gets a list of all tasks belonging to a particular timesheet.

Gets the timesheet task Information for active tasks corresponding to a particular timesheet.

Gets the Type of the current instance.

Gets all the information related to the timesheets which have not yet been exported from OfficeClip from a particular group.

Gets a list of all the timesheet task names corresponding to a particular group which have net yet been exported to QuickBooks.

Initialize the connection parameters

Inserts a new timesheet into the database and routes it to a particular user as defined in the workflow.

Inserts all the Comments related to a particular timesheet into the database.

Inserts individual timesheet detail items inside an timesheet into the database.

Inserts a new timesheet into the database.

Inserts all the information related to a task.

Inserts all the information related to a timesheet Tasks corresponding to a particular group using which members of a group can create timesheets.

Finds if the timesheet details is modified

marks the timesheet details to be modified

Creates a shallow copy of the current Object.

Rolls back the transaction

Sets the parameter value of the sql parameter to a known value

Sets the stored procedure data adapter

Sets the expired status of the timesheet

Returns the status of the timesheets submitted for a range of weeks

Returns a String that represents the current Object.

Updates all the information related to a particular timesheet into the database and routes it to a particular user as defined in the workflow.

Updates all the Comments related to a particular timesheet into the database.

Inserts all the information related to a task.

Gets the OfficeClip.DBLayer.ConnectionString property encapsulates a callout to the ASP+ Config System to obtain the database connection string for the application.

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.