public ActionResult Student(Account account)
{
var StudentsDal = new StudentsDal();
var username = account.ID;
var StudentsUser = (from x in StudentsDal.Students where x.ID.Equals(username) select x).ToList <Student>();
var StudentCourseDal = new StudentCourseDal();
var studentCourseObj = (from x in StudentCourseDal.StudentCourses where x.StudentID.Equals(username) select x).ToList <StudentCourse>();
var CoursesDal = new CoursesDal();
List <Courses> CourseDetail = new List <Courses>();
Courses t = new Courses();
foreach (StudentCourse y in studentCourseObj)
{
t = (from x in CoursesDal.Courses where x.CourseName.Equals(y.CourseName) select x).FirstOrDefault <Courses>();
CourseDetail.Add(t);
}
Student student = new Student()
{
ID = account.ID,
FirstName = StudentsUser[0].FirstName,
LastName = StudentsUser[0].LastName,
};
StudentViewModel studentViewModel = new StudentViewModel()
{
student = student,
courses = CourseDetail,
studentCourses = studentCourseObj
};
return(View(studentViewModel));
}
public ActionResult ShowStudents(string CourseName)
{
string courseName = CourseName;
CourseN = courseName;
var StudentCourseDal = new StudentCourseDal();
var StudentCourseObj = (from x in StudentCourseDal.StudentCourses where x.CourseName.Equals(courseName) select x).ToList <StudentCourse>();
return(View("ShowStudents", StudentCourseObj));
}
public ActionResult UpdateGrade(string StudentID, string Grade)
{
string studentID = StudentID;
string newGrade = Grade;
var StudentCourseDal = new StudentCourseDal();
var StudentCourseObj = (from x in StudentCourseDal.StudentCourses where x.CourseName.Equals(CourseN) select x).ToList <StudentCourse>();
foreach (StudentCourse sc in StudentCourseDal.StudentCourses)
{
if (sc.CourseName == CourseN && sc.StudentID == studentID)
{
sc.Grade = int.Parse(newGrade);
}
}
StudentCourseDal.SaveChanges();
return(View("ShowStudents", StudentCourseObj));
}
public ActionResult StudentToCourse(string StudentID, string CourseName)
{
var LecturerDal = new LecturerDal();
var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>();
var StudentCourseDal = new StudentCourseDal();
var FacultyDal = new FacultyDal();
var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(faculy_id) select x).ToList <Faculty>();
var CourseDal = new CoursesDal();
var CourseObj = (from x in CourseDal.Courses select x).ToList <Courses>();
var StudentsDal = new StudentsDal();
var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>();
Faculty faculty = new Faculty()
{
ID = faculy_id,
FirstName = FacultyObj[0].FirstName,
LastName = FacultyObj[0].LastName
};
FacultyViewModel facultyViewModel = new FacultyViewModel()
{
faculty = faculty,
Coursesdata = CourseObj,
Studentsdata = StudentsObj,
LecturersData = LecturerObj
};
StudentCourse sc = new StudentCourse()
{
CourseName = CourseName,
StudentID = StudentID,
};
if (StudentCourseDal.StudentCourses.Find(sc.StudentID, sc.CourseName) == null)
{
StudentCourseDal.StudentCourses.Add(sc);
StudentCourseDal.SaveChanges();
}
else
{
ViewBag.ErrorMessage2 = "This student is already assigned to this course!";
return(View("Faculty", facultyViewModel));
}
return(View("Faculty", facultyViewModel));
}