C# Class Nettiers.AdventureWorks.Data.WebServiceClient.WsEmployeeDepartmentHistoryProviderBase

This class is the webservice client implementation that exposes CRUD methods for Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory objects.
Inheritance: EmployeeDepartmentHistoryProviderBase
Mostra file Open project: netTiers/netTiers

Public Methods

Method Description
BulkInsert ( TransactionManager transactionManager, Nettiers entityList ) : void

Lets you efficiently bulk many entity to the database.

After inserting into the datasource, the Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns)

Convert ( Nettiers outItem, WsProxy item ) : EmployeeDepartmentHistory

Convert a nettiers collection to the ws proxy collection.
Convert ( WsProxy item ) : EmployeeDepartmentHistory

Convert a nettiers collection to the ws proxy collection.
Convert ( WsProxy items ) : Nettiers.AdventureWorks.Entities.TList

Convert a collection from the ws proxy to a nettiers collection.
Convert ( Nettiers item ) : WsProxy.EmployeeDepartmentHistory

Convert a nettiers entity to the ws proxy entity.
Convert ( Nettiers items ) : WsProxy.EmployeeDepartmentHistory[]

Convert a collection from to a nettiers collection to a the ws proxy collection.
Delete ( TransactionManager transactionManager, System _employeeId, System _startDate, System _departmentId, System _shiftId ) : bool Deletes based on primary key(s).
Find ( TransactionManager transactionManager, string whereClause, int start, int pagelen, int &count ) : Nettiers.AdventureWorks.Entities.TList

Returns rows meeting the whereclause condition from the DataSource.

Operators must be capitalized (OR, AND)

