public static void CoursesAvailableForStudent(string id)
{
int level = context.students.FirstOrDefault(s => s.student_ID == id).student_level;
List <course> coursesAvailabaleForStudent = (from c in context.courses
where c.course_level == level
select c).ToList();
//List<string> RemainingCourses = (from c in context.student_available_course
// where c.student_ID == id
// select c.course_ID).ToList();
//List<prequest_course> PC = context.prequest_course.ToList();
//foreach (var item in coursesAvailabaleForStudent)
//{
// foreach (var itemPC in PC)
// {
// if ()
//}
//}
foreach (var item in coursesAvailabaleForStudent)
{
student_available_course SAC = new student_available_course();
SAC.student_ID = id;
SAC.course_ID = item.course_code;
context.student_available_course.Add(SAC);
context.SaveChanges();
}
}
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 ActionResult registerToStudent(string id, CoursesAvailabelToStudentViewModel CATS)
{
foreach (var item in CATS.coursesAvailableList)
{
student_available_course SAC = new student_available_course();
SAC.course_ID = context.courses.FirstOrDefault(c => c.course_name == item).course_code;
SAC.student_ID = context.students.FirstOrDefault(s => s.student_ID == id).student_ID;
context.student_available_course.Add(SAC);
context.SaveChanges();
}
return(RedirectToAction("getStudent"));
}