public Int64 AddItemToDB(Data.SalesTransactionItemDetails Details) { try { Details.TransactionID = mclsSalesTransactionDetails.TransactionID; Details.TransactionDate = mclsSalesTransactionDetails.TransactionDate; Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(mConnection, mTransaction); mConnection = clsSalesTransactions.Connection; mTransaction = clsSalesTransactions.Transaction; Int64 TransactionItemsID = clsSalesTransactions.AddItem(mclsSalesTransactionDetails, Details); clsSalesTransactions.CommitAndDispose(); Details.TransactionItemsID = TransactionItemsID; clsEvent.AddEventLn("Adding item no: " + Details.ItemNo + " Barcode".PadRight(15) + ":" + Details.BarCode + " ProductCode".PadRight(15) + ":" + Details.ProductCode + " Price".PadRight(15) + ":" + Details.Price, true); return TransactionItemsID; } catch (Exception ex) { InsertErrorLogToFile(ex, "ERROR!!! Adding sales item to database. TRACE: "); throw ex; } }