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

This class is the webservice client implementation that exposes CRUD methods for Nettiers.AdventureWorks.Entities.SalesTerritoryHistory objects.
Inheritance: SalesTerritoryHistoryProviderBase
Exibir arquivo 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.SalesTerritoryHistory object will be updated to refelect any changes made by the datasource. (ie: identity or computed columns)

Convert ( Nettiers outItem, WsProxy item ) : SalesTerritoryHistory

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

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

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

Convert a collection from to a nettiers collection to a the ws proxy collection.
Delete ( TransactionManager transactionManager, System _salesPersonId, System _startDate, System _territoryId ) : 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.
GetByRowguid ( TransactionManager transactionManager, System _rowguid, int start, int pageLength, int &count ) : SalesTerritoryHistory

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

Gets rows from the datasource based on the FK_SalesTerritoryHistory_SalesPerson_SalesPersonID key. FK_SalesTerritoryHistory_SalesPerson_SalesPersonID Description: Foreign key constraint referencing SalesPerson.SalesPersonID.
GetBySalesPersonIdStartDateTerritoryId ( TransactionManager transactionManager, System _salesPersonId, System _startDate, System _territoryId, int start, int pageLength, int &count ) : SalesTerritoryHistory

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

Gets rows from the datasource based on the FK_SalesTerritoryHistory_SalesTerritory_TerritoryID key. FK_SalesTerritoryHistory_SalesTerritory_TerritoryID Description: Foreign key constraint referencing SalesTerritory.TerritoryID.
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.SalesTerritoryHistory object into the datasource using a transaction.
Update ( TransactionManager transactionManager, Nettiers entity ) : bool

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

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

Creates a new WsSalesTerritoryHistoryProviderBase 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.SalesTerritoryHistory 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 ) : SalesTerritoryHistory
outItem Nettiers
item WsProxy
return Nettiers.AdventureWorks.Entities.SalesTerritoryHistory

Convert() public static method

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

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.SalesTerritoryHistory
item Nettiers
return WsProxy.SalesTerritoryHistory

Convert() public static method

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

Delete() public method

Deletes based on primary key(s).
public Delete ( TransactionManager transactionManager, System _salesPersonId, System _startDate, System _territoryId ) : bool
transactionManager TransactionManager object
_salesPersonId System
_startDate System
_territoryId 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

GetByRowguid() public method

Gets rows from the datasource based on the AK_SalesTerritoryHistory_rowguid index.
public GetByRowguid ( TransactionManager transactionManager, System _rowguid, int start, int pageLength, int &count ) : SalesTerritoryHistory
transactionManager TransactionManager object
_rowguid System ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
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.SalesTerritoryHistory

GetBySalesPersonId() public method

Gets rows from the datasource based on the FK_SalesTerritoryHistory_SalesPerson_SalesPersonID key. FK_SalesTerritoryHistory_SalesPerson_SalesPersonID Description: Foreign key constraint referencing SalesPerson.SalesPersonID.
public GetBySalesPersonId ( TransactionManager transactionManager, System _salesPersonId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
_salesPersonId System Primary key for SalesTerritoryHistory records.
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

GetBySalesPersonIdStartDateTerritoryId() public method

Gets rows from the datasource based on the PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID index.
public GetBySalesPersonIdStartDateTerritoryId ( TransactionManager transactionManager, System _salesPersonId, System _startDate, System _territoryId, int start, int pageLength, int &count ) : SalesTerritoryHistory
transactionManager TransactionManager object
_salesPersonId System Primary key for SalesTerritoryHistory records.
_startDate System Date the sales representive started work in the territory.
_territoryId System Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
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.SalesTerritoryHistory

GetByTerritoryId() public method

Gets rows from the datasource based on the FK_SalesTerritoryHistory_SalesTerritory_TerritoryID key. FK_SalesTerritoryHistory_SalesTerritory_TerritoryID Description: Foreign key constraint referencing SalesTerritory.TerritoryID.
public GetByTerritoryId ( TransactionManager transactionManager, System _territoryId, int start, int pageLength, int &count ) : Nettiers.AdventureWorks.Entities.TList
transactionManager TransactionManager object
_territoryId System Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
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.SalesTerritoryHistory object into the datasource using a transaction.
public Insert ( TransactionManager transactionManager, Nettiers entity ) : bool
transactionManager TransactionManager object
entity Nettiers Nettiers.AdventureWorks.Entities.SalesTerritoryHistory 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.SalesTerritoryHistory object to update.
return bool

WsSalesTerritoryHistoryProviderBase() public method

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

WsSalesTerritoryHistoryProviderBase() public method

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