public ActionResult Create(StudentEnrolledCourse studentEnrolledCourse)
{
if (ModelState.IsValid)
{
if (!CourseValidation(studentEnrolledCourse))
{
studentEnrolledCourse.IsEnrolled = true;
db.StudentEnrolledCourses.Add(studentEnrolledCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.CourseEnrolled = "Course Enrolled";
var student = db.Students.Find(studentEnrolledCourse.StudentId);
var courseList = db.Courses.ToList().FindAll(c => c.DepartmentId == student.DepartmentId);
ViewBag.CourseId = new SelectList(courseList, "CourseId", "CourseCode");
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentRegistrationNumber");
return(View(studentEnrolledCourse));
}
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", studentEnrolledCourse.CourseId);
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentRegistrationNumber", studentEnrolledCourse.StudentId);
return(View(studentEnrolledCourse));
}
public ActionResult DeleteConfirmed(int id)
{
StudentEnrolledCourse studentEnrolledCourse = db.StudentEnrolledCourses.Find(id);
db.StudentEnrolledCourses.Remove(studentEnrolledCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "EnrolledId,StudentId,StudentName,StudentEmail,StudentDepartment,CourseId,EnrolledDate,GradeLetter")] StudentEnrolledCourse studentEnrolledCourse)
{
if (ModelState.IsValid)
{
db.Entry(studentEnrolledCourse).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", studentEnrolledCourse.CourseId);
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentName", studentEnrolledCourse.StudentId);
return(View(studentEnrolledCourse));
}
// To enroll course to student//
public bool SaveEnrollCourse(StudentCourseEnroll StudentEnrolled)
{
StudentEnrolledCourse enroll = new StudentEnrolledCourse();
enroll.StudentID = StudentEnrolled.StudentID;
enroll.CourseID = StudentEnrolled.CourseID;
enroll.enrolledDate = StudentEnrolled.Dates;
dbContext.StudentEnrolledCourses.Add(enroll);
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
// GET: StudentEnrolledCourse/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentEnrolledCourse studentEnrolledCourse = db.StudentEnrolledCourses.Find(id);
if (studentEnrolledCourse == null)
{
return(HttpNotFound());
}
return(View(studentEnrolledCourse));
}
// GET: StudentEnrolledCourse/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentEnrolledCourse studentEnrolledCourse = db.StudentEnrolledCourses.Find(id);
if (studentEnrolledCourse == null)
{
return(HttpNotFound());
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", studentEnrolledCourse.CourseId);
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentName", studentEnrolledCourse.StudentId);
return(View(studentEnrolledCourse));
}
public ActionResult SaveStudentResult([Bind(Include = "StudentId,StudentName,StudentEmail,StudentDepartment,CourseId,EnrolledDate,GradeLetter")] StudentEnrolledCourse studentEnrolledCourse)
{
var studentEnrolledCourses = db.StudentEnrolledCourses.Where(x => x.IsEnrolled == true);
StudentEnrolledCourse aStudentEnrolledCourse = studentEnrolledCourses.ToList().Find(x => (x.StudentId == studentEnrolledCourse.StudentId) && (x.CourseId == studentEnrolledCourse.CourseId));
if (studentEnrolledCourse.CourseId != 0)
{
aStudentEnrolledCourse.GradeLetter = studentEnrolledCourse.GradeLetter;
if (ModelState.IsValid)
{
db.Entry(aStudentEnrolledCourse).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ViewResult"));
}
}
var courseList = (db.StudentEnrolledCourses.Include(m => m.Course).Select(n => new { StudentId = n.StudentId, CourseId = n.CourseId, CourseCode = n.Course.CourseCode, IsEnrolled = n.IsEnrolled })).ToList().FindAll(x => (x.StudentId == studentEnrolledCourse.StudentId) && (x.IsEnrolled == true));
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", studentEnrolledCourse.CourseId);
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "StudentRegistrationNumber", studentEnrolledCourse.StudentId);
return(View(studentEnrolledCourse));
}
public bool CourseValidation(StudentEnrolledCourse aStudentEnrolledCourse)
{
return(IsCourseExists(aStudentEnrolledCourse.CourseId, aStudentEnrolledCourse.StudentId));
}
