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