public ActionResult CreateOne(GradeBookModel gradeBookModel) { if (!this.User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } gradeBookModel.StudentModels = db.studentModels.Find(gradeBookModel.student_Id); gradeBookModel.class_Id = gradeBookModel.StudentModels.class_Id; gradeBookModel.TaskModel = db.taskModel.Find(gradeBookModel.task_Id); gradeBookModel.TaskModel.points = gradeBookModel.TaskModel.points; if (ModelState.IsValid) { if (gradeBookModel.TaskModel.points < gradeBookModel.pointsEarned) { gradeBookModel.pointsEarned = gradeBookModel.TaskModel.points; } if (gradeBookModel.pointsEarned < 0) { gradeBookModel.pointsEarned = 0; } db.gradeBookModel.Add(gradeBookModel); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.student_Id = new SelectList(db.studentModels, "student_Id", "fName", gradeBookModel.student_Id); ViewBag.task_Id = new SelectList(db.taskModel, "task_Id", "taskName", gradeBookModel.task_Id); return(View(gradeBookModel)); }
public ActionResult Edit(GradeBookModel gradeBookModel) { if (!this.User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } if (gradeBookModel.assignment_notes == null) { gradeBookModel.assignment_notes = ""; } if (ModelState.IsValid) { if (gradeBookModel.pointsEarned < 0) { gradeBookModel.pointsEarned = 0; } gradeBookModel.grade = Convert.ToDecimal((gradeBookModel.pointsEarned / gradeBookModel.possiblePoints) * 100); GradeBookModel grade = db.gradeBookModel.Find(gradeBookModel.grade_Id); db.gradeBookModel.Remove(grade); db.gradeBookModel.Add(gradeBookModel); db.SaveChanges(); return(RedirectToAction("Index/" + gradeBookModel.class_Id)); } ViewBag.Student = gradeBookModel.StudentModels.fName + " " + gradeBookModel.StudentModels.lName; gradeBookModel.ClassModel = db.classmodel.Find(gradeBookModel.class_Id); gradeBookModel.StudentModels = db.studentModels.Find(gradeBookModel.student_Id); gradeBookModel.TaskModel = db.taskModel.Find(gradeBookModel.task_Id); return(View(gradeBookModel)); }
public ActionResult Create(GradeBookModel gradeBookModel) { if (!this.User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { var students = db.studentModels.ToList(); foreach (StudentModels student in students) { if (student.class_Id == gradeBookModel.class_Id) { int points = db.taskModel.Find(gradeBookModel.task_Id).points; gradeBookModel.possiblePoints = points; gradeBookModel.StudentModels = student; gradeBookModel.student_Id = student.student_Id; gradeBookModel.pointsEarned = 0; db.gradeBookModel.Add(gradeBookModel); db.SaveChanges(); } } return(RedirectToAction("Index")); } ViewBag.class_Id = new SelectList(db.classmodel, "class_Id", "className", gradeBookModel.class_Id); ViewBag.task_Id = new SelectList(db.taskModel, "task_Id", "taskName", gradeBookModel.task_Id); return(View(gradeBookModel)); }
public ActionResult partialEdit(GradeBookModel gradeBookModel) { GradeBookModel grade = db.gradeBookModel.Find(gradeBookModel.grade_Id); if (grade.pointsEarned != gradeBookModel.pointsEarned || grade.assignment_notes != gradeBookModel.assignment_notes) { if (gradeBookModel.assignment_notes == null) { gradeBookModel.assignment_notes = ""; } if (gradeBookModel.pointsEarned < 0) { gradeBookModel.pointsEarned = 0; } gradeBookModel.grade = Convert.ToDecimal((gradeBookModel.pointsEarned / gradeBookModel.possiblePoints) * 100); db.gradeBookModel.Remove(grade); db.gradeBookModel.Add(gradeBookModel); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }
public ActionResult StudentDetails(int?id) { if (id == null) { return(RedirectToAction("Student_Index")); } GradeBookModel grade = db.gradeBookModel.Find(id); grade.TaskModel = db.taskModel.Find(grade.task_Id); return(View(grade)); }
public ActionResult DeleteConfirmed(int id) { if (!this.User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } GradeBookModel gradeBookModel = db.gradeBookModel.Find(id); db.gradeBookModel.Remove(gradeBookModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Student_Chart() { if (!this.User.IsInRole("Student")) { return(RedirectToAction("Index", "Home")); } string UserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); List <GradeBookModel> this_grade = new List <GradeBookModel>(); //List<TaskModel> tasks = new List<TaskModel>(); FOR TASK DROPDOWN GradeBookModel a_grade = new GradeBookModel(); var students = db.studentModels.ToList(); var grades = db.gradeBookModel.ToList(); StudentModels this_student = new StudentModels(); foreach (StudentModels student in students) { if (student.student_account_Id == UserId) { this_student = student; } } foreach (GradeBookModel grade in grades) { grade.TaskModel = new TaskModel(); grade.TaskModel = db.taskModel.Find(grade.task_Id); grade.task_Id = grade.TaskModel.task_Id; int class_possible = 0; decimal?class_total = 0; if (grade.student_Id == this_student.student_Id) { //tasks.Add(grade.TaskModel); ADD TASK TO DROPDOWN foreach (GradeBookModel grade1 in grades) { if (this_student.class_Id == grade1.class_Id) { grade.possiblePoints = grade.TaskModel.points; if (grade.task_Id == grade1.task_Id) { class_possible += grade.TaskModel.points; class_total += grade1.pointsEarned; } } } grade.grade = (class_total / class_possible) * 100; a_grade = grade; this_grade.Add(a_grade); } } //ViewBag.task_id = new SelectList(tasks, "task_Id", "taskName"); SEND TASK DROPDOWN return(View(this_grade)); }
// GET: GradeBook/Details/5 public ActionResult Details(int?id) { if (!this.User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GradeBookModel gradeBookModel = db.gradeBookModel.Find(id); if (gradeBookModel == null) { return(HttpNotFound()); } return(View(gradeBookModel)); }
public void createGrades(TaskModel task, int class_id) { List <StudentModels> students = db.studentModels.ToList(); foreach (StudentModels student in students) { GradeBookModel grade = new GradeBookModel(); student.ClassModel = db.classmodel.Find(student.class_Id); task.CourseModels = db.coursemodels.Find(task.course_Id); if (student.class_Id == class_id) { grade.class_Id = class_id; grade.pointsEarned = null; grade.possiblePoints = task.points; grade.student_Id = student.student_Id; grade.task_Id = task.task_Id; db.gradeBookModel.Add(grade); } } }
public void createGrades(StudentModels student) { List <ClassTaskJoinModel> classTask = db.classTask.ToList(); foreach (ClassTaskJoinModel _tasks in classTask) { if (_tasks.class_id == student.class_Id) { GradeBookModel grade = new GradeBookModel(); TaskModel task = db.taskModel.Find(_tasks.task_id); grade.class_Id = student.class_Id; grade.pointsEarned = null; grade.possiblePoints = task.points; grade.student_Id = student.student_Id; grade.task_Id = _tasks.task_id; db.gradeBookModel.Add(grade); db.SaveChanges(); } } }
// GET: GradeBook/Delete/5 public ActionResult Delete(int?id) { if (!this.User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GradeBookModel gradeBookModel = db.gradeBookModel.Find(id); gradeBookModel.StudentModels = db.studentModels.Find(gradeBookModel.student_Id); gradeBookModel.TaskModel = db.taskModel.Find(gradeBookModel.task_Id); gradeBookModel.TaskModel.CourseModels = db.coursemodels.Find(gradeBookModel.TaskModel.course_Id); if (gradeBookModel == null) { return(HttpNotFound()); } return(View(gradeBookModel)); }
// GET: GradeBook/Edit/5 public ActionResult Edit(int?id) { if (!this.User.IsInRole("Admin")) { return(RedirectToAction("Index", "Home")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GradeBookModel gradeBookModel = db.gradeBookModel.Find(id); StudentModels student = db.studentModels.Find(gradeBookModel.student_Id); if (gradeBookModel == null) { return(HttpNotFound()); } ViewBag.Student = student.fName + " " + student.lName; gradeBookModel.TaskModel = db.taskModel.Find(gradeBookModel.task_Id); return(View(gradeBookModel)); }
public List <GradeBookModel> classAverage(int?class_id) { List <GradeBookModel> grade_list = new List <GradeBookModel>(); List <GradeBookModel> grades = db.gradeBookModel.ToList(); List <StudentModels> students = db.studentModels.ToList(); foreach (StudentModels student in students) { GradeBookModel grade = new GradeBookModel(); if (student.class_Id == class_id) { int possible = 0; decimal?earned = 0; grade.StudentModels = student; grade.student_Id = student.student_Id; foreach (GradeBookModel one_Grade in grades) { grade.TaskModel = new TaskModel(); if (one_Grade.student_Id == student.student_Id) { if (one_Grade.pointsEarned != null) { grade.TaskModel = db.taskModel.Find(one_Grade.task_Id); possible += one_Grade.TaskModel.points; earned += one_Grade.pointsEarned; } } } if (earned != 0) { grade.StudentModels = db.studentModels.Find(grade.student_Id); grade.pointsEarned = earned; grade.possiblePoints = possible; grade.grade = (earned / possible) * 100; grade_list.Add(grade); } } } return(grade_list); }