Exemple #1
0
        public void AddOrUpdateAverageRoundStats(AverageRoundStats averageRoundStats)
        {
            if (Db.Database.Connection.State == System.Data.ConnectionState.Closed)
            {
                Db.Database.Connection.Open();
            }

            var result = (from n in Db.AverageRoundStats
                          where n.LeagueSeasonId == averageRoundStats.LeagueSeasonId
                          select n).FirstOrDefault();

            if (result == null)
            {
                //add teamForm
                Db.AverageRoundStats.Add(averageRoundStats);
                Db.SaveChanges();

                var repo = new LogRepository();
                repo.WriteLog(Database.SystemData.Severity.Information, "Insert to AverageRoundStats table new record", nameof(AnalysisDataRepository),
                              "localhost", "[LeagueSeasonId = " + averageRoundStats.LeagueSeasonId + "]", "");
            }
            else
            {
                //update teamForm
                result.Copy(averageRoundStats);
                Db.SaveChanges();

                var repo = new LogRepository();
                repo.WriteLog(Database.SystemData.Severity.Information, "Update record in AverageRoundStats table", nameof(AnalysisDataRepository),
                              "localhost", "[LeagueSeasonId = " + result.LeagueSeasonId + "]", "");
            }

            Db.Database.Connection.Close();
        }
