コード例 #1
0
        /// <summary>
        /// Gets a random age.
        /// </summary>
        /// <param name="ageGroup">The (optional) age group.</param>
        /// <returns>An integer within the specified age group range.</returns>
        public static int RandomAge(AgeGroup ageGroup = AgeGroup.Any)
        {
            const int maximumAge = 120;
            const int minimumAge = 0;

            switch (ageGroup)
            {
            case AgeGroup.Any:
                return(RandomInteger(minimumAge, maximumAge));

            case AgeGroup.Infant:
                return(RandomInteger(minimumAge, 1));

            case AgeGroup.Toddler:
                return(RandomInteger(1, 3));

            case AgeGroup.Preschooler:
                return(RandomInteger(3, 5));

            case AgeGroup.Gradeschooler:
                return(RandomInteger(5, 12));

            case AgeGroup.Teen:
                return(RandomInteger(12, 18));

            case AgeGroup.Adult:
                return(RandomInteger(18, maximumAge));

            case AgeGroup.Senior:
                return(RandomInteger(65, maximumAge));

            default:
                return(RandomInteger(minimumAge, maximumAge));
            }
        }
コード例 #2
0
        private decimal GetAgeMultiplier(AgeGroup ageGroup)
        {
            decimal factor;

            switch (ageGroup)
            {
            case AgeGroup.LessThanTwenty:
                factor = 0.01m;
                break;

            case AgeGroup.TwentyOneToForty:
                factor = 0.03m;
                break;

            case AgeGroup.FortyOneToSixty:
                factor = 0.05m;
                break;

            case AgeGroup.AboveSixty:
            default:
                factor = 0.08m;
                break;
            }

            return(factor);
        }
