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);
}