//Derek Instalment Plan - Void Pay OS - Update Payment Plan
public void VoidReceipt(string strReceiptNo, bool VoidPre)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
try
{
// Check Access Right here
TblReceipt receipt = new TblReceipt();
TblReceiptFreebie sqlReceiptFreebie = new TblReceiptFreebie();
TblRewardsTransaction mRewardTransaction = new TblRewardsTransaction();
TblReceiptPayment sqlReceiptPayment = new TblReceiptPayment();
TblPaymentPlan myPaymentPlan = new TblPaymentPlan();
myPaymentPlan.MainConnectionProvider = connProvider;
mRewardTransaction.MainConnectionProvider = connProvider;
receipt.MainConnectionProvider = connProvider;
sqlReceiptFreebie.MainConnectionProvider = connProvider;
sqlReceiptPayment.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("VoidReceipt");
receipt.StrReceiptNo = strReceiptNo;
receipt.SelectOne();
int nCategoryID = receipt.NCategoryID.Value;
string strBranchCode = receipt.StrBranchCode.Value;
if (receipt.DtDate.Value != System.DateTime.Today && VoidPre == false)
throw new Exception("Not allow to void previous data receipt. ");
if (strBranchCode != User.BranchCode)
throw new Exception("Not allow to void other's branches' receipt. ");
receipt.FVoid = System.Data.SqlTypes.SqlBoolean.True;
receipt.Update();
string strSQL;
if (receipt.NCategoryID == 7 || receipt.NCategoryID == 36 || receipt.NCategoryID == 37)
strSQL = "select top 1 * from tblMemberCreditPackage where strReceiptNo ='" + receipt.StrReceiptNo.ToString() + "' AND fFree=0";
else
strSQL = "select top 1 * from tblMemberPackage where strReceiptNo ='" + receipt.StrReceiptNo.ToString() + "' AND fFree=0";
DataSet _ds1 = new DataSet();
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds1, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
//Roll back when package conversion
if (_ds1.Tables["table"].Rows.Count > 0)
{
string strPkgRemark = _ds1.Tables["table"].Rows[0]["strUpgradeFrom"].ToString();
string[] rollbackPackages = strPkgRemark.ToString().Split(',');
foreach (string rollbackPackage in rollbackPackages)
{
if (rollbackPackage.Trim() != "" && rollbackPackage.Trim() != "Null")
{
if (rollbackPackage.Contains("(C)"))
{
int nPackageID = Convert.ToInt32(rollbackPackage.Trim().Replace("(C)", ""));
TblMemberCreditPackage mp2 = new TblMemberCreditPackage();
mp2.NCreditPackageID = nPackageID;
mp2.SelectOne();
mp2.StrUpgradeTo = "";
mp2.StrRemarks = "";
mp2.NStatusID = 0;
mp2.Update();
}
else if (rollbackPackage.Contains("(B)"))
{
string strSQL2 = "select * from tblMemberPackage where strUpgradeTo='" + receipt.StrReceiptNo.ToString() + "' ";
DataSet _ds2 = new DataSet();
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds2, new string[] { "table" }, new SqlParameter("@strSQL", strSQL2));
foreach (DataRow drComboPkg in _ds2.Tables["table"].Rows)
{
TblMemberPackage mp = new TblMemberPackage();
DataTable convertedPkgTable = mp.LoadData("select * from tblMemberPackage where nPackageID=" + drComboPkg["nPackageID"].ToString());
if (convertedPkgTable.Rows.Count > 0)
{
convertedPkgTable.Rows[0]["nStatusID"] = 0;
convertedPkgTable.Rows[0]["strUpgradeTo"] = "";
convertedPkgTable.Rows[0]["strRemarks"] = "";
mp.SaveData(convertedPkgTable);
}
}
}
else
{
int nPackageID = Convert.ToInt32(rollbackPackage.Trim());
TblMemberPackage mp2 = new TblMemberPackage();
mp2.NPackageID = nPackageID;
mp2.SelectOne();
mp2.StrUpgradeTo = "";
mp2.StrRemarks = "";
mp2.NStatusID = 0;
mp2.Update();
//rollback free package if have any
TblMemberPackage mp3 = new TblMemberPackage();
string strFreePackageCode = "";
string strSQL3 = "select strFreePkgCode from tblPackage where strPackageCode='" + Convert.ToString(mp2.StrPackageCode) + "' ";
DataSet _ds = new DataSet();
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL3));
if (_ds.Tables["table"].Rows.Count > 0)
{
strFreePackageCode = _ds.Tables["table"].Rows[0]["strFreePkgCode"].ToString();
}
DataTable freePkgTable = mp3.LoadData("select * from tblMemberPackage where strReceiptNo=@strReceiptNo and strPackageCode =@strFreePackageCode ",
new string[] { "@strReceiptNo", "@strFreePackageCode" }, new object[] { mp2.StrReceiptNo.ToString(), strFreePackageCode });
if (freePkgTable.Rows.Count > 0)
{
freePkgTable.Rows[0]["nStatusID"] = 0;
freePkgTable.Rows[0]["strUpgradeTo"] = "";
freePkgTable.Rows[0]["strRemarks"] = "";
mp3.SaveData(freePkgTable);
}
}
}
}
}
receipt.MUpgradeAmount = System.Data.SqlTypes.SqlMoney.Null;
receipt.StrRemarks = "";
receipt.Update();
#region ====== Added By Albert ======
/*
* To remove reward transaction.
*/
mRewardTransaction.StrReferenceNo = strReceiptNo;
mRewardTransaction.SelectAllWReferenceNo();
mRewardTransaction.NTypeID = 3;
mRewardTransaction.Update();
#endregion
//rollback used cash voucher
TblReceiptPayment tblReceiptPayment = new ACMSDAL.TblReceiptPayment();
tblReceiptPayment.StrReceiptNo = strReceiptNo;
DataTable tblPayment = tblReceiptPayment.SelectAllWstrReceiptNoLogic();
foreach (DataRow dr in tblPayment.Rows)
{
if (dr["strPaymentCode"].ToString() == "CASHVOUCHER")
{
TblCashVoucher sqlCV = new TblCashVoucher();
sqlCV.MainConnectionProvider = connProvider;
sqlCV.StrSN = dr["strReferenceNo"].ToString();
DataTable table = sqlCV.SelectOne();
sqlCV.NStatusID = 1;
sqlCV.StrRedeemedByID = System.Data.SqlTypes.SqlString.Null;
sqlCV.DtRedeemedDate = System.Data.SqlTypes.SqlDateTime.Null;
sqlCV.StrRedeemedBranch = System.Data.SqlTypes.SqlString.Null;
sqlCV.Update();
sqlCV.SaveData(table);
}
}
if (!receipt.StrChildReceiptNo.IsNull)
{
int IsVoid = 0;
IsVoid = receipt.CheckIfChildReceiptVoid(receipt.StrChildReceiptNo.Value);
if (IsVoid == 0)
{
throw new Exception("The receipt given has child receipt, please void child receipt first before void this receipt");
}
}
string strDepositReceiptNo = "";
if (!receipt.StrParentReceiptNo.IsNull)
{
TblReceiptEntries pReceipt = new TblReceiptEntries();
pReceipt.StrReceiptNo = receipt.StrParentReceiptNo.Value;
pReceipt.SelectAllWstrReceiptNoLogic();
if (pReceipt.StrCode.Value != "Deposit")
{
nCategoryID = 0; //Check if pay outstanding receipt, reset category to 0
}
else if (pReceipt.StrCode.Value == "Deposit")
{
strDepositReceiptNo = receipt.StrParentReceiptNo.Value;
}
pReceipt.Dispose();
}
if (strDepositReceiptNo != "")
{
try
{
receipt.ReviveDepositForVoidMasterReceipt(strReceiptNo, strDepositReceiptNo);
}
catch { }
}
if (nCategoryID == 1 || nCategoryID == 3 || nCategoryID == 4 || nCategoryID == 5 ||
nCategoryID == 6 || nCategoryID == 8 || nCategoryID == 9 || nCategoryID == 14 || nCategoryID == 23)
{
ActionTakeWhenVoidReceiptForCategory_1_3_4_5_6_8_9_14_23(strReceiptNo, connProvider);
}
else if (nCategoryID == 2)
{
//Fitness GIRO
ActionTakeWhenVoidReceiptForCategory_2(strReceiptNo, connProvider);
}
else if (nCategoryID == 7)
{
// Spa Credit Account
ActionTakeWhenVoidReceiptForCategory_7(strReceiptNo, connProvider);
}
else if (nCategoryID == 36 || nCategoryID == 37)
{
// Holistic Credit Account
ActionTakeWhenVoidReceiptForCategory_7(strReceiptNo, connProvider);
}
else if (nCategoryID == 38)
{
// Cash Voucher
ActionTakeWhenVoidReceiptForCategory_38(strReceiptNo, connProvider);
}
else
{
DeleteFreeMemberPackage(strReceiptNo, connProvider);
if (nCategoryID == 11 || nCategoryID == 12)
{
//ActionTakeWhenVoidReceiptForCategory_11_12(strReceiptNo, connProvider);
}
else if (nCategoryID == 21)
{
// mineral water
}
else if (nCategoryID == 15)
{
//Locker Rental
}
else if (nCategoryID == 0)
{
// Pay Outstanding
ActionTakeWhenVoidReceiptForCategory_0(receipt, connProvider);
//Get New Payment Plan
//If Table Row Count > 0 Then Update Payment Plan
//Derek Instalment Plan - Update tblPaymentPlan (if any)
//Reset Payment Plan's Receipt by payment receipt No - Bool 1 Updated 0 Not Found
//Get Bool If 1
//Find the Master Receipt No if 1
string strMasterReceiptNo = "";
strMasterReceiptNo = myPaymentPlan.GetInhouseIPPMasterOSReceiptSimple(strReceiptNo);
if (strMasterReceiptNo != "")
{
if (myPaymentPlan.GetInhouseResetIPP_VoidPayOS(strReceiptNo) == 1)
{
DataTable paymentPlanTable = myPaymentPlan.GetInhouseAdjustedIPP_VoidPayOS(strMasterReceiptNo);
if (paymentPlanTable != null && paymentPlanTable.Rows.Count > 0)
{
foreach (DataRow r in paymentPlanTable.Rows)
{
if (r["lastestUpdate"].ToString() == "1")
{
myPaymentPlan.IPPSubsequentUpdate(Convert.ToInt32(r["nPaymentPlanID"]), r["strReceiptNo"].ToString(),
Convert.ToInt32(r["nInstalmentNo"]), Convert.ToDecimal(r["mPaidAmount"]),
Convert.ToDecimal(r["mAdjustedPaymentPlanAmt"]), Convert.ToDecimal(r["mOutstandingAmt"]));
}
}
//paymentPlanTable.AcceptChanges();
}
}
}
}
else if (nCategoryID == 18)
{
ActionTakeWhenVoidReceiptForCategory_18(strReceiptNo, connProvider);
}
else if (nCategoryID == 19)
{
ActionTakeWhenVoidReceiptForCategory_19(strReceiptNo, connProvider);
}
#region Un-support voiding
/*
else if (nCategoryID == 17)
{
//throw new Exception("Forget card's receipt is not allow to void.");
//do notthing. Just void the receipt
}
else if (nCategoryID == 10)
{
//throw new Exception("Upgrade Package's receipt is not allow to void.");
// do notthing. Just void the receipt.
}
else if (nCategoryID == 20)
{
//Replace Membership Card
//throw new Exception("Replace member card's receipt is not allow to void.");
//do notthing, just void the receipt
}
*/
#endregion
}
connProvider.CommitTransaction();
}
catch (Exception ex)
{
connProvider.RollbackTransaction("VoidReceipt");
throw ex;
}
finally
{
if (connProvider.CurrentTransaction != null)
connProvider.CurrentTransaction.Dispose();
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
connProvider.DBConnection.Close();
}
}
}
