public bool AddEnrolledCourses(EnrolledCourse enrolledCourse) { try { var result1 = from c in context.EnrolledCourses where c.StudentEmail == enrolledCourse.StudentEmail && c.Name == enrolledCourse.Name select c; if (result1.Count() == 0) { context.EnrolledCourses.Add(enrolledCourse); int result = context.SaveChanges(); if (result > 0) { return(true); } } return(false); } catch (Exception e) { throw; } }
//Course registration #region Course registration public ActionResult SaveCourses(int id, int sessId) { ViewBag.CourseRegistration = "active-menu"; var enrollment = db.Enrollments.FirstOrDefault(x => x.EnrollmentId == id); var courses = db.Course.Where(x => x.DepartmentID == enrollment.DepartmentId && x.SessionId == sessId); var enrolledcourses = db.EnrolledCourses.FirstOrDefault(p => p.EnrollmentId == id); //Check if enrolled courses has been created? if (enrolledcourses == null) { try { foreach (var item in courses) { EnrolledCourse enrolledCourse = db.EnrolledCourses.Create(); enrolledCourse.CourseID = item.CourseID; enrolledCourse.EnrollmentId = enrollment.EnrollmentId; enrolledCourse.Grade = ""; enrolledCourse.Remark = "Not Entered"; enrolledCourse.TestScore = 0; enrolledCourse.ExamScore = 0; enrolledCourse.TotalScore = 0; db.EnrolledCourses.Add(enrolledCourse); } db.SaveChanges(); } catch { throw; } } return(RedirectToAction("CourseRegistration", new { id = id })); }
public ActionResult DeleteConfirmed2(int enrollmentId, int id) { var course = db.EnrolledCourses.Include(p => p.Course); EnrolledCourse enrolledcourses = db.EnrolledCourses.Find(id); db.EnrolledCourses.Remove(enrolledcourses); db.SaveChanges(); return(RedirectToAction("CourseRegistration", new { id = enrollmentId })); }
public ActionResult DeleteNormalCourse(int enrollmentId, int id = 0) { ViewBag.CourseRegistration = "active-menu"; EnrolledCourse enrolledcourses = db.EnrolledCourses.Find(id); if (enrolledcourses == null) { return(HttpNotFound()); } return(View(enrolledcourses)); }
public IActionResult ChangeCourseStatus(int id, string UserEmail, [FromBody] EnrolledCourse enrolledCourse) { if (ModelState.IsValid && id == enrolledCourse.Id) { bool result = repository.ChangeCourseStatus(enrolledCourse, UserEmail); if (result) { return(Created("UpdatedCourse", enrolledCourse.Id)); } } return(BadRequest(ModelState)); }
public IActionResult Post([FromBody] EnrolledCourse enrolledCourse) { if (ModelState.IsValid) { bool result = repository.AddEnrolledCourses(enrolledCourse); if (result) { return(Created("AddCoursesEnrolled", enrolledCourse)); } return(BadRequest(new { Message = "You have already Enrolled for This Course." })); //return StatusCode(StatusCodes.Status500InternalServerError); } return(BadRequest(ModelState)); }
public async Task <bool> ChangeCourseStatusAsync(EnrolledCourse enrolledCourse, string UserEmail) { try { if (UserEmail == enrolledCourse.MentorEmail) { if (enrolledCourse.Status == "Requested") { enrolledCourse.Status = "Request Accepted"; } else if (enrolledCourse.Status == "In Progress") { enrolledCourse.Status = "Completed"; } context.EnrolledCourses.Update(enrolledCourse); int result = await context.SaveChangesAsync(); if (result > 0) { return(true); } } else if (UserEmail == enrolledCourse.StudentEmail && enrolledCourse.Status == "Request Accepted") { enrolledCourse.Status = "In Progress"; context.EnrolledCourses.Update(enrolledCourse); int result = await context.SaveChangesAsync(); if (result > 0) { return(true); } } return(false); } catch (Exception) { throw; } }
public ActionResult EnrollInCourse(int id) { var currentUserId = User.Identity.GetUserId(); // var CourseId = (int)Session["CourseId"]; var EnrolledCourse = _context.EnrolledCourses.Where(c => c.CourseId == id).SingleOrDefault(a => a.StudentId == currentUserId); if (EnrolledCourse != null) { return(Content("You are already enrolled in the course")); } var enroll = new EnrolledCourse(); enroll.CourseId = id; enroll.StudentId = currentUserId; _context.EnrolledCourses.Add(enroll); _context.SaveChanges(); return(View()); }