// If your activity returns a value, derive from CodeActivity<TResult>
// and return the value from the Execute method.
protected override void Execute(CodeActivityContext context)
{
SalesOrderDetail salesDetail = SalesDetail.Get(context);
using (AdventureWorksDataContext dc = new AdventureWorksDataContext())
{
var historyRow = new TransactionHistory();
historyRow.ProductID = salesDetail.ProductID;
historyRow.ModifiedDate = DateTime.Now;
historyRow.Quantity = salesDetail.OrderQty;
historyRow.TransactionDate = salesDetail.ModifiedDate;
historyRow.TransactionType = 'S';
historyRow.ReferenceOrderID = salesDetail.SalesOrderID;
historyRow.ReferenceOrderLineID = salesDetail.SalesOrderDetailID;
dc.TransactionHistories.InsertOnSubmit(historyRow);
dc.SubmitChanges();
Console.WriteLine("Product {0}: Added history for Qty of {1} ",salesDetail.ProductID, salesDetail.OrderQty);
}
}
partial void DeleteTransactionHistory(TransactionHistory instance);
partial void UpdateTransactionHistory(TransactionHistory instance);
partial void InsertTransactionHistory(TransactionHistory instance);
private void detach_TransactionHistories(TransactionHistory entity)
{
this.SendPropertyChanging();
entity.Product = null;
}
