Namespace: Consultingwerk.SmartFramework.Authentication
Class 
UserDataAccess Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.OERA.DataAccess
Consultingwerk.SmartFramework.SmartDataAccess
Consultingwerk.SmartFramework.Authentication.UserDataAccess

Inherits: Consultingwerk.SmartFramework.SmartDataAccess
Implements: Consultingwerk.OERA.IDataAccess, Consultingwerk.OERA.IDataAccessCanFind, Consultingwerk.OERA.IDataAccessCountRecords, IDSQueryStringSource, Consultingwerk.OERA.IProvidesSmartRecordInformation


Consultingwerk.SmartFramework.Authentication.UserBusinessEntity
Consultingwerk.SmartFramework.Authentication.UserBusinessEntity

Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
AssignManager (character) Assigns the ManagerUserName and ManagerUserFullName fields
AssignNewSecurityId (handle) Assigns the new available UserSecurityId value
AttachDataSources () Attaches the DATA-SOURCE objects to the ProDataset Buffers
BindDataset (dataset) Do nothing, just receive the parameter and bind to the received Dataset reference
DefineReadEvents () TO-DO: Subscribe to ProDataset Event Handlers using SET-CALLBACK as needed
DetachDataSources () Detaches the DATA-SOURCE objects to the ProDataset Buffers
eSmartUserAfterFill (dataset) Populates the calculated fields of the eSmartUser TEMP-TABLE
eSmartUserCreateBeginTrans () Validation method for eSmartUser
eSmartUserCreateEndTrans () Validation method for eSmartUser
eSmartUserDeleteBeginTrans () Validation method for eSmartUser
eSmartUserModifyEndTrans () Validation method for eSmartUser
FetchDataByStaticQuery (IFetchDataByStaticQueryRequest) Fetches data for single table, using a static query
FetchSmartUserByUserGuid (character, character) FetchData method for static query
FetchSmartUserByUserNameLoginCompanyGuid (character, character, character) FetchData method for static query
FetchSmartUserByUserSecurityId (integer, character) FetchData method for static query
OnBeforeSavingRowChanges (SaveRowChangesEventArgs) Validates the Username when adding or modifying a SmartUser row
SaveChanges () Save changes to physical storage
SaveRowChanges (handle) Executes SAVE-ROW-CHANGES on the before buffer
CHARACTER SourceColumn (character, character) Returns the database field name matching a temp-table field name contained in a consumers query string (query string vs. temp-table definition)
CHARACTER SourceDefaultQuery (character) Returns the base query string used to retrieve data for the temp tables. This query string will be appended by the query provided by the consumer (FetchDataRequest object).
LOGICAL ValidateUserPassword (character, character) Verifies the users password

Top Constructor Summary
Options Name Purpose
UserDataAccess (handle) Constructor for the UserDataAccess class


Method Detail
Top

AssignManager (character)
Purpose: Assigns the ManagerUserName and ManagerUserFullName fields
Notes:

Parameters:
pcUserGuid CHARACTER
Top

AssignNewSecurityId (handle)
Purpose: Assigns the new available UserSecurityId value
Notes:

Parameters:
phBuffer HANDLE
The handle of the eSmartUser buffer
Top

AttachDataSources ()
Purpose: Attaches the DATA-SOURCE objects to the ProDataset Buffers
Notes: Overrides ABSTRACT method in Consultingwerk.OERA.DataAccess,
Invoked in FetchData and SaveChanges

Top

BindDataset (dataset)
Purpose: Do nothing, just receive the parameter and bind to the received
Dataset reference
Notes: Invoked from the class constructor

Parameters:
dsUser DATASET dsUser
DATASET to bind to
Top

DefineReadEvents ()
Purpose: TO-DO: Subscribe to ProDataset Event Handlers using SET-CALLBACK
as needed
Notes: Overrides ABSTRACT method in Consultingwerk.OERA.DataAccess,
Invoked in FetchData

Top

DetachDataSources ()
Purpose: Detaches the DATA-SOURCE objects to the ProDataset Buffers
Notes: Overrides ABSTRACT method in Consultingwerk.OERA.DataAccess,
Invoked in FetchData and SaveChanges

Top

eSmartUserAfterFill (dataset)
Purpose: Populates the calculated fields of the eSmartUser TEMP-TABLE
Notes:

Parameters:
dsUser DATASET dsUser
The User Dataset used in the Dataset Fill Event
Top

eSmartUserCreateBeginTrans ()
Purpose: Validation method for eSmartUser
Notes:

Top

eSmartUserCreateEndTrans ()
Purpose: Validation method for eSmartUser
Notes:

Top

