public async Task <IActionResult> ExamScore() { var CurrentUser = (Teacher)await _userManager.GetUserAsync(User); var Class = _context.Classes.SingleOrDefault(c => c.Id == CurrentUser.ClassId); Class.Students = _context.Students.Where(s => s.ClassId == Class.Id).ToList(); var model = new AllDepartmentsExams(); model.ScienceExams = new List <StudentExams>(); model.CommercialExams = new List <StudentExams>(); model.ArtExams = new List <StudentExams>(); int ScienceId = _context.Departments.Single(d => d.Name == "Science").Id; int CommercialId = _context.Departments.Single(d => d.Name == "Commercial").Id; int ArtId = _context.Departments.Single(d => d.Name == "Art").Id; int CurrentTermId = _context.CurrentTerm.Id; var ScienceStudents = _context.Students.Where(s => s.DepartmentId == ScienceId && s.ClassId == Class.Id); var CommercialStudents = _context.Students.Where(s => s.DepartmentId == CommercialId && s.ClassId == Class.Id); var ArtStudents = _context.Students.Where(s => s.DepartmentId == ArtId && s.ClassId == Class.Id); foreach (var student in ScienceStudents) { var StudentExams = new StudentExams(); StudentExams.StudentName = student.FullName; var Exams = _context.Exams.Where(e => e.StudentId == student.Id && e.TermId == CurrentTermId); StudentExams.Exams = Exams.Include(e => e.DepartmentSubject).ThenInclude(ds => ds.Subject).ToList(); model.ScienceExams.Add(StudentExams); } foreach (var student in CommercialStudents) { var StudentExams = new StudentExams(); StudentExams.StudentName = student.FullName; var Exams = _context.Exams.Where(e => e.StudentId == student.Id && e.TermId == CurrentTermId); StudentExams.Exams = Exams.Include(e => e.DepartmentSubject).ThenInclude(ds => ds.Subject).ToList(); model.CommercialExams.Add(StudentExams); } foreach (var student in ArtStudents) { var StudentExams = new StudentExams(); StudentExams.StudentName = student.FullName; var Exams = _context.Exams.Where(e => e.StudentId == student.Id && e.TermId == CurrentTermId); StudentExams.Exams = Exams.Include(e => e.DepartmentSubject).ThenInclude(ds => ds.Subject).ToList(); model.ArtExams.Add(StudentExams); } return(View(model)); }
public async Task SaveAllUpdatesStudentExams() { ValidationErrors = null; try { await _studentExamService.Update(StudentExams.Select(_ => _.StudentExam).ToList()); StudentExams.ForEach(_ => _.Changed = false); } catch (ValidationPropertyException vpe) { ValidationErrors = vpe.ErrorsList.ToList(); } catch (ValidationException ve) { ValidationErrors = ve.Errors.ToList(); } }
public IActionResult ClassExams(int Id) { var Class = _db.Classes.Find(Id); Class.Students = _db.Students.Where(s => s.ClassId == Class.Id).ToList(); var model = new AllDepartmentsExams(); model.ScienceExams = new List <StudentExams>(); model.CommercialExams = new List <StudentExams>(); model.ArtExams = new List <StudentExams>(); int ScienceId = _db.Departments.Single(d => d.Name == "Science").Id; int CommercialId = _db.Departments.Single(d => d.Name == "Commercial").Id; int ArtId = _db.Departments.Single(d => d.Name == "Art").Id; int CurrentTermId = _db.CurrentTerm.Id; var ScienceStudents = _db.Students.Where(s => s.DepartmentId == ScienceId && s.ClassId == Class.Id); var CommercialStudents = _db.Students.Where(s => s.DepartmentId == CommercialId && s.ClassId == Class.Id); var ArtStudents = _db.Students.Where(s => s.DepartmentId == ArtId && s.ClassId == Class.Id); foreach (var student in ScienceStudents) { var StudentExams = new StudentExams(); StudentExams.StudentName = student.FullName; var Exams = _db.Exams.Where(e => e.StudentId == student.Id && e.TermId == CurrentTermId); StudentExams.Exams = Exams.Include(e => e.DepartmentSubject).ThenInclude(ds => ds.Subject).ToList(); model.ScienceExams.Add(StudentExams); } foreach (var student in CommercialStudents) { var StudentExams = new StudentExams(); StudentExams.StudentName = student.FullName; var Exams = _db.Exams.Where(e => e.StudentId == student.Id && e.TermId == CurrentTermId); StudentExams.Exams = Exams.Include(e => e.DepartmentSubject).ThenInclude(ds => ds.Subject).ToList(); model.CommercialExams.Add(StudentExams); } foreach (var student in ArtStudents) { var StudentExams = new StudentExams(); StudentExams.StudentName = student.FullName; var Exams = _db.Exams.Where(e => e.StudentId == student.Id && e.TermId == CurrentTermId); StudentExams.Exams = Exams.Include(e => e.DepartmentSubject).ThenInclude(ds => ds.Subject).ToList(); model.ArtExams.Add(StudentExams); } return(View(model)); }
/// <summary> /// We have implemented the properties and variable stuffs /// </summary> private static void StudentExample() { Console.WriteLine("Student s1"); var s1 = new StudentExams(); s1.EnglishMarks = 21; s1.MathMarks = 30; Console.WriteLine("Total => " + s1.TotalMarks); Console.WriteLine("Percentage => " + s1.Percentage); Console.WriteLine("Division => " + s1.Division); Console.WriteLine("Student s2"); var s2 = new StudentExams(); s2.EnglishMarks = 19; s2.MathMarks = 3; Console.WriteLine("Total => " + s2.TotalMarks); Console.WriteLine("Percentage => " + s2.Percentage); Console.WriteLine("Division => " + s2.Division); s1.Display(); }