public ActionResult DeleteConfirmed(int id)
{
ModuleRating moduleRating = db.ModuleRating.Find(id);
db.ModuleRating.Remove(moduleRating);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,ModuleID,EnrollmentID,LabRate,TestRate")] ModuleRating moduleRating)
{
if (ModelState.IsValid)
{
db.Entry(moduleRating).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EnrollmentID = new SelectList(db.Enrollments, "ID", "ID", moduleRating.EnrollmentID);
ViewBag.ModuleID = new SelectList(db.Modules, "ID", "Title", moduleRating.ModuleID);
return(View(moduleRating));
}
// GET: ModuleRatings/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ModuleRating moduleRating = db.ModuleRating.Find(id);
if (moduleRating == null)
{
return(HttpNotFound());
}
return(View(moduleRating));
}
// GET: ModuleRatings/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ModuleRating moduleRating = db.ModuleRating.Find(id);
if (moduleRating == null)
{
return(HttpNotFound());
}
ViewBag.EnrollmentID = new SelectList(db.Enrollments, "ID", "ID", moduleRating.EnrollmentID);
ViewBag.ModuleID = new SelectList(db.Modules, "ID", "Title", moduleRating.ModuleID);
return(View(moduleRating));
}
// GET: Students/Details/5
public ActionResult Details(int id, int?selectedCourse)
{
Student student = context.Students
.Include(s => s.User)
.Include(s => s.Enrollments)
.Include(s => s.Enrollments.Select(e => e.Course))
.Include(s => s.Enrollments.Select(e => e.Course.Instructor))
.Include(s => s.Enrollments.Select(e => e.Course.Instructor.User))
.FirstOrDefault(s => s.ID == id);
if (selectedCourse.HasValue)
{
List <Module> modulesDM = context
.Courses
.Include(c => c.Modules)
.FirstOrDefault(c => c.ID == selectedCourse)
.Modules.ToList();
List <StudentRatingVM> modules = new List <StudentRatingVM>();
Enrollment enr = context.Enrollments.FirstOrDefault(e => e.CourseID == selectedCourse && e.StudentID == id);
foreach (Module module in modulesDM)
{
ModuleRating rating = context.ModuleRating.FirstOrDefault(mr => mr.EnrollmentID == enr.ID && mr.ModuleID == module.ID);
modules.Add(new StudentRatingVM {
Module = module, LabRate = rating?.LabRate, TestRate = rating?.TestRate
});
}
ViewBag.Modules = modules;
}
//List<Course>
if (student == null)
{
return(HttpNotFound());
}
return(View("Details", student));
}
