public HotTipsterMenu()
{
InitializeComponent();
ReadWriteToSQLite sqldb = new ReadWriteToSQLite();
HistoricDataReader reader = new HistoricDataReader(); // @"C:\Users\carra\Documents\HotTipster\HotTipsHistoricData.txt"); //Replace with directory ref?
if (!File.Exists(Directory.GetCurrentDirectory() + Path.DirectorySeparatorChar + "HotTipster.db"))
{
sqldb.CreateDatabase();
sqldb.InsertExistingRaceCoursesIntoDB();
//sqldb.InsertListOfBets(reader.ListOfHistoricHorseBetsOriginal());
sqldb.InsertListOfBets(HorseBet.AddCourseIDToHistoricBetData());
}
}
public void AddCourseIDToHistoricBetData()
{
List <HorseBet> bets;
ReadWriteToSQLite dataWriter = new ReadWriteToSQLite();
dataWriter.CreateDatabase();
dataWriter.InsertExistingRaceCoursesIntoDB();
bets = HorseBet.AddCourseIDToHistoricBetData();
HorseBet test = new HorseBet("Aintree", new DateTime(2017, 5, 12), 11.58m, true, 0);
//CollectionAssert.Contains(bets, test);
Assert.IsTrue(bets.Any(bet => bet.CourseID == 1));
Assert.IsTrue(bets.Any(bet => bet.CourseID == 6));
Assert.IsTrue(bets.Any(bet => bet.CourseID == 13));
Assert.IsTrue(bets.Any(bet => bet.CourseID == 18));
Assert.IsFalse(bets.Any(bet => bet.CourseID == 20));
}
