Example #1
0
 public async Task <IActionResult> OnPostSubmitAsync()
 {
     Cadets = _context.Cadets.ToList();
     if (!string.IsNullOrWhiteSpace(nameFilter))
     {
         Cadets = Cadets.Where(s => s.Surname.Contains(nameFilter, StringComparison.CurrentCultureIgnoreCase))
                  .OrderBy(s => s.Surname).ToList();
     }
     if (ageFilter != -1)
     {
         Cadets = Cadets.Where(s => s.Age == ageFilter).OrderBy(s => s.Surname).ToList();
     }
     if (yearFilter != -1)
     {
         Cadets = Cadets.Where(s => s.Year == yearFilter).OrderBy(s => s.Surname).ToList();
     }
     if (!string.IsNullOrWhiteSpace(formFilter))
     {
         Cadets = Cadets.Where(s => s.Form.Contains(formFilter, StringComparison.CurrentCultureIgnoreCase))
                  .OrderBy(s => s.Surname).ToList();
     }
     if (!string.IsNullOrWhiteSpace(genderFilter))
     {
         Cadets = Cadets.Where(s => s.Gender.Contains(genderFilter, StringComparison.CurrentCultureIgnoreCase))
                  .OrderBy(s => s.Surname).ToList();
     }
     if (!string.IsNullOrWhiteSpace(rankFilter))
     {
         Cadets = Cadets.Where(s => s.Rank.Contains(rankFilter, StringComparison.CurrentCultureIgnoreCase))
                  .OrderBy(s => s.Surname).ToList();
     }
     if (platoonFilter != -1)
     {
         Cadets = Cadets.Where(s => s.Platoon == platoonFilter).OrderBy(s => s.Surname).ToList();
     }
     if (yearFilter != -1)
     {
         Cadets = Cadets.Where(s => s.Section == sectionFilter).OrderBy(s => s.Surname).ToList();
     }
     return(Page());
 }
Example #2
0
        public async Task <IActionResult> OnPostAsync()
        {
            RegisterViews = new List <RegisterView>();
            Cadets        = _context.Cadets.Include(c => c.Registers).OrderBy(s => s.Surname).ToList();
            Registers     = _context.Registers.ToList();

            attFiltered = false;
            dayFiltered = false;
            compDate    = daySelector(DateTime.Today.Date);

            if (!string.IsNullOrWhiteSpace(nameFilter))
            {
                Cadets = Cadets.Where(
                    s => s.Surname.Contains(nameFilter, StringComparison.CurrentCultureIgnoreCase))
                         .OrderBy(s => s.Surname).ToList();
            }

            if (!string.IsNullOrWhiteSpace(attendFilter))
            {
                if (0 == string.Compare("Yes", attendFilter,
                                        StringComparison.CurrentCultureIgnoreCase))
                {
                    attFiltered = true;
                    filterVal   = true;
                }
                if (0 == string.Compare("No", attendFilter,
                                        StringComparison.CurrentCultureIgnoreCase))
                {
                    attFiltered = true;
                    filterVal   = false;
                }
            }

            if (0 != DateTime.Compare(dateFilter, compDate))
            {
                dayFiltered = true;
            }

            foreach (var cadet in Cadets)
            {
                //if no registers for a cadet, display their name
                if (0 == cadet.Registers.Count)
                {
                }
                //move data into the viewmodel
                else
                {
                    //first reg is to only show name first time
                    var firstRegistration = true;
                    if (dayFiltered == true && attFiltered == true)
                    {
                        foreach (var register in cadet.Registers.Where(s => s.Register.DateOfReg == dateFilter &&
                                                                       s.Register.Attended == filterVal))
                        {
                            RegisterViews.Add(
                                new RegisterView
                            {
                                FullName   = firstRegistration ? cadet.Surname + ", " + cadet.KnownAs : "",
                                Attendance = register.Register.Attended.ToString(),    // ? "Yes" : "No",
                                RegDate    = register.Register.DateOfReg.Date,
                            }
                                );
                            firstRegistration = false;
                        }
                    }
                    else if (dayFiltered == true && attFiltered == false)
                    {
                        foreach (var register in cadet.Registers.Where(s => s.Register.DateOfReg == dateFilter))
                        {
                            RegisterViews.Add(
                                new RegisterView
                            {
                                FullName   = firstRegistration ? cadet.Surname + ", " + cadet.KnownAs : "",
                                Attendance = register.Register.Attended.ToString(),    // ? "Yes" : "No",
                                RegDate    = register.Register.DateOfReg.Date,
                            }
                                );
                            firstRegistration = false;
                        }
                    }
                    else if (dayFiltered == false && attFiltered == true)
                    {
                        foreach (var register in cadet.Registers.Where(s => s.Register.Attended == filterVal))
                        {
                            RegisterViews.Add(
                                new RegisterView
                            {
                                FullName   = firstRegistration ? cadet.Surname + ", " + cadet.KnownAs : "",
                                Attendance = register.Register.Attended.ToString(),    // ? "Yes" : "No",
                                RegDate    = register.Register.DateOfReg.Date,
                            }
                                );
                            firstRegistration = false;
                        }
                    }
                    else
                    {
                        foreach (var register in cadet.Registers)
                        {
                            RegisterViews.Add(
                                new RegisterView
                            {
                                FullName   = firstRegistration ? cadet.Surname + ", " + cadet.KnownAs : "",
                                Attendance = register.Register.Attended.ToString(),    // ? "Yes" : "No",
                                RegDate    = register.Register.DateOfReg.Date,
                            }
                                );
                            firstRegistration = false;
                        }
                    }
                }
            }
            return(Page());
        }
