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 TestBetListAddedToDatabase() { List <HorseBet> test = new List <HorseBet>(); test.Add(new HorseBet("Aintree", new DateTime(2017, 5, 12), 11.58m, true, 1)); ReadWriteToSQLite writer = new ReadWriteToSQLite(); writer.InsertListOfBets(test); List <HorseBet> retrievedBet = new List <HorseBet>(); retrievedBet = ReadWriteToSQLite.RetrieveHorseBetsFromDB(); Assert.AreEqual(test[0].CourseID, retrievedBet[0].CourseID); Assert.AreEqual(test[0].BetAmount, retrievedBet[0].BetAmount); Assert.AreEqual(test[0].BetResult, retrievedBet[0].BetResult); Assert.AreEqual(test[0].RaceDate, retrievedBet[0].RaceDate); Assert.AreEqual(test.Count(), retrievedBet.Count()); }