public async Task <IActionResult> OnPostAsync() { foreach (var cadEntry in CadetViews) { bool emptyVal = false; if (string.IsNullOrEmpty(cadEntry.firstName) || string.IsNullOrEmpty(cadEntry.lastName) || string.IsNullOrEmpty(cadEntry.schoolForm) || string.IsNullOrEmpty(cadEntry.cadGender) || string.IsNullOrEmpty(cadEntry.cadRank)) { emptyVal = true; } if (emptyVal == false) { var cadet = _context.Cadets .Where(r => r.Surname == cadEntry.lastName && r.KnownAs == cadEntry.firstName && r.Gender == cadEntry.cadGender && r.Year == cadEntry.schoolYear).ToList(); if (cadet.Count > 0) { tempString = "Cadet already exists"; } else { _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(RedirectToPage("./CadetCreator")); }
public async Task <IActionResult> OnPostAsync() { foreach (var qualEntry in QualificationViews) { bool emptyVal = false; if (string.IsNullOrEmpty(qualEntry.qualName)) { emptyVal = true; } if (emptyVal == false) { var qual = _context.Qualifications.Where(r => r.Name == qualEntry.qualName).ToList(); if (qual.Count > 0) { tempString = "Cadet already exists"; } else { _context.Add(new Qualification { Name = qualEntry.qualName, PassMark = qualEntry.passMark, ParOrChi = qualEntry.chiPar, Parent = qualEntry.parent, NumOfChi = qualEntry.chiNum, MinChiPass = qualEntry.passNum }); counttest++; await _context.SaveChangesAsync(); tempString = counttest + "Entries Created"; } } } return(RedirectToPage("./QualificationCreator")); }