Exemple #2
0
        private bool AnalyzeLeagueSeason(LeagueSeason season)
        {
            var haveAllRoundsStats = false;
            var allSeasonRounds    = leagueRepo.GetCurrentSeasonRounds(season.LeagueSeasonId).Where(sr => (sr.HomeWinsCount + sr.DrawsCount + sr.AwayWinsCount) == 10).ToList();

            var averageRoundStats = new AverageRoundStats
            {
                LeagueSeasonId = season.LeagueSeasonId
            };

            var homeTeamWinsCount = allSeasonRounds.Select(o => o.HomeWinsCount).OrderBy(o => o).ToArray();
            var awayTeamWinsCount = allSeasonRounds.Select(o => o.AwayWinsCount).OrderBy(o => o).ToArray();
            var drawsCount        = allSeasonRounds.Select(o => o.DrawsCount).OrderBy(o => o).ToArray();

            var goals     = allSeasonRounds.Select(o => o.Goals).OrderBy(o => o).ToArray();
            var awayGoals = allSeasonRounds.Select(o => o.AwayGoals).OrderBy(o => o).ToArray();
            var homeGoals = allSeasonRounds.Select(o => o.HomeGoals).OrderBy(o => o).ToArray();

            var btts_yes = allSeasonRounds.Select(o => o.BTTS_Yes).OrderBy(o => o).ToArray();
            var btts_no  = allSeasonRounds.Select(o => o.BTTS_No).OrderBy(o => o).ToArray();

            var totalOver2_5  = allSeasonRounds.Select(o => o.GamesOver2_5).OrderBy(o => o).ToArray();
            var totalUnder2_5 = allSeasonRounds.Select(o => o.GamesUnder2_5).OrderBy(o => o).ToArray();

            averageRoundStats.HomeWinsCount_Average = homeTeamWinsCount.Length != 0 ? homeTeamWinsCount.Average() : 0;
            averageRoundStats.HomeWinsCount_Min     = homeTeamWinsCount.Length != 0 ? homeTeamWinsCount.First() : 0;
            averageRoundStats.HomeWinsCount_Max     = homeTeamWinsCount.Length != 0 ? homeTeamWinsCount.Last() : 0;
            averageRoundStats.AwayWinsCount_Average = awayTeamWinsCount.Length != 0 ? awayTeamWinsCount.Average() : 0;
            averageRoundStats.AwayWinsCount_Min     = awayTeamWinsCount.Length != 0 ? awayTeamWinsCount.First() : 0;
            averageRoundStats.AwayWinsCount_Max     = awayTeamWinsCount.Length != 0 ? awayTeamWinsCount.Last() : 0;
            averageRoundStats.DrawsCount_Average    = drawsCount.Length != 0 ? drawsCount.Average() : 0;
            averageRoundStats.DrawsCount_Min        = drawsCount.Length != 0 ? drawsCount.First() : 0;
            averageRoundStats.DrawsCount_Max        = drawsCount.Length != 0 ? drawsCount.Last() : 0;

            averageRoundStats.HomeGoals_Average = homeGoals.Length != 0 ? homeGoals.Average() : 0;
            averageRoundStats.HomeGoals_Min     = homeGoals.Length != 0 ? homeGoals.First() : 0;
            averageRoundStats.HomeGoals_Max     = homeGoals.Length != 0 ? homeGoals.Last() : 0;
            averageRoundStats.AwayGoals_Average = awayGoals.Length != 0 ? awayGoals.Average() : 0;
            averageRoundStats.AwayGoals_Min     = awayGoals.Length != 0 ? awayGoals.First() : 0;
            averageRoundStats.AwayGoals_Max     = awayGoals.Length != 0 ? awayGoals.Last() : 0;
            averageRoundStats.Goals_Average     = goals.Length != 0 ? goals.Average() : 0;
            averageRoundStats.Goals_Min         = goals.Length != 0 ? goals.First() : 0;
            averageRoundStats.Goals_Max         = goals.Length != 0 ? goals.Last() : 0;

            averageRoundStats.BTTS_Yes_Average = btts_yes.Length != 0 ? btts_yes.Average() : 0;
            averageRoundStats.BTTS_Yes_Min     = btts_yes.Length != 0 ? btts_yes.First() : 0;
            averageRoundStats.BTTS_Yes_Max     = btts_yes.Length != 0 ? btts_yes.Last() : 0;
            averageRoundStats.BTTS_No_Average  = btts_no.Length != 0 ? btts_no.Average() : 0;
            averageRoundStats.BTTS_No_Min      = btts_no.Length != 0 ? btts_no.First() : 0;
            averageRoundStats.BTTS_No_Max      = btts_no.Length != 0 ? btts_no.Last() : 0;

            averageRoundStats.GamesOver2_5_Average  = totalOver2_5.Length != 0 ? totalOver2_5.Average() : 0;
            averageRoundStats.GamesOver2_5_Min      = totalOver2_5.Length != 0 ? totalOver2_5.First() : 0;
            averageRoundStats.GamesOver2_5_Max      = totalOver2_5.Length != 0 ? totalOver2_5.Last() : 0;
            averageRoundStats.GamesUnder2_5_Average = totalUnder2_5.Length != 0 ? totalUnder2_5.Average() : 0;
            averageRoundStats.GamesUnder2_5_Min     = totalUnder2_5.Length != 0 ? totalUnder2_5.First() : 0;
            averageRoundStats.GamesUnder2_5_Max     = totalUnder2_5.Length != 0 ? totalUnder2_5.Last() : 0;

            averageRoundStats.LastUpdate = DateTime.Now;

            //validate stats
            {
                //all main results
                var games = averageRoundStats.HomeWinsCount_Average +
                            averageRoundStats.AwayWinsCount_Average +
                            averageRoundStats.DrawsCount_Average;
                games /= 10;
                if (games < 0.95 || games > 1.01)
                {
                    return(ReturnFalse($"[Season = {season.LeagueSeasonId}]All games percentage not 100% [{games * 100}%]"));
                }

                var btts = averageRoundStats.BTTS_Yes_Average +
                           averageRoundStats.BTTS_No_Average;
                btts /= 10;
                if (btts < 0.95 || btts > 1.01)
                {
                    return(ReturnFalse($"[Season = {season.LeagueSeasonId}]All BTTS games percentage not 100% [{games * 100}%]"));
                }

                var total = averageRoundStats.GamesOver2_5_Average +
                            averageRoundStats.GamesUnder2_5_Average;
                total /= 10;
                if (total < 0.95 || total > 1.01)
                {
                    return(ReturnFalse($"[Season = {season.LeagueSeasonId}]All TOTAL games percentage not 100% [{games * 100}%]"));
                }
            }

            analysisRepo.AddOrUpdateAverageRoundStats(averageRoundStats);

            var gamePlayed = allSeasonRounds.Sum(r => r.GamePlayed);

            haveAllRoundsStats = gamePlayed >= 380;

            return(haveAllRoundsStats);
        }