Sage.Integration.Northwind.Application.Entities.Product.DataSets.ProductTableAdapters.ProductsTableAdapter.FillBy C# (CSharp) Method

        public virtual int FillBy(Product.ProductsDataTable dataTable, int ProductID) {
            this.Adapter.SelectCommand = this.CommandCollection[1];
            this.Adapter.SelectCommand.Parameters[0].Value = ((int)(ProductID));
            if ((this.ClearBeforeFill == true)) {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);
            return returnValue;
        }
        

        public override Document GetDocument(Identity identity, Token lastToken, NorthwindConfig config)
        {
            int recordCount;

            DataSets.Product product = new DataSets.Product();
            int priceID;

            priceID = Identity.GetId(identity);


            using (OleDbConnection connection = new OleDbConnection(config.ConnectionString))
            {
                DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter;
                tableAdapter            = new DataSets.ProductTableAdapters.ProductsTableAdapter();
                tableAdapter.Connection = connection;
                recordCount             = tableAdapter.FillBy(product.Products, priceID);
            }

            if (recordCount == 0)
            {
                return(GetDeletedDocument(identity));
            }

            return(GetDocument((DataSets.Product.ProductsRow)product.Products[0], lastToken, config));
        }