示例#1
0
        public async Task <IActionResult> OnPostSubmitAsync()
        {
            foreach (var cadEntry in Cadets)
            {
                bool emptyVal = false;

                if (string.IsNullOrEmpty(cadEntry.KnownAs) ||
                    string.IsNullOrEmpty(cadEntry.Surname) ||
                    string.IsNullOrEmpty(cadEntry.Form) ||
                    string.IsNullOrEmpty(cadEntry.Gender) ||
                    string.IsNullOrEmpty(cadEntry.Rank))
                {
                    emptyVal = true;
                }

                if (emptyVal == false)
                {
                    Cadets = _context.Cadets
                             .Where(r => r.CadetId == cadEntry.CadetId)
                             .OrderBy(s => s.Surname).ToList();

                    //var cadet = _context.Cadets.Attach(new Cadet { CadetId = cadEntry.CadetId });

                    if (Cadets.Count > 0)
                    {
                        for (var i = 0; i < Cadets.Count; i++)
                        {
                            Cadets[i].KnownAs = cadEntry.KnownAs;
                            Cadets[i].Surname = cadEntry.Surname;
                            Cadets[i].Age     = cadEntry.Age;
                            Cadets[i].Year    = cadEntry.Year;
                            Cadets[i].Form    = cadEntry.Form;
                            Cadets[i].Gender  = cadEntry.Gender;
                            Cadets[i].Rank    = cadEntry.Rank;
                            Cadets[i].Platoon = cadEntry.Platoon;
                            Cadets[i].Section = cadEntry.Section;
                            _context.Update(Cadets[i]);
                            _context.SaveChanges();
                        }
                        //_context.Add(new Cadet
                        //{
                        //    Surname = cadEntry.lastName,
                        //    KnownAs = cadEntry.firstName,
                        //    Age = cadEntry.yearsOld,
                        //    Year = cadEntry.schoolYear,
                        //    Form = cadEntry.schoolForm,
                        //    Gender = cadEntry.cadGender,
                        //    Rank = cadEntry.cadRank,
                        //    Platoon = cadEntry.cadPlatoon,
                        //    Section = cadEntry.cadSection
                        //});
                        //counttest++;
                        //await _context.SaveChangesAsync();
                        //tempString = counttest + "Entries Created";
                    }
                }
            }
            return(Page());
        }
        public async Task <IActionResult> OnPostDeleteAsync(int DeleId)
        {
            var removeItem = _context.Qualifications.SingleOrDefault(s => s.QualificationId == DeleId);

            if (removeItem != null)
            {
                _context.Qualifications.Remove(removeItem);
                _context.SaveChanges();
            }
            Qualifications = _context.Qualifications.OrderBy(s => s.Name).ToList();
            return(Page());
        }
示例#3
0
        public void RegCreat(DateTime selectDay)
        {
            Registers = _context.Registers.Where(c => c.DateOfReg == selectDay).ToList();

            if (Registers.Count == 0)
            {
                _context.Registers.Add(new Register {
                    Attended = true, DateOfReg = selectDay
                });
                _context.Registers.Add(new Register {
                    Attended = false, DateOfReg = selectDay
                });
                _context.SaveChanges();
            }
        }
        public async Task <IActionResult> OnPostSubmitAsync()
        {
            foreach (var qualEntry in Qualifications)
            {
                bool emptyVal = false;

                if (string.IsNullOrEmpty(qualEntry.Name))
                {
                    emptyVal = true;
                }

                if (emptyVal == false)
                {
                    Qualifications = _context.Qualifications
                                     .Where(r => r.QualificationId == qualEntry.QualificationId)
                                     .OrderBy(s => s.Name).ToList();

                    //var cadet = _context.Cadets.Attach(new Cadet { CadetId = cadEntry.CadetId });

                    if (Qualifications.Count > 0)
                    {
                        for (var i = 0; i < Qualifications.Count; i++)
                        {
                            Qualifications[i].Name       = qualEntry.Name;
                            Qualifications[i].PassMark   = qualEntry.PassMark;
                            Qualifications[i].ParOrChi   = qualEntry.ParOrChi;
                            Qualifications[i].Parent     = qualEntry.Parent;
                            Qualifications[i].NumOfChi   = qualEntry.NumOfChi;
                            Qualifications[i].MinChiPass = qualEntry.MinChiPass;
                            _context.Update(Qualifications[i]);
                            _context.SaveChanges();
                        }
                    }
                }
            }
            return(Page());
        }