public bool Create(UserBO userBO)
{
using (var db = new dbGSCasinoContext())
{
using (var transaction = db.Database.BeginTransaction())
{
UserInfoRepository userInfoRepository = new UserInfoRepository();
TblUserInfo userInfo = userInfoRepository.Create(userBO, db);
UserAuthRepository userAuthRepository = new UserAuthRepository();
TblUserAuth userAuth = userAuthRepository.Create(userBO, userInfo, db);
UserRoleRepository userRoleRepository = new UserRoleRepository();
userRoleRepository.Create(userAuth, db);
// CREATE USER WALLETS
UserWalletAppService userWallet = new UserWalletAppService();
userWallet.Create(userAuth, db);
transaction.Commit();
return(true);
}
}
}
public UserResponseBO Authenticate(UserBO userBO)
{
using (var db = new dbGSCasinoContext())
{
UserAuthRepository userAuthRepository = new UserAuthRepository();
TblUserAuth userAuth = userAuthRepository.Get(userBO, db);
UserInfoRepository userInfoRepository = new UserInfoRepository();
TblUserInfo userInfo = userInfoRepository.Get(userAuth, db);
UserWalletRepository userWalletRepository = new UserWalletRepository();
List <UserWalletBO> userWallet = userWalletRepository.GetBO(userAuth, db);
UserRoleRepository userRoleRepository = new UserRoleRepository();
TblUserRole userRole = userRoleRepository.Get(userAuth, db);
UserResponseBO userAuthResponse = new UserResponseBO();
userAuthResponse.UserInfo = userInfo;
userAuthResponse.UserWallet = userWallet;
userAuthResponse.UserAuth = userAuth;
userAuthResponse.UserRole = userRole;
return(userAuthResponse);
}
}
public TblUserInfo Get(TblUserAuth userAuth)
{
using (var db = new dbGSCasinoContext())
{
using (var transaction = db.Database.BeginTransaction())
{
UserInfoRepository userInfoRepository = new UserInfoRepository();
TblUserInfo userInfo = userInfoRepository.Get(userAuth, db);
return(userInfo);
}
}
}
public bool UpdateWithdrawalRequest(TransactionQueryBO transactionQueryBO)
{
using (var db = new dbGSCasinoContext())
{
UserWithdrawRequestRepository userWithdrawRequestRepository = new UserWithdrawRequestRepository();
TblUserWithdrawalRequest userWithdrawalRequest = new TblUserWithdrawalRequest();
userWithdrawalRequest.Id = transactionQueryBO.ID;
userWithdrawalRequest.WithdrawalStatus = (short)transactionQueryBO.RequestStatus;
userWithdrawRequestRepository.Update(userWithdrawalRequest, db);
}
return(true);
}
public bool CreateWithdrawalRequest(WalletTransactionBO walletTransactionBO)
{
using (var db = new dbGSCasinoContext())
{
UserWithdrawRequestRepository userWithdrawRequestRepository = new UserWithdrawRequestRepository();
TblUserWithdrawalRequest userWithdrawalRequest = new TblUserWithdrawalRequest();
userWithdrawalRequest.Address = walletTransactionBO.To;
userWithdrawalRequest.TotalAmount = (decimal)walletTransactionBO.Amount;
userWithdrawalRequest.WithdrawalStatus = (short)WithdrawalRequestStatus.Pending;
userWithdrawalRequest.SourceWalletTypeId = 12;
userWithdrawRequestRepository.Create(userWithdrawalRequest, db);
}
return(true);
}
public List <UserWalletBO> GetBO(TblUserAuth tblUserAuth, dbGSCasinoContext db = null)
{
if (db != null)
{
UserWalletRepository userWalletRepository = new UserWalletRepository();
return(userWalletRepository.GetBO(tblUserAuth, db));
}
else
{
using (db = new dbGSCasinoContext())
{
using (var transaction = db.Database.BeginTransaction())
{
UserWalletRepository userWalletRepository = new UserWalletRepository();
return(userWalletRepository.GetBO(tblUserAuth, db));
}
}
}
}
public bool Create(TblUserAuth tblUserAuth, dbGSCasinoContext db = null)
{
if (db != null)
{
UserWalletRepository userWalletRepository = new UserWalletRepository();
return(userWalletRepository.Create(tblUserAuth, db));
}
else
{
using (db = new dbGSCasinoContext())
{
using (var transaction = db.Database.BeginTransaction())
{
UserWalletRepository userWalletRepository = new UserWalletRepository();
transaction.Commit();
return(userWalletRepository.Create(tblUserAuth, db));
}
}
}
}
public List <UserTransactionHistoryBO> Get(TransactionQueryBO transactionQuery)
{
using (var db = new dbGSCasinoContext())
{
List <UserTransactionHistoryBO> userWithdrawalHistoryBOs = new List <UserTransactionHistoryBO>();
UserDepositRequestRepository userDepositRequest = new UserDepositRequestRepository();
UserWithdrawRequestRepository withdrawRequestRepository = new UserWithdrawRequestRepository();
List <TblUserDepositRequest> tblUserDeposits = new List <TblUserDepositRequest>();
List <TblUserWithdrawalRequest> userWithdrawalRequests = new List <TblUserWithdrawalRequest>();
switch (transactionQuery.TransactionType)
{
case TransactionType.All:
tblUserDeposits = userDepositRequest.Get(transactionQuery, db);
for (int i = 0; i < tblUserDeposits.Count; i++)
{
UserTransactionHistoryBO withdrawalHistory = new UserTransactionHistoryBO();
withdrawalHistory.Address = tblUserDeposits[i].Address;
withdrawalHistory.ID = tblUserDeposits[i].Id;
withdrawalHistory.RequestedOn = tblUserDeposits[i].CreatedOn;
withdrawalHistory.TotalAmount = tblUserDeposits[i].Amount;
withdrawalHistory.WithdrawalStatus = (WithdrawalRequestStatus)tblUserDeposits[i].DepositStatus;
withdrawalHistory.MemberCode = tblUserDeposits[i].UserAuth.UserInfo.Uid;
withdrawalHistory.MemberEmail = tblUserDeposits[i].UserAuth.UserInfo.Email;
withdrawalHistory.MemberName = String.Format("{0} {1}", tblUserDeposits[i].UserAuth.UserInfo.FirstName, tblUserDeposits[i].UserAuth.UserInfo.LastName);
withdrawalHistory.Txid = tblUserDeposits[i].GetHashCode().ToString();
userWithdrawalHistoryBOs.Add(withdrawalHistory);
}
userWithdrawalRequests = withdrawRequestRepository.Get(transactionQuery, db);
for (int i = 0; i < userWithdrawalRequests.Count; i++)
{
UserTransactionHistoryBO withdrawalHistory = new UserTransactionHistoryBO();
withdrawalHistory.Address = userWithdrawalRequests[i].Address;
withdrawalHistory.ID = userWithdrawalRequests[i].Id;
withdrawalHistory.RequestedOn = userWithdrawalRequests[i].CreatedOn;
withdrawalHistory.TotalAmount = userWithdrawalRequests[i].TotalAmount;
withdrawalHistory.WithdrawalStatus = (WithdrawalRequestStatus)userWithdrawalRequests[i].WithdrawalStatus;
withdrawalHistory.MemberCode = userWithdrawalRequests[i].UserAuth.UserInfo.Uid;
withdrawalHistory.MemberEmail = userWithdrawalRequests[i].UserAuth.UserInfo.Email;
withdrawalHistory.MemberName = String.Format("{0} {1}", userWithdrawalRequests[i].UserAuth.UserInfo.FirstName, userWithdrawalRequests[i].UserAuth.UserInfo.LastName);
withdrawalHistory.Txid = userWithdrawalRequests[i].GetHashCode().ToString();
userWithdrawalHistoryBOs.Add(withdrawalHistory);
}
break;
case TransactionType.Sent:
break;
case TransactionType.Received:
break;
case TransactionType.Deposit:
tblUserDeposits = userDepositRequest.Get(transactionQuery, db);
for (int i = 0; i < tblUserDeposits.Count; i++)
{
UserTransactionHistoryBO withdrawalHistory = new UserTransactionHistoryBO();
withdrawalHistory.Address = tblUserDeposits[i].Address;
withdrawalHistory.ID = tblUserDeposits[i].Id;
withdrawalHistory.RequestedOn = tblUserDeposits[i].CreatedOn;
withdrawalHistory.TotalAmount = tblUserDeposits[i].Amount;
withdrawalHistory.WithdrawalStatus = (WithdrawalRequestStatus)tblUserDeposits[i].DepositStatus;
withdrawalHistory.MemberCode = tblUserDeposits[i].UserAuth.UserInfo.Uid;
withdrawalHistory.MemberEmail = tblUserDeposits[i].UserAuth.UserInfo.Email;
withdrawalHistory.MemberName = String.Format("{0} {1}", tblUserDeposits[i].UserAuth.UserInfo.FirstName, tblUserDeposits[i].UserAuth.UserInfo.LastName);
withdrawalHistory.Txid = tblUserDeposits[i].GetHashCode().ToString();
userWithdrawalHistoryBOs.Add(withdrawalHistory);
}
break;
case TransactionType.Withdraw:
userWithdrawalRequests = withdrawRequestRepository.Get(transactionQuery, db);
for (int i = 0; i < userWithdrawalRequests.Count; i++)
{
UserTransactionHistoryBO withdrawalHistory = new UserTransactionHistoryBO();
withdrawalHistory.Address = userWithdrawalRequests[i].Address;
withdrawalHistory.ID = userWithdrawalRequests[i].Id;
withdrawalHistory.RequestedOn = userWithdrawalRequests[i].CreatedOn;
withdrawalHistory.TotalAmount = userWithdrawalRequests[i].TotalAmount;
withdrawalHistory.WithdrawalStatus = (WithdrawalRequestStatus)userWithdrawalRequests[i].WithdrawalStatus;
withdrawalHistory.MemberCode = userWithdrawalRequests[i].UserAuth.UserInfo.Uid;
withdrawalHistory.MemberEmail = userWithdrawalRequests[i].UserAuth.UserInfo.Email;
withdrawalHistory.MemberName = String.Format("{0} {1}", userWithdrawalRequests[i].UserAuth.UserInfo.FirstName, userWithdrawalRequests[i].UserAuth.UserInfo.LastName);
withdrawalHistory.Txid = userWithdrawalRequests[i].GetHashCode().ToString();
userWithdrawalHistoryBOs.Add(withdrawalHistory);
}
break;
default:
break;
}
return(userWithdrawalHistoryBOs);
}
}
