Esempio n. 1
0
        private async Task ImportMatch(Competition competition, Guid?team1Key, Guid?team2Key, string matchId, DateTime matchDate)
        {
            // http://www.soccerbase.com/matches/additional_information.sd?id_game=689457
            var uri      = new Uri(string.Format("http://www.soccerbase.com/matches/additional_information.sd?id_game={0}", matchId));
            var document = GetHtmlDocument(uri);

            //win - on aggregate
            var matchStatus = document.DocumentNode.Descendants("p").First(p => p.Attributes["class"].Value == "status").InnerText;
            var isCompleted = matchStatus == "result" || matchStatus.Contains("on aggregate") || matchStatus.Contains("on penalties") || matchStatus.Contains("AFTER EXTRA TIME") || matchStatus.Contains("win on away goals");

            if (!isCompleted)
            {
                return;
            }

            //Scores
            var span    = document.DocumentNode.Descendants("span").FirstOrDefault(s => s.Attributes.Contains("title") && s.Attributes["title"].Value.Contains("Half-time"));
            var team1Ht = span != null?span.Descendants("em").ElementAt(0).InnerText.ToNullableShort() : null;

            var team2Ht = span != null?span.Descendants("em").ElementAt(1).InnerText.ToNullableShort() : null;

            span = document.DocumentNode.Descendants("span").FirstOrDefault(s => s.Attributes.Contains("title") && s.Attributes["title"].Value.Contains("Full-time"));
            var team1Ft = span != null?span.Descendants("em").ElementAt(0).InnerText.ToNullableShort() : null;

            var team2Ft = span != null?span.Descendants("em").ElementAt(1).InnerText.ToNullableShort() : null;

            //Attendance
            var attendance = GetAttendance(matchId);

            //Does match exist in Soccerbase lookup?
            var matchKey = await LookupMatch(matchId);

            Match  match  = null;
            MatchV matchV = null;

            //Does campaign exist?
            var campaign = await ProcessCampaign(competition.PrimaryKey, matchDate);

            if (campaign == null)
            {
                return;
            }

            var venueGuid = await GetVenueGuid((Guid)team1Key, matchDate);

            if (matchKey == null)
            {
                var endOfMatchDay       = matchDate.ToEndOfDay();
                var beginningOfMatchDay = matchDate.Date;

                //Does match exist in Match tables
                //var matchQuery = from m in provider.MatchVs
                //                 where m.CampaignGuid == campaign.PrimaryKey
                //                 && m.Team1Guid == team1Key
                //                 && m.Team2Guid == team2Key
                //                 && m.IsActive
                //                 && !m.IsMarkedForDeletion
                //                 && m.MatchDate >= beginningOfMatchDay
                //                 && m.MatchDate <= endOfMatchDay
                //                 select m;

                var searchMatchV = await Provider.GetMatchByCampaignAndTeams(campaign.PrimaryKey, (Guid)team1Key, (Guid)team2Key, matchDate);

                if (searchMatchV != null)
                {
                    match    = searchMatchV.Match;
                    matchKey = match.PrimaryKey;
                    matchV   = match.GetApprovedVersion <MatchV>(matchDate);
                }
                else
                {
                    match                = Match.Create <Match>();
                    matchV               = MatchV.CreateNew <MatchV>(User.GetUserId());
                    matchV.HeaderKey     = match.PrimaryKey;
                    matchV.EffectiveFrom = Date.LowDate;
                    matchV.EffectiveTo   = Date.HighDate;

                    CreateLookupMatch(match.PrimaryKey, matchId);
                }
            }
            else
            {
                match  = (await Provider.GetMatch((Guid)matchKey, matchDate)).Match;
                matchV = match.GetApprovedVersion <MatchV>(matchDate);
            }

            if (matchV.MatchImportType == MatchImportType.AutomaticResultWithEvents || matchV.MatchImportType == MatchImportType.ManualResult)
            {
                return;
            }

            matchV.MatchDate       = matchDate.Date;
            matchV.MatchTimeTicks  = matchV.MatchTimeTicks > 0 ? matchV.MatchTimeTicks : (matchDate - matchDate.Date).Ticks;
            matchV.MatchImportType = MatchImportType.AutomaticResultWithEvents;
            matchV.VenueGuid       = venueGuid;
            matchV.Attendance      = attendance;

            if (competition.GetApprovedVersion <CompetitionV>(matchDate).CompetitionType == CompetitionType.League)
            {
                var campaignStage = campaign.CampaignStages.FirstOrDefault(f => f.IsDefault);

                if (campaignStage != null)
                {
                    matchV.CampaignStageKey = campaignStage.PrimaryKey;
                }
            }

            matchV.Team1Guid = (Guid)team1Key;
            matchV.Team1HT   = team1Ht;
            matchV.Team1FT   = team1Ft;
            matchV.Team2Guid = (Guid)team2Key;
            matchV.Team2HT   = team2Ht;
            matchV.Team2FT   = team2Ft;

            if (matchKey == null)
            {
                Provider.Add(match);
                Provider.Add(matchV);
            }

            Provider.SaveChanges();

            await ProcessMatchPlayers(document, matchV);
        }
