Ejemplo n.º 1
0
        public void MakePickDeletesExistingPick()
        {
            var existingPicks = new List<UserPick>();
            var existingPick = new UserPick
                {
                    GameId = GAME_ID,
                    Id = EXISTING_PICK_ID,
                    OptionGroupId = GROUP_ID,
                    OptionType = GameOptionType.Winner,
                    UserId = USER_ID
                };

            existingPicks.Add(existingPick);

            _pickRepository
                .Setup(repository => repository.GetForGame(USER_ID, GAME_ID))
                .Returns(existingPicks);

            var option = new Option<Team>
                {
                    CutOff = DateTime.UtcNow.AddMinutes(1),
                    GameId = GAME_ID,
                    Id = OPTION_ID,
                    GroupId = GROUP_ID
                };

            _optionRepository
                .Setup(repository => repository.Get(OPTION_ID))
                .Returns(option);

            _pickRepository
                .Setup(repository => repository.Pick(USER_ID, GAME_ID, OPTION_ID))
                .Returns(1)
                .Verifiable();

            _pickManager.Pick(USER_ID, OPTION_ID);

            _pickRepository.Verify(repository => repository.Pick(USER_ID, GAME_ID, OPTION_ID), Times.Once());
            _pickRepository.Verify(repository => repository.Delete(USER_ID, EXISTING_PICK_ID), Times.Once());
        }
Ejemplo n.º 2
0
        public UserPick Pick(long userId, long gameOptionId)
        {
            // Get all the picks for the game
            var gameOption = _gameOptionRepository.Get(gameOptionId);

            if (gameOption == null)
            {
                throw new BusinessException(ErrorCodes.InvalidGameOption, "Requested game option does not exist.");
            }

            // Check if were past the cut off time
            if (DateTime.UtcNow > gameOption.CutOff)
            {
                throw new BusinessException(ErrorCodes.PastCutOffTime, "The cut off time to make the requested pick has passed.");
            }

            var gamePicks = _pickRepository.GetForGame(userId, gameOption.GameId);
            var gameId = gameOption.GameId;

            // Check if a pick already exists for the game and group
            var existingPick = gamePicks.FirstOrDefault(pick => pick.GameId == gameId && pick.OptionGroupId == gameOption.GroupId);

            // If a pick doesn't already exist for the game and group then add the pick
            if (existingPick != null)
            {
                // TODO: Log the existing pick
                _pickRepository.Delete(userId, existingPick.Id);
            }

            // Now make the pick
            var pickId = _pickRepository.Pick(userId, gameId, gameOptionId);
            var userPick = new UserPick
                {
                    GameId = gameId,
                    Id = pickId,
                    OptionGroupId = gameOption.GroupId,
                    OptionId = gameOptionId,
                    OptionType = gameOption.Type,
                    UserId = userId
                };

            // TODO: Log the new pick

            return userPick;
        }
Ejemplo n.º 3
0
        private static UserPick MapUserPick(MySqlDataReader dr)
        {
            var pick = new UserPick
                {
                    GameId = dr.GetInt64("gameId"),
                    Id = dr.GetInt64("id"),
                    OptionId = dr.GetInt64("gameOptionId"),
                    OptionGroupId = dr.GetInt64("groupId"),
                    OptionType = (GameOptionType) dr.GetInt32("type"),
                    UserId = dr.GetInt64("userId")
                };

            var outcomeOrdinal = dr.GetOrdinal("outcome");

            if (!dr.IsDBNull(outcomeOrdinal))
            {
                pick.Outcome = (OptionOutcome) dr.GetInt32(outcomeOrdinal);
            }

            return pick;
        }
Ejemplo n.º 4
0
        public IList<UserPick> GetForSeasonAllUsers(int season)
        {
            var picks = new List<UserPick>();

            using (var conn = GetConnection())
            {
                var cmd = new MySqlCommand(GET_PICKS_FOR_SEASON_FOR_ALL_USERS);

                cmd.Parameters.AddWithValue("@season", season);
                ExecuteReader(cmd, dr =>
                    {
                        var pick = new UserPick
                            {
                                OptionId = dr.GetInt64("gameOptionId"),
                                UserId = dr.GetInt64("userId")
                            };

                        picks.Add(pick);
                    });
            }

            return picks;
        }