public bool InsertTransactionRewards(Wallet_Account_Reward record) { try { using (var eWalletTransactionUnitOfWork = new WalletTransactionUow(new WalletEntities())) { eWalletTransactionUnitOfWork.BeginTransaction().DoInsert(record).EndTransaction(); return(true); } } catch (Exception ex) { var logWallet = new LogWallet(); logWallet.Log(MethodBase.GetCurrentMethod(), record.ID, ex, ""); return(false); } }
public Wallet_Account_Reward BuildWalletAccReward(string accID, string walletID, decimal rewardAmt) { #region New Reward Account var Transaction_Reward = new Wallet_Account_Reward(); Transaction_Reward.ID = accID; Transaction_Reward.Wallet_ID = walletID; Transaction_Reward.Reward_Amount = rewardAmt; Transaction_Reward.Createdate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); Transaction_Reward.Updatedate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); Transaction_Reward.Remark = ""; Transaction_Reward.CheckSumReward = BuildCheckSum_Reward(Transaction_Reward); return(Transaction_Reward); #endregion }
public string GenerateNewWalletAccount(string pUserID, string pUserCreate) { var lstWalletAccount = new List <Wallet_Account>(); var lstWalletRule = new List <Wallet_Rule>(); //var lstInterestSnapshot = new List<Transaction_Interest_Snapshot>(); var lstRewards = new List <Wallet_Account_Reward>(); var New_WalletUser = new Wallet_User(); New_WalletUser.User_ID = pUserID; New_WalletUser.Wallet_ID = SecurityLogic.GenerateKey(30); var curDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); WalletTransactionUow WalletTransactionUnitOfWork = new WalletTransactionUow(new WalletEntities()); try { WalletTransactionUnitOfWork.BeginTransaction(); WalletTransactionUnitOfWork.DoInsert(New_WalletUser).SaveAndContinue(); using (var CurrenciesQueryBuilder = new CurrenciesQueryBuilder(new WalletEntities())) { foreach (var CurrencyCode in CurrenciesQueryBuilder.ToList()) { #region New Wallet Acc Random random = new Random(); var New_walletAcc = new Wallet_Account(); New_walletAcc.ID = SecurityLogic.GenerateKey(30); New_walletAcc.Wallet_ID = New_WalletUser.Wallet_ID; New_walletAcc.User_ID = pUserID; New_walletAcc.Available_Balance = ConvertUtility.RoundToTwoDecimalPlaces(0); New_walletAcc.Total_Balance = ConvertUtility.RoundToTwoDecimalPlaces(0); New_walletAcc.Currency_Code = CurrencyCode.Currency_Code; New_walletAcc.CreateDate = curDate; New_walletAcc.CreateUser = pUserCreate; New_walletAcc.UpdateDate = curDate; New_walletAcc.UpdateUser = pUserCreate; New_walletAcc.ChecksumAvailable1 = BuildCheckSumAvailable1(New_walletAcc); var strCheckSum2 = BuildCheckSumAvailable2(New_walletAcc); if (strCheckSum2 != "") { New_walletAcc.ChecksumAvailable2 = strCheckSum2; } else { var logWallet = new LogWallet(); Task.Factory.StartNew(() => logWallet.Log(MethodBase.GetCurrentMethod(), New_WalletUser.Wallet_ID, null, "Can not build checksum2")); return("Failed"); } New_walletAcc.ChecksumTotal1 = BuildCheckSumTotal1(New_walletAcc); New_walletAcc.ChecksumTotal2 = BuildCheckSumTotal2(New_walletAcc); lstWalletAccount.Add(New_walletAcc); #endregion #region New Wallet Rule var New_WalletRule = new Wallet_Rule(); New_WalletRule.ID = SecurityLogic.GenerateKey(30); New_WalletRule.Account_ID = New_walletAcc.ID; switch (CurrencyCode.Currency_Code) { case "VND": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_VND; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_VND; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_VND; break; case "USD": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_USD; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_USD; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_USD; break; case "SGD": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_SGN; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_SGN; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_SGN; break; case "MYR": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_MYR; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_MYR; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_MYR; break; case "THB": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_THB; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_THB; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_THB; break; case "CNY": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_CNY; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_CNY; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_CNY; break; case "KHR": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_KHR; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_KHR; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_KHR; break; case "MMK": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_MMK; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_MMK; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_MMK; break; case "Rp": New_WalletRule.Maximum_Topup_Amount = EwalletConstant.EWallet_LimitTopupAmount_Rp; New_WalletRule.Maximum_Withdraw_Amount = EwalletConstant.EWallet_LimitWithdrawAmount_Rp; New_WalletRule.Minimum_Topup_Amount = EwalletConstant.EWallet_LimitTopupMinimumAmount_Rp; break; } New_WalletRule.CreateDate = curDate; New_WalletRule.UpdateDate = curDate; New_WalletRule.Currency_Code = CurrencyCode.Currency_Code; lstWalletRule.Add(New_WalletRule); #endregion //#region New Interest Snapshot //var TransactionInterest = new WalletInterestLogic(); //var Tran_interest = new Transaction_Interest_Snapshot(); //Tran_interest.ID = Guid.NewGuid().ToString(); //Tran_interest.Account_ID = New_walletAcc.ID; //Tran_interest.Tran_ID = Guid.NewGuid().ToString(); //Tran_interest.Interest_Amount = 0; //Tran_interest.Total_Amount = 0; //Tran_interest.Createdate = DateTime.Now; //Tran_interest.Remark = ""; //var TransactionLogic = new WalletTransactionLogic(true); //Tran_interest.CheckSumInterest = TransactionInterest.BuildCheckSum_SnapshotInterest(Tran_interest); //lstInterestSnapshot.Add(Tran_interest); //#endregion #region New Reward Account var Transaction_Reward = new Wallet_Account_Reward(); Transaction_Reward.ID = New_walletAcc.ID; Transaction_Reward.Wallet_ID = New_walletAcc.Wallet_ID; Transaction_Reward.Reward_Amount = 0; Transaction_Reward.Createdate = curDate; Transaction_Reward.Updatedate = curDate; Transaction_Reward.Remark = ""; var TransactionRewardLogic = new WalletRewardLogic(); Transaction_Reward.CheckSumReward = TransactionRewardLogic.BuildCheckSum_Reward(Transaction_Reward); lstRewards.Add(Transaction_Reward); #endregion } } WalletTransactionUnitOfWork.DoInsertMany(lstWalletAccount); WalletTransactionUnitOfWork.DoInsertMany(lstWalletRule); //WalletTransactionUnitOfWork.DoInsertMany(lstInterestSnapshot); WalletTransactionUnitOfWork.DoInsertMany(lstRewards); WalletTransactionUnitOfWork.EndTransaction(); return(New_WalletUser.Wallet_ID); } catch (Exception ex) { WalletTransactionUnitOfWork.RollBack(); var logWallet = new LogWallet(); Task.Factory.StartNew(() => logWallet.Log(MethodBase.GetCurrentMethod(), New_WalletUser.Wallet_ID, ex, "")); return("Failed"); } }
public string BuildCheckSum_Reward(Wallet_Account_Reward InterestTran) { string checkSum = SecurityLogic.GetSha1Hash(InterestTran.ID + "|" + InterestTran.Wallet_ID + "|" + InterestTran.Createdate.ToString("yyyy-MM-dd HH:mm:ss") + "|" + InterestTran.Updatedate.ToString("yyyy-MM-dd HH:mm:ss") + "|" + InterestTran.Reward_Amount + "|" + EwalletConstant.WebserverKey); return(checkSum); }
public decimal UpdateRewardByAccIDForPaymentWithoutTownbus(WalletTransactionUow eWalletTransactionUnitOfWork, Wallet_Account_Reward RewardAcc, decimal CalReward, string remarks) { decimal realReward = 0; try { if (CalReward >= RewardAcc.Reward_Amount) { realReward = RewardAcc.Reward_Amount; RewardAcc.Reward_Amount = 0; } else if (CalReward < RewardAcc.Reward_Amount) { realReward = CalReward; RewardAcc.Reward_Amount = RewardAcc.Reward_Amount - CalReward; } RewardAcc.Updatedate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); RewardAcc.CheckSumReward = BuildCheckSum_Reward(RewardAcc); RewardAcc.Remark = remarks; eWalletTransactionUnitOfWork.DoUpdate(RewardAcc).SaveAndContinue(); return(realReward); } catch (Exception ex) { var logWallet = new LogWallet(); logWallet.Log(MethodBase.GetCurrentMethod(), RewardAcc.ID, ex, ""); return(-1); } }