/// <summary> /// Renders the object as a simple HTML report. /// </summary> public void Render() { MetricsBase = new MetricsBase(new PreStyleBreakdown(), Season) { DoBreakdowns = true }; MetricsBase.Load(Season, skipPostseason:true); TeamList = MetricsBase.TeamList; var str = new SimpleTableReport( string.Format( "Balance Report {0}", Season ) ); str.AddStyle( "#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 641px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }" ); str.AddStyle( "#main { margin-left:1em; }" ); str.AddStyle( "#dtStamp { font-size:0.8em; }" ); str.AddStyle( ".end { clear: both; }" ); str.AddStyle( ".gponame { color:white; background:black }" ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn( new ReportColumn( "Team", "TEAM", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "Rating", "RATING", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "Plays", "PLAYS", "{0}", typeof( Int32 ), true ) ); str.AddColumn( new ReportColumn( "Passes", "PASSES", "{0}", typeof( Int32 ), true ) ); str.AddColumn( new ReportColumn( "Runs", "RUNS", "{0}", typeof( Int32 ), true ) ); str.AddColumn( new ReportColumn( "Pass%", "PPERCENT", "{0:0.00}", typeof( decimal ), false ) ); str.AddColumn( new ReportColumn( "Run%", "RPERCENT", "{0:0.00}", typeof( decimal ), false ) ); str.AddColumn( new ReportColumn( "Tdp", "TDPASSES", "{0}", typeof( string ) ) ); str.AddColumn( new ReportColumn( "Tdr", "TDRUNS", "{0}", typeof( String ) ) ); BuildTable( str ); str.SetSortOrder( "PASSES DESC"); str.RenderAsHtml( OutputFilename(), true ); }
public void Render() { // might have to load some stuff first ??? var str = new SimpleTableReport( "Game Summary " + Game.ScoreOut() ); str.AddDenisStyle(); str.SubHeader = SubHeading(); str.AnnounceIt = true; str.AddColumn( new ReportColumn( "C1", "COL01", "{0}" ) ); str.AddColumn( new ReportColumn( "C2", "COL02", "{0}" ) ); str.AddColumn( new ReportColumn( "C3", "COL03", "{0}" ) ); str.AddColumn( new ReportColumn( "C4", "COL04", "{0}" ) ); str.AddColumn( new ReportColumn( "C5", "COL05", "{0}" ) ); str.AddColumn( new ReportColumn( "C6", "COL06", "{0}" ) ); str.AddColumn( new ReportColumn( "C7", "COL07", "{0}" ) ); str.AddColumn( new ReportColumn( "C8", "COL08", "{0}" ) ); str.AddColumn( new ReportColumn( "C9", "COL09", "{0}" ) ); str.AddColumn( new ReportColumn( "C10", "COL10", "{0}" ) ); str.AddColumn( new ReportColumn( "C11", "COL11", "{0}" ) ); str.CustomHeader = SummaryHeader(); str.LoadBody( BuildTable() ); str.RenderAsHtml( FileName(), persist: true ); }
public void Render() { SimpleTableReport str = new SimpleTableReport( "Volume Report " + m_Season ); str.AddStyle("#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 641px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }"); str.AddStyle("#main { margin-left:1em; }"); str.AddStyle("#dtStamp { font-size:0.8em; }"); str.AddStyle(".end { clear: both; }"); str.AddStyle(".gponame { color:white; background:black }"); str.AddStyle("label { display:block; float:left; width:130px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:right; }"); str.AddStyle("value { display:block; float:left; width:100px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:left; font-weight: bold; color:blue }"); str.AddStyle("#notes { float:right; height:auto; width:308px; font-size: 88%; background-color: #ffffe1; border: 1px solid #666666; padding: 5px; margin: 0px 0px 10px 10px; color:#666666 }"); str.AddStyle("div.notes H4 { background-image: url(images/icon_info.gif); background-repeat: no-repeat; background-position: top left; padding: 3px 0px 3px 27px; border-width: 0px 0px 1px 0px; border-style: solid; border-color: #666666; color: #666666; font-size: 110%;}"); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn(new ReportColumn("Wk", "WEEK", "{0}", typeof(String) )); str.AddColumn(new ReportColumn("G", "GAMES", "{0}", typeof(Int32), true )); str.AddColumn(new ReportColumn("Spr", "SPREAD", "{0}", typeof(Int32), true )); str.AddColumn(new ReportColumn("MyT", "MYTIPS", "{0}", typeof(Int32), true )); str.AddColumn(new ReportColumn("ATS", "ATS", "{0}", typeof(Int32), true)); str.AddColumn(new ReportColumn("H", "HOME", "{0}", typeof(Int32), true)); BuildTable(str); str.RenderAsHtml(string.Format("{0}//tipping{1}.htm", Utility.OutputDirectory(), m_Season), true); }
private void BuildTable( SimpleTableReport str ) { var totTDp = 0; var totTDr = 0; if (TeamList == null) return; foreach ( NflTeam t in TeamList ) { if (t == null) continue; var dr = str.Body.NewRow(); t.TallyPlays( Season, skipPostseason: true ); dr[ "TEAM" ] = t.NameOut(); dr[ "RATING" ] = t.Ratings; dr[ "PLAYS" ] = t.Passes + t.Runs; dr[ "PASSES" ] = t.Passes; dr[ "RUNS" ] = t.Runs; dr[ "PPERCENT" ] = Utility.Percent( t.Passes, t.Passes + t.Runs ); dr[ "RPERCENT" ] = Utility.Percent(t.Runs, t.Passes + t.Runs); dr[ "TDPASSES" ] = string.Format( "<a href='{0}'>{1}</a>", t.TdpBreakdownLink(), t.Tdp ); dr[ "TDRUNS" ] = string.Format( "<a href='{0}'>{1}</a>", t.TdrBreakdownLink(), t.Tdr ); str.Body.Rows.Add( dr ); totTDp += t.Tdp; totTDr += t.Tdr; } str.ReportFooter = string.Format("Total TDr : {0}<br>Total TDp : {1}", totTDr, totTDp ); str.IsFooter = true; Utility.Announce(str.ReportFooter); }
public void Render() { NflSeason = new NflSeason( Year, loadGames: false, loadDivisions: false); NflSeason.LoadRegularWeeks(); var str = new SimpleTableReport( string.Format( "Score Grid {0}-{1}", NflSeason.Year, ScopeInFocus ) ) { ReportHeader = ScopeInFocus }; StyleHelper.AddStyle( str ); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn( new ReportColumn( "Stat", "STAT", "{0}" ) ); str.AddColumn( new ReportColumn( "Total", "TOT", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk01", "WK01", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk02", "WK02", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk03", "WK03", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk04", "WK04", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk05", "WK05", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk06", "WK06", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk07", "WK07", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk08", "WK08", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk09", "WK09", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk10", "WK10", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk11", "WK11", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk12", "WK12", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk13", "WK13", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk14", "WK14", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk15", "WK15", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk16", "WK16", "{0}" ) ); str.AddColumn( new ReportColumn( "Wk17", "WK17", "{0}" ) ); str.LoadBody( BuildTable() ); //str.SubHeader = SubHeading(); str.RenderAsHtml( FileName(), true ); }
public void Render() { var report = string.Format( "Hillen Tips {0}-{1}", Season.Year, Week.Week ); var str = new SimpleTableReport( report ) { ReportHeader = report }; StyleHelper.AddStyle( str ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn( new ReportColumn( "Away", "AWAY", "{0}" ) ); str.AddColumn( new ReportColumn( "AwayTip", "AWAYTIP", "{0}" ) ); str.AddColumn( new ReportColumn( "Home", "HOME", "{0}" ) ); str.AddColumn( new ReportColumn( "HomeTip", "HOMETIP", "{0}" ) ); str.AddColumn( new ReportColumn( "HLine", "HLINE", "{0}" ) ); str.AddColumn( new ReportColumn( "Spr", "SPREAD", "{0}" ) ); str.AddColumn( new ReportColumn( "Result", "RESULT", "{0}" ) ); str.AddColumn( new ReportColumn( "SuResult", "SURESULT", "{0}" ) ); str.AddColumn( new ReportColumn( "SuWins", "SUWINS", "{0}" ) ); str.AddColumn( new ReportColumn( "SuLoses", "SULOSES", "{0}" ) ); str.AddColumn( new ReportColumn( "SprResult", "SPRRESULT", "{0}" ) ); str.AddColumn( new ReportColumn( "Wins", "WINS", "{0}" ) ); str.AddColumn( new ReportColumn( "Loses", "LOSES", "{0}" ) ); str.AddColumn( new ReportColumn( "Ties", "TIES", "{0}" ) ); str.LoadBody( BuildTable() ); //str.SubHeader = SubHeading(); str.RenderAsHtml( FileName(), true ); }
/// <summary> /// Creates the output. /// </summary> public void Render() { var str = new SimpleTableReport("Player Projection " + Player.PlayerName + "-" + Season); str.AddStyle( "#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 641px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }"); str.AddStyle("#main { margin-left:1em; }"); str.AddStyle("#dtStamp { font-size:0.8em; }"); str.AddStyle(".end { clear: both; }"); str.AddStyle(".gponame { color:white; background:black }"); str.AddStyle( "label { display:block; float:left; width:130px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:right; }"); str.AddStyle( "value { display:block; float:left; width:100px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:left; font-weight: bold; color:blue }"); str.AddStyle( "#notes { float:right; height:auto; width:308px; font-size: 88%; background-color: #ffffe1; border: 1px solid #666666; padding: 5px; margin: 0px 0px 10px 10px; color:#666666 }"); str.AddStyle( "div.notes H4 { background-image: url(images/icon_info.gif); background-repeat: no-repeat; background-position: top left; padding: 3px 0px 3px 27px; border-width: 0px 0px 1px 0px; border-style: solid; border-color: #666666; color: #666666; font-size: 110%;}"); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn(new ReportColumn("Week", "WEEK", "{0}")); str.AddColumn(new ReportColumn("Matchup", "MATCH", "{0}")); str.AddColumn(new ReportColumn("Score", "SCORE", "{0}")); str.AddColumn(new ReportColumn("OppUnit", "OPPRATE", "{0}")); str.AddColumn(new ReportColumn("Proj", "PROJ", "{0:0.0}", true)); str.AddColumn(new ReportColumn("Y-FP", "FP", "{0:0.0}", true)); str.AddColumn(new ReportColumn("Stats", "STATS", "{0}")); str.AddColumn(new ReportColumn("Actual", "ACTUAL", "{0:0.0}", true)); str.AddColumn(new ReportColumn("ActStats", "ACTUALSTAT", "{0:0.0}")); str.AddColumn(new ReportColumn("Variation", "VAR", "{0:0.0}", tally:true)); str.LoadBody(BuildTable()); str.SubHeader = SubHeading(); str.RenderAsHtml(FileName(), true); }
private void BuildTable(SimpleTableReport str) { if (weekList != null) { foreach (NFLWeek w in weekList) { if (w != null) { if ( w.HasPassed() ) { DataRow dr = str.Body.NewRow(); dr[ "WEEK" ] = w.Week; dr[ "GAMES" ] = w.GameList().Count; dr[ "SPREAD" ] = w.SpreadTotalCorrect(); dr[ "MYTIPS" ] = w.MyTipsCorrect(); dr[ "ATS" ] = w.MyAtsCorrect(); dr[ "HOME" ] = w.TotalHomeWins(); str.Body.Rows.Add(dr); } } } } return; }
public override void RenderAsHtml() { Name = "Market Analysis " + Season; var dt = GetTeams(); _mTeamList = new ArrayList(); foreach (var t in from DataRow dr in dt.Rows select dr["TEAMID"].ToString() into teamCode select new NflTeam(teamCode)) { t.CountFaPoints(Season); _mTeamList.Add(t); } // Use a simple table output to show the rankings var str = new SimpleTableReport { ReportHeader = Name, ColumnHeadings = true, DoRowNumbers = true }; str.AddColumn(new ReportColumn("Team", "TEAM", "{0,-20}")); str.AddColumn(new ReportColumn("FA Points", "FA", "{0,5}")); str.AddColumn(new ReportColumn("In", "IN", "{0,5}")); str.AddColumn(new ReportColumn("Got", "GOT", "{0}")); str.AddColumn(new ReportColumn("Out", "OUT", "{0,5}")); str.AddColumn(new ReportColumn("Lost", "LOST", "{0}")); str.AddColumn(new ReportColumn("Net", "NET", "{0}")); str.LoadBody(BuildTable()); FileOut = OutputFilename(); str.RenderAsHtml( FileOut, true); }
/// <summary> /// Renders the object as a simple HTML report. /// </summary> public override void RenderAsHtml() { Name = "Strength of Schedule"; var ds = Utility.TflWs.TeamsDs(Season); var dt = ds.Tables["Team"]; _teamList = new ArrayList(); foreach (DataRow dr in dt.Rows) { var t = new NflTeam(dr["TEAMID"].ToString(), Season, Int32.Parse(dr["WINS"].ToString()), dr["TEAMNAME"].ToString()); t.StrengthOfSchedule(); _teamList.Add(t); } var str = new SimpleTableReport(Name) {ColumnHeadings = true, DoRowNumbers = true}; str.AddColumn(new ReportColumn("Team", KFieldTeam, "{0,-20}")); str.AddColumn(new ReportColumn("SoS", KFieldSos, "{0}")); str.AddColumn(new ReportColumn("Exp W", KFieldExpWins, "{0}")); str.AddColumn(new ReportColumn("Exp L", KFieldExpLosses, "{0}")); str.AddColumn(new ReportColumn("Prev W", KFieldWins, "{0}")); str.AddColumn(new ReportColumn("Prev L", KFieldLosses, "{0}")); str.AddColumn(new ReportColumn("Var", KFieldVariance, "{0}")); str.LoadBody(BuildTable()); str.RenderAsHtml( OutputFilename(), true ); }
public void Render() { var str = new SimpleTableReport( string.Format( "Stat Grid {0}-{1}", Season.Year, StatInFocus ) ) {ReportHeader = StatInFocus}; StyleHelper.AddStyle( str ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.Totals = true; str.AddColumn( new ReportColumn( "Team", "TEAM", "{0}" ) ); str.AddColumn( new ReportColumn( "Total", "TOT", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk01", "WK01", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk02", "WK02", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk03", "WK03", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk04", "WK04", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk05", "WK05", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk06", "WK06", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk07", "WK07", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk08", "WK08", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk09", "WK09", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk10", "WK10", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk11", "WK11", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk12", "WK12", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk13", "WK13", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk14", "WK14", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk15", "WK15", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk16", "WK16", "{0}", tally: true ) ); str.AddColumn( new ReportColumn( "Wk17", "WK17", "{0}", tally: true ) ); str.LoadBody( BuildTable() ); //str.SubHeader = SubHeading(); str.RenderAsHtml( FileName(), true ); }
public string RenderData(ArrayList unitList, string sHead, NFLWeek week) { // Output the list var tu1 = (TeamUnit) unitList[0]; var r = new SimpleTableReport {ReportHeader = sHead, ReportFooter = "", DoRowNumbers = true}; var ds = LoadData(unitList, week); r.AddColumn(new ReportColumn("Name", "TEAM", "{0,-15}")); r.AddColumn(new ReportColumn("Rating", "RATING", "{0,-1}")); r.AddColumn(new ReportColumn("Total", "tot", "{0,5}")); const int startAt = Constants.K_WEEKS_IN_A_SEASON; var currentWeek = new NFLWeek(Int32.Parse(Utility.CurrentSeason()), Int32.Parse(Utility.CurrentWeek()), false); for (var w = startAt; w > 0; w--) { var header = string.Format("Week {0}", currentWeek.Week); var fieldName = string.Format(FieldFormat, currentWeek.WeekNo); r.AddColumn(new ReportColumn(header, fieldName, "{0,5}", tu1.BGPicker)); currentWeek = currentWeek.PreviousWeek(currentWeek, true, false ); } var dt = ds.Tables[0]; dt.DefaultView.Sort = "tot " + tu1.SortDirection(); r.LoadBody(dt); FileOut = string.Format( "{0}Units\\{1}.htm", Utility.OutputDirectory(), sHead ); r.RenderAsHtml( FileOut, true); return FileOut; }
/// <summary> /// Creates the output. /// </summary> public void Render() { var homeRatings = Game.HomeNflTeam.Ratings; var awayRatings = Game.AwayNflTeam.Ratings; Game.LoadPrediction(); // ratings get overwritten!! Game.HomeNflTeam.Ratings = homeRatings; Game.AwayNflTeam.Ratings = awayRatings; var str = new SimpleTableReport( "GameProjection " + Game.GameName() ); str.AddDenisStyle(); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AnnounceIt = AnnounceIt; str.AddColumn( new ReportColumn( "Team", "TEAM", "{0}" ) ); str.AddColumn( new ReportColumn( "Rating", "RATING", "{0}" ) ); str.AddColumn( new ReportColumn( "Score", "SCORE", "{0}", ScoreTotalDelegate ) ); str.AddColumn( new ReportColumn( "YDp", "YDP", "{0}", true ) ); str.AddColumn( new ReportColumn( "Tdp", "TDP", "{0}", true ) ); str.AddColumn( new ReportColumn( "YDr", "YDR", "{0}", true ) ); str.AddColumn( new ReportColumn( "Tdr", "TDR", "{0}", true ) ); str.AddColumn( new ReportColumn( "TDd", "TDD", "{0}", true ) ); str.AddColumn( new ReportColumn( "TDs", "TDS", "{0}", true ) ); str.AddColumn( new ReportColumn( "FGs", "FG", "{0}", true ) ); str.LoadBody( BuildTable() ); str.SubHeader = SubHeading(); str.FootNote = Game.PlayerProjectionsHtml(); // these projections are old str.RenderAsHtml( FileName(), true ); }
/// <summary> /// Creates the output. /// </summary> public void Render() { var str = new SimpleTableReport( "Player Profile " + Player.PlayerName ); str.AddStyle( "#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 641px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }" ); str.AddStyle( "#main { margin-left:1em; }" ); str.AddStyle( "#dtStamp { font-size:0.8em; }" ); str.AddStyle( ".end { clear: both; }" ); str.AddStyle( ".gponame { color:white; background:black }" ); str.AddStyle( "label { display:block; float:left; width:130px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:right; }" ); str.AddStyle( "value { display:block; float:left; width:100px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:left; font-weight: bold; color:blue }" ); str.AddStyle( "#notes { float:right; height:auto; width:308px; font-size: 88%; background-color: #ffffe1; border: 1px solid #666666; padding: 5px; margin: 0px 0px 10px 10px; color:#666666 }" ); str.AddStyle( "div.notes H4 { background-image: url(images/icon_info.gif); background-repeat: no-repeat; background-position: top left; padding: 3px 0px 3px 27px; border-width: 0px 0px 1px 0px; border-style: solid; border-color: #666666; color: #666666; font-size: 110%;}" ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn( new ReportColumn( "Week", "WEEK", "{0}" ) ); str.AddColumn( new ReportColumn( "Team", "TEAM", "{0}" ) ); str.AddColumn( new ReportColumn( "U-Res", "URES", "{0}" ) ); str.AddColumn( new ReportColumn( "EP", "EP", "{0:0.0}", true ) ); str.AddColumn( new ReportColumn( "Matchup", "MATCH", "{0}" ) ); str.AddColumn( new ReportColumn( "Stats", "STATS", "{0}" ) ); str.AddColumn( new ReportColumn( "F Pts", "FPTS", "{0}", true ) ); str.LoadBody( BuildTable() ); str.SubHeader = SubHeading(); str.RenderAsHtml( string.Format("{0}players//{1}.htm", Utility.OutputDirectory(), Player.PlayerCode), true); }
public ScoreCount(string season) { Season = season; _r = new SimpleTableReport(string.Format("Score Counts : {0}", Season)) {ColumnHeadings = true, Totals = false, DoRowNumbers = false}; _r.AddColumn(new ReportColumn("Score Type", "SCORE", "{0,-20}")); _r.AddColumn(new ReportColumn("Count", "VALUE", "{0}", true)); _dt = new DataTable(); var sf = new ScoreFactory(); _scoreList = sf.GetAllScoreTypes(); Load(); }
private void BuildTable( SimpleTableReport str ) { foreach (var tipster in Tipsters) { var dr = str.Body.NewRow(); dr["METHOD"] = tipster.Key; dr[ "WINS" ] = tipster.Value.Wins; dr[ "LOSSES" ] = tipster.Value.Losses; dr[ "TIES" ] = tipster.Value.Ties; dr[ "CLIP" ] = tipster.Value.Clip(); str.Body.Rows.Add( dr ); } return; }
private void Render() { SimpleTableReport str = new SimpleTableReport( "Gordan Rankings : Week " + Utility.CurrentWeek() ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.AddColumn( new ReportColumn( "Team", "TEAM", "{0,-20}" ) ); str.AddColumn( new ReportColumn( "Rating", "RANK", "{0}" ) ); for ( int i = Int32.Parse( Utility.CurrentWeek() ); i > -1; i-- ) { string colName = string.Format( "Week{0:0#}", i ); str.AddColumn( new ReportColumn( colName, colName, "{0}" ) ); } str.LoadBody( dt ); str.RenderAsHtml( string.Format("{0}Gordan{1}{2}.htm", Utility.OutputDirectory(), s.Year, Utility.CurrentWeek()), true ); }
public override void RenderAsHtml() { var str = new SimpleTableReport("Run Report"); str.AddDenisStyle(); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = true; str.IsFooter = false; str.AddColumn( new ReportColumn( "Machine", "MACHINE", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "Report", "REPORT", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "Finished", "FINISHED", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "At", "FINISHAT", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "Elapsed", "ELAPSED", "{0}", typeof( string ) ) ); BuildTable( str ); //str.SetSortOrder( "FINISHED DESC" ); str.RenderAsHtml( OutputFilename(), true ); Finish(); }
private void BuildTable( SimpleTableReport str ) { if ( Team.GameList != null ) { foreach ( NFLGame g in Team.GameList ) { if ( g != null ) { DataRow dr = str.Body.NewRow(); g.LoadStats( tflWS ); dr[ "WEEK" ] = g.GameCodeOut(); dr[ "OPP" ] = g.Opponent( Team.TeamCode ); dr[ "COUNT" ] = g.StatFor( Team.TeamCode, StatCode ); dr[ "WHO" ] = g.PlayersFor( Team.TeamCode, StatCode ); str.Body.Rows.Add( dr ); } } } return; }
private static void BuildTable( SimpleTableReport str ) { var dt = Utility.TflWs.GetRuns( DateTime.Now.Subtract( new TimeSpan( 7 * 24, 0, 0 ) ) ); var cutOffDate = DateTime.Now.Subtract( new TimeSpan( 12, 0, 0, 0 ) ); foreach ( DataRow r in dt.Rows ) { var dr = str.Body.NewRow(); var dRun = DateTime.Parse( r[ "FINISHED" ].ToString() ); if ( dRun <= cutOffDate ) continue; dr[ "MACHINE" ] = r[ "MACHINE" ]; dr[ "FINISHED" ] = string.Format( "{0:ddd dd MMM yyyy}", dRun ); dr[ "FINISHAT" ] = r[ "FINISHAT" ]; dr[ "ELAPSED" ] = string.Format( "{0,2}:{1,2:00}:{2,2:00}", r[ "HRS" ], r[ "MINS" ], r[ "SECS" ] ); dr[ "REPORT" ] = r[ "STEP" ]; str.Body.Rows.Add( dr ); } }
/// <summary> /// Creates the output. /// </summary> public void Render() { SimpleTableReport str = new SimpleTableReport( string.Format( "{0}-{1}", StatCode, Team.TeamCode ) ); str.AddStyle( "#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 641px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }" ); str.AddStyle( "#main { margin-left:1em; }" ); str.AddStyle( "#dtStamp { font-size:0.8em; }" ); str.AddStyle( ".end { clear: both; }" ); str.AddStyle( ".gponame { color:white; background:black }" ); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn( new ReportColumn( "Week", "WEEK", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "Opp", "OPP", "{0}", typeof( String ) ) ); str.AddColumn( new ReportColumn( "Count", "COUNT", "{0}", typeof( String ), true ) ); str.AddColumn( new ReportColumn( "Who", "WHO", "{0}", typeof( String ) ) ); BuildTable( str ); //str.SubHeader = SubHeading(); str.RenderAsHtml(string.Format("{0}{1}-{2}.htm", Utility.OutputDirectory(), Team.TeamCode, StatCode), true); }
public void GameRatings( NFLWeek week, string fTeamOwner ) { string when = string.Format( "Week{0}-{1:0#}", week.Season, Int32.Parse( week.Week ) ); //RosterLib.Utility.Announce( string.Format( "GameRatings for {0} owner {1}", when, fTeamOwner ) ); var str = new SimpleTableReport( string.Format( "Game Ratings {1}: {0}", when, Name ) ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.AddColumn( new ReportColumn( "Rating", "RATING", "{0}", typeof( Int32 ), true ) ); str.AddColumn( new ReportColumn( "Day", "DAY", "{0}", typeof( String) ) ); str.AddColumn( new ReportColumn( "Time", "HOUR", "{0}", typeof( String) ) ); str.AddColumn( new ReportColumn( "AT", "AT", "{0}", typeof( String) ) ); str.AddColumn( new ReportColumn( "HT", "HT", "{0}", typeof( String) ) ); str.AddColumn( new ReportColumn( "TV", "TV", "{0}", typeof( String) ) ); str.AddColumn( new ReportColumn( "Fav", "FAV", "{0}", typeof( String) ) ); str.AddColumn( new ReportColumn( "Spr", "SPREAD", "{0}", typeof( String) ) ); str.AddColumn( new ReportColumn( "myTip", "TIP", "{0}", typeof( String) ) ); BuildRatingsTable( str, fTeamOwner, week ); str.RenderAsHtml(string.Format("{0}gameratings\\Ratings{2}{1}.htm", Utility.OutputDirectory(), when, CompCode), true); }
public void Render() { LoadTeams(); var heading = Week == null ? "Scores Season " + Season : "Scores : Week " + Week; var str = new SimpleTableReport( heading ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.AddColumn( new ReportColumn( "Team", "TEAM", "{0,-20}" ) ); str.AddColumn( new ReportColumn( "Total", "TOTAL", "{0}" ) ); str.AddColumn( new ReportColumn( "Passes", "TDp", "{0}" ) ); str.AddColumn( new ReportColumn( "Runs", "TDr", "{0}" ) ); str.AddColumn( new ReportColumn( "Punt returns", "TDt", "{0}" ) ); str.AddColumn( new ReportColumn( "KO returns", "TDk", "{0}" ) ); str.AddColumn( new ReportColumn( "Int returns", "TDi", "{0}" ) ); str.AddColumn( new ReportColumn( "Fumble returns", "TDf", "{0}" ) ); str.LoadBody( BuildTable() ); FileOut = Week == null ? string.Format( "{0}//Scores/{1}//Scores.htm", Utility.OutputDirectory(), Season ) : string.Format( "{0}//Scores/{1}//Scores-{2}.htm",Utility.OutputDirectory(), Season, Week ); str.RenderAsHtml( FileOut, true ); }
public void Render() { var str = new SimpleTableReport( string.Format( "Tipping Comp - {0:d}", DateTime.Now ) ); str.AddStyle( "#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 761px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }" ); str.AddStyle( "#main { margin-left:1em; }" ); str.AddStyle( "#dtStamp { font-size:0.8em; }" ); str.AddStyle( ".end { clear: both; }" ); str.AddStyle( ".gponame { color:white; background:black }" ); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn( new ReportColumn( "Method", "METHOD", "{0}", typeof( String ), false ) ); str.AddColumn( new ReportColumn( "Wins", "WINS", "{0}", typeof( Int32 ), tally: true ) ); str.AddColumn( new ReportColumn( "Losses", "LOSSES", "{0}", typeof( Int32 ), tally:true ) ); str.AddColumn( new ReportColumn( "Ties", "TIES", "{0}", typeof( Int32 ), tally: true ) ); str.AddColumn( new ReportColumn( "Clip", "CLIP", "{0:#.##0}", typeof( Decimal ), false ) ); BuildTable( str ); str.SetSortOrder( "Clip DESC" ); str.RenderAsHtml( OutputFilename, true ); }
public void Render(string header) { // Output the list Heading = header; Utility.Announce("TeamListing " + Heading); var r = new SimpleTableReport(Heading, "") {DoRowNumbers = true}; if (!string.IsNullOrEmpty(SubHeading)) r.SubHeader = SubHeading; var ds = LoadData(); r.AddColumn(new ReportColumn("Name", "NAME", "{0,-15}")); r.AddColumn(new ReportColumn("Sacks", "SACKS", "{0,9}")); r.AddColumn(new ReportColumn("Interceptions", "INTERCEPTS", "{0,4}")); r.AddColumn(new ReportColumn("Points", "POINTS", "{0,5}")); var dt = ds.Tables[0]; dt.DefaultView.Sort = "Points DESC"; r.LoadBody(dt); FileOut = string.Format("{0}{1}.htm", Utility.OutputDirectory(), Heading); r.RenderAsHtml( FileOut, true ); }
public void Render() { var str = new SimpleTableReport($"Suggested Lineup {Season}:{Week:#0} {LeagueId}"); str.AddDenisStyle(); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn(new ReportColumn("Slot", "SLOT", "{0:00}")); str.AddColumn(new ReportColumn("Player", "PLAYER", "{0}")); str.AddColumn(new ReportColumn("Team", "TEAM", "{0}")); str.AddColumn(new ReportColumn("Pos", "POS", "{0}")); str.AddColumn(new ReportColumn("RPoints", "PTS", "{0}")); str.AddColumn(new ReportColumn("Role", "ROLE", "{0}")); str.AddColumn(new ReportColumn("Game", "GAME", "{0}")); str.AddColumn(new ReportColumn("OppUnit", "OPPRATE", "{0}")); str.AddColumn(new ReportColumn("Spread", "SPREAD", "{0:##.#}")); str.AddColumn(new ReportColumn("Total", "TOTAL", "{0:##.#}")); str.AddColumn(new ReportColumn("Actual", "ACTUAL", "{0:##}")); str.LoadBody(BuildTable()); str.SetSortOrder("SLOT,PTS DESC"); str.RenderAsHtml(FileName(), true); }
/// <summary> /// Creates the output. /// </summary> public void Render() { var fileName = $"{Utility.OutputDirectory()}players//{Player.PlayerCode}.htm"; var lastReportDate = GetLastReportDate(fileName); #if DEBUG var rootDataPath = "e:\\tfl\\"; #else var rootDataPath = "c:\\tfl"; #endif var dData = GetDataDate(rootDataPath); bool reportIsStale = dData > lastReportDate; if (reportIsStale) { var str = new SimpleTableReport("Player Profile " + Player.PlayerName); str.AddDenisStyle(); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn(new ReportColumn("Week", "WEEK", "{0}")); str.AddColumn(new ReportColumn("Team", "TEAM", "{0}")); str.AddColumn(new ReportColumn("U-Res", "URES", "{0}")); str.AddColumn(new ReportColumn("EP", "EP", "{0:0.0}", true)); str.AddColumn(new ReportColumn("Matchup", "MATCH", "{0}")); str.AddColumn(new ReportColumn("Stats", "STATS", "{0}")); str.AddColumn(new ReportColumn("F Pts", "FPTS", "{0}", true)); str.LoadBody(BuildTable()); str.SubHeader = SubHeading(); str.RenderAsHtml(fileName, true); } else { Console.WriteLine($"player report for {Player.PlayerName} skipped"); } }
/// <summary> /// Creates the output. /// </summary> public void Render() { var str = new SimpleTableReport("Player Projection " + Player.PlayerName + "-" + Season); str.AddStyle( "#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 641px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }"); str.AddStyle("#main { margin-left:1em; }"); str.AddStyle("#dtStamp { font-size:0.8em; }"); str.AddStyle(".end { clear: both; }"); str.AddStyle(".gponame { color:white; background:black }"); str.AddStyle( "label { display:block; float:left; width:130px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:right; }"); str.AddStyle( "value { display:block; float:left; width:100px; padding: 3px 5px; margin: 0px 0px 5px 0px; text-align:left; font-weight: bold; color:blue }"); str.AddStyle( "#notes { float:right; height:auto; width:308px; font-size: 88%; background-color: #ffffe1; border: 1px solid #666666; padding: 5px; margin: 0px 0px 10px 10px; color:#666666 }"); str.AddStyle( "div.notes H4 { background-image: url(images/icon_info.gif); background-repeat: no-repeat; background-position: top left; padding: 3px 0px 3px 27px; border-width: 0px 0px 1px 0px; border-style: solid; border-color: #666666; color: #666666; font-size: 110%;}"); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn(new ReportColumn("Week", "WEEK", "{0}")); str.AddColumn(new ReportColumn("Matchup", "MATCH", "{0}")); str.AddColumn(new ReportColumn("Score", "SCORE", "{0}")); str.AddColumn(new ReportColumn("OppUnit", "OPPRATE", "{0}")); str.AddColumn(new ReportColumn("Proj", "PROJ", "{0:0.0}", true)); str.AddColumn(new ReportColumn("Y-FP", "FP", "{0:0.0}", true)); str.AddColumn(new ReportColumn("Stats", "STATS", "{0}")); str.AddColumn(new ReportColumn("Actual", "ACTUAL", "{0:0.0}", true)); str.AddColumn(new ReportColumn("ActStats", "ACTUALSTAT", "{0:0.0}")); str.AddColumn(new ReportColumn("Variation", "VAR", "{0:0.0}", tally: true)); str.LoadBody(BuildTable()); str.SubHeader = SubHeading(); str.RenderAsHtml(FileName(), true); }
public void Render() { var str = new SimpleTableReport($"Stat Grid {Season.Year}-{StatInFocus}") { ReportHeader = StatInFocus }; StyleHelper.AddStyle(str); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.Totals = true; str.AddColumn(new ReportColumn("Team", "TEAM", "{0}")); str.AddColumn(new ReportColumn("Total", "TOT", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk01", "WK01", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk02", "WK02", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk03", "WK03", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk04", "WK04", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk05", "WK05", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk06", "WK06", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk07", "WK07", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk08", "WK08", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk09", "WK09", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk10", "WK10", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk11", "WK11", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk12", "WK12", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk13", "WK13", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk14", "WK14", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk15", "WK15", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk16", "WK16", "{0}", tally: true)); str.AddColumn(new ReportColumn("Wk17", "WK17", "{0}", tally: true)); str.LoadBody(BuildTable()); //str.SubHeader = SubHeading(); str.RenderAsHtml(FileName(), true); }
/// <summary> /// Creates the output. /// </summary> public void Render() { var homeRatings = Game.HomeNflTeam.Ratings; var awayRatings = Game.AwayNflTeam.Ratings; Game.LoadPrediction(); // ratings get overwritten!! Game.HomeNflTeam.Ratings = homeRatings; Game.AwayNflTeam.Ratings = awayRatings; var str = new SimpleTableReport( "GameProjection " + Game.GameName()); str.AddDenisStyle(); str.ColumnHeadings = true; str.DoRowNumbers = false; str.ShowElapsedTime = false; str.IsFooter = false; str.AnnounceIt = AnnounceIt; str.AddColumn(new ReportColumn("Team", "TEAM", "{0}")); str.AddColumn(new ReportColumn("Rating", "RATING", "{0}")); str.AddColumn(new ReportColumn("Score", "SCORE", "{0}", ScoreTotalDelegate)); str.AddColumn(new ReportColumn("YDp", "YDP", "{0}", true)); str.AddColumn(new ReportColumn("Tdp", "TDP", "{0}", true)); str.AddColumn(new ReportColumn("YDr", "YDR", "{0}", true)); str.AddColumn(new ReportColumn("Tdr", "TDR", "{0}", true)); str.AddColumn(new ReportColumn("TDd", "TDD", "{0}", true)); str.AddColumn(new ReportColumn("TDs", "TDS", "{0}", true)); str.AddColumn(new ReportColumn("FGs", "FG", "{0}", true)); str.LoadBody(BuildTable()); str.SubHeader = SubHeading(); str.FootNote = Game.PlayerProjectionsHtml(); // these projections are old str.RenderAsHtml( FileName(), persist: true); }
private void BuildTable(SimpleTableReport str) { var totTDp = 0; var totTDr = 0; if (TeamList == null) { return; } foreach (NflTeam t in TeamList) { if (t == null) { continue; } var dr = str.Body.NewRow(); t.TallyPlays(Season, skipPostseason: true); dr["TEAM"] = t.NameOut(); dr["RATING"] = t.Ratings; dr["PLAYS"] = t.Passes + t.Runs; dr["PASSES"] = t.Passes; dr["RUNS"] = t.Runs; dr["PPERCENT"] = Utility.Percent(t.Passes, t.Passes + t.Runs); dr["RPERCENT"] = Utility.Percent(t.Runs, t.Passes + t.Runs); dr["TDPASSES"] = string.Format("<a href='{0}'>{1}</a>", t.TdpBreakdownLink(), t.Tdp); dr["TDRUNS"] = string.Format("<a href='{0}'>{1}</a>", t.TdrBreakdownLink(), t.Tdr); str.Body.Rows.Add(dr); totTDp += t.Tdp; totTDr += t.Tdr; } str.ReportFooter = string.Format("Total TDr : {0}<br>Total TDp : {1}", totTDr, totTDp); str.IsFooter = true; Utility.Announce(str.ReportFooter); }
private static void DumpMetricTable( DataTable dt, DateTime when) { var st = new SimpleTableReport( $"Team Metrics at {when.ToShortDateString()}" ) { ColumnHeadings = true }; st.AddColumn(new ReportColumn("Team", "TEAM", "{0,-20}")); st.AddColumn(new ReportColumn("YDp", "YDp", "{0}")); st.AddColumn(new ReportColumn("RYDp", "RYDp", "{0}")); st.AddColumn(new ReportColumn("YDr", "YDr", "{0}")); st.AddColumn(new ReportColumn("RYDr", "RYDr", "{0}")); st.AddColumn(new ReportColumn("SAKa", "SAKa", "{0}")); st.AddColumn(new ReportColumn("RSAKa", "RSAKa", "{0}")); st.AddColumn(new ReportColumn("SAK", "SAK", "{0}")); st.AddColumn(new ReportColumn("RSAK", "RSAK", "{0}")); st.AddColumn(new ReportColumn("YDra", "YDra", "{0}")); st.AddColumn(new ReportColumn("RYDra", "RYDra", "{0}")); st.AddColumn(new ReportColumn("INT", "INT", "{0}")); st.AddColumn(new ReportColumn("TDpa", "TDpa", "{0}")); st.AddColumn(new ReportColumn("IntRatio", "IntRatio", "{0}")); st.AddColumn(new ReportColumn("RIntRatio", "RIntRatio", "{0}")); st.AddColumn(new ReportColumn("RPoints", "RPTS", "{0}")); dt.DefaultView.Sort = "INT DESC"; st.LoadBody(dt); st.RenderAsHtml( fileName: string.Format("{0}\\{1}\\Metrics\\MetricTable.htm", Utility.OutputDirectory(), Utility.CurrentSeason()), persist: true); }
public override void RenderAsHtml() { Name = "Market Analysis " + Season; var dt = GetTeams(); _mTeamList = new ArrayList(); foreach (var t in from DataRow dr in dt.Rows select dr["TEAMID"].ToString() into teamCode select new NflTeam(teamCode)) { t.CountFaPoints(Season); _mTeamList.Add(t); } // Use a simple table output to show the rankings var str = new SimpleTableReport { ReportHeader = Name, ColumnHeadings = true, DoRowNumbers = true }; str.AddColumn(new ReportColumn("Team", "TEAM", "{0,-20}")); str.AddColumn(new ReportColumn("FA Points", "FA", "{0,5}")); str.AddColumn(new ReportColumn("In", "IN", "{0,5}")); str.AddColumn(new ReportColumn("Got", "GOT", "{0}")); str.AddColumn(new ReportColumn("Out", "OUT", "{0,5}")); str.AddColumn(new ReportColumn("Lost", "LOST", "{0}")); str.AddColumn(new ReportColumn("Net", "NET", "{0}")); str.LoadBody(BuildTable()); FileOut = OutputFilename(); str.RenderAsHtml(FileOut, true); }
public void Render() { LoadTeams(); // By each Team var heading = Week == null ? "GL Scores Season " + Season : "Scores : Week " + Week; var str = new SimpleTableReport(heading) { ColumnHeadings = true, DoRowNumbers = true }; str.AddColumn(new ReportColumn("Team", "TEAM", "{0,-20}")); str.AddColumn(new ReportColumn("Total", "TOTAL", "{0}")); AddWeeklyColumns(str); str.LoadBody(BuildAndLoadDataTable()); FileOut = Week == null ? $"{Utility.OutputDirectory()}{Season}//Scores//GLScores.htm" : $"{Utility.OutputDirectory()}{Season}//Scores//GLScores-{Week}.htm"; str.RenderAsHtml(FileOut, persist: true); }
private void Render(SimpleTableReport r, string header) { r.LoadBody(Data); r.RenderAsHtml(string.Format("{0}{1}.htm", Utility.OutputDirectory(), header), true); }
public void RenderAsHtml( string fileName, string season ) { var st = new SimpleTableReport( "Frequency Table " + name, StdFooter()) {ColumnHeadings = true}; st.AddColumn( new ReportColumn( "Occurence", "Occurence", "{0:##0}" ) ); st.AddColumn( new ReportColumn( "Freq.", "Frequency", "{0}" ) ); st.AddColumn( new ReportColumn( "Cum. Freq.", "Cumulative", "{0}" ) ); st.AddColumn( new ReportColumn( "Percent ", "Percent", "{0:##0.0}" ) ); st.AddColumn( new ReportColumn( "Cum. %", "TotPercent", "{0:##0.0}" ) ); st.LoadBody( dt ); st.DoRowNumbers = false; st.ShowElapsedTime = false; FileName = string.Format("{0}{2}\\Frequency\\{1}.htm", Utility.OutputDirectory(), name, season); st.RenderAsHtml( FileName, true); }
public string RenderData( ArrayList playerList, string sHead, NFLWeek week) { // Output the list var r = new SimpleTableReport { ReportHeader = sHead, ReportFooter = "", DoRowNumbers = true }; var ds = LoadData(playerList, week); r.AddColumn(new ReportColumn("Name", "NAME", "{0,-15}")); r.AddColumn(new ReportColumn("Team", "CURRTEAM", "{0,2}")); r.AddColumn(new ReportColumn("Role", "ROLE", "{0,1}")); r.AddColumn(new ReportColumn("Owner", "FT", "{0,2}")); r.AddColumn(new ReportColumn("Total", "tot", "{0,5}")); var startAt = FullStart ? Constants.K_WEEKS_IN_A_SEASON : Constants.K_WEEKS_IN_REGULAR_SEASON; for (var w = startAt; w > 0; w--) { var header = $"Week {w}"; var fieldName = string.Format(FieldFormat, w); if (IsGridStatsQBReport(sHead)) { r.AddColumn( new ReportColumn(header, fieldName, "{0,5}", QbBgPicker)); } if (IsYahooQbReport(sHead)) { r.AddColumn( new ReportColumn(header, fieldName, "{0,5}", EspnQbBgPicker)); } if (IsYahooRbReport(sHead)) { r.AddColumn( new ReportColumn(header, fieldName, "{0,5}", EspnRbBgPicker)); } if (IsYahooWrReport(sHead)) { r.AddColumn( new ReportColumn(header, fieldName, "{0,5}", EspnWrBgPicker)); } if (IsYahooTeReport(sHead)) { r.AddColumn( new ReportColumn(header, fieldName, "{0,5}", EspnTeBgPicker)); } if (IsYahooPkReport(sHead)) { r.AddColumn( new ReportColumn(header, fieldName, "{0,5}", EspnPkBgPicker)); } } var dt = ds.Tables[0]; dt.DefaultView.Sort = "tot DESC"; r.LoadBody(dt); FileOut = sHead; r.RenderAsHtml(FileOut, true); return(FileOut); }
/// <summary> /// Make a big report then write it as CSV /// </summary> public void DumpPlayersToCsv() { // Define the simple report var when = string.Format("Week{0}-{1:0#}", Utility.CurrentSeason(), Int32.Parse(Utility.CurrentWeek()) + 1); var str = new SimpleTableReport(string.Format("Player Stats : {0}", when)); str.AddColumn(new ReportColumn("Jersey", "JERSEY", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Name", "NAME", "{0,-15}", typeof (String))); str.AddColumn(new ReportColumn("Team", "CURRTEAM", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Unit", "UNIT", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Rookie", "ROOKIEYR", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Drafted", "DRAFTED", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Category", "CATEGORY", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Pos", "POSDESC", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Role", "ROLE", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Owner", "OWNER", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Age", "AGE", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Stars", "STARS", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Value", "VALUE", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Scores", "SCORES", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Rushes", "RUSHES", "{0}", typeof (String))); str.AddColumn(new ReportColumn("YDr", "YDR", "{0}", typeof (String))); str.AddColumn(new ReportColumn("AvgYDr", "AVGYDR", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Tdr", "TDR", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Catches", "CATCHES", "{0}", typeof (String))); str.AddColumn(new ReportColumn("YDc", "YDC", "{0}", typeof (String))); str.AddColumn(new ReportColumn("AvgYDc", "AVGYDC", "{0}", typeof (String))); str.AddColumn(new ReportColumn("TDc", "TDC", "{0}", typeof (String))); str.AddColumn(new ReportColumn("COM", "COM", "{0}", typeof (String))); str.AddColumn(new ReportColumn("ATTEMPTS", "ATTEMPTS", "{0}", typeof (String))); str.AddColumn(new ReportColumn("YDp", "YDp", "{0}", typeof (String))); str.AddColumn(new ReportColumn("AVGYDp", "AVGYDp", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Tdp", "Tdp", "{0}", typeof (String))); str.AddColumn(new ReportColumn("INT", "INT", "{0}", typeof (String))); var dt = new DataTable(); var cols = dt.Columns; cols.Add("JERSEY", typeof (String)); cols.Add("NAME", typeof (String)); cols.Add("TEAM", typeof (String)); cols.Add("UNIT", typeof (String)); cols.Add("ROOKIEYR", typeof (String)); cols.Add("DRAFTED", typeof (String)); cols.Add("CATEGORY", typeof (String)); cols.Add("POSDESC", typeof (String)); cols.Add("ROLE", typeof (String)); cols.Add("OWNER", typeof (String)); cols.Add("AGE", typeof (String)); cols.Add("STARS", typeof (String)); cols.Add("VALUE", typeof (String)); cols.Add("SCORES", typeof (String)); cols.Add("RUSHES", typeof (String)); cols.Add("YDR", typeof (String)); cols.Add("AVGYDR", typeof (String)); cols.Add("TDR", typeof (String)); cols.Add("CATCHES", typeof (String)); cols.Add("YDC", typeof (String)); cols.Add("AVGYDC", typeof (String)); cols.Add("TDC", typeof (String)); cols.Add("COM", typeof (String)); cols.Add("ATTEMPTS", typeof (String)); cols.Add("YDp", typeof (String)); cols.Add("AVGYDp", typeof (String)); cols.Add("Tdp", typeof (String)); cols.Add("INT", typeof (String)); // Load the body foreach (NflConference c in _confList) foreach (NFLDivision d in c.DivList) foreach (NflTeam t in d.TeamList) { if (t.PlayerList == null) t.LoadPlayerUnits(); foreach (NFLPlayer p in t.PlayerList) { p.LoadPerformances(false, false, Utility.SeasonInFocus()); if (!string.IsNullOrEmpty(p.PlayerName)) { var dr = dt.NewRow(); dr["JERSEY"] = p.JerseyNo; dr["NAME"] = p.PlayerName; dr["TEAM"] = p.CurrTeam.TeamCode; dr["UNIT"] = p.Unit(); dr["ROOKIEYR"] = p.RookieYear; dr["DRAFTED"] = p.Drafted.Trim(); dr["CATEGORY"] = p.PlayerCat; dr["POSDESC"] = p.PlayerPos.Replace(",", "-"); dr["ROLE"] = p.PlayerRole; dr["OWNER"] = p.Owner; dr["AGE"] = p.PlayerAge(); dr["STARS"] = p.StarRating; dr["VALUE"] = p.Value().ToString(); dr["SCORES"] = p.Scores.ToString(); if (p.TotStats == null) { dr["RUSHES"] = "0"; dr["YDR"] = "0"; dr["AVGYDR"] = "0.0"; dr["TDR"] = "0"; dr["CATCHES"] = "0"; dr["YDC"] = "0.0"; dr["AVGYDC"] = "0"; dr["TDC"] = "0"; dr["COM"] = "0"; dr["ATTEMPTS"] = "0"; dr["YDp"] = "0"; dr["AVGYDp"] = "0.0"; dr["Tdp"] = "0"; dr["INT"] = "0"; } else { dr["RUSHES"] = p.TotStats.Rushes.ToString(); dr["YDR"] = p.TotStats.YDr.ToString(); dr["AVGYDR"] = string.Format("{0:0.0}", Utility.Average(p.TotStats.YDr, p.TotStats.Rushes)); dr["TDR"] = p.TotStats.Tdr.ToString(); dr["CATCHES"] = p.TotStats.Catches.ToString(); dr["YDC"] = p.TotStats.YDc.ToString(); dr["AVGYDC"] = string.Format("{0:0.0}", Utility.Average(p.TotStats.YDc, p.TotStats.Catches)); dr["TDC"] = p.TotStats.Tdc.ToString(); dr["COM"] = p.TotStats.Completions.ToString(); dr["ATTEMPTS"] = p.TotStats.PassAtts.ToString(); dr["YDp"] = p.TotStats.YDp.ToString(); dr["AVGYDp"] = string.Format("{0:0.0}", Utility.Average(p.TotStats.YDp, p.TotStats.Completions)); dr["Tdp"] = p.TotStats.Tdp.ToString(); dr["INT"] = p.TotStats.PassInt.ToString(); } dt.Rows.Add(dr); } } } str.LoadBody(dt); str.RenderAsCsv( "Players" ); }
private void BuildTable(SimpleTableReport str) { foreach (NflConference c in _confList) foreach (NFLDivision d in c.DivList) foreach (NflTeam t in d.TeamList) foreach (NFLPlayer p in t.PlayerList) { p.ExperiencePoints = Masters.Epm.GetEp(p.PlayerCode); var dr = str.Body.NewRow(); dr["TEAM"] = t.Name; dr["PLAYER"] = p.PlayerOut(); dr["UNIT"] = p.Unit(); dr["EP"] = p.ExperiencePoints; str.Body.Rows.Add(dr); } }
private SimpleTableReport DefineSte() { var str = new SimpleTableReport(Heading) { ColumnHeadings = true, DoRowNumbers = true }; str.AddColumn( new ReportColumn( "Team", "TEAM", "{0,-20}")); str.AddColumn( new ReportColumn( "Opp", "OPP", "{0,-20}")); str.AddColumn( new ReportColumn( "Total", "TOTAL", "{0:0.00}", typeof(decimal), tally: true, colourDelegateIn: PickTotalColourDelegate("TOT"))); str.AddColumn( new ReportColumn( "QB", "QB", "{0:0.00}", typeof(decimal), tally: true, colourDelegateIn: Simple32BgPicker)); str.AddColumn( new ReportColumn( "RB", "RB", "{0:0.00}", typeof(decimal), tally: true, colourDelegateIn: Simple32BgPicker)); str.AddColumn( new ReportColumn( "WR", "WR", "{0:0.00}", typeof(decimal), tally: true, colourDelegateIn: Simple32BgPicker)); str.AddColumn( new ReportColumn( "TE", "TE", "{0:0.00}", typeof(decimal), tally: true, colourDelegateIn: Simple32BgPicker)); str.AddColumn( new ReportColumn( "PK", "PK", "{0:0.00}", typeof(decimal), tally: true, colourDelegateIn: Simple32BgPicker)); return(str); }
public string RenderProjectedData( ArrayList playerList, string sHead, [Optional] string sortOrder, IRatePlayers scorer, IWeekMaster weekMaster) { // Output the list Utility.Announce("PlayerListing " + sHead); var r = new SimpleTableReport { ReportHeader = sHead, ReportFooter = Season, DoRowNumbers = true }; if (!string.IsNullOrEmpty(SubHeader)) { r.SubHeader = SubHeader; } /////////////////////////////////////////////////////////////// var ds = LoadProjectedData(playerList, scorer, weekMaster); // <-- projection action here /////////////////////////////////////////////////////////////// r.AddColumn(new ReportColumn("Name", "NAME", "{0,-15}")); r.AddColumn(new ReportColumn("Pos", "POS", "{0,9}")); r.AddColumn(new ReportColumn("Role", "ROLE", "{0,9}")); r.AddColumn(new ReportColumn("RookieYr", "ROOKIEYR", "{0,4}")); r.AddColumn(new ReportColumn("Team", "CURRTEAM", "{0,2}")); if (ShowOpponent) { r.AddColumn(new ReportColumn("Opp", "OPPONENT", "{0,2}")); r.AddColumn(new ReportColumn("Opp", "OPPRATE", "{0,2}")); r.AddColumn(new ReportColumn("Spread", "SPREAD", "{0,5}")); } r.AddColumn(new ReportColumn("Age", "AGE", "{0,2}")); r.AddColumn(new ReportColumn("Owner", "FT", "{0,2}")); if (LongStats) { r.AddColumn(new ReportColumn("Curr", "CURSCORES", "{0,5}")); r.AddColumn(new ReportColumn("Tot", "SCORES", "{0,5}")); r.AddColumn(new ReportColumn("Avg", "AVG", "{0:0.0}")); r.AddColumn(new ReportColumn("Inj", "INJURY", "{0,5}")); r.AddColumn(new ReportColumn("YDp", "YDP", "{0,5}")); r.AddColumn(new ReportColumn("Tdp", "TDP", "{0,5}")); r.AddColumn(new ReportColumn("YDr", "YDR", "{0,5}")); r.AddColumn(new ReportColumn("Tdr", "TDR", "{0,5}")); r.AddColumn(new ReportColumn("YDc", "YDC", "{0,5}")); r.AddColumn(new ReportColumn("TDc", "TDC", "{0,5}")); r.AddColumn(new ReportColumn("Fg", "Fg", "{0,5}")); } r.AddColumn(new ReportColumn("Points", "POINTS", "{0,5}")); r.AddColumn(new ReportColumn("PFP", "PFP", "{0,5}")); r.AddColumn(new ReportColumn("ADP", "ADP", "{0,5}")); var dt = ds.Tables[0]; dt.DefaultView.Sort = LongStats ? (string.IsNullOrEmpty(sortOrder) ? "Points DESC" : sortOrder) : "Points DESC"; r.LoadBody(dt); // just assigns the data table FileOut = string.Format("{0}{1}.htm", Utility.OutputDirectory(), sHead); r.RenderAsHtml(FileOut, true); if (RenderToCsv) { r.RenderAsCsv("Starters-" + sHead, Logger); } return(FileOut); }
private void GenerateFootNote(SimpleTableReport str) { str.FootNote = DumpFantasyPlayers() + DumpPlayerGameMetrics() + DumpLineups(); }
/// <summary> /// Make a big report then write it as CSV /// </summary> public void DumpPlayersToCsv() { // Define the simple report var when = string.Format("Week{0}-{1:0#}", Utility.CurrentSeason(), Int32.Parse(Utility.CurrentWeek()) + 1); var str = new SimpleTableReport(string.Format("Player Stats : {0}", when)); str.AddColumn(new ReportColumn("Jersey", "JERSEY", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Name", "NAME", "{0,-15}", typeof(String))); str.AddColumn(new ReportColumn("Team", "CURRTEAM", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Unit", "UNIT", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Rookie", "ROOKIEYR", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Drafted", "DRAFTED", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Category", "CATEGORY", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Pos", "POSDESC", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Role", "ROLE", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Owner", "OWNER", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Age", "AGE", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Stars", "STARS", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Value", "VALUE", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Scores", "SCORES", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Rushes", "RUSHES", "{0}", typeof(String))); str.AddColumn(new ReportColumn("YDr", "YDR", "{0}", typeof(String))); str.AddColumn(new ReportColumn("AvgYDr", "AVGYDR", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Tdr", "TDR", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Catches", "CATCHES", "{0}", typeof(String))); str.AddColumn(new ReportColumn("YDc", "YDC", "{0}", typeof(String))); str.AddColumn(new ReportColumn("AvgYDc", "AVGYDC", "{0}", typeof(String))); str.AddColumn(new ReportColumn("TDc", "TDC", "{0}", typeof(String))); str.AddColumn(new ReportColumn("COM", "COM", "{0}", typeof(String))); str.AddColumn(new ReportColumn("ATTEMPTS", "ATTEMPTS", "{0}", typeof(String))); str.AddColumn(new ReportColumn("YDp", "YDp", "{0}", typeof(String))); str.AddColumn(new ReportColumn("AVGYDp", "AVGYDp", "{0}", typeof(String))); str.AddColumn(new ReportColumn("Tdp", "Tdp", "{0}", typeof(String))); str.AddColumn(new ReportColumn("INT", "INT", "{0}", typeof(String))); var dt = new DataTable(); var cols = dt.Columns; cols.Add("JERSEY", typeof(String)); cols.Add("NAME", typeof(String)); cols.Add("TEAM", typeof(String)); cols.Add("UNIT", typeof(String)); cols.Add("ROOKIEYR", typeof(String)); cols.Add("DRAFTED", typeof(String)); cols.Add("CATEGORY", typeof(String)); cols.Add("POSDESC", typeof(String)); cols.Add("ROLE", typeof(String)); cols.Add("OWNER", typeof(String)); cols.Add("AGE", typeof(String)); cols.Add("STARS", typeof(String)); cols.Add("VALUE", typeof(String)); cols.Add("SCORES", typeof(String)); cols.Add("RUSHES", typeof(String)); cols.Add("YDR", typeof(String)); cols.Add("AVGYDR", typeof(String)); cols.Add("TDR", typeof(String)); cols.Add("CATCHES", typeof(String)); cols.Add("YDC", typeof(String)); cols.Add("AVGYDC", typeof(String)); cols.Add("TDC", typeof(String)); cols.Add("COM", typeof(String)); cols.Add("ATTEMPTS", typeof(String)); cols.Add("YDp", typeof(String)); cols.Add("AVGYDp", typeof(String)); cols.Add("Tdp", typeof(String)); cols.Add("INT", typeof(String)); // Load the body foreach (NflConference c in _confList) { foreach (NFLDivision d in c.DivList) { foreach (NflTeam t in d.TeamList) { if (t.PlayerList == null) { t.LoadPlayerUnits(); } foreach (NFLPlayer p in t.PlayerList) { p.LoadPerformances(false, false, Utility.SeasonInFocus()); if (!string.IsNullOrEmpty(p.PlayerName)) { var dr = dt.NewRow(); dr["JERSEY"] = p.JerseyNo; dr["NAME"] = p.PlayerName; dr["TEAM"] = p.CurrTeam.TeamCode; dr["UNIT"] = p.Unit(); dr["ROOKIEYR"] = p.RookieYear; dr["DRAFTED"] = p.Drafted.Trim(); dr["CATEGORY"] = p.PlayerCat; dr["POSDESC"] = p.PlayerPos.Replace(",", "-"); dr["ROLE"] = p.PlayerRole; dr["OWNER"] = p.Owner; dr["AGE"] = p.PlayerAge(); dr["STARS"] = p.StarRating; dr["VALUE"] = p.Value().ToString(); dr["SCORES"] = p.Scores.ToString(); if (p.TotStats == null) { dr["RUSHES"] = "0"; dr["YDR"] = "0"; dr["AVGYDR"] = "0.0"; dr["TDR"] = "0"; dr["CATCHES"] = "0"; dr["YDC"] = "0.0"; dr["AVGYDC"] = "0"; dr["TDC"] = "0"; dr["COM"] = "0"; dr["ATTEMPTS"] = "0"; dr["YDp"] = "0"; dr["AVGYDp"] = "0.0"; dr["Tdp"] = "0"; dr["INT"] = "0"; } else { dr["RUSHES"] = p.TotStats.Rushes.ToString(); dr["YDR"] = p.TotStats.YDr.ToString(); dr["AVGYDR"] = string.Format("{0:0.0}", Utility.Average(p.TotStats.YDr, p.TotStats.Rushes)); dr["TDR"] = p.TotStats.Tdr.ToString(); dr["CATCHES"] = p.TotStats.Catches.ToString(); dr["YDC"] = p.TotStats.YDc.ToString(); dr["AVGYDC"] = string.Format("{0:0.0}", Utility.Average(p.TotStats.YDc, p.TotStats.Catches)); dr["TDC"] = p.TotStats.Tdc.ToString(); dr["COM"] = p.TotStats.Completions.ToString(); dr["ATTEMPTS"] = p.TotStats.PassAtts.ToString(); dr["YDp"] = p.TotStats.YDp.ToString(); dr["AVGYDp"] = string.Format("{0:0.0}", Utility.Average(p.TotStats.YDp, p.TotStats.Completions)); dr["Tdp"] = p.TotStats.Tdp.ToString(); dr["INT"] = p.TotStats.PassInt.ToString(); } dt.Rows.Add(dr); } } } } } str.LoadBody(dt); str.RenderAsCsv("Players", Logger); }
public void DumpProjections() { Announce("Dumping Projections"); if (ProjectionList == null) { return; } // for each projection in the report foreach (var pl in ProjectionList) { var metricName = ( String )pl; // load the totals into a simple report var dt = new DataTable(); var cols = dt.Columns; cols.Add("TEAM", typeof(String)); cols.Add("STARTER", typeof(String)); cols.Add("TOTAL", typeof(Decimal)); cols.Add("GS", typeof(String)); cols.Add("G2", typeof(String)); foreach (NFLDivision d in Afc.DivList) { foreach (NflTeam t in d.TeamList) { foreach (NFLOutputMetric m in t.ProjectionList) { if (m.Name == metricName) { AddRow(dt, m.Total, t, metricName); break; } } } } foreach (NFLDivision d in Nfc.DivList) { foreach (NflTeam t in d.TeamList) { foreach (NFLOutputMetric m in t.ProjectionList) { if (m.Name == metricName) { AddRow(dt, m.Total, t, metricName); break; } } } } var st = new SimpleTableReport { ReportHeader = "Projected " + metricName, ColumnHeadings = true }; st.AddColumn(new ReportColumn("Team", "TEAM", "{0,-20}")); st.AddColumn(new ReportColumn("Starter", "STARTER", "{0,-20}")); st.AddColumn(new ReportColumn("Total", "TOTAL", "{0:##0}", true)); st.AddColumn(new ReportColumn("GS11", "GS", "{0,-10}")); st.AddColumn(new ReportColumn("GS3", "G2", "{0,-10}")); dt.DefaultView.Sort = "TOTAL DESC"; st.LoadBody(dt); st.ShowElapsedTime = false; st.RenderAsHtml( string.Format("{0}{2}\\Projections\\Projected-{1}.htm", Utility.OutputDirectory(), metricName, Utility.CurrentSeason()), true); } }
/// <summary> /// Looks at the EP xml to dump out a report /// </summary> public void RosterExperience() { Utility.Announce("NFLRosterReport.RosterExperience - creating simple report"); CheckPreRequisites(); var str = new SimpleTableReport(string.Format("Roster Experience {0}", Utility.CurrentSeason())); str.AddStyle( "#container { text-align: left; background-color: #ccc; margin: 0 auto; border: 1px solid #545454; width: 641px; padding:10px; font: 13px/19px Trebuchet MS, Georgia, Times New Roman, serif; }"); str.AddStyle("#main { margin-left:1em; }"); str.AddStyle("#dtStamp { font-size:0.8em; }"); str.AddStyle(".end { clear: both; }"); str.AddStyle(".gponame { color:white; background:black }"); str.ColumnHeadings = true; str.DoRowNumbers = true; str.ShowElapsedTime = false; str.IsFooter = false; str.AddColumn(new ReportColumn("Team", "TEAM", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Player", "PLAYER", "{0}", typeof (String))); str.AddColumn(new ReportColumn("Unit", "UNIT", "{0}", typeof (String))); str.AddColumn(new ReportColumn("EP", "EP", "{0}", typeof (Int32), true)); BuildTable(str); str.SetSortOrder("EP DESC"); str.RenderAsHtml( string.Format("{0}Experience-{1}-{2}.htm", Utility.OutputDirectory(), Utility.CurrentSeason(), Utility.CurrentWeek()), true); }
private static void Render( string season, string week, DataTable dt ) { var str = new SimpleTableReport { ReportHeader = "Gordan Line : Week " + week, ColumnHeadings = true, DoRowNumbers = true }; str.AddColumn( new ReportColumn( "Away Team", "AWAY", "{0,-20}" ) ); str.AddColumn( new ReportColumn( "ALR", "AWAYLETTER", "{0,-2}" ) ); str.AddColumn( new ReportColumn( "Home Team", "HOME", "{0,-20}" ) ); str.AddColumn( new ReportColumn( "HLR", "HOMELETTER", "{0,-2}" ) ); str.AddColumn( new ReportColumn( "Spread", "SPREAD", "{0:#0.0}" ) ); str.AddColumn( new ReportColumn( "GordLine", "GLINE", "{0:#0.0}" ) ); str.AddColumn(new ReportColumn("MyTip", "MYTIP", "{0:#0.0}")); str.AddColumn(new ReportColumn("Diff", "DIFF", "{0:#0.0}")); str.AddColumn( new ReportColumn( "AwSR", "ASR", "{0}" ) ); str.AddColumn( new ReportColumn( "HmSR", "HSR", "{0}" ) ); str.AddColumn( new ReportColumn( "Bet", "BET", "{0,-20}" ) ); str.AddColumn( new ReportColumn( "Away", "AWAYSCORE", "{0}" ) ); str.AddColumn( new ReportColumn( "Home", "HOMESCORE", "{0}" ) ); str.AddColumn( new ReportColumn( "Result", "RESULT", "{0}" ) ); str.AddColumn( new ReportColumn( "Adjustment", "ADJUST", "{0}" ) ); str.LoadBody( dt ); str.RenderAsHtml( string.Format("{0}GordanLine{1}{2}.htm", Utility.OutputDirectory(), season, week), true ); }
public string RenderData( ArrayList playerList, string sHead, [Optional] string sortOrder, IRatePlayers scorer) { // Output the list Utility.Announce("PlayerListing " + sHead); var r = new SimpleTableReport { ReportHeader = sHead, DoRowNumbers = true }; if (!string.IsNullOrEmpty(SubHeader)) { r.SubHeader = SubHeader; } var ds = LoadData(playerList, scorer); // <--action r.AddColumn(new ReportColumn("Name", "NAME", "{0,-15}")); r.AddColumn(new ReportColumn("Pos", "POS", "{0,9}")); r.AddColumn(new ReportColumn("Role", "ROLE", "{0,9}")); r.AddColumn(new ReportColumn("RookieYr", "ROOKIEYR", "{0,4}")); r.AddColumn(new ReportColumn("Team", "CURRTEAM", "{0,2}")); r.AddColumn(new ReportColumn("Age", "AGE", "{0,2}")); r.AddColumn(new ReportColumn("Owner", "FT", "{0,2}")); if (LongStats) { r.AddColumn(new ReportColumn("Curr", "CURSCORES", "{0,5}")); r.AddColumn(new ReportColumn("Tot", "SCORES", "{0,5}")); r.AddColumn(new ReportColumn("Avg", "AVG", "{0:0.0}")); r.AddColumn(new ReportColumn("Inj", "INJURY", "{0,5}")); r.AddColumn(new ReportColumn("YDp", "YDP", "{0,5}")); r.AddColumn(new ReportColumn("Tdp", "TDP", "{0,5}")); r.AddColumn(new ReportColumn("YDr", "YDR", "{0,5}")); r.AddColumn(new ReportColumn("Tdr", "TDR", "{0,5}")); r.AddColumn(new ReportColumn("YDc", "YDC", "{0,5}")); r.AddColumn(new ReportColumn("TDc", "TDC", "{0,5}")); r.AddColumn(new ReportColumn("Fg", "Fg", "{0,5}")); } r.AddColumn(new ReportColumn("Points", "POINTS", "{0,5}")); var dt = ds.Tables[0]; dt.DefaultView.Sort = LongStats ? (string.IsNullOrEmpty(sortOrder) ? "Points DESC" : sortOrder) : "Points DESC"; r.LoadBody(dt); if (string.IsNullOrEmpty(FileOut)) { FileOut = $@"{ Utility.OutputDirectory() }//{ Utility.CurrentSeason() }//{ sHead }.htm" ; } r.RenderAsHtml(fileName: FileOut, persist: true); if (RenderToCsv) { r.RenderAsCsv("Starters-" + sHead, Logger); } return(FileOut); }
public void Render(SimpleTableReport r, string header) { r.LoadBody(Data); r.RenderAsHtml(FileOut, persist: true); }
/// <summary> /// Renders the Matrix as HTML. /// </summary> /// <param name="header1">The header.</param> /// <param name="defence">if set to <c>true</c> [defence].</param> /// <param name="offence">if set to <c>true</c> [offence].</param> /// <param name="persist">if set to <c>true</c> [persist].</param> /// <param name="showRank">if set to <c>true</c> [show rank].</param> /// <returns></returns> public string RenderAsHtml(string header1, bool defence, bool offence, bool persist, bool showRank) { // load table _dt.Clear(); if (offence) { LoadWeeks(KUnitNamePassingOffence, PoExp); // for debug show multiplier LoadMultiplier("PD multiplier", PoExp); LoadMetric("Tdp", PoExp); LoadWeeks(KUnitNameRushingOffence, RoExp); LoadMultiplier("RD multiplier", RoExp); LoadMetric("Tdr", RoExp); LoadWeeks(KUnitNamePassProtection, PpExp); LoadMultiplier("PR multiplier", PpExp); LoadMetric("SAK allowed", PpExp); } if (defence) { LoadWeeks(KUnitNamePassRush, PrExp); LoadMultiplier("PP multiplier", PrExp); LoadMetric("SAK", PrExp); LoadWeeks(KUnitNameRushingDefence, RdExp); LoadMultiplier("RO multiplier", RdExp); LoadMetric("Tdr", RdExp); LoadWeeks(KUnitNamePassingDefence, PdExp); LoadMultiplier("PO multiplier", PdExp); LoadMetric("Tdp", PdExp); } if (defence && offence) { TotalLine(); } St = new SimpleTableReport("Unit Matrix " + Team.TeamCode, "") { ColumnHeadings = true }; St.AddColumn(new ReportColumn(header1, "UnitName", "{0}")); St.AddColumn(new ReportColumn("01<br>" + _opponent[0], "Week01", "{0:#0.0}")); St.AddColumn(new ReportColumn("02<br>" + _opponent[1], "Week02", "{0:#0.0}")); St.AddColumn(new ReportColumn("03<br>" + _opponent[2], "Week03", "{0:#0.0}")); St.AddColumn(new ReportColumn("04<br>" + _opponent[3], "Week04", "{0:#0.0}")); St.AddColumn(new ReportColumn("05<br>" + _opponent[4], "Week05", "{0:#0.0}")); St.AddColumn(new ReportColumn("06<br>" + _opponent[5], "Week06", "{0:#0.0}")); St.AddColumn(new ReportColumn("07<br>" + _opponent[6], "Week07", "{0:#0.0}")); St.AddColumn(new ReportColumn("08<br>" + _opponent[7], "Week08", "{0:#0.0}")); St.AddColumn(new ReportColumn("09<br>" + _opponent[8], "Week09", "{0:#0.0}")); St.AddColumn(new ReportColumn("10<br>" + _opponent[9], "Week10", "{0:#0.0}")); St.AddColumn(new ReportColumn("11<br>" + _opponent[10], "Week11", "{0:#0.0}")); St.AddColumn(new ReportColumn("12<br>" + _opponent[11], "Week12", "{0:#0.0}")); St.AddColumn(new ReportColumn("13<br>" + _opponent[12], "Week13", "{0:#0.0}")); St.AddColumn(new ReportColumn("14<br>" + _opponent[13], "Week14", "{0:#0.0}")); St.AddColumn(new ReportColumn("15<br>" + _opponent[14], "Week15", "{0:#0.0}")); St.AddColumn(new ReportColumn("16<br>" + _opponent[15], "Week16", "{0:#0.0}")); St.AddColumn(new ReportColumn("17<br>" + _opponent[16], "Week17", "{0:#0.0}")); St.AddColumn(new ReportColumn("18<br>" + _opponent[16], "Week18", "{0:#0.0}")); St.AddColumn(new ReportColumn("19<br>" + _opponent[16], "Week18", "{0:#0.0}")); St.AddColumn(new ReportColumn("20<br>" + _opponent[16], "Week18", "{0:#0.0}")); St.AddColumn(new ReportColumn("21<br>" + _opponent[16], "Week18", "{0:#0.0}")); St.AddColumn(new ReportColumn("Tot", "TOTAL", "{0:#0.0}")); if (showRank) { St.AddColumn(new ReportColumn("Rank", "RANK", "{0}")); } St.LoadBody(_dt); St.DoRowNumbers = false; St.ShowElapsedTime = false; if (persist) { St.RenderAsHtml( string.Format("{0}Experience Points\\unitMatrix\\Unit_{1}.htm", Utility.OutputDirectory(), Team.TeamCode), true); } return(St.BodyOut()); }