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 bool InsertSnapshot(string now) { var lstRewardAcc = new List <Wallet_Account_Reward>(); var lstWalletSnapshot = new List <Wallet_Snapshot>(); var userLogic = new WalletUserLogic(true); try { var DateSnapshot = new WalletSnapshotQueryBuilder(new WalletEntities()).GetLatestDateSnapshot().FirstOrDefault().CreateDateSnapshot; if (DateSnapshot.Year == int.Parse(now.Split('-')[0]) && DateSnapshot.Month == int.Parse(now.Split('-')[1]) && DateSnapshot.Day == int.Parse(now.Split('-')[2])) { return(true); } WalletTransactionUow WalletTransactionUnitOfWork = null; using (WalletTransactionUnitOfWork = new WalletTransactionUow(new WalletEntities())) { WalletTransactionUnitOfWork.BeginTransaction(); var lstWalletAccount = WalletTransactionUnitOfWork.GetAllWalletAccount().OrderBy(wa => wa.ID); lstRewardAcc = WalletTransactionUnitOfWork.GetAllRewardAccount(); string S1 = ""; foreach (Wallet_Account walletAcc in lstWalletAccount) { var walletSnapShot = new Wallet_Snapshot(); walletSnapShot.ID = Guid.NewGuid().ToString(); walletSnapShot.Account_ID = walletAcc.ID; walletSnapShot.Balance = walletAcc.Available_Balance; if (lstRewardAcc != null) { var rewardACC = lstRewardAcc.Find(p => p.ID == walletAcc.ID); if (rewardACC != null) { walletSnapShot.Reward_Amount = rewardACC.Reward_Amount; } else { walletSnapShot.Reward_Amount = 0; } } else { walletSnapShot.Reward_Amount = 0; } walletSnapShot.CreateDate = walletAcc.CreateDate; walletSnapShot.UpdateDate = walletAcc.UpdateDate; walletSnapShot.CreateDateSnapshot = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); walletSnapShot.Currency_Code = walletAcc.Currency_Code; walletSnapShot.Checksum = BuildCheckSum(walletSnapShot); lstWalletSnapshot.Add(walletSnapShot); S1 += walletSnapShot.ID + walletSnapShot.Account_ID + ConvertUtility.RoundToTwoDecimalPlaces(walletSnapShot.Balance) + ConvertUtility.RoundToTwoDecimalPlaces(walletSnapShot.Reward_Amount) + walletSnapShot.CreateDate.ToString("yyyy-MM-dd HH:mm:ss") + walletSnapShot.Currency_Code + walletSnapShot.Checksum; } var S1Hash = SecurityLogic.GetSha1Hash(S1); foreach (Wallet_Snapshot Wallet_Snapshot in lstWalletSnapshot) { Wallet_Snapshot.Snapshot = S1Hash; } WalletTransactionUnitOfWork.DoInsertMany(lstWalletSnapshot).EndTransaction(); } return(true); } catch (Exception ex) { var logWallet = new LogWallet(); Task.Factory.StartNew(() => logWallet.Log(MethodBase.GetCurrentMethod(), "", ex, "")); return(false); } }