public TheBetEntity SaveUserBet(List <GameEntity> gameList, int userId)
{
using (var context = new theBetDBEntities())
{
var returnEntity = new TheBetEntity()
{
ErrorMsg = "", Exception = null, gameList = null
};
try
{
foreach (var game in gameList)
{
var userBet = new UserBet()
{
GameId = game.GameId,
UserId = userId,
UserTeam1Goals = game.UserTeam1Goals,
UserTeam2Goals = game.UserTeam2Goals
};
context.UserBet.Add(userBet);
}
context.SaveChanges();
return(returnEntity);
}
catch (Exception ex)
{
returnEntity.Exception = ex.InnerException.StackTrace;
returnEntity.ErrorMsg = ex.Message;
return(returnEntity);
}
}
}
public UserResponse Get(User user)
{
using (var context = new theBetDBEntities())
{
var userResponse = new UserResponse();
try
{
var requestedUser = context.User.Where(u => u.Name.ToLower() == user.Name.ToLower() && u.Password == user.Password).FirstOrDefault();
if (requestedUser != null)
{
userResponse.User = requestedUser;
userResponse.User.Password = null;
}
else
{
userResponse.ErrorMsg = "Wrong username or password. Probably both...";
}
}
catch (Exception ex)
{
userResponse.Exception = ex.InnerException.Message;
userResponse.ErrorMsg = "Error, invalid username or email. Knowing you, I'll bet it's both";
}
return(userResponse);
}
}
public List <UserQuestionAnswer> GetUserQuestions(User user)
{
using (var context = new theBetDBEntities())
{
var userQuestions = context.UserQuestionAnswer.Where(u => u.UserId == user.Id).ToList();
return(userQuestions);
}
}
public List <UserBet> GetUserBet(User user)
{
using (var context = new theBetDBEntities())
{
var userBet = context.UserBet.Where(u => u.UserId == user.Id).ToList();
return(userBet);
}
}
public List <Stage> GetAllStages()
{
using (var context = new theBetDBEntities())
{
var stages = context.Stage.ToList();
return(stages);
}
}
public List <Team> GetAllTeams()
{
using (var context = new theBetDBEntities())
{
var teams = context.Team.ToList();
return(teams);
}
}
public List <Game> GetAllGames()
{
using (var context = new theBetDBEntities())
{
var games = context.Game.ToList();
return(games);
}
}
public List <Question> GetAllQuestions()
{
using (var context = new theBetDBEntities())
{
var questions = context.Question.ToList();
return(questions);
}
}
public bool CheckIfUsernameOrEmailExist(User user)
{
using (var context = new theBetDBEntities())
{
var doesExist = false;
try
{
doesExist = context.User.Any(u => u.Name.ToLower() == user.Name.ToLower() || u.Email.ToLower() == user.Email.ToLower());
}
catch (Exception ex)
{
doesExist = false;
}
return(doesExist);
}
}
public UserResponse Register(User user)
{
using (var context = new theBetDBEntities())
{
var userResponse = new UserResponse();
try
{
context.User.Add(user);
context.SaveChanges();
userResponse.User = user;
userResponse.User.Password = null;
}
catch (Exception ex)
{
userResponse.Exception = ex.InnerException.Message;
userResponse.ErrorMsg = "Error, when creating User, dont ask me why...";
}
return(userResponse);
}
}