GetAll ( TransactionManager transactionManager, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList

Gets All rows from the DataSource.
GetByDepartmentId ( TransactionManager transactionManager, System _departmentId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList

Gets rows from the datasource based on the IX_EmployeeDepartmentHistory_DepartmentID index.
GetByEmployeeId ( TransactionManager transactionManager, System _employeeId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList

Gets rows from the datasource based on the FK_EmployeeDepartmentHistory_Employee_EmployeeID key. FK_EmployeeDepartmentHistory_Employee_EmployeeID Description: Foreign key constraint referencing Employee.EmployeeID.
GetByEmployeeIdStartDateDepartmentIdShiftId ( TransactionManager transactionManager, System _employeeId, System _startDate, System _departmentId, System _shiftId, int start, int pageLength, int &count ) : EmployeeDepartmentHistory

Gets rows from the datasource based on the PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID index.
GetByShiftId ( TransactionManager transactionManager, System _shiftId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList

Gets rows from the datasource based on the IX_EmployeeDepartmentHistory_ShiftID index.
GetPaged ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList

Gets a page of rows from the DataSource.
Insert ( TransactionManager transactionManager, Nettiers entity ) : bool

Inserts a Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory object into the datasource using a transaction.
Update ( TransactionManager transactionManager, Nettiers entity ) : bool

Update an existing row in the datasource.
WsEmployeeDepartmentHistoryProviderBase ( ) : System

Creates a new WsEmployeeDepartmentHistoryProviderBase instance. Uses connection string to connect to datasource.
WsEmployeeDepartmentHistoryProviderBase ( string url ) : System

Creates a new WsEmployeeDepartmentHistoryProviderBase instance. Uses connection string to connect to datasource.

Method Details

BulkInsert() public method

Lets you efficiently bulk many entity to the database.
After inserting into the datasource, the Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns)
public BulkInsert ( TransactionManager transactionManager, Nettiers entityList ) : void
transactionManager TransactionManager NOTE: The transaction manager should be null for the web service client implementation.
entityList Nettiers The entities.
return void

Convert() public static method

Convert a nettiers collection to the ws proxy collection.
public static Convert ( Nettiers outItem, WsProxy item ) : EmployeeDepartmentHistory
outItem Nettiers
item WsProxy
return Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory

Convert() public static method

Convert a nettiers collection to the ws proxy collection.
public static Convert ( WsProxy item ) : EmployeeDepartmentHistory
item WsProxy
return Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory

Convert() public static method

Convert a collection from the ws proxy to a nettiers collection.
public static Convert ( WsProxy items ) : Nettiers.AdventureWorks.Entities.TList
items WsProxy
return Nettiers.AdventureWorks.Entities.TList

Convert() public static method

Convert a nettiers entity to the ws proxy entity.
public static Convert ( Nettiers item ) : WsProxy.EmployeeDepartmentHistory
item Nettiers
return WsProxy.EmployeeDepartmentHistory

Convert() public static method

Convert a collection from to a nettiers collection to a the ws proxy collection.
public static Convert ( Nettiers items ) : WsProxy.EmployeeDepartmentHistory[]
items Nettiers
return WsProxy.EmployeeDepartmentHistory[]

Delete() public method

Deletes based on primary key(s).
public Delete ( TransactionManager transactionManager, System _employeeId, System _startDate, System _departmentId, System _shiftId ) : bool
transactionManager TransactionManager object
_employeeId System
_startDate System
_departmentId System
_shiftId System
return bool

Find() public method

Returns rows meeting the whereclause condition from the DataSource.
Operators must be capitalized (OR, AND)
public Find ( TransactionManager transactionManager, string whereClause, int start, int pagelen, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
whereClause string Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').
start int Row number at which to start reading.
pagelen int Number of rows to return.
count int Number of rows in the DataSource.
return Nettiers.AdventureWorks.Entities.TList

GetAll() public method

Gets All rows from the DataSource.
public GetAll ( TransactionManager transactionManager, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int out parameter to get total records for query
return Nettiers.AdventureWorks.Entities.TList

GetByDepartmentId() public method

Gets rows from the datasource based on the IX_EmployeeDepartmentHistory_DepartmentID index.
public GetByDepartmentId ( TransactionManager transactionManager, System _departmentId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
_departmentId System Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int out parameter to get total records for query
return Nettiers.AdventureWorks.Entities.TList

GetByEmployeeId() public method

Gets rows from the datasource based on the FK_EmployeeDepartmentHistory_Employee_EmployeeID key. FK_EmployeeDepartmentHistory_Employee_EmployeeID Description: Foreign key constraint referencing Employee.EmployeeID.
public GetByEmployeeId ( TransactionManager transactionManager, System _employeeId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
_employeeId System Employee identification number. Foreign key to Employee.EmployeeID.
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int out parameter to get total records for query
return Nettiers.AdventureWorks.Entities.TList

GetByEmployeeIdStartDateDepartmentIdShiftId() public method

Gets rows from the datasource based on the PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID index.
public GetByEmployeeIdStartDateDepartmentIdShiftId ( TransactionManager transactionManager, System _employeeId, System _startDate, System _departmentId, System _shiftId, int start, int pageLength, int &count ) : EmployeeDepartmentHistory
transactionManager TransactionManager object
_employeeId System Employee identification number. Foreign key to Employee.EmployeeID.
_startDate System Date the employee started work in the department.
_departmentId System Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
_shiftId System Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int out parameter to get total records for query
return Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory

GetByShiftId() public method

Gets rows from the datasource based on the IX_EmployeeDepartmentHistory_ShiftID index.
public GetByShiftId ( TransactionManager transactionManager, System _shiftId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
_shiftId System Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int out parameter to get total records for query
return Nettiers.AdventureWorks.Entities.TList

GetPaged() public method

Gets a page of rows from the DataSource.
public GetPaged ( TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
whereClause string Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').
orderBy string Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);
start int Row number at which to start reading.
pageLength int Number of rows to return.
count int Number of rows in the DataSource.
return Nettiers.AdventureWorks.Entities.TList

Insert() public method

Inserts a Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory object into the datasource using a transaction.
public Insert ( TransactionManager transactionManager, Nettiers entity ) : bool
transactionManager TransactionManager object
entity Nettiers Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory object to insert.
return bool

Update() public method

Update an existing row in the datasource.
public Update ( TransactionManager transactionManager, Nettiers entity ) : bool
transactionManager TransactionManager object
entity Nettiers Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory object to update.
return bool

WsEmployeeDepartmentHistoryProviderBase() public method

Creates a new WsEmployeeDepartmentHistoryProviderBase instance. Uses connection string to connect to datasource.
public WsEmployeeDepartmentHistoryProviderBase ( ) : System
return System

WsEmployeeDepartmentHistoryProviderBase() public method

Creates a new WsEmployeeDepartmentHistoryProviderBase instance. Uses connection string to connect to datasource.
public WsEmployeeDepartmentHistoryProviderBase ( string url ) : System
url string The url to the nettiers webservice.
return System