public ActionResult insertDegreesToStudent(student_degree SD, string status) { if (context.students.FirstOrDefault(s => s.student_ID == SD.student_ID) != null && context.courses.FirstOrDefault(c => c.course_code == SD.course_ID) != null && (SD.activites + SD.midterm + SD.practical <= 50) && (SD.activites + SD.final + SD.midterm + SD.practical <= 100)) { student_degree newSD = new student_degree { student_ID = SD.student_ID, course_ID = SD.course_ID, final = SD.final, practical = SD.practical, midterm = SD.midterm, activites = SD.activites }; newSD.GPA = Convert.ToDecimal(CoursesFCI.CalGPA(Convert.ToDouble(newSD.activites + newSD.final + newSD.midterm + newSD.practical))); newSD.appreciation = CoursesFCI.CalAppreciation(Convert.ToDouble(newSD.GPA)); context.student_degree.Add(newSD); context.SaveChanges(); bool isSuccess = CoursesFCI.isSuccess(newSD.appreciation); if (isSuccess) { student_available_course RemoveCourse = context.student_available_course.FirstOrDefault(c => c.course_ID == newSD.course_ID); context.student_available_course.Remove(RemoveCourse); context.SaveChanges(); } if (status == "true") { } return(RedirectToAction("../studentInformation/operationsucceeded")); } return(View("insertDegreesToStudent")); }
public static void EndTerm(student_degree SD) { student_case_report SCR = new student_case_report() { student_ID = SD.student_ID, course_ID = SD.course_ID, appreciation = SD.appreciation, GPA = SD.GPA.Value, total_degree = (SD.midterm.Value + SD.practical.Value + SD.activites.Value + SD.final.Value) }; context.student_case_report.Add(SCR); if (SD.student.student_term == 1) { //ممكن تطلع غلط SD.student.student_term++; } else { SD.student.student_level++; } context.SaveChanges(); }