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