Ejemplo n.º 1
0
 private static void GetPayloadOwners(Payload payload, PlayerStatsController playerStatsController, OwnersController ownerController, OwnerTeamsController ownerTeamsController, PlayersController playersController, SeasonWeeks seasonWeek)
 {
     var leaguePoints = ownerTeamsController.GetLeaguePoints(seasonWeek.SeasonWeekId);
     payload.PayloadOwners = new List<PayloadOwner>();
     foreach (var owner in ownerController.GetOwners())
     {
         payload.PayloadOwners.Add(new PayloadOwner
         {
             Owner = owner,
             OwnerPoints = leaguePoints.Where(lp => lp.UniqueId == owner.UniqueId).First(),
             OwnerPlayerStats = playerStatsController.GetPlayerStatsForOwnerWeek(owner.UniqueId, seasonWeek.SeasonWeekId),
             OwnerTeam = playersController.GetOwnersTeamSimulatedWeek(owner.UniqueId, seasonWeek.SeasonWeekId)
         });
     }
 }
Ejemplo n.º 2
0
 private static void GetPayloadCurrentOwner(Payload payload, PlayerStatsController playerStatsController, OwnersController ownerController, OwnerTeamsController ownerTeamsController, PlayersController playersController, SeasonWeeks seasonWeek, string uniqueId)
 {
     payload.CurrentOwner = ownerController.GetOwnerByUniqueId(uniqueId);
     payload.CurrentTeam = playersController.GetOwnersTeamSimulatedWeek(uniqueId, seasonWeek.SeasonWeekId);
     payload.CurrentOwnerPlayerStats = playerStatsController.GetPlayerStatsForOwnerWeek(uniqueId, seasonWeek.SeasonWeekId);
     payload.Owners = ownerController.GetOwners();
 }
Ejemplo n.º 3
0
        public string GetOwnerPayload(string uniqueId, int seasonWeekId, string owners)
        {
            var payload = new Payload();

            PlayerStatsController playerStatsController = new PlayerStatsController();
            OwnersController ownerController = new OwnersController();
            OwnerTeamsController ownerTeamsController = new OwnerTeamsController();
            WeeksController weeksController = new WeeksController();
            PlayersController playersController = new PlayersController();

            var ownerExists = context.Owners.Where(o => o.UniqueId == uniqueId).First();

            var seasonWeek = new SeasonWeeks();
            if (seasonWeekId == -1)
            {
                seasonWeek = weeksController.GetSeasonWeek(DateTime.Now.ToShortDateString());
            }
            else
            {
                seasonWeek = weeksController.GetSeasonWeek(seasonWeekId);
            }

            GetPayloadOwners(payload, playerStatsController, ownerController, ownerTeamsController, playersController, seasonWeek);

            return Compression.Compress(JsonConvert.SerializeObject(payload));
        }
Ejemplo n.º 4
0
        public string GetUpdatePayload(string uniqueId, int seasonWeekId, string update)
        {
            var payload = new Payload();

            PlayerStatsController playerStatsController = new PlayerStatsController();
            PositionLimitsController positionLimitsController = new PositionLimitsController();
            OwnersController ownerController = new OwnersController();
            OwnerTeamsController ownerTeamsController = new OwnerTeamsController();
            WeeksController weeksController = new WeeksController();
            GamesController gamesController = new GamesController();
            PlayersController playersController = new PlayersController();
            RanksController ranksController = new RanksController();

            var ownerExists = context.Owners.Where(o => o.UniqueId == uniqueId).First();

            var seasonWeek = new SeasonWeeks();
            if (seasonWeekId == -1)
            {
                seasonWeek = weeksController.GetSeasonWeek(DateTime.Now.ToShortDateString());
            }
            else
            {
                seasonWeek = weeksController.GetSeasonWeek(seasonWeekId);
            }

            GetPayloadCurrentOwner(payload, playerStatsController, ownerController, ownerTeamsController, playersController, seasonWeek, uniqueId);

            GetPayloadOwners(payload, playerStatsController, ownerController, ownerTeamsController, playersController, seasonWeek);

            //GetPayloadPositionLimits(payload, positionLimitsController);

            //GetPayloadWeeks(payload, weeksController);

            GetPayloadGames(payload, gamesController, seasonWeek);

            //GetPayloadPlayers(payload, playersController, ownerExists);

            GetPayloadRanks(payload, ranksController, seasonWeek);

            return Compression.Compress(JsonConvert.SerializeObject(payload));
        }
