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