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

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

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

Syntax

C#
public DataSet GetExpensesForExport(
	int groupId,
	DateTime fromDate,
	DateTime toDate
)
Visual Basic (Declaration)
Public Function GetExpensesForExport ( _
	groupId As Integer, _
	fromDate As DateTime, _
	toDate As DateTime _
) As DataSet
Visual C++
public:
DataSet^ GetExpensesForExport(
	int groupId, 
	DateTime fromDate, 
	DateTime toDate
)

Parameters

groupId
Type: System..::.Int32
The unique id for the group.
fromDate
Type: System..::.DateTime
Starting date of the range.
toDate
Type: System..::.DateTime
Ending date of the ranage.

Return Value

DataSet containing all the information related to the timesheets which are ready to be exported. This DataSet consists of a single DataTable with the following columns.
  • expenseId (System.Int32)Id of the expense which is ready to be exported.
  • fromDate (System.DateTime)Starting date of the duration for which the expense was created.
  • toDate (System.DateTime)Ending date of the duration for which the expense was created.
  • createdTimestamp (System.DateTime)The timestamp when the expense was created.
  • createdByUserId (System.Int32)The user id of the user for which the expense was created.
  • name (System.String)Name of the user for which the expense was created.
  • approvedByUser (System.String)Name of the user who has approved the expense.
  • status (System.String)Flag (Y/N) indicating whether this particular expense has already been exported or not.
  • exportTimestamp (System.DateTime)Date and time when the expense was exported.
  • isActive (System.String)Returns "Y" if the expense is active.

See Also