protected string Autosub( string weekId, SqlDatabase db, DateTime selectedDate )
{
string result = AutoSub.ProcessAutosubs( weekId );
StatGrabber.StatGrabber sg = new StatGrabber.StatGrabber();
result += sg.UpdateAveragesAndScores( db, selectedDate );
return result;
}
protected void btnProcessManualBox_Click( object sender, EventArgs e )
{
StatGrabber.StatGrabber sg = new StatGrabber.StatGrabber();
SqlDatabase db = new SqlDatabase( System.Configuration.ConfigurationManager.AppSettings["ConnectionString"] );
ArrayList problems = new ArrayList();
try
{
ArrayList perfs = sg.GetGamePerformances( tbManualBoxURL.Text, problems );
tbOutput.Text += "Got " + perfs.Count + " perfs from " + tbManualBoxURL.Text + "\r\n";
problems.AddRange( sg.SavePerformances( db, perfs, calStatDate.SelectedDate ) );
}
catch( StatGrabber.StatGrabberException ex )
{
tbOutput.Text += ex.Message;
}
if( problems.Count > 0 )
{
tbOutput.Text += "Problems:\r\n";
foreach( StatGrabber.PlayerPerformance p in problems )
{
tbOutput.Text += p.FirstName + " " + p.LastName + " " + p.TeamName + "\r\n";
}
}
else
{
tbOutput.Text += "No problems identifying players\r\n";
}
tbOutput.Text += sg.UpdateAveragesAndScores( db, calStatDate.SelectedDate );
Log.AddLogEntry(
LogEntryTypes.StatsProcessed,
Page.User.Identity.Name,
tbOutput.Text );
}
protected void ButtonProcessDaily_Click(object sender, System.EventArgs e)
{
tbScrapeResults.Text += "\r\n" + calStatDate.SelectedDate.ToString() + "\r\n";
StatGrabber.StatGrabber sg = new StatGrabber.StatGrabber();
ArrayList urls = sg.GetGames( calStatDate.SelectedDate );
tbScrapeResults.Text += "Ran GetGames, got back " + urls.Count + " games\r\n";
ArrayList problems = null;
ArrayList performances = null;
if( urls.Count > 0 )
{
try
{
performances = sg.GetPerformances( urls );
tbScrapeResults.Text += "Ran GetPerformances, got back " + performances.Count + " perfs\r\n";
if( performances.Count > 0 )
{
SqlConnection con = new SqlConnection( System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"] );
problems = sg.SavePerformances( con, performances, calStatDate.SelectedDate );
tbScrapeResults.Text += "Ran SavePerformances, got back " + problems.Count + " problems\r\n";
foreach( PlayerPerformance p in problems )
{
tbScrapeResults.Text += p.FirstName + " " + p.LastName + " " + p.TeamName + "\r\n";
}
}
}
catch( StatGrabberException ex )
{
tbScrapeResults.Text += "StatGrabber threw: "
+ ex.Message;
}
}
Log.AddLogEntry(
LogEntryTypes.StatsProcessed,
Page.User.Identity.Name,
"Processed stats for "
+ calStatDate.SelectedDate.ToString()
+ ", found "
+ urls.Count
+ " games, "
+ ( performances == null ? -1 : performances.Count )
+ " perfs, "
+ ( problems == null ? -1 : problems.Count )
+ " problems" );
}
protected void ButtonProcessDaily_Click(object sender, System.EventArgs e)
{
tbOutput.Text += "\r\nScraping " + calStatDate.SelectedDate.ToString() + "\r\n";
StatGrabber.StatGrabber sg = new StatGrabber.StatGrabber();
ArrayList urls = sg.GetGames( this.calStatDate.SelectedDate );
tbOutput.Text += "Found " + urls.Count + " games\r\n";
SqlDatabase db = new SqlDatabase( System.Configuration.ConfigurationManager.AppSettings["ConnectionString"] );
ArrayList problems = new ArrayList();
foreach( string url in urls )
{
try
{
ArrayList perfs = sg.GetGamePerformances( url );
tbOutput.Text += "Got " + perfs.Count + " perfs from " + url + "\r\n";
problems.AddRange( sg.SavePerformances( db, perfs, calStatDate.SelectedDate ) );
}
catch( StatGrabber.StatGrabberException ex )
{
tbOutput.Text += ex.Message;
}
}
if( problems.Count > 0 )
{
tbOutput.Text += "\r\nFound the following problems:\r\n";
foreach( StatGrabber.PlayerPerformance p in problems )
{
tbOutput.Text += p.FirstName + " " + p.LastName + " " + p.TeamName + "\r\n";
}
}
else
{
tbOutput.Text += "\r\nNo problems identifying players\r\n";
}
tbOutput.Text += "\r\n";
tbOutput.Text += sg.UpdateAveragesAndScores( db, calStatDate.SelectedDate );
Log.AddLogEntry(
LogEntryTypes.StatsProcessed,
Page.User.Identity.Name,
tbOutput.Text );
}
