Пример #1
0
        private void DoUpdateNFLMatchupsESPN()
        {
            try
            {
                System.Net.WebClient client = new System.Net.WebClient();
                string        json          = client.DownloadString("http://site.api.espn.com/apis/site/v2/sports/football/nfl/scoreboard");
                API.ESPN.Feed model         = Newtonsoft.Json.JsonConvert.DeserializeObject <API.ESPN.Feed>(json);

                var   data     = DBModel();
                int[] nflYears = data.NFL_years.Where(x => x.sport_id == 100).Select(x => x.id).ToArray();
                int[] nflWeeks = data.NFL_weeks.Where(x => nflYears.Contains(x.year_id.Value)).Select(x => x.week).ToArray();

                var matchupsWithoutWinner = data.NFL_Matchups.Where(x => x.winner == null && nflWeeks.Contains(x.week) && model.week.number == x.year_week).ToList();

                foreach (var matchup in matchupsWithoutWinner)
                {
                    int week   = matchup.year_week ?? matchup.week;
                    int yearId = data.NFL_weeks.First(x => x.week == matchup.week).year_id ?? 1;
                    int year   = data.NFL_years.First(x => x.id == yearId).year;

                    API.ESPN.Event apiMatchup = model.events.FirstOrDefault(m =>
                                                                            CheckForWeirdName(m.competitions.First().competitors.First(c => c.homeAway == "home").team.shortDisplayName) == matchup.home &&
                                                                            CheckForWeirdName(m.competitions.First().competitors.First(c => c.homeAway == "away").team.shortDisplayName) == matchup.away);

                    if (apiMatchup != null)
                    {
                        UpdateMatchup(matchup, apiMatchup);
                    }
                }

                if (_changesMade)
                {
                    data.SubmitChanges();
                }

                checkIfWeeksNeedToBeClosed();
            }
            catch (Exception ex)
            {
                try
                {
                    //if (IsAppInTestMode())
                    LibCommon.SendEmail("*****@*****.**", "Exception in DoUpdateNFLMatchupsESPN()", ex.ToString(), "EricWrightSite");
                }
                catch { }
            }
        }
Пример #2
0
        private void UpdateMatchup(db.NFL_Matchup matchup, API.ESPN.Event node)
        {
            matchup.status    = node.status.type.state;
            matchup.eid       = Convert.ToInt64(node.id);
            matchup.scheduled = node.date.ToLocalTime().ToShortDateString();

            List <string> channels = new List <string>();

            node.competitions.ToList().ForEach(c => c.broadcasts.ToList().ForEach(b => b.names.ToList().ForEach(n => channels.Add(n))));
            matchup.channel = string.Join(", ", channels.Distinct().ToArray());

            List <string> venues = new List <string>();

            node.competitions.ToList().ForEach(c => venues.Add(c.venue.fullName));
            matchup.stadium = string.Join(", ", venues.Distinct().ToArray());

            //int statusInt;
            bool live = node.status.type.state != "pre" && node.status.type.state != "post";

            matchup.live_update = live ?
                                  matchup.live_update = $"Clock: { node.status.displayClock }, Quarter: { node.status.period }" :
                                                        null;

            if (live)
            {
                _changesMade = true;
            }

            if (matchup.status != null)
            {
                int?oldHome = matchup.home_score;
                int?oldAway = matchup.away_score;

                int    homeScore;
                string homeScoreString = node.competitions.First().competitors.First(c => c.homeAway == "home").score;
                if (int.TryParse(homeScoreString, out homeScore))
                {
                    matchup.home_score = homeScore;
                }
                int    awayScore;
                string awayScoreString = node.competitions.First().competitors.First(c => c.homeAway == "away").score;
                if (int.TryParse(awayScoreString, out awayScore))
                {
                    matchup.away_score = awayScore;
                }

                if (matchup.home_score.HasValue && matchup.away_score.HasValue &&
                    (oldAway != matchup.away_score.Value || oldHome != matchup.home_score.Value))
                {
                    _changesMade = true;
                }
            }

            if (matchup.status != null && node.status.type.shortDetail.ToLower().StartsWith("final"))
            {
                string oldWinner = matchup.winner;

                matchup.status = node.status.type.shortDetail;

                if (matchup.home_score > matchup.away_score)
                {
                    matchup.winner = matchup.home;
                }
                else if (matchup.away_score > matchup.home_score)
                {
                    matchup.winner = matchup.away;
                }
                else
                {
                    matchup.winner = "TIE";
                }

                if (!string.IsNullOrEmpty(matchup.winner) && oldWinner != matchup.winner)
                {
                    _changesMade = true;
                }
            }
        }