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

The ProjectDB type exposes the following members.

Constructors

  NameDescription
Public methodProjectDB

Methods

  NameDescription
Public methodAccountExists
Checks whether a Customer with a particular screen name exists.
Public methodAddOutputParameterOverloaded.
Public methodAddParameterOverloaded.
Protected methodAddParametersOverloaded.
Public methodClearParameters
Clear all the sql stored procedure parameters
(Inherited from OfficeClipDB.)
Public methodClose
Close the connection, data adapter and the command
(Inherited from OfficeClipDB.)
Public methodCommit
Commits the transaction
(Inherited from OfficeClipDB.)
Public methodDeleteProject
Deletes a particular Project identified by projectId.
Public methodDispose
disposes the object for garbage collection
(Inherited from OfficeClipDB.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodExecuteNonQueryOverloaded.
Protected methodExecuteReader
Executes the sql datareader
(Inherited from OfficeClipDB.)
Protected methodExecuteScalar
Executes the query that returns a single valur
(Inherited from OfficeClipDB.)
Protected methodFill
Fills the dataset
(Inherited from OfficeClipDB.)
Protected methodFinalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetAccount
Gets all the information related to a particular Customer identified by accountId.
Public methodGetClientAndProjectList
Get a list of all the Customer and Projects for a particular group.
Public methodGetClientAndProjectRestrictedList
Gets the restricted list for the client and the project
Public methodGetClientList
Gets the list of clients for a particular group.
Public methodGetHashCode
Serves as a hash function for a particular type. GetHashCode()()() is suitable for use in hashing algorithms and data structures like a hash table.
(Inherited from Object.)
Public methodGetParameterCount
Gets the parameter count
(Inherited from OfficeClipDB.)
Public methodGetParameterValue
Gets the value of the parameter
(Inherited from OfficeClipDB.)
Public methodGetProject
Gets all the Project related information from the database.
Public methodGetProjectList
Gets the list of projects
Public methodGetProjectsForRdlc
List of projects in a group (used in rdl reports)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodGetUserRestrictedList
Gets the restricted list for the user
Protected methodInit
Initialize the connection parameters
(Inherited from OfficeClipDB.)
Public methodInitTransactionOverloaded.
Public methodInsertAccount
inserts the account
Public methodInsertProject
Inserts all the Project related information from the database.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodProjectExists
Checks whether a Project with a particular screen name exists.
Public methodRollback
Rolls back the transaction
(Inherited from OfficeClipDB.)
Public methodSetParameterValue
Sets the parameter value of the sql parameter to a known value
(Inherited from OfficeClipDB.)
Protected methodSetSPCommandOverloaded.
Protected methodSetSPDataAdapter
Sets the stored procedure data adapter
(Inherited from OfficeClipDB.)
Public methodToString
Returns a String that represents the current Object.
(Inherited from Object.)
Public methodUpdateAccountName
Updates a Customer and all its related information into the database.
Public methodUpdateClientProjectRestricted
Updates the client and the project restricted list
Public methodUpdateProject
Updates all the Project related information from the database.
Public methodUpdateUsersRestricted
Updates the users restricted list

Properties

  NameDescription
Public propertyConnectionString
Gets the OfficeClip.DBLayer.ConnectionString property encapsulates a callout to the ASP+ Config System to obtain the database connection string for the application.
(Inherited from OfficeClipDB.)
Protected propertyDBConnString
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.
(Inherited from OfficeClipDB.)

See Also