archives the Project in the database, or restores it.

Bulk archives the cases so that they are not shown to the user. This is called from UpdateOptions.

Clear all the sql stored procedure parameters

Close the connection, data adapter and the command

Commits the transaction

Deletes the all cases from the project

Deletes the archived cases from the project

Deletes a particular case

Removes the Project in the database.

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 the Project list which are accessible to the administrator. This method assumes that the currently logged in user is an administrator.

Gets the attachment paths

Provides an ArrayList of PropertyInfo for a tracker case.

Gets the tracker case detail in a String

Gets the internal case id from the Project id and the case number.

Gets the extension parameters of the case. The extension parameters are Description, Resolution and Comments.

Get the caselist information to display in the caselist screen of the tracker for a particular user.

Gets all the case information, this combines the normal case list information and also the Description, Resolution and Comments

Get the case list information for the knowledge base

Gets the children of an object

Returns a datatable consisting of all the field list values.

Returns a datatable consisting of all the field names.

Gets the tracker case information consisting of all the field values.

Gets the filter detail for a given filter

Gets all the filters

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 the tracker history for display on the screen.

Gets the parameter count

Gets the value of the parameter

Gets the count of the projects

Gets the Project information.

Gets a list of all the Projects from the database

Returns the style of the row, the row style can be in terms of background color or font

Gets the statistical data related to the list type fields.

Gets the tracker status matrix for extranet users

Gets the Type of the current instance.

Initialize the connection parameters

Inserts a new case in the tracker.

Modifies the field values of a list type.

Checks if the tracker case is present

Creates a shallow copy of the current Object.

Move the list item of a tracker field to one Position down.

Move the list item of a tracker field to one Position up.

Removes the field list values

Delete a filter from the database

Rolls back the transaction

Saves a newly created filter in the database

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 an existing case in the tracker.

Updates the default value of the list type field.

Updates the sort order of a field type of type list.

Updates the list value of a particular list type field in tracker.

Updates the fixed field names.

Updates the edit capabilities of the fixed fields

Updates the mandatory capabilities of the fixed fields

Updates the database based on the values entered in the option screen.

Changes the name of the Project.

Changes the name of the udf field.

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.