public async Task InsertTest()
{
var skierId = (await SkierDao.FindAllAsync()).First().Id;
var raceId = (await RaceDao.FindAllAsync()).First().Id;
var newSkierId = await SkierDao.InsertGetIdAsync(new Skier
{
Retired = false,
CountryId = (await CountryDao.FindAllAsync()).First().Id,
FirstName = "ABC",
LastName = "DEF",
GenderId = 1,
DateOfBirth = DateTime.Now
});
await StartListDao.InsertAsync(new StartList
{
SkierId = newSkierId.Value,
RaceId = raceId,
StartNumber = 99,
StartStateId = (int)Domain.Enums.RaceState.Finished
});
var startList = await StartListDao.FindByIdAsync(skierId, raceId);
Assert.AreEqual(skierId, startList.SkierId);
Assert.AreEqual(raceId, startList.RaceId);
Assert.AreEqual((int)Domain.Enums.RaceState.Finished, startList.StartStateId);
Assert.NotNull(startList.Skier);
Assert.NotNull(startList.StartState);
Assert.NotNull(startList.Race);
}
public async Task FindAvailableSkiersForRaceTest()
{
var skier = (await SkierDao.FindAllAsync()).First();
var race = (await RaceDao.FindAllAsync()).First();
var availableSkiers = await SkierDao.FindAvailableSkiersForRace(race.Id);
Assert.IsTrue(availableSkiers.All(s => s.Id != skier.Id));
var newSkierId = await SkierDao.InsertGetIdAsync(new Skier
{
Retired = false,
FirstName = "xy",
LastName = "z",
CountryId = (await CountryDao.FindAllAsync()).First().Id,
GenderId = race.GenderId,
DateOfBirth = DateTime.Today
});
availableSkiers = await SkierDao.FindAvailableSkiersForRace(race.Id);
Assert.IsTrue(availableSkiers.All(s => s.Id != newSkierId.Value));
var newSkier = await SkierDao.FindByIdAsync(newSkierId.Value);
newSkier.GenderId = newSkier.GenderId == 1 ? 2 : 1;
await SkierDao.UpdateAsync(newSkier);
availableSkiers = await SkierDao.FindAvailableSkiersForRace(race.Id);
Assert.IsFalse(availableSkiers.Any(s => s.Id != newSkierId.Value));
}
public async Task InsertTest()
{
var countryId = (await CountryDao.FindAllAsync()).First().Id;
var skierId = await SkierDao.InsertGetIdAsync(new Skier
{
CountryId = countryId,
FirstName = "Test",
LastName = "pacito",
GenderId = (int)Domain.Enums.Gender.Male,
DateOfBirth = new DateTime(1969, 4, 20)
});
var skier = await SkierDao.FindByIdAsync(skierId.Value);
Assert.AreEqual(countryId, skier.CountryId);
Assert.AreEqual("Test", skier.FirstName);
Assert.AreEqual("pacito", skier.LastName);
Assert.AreEqual((int)Domain.Enums.Gender.Male, skier.GenderId);
Assert.AreEqual(new DateTime(1969, 4, 20), skier.DateOfBirth);
Assert.NotNull(skier.Country);
Assert.NotNull(skier.Gender);
}
public async Task GetRemainingStartListForRaceTest()
{
var race = (await RaceDao.FindAllAsync()).First();
Assert.AreEqual(0, (await StartListDao.GetRemainingStartListForRace(race.Id)).Count());
var skierId = await SkierDao.InsertGetIdAsync(new Skier
{
Retired = false,
FirstName = "F",
LastName = "S",
CountryId = (await CountryDao.FindAllAsync()).First().Id,
GenderId = race.GenderId,
DateOfBirth = DateTime.Now
});
await StartListDao.InsertAsync(new StartList
{
RaceId = race.Id, SkierId = skierId.Value, StartNumber = 99, StartStateId = (int)StartState.Upcoming
});
Assert.AreEqual(1, (await StartListDao.GetRemainingStartListForRace(race.Id)).Count());
}
