public IList <IUserDTO> GetAll()
{
IList <IUserDTO> tempUserList = new List <IUserDTO>();
try
{
CasinoPortalEntities context = new CasinoPortalEntities();
using (context)
{
var items = context.Users.ToList();
foreach (var eachItem in items)
{
IUserDTO userDTO = (IUserDTO)DTOFactory.Instance.Create(DTOType.UserDTO);
EntityConverter.FillDTOFromEntity(eachItem, userDTO);
tempUserList.Add(userDTO);
}
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
return(tempUserList);
}
public IUserDTO CreateUser(IUserDTO userDTO)
{
IUserDTO retVal = null;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
userDTO.BlockedAmount = 0;
userDTO.AccountBalance = 500;
userDTO.UniqueUserId = RandomString(8);
User user = new User();
EntityConverter.FillEntityFromDTO(userDTO, user);
context.Users.Add(user);
context.SaveChanges();
userDTO.UserID = user.UserID;
retVal = userDTO;
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
return(retVal);
}
public IList <IUserDTO> GetAllUser()
{
List <IUserDTO> all = null;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
all = new List <IUserDTO>();
foreach (Player v in context.Players)
{
IUserDTO userDTO = (IUserDTO)DTOFactory.Instance.Create(DTOType.UserDTO);
EntityDataModel.EntityConverter.FillDTOFromEntity(v, userDTO);
all.Add(userDTO);
}
return(all);
}
}
catch (Exception exception)
{
ExceptionManager.HandleException(exception);
throw new DACException(exception.Message);
}
}
public IUserDTO GetUserByEmailId(string emailId)
{
IUserDTO userDTO = null;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
//var userId = context.Employees.Where(m => m.Email == emailId).Select(m => m.EmployeeId).SingleOrDefault();
Player user = context.Players.FirstOrDefault(m => m.EmailId == emailId);
//
if (user != null)
{
userDTO = (IUserDTO)DTOFactory.Instance.Create(DTOType.UserDTO);
EntityDataModel.EntityConverter.FillDTOFromEntity(user, userDTO);
return(userDTO);
}
}
return(userDTO);
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
}
public IUserDTO AddWinningPrize(string emailId, decimal betAmount, decimal multiplyFactor)
{
IUserDTO userDTO = null;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
Player user = context.Players.FirstOrDefault(m => m.EmailId == emailId);
if (user != null)
{
user.AccountBalance += (decimal)(user.BlockedAmount * multiplyFactor);
user.BlockedAmount = 0;
userDTO = (IUserDTO)DTOFactory.Instance.Create(DTOType.UserDTO);
EntityDataModel.EntityConverter.FillDTOFromEntity(user, userDTO);
if (context.SaveChanges() > 0)
{
return(userDTO);
}
}
}
return(userDTO);
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
}
public IUserDTO CreateAUser(IUserDTO customer)
{
IUserDTO createUserRetVal = null;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
Player user = new Player();
customer.BlockedAmount = 0;
customer.AccountBalance = 500;
EntityConverter.FillEntityFromDTO(customer, user);
context.Players.Add(user);
if (context.SaveChanges() > 0)
{
createUserRetVal = customer;
createUserRetVal.PlayerId = user.PlayerId;
}
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
return(createUserRetVal);
}
public IUserDTO GetUserByContactNumber(string contactNumber)
{
IUserDTO userDTO = null;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
Player user = context.Players.FirstOrDefault(m => m.ContactNumber == contactNumber);
if (user != null)
{
userDTO = (IUserDTO)DTOFactory.Instance.Create(DTOType.UserDTO);
EntityDataModel.EntityConverter.FillDTOFromEntity(user, userDTO);
return(userDTO);
}
}
return(userDTO);
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
}
public IUserDTO AddUserMoney(string emailId, decimal rechargeAmount)
{
IUserDTO userDTO = null;
try
{
//userDTO = GetUserByEmailId(emailId);
//userDTO.AccountBalance+=rechargeAmount;
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
//var userId = context.Employees.Where(m => m.Email == emailId).Select(m => m.EmployeeId).SingleOrDefault();
Player user = context.Players.FirstOrDefault(m => m.EmailId == emailId);
if (user != null)
{
user.AccountBalance += rechargeAmount;
userDTO = (IUserDTO)DTOFactory.Instance.Create(DTOType.UserDTO);
EntityDataModel.EntityConverter.FillDTOFromEntity(user, userDTO);
if (context.SaveChanges() > 0)
{
return(userDTO);
}
return(userDTO);
}
}
return(userDTO);
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
}
public IList <IUserDTO> SearchUser(string nameSearch, string contactSearch, string emailSearch)
{
IList <IUserDTO> returnedList = null;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
IList <SearchEmployee_Result> userList = new List <SearchEmployee_Result>();
userList = (IList <SearchEmployee_Result>)context.SearchEmployee(nameSearch, emailSearch, contactSearch).ToList();
if (userList.Count > 0)
{
returnedList = new List <IUserDTO>();
foreach (var user in userList)
{
IUserDTO userDTO = (IUserDTO)DTOFactory.Instance.Create(DTOType.UserDTO);
EntityDataModel.EntityConverter.FillDTOFromEntity(user, userDTO);
returnedList.Add(userDTO);
}
}
}
}
catch (Exception exception)
{
ExceptionManager.HandleException(exception);
throw new DACException(exception.Message);
}
return(returnedList);
}
public bool DeleteUser(int userId)
{
bool tempRV = false;
try
{
using (CasinoPortalEntities context = new CasinoPortalEntities())
{
var foundItem = context.Users.ToList().Where(eachItem => eachItem.UserID == userId).FirstOrDefault();
if (foundItem != null)
{
context.Users.Remove(foundItem);
context.SaveChanges();
tempRV = true;
}
}
}
catch (Exception ex)
{
ExceptionManager.HandleException(ex);
throw new DACException(ex.Message);
}
return(tempRV);
}
