private List <Result> GetResults100m(string competition)
        {
            DatabaseApi.SelectCompetition100m(competition);
            var settings      = SettingsHelper.GetSettings();
            var rawResults    = DatabaseApi.LoadCompetitionFromTable(TableName.OrionResult);
            var actualResults = this.AddNewResults(rawResults.OfType <OrionResult>().ToList(), settings);

            return(BuildResultObjects(actualResults));
        }
        private List <Registration> GetRegistrations100m(string competition)
        {
            DatabaseApi.SelectCompetition100m(competition);
            var rawResults = DatabaseApi.LoadCompetitionFromTable(TableName.LeonRegistration);
            var actualRegs = this.AddNewRegistrations(rawResults.OfType <LeonPerson>().ToList());
            var results    = this.GetResults100m(competition);

            foreach (var result in results)
            {
                var reg = actualRegs.SingleOrDefault(r => r.ShooterId == result.ShooterId);
                if (reg != null)
                {
                    reg.Result = result;
                }
            }

            return(actualRegs);
        }