private void MineralWaterTransaction(ACMSDAL.ConnectionProvider connProvider, ACMSLogic.POS pos) { if (pos.NCategoryID == 21 && pos.ReceiptItemsTable.Rows.Count > 0) { string strProductCode = pos.ReceiptItemsTable.Rows[0]["strCode"].ToString(); int qtyToDeduct = ACMS.Convert.ToInt32(pos.ReceiptItemsTable.Rows[0]["MineralWaterQty"]); TblProductInventory producInv = new TblProductInventory(); producInv.MainConnectionProvider = connProvider; producInv.IncreaseQuantity(strProductCode, pos.StrBranchCode, -qtyToDeduct); } }
private void PostToStock(ACMSDAL.ConnectionProvider connProvider, DataTable TblQty, ACMSLogic.POS pos) { TblProductInventory proInven = new TblProductInventory(); proInven.MainConnectionProvider = connProvider; //SelectedGridItemChangedEventArgs(); // deduct stock foreach (DataRow r in TblQty.Rows) { if (r["strCode"].ToString().ToUpper() != "REG") { int nQuantity = ACMS.Convert.ToInt32(r["nQuantity"]); proInven.IncreaseQuantity(r["strCode"].ToString(), pos.StrBranchCode, -nQuantity); } } }
private void ActionTakeWhenVoidReceiptForCategory_11_12(string strReceiptNo, ConnectionProvider connProvider) { //string cmdText = "Select sum (nQuantity) as Qty, strCode From tblReceiptEntries where strReceiptNo = @strReceiptNo group by strReceiptNo, strCode"; TblReceiptEntries receiptEntries = new TblReceiptEntries(); receiptEntries.MainConnectionProvider = connProvider; DataTable table = receiptEntries.GetQty_StrCodeBaseStrReceiptNo(strReceiptNo); if (table.Rows.Count > 0) { TblProductInventory productInven = new TblProductInventory(); productInven.MainConnectionProvider = connProvider; foreach (DataRow r in table.Rows) { if (CheckIsRegistrationRow(r)) return; if (r["strCode"].ToString().Length > 0) { string strCode = r["strCode"].ToString(); int totalQtyToAddup = ACMS.Convert.ToInt32(r["Qty"]); productInven.IncreaseQuantity(strCode, User.BranchCode, totalQtyToAddup); } } } }