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