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