Example #3
0
        public async Task <IActionResult> OnPostFilterAsync()
        {
            Cadets    = _context.Cadets.Include(c => c.Registers).OrderBy(s => s.Surname).ToList();
            Registers = _context.Registers.ToList();

            RegisterViews = new List <RegisterView>();
            if (regGroup == "years")
            {
                if (regGroupVal >= 9 && regGroupVal <= 13)
                {
                    Cadets = Cadets.Where(s => s.Year == regGroupVal).ToList();
                }
                else
                {
                }
            }
            else if (regGroup == "platoons")
            {
                if (regGroupVal >= 1 && regGroupVal <= 3)
                {
                    Cadets = Cadets.Where(s => s.Platoon == regGroupVal).ToList();
                }
                else
                {
                }
            }
            else
            {
            }

            if (custDate == "Yes")
            {
                RegCreat(dateSel);
                day = dateSel;
            }
            else
            {
                day = daySelector(DateTime.Today);
            }


            for (var i = 0; i < Cadets.Count; i++)//each (var cadet in Cadets)
            {
                if (0 == Cadets[i].Registers.Count)
                {
                    RegisterViews.Add(
                        new RegisterView
                    {
                        FullName   = Cadets[i].Surname + ", " + Cadets[i].KnownAs,
                        Attendance = false.ToString(),
                        RegDate    = day.Date,
                    }
                        );
                }
                else
                {
                    for (int x = 0; x < Cadets[i].Registers.Count; x++)
                    {
                        if (Cadets[i].Registers[x].Register.DateOfReg == day)
                        {
                            RegisterViews.Add(
                                new RegisterView
                            {
                                FullName   = Cadets[i].Surname + ", " + Cadets[i].KnownAs,
                                Attendance = Cadets[i].Registers[x].Register.Attended.ToString(),    // ? "Yes" : "No",
                                RegDate    = day.Date,
                            }
                                );
                            regDone = true;
                        }
                    }
                    if (regDone == false)
                    {
                        RegisterViews.Add(
                            new RegisterView
                        {
                            FullName   = Cadets[i].Surname + ", " + Cadets[i].KnownAs,
                            Attendance = false.ToString(),        // ? "Yes" : "No",
                            RegDate    = day.Date,
                        }
                            );
                    }
                }
            }
            return(Page());
        }