public void StorePrediction(string method, NFLGame game, NFLResult result) { // Validate prediction if (!result.IsValid()) { Utility.Announce("Invalid prediction - " + game.GameName()); } // See if we have this prediction already var ds = Utility.TflWs.GetPrediction(method, game.Season, game.Week, game.GameCode); if (ds.Tables[0].Rows.Count == 1) { // if yes just update Utility.TflWs.UpdatePrediction( method, game.Season, game.Week, game.GameCode, result.HomeScore, result.AwayScore, result.HomeTDp, result.HomeTDr, result.HomeTDd, result.HomeTDs, result.HomeFg, result.AwayTDp, result.AwayTDr, result.AwayTDd, result.AwayTDs, result.AwayFg, result.HomeYDp, result.HomeYDr, result.AwayYDp, result.AwayYDr ); } else { // otherwise insert Utility.TflWs.InsertPrediction( method, game.Season, game.Week, game.GameCode, result.HomeScore, result.AwayScore, result.HomeTDp, result.HomeTDr, result.HomeTDd, result.HomeTDs, result.HomeFg, result.AwayTDp, result.AwayTDr, result.AwayTDd, result.AwayTDs, result.AwayFg, result.HomeYDp, result.HomeYDr, result.AwayYDp, result.AwayYDr ); } }
public void StorePrediction(string method, NFLGame game, NFLResult result) { // Validate prediction if ( !result.IsValid() ) Utility.Announce( "Invalid prediction - " + game.GameName() ); // See if we have this prediction already var ds = Utility.TflWs.GetPrediction(method, game.Season, game.Week, game.GameCode); if (ds.Tables[0].Rows.Count == 1) // if yes just update Utility.TflWs.UpdatePrediction( method, game.Season, game.Week, game.GameCode, result.HomeScore, result.AwayScore, result.HomeTDp, result.HomeTDr, result.HomeTDd, result.HomeTDs, result.HomeFg, result.AwayTDp, result.AwayTDr, result.AwayTDd, result.AwayTDs, result.AwayFg, result.HomeYDp, result.HomeYDr, result.AwayYDp, result.AwayYDr ); else // otherwise insert Utility.TflWs.InsertPrediction( method, game.Season, game.Week, game.GameCode, result.HomeScore, result.AwayScore, result.HomeTDp, result.HomeTDr, result.HomeTDd, result.HomeTDs, result.HomeFg, result.AwayTDp, result.AwayTDr, result.AwayTDd, result.AwayTDs, result.AwayFg, result.HomeYDp, result.HomeYDr, result.AwayYDp, result.AwayYDr ); }
public void TestMarginForTeam() { var result = new NFLResult("SF", 30, "GB", 22); Assert.AreEqual(8, result.MarginForTeam("SF"), "SF margin should be +8"); Assert.AreEqual(-8, result.MarginForTeam("GB"), "GB margin should be -8"); }
public void TestAtsResultTie() { var prediction = new NFLResult { HomeTeam = "IC", AwayTeam = "MV", AwayScore = 22, HomeScore = 21 }; var game = new NFLGame("2012:02-E"); // BR @ PE var atsResult = game.EvaluatePredictionAts(prediction, game.Spread); Assert.AreEqual("ATS:PUSH", atsResult); }
public void TestResultIsValid() { var sut = new NFLResult(home: "BB", homePts: 20, away: "NE", awayPts: 31); sut.AwayFg = 1; sut.AwayTDr = 2; sut.AwayTDp = 2; sut.HomeTDp = 1; sut.HomeTDd = 1; sut.HomeFg = 2; var isValid = sut.IsValid(); Assert.IsTrue(isValid); }
public void TestDbfPredictionStorer() { var game = new NFLGame("2006:02-A"); // BB @ MD var result = new NFLResult("MD", 24, "BB", 20); result.HomeYDp = 250; result.HomeYDr = 116; result.AwayYDp = 350; result.AwayYDr = 68; result.AwayTDr = 1; var storer = new DbfPredictionStorer(); storer.StorePrediction("test", game, result); var getter = new DbfPredictionQueryMaster(); var prediction = getter.Get("test", "2006", "02", "A"); Assert.IsTrue(prediction.HomeScore.Equals(24), "Home score should be 24"); Assert.IsTrue(prediction.AwayScore.Equals(20), "Away score should be 20"); Assert.IsTrue(prediction.NflResult.AwayTDr.Equals(1), "Away TDr should be 1"); Assert.IsTrue(prediction.NflResult.AwayYDr.Equals(68), "Away YDr should be 68"); }
public void StorePrediction(string method, NFLGame game, NFLResult result) { // Validate prediction if (!result.IsValid()) { Utility.Announce("Invalid prediction - " + game.GameName()); } // See if we have this prediction already var ds = Utility.TflWs.GetPrediction(method, game.Season, game.Week, game.GameCode); if (ds.Tables[0].Rows.Count == 1) { // if yes just update Utility.TflWs.UpdatePrediction( method, game.Season, game.Week, game.GameCode, result.HomeScore, result.AwayScore, result.HomeTDp, result.HomeTDr, result.HomeTDd, result.HomeTDs, result.HomeFg, result.AwayTDp, result.AwayTDr, result.AwayTDd, result.AwayTDs, result.AwayFg, result.HomeYDp, result.HomeYDr, result.AwayYDp, result.AwayYDr ); } else { // otherwise insert Utility.TflWs.InsertPrediction( method, game.Season, game.Week, game.GameCode, result.HomeScore, result.AwayScore, result.HomeTDp, result.HomeTDr, result.HomeTDd, result.HomeTDs, result.HomeFg, result.AwayTDp, result.AwayTDr, result.AwayTDd, result.AwayTDs, result.AwayFg, result.HomeYDp, result.HomeYDr, result.AwayYDp, result.AwayYDr ); } //TODO: this stuffs up the scores if using the Miller predictions //// also update Game projections (used by Starters()) //Utility.TflWs.StoreResult(game.Season, game.Week, game.GameCode, result.AwayScore, result.HomeScore, result.HomeTDp, // result.AwayTDp, result.HomeTDr, result.AwayTDr, result.HomeFg, result.AwayFg, // result.AwayTDd, result.HomeTDd, result.AwayTDs, result.HomeTDs); }
public void StorePrediction(string method, NFLGame game, NFLResult result) { }
public void StorePrediction( string method, NFLGame game, NFLResult result ) { }