}//GetTakenBy //----------------------------------------------------------------------------------------------// private void AddItem(Models.Product product, WorkSpace ws) { stockRecord = (StockRecord)ws.CreateObject("StockRecord"); //Create a stockRecord with lvi.Text and look for it in database. SDOHelper.Write(stockRecord, "STOCK_CODE", product.Code); if (stockRecord.Find(false)) { //Add item to the order. sopItem = SDOHelper.Add(sopPost.Items); //Put product details and prices into sopItem SDOHelper.Write(sopItem, "STOCK_CODE", SDOHelper.Read(stockRecord, "STOCK_CODE")); SDOHelper.Write(sopItem, "DESCRIPTION", SDOHelper.Read(stockRecord, "DESCRIPTION")); double qty = product.Qty; double salePrc = product.SalePrice; double netAmt = salePrc * qty * (1 - cusDiscountRate / 100); double taxAmt = netAmt * defTaxRate / 100; SDOHelper.Write(sopItem, "QTY_ORDER", qty); SDOHelper.Write(sopItem, "UNIT_PRICE", salePrc); SDOHelper.Write(sopItem, "NET_AMOUNT", netAmt); SDOHelper.Write(sopItem, "TAX_AMOUNT", taxAmt); SDOHelper.Write(sopItem, "TAX_RATE", defTaxRate); SDOHelper.Write(sopItem, "NOMINAL_CODE", ((int)setUsr.stockNomCode).ToString()); SDOHelper.Write(sopItem, "TAX_CODE", (short)taxCode); } else { throw new MyException("Stock: " + product.Code + " does not seem to exist."); } //Else } //AddItem
} //AddItem //----------------------------------------------------------------------------------------------// private void DestroyAllObjects() { if (conData != null) { Marshal.FinalReleaseComObject(conData); conData = null; }//If if (currData != null) { Marshal.FinalReleaseComObject(currData); currData = null; }//If if (sopPost != null) { Marshal.FinalReleaseComObject(sopPost); sopPost = null; }//If if (sopItem != null) { Marshal.FinalReleaseComObject(sopItem); sopItem = null; }//If if (stockRecord != null) { Marshal.FinalReleaseComObject(stockRecord); stockRecord = null; }//If if (ws != null) { ws.Disconnect(); Marshal.FinalReleaseComObject(ws); ws = null; }//If if (sdo != null) { Marshal.FinalReleaseComObject(sdo); sdo = null; } //If } //DestroyAllObjects