Ejemplo n.º 5
0
        /// <summary>
        /// Get the owner rankings for the current week.
        /// </summary>
        public IEnumerable<Ranks> GetRanks(int seasonWeekId)
        {
            List<Ranks> ranks = new List<Ranks>();
            WeeksController controller = new WeeksController();
            OwnerTeamsController otController = new OwnerTeamsController();
            var seasonWeek = controller.GetSeasonWeek(seasonWeekId);
            int seasonTypeId = seasonWeek.SeasonTypeId;
            int seasonYear = seasonWeek.SeasonYear;
            int currentWeekNum = seasonWeek.WeekNum;

            foreach (var owner in context.Owners)
            {
                Ranks rankThisWeek = new Ranks { OwnerId = owner.OwnerId, TeamName = owner.TeamName, OwnerName = owner.OwnerName, DollarsMade = 0, WeeksWon = new List<WeekWon>(), TotalPoints = 0, PayoutDollars = 0, WeeksWonDollars = 0 };
                ranks.Add(rankThisWeek);
            }

            var dollarsPayout = 50;
            var query = NPGGFFLApi.queries.RanksWeeksWonQuery;
            query = query.Replace("{{:PlayerPointsQuery}}", NPGGFFLApi.queries.PlayerPointsQuery);
            query = query.Replace("{{:GameFilter}}", string.Empty);
            query = query.Replace("{{:PlayerFilter}}", string.Empty);
            query = query.Replace("{{:SeasonYearFilter}}", string.Format("and pp.SeasonYear = {0}", seasonYear));
            query = query.Replace("{{:SeasonTypeFilter}}", string.Format("and pp.SeasonTypeId = {0}", seasonTypeId));
            query = query.Replace("{{:SeasonWeekFilter}}", string.Format("and pp.SeasonEndDtm <= '{0}' and pp.WeekNum <= {1}", DateTime.Now, currentWeekNum));
            var winningOwners = context.ExecuteQuery<WinningOwners>(query);

            foreach (var wo in winningOwners)
            {
                var rankExists = ranks.Where(r => r.OwnerId == wo.OwnerId).FirstOrDefault();
                if (rankExists != null)
                {
                    rankExists.DollarsMade += dollarsPayout;
                    rankExists.WeeksWonDollars += dollarsPayout;
                    rankExists.WeeksWon.Add(new WeekWon { WeekNum = wo.WeekNum });
                }
            }

            var rankQuery = NPGGFFLApi.queries.RanksQuery;
            rankQuery = rankQuery.Replace("{{:PlayerPointsQuery}}", NPGGFFLApi.queries.PlayerPointsQuery);
            rankQuery = rankQuery.Replace("{{:GameFilter}}", string.Empty);
            rankQuery = rankQuery.Replace("{{:PlayerFilter}}", string.Empty);
            rankQuery = rankQuery.Replace("{{:SeasonYearFilter}}", string.Format("and pp.SeasonYear = {0}", seasonYear));
            rankQuery = rankQuery.Replace("{{:SeasonTypeFilter}}", string.Format("and pp.SeasonTypeId = {0}", seasonTypeId));
            rankQuery = rankQuery.Replace("{{:SeasonWeekFilter}}", string.Format("and pp.SeasonEndDtm <= '{0}' and pp.WeekNum <= {1}", DateTime.Now, currentWeekNum));
            var ranksOwners = context.ExecuteQuery<RanksOwners>(rankQuery);

            foreach (var ro in ranksOwners)
            {
                var rankExists = ranks.Where(r => r.OwnerId == ro.OwnerId).FirstOrDefault();
                if (rankExists != null)
                {
                    rankExists.TotalPoints = ro.TotalPoints;
                }
            }

            int rankNum = 1;
            foreach (var rank in ranks.OrderByDescending(r => r.TotalPoints))
            {
                var payoutForPosition = context.LeaguePayouts.Where(lp => lp.RankNum == rankNum).FirstOrDefault();
                if (payoutForPosition != null)
                {
                    rank.DollarsMade += payoutForPosition.DollarAmount;
                    rank.PayoutDollars += payoutForPosition.DollarAmount;
                }
                rankNum++;
            }

            return ranks.OrderByDescending(r => r.TotalPoints).ThenBy(r => r.OwnerName);
        }