コード例 #3
0
        public async Task <IActionResult> Edit(int id, [Bind("Id,AgeGroupName")] AgeGroup ageGroup)
        {
            if (id != ageGroup.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(ageGroup);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!AgeGroupExists(ageGroup.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(ageGroup));
        }
コード例 #4
0
ファイル: UrlHelper.cs プロジェクト: rnrbrste/stravadotnet
        /// <summary>
        ///  AgeGroup to string
        /// </summary>
        /// <param name="age"></param>
        /// <returns></returns>
        public static string AgeGroupToString(AgeGroup age)
        {
            String ageFilter = String.Empty;

            switch (age)
            {
                case AgeGroup.One:
                    ageFilter = "0_24";
                    break;
                case AgeGroup.Two:
                    ageFilter = "25_34";
                    break;
                case AgeGroup.Three:
                    ageFilter = "35_44";
                    break;
                case AgeGroup.Four:
                    ageFilter = "45_54";
                    break;
                case AgeGroup.Five:
                    ageFilter = "55_64";
                    break;
                case AgeGroup.Six:
                    ageFilter = "65_plus";
                    break;
            }
            return ageFilter;
        }
コード例 #5
0
        private void InitAgeGroup()
        {
            if (_db.AgeGroups.Count() > 0)
            {
                return;
            }

            string  file = System.IO.File.ReadAllText("RawData/case_details_210320.json");
            dynamic json = JsonConvert.DeserializeObject(file);

            List <AgeGroup> ageGroups = new List <AgeGroup>();

            foreach (JObject record in json)
            {
                AgeGroup ageGroup = new AgeGroup();
                ageGroup.Range = record["Age_Group"].ToString();

                ageGroups.Add(ageGroup);
            }

            List <AgeGroup> distinct = ageGroups.DistinctBy(ag => ag.Range).ToList();

            _db.AddRange(distinct);
            _db.SaveChanges();
        }
コード例 #6
0
        private void GenerateCaseReceivedEvents(
            CaseReportData caseReportData,
            AgeGroup group,
            Sex sex,
            int count,
            int healthRiskNumber)
        {
            for (int i = 0; i < count; i++)
            {
                var caseRegistered = new CaseRegistered(
                    Guid.NewGuid(),
                    caseReportData.CaseReportId,
                    (int)group,
                    (int)sex,
                    caseReportData.Latitude,
                    caseReportData.Longitude,
                    caseReportData.Timestamp,
                    caseReportData.DataCollectorId,
                    caseReportData.HealthRiskId,
                    healthRiskNumber,
                    caseReportData.PhoneNumber);

                Apply(caseRegistered);
            }
        }
コード例 #7
0
    public void UpdateDiaryFixture(int diaryId, AgeGroup @group, string homeOrAway, string detail, string link,
                                   string photos, string report, bool isLeague)
    {
        using (OleDbConnection cn = new OleDbConnection(connectionString))
        {
            cn.Open();
            var sql = String.Format(@"update Diary
                set Fixture{0}Detail = @FixtureDetail, 
                Fixture{0}HA = @FixtureHA, 
                Fixture{0}Link = @FixtureLink, 
                Fixture{0}Photos = @FixturePhotos, 
                Fixture{0}Report = @FixtureReport,
                Fixture{0}League = @FixtureLeague
                where DiaryId = {1}", group.ToString(), diaryId);

            var command = cn.CreateCommand();
            command.CommandText = sql;
            command.Parameters.AddWithValue("FixtureDetail", detail);
            command.Parameters.AddWithValue("FixtureHA", homeOrAway);
            command.Parameters.AddWithValue("FixtureLink", link);
            command.Parameters.AddWithValue("FixturePhotos", photos);
            command.Parameters.AddWithValue("FixtureReport", report);
            command.Parameters.AddWithValue("FixtureLeague", isLeague);
            command.ExecuteNonQuery();
            //            var dates = cn.Execute(sql, parameters);
        }
    }
コード例 #8
0
        /// <summary>
        ///  AgeGroup to string
        /// </summary>
        /// <param name="age"></param>
        /// <returns></returns>
        public static string AgeGroupToString(AgeGroup age)
        {
            String ageFilter = String.Empty;

            switch (age)
            {
            case AgeGroup.One:
                ageFilter = "0_24";
                break;

            case AgeGroup.Two:
                ageFilter = "25_34";
                break;

            case AgeGroup.Three:
                ageFilter = "35_44";
                break;

            case AgeGroup.Four:
                ageFilter = "45_54";
                break;

            case AgeGroup.Five:
                ageFilter = "55_64";
                break;

            case AgeGroup.Six:
                ageFilter = "65_plus";
                break;
            }
            return(ageFilter);
        }
コード例 #9
0
        public void OnGet()
        {
            Deaths    = diagnosisService.Deaths();
            Recovered = diagnosisService.Recovered();
            Diagnoses = diagnosisService.GetDiagnosesWithCorona();
            var Ddiagnoses = Diagnoses.GroupBy(x => 10 * ((DateTime.Now.Year - x.Patient.BirthDate.Year) / 10));

            foreach (var item in Ddiagnoses.OrderBy(i => i.Key))
            {
                AgeGroup.Add(new StatisticsCore
                {
                    Age           = item.Key.ToString() + "-" + $"{item.Key + 9}",
                    TotalPatients = item.GroupBy(x => x.Patient.Name).Count()
                });;
            }
            var patientDeath = Deaths.GroupBy(x => 10 * ((DateTime.Now.Year - x.Patient.BirthDate.Year) / 10));

            foreach (var item in patientDeath)
            {
                PatientDeath.Add(new StatisticsCore
                {
                    Age           = item.Key.ToString() + "-" + $"{item.Key + 9}",
                    TotalPatients = item.GroupBy(x => x.Patient.Name).Count()
                });
            }
        }
コード例 #10
0
        /// <summary>
        /// Helper method used to convert DataTable to list of AgeGroups.
        /// </summary>
        /// <param name="dataTable">The DataTable to be converted to list of AgeGroups</param>
        /// <returns>A list of AgeGroups from the database (empty list if the parameter is null)</returns>
        private List <AgeGroup> HandleData(DataTable dataTable)
        {
            List <AgeGroup> ageGroups = new List <AgeGroup>();

            if (dataTable is null)
            {
                return(ageGroups);
            }
            dataTable.Rows.Cast <DataRow>().ToList().ForEach(row =>
            {
                AgeGroup ageGroup = new AgeGroup()
                {
                    Id   = (int)row["Id"],
                    Name = (string)row["Name"]
                };
                if (row["MinAge"] != DBNull.Value)
                {
                    ageGroup.MinAge = (byte)row["MinAge"];
                }
                if (row["MaxAge"] != DBNull.Value)
                {
                    ageGroup.MaxAge = (byte)row["MaxAge"];
                }
                ageGroups.Add(ageGroup);
            });
            return(ageGroups);
        }
コード例 #11
0
        public async Task <IHttpActionResult> PutAgeGroup(int id, AgeGroup ageGroup)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != ageGroup.AgeGroupId)
            {
                return(BadRequest());
            }

            db.Entry(ageGroup).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!AgeGroupExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
コード例 #12
0
        public IEnumerable <EventCountDTO> GetEventsNumber()
        {
            IDbConnection         con    = DBUtils.getConnection();
            IList <EventCountDTO> events = new List <EventCountDTO>();

            using (var comm = con.CreateCommand())
            {
                comm.CommandText = "SELECT Event, AgeGroup, COUNT(*) AS Number FROM (SELECT Event1 AS Event, AgeGroup FROM Entry UNION ALL SELECT Event2, AgeGroup FROM Entry WHERE Event2 != 'NONE') GROUP BY Event, AgeGroup;";

                using (var dataR = comm.ExecuteReader())
                {
                    while (dataR.Read())
                    {
                        Event         Eventt   = (Event)Enum.Parse(typeof(Event), dataR.GetString(0));
                        AgeGroup      ageGroup = (AgeGroup)Enum.Parse(typeof(AgeGroup), dataR.GetString(1));
                        long          Count    = dataR.GetInt64(2);
                        EventCountDTO eventt   = new EventCountDTO {
                            Event = Eventt, AgeGroup = ageGroup, Count = Count
                        };
                        events.Add(eventt);
                    }
                }
            }
            return(events);
        }
コード例 #13
0
        protected override ActionResult DisplayResultsView(RaceFilterViewModel filter)
        {
            var viewModel = new TriStatsViewModel();

            viewModel.Filter = filter;

            List <Triathlete> allAthletes = GetAllAthletesForRaces(filter);


            var selectedAgeGroupIds = AgeGroup.Expand(filter.SelectedAgeGroupIds);
            var selectedGenderIds   = Gender.Expand(filter.SelectedGenderIds);
            var athletes            = new List <Triathlete>();

            foreach (string raceId in filter.SelectedRaceIds)
            {
                var athletesPerRace = allAthletes.Where(
                    a => a.RequestContext.RaceId.Equals(raceId, System.StringComparison.CurrentCultureIgnoreCase) &&
                    selectedAgeGroupIds.Contains(a.RequestContext.AgeGroupId) &&
                    selectedGenderIds.Contains(a.RequestContext.GenderId)
                    ).ToList();
                // new BasicDurationFilter() { } //bypass the user's duration filter so we can get all athletes, including DNFs


                athletes.AddRange(athletesPerRace);
                viewModel.Stats.Add(
                    GetStats(athletesPerRace, filter.AvailableRaces.Single(r => r.RaceId == raceId)));
            }
            viewModel.Triathletes = athletes;
            return(View("Compare", viewModel));
        }
コード例 #14
0
        internal decimal CalculateWith(Gender gender, AgeGroup ageGroup, Province province)
        {
            SubmitValuesInIndexPage(gender, ageGroup, province);
            remoteWebDriver.WaitUntilElementIsPresent(By.Id(ResultTextIdentifier));

            return(decimal.Parse(remoteWebDriver.FindElementById(ResultTextIdentifier).Text));
        }
コード例 #15
0
        public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            string ageGroupLabel = Properties.Resources.AgeGroupUnknown;

            if (value != null)
            {
                AgeGroup ageGroup = (AgeGroup)value;
                if (ageGroup == AgeGroup.Youth)
                {
                    ageGroupLabel = Properties.Resources.AgeGroupYouth;
                }
                else if (ageGroup == AgeGroup.Adult)
                {
                    ageGroupLabel = Properties.Resources.AgeGroupAdult;
                }
                else if (ageGroup == AgeGroup.MiddleAge)
                {
                    ageGroupLabel = Properties.Resources.AgeGroupMiddleAge;
                }
                else if (ageGroup == AgeGroup.Senior)
                {
                    ageGroupLabel = Properties.Resources.AgeGroupSenior;
                }
            }

            return(ageGroupLabel);
        }
