Protocol.Covington.WorkRequest.DAL.Request Class
Purpose: Data Access class for the table 'Request'.

Access: Public
Base Classes: DBInteractionBase
  Members Description  
    _personID    
    _personIDOld    
    _clientID    
    _clientIDOld    
    _priorityID    
    _priorityIDOld    
    _actionID    
    _actionIDOld    
    _categoryID    
    _categoryIDOld    
    _departmentID    
    _departmentIDOld    
    _requestID    
    _divisionID    
    _divisionIDOld    
    _locationID    
    _locationIDOld    
    _requestedCompletionDate    
    _priorityRank    
    _number    
    _subject    
    Request 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.

 
    UpdateAllWDivisionIDLogic Purpose: Update method for updating one or more rows using the Foreign Key 'DivisionID. This method will Update one or more existing rows in the database. It will reset the field 'DivisionID' in all rows which have as value for this field the value as set in property 'divisionIDOld' to the value as set in property 'divisionID'.

 
    UpdateAllWLocationIDLogic Purpose: Update method for updating one or more rows using the Foreign Key 'LocationID. This method will Update one or more existing rows in the database. It will reset the field 'LocationID' in all rows which have as value for this field the value as set in property 'locationIDOld' to the value as set in property 'locationID'.

 
    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'.

 
    UpdateAllWClientIDLogic Purpose: Update method for updating one or more rows using the Foreign Key 'ClientID. This method will Update one or more existing rows in the database. It will reset the field 'ClientID' in all rows which have as value for this field the value as set in property 'clientIDOld' to the value as set in property 'clientID'.

 
    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'.

 
    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'.

 
    UpdateAllWCategoryIDLogic Purpose: Update method for updating one or more rows using the Foreign Key 'CategoryID. This method will Update one or more existing rows in the database. It will reset the field 'CategoryID' in all rows which have as value for this field the value as set in property 'categoryIDOld' to the value as set in property 'categoryID'.

 
    UpdateAllWActionIDLogic Purpose: Update method for updating one or more rows using the Foreign Key 'ActionID. This method will Update one or more existing rows in the database. It will reset the field 'ActionID' in all rows which have as value for this field the value as set in property 'actionIDOld' to the value as set in property 'actionID'.

 
    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.

 
    SelectAllWDivisionIDLogic Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'DivisionID'

 
    SelectAllWLocationIDLogic Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'LocationID'

 
    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'

 
    SelectAllWClientIDLogic Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'ClientID'

 
    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'

 
    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'

 
    SelectAllWCategoryIDLogic Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'CategoryID'

 
    SelectAllWActionIDLogic Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'ActionID'

 
    RequestID    
    Subject    
    RequestedCompletionDate    
    DivisionID    
    divisionIDOld    
    LocationID    
    locationIDOld    
    DepartmentID    
    departmentIDOld    
    ClientID    
    clientIDOld    
    PersonID    
    personIDOld    
    PriorityID    
    priorityIDOld    
    PriorityRank    
    CategoryID    
    categoryIDOld    
    ActionID    
    actionIDOld    
    Number