Beispiel #1
0
        // Method that reads in all  data and displays all
        public static List <SuperBowlGames> readInAllData(string write)
        {
            List <SuperBowlGames> SuperBowlGame = new List <SuperBowlGames>();
            SuperBowlGames        aGame;
            string     path      = write;
            const char DELIMITER = ',';

            string[]     arrayOfData;
            const string FILEPATH = @"C:\Users\rolmicw\Documents\Visual Studio 2017\Projects\Project2\Super_Bowl_Project.csv";

            try
            {
                FileStream   file = new FileStream(FILEPATH, FileMode.Open, FileAccess.Read);
                StreamReader read = new StreamReader(file);
                StreamWriter sw   = new StreamWriter(path);
                sw.WriteLine("*****ALL SUPER BOWL DATA*****");
                while (!read.EndOfStream)
                {
                    arrayOfData = read.ReadLine().Split(DELIMITER);
                    aGame       = new SuperBowlGames(arrayOfData[0], arrayOfData[1], Convert.ToInt32(arrayOfData[2]), arrayOfData[3], arrayOfData[4], arrayOfData[5], Convert.ToInt32(arrayOfData[6]), arrayOfData[7], arrayOfData[8], arrayOfData[9], Convert.ToInt32(arrayOfData[10]), arrayOfData[11], arrayOfData[12], arrayOfData[13], arrayOfData[14]);

                    aGame.Date       = arrayOfData[0];
                    aGame.SB         = arrayOfData[1];
                    aGame.Attendance = Convert.ToInt32(arrayOfData[2]);
                    aGame.QBWin      = arrayOfData[3];
                    aGame.CoachWin   = arrayOfData[4];
                    aGame.WinTeam    = arrayOfData[5];
                    aGame.WinPoints  = Convert.ToInt32(arrayOfData[6]);
                    aGame.QBLose     = arrayOfData[7];
                    aGame.CoachLose  = arrayOfData[8];
                    aGame.LoseTeam   = arrayOfData[9];
                    aGame.LosePoints = Convert.ToInt32(arrayOfData[10]);
                    aGame.MVP        = arrayOfData[11];
                    aGame.Stadium    = arrayOfData[12];
                    aGame.City       = arrayOfData[13];
                    aGame.State      = arrayOfData[14];


                    Console.WriteLine(aGame);
                    sw.WriteLine("");
                    sw.WriteLine(aGame);
                    sw.WriteLine("______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________");
                }
                sw.Close();
                read.Close();
                file.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            Console.ReadKey();
            return(SuperBowlGame);
        }
Beispiel #2
0
        // Method for players with most MVPs
        public static void getBestMVPs(List <SuperBowlGames> aGame, string write)
        {
            List <SuperBowlGames> SuperBowlGame = new List <SuperBowlGames>();
            SuperBowlGames        aMvp;
            List <string>         mvp    = new List <string>();
            List <string>         winner = new List <string>();
            List <string>         loser  = new List <string>();
            List <string>         date   = new List <string>();
            string     path      = write;
            int        x         = 0;
            const char DELIMITER = ',';

            string[]     arrayOfData;
            const string FILEPATH = @"C:\Users\rolmicw\Documents\Visual Studio 2017\Projects\Project2\Super_Bowl_Project.csv";

            try
            {
                FileStream   file = new FileStream(FILEPATH, FileMode.Open, FileAccess.Read);
                StreamReader read = new StreamReader(file);

                while (!read.EndOfStream)
                {
                    arrayOfData = read.ReadLine().Split(DELIMITER);
                    aMvp        = new SuperBowlGames(arrayOfData[0], arrayOfData[1], Convert.ToInt32(arrayOfData[2]), arrayOfData[3], arrayOfData[4], arrayOfData[5], Convert.ToInt32(arrayOfData[6]), arrayOfData[7], arrayOfData[8], arrayOfData[9], Convert.ToInt32(arrayOfData[10]), arrayOfData[11], arrayOfData[12], arrayOfData[13], arrayOfData[14]);

                    mvp.Add(arrayOfData[11]);
                    winner.Add(arrayOfData[5]);
                    loser.Add(arrayOfData[9]);
                    date.Add(arrayOfData[0]);
                }
                read.Close();
                file.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }

            var q = mvp.GroupBy(i => i).Select(g => new { Value = g.Key, Count = g.Count() }).OrderByDescending(i => i.Count);

            foreach (var i in q)
            {
                if (i.Count > 2)
                {
                    Console.WriteLine("Value: " + i.Value + " Count: " + i.Count);
                }
            }
            try
            {
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("*****MVPS THAT HAVE WON MVP MORE THAN TWICE*****");
                }

                while (x <= 49)
                {
                    if (mvp[x].Contains("Tom Brady") || mvp[x].Contains("Joe Montana"))
                    {
                        Console.WriteLine("MVP: " + mvp[x] + "\n Winning Team: " + winner[x] + "\n Losing Team: " + loser[x] + "\n Date: " + date[x]);
                        using (StreamWriter sw = File.AppendText(path))
                        {
                            sw.WriteLine("");
                            sw.WriteLine("MVP: " + mvp[x] + "\n Winning Team: " + winner[x] + "\n Losing Team: " + loser[x] + "\n Date: " + date[x]);
                            sw.WriteLine("______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________");
                        }
                    }
                    x++;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
            Console.ReadKey();
        }
Beispiel #3
0
        // Method to get coach that lost the most superbowl games
        public static void questions(List <SuperBowlGames> aGame, string write)
        {
            List <SuperBowlGames> SuperBowlGame = new List <SuperBowlGames>();
            SuperBowlGames        aHost;
            List <string>         loserCoach      = new List <string>();
            List <string>         winnerCoach     = new List <string>();
            List <string>         winnerTeam      = new List <string>();
            List <string>         loserTeam       = new List <string>();
            List <int>            greatestPtsDiff = new List <int>();
            List <float>          avgAttendance   = new List <float>();
            List <string>         sb = new List <string>();
            string     path          = write;
            int        x             = 0;
            const char DELIMITER     = ',';

            string[]     arrayOfData;
            const string FILEPATH = @"C:\Users\rolmicw\Documents\Visual Studio 2017\Projects\Project2\Super_Bowl_Project.csv";

            try
            {
                FileStream   file = new FileStream(FILEPATH, FileMode.Open, FileAccess.Read);
                StreamReader read = new StreamReader(file);

                while (!read.EndOfStream)
                {
                    arrayOfData = read.ReadLine().Split(DELIMITER);
                    aHost       = new SuperBowlGames(arrayOfData[0], arrayOfData[1], Convert.ToInt32(arrayOfData[2]), arrayOfData[3], arrayOfData[4], arrayOfData[5], Convert.ToInt32(arrayOfData[6]), arrayOfData[7], arrayOfData[8], arrayOfData[9], Convert.ToInt32(arrayOfData[10]), arrayOfData[11], arrayOfData[12], arrayOfData[13], arrayOfData[14]);

                    sb.Add(arrayOfData[1]);
                    avgAttendance.Add(Convert.ToInt32(arrayOfData[2]));
                    winnerCoach.Add(arrayOfData[4]);
                    winnerTeam.Add(arrayOfData[5]);
                    loserCoach.Add(arrayOfData[8]);
                    loserTeam.Add(arrayOfData[9]);
                    greatestPtsDiff.Add(Convert.ToInt32(arrayOfData[6]) - Convert.ToInt32(arrayOfData[10]));
                }
                read.Close();
                file.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }


            try
            {
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("*****QUESTIONS*****");
                }


                var q = loserCoach.GroupBy(i => i).Select(g => new { Value = g.Key, Count = g.Count() }).OrderByDescending(i => i.Count);

                Console.WriteLine();
                Console.WriteLine("Which coach lost the most super bowls?");
                Console.WriteLine("=======================================");
                Console.WriteLine("{0}", q.First());
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("Which coach lost the most super bowls?");
                    sw.WriteLine("=======================================");
                    sw.WriteLine("{0}", q.First());
                }

                var q2 = winnerCoach.GroupBy(i => i).Select(g => new { Value = g.Key, Count = g.Count() }).OrderByDescending(i => i.Count);

                Console.WriteLine();
                Console.WriteLine("Which coach won the most super bowls?");
                Console.WriteLine("=======================================");
                Console.WriteLine("{0}", q2.First());
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("Which coach won the most super bowls?");
                    sw.WriteLine("=======================================");
                    sw.WriteLine("{0}", q2.First());
                }

                var q3 = winnerTeam.GroupBy(i => i).Select(g => new { Value = g.Key, Count = g.Count() }).OrderByDescending(i => i.Count);

                Console.WriteLine();
                Console.WriteLine("Which team(s) won the most super bowls?");
                Console.WriteLine("=======================================");
                Console.WriteLine("{0}", q3.First());
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("Which team(s) won the most super bowls?");
                    sw.WriteLine("=======================================");
                    sw.WriteLine("{0}", q3.First());
                }

                var q4 = loserTeam.GroupBy(i => i).Select(g => new { Value = g.Key, Count = g.Count() }).OrderByDescending(i => i.Count);

                Console.WriteLine();
                Console.WriteLine("Which team(s) lost the most super bowls?");
                Console.WriteLine("========================================");
                Console.WriteLine("{0}", q4.First());
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("Which team(s) lost the most super bowls?");
                    sw.WriteLine("========================================");
                    sw.WriteLine("{0}", q4.First());
                }

                var q5 = greatestPtsDiff.GroupBy(i => i).Select(g => new { Value = g.Key, Count = g.Max() }).OrderByDescending(i => i.Count);

                Console.WriteLine();
                Console.WriteLine("Which Super bowl had the greatest point difference?");
                Console.WriteLine("===================================================");
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("Which Super bowl had the greatest point difference?");
                    sw.WriteLine("===================================================");
                }

                while (x < 49)
                {
                    if (greatestPtsDiff[x] == 45)
                    {
                        Console.WriteLine("Super Bowl: {1} Point Difference: {0}", q5.First(), sb[x]);
                        using (StreamWriter sw = File.AppendText(path))
                        {
                            sw.WriteLine();
                            sw.WriteLine("Super Bowl: {1} Point Difference: {0}", q5.First(), sb[x]);
                        }
                    }
                    x++;
                }

                Console.WriteLine();
                Console.WriteLine("What is the average attendance of all super bowls?");
                Console.WriteLine("==================================================");
                Console.WriteLine("{0}", avgAttendance.Average());
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("What is the average attendance of all super bowls?");
                    sw.WriteLine("==================================================");
                    sw.WriteLine("{0}", avgAttendance.Average());
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }

            Console.ReadKey();
        }
