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

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

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

Syntax

C#
public DataSet GetExpenses(
	int groupId,
	string userList,
	DateTime fromDate,
	DateTime toDate,
	bool isRestricted
)
Visual Basic (Declaration)
Public Function GetExpenses ( _
	groupId As Integer, _
	userList As String, _
	fromDate As DateTime, _
	toDate As DateTime, _
	isRestricted As Boolean _
) As DataSet
Visual C++
public:
DataSet^ GetExpenses(
	int groupId, 
	String^ userList, 
	DateTime fromDate, 
	DateTime toDate, 
	bool isRestricted
)

Parameters

groupId
Type: System..::.Int32
The unique id for the group.
userList
Type: System..::.String
Comma delimited list of userIds for whom the expenses are to be retrieved.
fromDate
Type: System..::.DateTime
Starting Date of the range.
toDate
Type: System..::.DateTime
Ending Date of the range.
isRestricted
Type: System..::.Boolean

Return Value

DataSet containing all the information related to all the expenses for the respective users within the date range. This DataSet consists of a single DataTable with the following columns.
  • Amount (System.Decimal)Total Amount in the expense.
  • ExpenseId (System.Int32)Id of the expense.
  • status (System.String)Current status of the expense.
  • weekStartDate (System.String)Starting date of the expense.
  • name (System.String)User to which the expense belongs.
  • emailAddress (System.String)Email Address of the user.
  • withUserName (System.String)Name of the user to whom this expense is currently submitted.
  • withUserEmailAddress (System.String)Email Address of the user to whom this expense is currently submitted.

See Also