コード例 #16
0
        private HypotheticalsViewModel GetEstimatedTime(RaceFilterViewModel filter)
        {
            var modelView = new HypotheticalsViewModel();

            modelView.Filter = filter;

            string raceId = filter.SelectedRaceIds.First();

            var athletes = _RaceService.GetAthletes(
                new BasicRaceCriteria
            {
                SelectedRaceIds     = new string[] { raceId },
                SelectedAgeGroupIds = AgeGroup.Expand(filter.SelectedAgeGroupIds),
                SelectedGenderIds   = Gender.Expand(filter.SelectedGenderIds)
            },
                filter
                );

            modelView.Triathletes = athletes;
            modelView.Stats.Add(GetStats(athletes, filter.AvailableRaces.Single(r => r.RaceId == raceId)));
            modelView.SelectedSkillLevel = filter.SkillLevel; //TO-DO: fix this up so it removes the redundancy



            return(modelView);
        }
コード例 #17
0
        public List <IAgeGroup> Map(IDataReader from)
        {
            var list = new List <IAgeGroup>();

            if (from == null)
            {
                return(list);
            }
            while (from.Read())
            {
                var item = new AgeGroup();
                if (!from.IsDBNull(0))
                {
                    item.Id = Convert.ToInt32(from["Id"]);
                }
                if (!from.IsDBNull(1))
                {
                    item.MinAge = Convert.ToInt32(from["MinAge"]);
                }
                if (!from.IsDBNull(2))
                {
                    item.MaxAge = Convert.ToInt32(from["MaxAge"]);
                }
                if (!from.IsDBNull(3))
                {
                    item.Description = from["Description"].ToString();
                }
                ;

                list.Add(item);
            }
            return(list);
        }