Beispiel #4
0
        // Method to get states that host the most superbowls
        public static void getMostHosts(List <SuperBowlGames> aGame, string write)
        {
            List <SuperBowlGames> SuperBowlGame = new List <SuperBowlGames>();
            SuperBowlGames        aHost;
            List <string>         state   = new List <string>();
            List <string>         city    = new List <string>();
            List <string>         stadium = new List <string>();
            List <string>         date    = new List <string>();
            string     path      = write;
            int        x         = 0;
            const char DELIMITER = ',';

            string[]     arrayOfData;
            const string FILEPATH = @"C:\Users\rolmicw\Documents\Visual Studio 2017\Projects\Project2\Super_Bowl_Project.csv";

            try
            {
                FileStream   file = new FileStream(FILEPATH, FileMode.Open, FileAccess.Read);
                StreamReader read = new StreamReader(file);

                while (!read.EndOfStream)
                {
                    arrayOfData = read.ReadLine().Split(DELIMITER);
                    aHost       = new SuperBowlGames(arrayOfData[0], arrayOfData[1], Convert.ToInt32(arrayOfData[2]), arrayOfData[3], arrayOfData[4], arrayOfData[5], Convert.ToInt32(arrayOfData[6]), arrayOfData[7], arrayOfData[8], arrayOfData[9], Convert.ToInt32(arrayOfData[10]), arrayOfData[11], arrayOfData[12], arrayOfData[13], arrayOfData[14]);

                    state.Add(arrayOfData[14]);
                    city.Add(arrayOfData[13]);
                    stadium.Add(arrayOfData[12]);
                    date.Add(arrayOfData[0]);
                }
                read.Close();
                file.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }

            var q = state.GroupBy(i => i).Select(g => new { Value = g.Key, Count = g.Count() }).OrderByDescending(i => i.Count);

            foreach (var i in q)
            {
                Console.WriteLine("Value: " + i.Value + " Count: " + i.Count);
            }
            Console.WriteLine();
            Console.WriteLine("List of the cities in most hosted state");
            Console.WriteLine("=======================================");
            try
            {
                using (StreamWriter sw = File.AppendText(path))
                {
                    sw.WriteLine();
                    sw.WriteLine("*****STATE THAT HAS HOSTED THE MOST SUPER BOWLS*****");
                }
                while (x < 49)
                {
                    if (state[x].Contains("Florida"))
                    {
                        Console.WriteLine("\nCity: " + city[x] + "\n State: " + state[x] + "\n Stadium: " + stadium[x] + "\n Date: " + date[x]);

                        using (StreamWriter sw = File.AppendText(path))
                        {
                            sw.WriteLine("");
                            sw.WriteLine("\nCity: " + city[x] + "\n State: " + state[x] + "\n Stadium: " + stadium[x] + "\n Date: " + date[x]);
                            sw.WriteLine("______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________");
                        }
                    }
                    x++;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }

            Console.ReadKey();
        }