public StartListController(ILogger <StartListController> logger) { _logger = logger; var connectionFactory = ConnectionFactoryHolder.getInstace().getConnectionFactory(); _adoStartListDao = new AdoStartListDao(connectionFactory); _adoRaceDataDao = new AdoRaceDataDao(connectionFactory); _adoSkierDao = new AdoSkierDao(connectionFactory); }
public async Task <ICollection <SkierModel> > GetAllSkiersWithSameSex(string sex) { return(await Task.Run(() => { IEnumerable <Skier> allSkiers = new AdoSkierDao(connectionFactory).FindAll(); IEnumerable <Skier> allSkiersWithSameSex = allSkiers.Where(skier => skier.Sex == sex); var allSkierModelsWithSameSex = new ObservableCollection <SkierModel>(); foreach (var skierWithSameSex in allSkiersWithSameSex) { allSkierModelsWithSameSex.Add(new SkierModel(skierWithSameSex)); } return allSkierModelsWithSameSex; })); }
public async Task <StartListModel> GetStartListForRaceId(int raceId, int runNo) { return(await Task.Run(() => { StartList = new StartListModel(); StartList.raceId = raceId; StartList.StartListMembers = new ObservableCollection <StartListMemberModel>(); IEnumerable <Skier> skiers = new AdoSkierDao(connectionFactory).FindAll(); IEnumerable <RaceData> racedata = new AdoRaceDataDao(connectionFactory).FindAllByRaceId(raceId); if (skiers == null) { throw new NullReferenceException("No skiers found"); } IEnumerable <StartListMember> startListMembers = new AdoStartListDao(connectionFactory) .FindAllByRaceIdAndRunNo(raceId, runNo) .OrderBy(startListMember => startListMember.StartPos); foreach (var startListMember in startListMembers) { var skierdata = racedata.FirstOrDefault(data => data.SkierId == startListMember.SkierId); StartList.StartListMembers.Add( new StartListMemberModel() { Skier = new SkierModel(skiers.FirstOrDefault(skier => skier.Id == startListMember.SkierId)), Startposition = startListMember.StartPos, RunNo = startListMember.RunNo, Blocked = skierdata != null && skierdata.Blocked, Disqualified = skierdata != null && skierdata.Disqualified, Finished = skierdata != null && skierdata.Finished, Running = skierdata != null && skierdata.Running, RaceDataId = skierdata?.Id ?? 0 } ); } return StartList; })); }
public StartListsImporter(IConnectionFactory connectionFactory) { adoRaceDao = new AdoRaceDao(connectionFactory); adoSkierDao = new AdoSkierDao(connectionFactory); adoStartListDao = new AdoStartListDao(connectionFactory); }
public void Setup() { configuration = ConfigurationUtil.GetConfiguration(); connectionFactory = DefaultConnectionFactory.FromConfiguration(configuration, "HuraceDbConnection"); skierDao = new AdoSkierDao(connectionFactory); }
public SkierController(ILogger <SkierController> logger) { _logger = logger; _adoSkierDao = new AdoSkierDao(ConnectionFactoryHolder.getInstace().getConnectionFactory()); }