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