コード例 #18
0
        public static string ToStravaString(this AgeGroup ageGroup)
        {
            switch (ageGroup)
            {
            case AgeGroup.From0To24:
                return("0_24");

            case AgeGroup.From25To34:
                return("25_34");

            case AgeGroup.From35To44:
                return("35_44");

            case AgeGroup.From45To54:
                return("45_54");

            case AgeGroup.From55To64:
                return("55_64");

            case AgeGroup.From64:
                return("64Plus");

            default:
                throw new NotSupportedException(string.Format("Unknown age group: {0}", ageGroup));
            }
        }
コード例 #19
0
    public static Wealth RootWealth(AgeGroup group)
    {
        float det = Random.Range(0.0f, 1.0f);

        if (group == AgeGroup.youngAdult)
        {
            if (det <= 0.6f)
            {
                return(Wealth.poor);
            }
            else if (det <= 0.99f)
            {
                return(Wealth.middleClass);
            }
            else
            {
                return(Wealth.wealthy);
            }
        }
        else
        {
            if (det <= 0.2f)
            {
                return(Wealth.poor);
            }
            else if (det <= 0.98f)
            {
                return(Wealth.middleClass);
            }
            else
            {
                return(Wealth.wealthy);
            }
        }
    }
コード例 #20
0
ファイル: RanksMap.cs プロジェクト: hadaromash/bv-tournaments
        private static string GetRankingPageUrl(int year, Gender gender, AgeGroup ageGroup)
        {
            const string RankingWebPageTemplate = "http://www.iva.org.il/Ranking.asp?cYear={0}&cMode=0&GenderId={1}&level_id={2}";
            int          genderId = GetGenderId(gender);
            int          levelId  = GetLevelId(ageGroup);

            return(string.Format(RankingWebPageTemplate, year, genderId, levelId));
        }
コード例 #21
0
 public void ValidateGroup(AgeGroup group, ModelStateDictionary ms)
 {
     if (_context.AgeGroups.Any(g => g.Value == group.Value))
     {
         ms.AddModelError("Value", "Дане ім'я не є унікальним");
         ms["Value"].ValidationState = ModelValidationState.Invalid;
     }
 }
コード例 #22
0
 public Questionnaire(int grade, string desc, string country, Gender gender, AgeGroup ageGroup)
 {
     Grade       = grade;
     Description = desc;
     Country     = country;
     Gender      = gender;
     AgeGr       = ageGroup;
 }
