public ActionResult NewGrade(Tbl_Grade grade) { var getClass = db.Tbl_Class.Where(m => m.ClassId == grade.Tbl_Class.ClassId).FirstOrDefault(); grade.Tbl_Class = getClass; var getStudent = db.Tbl_Student.Where(m => m.StudentId == grade.Tbl_Student.StudentId).FirstOrDefault(); grade.Tbl_Student = getStudent; // calculate grade average decimal average = (Convert.ToDecimal(grade.Exam1) + Convert.ToDecimal(grade.Exam2) + Convert.ToDecimal(grade.Exam3) + Convert.ToDecimal(grade.Project)) / 4; grade.Average = average; //calculate status if (average >= 45) { grade.Status = true; } else { grade.Status = false; } db.Tbl_Grade.Add(grade); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult UpdateGrade(Tbl_Grade grade) { var val = db.Tbl_Grade.Find(grade.GradeId); //class var gradeClass = db.Tbl_Class.Where(m => m.ClassId == grade.Tbl_Class.ClassId).FirstOrDefault(); val.ClassId = gradeClass.ClassId; //student var gradeStudent = db.Tbl_Student.Where(m => m.StudentId == grade.Tbl_Student.StudentId).FirstOrDefault(); val.StudentId = gradeStudent.StudentId; val.Exam1 = grade.Exam1; val.Exam2 = grade.Exam2; val.Exam3 = grade.Exam3; val.Project = grade.Project; decimal average = (Convert.ToDecimal(grade.Exam1) + Convert.ToDecimal(grade.Exam2) + Convert.ToDecimal(grade.Exam3) + Convert.ToDecimal(grade.Project)) / 4; val.Average = average; if (average >= 45) { val.Status = true; } else { val.Status = false; } db.SaveChanges(); return(RedirectToAction("Index")); }