Clear all the sql stored procedure parameters

Close the connection, data adapter and the command

Commits the transaction

Deletes a particular expense identified by ExpenseId.

Deletes all the details corresponding to a particular expense identified by ExpenseId.

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

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 a list of number of rows specified in the currently Active in the group.

Gets all the information related to the currently Active expense types corresponding to a particular group.

Gets all the details for an airfare type expense detail item based on the ExpenseId and ExpenseDetailId specified in the the ExpenseAirfareInfo object as input.

Gets a list of all the expense types defined for a particular expense identified by the expenseId.

Gets the all the information of expense types used in the expense with expenseId.

Gets all the details for an auto rental type expense detail item based on the ExpenseId and ExpenseDetailId specified in the the ExpenseAutorentalInfo object as input.

Checks for a given start date, whether an expense has already been created by a particular user corresponding to a particular group.

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

Gets all the expense details items created within a particular expense identified by ExpenseId.

Gets all the expense details items created within a particular expense identified by ExpenseId.

Gets all the details related to a particular expense identified by ExpenseId.

Gets all the Comments corresponding to a particular expense identified by ExpenseId.

Gets a list of number of rows specified in a particular expense types.

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

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

Gets the expense types for an expense type id.

Gets all the details corresponding to a particular expense type.

Gets a list of all the expense types defined in the Active expense types for a particular group.

List of expense types available for a group (used for rdl reports)

Gets the expense types for expenseId, if the expenseId is -1 then gets the expense types for the groupId.

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 for an hotel type expense detail item based on the ExpenseId and ExpenseDetailId specified in the the ExpenseHotelInfo object as input.

Gets all the informatin related to the most recent expense created by a particular user corresponding to a particular group.

Gets the parameter count

Gets the value of the parameter

Gets all the details for a taxi type expense detail item based on the ExpenseId and ExpenseDetailId specified in the the ExpenseTaxiInfo object as input.

Gets all the details for a telephone type expense detail item based on the ExpenseId and ExpenseDetailId specified in the the ExpenseTelephoneInfo object as input.

Gets the Type of the current instance.

Initialize the connection parameters

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

Inserts airfare expense detail item crated inside an expense into the database.

Inserts auto rental expense detail item created inside an expense into the database.

Inserts a new expense Comment created inside an expense

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

Inserts hotel expense detail item crated inside an expense into the database.

Inserts a new expense into the database.

Inserts taxi expense detail item created inside an expense into the database.

Inserts telephone expense detail item created inside an expense into the database.

Inserts all the information related to a expense type.

Inserts all the information related to a expense types corresponding to a a particular group.

Creates a shallow copy of the current Object.

Rolls back the transaction

Sets the expired status of the expense

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

Sets the stored procedure data adapter

Returns a String that represents the current Object.

Updates all the details realted to a particular expense into the database and routes it to a particular user as defined in the workflow.

Updates an expense Comment defined inside an expense.

Inserts all the information related to a expense types.

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.