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

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

Namespace:  OfficeClip.DBLayer.TE
Assembly:  OfficeClip.DBLayer (in OfficeClip.DBLayer)
Version: 8.1.1.0

Syntax

C#
public DataSet GetUnexportedTimesheets(
	int groupId
)
Visual Basic (Declaration)
Public Function GetUnexportedTimesheets ( _
	groupId As Integer _
) As DataSet
Visual C++
public:
DataSet^ GetUnexportedTimesheets(
	int groupId
)

Parameters

groupId
Type: System..::.Int32
The unique id for the group.

Return Value

DataSet containing all the information related to the timesheets which have not yet been exported from OfficeClip. This DataSet consists of a single DataTable with the following columns.
  • timesheetId (System.Int32)Id of the timesheet which has not yet been exported.
  • fromDate (System.DateTime)Starting Date of the duration for which the timesheet was created.
  • toDate (System.DateTime)Ending date of duration for which the timesheet was created.
  • name (System.String)Name of the user for which the timesheet was created.
  • approvedByUser (System.String)Name of the user who approved the timesheet.
  • status (System.String)Flag (Y/N) indicating the status whether the timesheet has been exported or not.
  • exportTimestamp (System.DateTime)Date and Time when the timesheet was exported. Please note as this timesheet has not yet been exported, this field will always be null.

See Also