Exemplo n.º 1
0
        public void ShowFixtures(DateTime pDate, List <Team> pListOfTeamsToDisplay, int pIndex, bool pager)
        {
            Pages pages = new Pages();

            pnlFixture.Controls.Clear();
            List <TextBox> txthomeTeam = new List <TextBox>();
            List <TextBox> txtAwayTeam = new List <TextBox>();
            List <Label>   lblVerses   = new List <Label>();

            GamePlay        game        = new GamePlay();
            Match           match       = new Match();
            List <GamePlay> listOfGames = game.GetFixture(pDate);
            List <GamePlay> gamesBroughtForward;

            //Only enters AddToList if the list of teams to display are not null
            if (pager || pListOfTeamsToDisplay == null)
            {
                gamesBroughtForward = pages.AddToList(listOfGames, pIndex, pnlPages).ToList();
            }
            else
            {
                gamesBroughtForward = listOfGames;
            }

            //gamesBroughtForward.RemoveAll(r => (r.Equals(null)));
            this.ReleaseFixtureOrResults(gamesBroughtForward, match, pListOfTeamsToDisplay);
        }
Exemplo n.º 2
0
        //public List<Team> GetHomeWinner(int pGamesToWin)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            int totalHomeGamesPlayed = 0;
        //            int countHomeWins = 0;
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToWin;
        //            int countWins = 0;
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            List<vwHomeGame> evResults = DbData.vwHomeGames
        //                .Where(x => (x.homeTeam.Equals(teamName) && x.competition.Equals(competition) && x.country.Equals(country)))
        //                .Select(x => (x)).ToList();

        //            //Count the number home games won
        //            countHomeWins = evResults.FindAll(x => (x.matchState.Equals("WON"))).Count;

        //            if (countHomeWins >= totalGamesToWin && selectedTeam.played > TOTALNUMBER)
        //            {
        //                homeWinner.Add(selectedTeam);
        //            }
        //        }
        //    }

        //    return homeWinner;
        //}

        //public List<Team> GetAwayWinner(int pGamesToWin)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            int totalHomeGamesPlayed = 0;
        //            int countHomeWins = 0;
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToWin;
        //            int countWins = 0;
        //            string gameState = "WIN";
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            ToSearchAwayGames(DbData, selectedTeam, countHomeWins, teamName, competition,
        //                country, totalGamesToWin, TOTALNUMBER, gameState);
        //        }
        //    }

        //    return awayWinner;
        //}

        //private int ToSearchAwayGames(SampleDataDataContext DbData, Team selectedTeam, int countHomeWins, string teamName,
        //    string competition, string country, int totalGamesToWin, int TOTALNUMBER, string pGameState)
        //{
        //    List<vwAwayGame> evResults = DbData.vwAwayGames
        //        .Where(x => (x.awayTeam.Equals(teamName) && x.competition.Equals(competition) && x.country.Equals(country)))
        //        .Select(x => (x)).ToList();

        //    //Count the number home games won
        //    countHomeWins = evResults.FindAll(x => (x.matchState.Equals(pGameState))).Count;

        //    if (countHomeWins >= totalGamesToWin && selectedTeam.played > TOTALNUMBER)
        //    {
        //        awayWinner.Add(selectedTeam);
        //    }
        //    return countHomeWins;
        //}

        //public List<Team> GetOnFormWinner(int pGamesToWin)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToWin;
        //            int countWins = 0;
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            List<COMPETITION_STAT> compStat = DbData.spTeamsForm(teamName, competition, country).ToList();

        //            //Count the number home games won
        //            countWins = compStat.FindAll(x => (x.matchState.Equals("WON"))).Count;

        //            if (countWins >= totalGamesToWin && selectedTeam.played >= TOTALNUMBER)
        //            {
        //                onFormWinner.Add(selectedTeam);
        //            }
        //        }
        //    }

        //    return onFormWinner;
        //}

        //public List<Team> GetOnFormLoser(int pGamesToLose)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToLose = pGamesToLose;
        //            int countWins = 0;
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            List<COMPETITION_STAT> compStat = DbData.spTeamsForm(teamName, competition, country).ToList();

        //            //Count the number home games won
        //            countWins = compStat.FindAll(x => (x.matchState.Equals("LOST"))).Count;

        //            if (countWins >= totalGamesToLose && selectedTeam.played >= TOTALNUMBER)
        //            {
        //                onFormLoser.Add(selectedTeam);
        //            }
        //        }
        //    }

        //    return onFormLoser;
        //}

        //public List<Team> GetHomeLoser(int pHomeGamesToLose)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            int totalHomeGamesPlayed = 0;
        //            int countHomeWins = 0;
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToLose = pHomeGamesToLose;
        //            int countWins = 0;
        //            //The state of the matches to search for
        //            string gameState = "LOST";
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            ToSearchAwayGames(DbData, selectedTeam, countHomeWins, teamName, competition,
        //                country, totalGamesToLose, TOTALNUMBER, gameState);
        //        }
        //    }

        //    return homeLoser;
        //}

        //public List<Team> GetAwayLoser(int pGamesToLose)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            int totalHomeGamesPlayed = 0;
        //            int countHomeWins = 0;
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToLose;
        //            int countWins = 0;
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            List<vwAwayGame> evResults = DbData.vwAwayGames
        //                .Where(x => (x.awayTeam.Equals(teamName) && x.competition.Equals(competition) && x.country.Equals(country)))
        //                .Select(x => (x)).ToList();

        //            //Count the number home games won
        //            countHomeWins = evResults.FindAll(x => (x.matchState.Equals("LOST"))).Count;

        //            if (countHomeWins >= totalGamesToWin && selectedTeam.played > TOTALNUMBER)
        //            {
        //                //MessageBox.Show("Total Home Games: " + totalHomeGamesPlayed + "\nTotal Home Wins: " + countHomeWins + "\n" + selectedTeam.nameOfTeam);
        //                awayLoser.Add(selectedTeam);
        //            }
        //        }
        //    }

        //    return awayLoser;
        //}

        //public List<Team> GetRegularDrawer(int pGamesToDrawCount)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToDrawCount;
        //            int countWins = 0;
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            List<COMPETITION_STAT> compStat = DbData.spTeamsForm(teamName, competition, country).ToList();

        //            //Count the number home games won
        //            countWins = compStat.FindAll(x => (x.matchState.Equals("DRAW"))).Count;

        //            if (countWins >= totalGamesToWin && selectedTeam.played >= TOTALNUMBER)
        //            {
        //                regularDrawer.Add(selectedTeam);
        //            }
        //        }
        //    }

        //    return regularDrawer;
        //}

        //public List<Team> GetRegularHomeDrawer(int pGamesToDrawCount)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            int totalHomeGamesPlayed = 0;
        //            int countHomeWins = 0;
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToDrawCount;
        //            int countWins = 0;
        //            //The state of the matches to search for
        //            string gameState = "DRAW";
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;

        //            ToSearchHomeGames(DbData, selectedTeam, countHomeWins, teamName, competition,
        //                country, totalGamesToWin, TOTALNUMBER, gameState);
        //        }
        //    }

        //    return regularHomeDrawer;
        //}

        //public List<Team> GetAwayDrawer(int pGamesToDraw)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            int totalHomeGamesPlayed = 0;
        //            int countHomeWins = 0;
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToDraw;
        //            int countWins = 0;
        //            string gameState = "DRAW";
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            ToSearchAwayGames(DbData, selectedTeam, countHomeWins, teamName, competition,
        //                country, totalGamesToWin, TOTALNUMBER, gameState);
        //        }
        //    }

        //    return regularAwayDrawer;
        //}

        //public List<Team> GetRegularCleanSheets(int pGamesToCount)
        //{
        //    using (IDbConnection conn = dor.Connection())
        //    {
        //        IEnumerable<Team> team = DbData.TEAMs.Select(x => (x));
        //        //Go Through all the teams in the TEAMs table
        //        foreach (Team selectedTeam in team)
        //        {
        //            int totalHomeGamesPlayed = 0;
        //            int countCleanSheets = 0;
        //            string teamName = selectedTeam.nameOfTeam;
        //            string competition = selectedTeam.currentCompetition;
        //            string country = selectedTeam.country;
        //            int totalGamesToWin = pGamesToCount;
        //            int countWins = 0;
        //            //Team must atleast have played 5 games
        //            const int TOTALNUMBER = 5;
        //            //Retrieve all the results from the stored procedure
        //            List<Results> evResults = DbData.RESULTs
        //                .Where(x => (Convert.ToInt64(x.homeTeamScore) == 0 || Convert.ToInt64(x.awayTeamScore) == 0))
        //                .Select(x => (x)).ToList();

        //            List<Results> homeRecord = evResults
        //                .Where(x => (x.homeTeam.Equals(teamName) && Convert.ToInt64(x.homeTeamScore) == 0))
        //                .Select(h => (h))
        //                .OrderByDescending(o => (o.dateOfmatch)).ToList();


        //            List<Results> awayRecord = evResults
        //                .Where(x => (x.awayTeam.Equals(teamName) && Convert.ToInt64(x.awayTeamScore) == 0))
        //                .Select(h => (h)).ToList();

        //            //Count the number home games won
        //            countCleanSheets = homeRecord.Count + awayRecord.Count;
        //            string test = "";
        //            if (countCleanSheets >= totalGamesToWin && selectedTeam.played > TOTALNUMBER)
        //            {
        //                regularCleanSheeter.Add(selectedTeam);
        //            }
        //        }
        //    }

        //    return regularCleanSheeter;
        //}

        public List <Team> GetSeasonPerformer(int pAveWinLose)
        {
            using (IDbConnection conn = dor.Connection())
            {
                DateTime        date     = FixtureControl.selectedDate;
                GamePlay        game     = new GamePlay();
                List <GamePlay> gameList = game.GetFixture(date).FindAll(g => (g.HomeWins >= pAveWinLose || g.AwayWins >= pAveWinLose ||
                                                                               g.HomeLosses >= pAveWinLose || g.AwayLosses >= pAveWinLose || g.HomeDraws >= pAveWinLose || g.AwayDraws >= pAveWinLose));

                foreach (GamePlay gameItem in gameList)
                {
                    Team homeTeam = conn.Query <Team>(@"SELECT * FROM [dbo].[TEAM] WHERE [nameOfTeam]=@nameOfTeam AND 
                                                    [country]=@country AND [currentCompetition]=@currentCompetition",
                                                      new
                    {
                        nameOfTeam         = gameItem.HomeTeam,
                        country            = gameItem.Country,
                        currentCompetition = gameItem.Competition
                    }).FirstOrDefault();
                    Team awayTeam = conn.Query <Team>(@"SELECT * FROM [dbo].[TEAM] WHERE [nameOfTeam]=@nameOfTeam AND 
                                                    [country]=@country AND [currentCompetition]=@currentCompetition",
                                                      new
                    {
                        nameOfTeam         = gameItem.AwayTeam,
                        country            = gameItem.Country,
                        currentCompetition = gameItem.Competition
                    }).FirstOrDefault();
                    //Team homeTeam = DbData.TEAMs.SingleOrDefault(t => (t.nameOfTeam.Equals(gameItem.HomeTeam) &&
                    //    t.country.Equals(gameItem.Country) && t.currentCompetition.Equals(gameItem.Competition)));
                    //Team awayTeam = DbData.TEAMs.SingleOrDefault(t => (t.nameOfTeam.Equals(gameItem.AwayTeam) &&
                    //    t.country.Equals(gameItem.Country) && t.currentCompetition.Equals(gameItem.Competition)));

                    seasonPerformer.Add(homeTeam);
                    seasonPerformer.Add(awayTeam);
                }
            }

            return(seasonPerformer);
        }