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> OnPostAsync() { Cadets = _context.Cadets.Include(s => s.Qualifications).OrderBy(s => s.Surname).ToList(); Qualifications = _context.Qualifications.OrderBy(s => s.Name).ToList(); foreach (var qualEntry in QualAssignViews) { //string inpName = qualEntry.cadetName; //string[] splitName = inpName.Split(','); //string realName = $"{splitName[1]} {splitName[0]}".Trim(); var cadetQuer = _context.Cadets .Where(s => s.Surname == qualEntry.cadetName /*splitName[0].Trim() * && s.KnownAs == splitName[1].Trim()*/) .ToList(); var qualQuer = _context.Qualifications.Where(s => s.Name == qualEntry.qualName).ToList(); if (cadetQuer.Count > 0 && qualQuer.Count > 0) { var cadQual = _context.CadetQualifications .Where(c => c.CadetId == cadetQuer[0].CadetId && c.QualificationId == qualQuer[0].QualificationId) .ToList(); if (qualEntry.cadetMark >= qualQuer[0].PassMark) { resultPass = "******"; } if (cadQual.Count > 0) { for (var i = 0; i < cadQual.Count; i++) { cadQual[i].CadetId = cadetQuer[0].CadetId; cadQual[i].QualificationId = qualQuer[0].QualificationId; cadQual[i].cadMark = qualEntry.cadetMark; cadQual[i].Passed = resultPass; _context.Update(cadQual[i]); } } if (cadQual.Count == 0) { _context.CadetQualifications.Add( new CadetQualification { CadetId = cadetQuer[0].CadetId, QualificationId = qualQuer[0].QualificationId, cadMark = qualEntry.cadetMark, Passed = resultPass }); } await _context.SaveChangesAsync(); } } return(Page()); }
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()); }
public async Task <IActionResult> OnPostSubmitAsync() { //DateTime inputDate = date; //bool attendance = Attend; Cadets = _context.Cadets.Include(c => c.Registers).OrderBy(s => s.Surname).ToList(); Registers = _context.Registers.ToList(); //var cadetRegisters = _context.CadetRegisters.Where(r => r.RegisterId == r.Register.RegisterId && r.Register.DateOfReg == inputDate && r.Cadet.Surname == inputName).ToList(); foreach (var regEntry in RegisterViews) { string inpName = regEntry.FullName; string[] splitName = inpName.Split(','); string realName = $"{splitName[1]} {splitName[0]}".Trim(); var cadetQuer = _context.Cadets.Where(c => c.Surname == splitName[0].Trim() && c.KnownAs == splitName[1].Trim()).ToList(); var attendance = 0 == string.Compare(regEntry.Attendance, "true", StringComparison.CurrentCultureIgnoreCase); var regQuer = _context.Registers .Where(r => r.DateOfReg == regEntry.RegDate && r.Attended == attendance).ToList(); if (regQuer.Count > 0 && cadetQuer.Count > 0) { var cadReg = _context.CadetRegisters .Where(c => c.CadetId == cadetQuer[0].CadetId && c.Register.DateOfReg == regQuer[0].DateOfReg) .ToList(); if (cadReg.Count > 0) { for (var i = 0; i < cadReg.Count; i++) { cadReg[i].CadetId = cadetQuer[0].CadetId; cadReg[i].RegisterId = regQuer[0].RegisterId; _context.Update(cadReg[i]); } } if (cadReg.Count == 0) { int cadID = cadetQuer[0].CadetId; int regID = regQuer[0].RegisterId; _context.CadetRegisters.Add(new CadetRegister { CadetId = cadID, RegisterId = regID }); } counttest++; returnedString = counttest + " Entry Created"; await _context.SaveChangesAsync(); } if (cadetQuer.Count == 0) { returnedString = "Cadet doesn't exist"; } } return(Page()); /*if (cadetRegisters.Count > 0) * { * string firstName = cadetRegisters[0].Cadet.KnownAs; * string lastName = cadetRegisters[0].Cadet.Surname; * string attend = cadetRegisters[0].Register.Attended.ToString(); * string newDate = cadetRegisters[0].Register.DateOfReg.ToShortDateString(); * returnedString = stringCreate(firstName, lastName, newDate, attend); * } * * else * { * var cadetQuer = _context.Cadets.Where(c => c.Surname == inputName).ToList(); * var regQuer = _context.Registers.Where(r => r.DateOfReg == inputDate && r.Attended == true).ToList(); * if (regQuer.Count > 0 && cadetQuer.Count > 0) * { * int cadID = cadetQuer[0].CadetId; * int regID = regQuer[0].RegisterId; * _context.CadetRegisters.Add(new CadetRegister { CadetId = cadID, RegisterId = regID }); * string firstName = cadetQuer[0].KnownAs; * string lastName = cadetQuer[0].Surname; * string attend = regQuer[0].Attended.ToString(); * string newDate = inputDate.ToShortDateString(); * returnedString = stringCreate(firstName, lastName, newDate, attend); * } * if (cadetQuer.Count > 0) * { * //run new date creation * _context.Registers.Add(new Register { Attended = true, DateOfReg = inputDate }); * _context.Registers.Add(new Register { Attended = false, DateOfReg = inputDate }); * returnedString = * stringCreate(cadetQuer[0].KnownAs, cadetQuer[0].Surname, inputDate.ToShortDateString(), attendance.ToString()); * } * else * { * returnedString = "Cadet doesn't exist"; * } * } * * useDate = date.ToShortDateString(); * return RedirectToPage("./RegisterEdit");*/ //_context.Registers.Add(new Register {Attended = true, //DateOfReg = new DateTime(), //}); //await _context.SaveChangesAsync(); /*assigns value to variable depending on input * foreach (var cadet in RegisterViews) * { * var s = $"{cadet.FullName}, {cadet.Attendance}, {cadet.RegDate}"; * if (cadet.Attendance == "true") * { * answer = "Yes"; * } * else * { * answer = "No"; * } * } * string queryString = * "SELECT CadetId, RegisterId FROM dbo.CadetRegisters;"; * * string queryStringAttend = * "SELECT Attended, DateOfReg FROM dbo.Register;"; * * using (SqlConnection connection = * new SqlConnection("Server=(localdb)\\mssqllocaldb;Database=CourseworkDatabase;Trusted_Connection=True;")) * { * SqlCommand command = * new SqlCommand(queryString, connection); * connection.Open(); * * SqlDataReader reader = command.ExecuteReader(); * * // Call Read before accessing data. * while (reader.Read()) * { * string regId = Convert.ToString(reader[0]); * * SqlCommand commandAttended = * new SqlCommand(queryStringAttend, connection); * connection.Open(); * SqlDataReader readerAttended = commandAttended.ExecuteReader(); * * returnedString = testFunc(regId, Convert.ToString(readerAttended[0]), Convert.ToDateTime(readerAttended[1]).Date); * } * * // Call Close when done reading. * reader.Close(); * connection.Close(); * } * using (v * var register = DbConnection.Database.SqlQuery("SELECT * FROM Registers").ToList; * */ }