public static void CreateUnLinkPackage() { TblPackage sqlPackage = new TblPackage(); sqlPackage.StrPackageCode = "Unlinked"; DataTable packageTable = sqlPackage.SelectOne(); if (packageTable == null || packageTable.Rows.Count == 0) { sqlPackage.StrPackageCode = "Unlinked"; sqlPackage.NCategoryID = 1; sqlPackage.NStatus = 2; sqlPackage.DtValidEnd = DateTime.Now; sqlPackage.DtValidStart = DateTime.Now; sqlPackage.NMaxSession = 10000; sqlPackage.Insert(); } }
/// <summary> /// Use Member Credit Package means use the credit to buy the package and then store in the tblMemberPackage /// be aware some package is not allow to purchase using credit package. Must check tblCreditPackageRestriction /// </summary> /// <returns></returns> public string[,] UseMemberCreditPackage(string[,] strPackageCode, int nCreditPackageID, string strSignID, string strSigKey, string strPdfExportPath, string remark) { //ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider(); DataRow[] rows, row1s = new DataRow[strPackageCode.Length / 2]; string[,] strUsage = new string[strPackageCode.Length / 2, 3]; //DataColumn[] dc = new DataColumn["Usage",System.Type.GetType("System.Int")]; try { TblMemberCreditPackage memberCreditPackage = new TblMemberCreditPackage(); //connProvider.OpenConnection(); //connProvider.BeginTransaction("UseMemberCreditPackage"); //memberCreditPackage.MainConnectionProvider = connProvider; memberCreditPackage.NCreditPackageID = nCreditPackageID; DataTable table = memberCreditPackage.SelectOne(); if (table == null || table.Rows.Count == 0) { throw new Exception("This member credit package been deleted by others"); } if (ACMS.Convert.ToInt32(table.Rows[0]["nStatusID"]) > 0) { throw new Exception("This member credit package has been deleted/expired/suspended."); } string strCreditPackageCode = memberCreditPackage.StrCreditPackageCode.Value; string strMembershipID = memberCreditPackage.StrMembershipID.Value; TblCreditPackageRestriction restriction = new TblCreditPackageRestriction(); restriction.StrCreditPackageCode = strCreditPackageCode; TblReceipt creditReceipt = new TblReceipt(); if (!memberCreditPackage.StrReceiptNo.IsNull) { creditReceipt.StrReceiptNo = memberCreditPackage.StrReceiptNo.Value; creditReceipt.SelectOne(); } DataTable restricttable = restriction.SelectAllWstrCreditPackageCodeLogic(); DataColumn colQuantity = new DataColumn("colQuantity", System.Type.GetType("System.Int32")); restricttable.Columns.Add(colQuantity); bool isAllowDiscount = false; if (restricttable.Rows.Count == 0) { throw new Exception("No allow to use credit package for this package."); } else { for (int j = 0; j < strPackageCode.Length / 2; j++) { rows = restricttable.Select("strPackageCode = '" + strPackageCode[j, 0] + "'", "strCreditPackageCode"); rows[0]["colQuantity"] = strPackageCode[j, 1]; row1s[j] = rows[0]; } if (row1s.Length == 0) { throw new Exception("No allow to use credit package for this package."); } // check later as got two package now //else //{ // isAllowDiscount = ACMS.Convert.ToBoolean(row1s[0]["fAllowDiscount"]); //} } // Must Check balance is enough to buy a Package or not TblCreditPackage creditPackage = new TblCreditPackage(); creditPackage.StrCreditPackageCode = memberCreditPackage.StrCreditPackageCode.Value; creditPackage.SelectOne(); decimal creditPackageValue = ACMS.Convert.ToDecimal(creditPackage.MCreditAmount); decimal mmbCreditPackageFreeCredit = ACMS.Convert.ToDecimal(creditPackage.MFreeCredit); decimal mmbCreditPackageTopupAmt = ACMS.Convert.ToDecimal(memberCreditPackage.MTopupAmount); decimal totalCreditUsage = GetCreditUsageFromMemberPackage(nCreditPackageID); decimal balance = (creditPackageValue + mmbCreditPackageTopupAmt + mmbCreditPackageFreeCredit) - totalCreditUsage; if (creditReceipt.MOutstandingAmount > 0 && !memberCreditPackage.StrReceiptNo.IsNull) { DataTable creditUsageMemberPackage = null; RefreshForPackageUsage(strMembershipID, ACMS.Convert.ToInt32(creditPackage.NCategoryID)); creditUsageMemberPackage = myDataTable; double m70PercPaidAmount = 0; if (creditUsageMemberPackage.Rows.Count > 0) { m70PercPaidAmount = ACMS.Convert.ToDouble(creditUsageMemberPackage.Select("nCreditPackageID=" + nCreditPackageID)[0]["PaidAmt"]) * 0.7; } if (totalCreditUsage > ACMS.Convert.ToDecimal(m70PercPaidAmount)) { throw new Exception(string.Format("Total usage is more than 70% of paid amount. \n Please clear the outstanding.")); } } if (balance < 0) { throw new Exception(string.Format("Balance for Member Credit Package : {0} is not enough.\n Please topup your credit.", nCreditPackageID.ToString())); } // Need to know here whether it is 1st use TblMemberPackage mp = new TblMemberPackage(); //mp.MainConnectionProvider = connProvider; mp.NCreditPackageID = nCreditPackageID; DataTable temptable = mp.SelectAllWnCreditPackageIDLogic(); bool is1stUseCreditPck = false; if (Convert.ToInt32(temptable.Compute("COUNT(nStatusID)", "nStatusID=0 or nStatusID=1")) == 0) { //means news insert is1stUseCreditPck = true; } int i = 0; foreach (DataRow drPackage in row1s) { for (int x = 0; x < ACMS.Convert.ToInt32(drPackage[3]); x++) // quantity { MemberPackage memberPackage = new MemberPackage(); DataTable memberPackageTable = memberPackage.New(false, strMembershipID); DataRow memberPackageRow = memberPackageTable.Rows[0]; memberPackageRow["nCreditPackageID"] = nCreditPackageID; memberPackageRow["strMembershipID"] = strMembershipID; memberPackageRow["dtPurchaseDate"] = DateTime.Now; memberPackageRow["strRemarks"] = remark; memberPackageRow["strSignatureID"] = strSignID; memberPackageRow["strSigKey"] = strSigKey; memberPackageRow["strSigPdfPath"] = strPdfExportPath; memberPackageRow["strUtilData"] = strSigKey; memberPackageRow["nStatusID"] = 0; memberPackageRow["strPackageCode"] = drPackage["strPackageCode"]; //strPackageCode; TblPackage package = new TblPackage(); package.StrPackageCode = drPackage["strPackageCode"].ToString(); // strPackageCode; package.SelectOne(); decimal creditUsage = 0; decimal packageListPrice = ACMS.Convert.ToDecimal(package.MListPrice); TblMember sqlMember = new TblMember(); //Check if redeemed spa single treatment from holistic in birthday month, give 50% discount if ((creditPackage.NCategoryID == 36 || creditPackage.NCategoryID == 37) && (package.NCategoryID == 4 || (package.NCategoryID == 6 && package.NMaxSession == 1)) && sqlMember.MembershipThisMonthBirtdayForUtilised(strMembershipID, nCreditPackageID)) { DialogResult result1 = MessageBox.Show("Member is having birthday this months and having 50% discount. Do you want to utilies?", "Warning", MessageBoxButtons.YesNo); if (result1 == DialogResult.Yes) { double discountPercent = 50; memberPackageRow["strPromotionCode"] = "120046SSD"; // calcualte usage * quantity creditUsage = packageListPrice - (packageListPrice * (decimal)discountPercent / 100); } else { if (ACMS.Convert.ToBoolean(drPackage["fAllowDiscount"])) { double discountPercent = creditPackage.DCreditDiscount.Value; // calcualte usage * quantity creditUsage = packageListPrice - (packageListPrice * (decimal)discountPercent / 100); } else { creditUsage = packageListPrice; } } } else if (ACMS.Convert.ToBoolean(drPackage["fAllowDiscount"])) { double discountPercent = creditPackage.DCreditDiscount.Value; // calcualte usage * quantity creditUsage = packageListPrice - (packageListPrice * (decimal)discountPercent / 100); } else { creditUsage = packageListPrice; } decimal previousBal = balance; balance = decimal.Parse(previousBal.ToString("N2")) - decimal.Parse(creditUsage.ToString("N2")); if (balance < 0) { throw new Exception(string.Format("Balance for Member Credit Package : {0} is not enough. \n Please topup your credit.", nCreditPackageID.ToString())); } memberPackageRow["mCreditPackageUsagePrice"] = creditUsage; memberPackageRow["strRemarks"] = memberPackageRow["strRemarks"] + " " + x; //Initially designed for immediate kick start if (memberPackageRow["dtStartDate"].ToString() == "") { int iduration = package.NPackageDuration.Value; DateTime dtNow = DateTime.Now.Date; memberPackageRow["dtStartDate"] = dtNow; if (package.StrDurationUnit.ToString().Trim() == "DAY") { memberPackageRow["dtExpiryDate"] = dtNow.AddDays(iduration - 1).AddDays(0); } else if (package.StrDurationUnit.ToString().Trim() == "WEEK") { iduration = iduration * 7; memberPackageRow["dtExpiryDate"] = dtNow.AddDays(iduration - 1).AddDays(0); } else { memberPackageRow["dtExpiryDate"] = dtNow.AddMonths(iduration).AddDays(-1); } } mp.SaveData(memberPackageTable); strUsage[i, 0] = package.StrDescription.ToString(); strUsage[i, 1] = creditUsage.ToString(); } strUsage[i, 2] = drPackage[3].ToString(); i++; } if (is1stUseCreditPck) { if (memberCreditPackage.DtStartDate.ToString() == "Null") { memberCreditPackage.NCreditPackageID = nCreditPackageID; memberCreditPackage.DtStartDate = DateTime.Now.Date; memberCreditPackage.DtExpiryDate = DateTime.Now.Date.AddMonths(ACMS.Convert.ToInt32(creditPackage.NValidMonths)).AddDays(-1); memberCreditPackage.Update(); } } //connProvider.CommitTransaction(); } catch (Exception) { //connProvider.RollbackTransaction("UseMemberCreditPackage"); throw; } finally { //if (connProvider.CurrentTransaction != null) // connProvider.CurrentTransaction.Dispose(); //if (connProvider.DBConnection != null) //{ // if (connProvider.DBConnection.State == ConnectionState.Open) // connProvider.DBConnection.Close(); //} } return(strUsage); }
public void NewRedemption(string strMembershipID, string itemCode, int qtyOfItemCodeToRedempt, ref int strTransNo) { ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider(); connProvider.OpenConnection(); TblRewardsCatalogue catalogue = new TblRewardsCatalogue(); catalogue.StrItemCode = itemCode; catalogue.SelectOne(); TblRewardsTransaction rewardTrans = new TblRewardsTransaction(); rewardTrans.MainConnectionProvider = connProvider; rewardTrans.StrMembershipID = strMembershipID; rewardTrans.DtDate = DateTime.Now; rewardTrans.NTypeID = 2; rewardTrans.StrReferenceNo = itemCode; rewardTrans.NEmployeeID = User.EmployeeID; rewardTrans.StrBranchCode = User.BranchCode; if (!catalogue.DRewardsPoints.IsNull) { rewardTrans.DRewardsPoints = -catalogue.DRewardsPoints.Value * qtyOfItemCodeToRedempt; } rewardTrans.Insert(); strTransNo = rewardTrans.NTransactionID.Value; TblPromotionFreebie promoFreebie = new TblPromotionFreebie(); promoFreebie.StrPromotionCode = itemCode; DataTable receiptFreebieTable = promoFreebie.SelectAllWstrPromotionCodeLogic(); //Code selected is Promotion Freebie Code if (receiptFreebieTable.Rows.Count > 0) { //TblProductInventory proInven = new TblProductInventory(); //proInven.MainConnectionProvider = connProvider; //// deduct stock //foreach (DataRow r in receiptFreebieTable.Rows) //{ // proInven.IncreaseQuantity(r["strItemCode"].ToString(), User.BranchCode, -qtyOfItemCodeToRedempt); //} } else { //Code selected is Package Code TblPackage pkg = new TblPackage(); pkg.StrPackageCode = itemCode; DataTable pkgTable = pkg.SelectOne(); if (pkgTable.Rows.Count > 0) { TblMemberPackage mp = new TblMemberPackage(); mp.SelectAll(); MemberPackage memberPackage = new MemberPackage(); DataTable memberPackageTable = memberPackage.New(false, strMembershipID); DataRow memberPackageRow = memberPackageTable.Rows[0]; memberPackageRow["strMembershipID"] = strMembershipID; memberPackageRow["dtPurchaseDate"] = DateTime.Now; memberPackageRow["strRemarks"] = "REWARDS"; memberPackageRow["nStatusID"] = 0; memberPackageRow["strPackageCode"] = itemCode; memberPackageRow["fFree"] = 1; mp.SaveData(memberPackageTable); } else { //Code selected is Product Code //TblProductInventory productInvent = new TblProductInventory(); //productInvent.MainConnectionProvider = connProvider; //productInvent.StrProductCode = itemCode; //productInvent.SelectOne(); //productInvent.NQuantity = ACMS.Convert.ToInt32(productInvent.NQuantity) - qtyOfItemCodeToRedempt; //productInvent.Update(); } } if (connProvider.CurrentTransaction != null) { connProvider.CurrentTransaction.Dispose(); } if (connProvider.DBConnection != null) { if (connProvider.DBConnection.State == ConnectionState.Open) { connProvider.DBConnection.Close(); } } }