private void ActionTakeWhenVoidReceiptForCategory_38(string strReceiptNo, ConnectionProvider connProvider) { TblReceiptEntries receiptEntries = new TblReceiptEntries(); receiptEntries.MainConnectionProvider = connProvider; DataTable table = receiptEntries.GetQty_StrCodeBaseStrReceiptNo(strReceiptNo); if (table.Rows.Count > 0) { foreach (DataRow r in table.Rows) { if (CheckIsRegistrationRow(r)) return; if (r["strCode"].ToString().Length > 0) { string strSQL; strSQL = "select * from tblReceiptPayment rp, tblReceipt r where strPaymentCode='CASHVOUCHER' and rp.strReferenceNo='" + r["strCode"].ToString() + "' and rp.strReceiptNo=r.strReceiptNo and fVoid=0"; DataSet _ds1 = new DataSet(); SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds1, new string[] { "table" }, new SqlParameter("@strSQL", strSQL)); //Roll back when cash voucher used if (_ds1.Tables["table"].Rows.Count > 0) throw new Exception("Cash Voucher(s) purchased in this receipt already used in receipt " + _ds1.Tables["table"].Rows[0]["strReceiptNo"] + " under member " + _ds1.Tables["table"].Rows[0]["strMembershipID"] + "."); TblCashVoucher sqlCV = new TblCashVoucher(); sqlCV.MainConnectionProvider = connProvider; string strCVCode = r["strCode"].ToString(); sqlCV.StrSN = strCVCode; DataTable dtCV = sqlCV.SelectOne(); sqlCV.NStatusID = 0; sqlCV.StrSoldToID = System.Data.SqlTypes.SqlString.Null; sqlCV.DtSoldDate = System.Data.SqlTypes.SqlDateTime.Null; sqlCV.StrSoldBranch = System.Data.SqlTypes.SqlString.Null; sqlCV.DtStartDate = System.Data.SqlTypes.SqlDateTime.Null; sqlCV.DtExpiryDate = System.Data.SqlTypes.SqlDateTime.Null; sqlCV.Update(); sqlCV.SaveData(table); } } } }
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); } } } }