public void TestInsertNewHorseBet()
{
ReadWriteToSQLite dataWriter = new ReadWriteToSQLite();
List <HorseBet> beforeList = ReadWriteToSQLite.RetrieveHorseBetsFromDB();
dataWriter.InsertNewBet(3, new DateTime(2018, 2, 25), true, 25.00M);
List <HorseBet> afterList = ReadWriteToSQLite.RetrieveHorseBetsFromDB();
Assert.AreEqual(afterList.Count, beforeList.Count + 1);
}
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());
}