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