コード例 #23
0
        public object[] getEnumDisplayAnnotaion(AgeGroup group, int num)
        {
            var enumType  = group.GetType();
            var enumValue = Enum.GetName(enumType, num);
            var member    = enumType.GetMember(enumValue)[0];

            return(member.GetCustomAttributes(typeof(DisplayAttribute), false));
        }
        public DetailsViewModel(AgeGroup categoryName, List <Participant> participants)
        {
            var helper = new HelperFunctions();
            var attr   = helper.getEnumDisplayAnnotaion(categoryName, (int)categoryName);

            CategoryName = ((DisplayAttribute)attr[0]).Name;

            Participants = participants;
        }
コード例 #25
0
 public void CanCalculateAge()
 {
     Assert.Equal(50, AgeGroup.GetAgeOnDate(raceDate, DateTime.Parse("25/01/1965")));
     Assert.Equal(20, AgeGroup.GetAgeOnDate(raceDate, DateTime.Parse("27/09/1995")));
     Assert.Equal(19, AgeGroup.GetAgeOnDate(raceDate, DateTime.Parse("28/09/1995")));
     Assert.Equal(20, AgeGroup.GetAgeOnDate(raceDate, DateTime.Parse("26/09/1995")));
     Assert.Equal(29, AgeGroup.GetAgeOnDate(raceDate, DateTime.Parse("12/12/1985")));
     Assert.Equal(29, AgeGroup.GetAgeOnDate(raceDate, DateTime.Parse("12/02/1986")));
 }
コード例 #26
0
ファイル: AcademyRepository.cs プロジェクト: Archer141/Awwsp
        public void UpdateAgeGroup(AgeGroup ageGroup)
        {
            var aG = GetAgeGropuById(ageGroup.AgeGroupID);

            aG.MaxAge = ageGroup.MaxAge;
            aG.MinAge = ageGroup.MinAge;
            aG.Name   = ageGroup.Name;
            dbContext.SaveChanges();
        }
コード例 #27
0
ファイル: AcademyRepository.cs プロジェクト: Archer141/Awwsp
 public void AddAgeGroup(AgeGroup ageGroup)
 {
     if (ageGroup != null)
     {
         // dbContext.AgeGroups.Add(new AgeGroup { MaxAge = ageGroup.MaxAge, MinAge = ageGroup.MinAge, Name = ageGroup.Name });
         dbContext.AgeGroups.Add(ageGroup);
         dbContext.SaveChanges();
     }
 }
コード例 #28
0
        /// <summary>
        /// 키워드 순위를 제공
        /// </summary>
        /// <param name="ageGroup">연령대</param>
        /// <returns>키워드 순위</returns>
        public async Task <IEnumerable <string> > ParseKeywordRankAsync(AgeGroup ageGroup)
        {
            var document = await GetHtmlDocumentAsync();

            var keywordNodes = document
                               .DocumentNode
                               .SelectNodes($"//div[@class='keyword_carousel']//div[@data-age='{ageGroup.GetDataAge()}']//ul[@class='rank_list v2']//span[@class='title']");

            return(keywordNodes.Select(n => n.InnerText).ToList());
        }
コード例 #29
0
ファイル: Person.cs プロジェクト: ButterfishGames/TheGuild
    private void GenPartner(RootPerson root)
    {
        gender   = Generators.PartnerGender(root);
        ageGroup = Generators.PartnerAgeGroup(root);
        age      = Generators.Age(ageGroup);

        skinColor = Generators.PartnerSkinColor(root);
        hairColor = Generators.RootHairColor(skinColor);
        eyeColor  = Generators.RootEyeColor(skinColor);
    }
コード例 #30
0
        public async Task OnPostCreate([Bind("Value")] AgeGroup group)
        {
            ValidateGroup(group, ModelState);
            if (ModelState.IsValid)
            {
                _context.AgeGroups.Add(group);
                await _context.SaveChangesAsync();
            }

            Groups = await _context.AgeGroups.ToListAsync();
        }
コード例 #31
0
        public async Task <IHttpActionResult> GetAgeGroup(int id)
        {
            AgeGroup ageGroup = await db.AgeGroups.FindAsync(id);

            if (ageGroup == null)
            {
                return(NotFound());
            }

            return(Ok(ageGroup));
        }
