public void Import()
{
if (!adoStartListDao.FindAll().Any())
{
GenerateStartLists();
foreach (var startList in StartLists)
{
adoStartListDao.Insert(startList);
// Console.WriteLine($"Inserting worked: {adoStartListDao.Insert(startList)} for: {startList}");
}
}
}
public void InsertTest()
{
var startlist = new StartListMember
{
Race = new Race {
Id = 14
},
SkierId = 44,
StartPos = 2,
RunNo = 1
};
Assert.True(startlistDao.Insert(startlist) > 0);
}
public async Task <bool> InsertStartListMember(int raceId, int skierId, int runNo, int startPosition)
{
return(await Task.Run(() =>
{
var startListAdo = new AdoStartListDao(connectionFactory);
var raceDataAdo = new AdoRaceDataDao(connectionFactory);
var oldRaceData = raceDataAdo.FindAllBySkierId(skierId).FirstOrDefault(rd => rd.RaceId == raceId);
if (oldRaceData != null)
{
raceDataAdo.Delete(oldRaceData);
}
var newRaceData = new RaceData()
{
RaceId = raceId,
SkierId = skierId,
Blocked = true,
Disqualified = false,
Finished = false,
Running = false
};
if (raceDataAdo.Insert(newRaceData) == 0)
{
return false;
}
var race = new Race
{
Id = raceId
};
var startListMember = new StartListMember
{
Race = race,
SkierId = skierId,
RunNo = runNo,
StartPos = startPosition
};
return startListAdo.Insert(startListMember) != 0;
}));
}