Esempio n. 2
0
        protected async Task ProcessMatch(string lookupId, DateTime matchDate, CompetitionV competitionV, Guid?venueGuid, int?attendance, Guid team1Guid, short?team1Ht, short?team1Ft, Guid team2Guid, short?team2Ht, short?team2Ft, Guid campaignStageKey)
        {
            if (campaignStageKey == null)
            {
                return;
            }

            var lookupMatchSearch = await Provider.GetLookupMatch(ImportSite, lookupId);

            var startOfDay = matchDate.Date;
            var endOfDay   = matchDate.ToEndOfDay();

            var matchSearch = await Provider.GetMatchByTeams(team1Guid, team2Guid, matchDate);

            var campaign = await Provider.FindCampaignAsync(competitionV.HeaderKey, matchDate);

            if (campaign == null)
            {
                var startDate = Date.LowDate;
                var endDate   = Date.HighDate;

                if (!competitionV.GetCampaignDates(matchDate, ref startDate, ref endDate))
                {
                    return;
                }

                var newCampaign = Campaign.CreateNew(competitionV.HeaderKey, startDate, endDate);
                campaign = newCampaign;

                Provider.Add(newCampaign);
                Provider.SaveChanges();
            }

            if (lookupMatchSearch != null || matchSearch != null)
            {
                MatchV matchV = null;

                if (lookupMatchSearch != null)
                {
                    var lookupMatch = lookupMatchSearch;
                    matchV = (await Provider.GetMatch(lookupMatch.MatchGuid, DateTime.Now));
                }
                else if (matchSearch != null)
                {
                    matchV = matchSearch;
                }

                if (matchV == null || matchV.MatchImportType == MatchImportType.ManualResult)
                {
                    return;
                }

                matchV.MatchDate        = matchDate.Date;
                matchV.MatchTimeTicks   = (matchDate - matchDate.Date).Ticks;
                matchV.VenueGuid        = venueGuid;
                matchV.Attendance       = attendance;
                matchV.Team1Guid        = team1Guid;
                matchV.Team1HT          = team1Ht;
                matchV.Team1FT          = team1Ft;
                matchV.Team2Guid        = team2Guid;
                matchV.Team2HT          = team2Ht;
                matchV.Team2FT          = team2Ft;
                matchV.MatchImportType  = matchV.GetMatchImportType(true);
                matchV.CampaignStageKey = campaignStageKey;
            }
            else
            {
                if (matchDate < DateTime.Now && team1Ft == null && team2Ft == null)
                {
                    return;
                }

                var matchGuid = Guid.NewGuid();

                Provider.Add(new Match()
                {
                    PrimaryKey = matchGuid
                });

                var matchV = MatchV.CreateNew <MatchV>(User.GetUserId());
                matchV.HeaderKey        = matchGuid;
                matchV.MatchDate        = matchDate.Date;
                matchV.MatchTimeTicks   = (matchDate - matchDate.Date).Ticks;
                matchV.VenueGuid        = venueGuid;
                matchV.Attendance       = attendance;
                matchV.Team1Guid        = team1Guid;
                matchV.Team1HT          = team1Ht;
                matchV.Team1FT          = team1Ft;
                matchV.Team2Guid        = team2Guid;
                matchV.Team2HT          = team2Ht;
                matchV.Team2FT          = team2Ft;
                matchV.EffectiveFrom    = Date.LowDate;
                matchV.EffectiveTo      = Date.HighDate;
                matchV.MatchImportType  = matchV.GetMatchImportType(true);
                matchV.CampaignStageKey = campaignStageKey;

                Provider.Add(matchV);

                if (lookupId != string.Empty)
                {
                    Provider.Add(new LookupMatch()
                    {
                        PrimaryKey = Guid.NewGuid(),
                        ImportSite = ImportSite,
                        MatchGuid  = matchGuid,
                        LookupId   = lookupId
                    });
                }
            }

            Provider.SaveChanges();
        }