| |
 |
Members |
Description |
|
| |
|
_requestID |
|
|
| |
|
_requestIDOld |
|
|
| |
|
_locationID |
|
|
| |
|
_divisionID |
|
|
| |
|
_projectID |
|
|
| |
|
_projectIDOld |
|
|
| |
|
_assignmentID |
|
|
| |
|
_personID |
|
|
| |
|
_personIDOld |
|
|
| |
|
_priorityID |
|
|
| |
|
_priorityIDOld |
|
|
| |
|
_departmentID |
|
|
| |
|
_departmentIDOld |
|
|
| |
|
_number |
|
|
| |
|
_priorityRank |
|
|
| |
|
Assignment |
Purpose: Class constructor.
|
|
| |
|
Insert |
Purpose: Insert method. This method will insert one new row into the database.
|
|
| |
|
Update |
Purpose: Update method. This method will Update one existing row in the database.
|
|
| |
|
UpdateAllWPersonIDLogic |
Purpose: Update method for updating one or more rows using the Foreign Key 'PersonID.
This method will Update one or more existing rows in the database. It will reset the field 'PersonID' in
all rows which have as value for this field the value as set in property 'personIDOld' to
the value as set in property 'personID'.
|
|
| |
|
UpdateAllWDepartmentIDLogic |
Purpose: Update method for updating one or more rows using the Foreign Key 'DepartmentID.
This method will Update one or more existing rows in the database. It will reset the field 'DepartmentID' in
all rows which have as value for this field the value as set in property 'departmentIDOld' to
the value as set in property 'departmentID'.
|
|
| |
|
UpdateAllWPriorityIDLogic |
Purpose: Update method for updating one or more rows using the Foreign Key 'PriorityID.
This method will Update one or more existing rows in the database. It will reset the field 'PriorityID' in
all rows which have as value for this field the value as set in property 'priorityIDOld' to
the value as set in property 'priorityID'.
|
|
| |
|
UpdateAllWRequestIDLogic |
Purpose: Update method for updating one or more rows using the Foreign Key 'RequestID.
This method will Update one or more existing rows in the database. It will reset the field 'RequestID' in
all rows which have as value for this field the value as set in property 'requestIDOld' to
the value as set in property 'requestID'.
|
|
| |
|
UpdateAllWProjectIDLogic |
Purpose: Update method for updating one or more rows using the Foreign Key 'ProjectID.
This method will Update one or more existing rows in the database. It will reset the field 'ProjectID' in
all rows which have as value for this field the value as set in property 'projectIDOld' to
the value as set in property 'projectID'.
|
|
| |
|
Delete |
Purpose: Delete method. This method will Delete one existing row in the database, based on the Primary Key.
|
|
| |
|
SelectOne |
Purpose: Select method. This method will Select one existing row from the database, based on the Primary Key.
|
|
| |
|
SelectAll |
Purpose: SelectAll method. This method will Select all rows from the table.
|
|
| |
|
SelectAllWPersonIDLogic |
Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'PersonID'
|
|
| |
|
SelectAllWDepartmentIDLogic |
Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'DepartmentID'
|
|
| |
|
SelectAllWPriorityIDLogic |
Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'PriorityID'
|
|
| |
|
SelectAllWRequestIDLogic |
Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'RequestID'
|
|
| |
|
SelectAllWProjectIDLogic |
Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'ProjectID'
|
|
| |
|
AssignmentID |
|
|
| |
|
PersonID |
|
|
| |
|
personIDOld |
|
|
| |
|
DepartmentID |
|
|
| |
|
departmentIDOld |
|
|
| |
|
PriorityID |
|
|
| |
|
priorityIDOld |
|
|
| |
|
PriorityRank |
|
|
| |
|
RequestID |
|
|
| |
|
requestIDOld |
|
|
| |
|
Number |
|
|
| |
|
ProjectID |
|
|
| |
|
projectIDOld |
|
|
| |
|
DivisionID |
|
|
| |
|
LocationID |
|
|
