// 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); }
// 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(); }
// 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(); }
// 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(); }