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