public void Repo_YearStats_Tests()
{
YearStats toInsert = CreateExtensions.DummyYearStats();
// Insert the year stats
repoLayer.InsertYearStats(connection, toInsert);
// Edit and re-insert.
toInsert.MemStickPlayerLoanTotal = 1000;
toInsert.Year = 2017;
repoLayer.InsertYearStats(connection, toInsert);
// Check the results
List <YearStats> results = repoLayer.GetYearStats(connection);
Assert.AreEqual(2, results.Count);
Assert.AreEqual(CreateExtensions.DummyYearStats().Serialize(), results[0].Serialize());
Assert.AreEqual(toInsert.Serialize(), results[1].Serialize());
// Update one of the listeners
results[1].AvListeners = 19;
YearStats updated = results[1];
repoLayer.UpdateYearStats(connection, updated);
// Check the results
results = repoLayer.GetYearStats(connection);
Assert.AreEqual(2, results.Count);
Assert.AreEqual(CreateExtensions.DummyYearStats().Serialize(), results[0].Serialize());
Assert.AreEqual(updated.Serialize(), results[1].Serialize());
// Delete a listener
repoLayer.DeleteYearStats(connection, results[1]);
// Check the results
results = repoLayer.GetYearStats(connection);
Assert.AreEqual(1, results.Count);
Assert.AreEqual(CreateExtensions.DummyYearStats().Serialize(), results[0].Serialize());
}
