Clear all the sql stored procedure parameters

Close the connection, data adapter and the command

Commits the transaction

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

Get the CSV formatted text for the selected fields from the users's details corresponding to a particular group.

Gets the all the information of all the members of a particular group in a VCard format.

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 all the users from the OfficeClip System.

Returns the first alphabets of the first name or the last name depending on the value of orderBy argument for a particular group.

Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table.

Returns all the user from a system who can be seen by a particular user.

This method returns a set of all the members of the OfficeClip account who are not a member of a given group.

Returns all the user who can be seen by a particular user, and does not belong to a particular group.

Gets the parameter count

Gets the value of the parameter

Gets the password string for a particular user, this string is used to compare the user's password to allow user entry to the system. The string being compared to and the password value obtained from the database both are in one way encrypted format.

Gets the Type of the current instance.

Get the user's id from the given the email Address in a particular group.

Gets all the users for a particular group sorted by a given sort condition.

Initialize the connection parameters

Creates a shallow copy of the current Object.

Resets user password and the mail is sent using the name and email Address of the currently logged in user.

Resets the password in the database and returns the password in cleartext as the output. This method is required because it will encourage reuse of this part for both reset password and Reinvite members

Rolls back the transaction

Gets the information of all the users for a particular user matching the search criteria.

Grants or revokes admin privileges to a set of users in a particular group.

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

Sets the stored procedure data adapter

Sets a Timestamp in the database which marking the the user's login date and time for the user who is currently logging in.

Returns a String that represents the current Object.

Encrypts the password for a particular user using the MD5 algorithm and saves the password in the database.

Encrypts the user pin number (used for mobile access) for a particular user using the MD5 algorithm and saves the password in the database.

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.