コード例 #32
0
ファイル: Token.cs プロジェクト: Paulgherve1/Critters
 //Increases the age and scale of a token
 public void Age()
 {
     if(age == AgeGroup.Cub){
         age = AgeGroup.Adult;
         SetScale(AgeGroup.Adult);
     }
     if(age == AgeGroup.Baby){
         age = AgeGroup.Cub;
         SetScale(AgeGroup.Cub);
     }
     if(age == AgeGroup.Adult){
         Mama = null;
     }
 }
コード例 #33
0
        private IQueryable<CrashData> FilterAgeGroup(IQueryable<CrashData> crashes, AgeGroup ageGroup)
        {
            switch (ageGroup)
            {
                case AgeGroup.Unknown:
                    break;
                case AgeGroup.Young:
                    crashes = crashes.Where(x => x.YoungDriverCount > 0);
                    break;
                case AgeGroup.MiddleAge:
                    crashes = crashes.Where(x => x.DriverCount > x.YoungDriverCount + x.OldDriverCount);
                    break;
                case AgeGroup.Old:
                    crashes = crashes.Where(x => x.OldDriverCount > 0);
                    break;
                default:
                    throw new ArgumentOutOfRangeException("ageGroup", ageGroup, null);
            }

            return crashes;
        }
コード例 #34
0
        /// <summary>
        /// Gets the gender-filtered and age-filtered leaderboard of a segment. This method requires the currently authenticated 
        /// athlete to have a Strava premium account.
        /// </summary>
        /// <param name="segmentId">The Strava segment Id.</param>
        /// <param name="gender">The gender used to filter the leaderboard.</param>
        /// /// <param name="age">The age range used to filter the leaderboard.</param>
        /// <returns>The leaderboard filtered by gender and age.</returns>
        public Leaderboard GetSegmentLeaderboard(String segmentId, Gender gender, AgeGroup age)
        {
            String getUrl = String.Format("{0}/{1}/leaderboard?gender={2}&age_group={3}&filter=age_group&access_token={4}",
                Endpoints.Leaderboard,
                segmentId,
                gender.ToString().Substring(0, 1),
                UrlHelper.AgeGroupToString(age),
                Authentication.AccessToken
                );

            String json = WebRequest.SendGet(new Uri(getUrl));
            return Unmarshaller<Leaderboard>.Unmarshal(json);
        }
