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