| private FillBy ( Product dataTable, int ProductID ) : int | ||
| dataTable | Product | |
| ProductID | int | |
| Résultat | 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;
}
