public bool TransactionHistoryArchiveDelete(TransactionHistoryArchive transactionhistoryarchive)
        {
            return Execute<bool>(dal =>
            {
                TransactionHistoryArchive transactionhistoryarchiveDelete = dal.TransactionHistoryArchive.Where(x => x.TransactionID == transactionhistoryarchive.TransactionID).FirstOrDefault();
                if (transactionhistoryarchiveDelete != null)
                {
                    dal.TransactionHistoryArchive.DeleteOnSubmit(transactionhistoryarchiveDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool TransactionHistoryArchiveUpdate(TransactionHistoryArchive transactionhistoryarchive)
        {
            return Execute<bool>(dal =>
            {
                TransactionHistoryArchive transactionhistoryarchiveUpdate = dal.TransactionHistoryArchive.Where(x => x.TransactionID == transactionhistoryarchive.TransactionID).FirstOrDefault();
                if (transactionhistoryarchiveUpdate != null)
                {
                    transactionhistoryarchiveUpdate.TransactionID = transactionhistoryarchive.TransactionID;
                    transactionhistoryarchiveUpdate.ProductID = transactionhistoryarchive.ProductID;
                    transactionhistoryarchiveUpdate.ReferenceOrderID = transactionhistoryarchive.ReferenceOrderID;
                    transactionhistoryarchiveUpdate.ReferenceOrderLineID = transactionhistoryarchive.ReferenceOrderLineID;
                    transactionhistoryarchiveUpdate.TransactionDate = transactionhistoryarchive.TransactionDate;
                    transactionhistoryarchiveUpdate.TransactionType = transactionhistoryarchive.TransactionType;
                    transactionhistoryarchiveUpdate.Quantity = transactionhistoryarchive.Quantity;
                    transactionhistoryarchiveUpdate.ActualCost = transactionhistoryarchive.ActualCost;
                    transactionhistoryarchiveUpdate.ModifiedDate = transactionhistoryarchive.ModifiedDate;

                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
 partial void DeleteTransactionHistoryArchive(TransactionHistoryArchive instance);
 partial void UpdateTransactionHistoryArchive(TransactionHistoryArchive instance);
 partial void InsertTransactionHistoryArchive(TransactionHistoryArchive instance);
 public void TransactionHistoryArchiveUpdate(TransactionHistoryArchive transactionhistoryarchive)
 {
     adventureWorks_BC.TransactionHistoryArchiveUpdate(transactionhistoryarchive);
 }