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