public bool Create(TblUserWithdrawalRequest userWithdrawalRequest, dbGSCasinoContext db)
{
db.TblUserWithdrawalRequest.Add(userWithdrawalRequest);
db.SaveChanges();
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 List <TblUserDepositRequest> Get(TransactionQueryBO transactionQuery, dbGSCasinoContext db)
{
// ENUMERATE ALL WALELT TYPES
var _q = from UDR in db.TblUserDepositRequest
from UA in db.TblUserAuth where UDR.UserAuthId == UA.Id
join userInfo in db.TblUserInfo on UA.UserInfoId equals userInfo.Id
//where UDR.DepositStatus == (short)transactionQuery.RequestStatus
//&& a.CreatedOn >= transactionQuery.DateFrom && a.CreatedOn <= transactionQuery.DateTo
select new TblUserDepositRequest
{
Id = UDR.Id,
Address = UDR.Address,
Amount = UDR.Amount,
CreatedOn = UDR.CreatedOn,
UserAuthId = UDR.UserAuthId,
DepositStatus = UDR.DepositStatus,
SourceCurrencyId = UDR.SourceCurrencyId,
TargetWalletTypeId = UDR.TargetWalletTypeId,
Remarks = UDR.Remarks,
CreatedBy = UDR.CreatedBy,
UserAuth = new TblUserAuth {
Id = UDR.UserAuth.Id, UserInfo = UA.UserInfo, UserAlias = UA.UserAlias, UserName = UA.UserName
}
};
List <TblUserDepositRequest> _qWalletTypeRes = _q.ToList <TblUserDepositRequest>();
return(_qWalletTypeRes);
}
public bool Update(TblUserWithdrawalRequest tblUserWithdrawalRequest, dbGSCasinoContext db)
{
try
{
db.TblUserWithdrawalRequest.Update(tblUserWithdrawalRequest);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
return(true);
}
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 TblUserAuth Get(UserBO userBO, dbGSCasinoContext 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 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 TblUserInfo Create(UserBO userBO, dbGSCasinoContext db)
{
TblUserInfo _userInfo = new TblUserInfo();
_userInfo.FirstName = userBO.FirstName;
_userInfo.LastName = userBO.LastName;
_userInfo.PhoneNumber = userBO.PhoneNumber;
_userInfo.Email = userBO.Email;
_userInfo.Dob = userBO.Dob;
_userInfo.CountryIsoCode2 = userBO.CountryIsoCode2;
_userInfo.Gender = userBO.Gender;
_userInfo.Uid = new Guid().ToString();
_userInfo.IsEnabled = true;
db.TblUserInfo.Add(_userInfo);
db.SaveChanges();
return(_userInfo);
}
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 bool Create(short authStatus, TblUserAuth userAuth, dbGSCasinoContext 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 TblUserInfo Get(TblUserAuth userAuth, dbGSCasinoContext 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);
}
public List <UserWalletBO> GetBO(TblUserAuth userAuth, dbGSCasinoContext 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
};
List <UserWalletBO> userWallet = _qUi.ToList <UserWalletBO>();
return(userWallet);
}
public TblUserAuth Create(UserBO userBO, TblUserInfo userInfo, dbGSCasinoContext db)
{
TblUserAuth _userAuth = new TblUserAuth();
byte[] _passwordByte = Encoding.ASCII.GetBytes(userBO.PasswordString);
byte[] _hashPasswordByte;
SHA512 shaM = new SHA512Managed();
_hashPasswordByte = shaM.ComputeHash(_passwordByte);
string base64Password = System.Convert.ToBase64String(_hashPasswordByte);
_userAuth.UserName = userBO.UserName;
_userAuth.PasswordByte = _hashPasswordByte;
_userAuth.IsTempPassword = false;
_userAuth.IsEnabled = true;
_userAuth.LoginStatus = 1;
_userAuth.UserInfoId = userInfo.Id;
db.TblUserAuth.Add(_userAuth);
db.SaveChanges();
return(_userAuth);
}
public List <TblUserWithdrawalRequest> Get(TransactionQueryBO transactionQuery, dbGSCasinoContext db)
{
// ENUMERATE ALL WALELT TYPES
var _q = from a in db.TblUserWithdrawalRequest
//where a.WithdrawalStatus == (short)transactionQuery.RequestStatus
//&& a.CreatedOn >= transactionQuery.DateFrom && a.CreatedOn <= transactionQuery.DateTo
from UA in db.TblUserAuth where a.UserAuthId == UA.Id
join userInfo in db.TblUserInfo on UA.UserInfoId equals userInfo.Id
select new TblUserWithdrawalRequest
{
Id = a.Id,
Address = a.Address,
TotalAmount = a.TotalAmount,
CreatedOn = a.CreatedOn,
UserAuthId = a.UserAuthId,
WithdrawalStatus = a.WithdrawalStatus,
SourceWalletTypeId = a.SourceWalletTypeId,
TargetCurrencyId = a.TargetCurrencyId,
Remarks = a.Remarks,
CreatedBy = a.CreatedBy,
UserAuth = new TblUserAuth {
Id = a.UserAuth.Id, UserInfo = UA.UserInfo, UserAlias = UA.UserAlias, UserName = UA.UserName
}
};
List <TblUserWithdrawalRequest> _qWalletTypeRes = _q.ToList <TblUserWithdrawalRequest>();
return(_qWalletTypeRes);
}
