using System; using System.Collections.Generic; using System.Linq; using System.Text; using ImportFootballResults; namespace Analyze { class Program { static void Main(string[] args) { Program p = new Program(); } public Program() { int[] seasons = new int[] { 2006, 2007, 2008, 2009, 2010}; // LINQ to SQL context (db conn) ResultsDBDataContext db = new ResultsDBDataContext(); // write out a header Console.WriteLine("Season, League, matches, qualified, qualified% ,0-0@HT, SR%"); // get all the leagues var leagues = from l in db.Leagues orderby l.ShortName, l.Div select l; // loop the leagues foreach (var l in leagues) { // Loop seasons for (int i = 0; i < seasons.Length; i++) { // get all games for a season+league var games = from g in db.Results where g.Div == l.ShortName && g.Season == seasons[i] select g; // games that qualifies var o25qualifiers = from ou in games where ou.BbAv_o25 < 2 select ou; // games that are 0-0 at HalfTime var scoreless = from s in o25qualifiers where s.HTHG == 0 && s.HTAG == 0 select s; // qualifier rate float qrate = ((o25qualifiers.Count() / (float)games.Count()) * 100); string qpercentage = String.Format("{0:0}", qrate); // hit rate float strikerate = 100-((scoreless.Count() / (float)o25qualifiers.Count())*100); string srpercentage = String.Format("{0:0}", strikerate); // write out the results Console.WriteLine("{0}, {1}, {2}, {3}, {4}%, {5}, {6}%", seasons[i], l.Name, games.Count(), o25qualifiers.Count(), qpercentage,scoreless.Count(), srpercentage ); } } Console.WriteLine(Environment.NewLine + "Done"); } } }