private FillBy ( Product dataTable, int ProductID ) : int | ||
dataTable | Product | |
ProductID | int | |
return | int |
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)); }
public override Document GetDocument(Identity identity, Token lastToken, NorthwindConfig config) { int recordCount; DataSets.Product product = new DataSets.Product(); int uomId; uomId = Identity.GetId(identity); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { Sage.Integration.Northwind.Application.Entities.Product.DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; tableAdapter = new Sage.Integration.Northwind.Application.Entities.Product.DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; recordCount = tableAdapter.FillBy(product.Products, uomId); } if (recordCount == 0) { return(GetDeletedDocument(identity)); } return(GetUOMDocument((DataSets.Product.ProductsRow)product.Products[0], lastToken, config)); }
/* Update */ public override void Update(Document doc, NorthwindConfig config, ref List<TransactionResult> result) { List<TransactionResult> transactionResult = new List<TransactionResult>(); UnitOfMeasureFamilyDocument uomFamilyDoc = doc as UnitOfMeasureFamilyDocument; #region check input values if (uomFamilyDoc == null) { result.Add(doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, Resources.ErrorMessages_DocumentTypeNotSupported)); return; } // check id #endregion DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; DataSets.Product productDataset = new DataSets.Product(); DataSets.Product.ProductsRow row; tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { connection.Open(); tableAdapter.Connection = connection; int recordCount = tableAdapter.FillBy(productDataset.Products, Convert.ToInt32(uomFamilyDoc.Id)); if (recordCount == 0) { doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, "Product does not exists"); return; } row = (DataSets.Product.ProductsRow)productDataset.Products.Rows[0]; try { // active ??? // defaultvalue ??? if(!uomFamilyDoc.name.NotSet) if (uomFamilyDoc.name.IsNull) row.SetQuantityPerUnitNull(); else row.QuantityPerUnit = (string)uomFamilyDoc.name.Value; if(!uomFamilyDoc.description.NotSet) if (uomFamilyDoc.description.IsNull) row.SetProductNameNull(); else row.ProductName = (string)uomFamilyDoc.description.Value; // ModifyID row.ModifyID = config.SequenceNumber; row.ModifyUser = config.CrmUser; } catch (Exception e) { uomFamilyDoc.Id = ""; #warning Check error message result.Add(uomFamilyDoc.SetTransactionStatus(TransactionStatus.UnRecoverableError, e.ToString())); return; } tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; tableAdapter.Update(productDataset.Products); result.Add(doc.SetTransactionStatus(TransactionStatus.Success)); } }
public override Document GetDocument(Identity identity, Token lastToken, NorthwindConfig config) { int recordCount; DataSets.Product product = new DataSets.Product(); int uomFamilyId; uomFamilyId = Identity.GetId(identity); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { Sage.Integration.Northwind.Application.Entities.Product.DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; tableAdapter = new Sage.Integration.Northwind.Application.Entities.Product.DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; recordCount = tableAdapter.FillBy(product.Products, uomFamilyId); } if (recordCount == 0) return GetDeletedDocument(identity); return GetUOMFamilyDocument((DataSets.Product.ProductsRow)product.Products[0], lastToken, config); }
/* Update */ public override void Update(Document doc, NorthwindConfig config, ref List <TransactionResult> result) { List <TransactionResult> transactionResult = new List <TransactionResult>(); UnitOfMeasureDocument uomDoc = doc as UnitOfMeasureDocument; #region check input values if (uomDoc == null) { result.Add(doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, Resources.ErrorMessages_DocumentTypeNotSupported)); return; } // check id #endregion DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; DataSets.Product productDataset = new DataSets.Product(); DataSets.Product.ProductsRow row; tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { connection.Open(); tableAdapter.Connection = connection; int recordCount = tableAdapter.FillBy(productDataset.Products, Convert.ToInt32(uomDoc.Id)); if (recordCount == 0) { doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, "Product does not exists"); return; } row = (DataSets.Product.ProductsRow)productDataset.Products.Rows[0]; try { // active??? if (uomDoc.name.IsNull) { row.SetQuantityPerUnitNull(); } else { row.QuantityPerUnit = (string)uomDoc.name.Value; } // units ??? // defaultvalue ??? // familyId ??? // ModifyID row.ModifyID = config.SequenceNumber; row.ModifyUser = config.CrmUser; } catch (Exception e) { uomDoc.Id = ""; #warning Check error message result.Add(uomDoc.SetTransactionStatus(TransactionStatus.UnRecoverableError, e.ToString())); return; } tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; tableAdapter.Update(productDataset.Products); result.Add(doc.SetTransactionStatus(TransactionStatus.Success)); } }
/* Update */ public override void Update(Document doc, NorthwindConfig config, ref List <TransactionResult> result) { List <TransactionResult> transactionResult = new List <TransactionResult>(); ProductDocument productDoc = doc as ProductDocument; #region check input values if (productDoc == null) { result.Add(doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, Resources.ErrorMessages_DocumentTypeNotSupported)); return; } // check id #endregion DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; DataSets.Product productDataset = new DataSets.Product(); DataSets.Product.ProductsRow row; tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { connection.Open(); tableAdapter.Connection = connection; int recordCount = tableAdapter.FillBy(productDataset.Products, Convert.ToInt32(productDoc.Id)); if (recordCount == 0) { doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, "Product does not exists"); return; } row = (DataSets.Product.ProductsRow)productDataset.Products.Rows[0]; try { // active??? // code??? if (productDoc.name.IsNull) { row.SetProductNameNull(); } else { row.ProductName = Convert.ToString(productDoc.name.Value); } if (productDoc.productfamilyid.IsNull) { row.SetCategoryIDNull(); } else { row.CategoryID = Convert.ToInt32(productDoc.productfamilyid.Value); } // uom category ??? if (productDoc.instock.IsNull) { row.SetUnitsInStockNull(); } else { row.UnitsInStock = Convert.ToInt16(productDoc.instock.Value); } // ModifyID row.ModifyID = config.SequenceNumber; row.ModifyUser = config.CrmUser; } catch (Exception e) { productDoc.Id = ""; #warning Check error message result.Add(productDoc.SetTransactionStatus(TransactionStatus.UnRecoverableError, e.ToString())); return; } tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; tableAdapter.Update(productDataset.Products); result.Add(doc.SetTransactionStatus(TransactionStatus.Success)); } }
public Pricing CheckPrice(Pricing PricingInformation, NorthwindConfig config) { int productId = 0; int recordCount; //TODO: did we need to check if Account exists? try { productId = int.Parse(PricingInformation.ProductId); if (productId == 0) { throw new ArgumentException(); } } catch (Exception) { PricingInformation.SynchMessage = Resources.ErrorMessages_ProductNotFound; return(PricingInformation); } DataSets.Product product = new DataSets.Product(); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; recordCount = tableAdapter.FillBy(product.Products, productId); } if (recordCount == 0) { PricingInformation.SynchMessage = Resources.ErrorMessages_ProductNotFound; return(PricingInformation); } DataSets.Product.ProductsRow row = product.Products[0]; decimal listprice = row.IsUnitPriceNull() ? (decimal)0 : row.UnitPrice; PricingInformation.ListPrice = XmlConvert.ToString(listprice); PricingInformation.DiscountRate = 0; PricingInformation.Discount = 0; PricingInformation.DiscountSum = 0; if (PricingInformation.Quantity >= 10) { PricingInformation.DiscountRate = new decimal(10); PricingInformation.Discount = new decimal(10); PricingInformation.DiscountSum = listprice * new decimal(0.1); } decimal quotedPrice = listprice - PricingInformation.DiscountSum; PricingInformation.QuotedPrice = XmlConvert.ToString(quotedPrice); PricingInformation.QuotedPriceTotal = XmlConvert.ToString(PricingInformation.Quantity * quotedPrice); PricingInformation.Tax = 0; PricingInformation.TaxRate = 0; return(PricingInformation); }
/* Update */ public override void Update(Document doc, NorthwindConfig config, ref List<TransactionResult> result) { List<TransactionResult> transactionResult = new List<TransactionResult>(); PriceDocument priceDoc = doc as PriceDocument; #region check input values if (priceDoc == null) { result.Add(doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, Resources.ErrorMessages_DocumentTypeNotSupported)); return; } // check id #endregion DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; DataSets.Product productDataset = new DataSets.Product(); DataSets.Product.ProductsRow row; tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { connection.Open(); tableAdapter.Connection = connection; int recordCount = tableAdapter.FillBy(productDataset.Products, Convert.ToInt32(priceDoc.Id)); if (recordCount == 0) { doc.SetTransactionStatus(TransactionStatus.UnRecoverableError, "Product does not exists"); return; } row = (DataSets.Product.ProductsRow)productDataset.Products.Rows[0]; try { // active??? // price_cid??? // pricinglistid ??? // productid ??? // uomid ??? if (priceDoc.price.IsNull) row.SetUnitPriceNull(); else row.UnitPrice = (decimal)priceDoc.price.Value; // ModifyID row.ModifyID = config.SequenceNumber; row.ModifyUser = config.CrmUser; } catch (Exception e) { priceDoc.Id = ""; #warning Check error message result.Add(priceDoc.SetTransactionStatus(TransactionStatus.UnRecoverableError, e.ToString())); return; } tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; tableAdapter.Update(productDataset.Products); result.Add(doc.SetTransactionStatus(TransactionStatus.Success)); } }
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); }
public Pricing CheckPrice(Pricing PricingInformation, NorthwindConfig config) { int productId = 0; int recordCount; //TODO: did we need to check if Account exists? try { productId = int.Parse(PricingInformation.ProductId); if (productId == 0) throw new ArgumentException(); } catch (Exception) { PricingInformation.SynchMessage = Resources.ErrorMessages_ProductNotFound; return PricingInformation; } DataSets.Product product = new DataSets.Product(); using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { DataSets.ProductTableAdapters.ProductsTableAdapter tableAdapter; tableAdapter = new DataSets.ProductTableAdapters.ProductsTableAdapter(); tableAdapter.Connection = connection; recordCount = tableAdapter.FillBy(product.Products, productId); } if (recordCount == 0) { PricingInformation.SynchMessage = Resources.ErrorMessages_ProductNotFound; return PricingInformation; } DataSets.Product.ProductsRow row = product.Products[0]; decimal listprice = row.IsUnitPriceNull() ? (decimal)0 : row.UnitPrice; PricingInformation.ListPrice = XmlConvert.ToString(listprice); PricingInformation.DiscountRate = 0; PricingInformation.Discount = 0; PricingInformation.DiscountSum = 0; if (PricingInformation.Quantity >= 10) { PricingInformation.DiscountRate = new decimal(10); PricingInformation.Discount = new decimal(10); PricingInformation.DiscountSum = listprice * new decimal(0.1); } decimal quotedPrice = listprice - PricingInformation.DiscountSum; PricingInformation.QuotedPrice = XmlConvert.ToString(quotedPrice); PricingInformation.QuotedPriceTotal = XmlConvert.ToString(PricingInformation.Quantity * quotedPrice); PricingInformation.Tax = 0; PricingInformation.TaxRate = 0; return PricingInformation; }