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