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

Access: Public
Base Classes: DBInteractionBase
  Members Description  
    _personID    
    _personIDOld    
    _requestID    
    _requestIDOld    
    _trackedRequestStatusID    
    _changeDate    
    _requestStatusID    
    _requestStatusIDOld    
    TrackedRequestStatus 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.

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

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

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

 
    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.

 
    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'

 
    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'

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

 
    TrackedRequestStatusID    
    RequestID    
    requestIDOld    
    ChangeDate    
    PersonID    
    personIDOld    
    RequestStatusID    
    requestStatusIDOld