/// <summary>
        /// Convert a collection from  to a nettiers collection to a the ws proxy collection.
        /// </summary>
        public static WsProxy.SpecialOfferProduct[] Convert(Nettiers.AdventureWorks.Entities.TList <SpecialOfferProduct> items)
        {
            WsProxy.SpecialOfferProduct[] outItems = new WsProxy.SpecialOfferProduct[items.Count];
            int count = 0;

            foreach (Nettiers.AdventureWorks.Entities.SpecialOfferProduct item in items)
            {
                outItems[count++] = Convert(item);
            }
            return(outItems);
        }
        /// <summary>
        /// Convert a nettiers entity to the ws proxy entity.
        /// </summary>
        public static WsProxy.SpecialOfferProduct Convert(Nettiers.AdventureWorks.Entities.SpecialOfferProduct item)
        {
            WsProxy.SpecialOfferProduct outItem = new WsProxy.SpecialOfferProduct();
            outItem.SpecialOfferId = item.SpecialOfferId;
            outItem.ProductId      = item.ProductId;
            outItem.Rowguid        = item.Rowguid;
            outItem.ModifiedDate   = item.ModifiedDate;

            outItem.OriginalSpecialOfferId = item.OriginalSpecialOfferId;
            outItem.OriginalProductId      = item.OriginalProductId;

            return(outItem);
        }
        /// <summary>
        ///     Gets rows from the datasource based on the PK_SpecialOfferProduct_SpecialOfferID_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="_specialOfferId">Primary key for SpecialOfferProduct records.</param>
        /// <param name="_productId">Product identification number. 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.SpecialOfferProduct"/> class.</returns>
        public override Nettiers.AdventureWorks.Entities.SpecialOfferProduct 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.SpecialOfferProduct items = proxy.SpecialOfferProductProvider_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>
        ///     Inserts a Nettiers.AdventureWorks.Entities.SpecialOfferProduct object into the datasource using a transaction.
        /// </summary>
        /// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
        /// <param name="entity">Nettiers.AdventureWorks.Entities.SpecialOfferProduct object to insert.</param>
        /// <remarks></remarks>
        /// <returns>Returns true if operation is successful.</returns>
        public override bool Insert(TransactionManager transactionManager, Nettiers.AdventureWorks.Entities.SpecialOfferProduct entity)
        {
            WsProxy.AdventureWorksServices proxy = new WsProxy.AdventureWorksServices();
            proxy.Url = Url;

            try
            {
                WsProxy.SpecialOfferProduct result = proxy.SpecialOfferProductProvider_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>
		/// Convert a collection from  to a nettiers collection to a the ws proxy collection.
		/// </summary>
		public static WsProxy.SpecialOfferProduct[] Convert(Nettiers.AdventureWorks.Entities.TList<SpecialOfferProduct> items)
		{
			WsProxy.SpecialOfferProduct[] outItems = new WsProxy.SpecialOfferProduct[items.Count];
			int count = 0;
		
			foreach (Nettiers.AdventureWorks.Entities.SpecialOfferProduct item in items)
			{
				outItems[count++] = Convert(item);
			}
			return outItems;
		}
		/// <summary>
		/// Convert a nettiers entity to the ws proxy entity.
		/// </summary>
		public static WsProxy.SpecialOfferProduct Convert(Nettiers.AdventureWorks.Entities.SpecialOfferProduct item)
		{			
			WsProxy.SpecialOfferProduct outItem = new WsProxy.SpecialOfferProduct();			
			outItem.SpecialOfferId = item.SpecialOfferId;
			outItem.ProductId = item.ProductId;
			outItem.Rowguid = item.Rowguid;
			outItem.ModifiedDate = item.ModifiedDate;

			outItem.OriginalSpecialOfferId = item.OriginalSpecialOfferId;
			outItem.OriginalProductId = item.OriginalProductId;
							
			return outItem;
		}
        /// <summary>
        /// Convert a nettiers collection to the ws proxy collection.
        /// </summary>
        public static Nettiers.AdventureWorks.Entities.SpecialOfferProduct Convert(Nettiers.AdventureWorks.Entities.SpecialOfferProduct outItem, WsProxy.SpecialOfferProduct item)
        {
            if (item != null && outItem != null)
            {
                outItem.SpecialOfferId = item.SpecialOfferId;
                outItem.ProductId      = item.ProductId;
                outItem.Rowguid        = item.Rowguid;
                outItem.ModifiedDate   = item.ModifiedDate;

                outItem.OriginalSpecialOfferId = item.SpecialOfferId;
                outItem.OriginalProductId      = item.ProductId;
                outItem.AcceptChanges();
            }

            return(outItem);
        }
 /// <summary>
 /// Convert a nettiers collection to the ws proxy collection.
 /// </summary>
 public static Nettiers.AdventureWorks.Entities.SpecialOfferProduct Convert(WsProxy.SpecialOfferProduct item)
 {
     Nettiers.AdventureWorks.Entities.SpecialOfferProduct outItem = item == null ? null : new Nettiers.AdventureWorks.Entities.SpecialOfferProduct();
     Convert(outItem, item);
     return(outItem);
 }