/// <summary>
/// Gets rows from the datasource based on the PK_EmployeePayHistory_EmployeeID_RateChangeDate index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_employeeId">Employee identification number. Foreign key to Employee.EmployeeID.</param>
/// <param name="_rateChangeDate">Date the change in pay is effective</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.EmployeePayHistory"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.EmployeePayHistory GetByEmployeeIdRateChangeDate(TransactionManager transactionManager, System.Int32 _employeeId, System.DateTime _rateChangeDate, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.EmployeePayHistory items = proxy.EmployeePayHistoryProvider_GetByEmployeeIdRateChangeDate(_employeeId, _rateChangeDate, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_PurchaseOrderHeader_ShipMethod_ShipMethodID key.
/// FK_PurchaseOrderHeader_ShipMethod_ShipMethodID Description: Foreign key constraint referencing ShipMethod.ShipMethodID.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_shipMethodId">Shipping method. Foreign key to ShipMethod.ShipMethodID.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.PurchaseOrderHeader objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList <PurchaseOrderHeader> GetByShipMethodId(TransactionManager transactionManager, System.Int32 _shipMethodId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.PurchaseOrderHeader[] items = proxy.PurchaseOrderHeaderProvider_GetByShipMethodId(_shipMethodId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_BillOfMaterials_Product_ComponentID key.
/// FK_BillOfMaterials_Product_ComponentID Description: Foreign key constraint referencing Product.ComponentID.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_componentId">Component identification number. Foreign key to Product.ProductID.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.BillOfMaterials objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList <BillOfMaterials> GetByComponentId(TransactionManager transactionManager, System.Int32 _componentId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.BillOfMaterials[] items = proxy.BillOfMaterialsProvider_GetByComponentId(_componentId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_productAssemblyId">Parent product identification number. Foreign key to Product.ProductID.</param>
/// <param name="_componentId">Component identification number. Foreign key to Product.ProductID.</param>
/// <param name="_startDate">Date the component started being used in the assembly item.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.BillOfMaterials"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.BillOfMaterials GetByProductAssemblyIdComponentIdStartDate(TransactionManager transactionManager, System.Int32?_productAssemblyId, System.Int32 _componentId, System.DateTime _startDate, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.BillOfMaterials items = proxy.BillOfMaterialsProvider_GetByProductAssemblyIdComponentIdStartDate(_productAssemblyId, _componentId, _startDate, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_addressLine1">First street address line.</param>
/// <param name="_addressLine2">Second street address line.</param>
/// <param name="_city">Name of the city.</param>
/// <param name="_stateProvinceId">Unique identification number for the state or province. Foreign key to StateProvince table.</param>
/// <param name="_postalCode">Postal code for the street address.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.Address"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.Address GetByAddressLine1AddressLine2CityStateProvinceIdPostalCode(TransactionManager transactionManager, System.String _addressLine1, System.String _addressLine2, System.String _city, System.Int32 _stateProvinceId, System.String _postalCode, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Address items = proxy.AddressProvider_GetByAddressLine1AddressLine2CityStateProvinceIdPostalCode(_addressLine1, _addressLine2, _city, _stateProvinceId, _postalCode, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_AWBuildVersion_SystemInformationID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_systemInformationId">Primary key for AWBuildVersion records.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.AwBuildVersion"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.AwBuildVersion GetBySystemInformationId(TransactionManager transactionManager, System.Byte _systemInformationId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.AwBuildVersion items = proxy.AwBuildVersionProvider_GetBySystemInformationId(_systemInformationId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PXML_Individual_Demographics index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_demographics">Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<Individual>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList <Individual> GetByDemographics(TransactionManager transactionManager, string _demographics, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Individual[] items = proxy.IndividualProvider_GetByDemographics(_demographics, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_salesPersonId">Primary key for SalesTerritoryHistory records.</param>
/// <param name="_startDate">Date the sales representive started work in the territory.</param>
/// <param name="_territoryId">Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.SalesTerritoryHistory"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.SalesTerritoryHistory GetBySalesPersonIdStartDateTerritoryId(TransactionManager transactionManager, System.Int32 _salesPersonId, System.DateTime _startDate, System.Int32 _territoryId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.SalesTerritoryHistory items = proxy.SalesTerritoryHistoryProvider_GetBySalesPersonIdStartDateTerritoryId(_salesPersonId, _startDate, _territoryId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_SalesOrderHeader_rowguid index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_rowguid">ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.SalesOrderHeader"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.SalesOrderHeader GetByRowguid(TransactionManager transactionManager, System.Guid _rowguid, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.SalesOrderHeader items = proxy.SalesOrderHeaderProvider_GetByRowguid(_rowguid, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PXML_Contact_AddContact index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_additionalContactInfo">Additional contact information about the person stored in xml format. </param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<Contact>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList <Contact> GetByAdditionalContactInfo(TransactionManager transactionManager, string _additionalContactInfo, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Contact[] items = proxy.ContactProvider_GetByAdditionalContactInfo(_additionalContactInfo, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets All rows from the DataSource a specific predicate filter.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of VProductModelInstructions objects.</returns>
public override VList <VProductModelInstructions> GetAll(TransactionManager transactionManager, int start, int pageLength)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = this.url;
WsProxy.VProductModelInstructions[] items = proxy.VProductModelInstructionsProvider_GetAll(start, pageLength);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_workOrderId">Primary key. Foreign key to WorkOrder.WorkOrderID.</param>
/// <param name="_productId">Primary key. Foreign key to Product.ProductID.</param>
/// <param name="_operationSequence">Primary key. Indicates the manufacturing process sequence.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.WorkOrderRouting"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.WorkOrderRouting GetByWorkOrderIdProductIdOperationSequence(TransactionManager transactionManager, System.Int32 _workOrderId, System.Int32 _productId, System.Int16 _operationSequence, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.WorkOrderRouting items = proxy.WorkOrderRoutingProvider_GetByWorkOrderIdProductIdOperationSequence(_workOrderId, _productId, _operationSequence, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_referenceOrderId">Purchase order, sales order, or work order identification number.</param>
/// <param name="_referenceOrderLineId">Line number associated with the purchase order, sales order, or work order.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<TransactionHistory>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList <TransactionHistory> GetByReferenceOrderIdReferenceOrderLineId(TransactionManager transactionManager, System.Int32 _referenceOrderId, System.Int32 _referenceOrderLineId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.TransactionHistory[] items = proxy.TransactionHistoryProvider_GetByReferenceOrderIdReferenceOrderLineId(_referenceOrderId, _referenceOrderLineId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the IX_JobCandidate_EmployeeID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_employeeId">Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<JobCandidate>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList <JobCandidate> GetByEmployeeId(TransactionManager transactionManager, System.Int32?_employeeId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.JobCandidate[] items = proxy.JobCandidateProvider_GetByEmployeeId(_employeeId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_WorkOrderRouting_Location_LocationID key.
/// FK_WorkOrderRouting_Location_LocationID Description: Foreign key constraint referencing Location.LocationID.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_locationId">Manufacturing location where the part is processed. Foreign key to Location.LocationID.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.WorkOrderRouting objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList <WorkOrderRouting> GetByLocationId(TransactionManager transactionManager, System.Int16 _locationId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.WorkOrderRouting[] items = proxy.WorkOrderRoutingProvider_GetByLocationId(_locationId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_Culture_Name index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_name">Culture description.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.Culture"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.Culture GetByName(TransactionManager transactionManager, System.String _name, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Culture items = proxy.CultureProvider_GetByName(_name, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the IX_ShoppingCartItem_ShoppingCartID_ProductID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_shoppingCartId">Shopping cart identification number.</param>
/// <param name="_productId">Product ordered. Foreign key to Product.ProductID.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<ShoppingCartItem>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList <ShoppingCartItem> GetByShoppingCartIdProductId(TransactionManager transactionManager, System.String _shoppingCartId, System.Int32 _productId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ShoppingCartItem[] items = proxy.ShoppingCartItemProvider_GetByShoppingCartIdProductId(_shoppingCartId, _productId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_Product_UnitMeasure_WeightUnitMeasureCode key.
/// FK_Product_UnitMeasure_WeightUnitMeasureCode Description: Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_weightUnitMeasureCode">Unit of measure for Weight column.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.Product objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList <Product> GetByWeightUnitMeasureCode(TransactionManager transactionManager, System.String _weightUnitMeasureCode, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Product[] items = proxy.ProductProvider_GetByWeightUnitMeasureCode(_weightUnitMeasureCode, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_SalesTaxRate_StateProvinceID_TaxType index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_stateProvinceId">State, province, or country/region the sales tax applies to.</param>
/// <param name="_taxType">1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.SalesTaxRate"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.SalesTaxRate GetByStateProvinceIdTaxType(TransactionManager transactionManager, System.Int32 _stateProvinceId, System.Byte _taxType, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.SalesTaxRate items = proxy.SalesTaxRateProvider_GetByStateProvinceIdTaxType(_stateProvinceId, _taxType, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_ProductCategory_ProductCategoryID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_productCategoryId">Primary key for ProductCategory records.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.ProductCategory"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.ProductCategory GetByProductCategoryId(TransactionManager transactionManager, System.Int32 _productCategoryId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ProductCategory items = proxy.ProductCategoryProvider_GetByProductCategoryId(_productCategoryId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_ProductModelProductDescriptionCulture_Culture_CultureID key.
/// FK_ProductModelProductDescriptionCulture_Culture_CultureID Description: Foreign key constraint referencing Culture.CultureID.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_cultureId">Culture identification number. Foreign key to Culture.CultureID.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.ProductModelProductDescriptionCulture objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList <ProductModelProductDescriptionCulture> GetByCultureId(TransactionManager transactionManager, System.String _cultureId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ProductModelProductDescriptionCulture[] items = proxy.ProductModelProductDescriptionCultureProvider_GetByCultureId(_cultureId, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_currencyRateDate">Date and time the exchange rate was obtained.</param>
/// <param name="_fromCurrencyCode">Exchange rate was converted from this currency code.</param>
/// <param name="_toCurrencyCode">Exchange rate was converted to this currency code.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.CurrencyRate"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.CurrencyRate GetByCurrencyRateDateFromCurrencyCodeToCurrencyCode(TransactionManager transactionManager, System.DateTime _currencyRateDate, System.String _fromCurrencyCode, System.String _toCurrencyCode, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.CurrencyRate items = proxy.CurrencyRateProvider_GetByCurrencyRateDateFromCurrencyCodeToCurrencyCode(_currencyRateDate, _fromCurrencyCode, _toCurrencyCode, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Deletes a row from the DataSource.
/// </summary>
/// <param name="_databaseLogId">Primary key for DatabaseLog records.. Primary Key.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <remarks>Deletes based on primary key(s).</remarks>
/// <returns>Returns true if operation suceeded.</returns>
public override bool Delete(TransactionManager transactionManager, System.Int32 _databaseLogId)
{
try
{
// call the proxy
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
bool result = proxy.DatabaseLogProvider_Delete(_databaseLogId);
return(result);
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets Vendor objects from the datasource by ContactID in the
/// VendorContact table. Table Vendor is related to table Contact
/// through the (M:N) relationship defined in the VendorContact table.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="_contactId">Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Vendor objects.</returns>
public override TList <Vendor> GetByContactIdFromVendorContact(TransactionManager transactionManager, System.Int32 _contactId, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Vendor[] items = proxy.VendorProvider_GetByContactIdFromVendorContact(_contactId, start, pagelen, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Inserts a Nettiers.AdventureWorks.Entities.DatabaseLog object into the datasource using a transaction.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">Nettiers.AdventureWorks.Entities.DatabaseLog object to insert.</param>
/// <remarks></remarks>
/// <returns>Returns true if operation is successful.</returns>
public override bool Insert(TransactionManager transactionManager, Nettiers.AdventureWorks.Entities.DatabaseLog entity)
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
try
{
WsProxy.DatabaseLog result = proxy.DatabaseLogProvider_Insert(Convert(entity));
Convert(entity, result);
return(true);
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets Illustration objects from the datasource by ProductModelID in the
/// ProductModelIllustration table. Table Illustration is related to table ProductModel
/// through the (M:N) relationship defined in the ProductModelIllustration table.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="_productModelId">Primary key. Foreign key to ProductModel.ProductModelID.</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Illustration objects.</returns>
public override TList <Illustration> GetByProductModelIdFromProductModelIllustration(TransactionManager transactionManager, System.Int32 _productModelId, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Illustration[] items = proxy.IllustrationProvider_GetByProductModelIdFromProductModelIllustration(_productModelId, start, pagelen, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Deletes a row from the DataSource.
/// </summary>
/// <param name="_productId">Product identification number. Foreign key to Product.ProductID. Primary Key.</param>
/// <param name="_startDate">Product cost start date.. Primary Key.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <remarks>Deletes based on primary key(s).</remarks>
/// <returns>Returns true if operation suceeded.</returns>
public override bool Delete(TransactionManager transactionManager, System.Int32 _productId, System.DateTime _startDate)
{
try
{
// call the proxy
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
bool result = proxy.ProductCostHistoryProvider_Delete(_productId, _startDate);
return(result);
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets All rows from the DataSource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.DatabaseLog objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList <DatabaseLog> GetAll(TransactionManager transactionManager, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.DatabaseLog[] items = proxy.DatabaseLogProvider_GetAll(start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets All rows from the DataSource by a specific predicate filter.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="whereClause">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').</param>
/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="count">Number of total rows.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of VEmployee objects.</returns>
public override VList <VEmployee> Get(TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = this.url;
WsProxy.VEmployee[] items = proxy.VEmployeeProvider_Get(whereClause, orderBy, start, pageLength, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Returns rows meeting the whereclause condition from the DataSource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="whereClause">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').</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks>Operators must be capitalized (OR, AND)</remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.ScrapReason objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList <ScrapReason> Find(TransactionManager transactionManager, string whereClause, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ScrapReason[] items = proxy.ScrapReasonProvider_Find(whereClause, start, pagelen, out count);
return(Convert(items));
}
catch (SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets TestIssue117TableA objects from the datasource by TestIssue117TableBId in the
/// TestIssue117TableC table. Table TestIssue117TableA is related to table TestIssue117TableB
/// through the (M:N) relationship defined in the TestIssue117TableC table.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="_testIssue117TableBid"></param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of TestIssue117TableA objects.</returns>
public override TList<TestIssue117Tablea> GetByTestIssue117TableBidFromTestIssue117Tablec(TransactionManager transactionManager, System.Int32 _testIssue117TableBid, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.TestIssue117Tablea[] items = proxy.TestIssue117TableaProvider_GetByTestIssue117TableBidFromTestIssue117Tablec(_testIssue117TableBid, start, pagelen, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_NullFKeyChild_NullFKeyParent key.
/// FK_NullFKeyChild_NullFKeyParent Description:
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_nullFkeyParentId"></param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.NullFkeyChild objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList<NullFkeyChild> GetByNullFkeyParentId(TransactionManager transactionManager, System.Int32? _nullFkeyParentId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.NullFkeyChild[] items = proxy.NullFkeyChildProvider_GetByNullFkeyParentId(_nullFkeyParentId, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PXML_ProductModel_Instructions index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_instructions">Manufacturing instructions in xml format.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<ProductModel>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList<ProductModel> GetByInstructions(TransactionManager transactionManager, string _instructions, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ProductModel[] items = proxy.ProductModelProvider_GetByInstructions(_instructions, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_referenceOrderId">Purchase order, sales order, or work order identification number.</param>
/// <param name="_referenceOrderLineId">Line number associated with the purchase order, sales order, or work order.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<TransactionHistoryArchive>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList<TransactionHistoryArchive> GetByReferenceOrderIdReferenceOrderLineId(TransactionManager transactionManager, System.Int32 _referenceOrderId, System.Int32 _referenceOrderLineId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.TransactionHistoryArchive[] items = proxy.TransactionHistoryArchiveProvider_GetByReferenceOrderIdReferenceOrderLineId(_referenceOrderId, _referenceOrderLineId, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the IX_ProductReview_ProductID_Name index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_productId">Product identification number. Foreign key to Product.ProductID.</param>
/// <param name="_reviewerName">Name of the reviewer.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TList<ProductReview>"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TList<ProductReview> GetByProductIdReviewerName(TransactionManager transactionManager, System.Int32 _productId, System.String _reviewerName, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ProductReview[] items = proxy.ProductReviewProvider_GetByProductIdReviewerName(_productId, _reviewerName, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Lets you efficiently bulk many entity to the database.
/// </summary>
/// <param name="transactionManager">NOTE: The transaction manager should be null for the web service client implementation.</param>
/// <param name="entityList">The entities.</param>
/// <remarks>
/// After inserting into the datasource, the Nettiers.AdventureWorks.Entities.ErrorLog object will be updated
/// to refelect any changes made by the datasource. (ie: identity or computed columns)
/// </remarks>
public override void BulkInsert(TransactionManager transactionManager, Nettiers.AdventureWorks.Entities.TList<ErrorLog> entityList)
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
try
{
proxy.ErrorLogProvider_BulkInsert(Convert(entityList));
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets a page of rows from the DataSource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="whereClause">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').</param>
/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.ErrorLog objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList<ErrorLog> GetPaged(TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength, out int count)
{
try
{
whereClause = whereClause ?? string.Empty;
orderBy = orderBy ?? string.Empty;
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ErrorLog[] items = proxy.ErrorLogProvider_GetPaged(whereClause, orderBy, start, pageLength, out count);
// Create a collection and fill it with the dataset
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Deletes a row from the DataSource.
/// </summary>
/// <param name="_errorLogId">Primary key for ErrorLog records.. Primary Key.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <remarks>Deletes based on primary key(s).</remarks>
/// <returns>Returns true if operation suceeded.</returns>
public override bool Delete(TransactionManager transactionManager, System.Int32 _errorLogId)
{
try
{
// call the proxy
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
bool result = proxy.ErrorLogProvider_Delete(_errorLogId);
return result;
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Deletes a row from the DataSource.
/// </summary>
/// <param name="_countryRegionCode">ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.. Primary Key.</param>
/// <param name="_currencyCode">ISO standard currency code. Foreign key to Currency.CurrencyCode.. Primary Key.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <remarks>Deletes based on primary key(s).</remarks>
/// <returns>Returns true if operation suceeded.</returns>
public override bool Delete(TransactionManager transactionManager, System.String _countryRegionCode, System.String _currencyCode)
{
try
{
// call the proxy
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
bool result = proxy.CountryRegionCurrencyProvider_Delete(_countryRegionCode, _currencyCode);
return result;
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID key.
/// FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID Description: Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_specialOfferId">Promotional code. Foreign key to SpecialOffer.SpecialOfferID.</param>
/// <param name="_productId">Product sold to customer. Foreign key to Product.ProductID.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.SalesOrderDetail objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList<SalesOrderDetail> GetBySpecialOfferIdProductId(TransactionManager transactionManager, System.Int32 _specialOfferId, System.Int32 _productId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.SalesOrderDetail[] items = proxy.SalesOrderDetailProvider_GetBySpecialOfferIdProductId(_specialOfferId, _productId, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets ProductModel objects from the datasource by ProductDescriptionID in the
/// ProductModelProductDescriptionCulture table. Table ProductModel is related to table ProductDescription
/// through the (M:N) relationship defined in the ProductModelProductDescriptionCulture table.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="_productDescriptionId">Primary key. Foreign key to ProductDescription.ProductDescriptionID.</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of ProductModel objects.</returns>
public override TList<ProductModel> GetByProductDescriptionIdFromProductModelProductDescriptionCulture(TransactionManager transactionManager, System.Int32 _productDescriptionId, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ProductModel[] items = proxy.ProductModelProvider_GetByProductDescriptionIdFromProductModelProductDescriptionCulture(_productDescriptionId, start, pagelen, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets All rows from the DataSource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.StateProvince objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList<StateProvince> GetAll(TransactionManager transactionManager, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.StateProvince[] items = proxy.StateProvinceProvider_GetAll(start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Deletes a row from the DataSource.
/// </summary>
/// <param name="_employeeId">Employee identification number. Foreign key to Employee.EmployeeID.. Primary Key.</param>
/// <param name="_startDate">Date the employee started work in the department.. Primary Key.</param>
/// <param name="_departmentId">Department in which the employee worked including currently. Foreign key to Department.DepartmentID.. Primary Key.</param>
/// <param name="_shiftId">Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.. Primary Key.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <remarks>Deletes based on primary key(s).</remarks>
/// <returns>Returns true if operation suceeded.</returns>
public override bool Delete(TransactionManager transactionManager, System.Int32 _employeeId, System.DateTime _startDate, System.Int16 _departmentId, System.Byte _shiftId)
{
try
{
// call the proxy
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
bool result = proxy.EmployeeDepartmentHistoryProvider_Delete(_employeeId, _startDate, _departmentId, _shiftId);
return result;
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets CountryRegion objects from the datasource by CurrencyCode in the
/// CountryRegionCurrency table. Table CountryRegion is related to table Currency
/// through the (M:N) relationship defined in the CountryRegionCurrency table.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="_currencyCode">ISO standard currency code. Foreign key to Currency.CurrencyCode.</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of CountryRegion objects.</returns>
public override TList<CountryRegion> GetByCurrencyCodeFromCountryRegionCurrency(TransactionManager transactionManager, System.String _currencyCode, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.CountryRegion[] items = proxy.CountryRegionProvider_GetByCurrencyCodeFromCountryRegionCurrency(_currencyCode, start, pagelen, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_SalesOrderDetail_rowguid index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_rowguid">ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.SalesOrderDetail"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.SalesOrderDetail GetByRowguid(TransactionManager transactionManager, System.Guid _rowguid, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.SalesOrderDetail items = proxy.SalesOrderDetailProvider_GetByRowguid(_rowguid, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_employeeId">Employee identification number. Foreign key to Employee.EmployeeID.</param>
/// <param name="_startDate">Date the employee started work in the department.</param>
/// <param name="_departmentId">Department in which the employee worked including currently. Foreign key to Department.DepartmentID.</param>
/// <param name="_shiftId">Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.EmployeeDepartmentHistory GetByEmployeeIdStartDateDepartmentIdShiftId(TransactionManager transactionManager, System.Int32 _employeeId, System.DateTime _startDate, System.Int16 _departmentId, System.Byte _shiftId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.EmployeeDepartmentHistory items = proxy.EmployeeDepartmentHistoryProvider_GetByEmployeeIdStartDateDepartmentIdShiftId(_employeeId, _startDate, _departmentId, _shiftId, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_StateProvince_StateProvinceCode_CountryRegionCode index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_stateProvinceCode">ISO standard state or province code.</param>
/// <param name="_countryRegionCode">ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. </param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.StateProvince"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.StateProvince GetByStateProvinceCodeCountryRegionCode(TransactionManager transactionManager, System.String _stateProvinceCode, System.String _countryRegionCode, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.StateProvince items = proxy.StateProvinceProvider_GetByStateProvinceCodeCountryRegionCode(_stateProvinceCode, _countryRegionCode, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the AK_ProductSubcategory_Name index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_name">Subcategory description.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.ProductSubcategory"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.ProductSubcategory GetByName(TransactionManager transactionManager, System.String _name, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ProductSubcategory items = proxy.ProductSubcategoryProvider_GetByName(_name, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets a page of rows from the DataSource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="whereClause">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').</param>
/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of VIndividualDemographics objects.</returns>
public override VList<VIndividualDemographics> Get(TransactionManager transactionManager, string whereClause, string orderBy, int start, int pageLength)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = this.url;
int count;
WsProxy.VIndividualDemographics[] items = proxy.VIndividualDemographicsProvider_Get(whereClause, orderBy, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets Store objects from the datasource by ContactID in the
/// StoreContact table. Table Store is related to table Contact
/// through the (M:N) relationship defined in the StoreContact table.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="_contactId">Contact (store employee) identification number. Foreign key to Contact.ContactID.</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Store objects.</returns>
public override TList<Store> GetByContactIdFromStoreContact(TransactionManager transactionManager, System.Int32 _contactId, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.Store[] items = proxy.StoreProvider_GetByContactIdFromStoreContact(_contactId, start, pagelen, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets All rows from the DataSource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="count">count of records returned</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of VJobCandidateEducation objects.</returns>
public override VList<VJobCandidateEducation> GetAll(TransactionManager transactionManager, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = this.url;
WsProxy.VJobCandidateEducation[] items = proxy.VJobCandidateEducationProvider_GetAll(start, pageLength);
count = items.Length;
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the FK_PurchaseOrderHeader_ShipMethod_ShipMethodID key.
/// FK_PurchaseOrderHeader_ShipMethod_ShipMethodID Description: Foreign key constraint referencing ShipMethod.ShipMethodID.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="_shipMethodId">Shipping method. Foreign key to ShipMethod.ShipMethodID.</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.PurchaseOrderHeader objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList<PurchaseOrderHeader> GetByShipMethodId(TransactionManager transactionManager, System.Int32 _shipMethodId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.PurchaseOrderHeader[] items = proxy.PurchaseOrderHeaderProvider_GetByShipMethodId(_shipMethodId, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Inserts a Nettiers.AdventureWorks.Entities.ProductReview object into the datasource using a transaction.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">Nettiers.AdventureWorks.Entities.ProductReview object to insert.</param>
/// <remarks></remarks>
/// <returns>Returns true if operation is successful.</returns>
public override bool Insert(TransactionManager transactionManager, Nettiers.AdventureWorks.Entities.ProductReview entity)
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
try
{
WsProxy.ProductReview result = proxy.ProductReviewProvider_Insert(Convert(entity));
Convert(entity, result);
return true;
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets All rows from the DataSource a specific predicate filter.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <remarks></remarks>
/// <returns>Returns a typed collection of VVendor objects.</returns>
public override VList<VVendor> GetAll(TransactionManager transactionManager, int start, int pageLength)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = this.url;
WsProxy.VVendor[] items = proxy.VVendorProvider_GetAll(start, pageLength);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Returns rows meeting the whereclause condition from the DataSource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pagelen">Number of rows to return.</param>
/// <param name="whereClause">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').</param>
/// <param name="count">Number of rows in the DataSource.</param>
/// <remarks>Operators must be capitalized (OR, AND)</remarks>
/// <returns>Returns a typed collection of Nettiers.AdventureWorks.Entities.ErrorLog objects.</returns>
public override Nettiers.AdventureWorks.Entities.TList<ErrorLog> Find(TransactionManager transactionManager, string whereClause, int start, int pagelen, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ErrorLog[] items = proxy.ErrorLogProvider_Find(whereClause, start, pagelen, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_TestIssue117TableC index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_testIssue117TableAid"></param>
/// <param name="_testIssue117TableBid"></param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.TestIssue117Tablec"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.TestIssue117Tablec GetByTestIssue117TableAidTestIssue117TableBid(TransactionManager transactionManager, System.Int32 _testIssue117TableAid, System.Int32 _testIssue117TableBid, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.TestIssue117Tablec items = proxy.TestIssue117TablecProvider_GetByTestIssue117TableAidTestIssue117TableBid(_testIssue117TableAid, _testIssue117TableBid, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_ErrorLog_ErrorLogID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_errorLogId">Primary key for ErrorLog records.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.ErrorLog"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.ErrorLog GetByErrorLogId(TransactionManager transactionManager, System.Int32 _errorLogId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.ErrorLog items = proxy.ErrorLogProvider_GetByErrorLogId(_errorLogId, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Deletes a row from the DataSource.
/// </summary>
/// <param name="_salesPersonId">Primary key for SalesTerritoryHistory records.. Primary Key.</param>
/// <param name="_startDate">Date the sales representive started work in the territory.. Primary Key.</param>
/// <param name="_territoryId">Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.. Primary Key.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <remarks>Deletes based on primary key(s).</remarks>
/// <returns>Returns true if operation suceeded.</returns>
public override bool Delete(TransactionManager transactionManager, System.Int32 _salesPersonId, System.DateTime _startDate, System.Int32 _territoryId)
{
try
{
// call the proxy
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
bool result = proxy.SalesTerritoryHistoryProvider_Delete(_salesPersonId, _startDate, _territoryId);
return result;
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Update an existing row in the datasource.
/// </summary>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">Nettiers.AdventureWorks.Entities.ErrorLog object to update.</param>
/// <remarks></remarks>
/// <returns>Returns true if operation is successful.</returns>
public override bool Update(TransactionManager transactionManager, Nettiers.AdventureWorks.Entities.ErrorLog entity)
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
try
{
WsProxy.ErrorLog result = proxy.ErrorLogProvider_Update(Convert(entity));
Convert(entity, result);
entity.AcceptChanges();
return true;
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
/// <summary>
/// Gets rows from the datasource based on the PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID index.
/// </summary>
/// <param name="start">Row number at which to start reading.</param>
/// <param name="pageLength">Number of rows to return.</param>
/// <param name="_salesPersonId">Primary key for SalesTerritoryHistory records.</param>
/// <param name="_startDate">Date the sales representive started work in the territory.</param>
/// <param name="_territoryId">Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.</param>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="count">out parameter to get total records for query</param>
/// <remarks></remarks>
/// <returns>Returns an instance of the <see cref="Nettiers.AdventureWorks.Entities.SalesTerritoryHistory"/> class.</returns>
public override Nettiers.AdventureWorks.Entities.SalesTerritoryHistory GetBySalesPersonIdStartDateTerritoryId(TransactionManager transactionManager, System.Int32 _salesPersonId, System.DateTime _startDate, System.Int32 _territoryId, int start, int pageLength, out int count)
{
try
{
WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
proxy.Url = Url;
WsProxy.SalesTerritoryHistory items = proxy.SalesTerritoryHistoryProvider_GetBySalesPersonIdStartDateTerritoryId(_salesPersonId, _startDate, _territoryId, start, pageLength, out count);
return Convert(items);
}
catch(SoapException soex)
{
System.Diagnostics.Debug.WriteLine(soex);
throw soex;
}
catch(Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
throw ex;
}
}
