Clear all the sql stored procedure parameters

Close the connection, data adapter and the command

Commits the transaction

Remove an alert.

Remove alerts for the events that has been removed from the list.

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 all the alerts for a particular user. This includes only Active alerts, i.e. not archived alerts.

Gets all the Archived alerts for a particular user

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 parameter count

Gets the value of the parameter

Gets the Type of the current instance.

Initialize the connection parameters

Checks if an alert is pending for the Current login user.

Creates a shallow copy of the current Object.

Rolls back the transaction

This function will be used to send any transactional alerts in OfficeClip. When an alert is sent, the alert gif in officeclip starts blinking. If the sent to the group, all the members of the group (whether registered or not) will get separate alerts.

Sets the alerts to the archived State. Alerts in the archived State are viewed by the user when they click on the archived alerts link. An exception is thrown if the data setting is not successful.

Sets a response to an invitation in the alert.

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 the alert message of an event

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.