public string UpdateAveragesAndScores( SqlDatabase db, DateTime when )
{
string result = "Successfully updated scores and averages";
DbConnection conn = db.CreateConnection();
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
db.ExecuteNonQuery( "spSetCurrentScore", when );
db.ExecuteNonQuery( "spRecalcPlayerAverages" );
trans.Commit();
}
catch( Exception e )
{
result = "Failed to update scores and averages: " + e.Message;
trans.Rollback();
}
conn.Close();
return result;
}
public ArrayList SavePerformances( SqlDatabase db, ArrayList perfs, DateTime when )
{
ArrayList problems = new ArrayList();
DbConnection conn = db.CreateConnection();
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
foreach( PlayerPerformance p in perfs )
{
DbCommand cmd = db.GetStoredProcCommand( "spAddPlayerPerformance",
when, p.FirstName, p.LastName, p.TeamName, p.Minutes, p.Assists, p.Blocks,
p.DefensiveRebounds, p.Fouls, p.FTAttempts, p.FTsMade, p.OffensiveRebounds,
p.PlusMinus, p.ShotAttempts, p.ShotsMade, p.Steals, p.ThreeAttempts,
p.ThreesMade, p.Turnovers, p.NBAId );
int x = (int)db.ExecuteScalar( cmd, trans );
if( x != 0 )
{
problems.Add( p );
}
}
trans.Commit();
}
catch( Exception e )
{
trans.Rollback();
PlayerPerformance p = new PlayerPerformance();
p.FirstName = "Exception thrown while saving results to db: " + e.Message;
problems.Add( p );
}
conn.Close();
return problems;
}