eSmartUserDeleteBeginTrans ()
Purpose: Validation method for eSmartUser
Notes: Resolve issue The current row has been changed by another user! (11913)
caused by PasswordEncoding and PasswordSalt being serialize-hidden and
thus not exposed to the web

Top

eSmartUserModifyEndTrans ()
Purpose: Validation method for eSmartUser
Notes:

Top

FetchDataByStaticQuery (IFetchDataByStaticQueryRequest)
Purpose: Fetches data for single table, using a static query
Notes:

Parameters:
poParameter Consultingwerk.OERA.IFetchDataByStaticQueryRequest
The query parameter object
Top

FetchSmartUserByUserGuid (character, character)
Purpose: FetchData method for static query
Notes:

Parameters:
pcUserGuid CHARACTER
The UserGuid value
pcChildTables CHARACTER
a list of the child tables to fill
Top

FetchSmartUserByUserNameLoginCompanyGuid (character, character, character)
Purpose: FetchData method for static query
Notes:

Parameters:
pcUserName CHARACTER
The UserName value
pcLoginCompanyGuid CHARACTER
The LoginCompanyGuid value
pcChildTables CHARACTER
a list of the child tables to fill
Top

FetchSmartUserByUserSecurityId (integer, character)
Purpose: FetchData method for static query
Notes:

Parameters:
piUserSecurityId INTEGER
The UserSecurityId value
pcChildTables CHARACTER
a list of the child tables to fill
Top

OnBeforeSavingRowChanges (SaveRowChangesEventArgs)
Purpose: Validates the Username when adding or modifying a SmartUser row
Notes:

Parameters:
e Consultingwerk.OERA.SaveRowChangesEventArgs
An EventArgs that contains the Event specific data
Top

SaveChanges ()
Purpose: Save changes to physical storage
Notes: This implementation of data access save traverses all records in order
to:
- Allow the DA to control transactions, which cannot be directly
controlled in distributed BL. Transaction control is a concern of
the BL, but should not be controlled with TRANSACTION keyword.
- Offer a course grained save interface from distributed BL
- The default operation here is just a transaction per record
- This simple sample does not use child relations to traverse
the buffers as the OERI BE example. (A property that controls
update order would give the same effect).
- Traversing of child data from a parent would make sense if done for
one parent record at a time.

Top

SaveRowChanges (handle)
Purpose: Executes SAVE-ROW-CHANGES on the before buffer
Notes: Overrides the DataAccess:SaveRowChanges method; resets the
AssignSkipList property for new records that already contain a
GUID value, this allows to provide the GUID value for new
records optionally from the client

Parameters:
phBeforeBuffer HANDLE
The handle of the BEFORE-BUFFER
Top

CHARACTER SourceColumn (character, character)
Purpose: Returns the database field name matching a temp-table field name
contained in a consumers query string (query string vs. temp-table
definition)
Notes: Call-back used by Consultingwerk.OERA.Query.DSQueryString (part of
DataAccess:FetchData FetchData () query preparation
TO-DO: Provide code for alternative mapping

Parameters:
pcTable CHARACTER
The temp table name to return the source (database table) field name for
pcColumn CHARACTER
The temp table column name to return the source (database table) field name for
Returns CHARACTER
The database field name mapped to the passed in temp-table field
Top

CHARACTER SourceDefaultQuery (character)
Purpose: Returns the base query string used to retrieve data for the temp
tables. This query string will be appended by the query provided by
the consumer (FetchDataRequest object).
Notes: Call-back used by Consultingwerk.OERA.Query.DSQueryString (part of
DataAccess:FetchData FetchData () query preparation

Parameters:
pcTable CHARACTER
The temp table name to return the source default (database) query string for
Returns CHARACTER
The base query string used to retrieve data for the given temp-table
Top

LOGICAL ValidateUserPassword (character, character)
Purpose: Verifies the users password
Notes:

Parameters:
pcUserGuid CHARACTER
The GUID of the user
pcPassword CHARACTER
The password to verify
Returns LOGICAL
Logical value indicating if the passwords do match


Constructor Detail
Top

UserDataAccess (handle)
Purpose: Constructor for the UserDataAccess class
Notes: Used by the BusinessEntity, will receive the handle of the dataset
instance form the BusinessEntity as a parameter. Permanently BIND's
to that dataset using the PRIVATE BindDataset Method.

Parameters:
phDataset HANDLE
The handle of the Business Entity dataset


ProDataset Detail

ProDataset dsUser

Member tables: eSmartUser


Temp-Table Detail

Temp-Table eSmartUser

Defined in:


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       13.04.2026 10:24:13