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()); }
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()); }