public string InsertUserRecord(User record)
{
try
{
using (var eWalletTransactionUnitOfWork = new WalletTransactionUow(new WalletEntities()))
{
record.User_ID = SecurityLogic.GenerateKey(30);
eWalletTransactionUnitOfWork.BeginTransaction().DoInsert(record).EndTransaction();
}
return(record.User_ID);
}
catch (Exception ex)
{
var logWallet = new LogWallet();
Task.Factory.StartNew(() => logWallet.Log(MethodBase.GetCurrentMethod(), record.User_ID, ex, ""));
return("");
}
}
public bool InsertVerificationStatus(UserBankAccountRequest request)
{
try
{
var BankAcc = SimpleAesUtil.DecryptAES(request.AccountNumber, EwalletConstant.keyAES);
BankAcc = BankAcc.Replace(EwalletConstant.strWord, "").Replace(" ", "").Replace("-", "");
double Num;
bool isNum = double.TryParse(BankAcc, out Num);
if (!isNum || BankAcc.Length < 8 || BankAcc.Length > 20)
{
var logWallet = new LogWallet();
logWallet.Log(MethodBase.GetCurrentMethod(), "BankAcc: " + BankAcc, null, "Issue for BankACC");
return(false);
}
byte[] bytes = Convert.FromBase64String(request.urlBankAcc);
request.FileNameBankAcc = "BankAcc_" + DateTime.Now.Ticks + request.FileNameBankAcc.Substring(request.FileNameBankAcc.LastIndexOf('.'), 4);
var pathFileNameBankAcc = Path.Combine(EwalletConstant.EWalletPathPictureUpload, request.FileNameBankAcc);
using (Image image = Image.FromStream(new MemoryStream(bytes)))
{
image.Save(pathFileNameBankAcc);
}
bytes = Convert.FromBase64String(request.urlPassIC);
request.FileNamePasIC = "BankPasIC_" + DateTime.Now.Ticks + request.FileNamePasIC.Substring(request.FileNamePasIC.LastIndexOf('.'), 4);
var pathFileNamePasIC = Path.Combine(EwalletConstant.EWalletPathPictureUpload, request.FileNamePasIC);
using (Image image = Image.FromStream(new MemoryStream(bytes)))
{
image.Save(pathFileNamePasIC);
}
var userBankAccount = new User_Bank_Account
{
ID = SecurityLogic.GenerateKey(30),
BankCurrency = request.BankCurrency,
CountryBank = request.CountryBank,
BankName = request.BankName,
AccountName = request.AccountName,
AccountNumber = request.AccountNumber,
Verify = "Pending",
urlBankAcc = pathFileNameBankAcc,
urlPassIC = pathFileNamePasIC,
User_ID = request.User_ID,
BankCity = request.BankCity,
BranchCode = request.BranchCode,
BranchName = request.BranchName,
Comments = request.Comments,
Create_date = DateTime.Now,
Update_date = DateTime.Now,
};
WalletTransactionUow WalletTransactionUnitOfWork = new WalletTransactionUow(new WalletEntities());
WalletTransactionUnitOfWork.BeginTransaction();
WalletTransactionUnitOfWork.DoInsert(userBankAccount).SaveAndContinue();
WalletTransactionUnitOfWork.EndTransaction();
return(true);
}
catch (Exception ex)
{
var logWallet = new LogWallet();
Task.Factory.StartNew(() => logWallet.Log(MethodBase.GetCurrentMethod(), request, ex, ""));
return(false);
}
}
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");
}
}