public IActionResult Register(Exam exam) { var emc = new ExamManagementContext(); var loggedStudent = emc.Students.Where(s => s.UserName == User.Identity.Name).First(); var regExams = emc.RegExam.Where(e => e.studentID == loggedStudent.studentID).ToList(); var matchedExam = regExams.Where(e => e.examID == exam.examID); RegExam updatedExam = new RegExam(); if (matchedExam.Count() > 0) { updatedExam = matchedExam.First(); updatedExam.withdraw = "0"; } else { updatedExam.examID = exam.examID; updatedExam.studentID = loggedStudent.studentID; updatedExam.registered = "1"; updatedExam.publish = "0"; updatedExam.withdraw = "0"; } emc.Update(updatedExam); emc.SaveChanges(); return(RedirectToAction("AvailExams")); }
public IActionResult AvailExams() { var emc = new ExamManagementContext(); var allExams = emc.Exams.ToList(); var loggedStudent = emc.Students.Where(s => s.UserName == User.Identity.Name).First(); var regExams = emc.RegExam.Where(e => e.studentID == loggedStudent.studentID).ToList(); regExams.RemoveAll(w => w.withdraw == "1"); var blockedExams = regExams.Select(e => e.Exam).ToList(); var availExams = allExams.Except(blockedExams); return(View(availExams)); }
public FacultyController(ExamManagementContext context, ExamManagementContextSeedData seeder) { _context = context; _seeder = seeder; }
public StudentsController(ExamManagementContext context, ExamManagementContextSeedData seeder) { _context = context; _seeder = seeder; }
public HomeController(ILogger <HomeController> logger, ExamManagementContext db) { _logger = logger; _db = db; }
public QuestionController(ExamManagementContext db) { context = db; }
public ExamsController(ExamManagementContext context) { _context = context; }
public ExamRegistrationController(ExamManagementContext context) { _context = context; }
public ExamController(ExamManagementContext db) { _db = db; }