コード例 #35
0
ファイル: AppService.cs プロジェクト: SimonDavies72/ClubSite
 public DiaryFixture GetDiaryFixture(int diaryId, AgeGroup group)
 {
     using (OleDbConnection cn = new OleDbConnection(connectionString))
     {
         cn.Open();
         var sql = String.Format(@"select DiaryId, [Date] as FixtureDate,
             Fixture{0}HA as FixtureHA,
             Fixture{0}Detail as FixtureDetail,
             Fixture{0}Link as FixtureLink,
             Fixture{0}Photos as FixturePhotos,
             Fixture{0}Report as FixtureReport,
             Fixture{0}League as FixtureLeague
         from Diary where DiaryId = @DiaryId", group.ToString());
         var dates = cn.Query<DiaryFixture>(sql, new { DiaryId = diaryId });
         return dates.First();
     }
 }
コード例 #36
0
ファイル: AppService.cs プロジェクト: SimonDavies72/ClubSite
 public IEnumerable<DiaryFixture> GetAgeGroupDiaryNew(AgeGroup ageGroup)
 {
     var calendarId = 1;
     using (OleDbConnection cn = new OleDbConnection(connectionString))
     {
         cn.Open();
         var sql = String.Format(@"SELECT f.FixtureID AS DiaryId, cd.CalendarDate AS FixtureDate, f.Details AS FixtureDetail, f.HA AS FixtureHA, f.Link AS FixtureLink, f.Photos AS FixturePhotos,
                      f.Report AS FixtureReport, f.League AS FixtureLeague
                      FROM (CalendarDates cd LEFT OUTER JOIN
                             (SELECT FixtureID, CalendarDateID, AgeGroup, Details, HA, Link, Photos, Report, League
                                FROM  Fixtures
                               WHERE (AgeGroup = '{0}')) f ON f.CalendarDateID = cd.CalendarDateID)
                      ORDER BY cd.CalendarDate", ageGroup.ToString());
         return cn.Query<DiaryFixture>(sql, new { CalendarId = calendarId });
     }
 }
コード例 #37
0
ファイル: AppService.cs プロジェクト: SimonDavies72/ClubSite
 public IEnumerable<DiaryFixture> GetAgeGroupDiary(AgeGroup ageGroup)
 {
     var calendarId = 1;
     using (OleDbConnection cn = new OleDbConnection(connectionString))
     {
         cn.Open();
         var sql = String.Format(@"select DiaryId, [Date] as FixtureDate,
             Fixture{0}HA as FixtureHA,
             Fixture{0}Detail as FixtureDetail,
             Fixture{0}Link as FixtureLink,
             Fixture{0}Photos as FixturePhotos,
             Fixture{0}Report as FixtureReport,
             Fixture{0}League as FixtureLeague,
             FixtureSocialDetail <> '' as IsSocial
         from Diary
         where CalendarId = @CalendarId
         order by [Date]", ageGroup.ToString());
         return cn.Query<DiaryFixture>(sql, new { CalendarId = calendarId });
     }
 }
コード例 #38
0
 private async Task<Leaderboard> GetLeaderboardInternal(int segmentId, int? page, int? perPage, Gender? gender, AgeGroup? ageGroup, bool following = false)
 {
     var request = new RestRequest(EndPoint + "/" + segmentId + "/leaderboard", Method.GET);
     if (page != null)
         request.AddParameter("page", page);
     if (perPage != null)
         request.AddParameter("per_page", perPage);
     request.AddParameter("following", following ? "true" : "false");
     if (gender.HasValue)
         request.AddParameter("gender", gender.Value.ToStravaString());
     if (ageGroup.HasValue)
         request.AddParameter("age_group", ageGroup.Value.ToStravaString());
     var response = await _client.RestClient.Execute<Leaderboard>(request);
     return response.Data;
 }
コード例 #39
0
ファイル: AppService.cs プロジェクト: SimonDavies72/ClubSite
    public void UpdateDiaryFixture(int diaryId, AgeGroup @group, string homeOrAway, string detail, string link,
        string photos, string report, bool isLeague)
    {
        using (OleDbConnection cn = new OleDbConnection(connectionString))
        {
            cn.Open();
            var sql = String.Format(@"update Diary
                set Fixture{0}Detail = @FixtureDetail,
                Fixture{0}HA = @FixtureHA,
                Fixture{0}Link = @FixtureLink,
                Fixture{0}Photos = @FixturePhotos,
                Fixture{0}Report = @FixtureReport,
                Fixture{0}League = @FixtureLeague
                where DiaryId = {1}", group.ToString(), diaryId);

            var command = cn.CreateCommand();
            command.CommandText = sql;
            command.Parameters.AddWithValue("FixtureDetail", detail);
            command.Parameters.AddWithValue("FixtureHA", homeOrAway);
            command.Parameters.AddWithValue("FixtureLink", link);
            command.Parameters.AddWithValue("FixturePhotos", photos);
            command.Parameters.AddWithValue("FixtureReport", report);
            command.Parameters.AddWithValue("FixtureLeague", isLeague);
            command.ExecuteNonQuery();
            //            var dates = cn.Execute(sql, parameters);
        }
    }
コード例 #40
0
ファイル: Token.cs プロジェクト: Paulgherve1/Critters
    public void SetScale(AgeGroup newAge)
    {
        age = newAge;

        if(age == AgeGroup.Adult)							{baseSize = 1;}
        else if(age == AgeGroup.Cub)						{baseSize = .75f;}
        else if(age == AgeGroup.Baby)						{baseSize = .45f;}

        baseSize /= (6 - critter.GetSize()) *.25f;
    }
コード例 #41
0
 public Task<Leaderboard> GetLeaderboard(int segmentId, int page, int perPage, Gender? gender, AgeGroup? ageGroup)
 {
     return GetLeaderboardInternal(segmentId, page, perPage, gender, ageGroup);
 }
コード例 #42
0
ファイル: SegmentClient.cs プロジェクト: TiBall/stravadotnet
        /// <summary>
        /// Gets the gender-filtered and age-filtered leaderboard of a segment. This method requires the currently authenticated 
        /// athlete to have a Strava premium account.
        /// </summary>
        /// <param name="segmentId">The Strava segment Id.</param>
        /// <param name="gender">The gender used to filter the leaderboard.</param>
        /// /// <param name="age">The age range used to filter the leaderboard.</param>
        /// <returns>The leaderboard filtered by gender and age.</returns>
        public Leaderboard GetSegmentLeaderboard(String segmentId, Gender gender, AgeGroup age)
        {
            String ageFilter = String.Empty;

            switch (age)
            {
                case AgeGroup.One:
                    ageFilter = "0_24";
                    break;
                case AgeGroup.Two:
                    ageFilter = "25_34";
                    break;
                case AgeGroup.Three:
                    ageFilter = "35_44";
                    break;
                case AgeGroup.Four:
                    ageFilter = "45_54";
                    break;
                case AgeGroup.Five:
                    ageFilter = "55_64";
                    break;
                case AgeGroup.Six:
                    ageFilter = "65_plus";
                    break;
            }

            String getUrl = String.Format("{0}/{1}/leaderboard?gender={2}&age_group={3}&filter=age_group&access_token={4}",
                Endpoints.Leaderboard,
                segmentId,
                gender.ToString().Substring(0, 1),
                ageFilter,
                Authentication.AccessToken
                );

            String json = WebRequest.SendGet(new Uri(getUrl));

            return Unmarshaller<Leaderboard>.Unmarshal(json);
        }
コード例 #43
0
 public Movie(string name, int id, decimal price, int movieLength, string actor, int year, AgeGroup ageGroup)
     : this(name, id, price, movieLength, actor, year)
 {
     this.AgeGroup = ageGroup;
 }
コード例 #44
0
ファイル: Token.cs プロジェクト: Paulgherve1/Critters
 public void SetAge(AgeGroup newAge)
 {
     age = newAge;
 }
コード例 #45
0
 /// <summary>
 /// Gets leaderboard for a segment.
 /// </summary>
 /// <param name="segmentId">ID of the segment.</param>
 /// <param name="gender"></param>
 /// <returns>Leaderboard of the segment</returns>
 public Task<Leaderboard> GetLeaderboard(int segmentId, Gender? gender, AgeGroup? ageGroup)
 {
     return GetLeaderboardInternal(segmentId, null, null, gender, ageGroup);
 }
コード例 #46
0
ファイル: Game.cs プロジェクト: HansS/TelerikAcademy-homework
 public Game(string name, int id, decimal price, string creator, int year, string platform, AgeGroup ageGroup)
     : this(name, id, price, creator, year, platform)
 {
     this.AgeGroup = ageGroup;
 }
コード例 #47
0
ファイル: Settings.cs プロジェクト: rossspoon/bvcms
 private void ParseAgeGroups(Parser parser)
 {
     parser.lineno++;
     if (parser.curr.indent == 0)
         return;
     var startindent = parser.curr.indent;
     while (parser.curr.indent == startindent)
     {
         var agegroup = new AgeGroup();
         if (parser.curr.kw != Parser.RegKeywords.None)
             throw parser.GetException("unexpected line");
         agegroup.SmallGroup = parser.GetLine();
         var m = parser.agerange.Match(agegroup.SmallGroup);
         if (!m.Success)
         {
             parser.lineno--;
             throw parser.GetException("expected age range like 0-12");
         }
         agegroup.StartAge = m.Groups["start"].Value.ToInt();
         agegroup.EndAge = m.Groups["end"].Value.ToInt();
         if (parser.curr.indent <= startindent)
             throw parser.GetException("expected either indented SmallGroup or Fee");
         var ind = parser.curr.indent;
         while (parser.curr.indent == ind)
         {
             switch (parser.curr.kw)
             {
                 case Parser.RegKeywords.SmallGroup:
                     agegroup.SmallGroup = parser.GetString(agegroup.SmallGroup);
                     break;
                 case Parser.RegKeywords.Fee:
                     agegroup.Fee = parser.GetDecimal();
                     break;
                 default:
                     throw parser.GetException("unexpected line");
             }
         }
         AgeGroups.Add(agegroup);
     }
 }