public List <UserWalletBO> GetBO(TblUserAuth userAuth, Minny_Casino_AffiliateContext db)
{
var _qUi = from a in db.TblUserWallet
join b in db.TblWalletType on a.WalletTypeId equals b.Id
join c in db.TblExchangeRate on a.WalletType.CurrencyId equals c.SourceCurrencyId
where a.UserAuthId == userAuth.Id
select new UserWalletBO
{
Id = a.Id,
UserAuthId = a.UserAuthId,
WalletTypeId = a.WalletTypeId,
IsEnabled = a.IsEnabled,
Balance = a.Balance,
BalanceFiat = a.Balance * c.Value,
CreatedOn = a.CreatedOn,
ModifiedOn = a.ModifiedOn,
WalletType = a.WalletType,
WalletName = a.WalletType.Name,
WalletCode = a.WalletType.Code
};
List <UserWalletBO> userWallet = _qUi.ToList <UserWalletBO>();
return(userWallet);
}
public ActionResult Send([FromBody] WalletTransactionBO walletTransaction)
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserAppService userAppService = new UserAppService();
TblUserInfo userInfo = userAppService.Get(userAuth);
UserResponseBO _apiResponse = new UserResponseBO();
TransactionAppService transactionAppService = new TransactionAppService();
transactionAppService.CreateWithdrawalRequest(walletTransaction);
_apiResponse.HttpStatusCode = "200";
_apiResponse.Message = "Transaction successful";
_apiResponse.Status = "Success";
return(Ok(_apiResponse));
}
catch (Exception ex)
{
ApiResponseBO _apiResponse = new ApiResponseBO();
_apiResponse.HttpStatusCode = "400";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
return(BadRequest(_apiResponse));
}
}
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 ActionResult Get()
{
UserWalletAppService userWalletAppService = new UserWalletAppService();
UserAuthResponse _apiResponse = new UserAuthResponse();
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
_apiResponse.UserWallet = userWalletAppService.GetBO(userAuth);
_apiResponse.HttpStatusCode = "200";
_apiResponse.Message = "UserWallet GET";
_apiResponse.Status = "Success";
}
catch (Exception ex)
{
_apiResponse.HttpStatusCode = "500";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
}
return(Ok(_apiResponse));
}
public ActionResult Receive([FromBody] WalletRecieveBO walletRecieve)
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserAppService userAppService = new UserAppService();
TblUserInfo userInfo = userAppService.Get(userAuth);
WalletRecieveBO wallet = new WalletRecieveBO();
wallet.AddressString = "Cardano wallet address";
wallet.CallbackUrl = "Your callback url";
return(Ok(wallet));
}
catch (Exception ex)
{
ApiResponseBO _apiResponse = new ApiResponseBO();
_apiResponse.HttpStatusCode = "400";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
return(BadRequest(_apiResponse));
}
}
public ActionResult Create()
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserAppService userAppService = new UserAppService();
TblUserInfo userInfo = userAppService.Get(userAuth);
WalletBO wallet = new WalletBO();
wallet.xPriv = "Cardano private key";
wallet.xPub = "Cardano public key";
return(Ok(wallet));
}
catch (Exception ex)
{
ApiResponseBO _apiResponse = new ApiResponseBO();
_apiResponse.HttpStatusCode = "400";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
return(BadRequest(_apiResponse));
}
}
public ActionResult GetWallet([FromBody] WalletBO wallet)
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserAppService userAppService = new UserAppService();
TblUserInfo userInfo = userAppService.Get(userAuth);
List <WalletBO> walletBOs = new List <WalletBO>();
WalletBO walletBO = new WalletBO();
wallet.xPriv = "Cardano private key";
wallet.xPub = "Cardano public key";
wallet.Balance.Amount = 10m;
walletBOs.Add(walletBO);
return(Ok(walletBOs));
}
catch (Exception ex)
{
ApiResponseBO _apiResponse = new ApiResponseBO();
_apiResponse.HttpStatusCode = "400";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
return(BadRequest(_apiResponse));
}
}
public ActionResult UpdateWithdrawalRequest(TransactionQueryBO transactionQuery)
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserResponseBO _apiResponse = new UserResponseBO();
TransactionAppService transactionAppService = new TransactionAppService();
transactionAppService.UpdateWithdrawalRequest(transactionQuery);
_apiResponse.HttpStatusCode = "200";
_apiResponse.Message = "Transaction successful";
_apiResponse.Status = "Success";
return(Ok(_apiResponse));
}
catch (Exception ex)
{
ApiResponseBO _apiResponse = new ApiResponseBO();
_apiResponse.HttpStatusCode = "400";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
return(BadRequest(_apiResponse));
}
}
public ActionResult BackupFunds()
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserResponseBO _apiResponse = new UserResponseBO();
_apiResponse.HttpStatusCode = "200";
_apiResponse.Message = "Transaction successful";
_apiResponse.Status = "Success";
return(Ok(_apiResponse));
}
catch (Exception ex)
{
ApiResponseBO _apiResponse = new ApiResponseBO();
_apiResponse.HttpStatusCode = "400";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
return(BadRequest(_apiResponse));
}
}
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 bool Create(TblUserAuth userAuth, dbGSCasinoContext db)
{
// ENUMERATE ALL WALELT TYPES
var _q = from a in db.TblWalletType
where a.Type == 1
select new TblWalletType
{
Name = a.Name,
Desc = a.Desc,
Type = a.Type,
Code = a.Code,
Id = a.Id
};
List <TblWalletType> _qWalletTypeRes = _q.ToList <TblWalletType>();
for (int i = 0; i < _qWalletTypeRes.Count; i++)
{
var _userWallet = new TblUserWallet();
_userWallet.UserAuthId = userAuth.Id;
_userWallet.WalletTypeId = _qWalletTypeRes[i].Id;
_userWallet.Balance = 0.0m;
_userWallet.IsEnabled = true;
db.TblUserWallet.Add(_userWallet);
}
db.SaveChanges();
return(true);
}
public async Task <IActionResult> Index()
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
SessionBO session = sessionController.GetSession(HttpContext.Session);
ApiRequest apiRequest = new ApiRequest();
ResponseBO _res = await apiRequest.GetAsync("User/Profile", session.SessionCookies);
UserResponseBO apiResponse = JsonConvert.DeserializeObject <UserResponseBO>(_res.ResponseResult);
TblUserInfo userInfo = apiResponse.UserInfo;
TblUserAuth userAuth = apiResponse.UserAuth;
if (apiResponse.HttpStatusCode == "200")
{
ActivityVM activityVM = new ActivityVM();
activityVM.Fullname = String.Format("{0} {1}", userInfo.FirstName, userInfo.LastName);
activityVM.Username = userAuth.UserName;
return(View(activityVM));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (System.Exception e)
{
return(RedirectToAction("Login", "Home"));
}
}
public TblUserRole Create(TblUserAuth userAuth, dbGSCasinoContext db)
{
TblUserRole userRole = new TblUserRole();
userRole.UserAuthId = userAuth.Id;
userRole.IsEnabled = true;
userRole.AccessRole = AccessRole.Client.ToString();
db.TblUserRole.Add(userRole);
db.SaveChanges();
return(userRole);
}
public TblUserInfo Get(TblUserAuth userAuth)
{
using (var db = new dbWorldCCityContext())
{
using (var transaction = db.Database.BeginTransaction())
{
UserInfoRepository userInfoRepository = new UserInfoRepository();
TblUserInfo userInfo = userInfoRepository.Get(userAuth, db);
return(userInfo);
}
}
}
public TblUserInfo Get(TblUserAuth userAuth)
{
using (var db = new Minny_Casino_AffiliateContext())
{
using (var transaction = db.Database.BeginTransaction())
{
UserInfoRepository userInfoRepository = new UserInfoRepository();
TblUserInfo userInfo = userInfoRepository.Get(userAuth, db);
return(userInfo);
}
}
}
public TblUserAuth Get(UserBO userBO, dbWorldCCityContext db)
{
byte[] _passwordByte = Encoding.ASCII.GetBytes(userBO.PasswordString);
byte[] _hashPasswordByte;
SHA512 shaM = new SHA512Managed();
_hashPasswordByte = shaM.ComputeHash(_passwordByte);
string base64Password = System.Convert.ToBase64String(_hashPasswordByte);
var _qAuth = from a in db.TblUserAuth
where a.UserName == userBO.UserName && a.PasswordByte == _hashPasswordByte
select new TblUserAuth
{
UserName = a.UserName,
PasswordByte = a.PasswordByte,
IsEnabled = a.IsEnabled,
UserInfoId = a.UserInfoId,
Id = a.Id
};
TblUserAuth tblUserAuth = _qAuth.FirstOrDefault();
if (tblUserAuth == null)
{
var _qAuth2 = from a in db.TblUserAuth
where a.UserName == userBO.UserName
select new TblUserAuth
{
UserName = a.UserName,
PasswordByte = a.PasswordByte,
IsEnabled = a.IsEnabled,
UserInfoId = a.UserInfoId,
Id = a.Id
};
tblUserAuth = _qAuth2.FirstOrDefault();
if (tblUserAuth == null)
{
throw new System.ArgumentException("User Does Not Exist");
}
UserAuthHistoryRepository userAuthHistoryRepository = new UserAuthHistoryRepository();
userAuthHistoryRepository.Create((int)AuthStatus.Invalid_User, tblUserAuth, db);
throw new System.ArgumentException("User Authentication Failed");
}
else
{
UserAuthHistoryRepository userAuthHistoryRepository = new UserAuthHistoryRepository();
userAuthHistoryRepository.Create((int)AuthStatus.Success, tblUserAuth, db);
return(tblUserAuth);
}
}
public TblUserAuth GetSession(ISession session)
{
string _currentUserSession = session.GetString(USER_SESSION);
if (_currentUserSession != null)
{
TblUserAuth userAuth = JsonConvert.DeserializeObject <TblUserAuth>(_currentUserSession);
return(userAuth);
}
else
{
throw new System.ArgumentException("User session invalid or expired.");
}
}
public TblUserRole Get(TblUserAuth userAuth, dbGSCasinoContext db)
{
var _qObj = from a in db.TblUserRole
where a.UserAuthId == userAuth.Id
select new TblUserRole
{
AccessRole = a.AccessRole,
IsEnabled = a.IsEnabled,
CreatedOn = a.CreatedOn,
Id = a.Id
};
TblUserRole userRole = _qObj.FirstOrDefault();
return(userRole);
}
public async Task <IActionResult> LoginAsync([FromBody] UserBO userBO)
{
try
{
ApiRequest apiRequest = new ApiRequest();
ResponseBO _res = await apiRequest.PostAsync("User/Authenticate", userBO);
UserResponseBO apiResponse = JsonConvert.DeserializeObject <UserResponseBO>(_res.ResponseResult);
if (apiResponse.HttpStatusCode == "200")
{
SessionController sessionController = new SessionController();
sessionController.CreateSession(apiResponse, _res.ResponseCookies, HttpContext.Session);
TblUserInfo tblUserInfo = apiResponse.UserInfo;
TblUserAuth tblUserAuth = apiResponse.UserAuth;
TblUserRole tblUserRole = apiResponse.UserRole;
//if (tblUserRole.AccessRole.Equals("Admin") || tblUserRole.AccessRole.Equals("SuperAdmin"))
//{
// apiResponse.RedirectUrl = "/Admin/";
//}
//else
//{
// apiResponse.RedirectUrl = "/Dashboard/";
//}
apiResponse.RedirectUrl = "/Dashboard/";
return(Ok(apiResponse));
}
else
{
apiResponse.RedirectUrl = "/User/Login/Failed";
return(BadRequest(apiResponse));
}
}
catch (System.Exception e)
{
UserResponseBO apiResponse = new UserResponseBO();
apiResponse.RedirectUrl = "/User/Login/Failed";
apiResponse.Message = e.Message;
return(BadRequest(apiResponse));
//return Redirect("~/User/Login/Failed");
}
}
// GET: /<controller>/
public async Task <IActionResult> Index()
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
SessionBO session = sessionController.GetSession(HttpContext.Session);
ApiRequest apiRequest = new ApiRequest();
ResponseBO _res = await apiRequest.GetAsync("User/Profile", session.SessionCookies);
UserResponseBO apiResponse = JsonConvert.DeserializeObject <UserResponseBO>(_res.ResponseResult);
TblUserInfo userInfo = apiResponse.UserInfo;
TblUserAuth userAuth = apiResponse.UserAuth;
_res = await apiRequest.GetAsync("User/Wallet", session.SessionCookies);
apiResponse = JsonConvert.DeserializeObject <UserResponseBO>(_res.ResponseResult);
List <UserWalletBO> userWallets = apiResponse.UserWallet;
if (apiResponse.HttpStatusCode == "200")
{
DashboardVM dashboardVM = new DashboardVM();
dashboardVM.Fullname = String.Format("{0} {1}", userInfo.FirstName, userInfo.LastName);
dashboardVM.TotalCustomer = (int)userWallets.Find(i => i.WalletCode == "DLN").Balance;
dashboardVM.TotalFirstDeposit = (int)userWallets.Find(i => i.WalletCode == "IDC").Balance;
dashboardVM.TotalHits = (int)userWallets.Find(i => i.WalletCode == "HIT").Balance;
dashboardVM.TotalIncome = (int)userWallets.Find(i => i.WalletCode == "TIN").Balance;
dashboardVM.TotalSignUps = (int)userWallets.Find(i => i.WalletCode == "TCR").Balance;
dashboardVM.Username = userAuth.UserName;
return(View(dashboardVM));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
catch (System.Exception e)
{
return(RedirectToAction("Login", "Home"));
}
}
public List <TblUserWallet> Get(TblUserAuth tblUserAuth, Minny_Casino_AffiliateContext db = null)
{
if (db != null)
{
UserWalletRepository userWalletRepository = new UserWalletRepository();
return(userWalletRepository.Get(tblUserAuth, db));
}
else
{
using (db = new Minny_Casino_AffiliateContext())
{
using (var transaction = db.Database.BeginTransaction())
{
UserWalletRepository userWalletRepository = new UserWalletRepository();
return(userWalletRepository.Get(tblUserAuth, db));
}
}
}
}
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 List <TblUserWallet> Get(TblUserAuth userAuth, dbGSCasinoContext db)
{
var _qUi = from a in db.TblUserWallet
join b in db.TblWalletType on a.WalletTypeId equals b.Id
where a.UserAuthId == userAuth.Id
select new TblUserWallet
{
Id = a.Id,
UserAuthId = a.UserAuthId,
WalletTypeId = a.WalletTypeId,
IsEnabled = a.IsEnabled,
Balance = a.Balance,
CreatedOn = a.CreatedOn,
ModifiedOn = a.ModifiedOn,
WalletType = a.WalletType
};
List <TblUserWallet> userWallet = _qUi.ToList <TblUserWallet>();
return(userWallet);
}
public ActionResult GetBalance([FromBody] AddressBO address)
{
try
{
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserAppService userAppService = new UserAppService();
TblUserInfo userInfo = userAppService.Get(userAuth);
AddressBO addressBO = new AddressBO();
addressBO.AddressString = address.AddressString;
addressBO.Value.Amount = 10m;
return(Ok(addressBO));
}
catch (Exception)
{
throw;
}
}
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 UserAuthResponse Authenticate(UserBO userBO)
{
using (var db = new dbWorldCCityContext())
{
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);
UserAuthResponse userAuthResponse = new UserAuthResponse();
userAuthResponse.UserInfo = userInfo;
userAuthResponse.UserWallet = userWallet;
userAuthResponse.UserAuth = userAuth;
return(userAuthResponse);
}
}
public ActionResult GetServerBalance()
{
try
{
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserAppService userAppService = new UserAppService();
TblUserInfo userInfo = userAppService.Get(userAuth);
ServerWalletBO serverWallet = new ServerWalletBO();
serverWallet.ServerBalance = 10000;
serverWallet.ServerDeposit = 2000;
serverWallet.TransferedToColdWallet = 30m;
return(Ok(serverWallet));
}
catch (Exception)
{
throw;
}
}
public bool Create(short authStatus, TblUserAuth userAuth, Minny_Casino_AffiliateContext db)
{
TblUserAuthHistory _userAuthHistory = new TblUserAuthHistory();
_userAuthHistory.AuthStatus = authStatus;
_userAuthHistory.UserAuthId = userAuth.Id;
if (authStatus == (int)AuthStatus.Success)
{
_userAuthHistory.IsSuccess = true;
}
else
{
_userAuthHistory.IsSuccess = false;
}
db.TblUserAuthHistory.Add(_userAuthHistory);
db.SaveChanges();
return(true);
}
public ActionResult History([FromBody] WalletBO wallet)
{
try
{
// GET SESSIONS
SessionController sessionController = new SessionController();
TblUserAuth userAuth = sessionController.GetSession(HttpContext.Session);
UserAppService userAppService = new UserAppService();
TblUserInfo userInfo = userAppService.Get(userAuth);
List <WalletTransactionBO> walletTransactions = new List <WalletTransactionBO>();
WalletTransactionBO walletTransaction = new WalletTransactionBO();
walletTransaction.From = "from wallet address..";
walletTransaction.To = "to wallet address..";
walletTransaction.Amount = 100f;
walletTransactions.Add(walletTransaction);
walletTransaction.From = "from wallet address..";
walletTransaction.To = "to wallet address..";
walletTransaction.Amount = 100f;
walletTransactions.Add(walletTransaction);
return(Ok(walletTransactions));
}
catch (Exception ex)
{
ApiResponseBO _apiResponse = new ApiResponseBO();
_apiResponse.HttpStatusCode = "400";
_apiResponse.Message = ex.Message;
_apiResponse.Status = "Error";
return(BadRequest(_apiResponse));
}
}
public TblUserInfo Get(TblUserAuth userAuth, Minny_Casino_AffiliateContext db)
{
var _qUi = from a in db.TblUserInfo
where a.Id == userAuth.UserInfoId
select new TblUserInfo
{
FirstName = a.FirstName,
LastName = a.LastName,
Dob = a.Dob,
Email = a.Email,
PhoneNumber = a.PhoneNumber,
Gender = a.Gender,
Uid = a.Uid,
EmailStatus = a.EmailStatus,
CreatedOn = a.CreatedOn,
CountryIsoCode2 = a.CountryIsoCode2,
CompanyName = a.CompanyName
};
TblUserInfo _tblUserInfo = _qUi.FirstOrDefault();
return(_tblUserInfo);
}
