Пример #1
0
        private string BuildRanks(SeasonWeek currentWeek)
        {
            var weeklyWinners = BuildWeeklyWinnersDictionary(currentWeek);
            var leaguePayouts = BuildLeaguePayoutsDictionary(currentWeek.SeasonYear);

            var rankDetail = (from rd in context.ExecuteQuery<RankDetail>(NPGGFFL2.queries.RanksQuery.Replace("{{Year}}", currentWeek.SeasonYear.ToString()))
                              group rd by new { rd.OwnerId, rd.TeamName, rd.SeasonYear, rd.SeasonType, rd.SeasonWeekNum, rd.SeasonWeekId } into g
                              select new
                              {
                                  OwnerId = g.Key.OwnerId,
                                  TeamName = g.Key.TeamName,
                                  SeasonYear = g.Key.SeasonYear,
                                  SeasonType = g.Key.SeasonType,
                                  SeasonWeekNum = g.Key.SeasonWeekNum,
                                  SeasonWeekId = g.Key.SeasonWeekId,
                                  PlayerStats = g.ToList().OrderBy(i => i.LineupPriority).ThenByDescending(i => i.Points),
                                  TotalPoints = g.Sum(ps => ps.Points),
                                  Win = (weeklyWinners.ContainsKey(g.Key.SeasonWeekId) ? (weeklyWinners[g.Key.SeasonWeekId].Equals(g.Key.OwnerId) ? true : false) : false)
                              })
                              .OrderBy(i => i.SeasonYear)
                              .ThenBy(i => i.SeasonType)
                              .ThenBy(i => i.SeasonWeekNum)
                              .ThenByDescending(i => i.TotalPoints);

            var rank = (from r in rankDetail
                        group r by new { r.OwnerId, r.TeamName } into g
                        select new
                        {
                            OwnerId = g.Key.OwnerId,
                            TeamName = g.Key.TeamName,
                            TotalPoints = g.Sum(r => r.TotalPoints),                            
                            RankDetail = g.ToList()
                        })
                        .OrderByDescending(r => r.TotalPoints)
                        .Select((r, i) => new {
                            OwnerId = r.OwnerId,
                            TeamName = r.TeamName,
                            TotalPoints = r.TotalPoints,
                            DollarsMade = (leaguePayouts.ContainsKey(i+1) ? leaguePayouts[i+1] : 0) + (r.RankDetail.Where(rd => rd.Win == true).Count() * 50),
                            RankDetail = r.RankDetail
                        });

            return JsonConvert.SerializeObject(rank);
        }
Пример #2
0
        public bool UpdateGames(string updategames)
        {
            bool success = true;

            foreach (var sweek in seasonWeeks)
            {
                var season = Convert.ToInt32(sweek.Split('-')[0].Trim());
                var stype = sweek.Split('-')[1].Trim();
                var week = Convert.ToInt32(sweek.Split('-')[2].Trim());
                
                var xml = HelperMethods.LoadHtmlFromUrl(string.Format("http://www.nfl.com/ajax/scorestrip?season={0}&seasonType={1}&week={2}", season, stype, week));
                var gameXml = XDocument.Parse(xml);

                if (gameXml.Descendants("g").Count() > 0)
                {
                    #region Insert Season Week
                    var seasonWeekExists = context.SeasonWeeks.Where(sw => sw.SeasonWeekId == sweek).FirstOrDefault();

                    if (seasonWeekExists == null)
                    {
                        seasonWeekExists = new SeasonWeek();
                        seasonWeekExists.SeasonWeekId = sweek;
                        seasonWeekExists.SeasonYear = season;
                        seasonWeekExists.SeasonType = stype;
                        seasonWeekExists.SeasonWeekNum = week;
                        seasonWeekExists.StartDtm = DateTime.Now;
                        seasonWeekExists.EndDtm = DateTime.Now;
                        context.SeasonWeeks.InsertOnSubmit(seasonWeekExists);
                    }
                    context.SubmitChanges(); 
                    #endregion

                    #region Insert Games
                    foreach (var game in gameXml.Descendants("g"))
                    {
                        var gameId = Convert.ToInt32(game.Attribute("eid").Value);
                        var gameYear = Convert.ToInt32(gameId.ToString().Substring(0, 4));
                        var gameMonth = Convert.ToInt32(gameId.ToString().Substring(4, 2));
                        var gameDay = Convert.ToInt32(gameId.ToString().Substring(6, 2));
                        var gameTime = game.Attribute("t").Value;
                        var gameHour = Convert.ToInt32(gameTime.Split(':')[0].Trim());
                        var gameMinute = Convert.ToInt32(gameTime.Split(':')[1].Trim());

                        var gameExists = context.Games.Where(g => g.GameId == gameId).FirstOrDefault();
                        if (gameExists == null)
                        {
                            Game g = new Game();
                            g.GameId = gameId;
                            g.ESPNId = 0;
                            g.SeasonWeekId = sweek;
                            g.HomeTeamId = game.Attribute("h").Value.ToLower();
                            g.AwayTeamId = game.Attribute("v").Value.ToLower();
                            g.GameDtm = new DateTime(gameYear, gameMonth, gameDay, gameHour, gameMinute, 0);
                            context.Games.InsertOnSubmit(g);
                        }
                    }

                    context.SubmitChanges(); 
                    #endregion

                    #region Update Start & End Dtm
                    var firstGame = seasonWeekExists.Games.OrderBy(g => g.GameDtm).FirstOrDefault();
                    var lastGame = seasonWeekExists.Games.OrderByDescending(g => g.GameDtm).FirstOrDefault();
                    var dt = firstGame.GameDtm;
                    while (dt.DayOfWeek != DayOfWeek.Wednesday) dt = dt.AddDays(-1);
                    seasonWeekExists.StartDtm = new DateTime(dt.Year, dt.Month, dt.Day, 0, 0, 0);
                    dt = lastGame.GameDtm;
                    while (dt.DayOfWeek != DayOfWeek.Tuesday) dt = dt.AddDays(1);
                    seasonWeekExists.EndDtm = new DateTime(dt.Year, dt.Month, dt.Day, 23, 59, 59);
                    context.SubmitChanges(); 
                    #endregion
                }
            }

            return success;
        }
Пример #3
0
        private Dictionary<string,string> BuildWeeklyWinnersDictionary(SeasonWeek currentWeek)
        {
            Dictionary<string, string> dict = new Dictionary<string, string>();
            var weeklyWinnerQuery = context.ExecuteQuery<WeeklyWinner>(NPGGFFL2.queries.WeeklyWinnersQuery.Replace("{{Year}}", currentWeek.SeasonYear.ToString()));

            foreach (var ww in weeklyWinnerQuery)
            {
                dict.Add(ww.SeasonWeekId, ww.OwnerId);              
            }

            return dict;
        }
Пример #4
0
 partial void DeleteSeasonWeek(SeasonWeek instance);
Пример #5
0
 partial void UpdateSeasonWeek(SeasonWeek instance);
Пример #6
0
 partial void InsertSeasonWeek(SeasonWeek instance);