public void AddStudentToCourse(int studentId, int courseId) { StudentCourses studentCourses = new StudentCourses() { CourseId = courseId, StudentId = studentId }; try { data.studentCourses.Add(studentCourses); } catch (Exception ex) { logger.Log(ex.Message); } }
public Courses CreateCourse(Courses course) { try { if (course != null) { data.courses.Add(course); } else { return(null); } } catch (Exception ex) { logger.Log(ex.Message);; } return(course); }
public Students CreateStudent(Students student) { try { if (student != null) { data.students.Add(student); } else { return(null); } } catch (Exception ex) { logger.Log(ex.Message); } return(student); }
public IActionResult Report() { logger.Log("works good"); var studentsList = university.GetAllStudents(); var courseList = university.GetAllCourses(); var relations = university.GetAllRelations(); var reportDetails = report.ReportStudentCourseRelation(studentsList, courseList, relations); return(View(reportDetails)); }
public IEnumerable <StudentCourseReportViewModel> ReportStudentCourseRelation(List <Students> studentsList, List <Courses> courseList, List <StudentCourses> relations) { try { var report = (from r in relations join s in studentsList on r.StudentId equals s.StudentId join c in courseList on r.CourseId equals c.CourseID select new StudentCourseReportViewModel { Student = s.FirstName + " " + s.LastName, Course = c.CourseName }).AsEnumerable(); return(report); } catch (Exception ex) { logger.Log(ex.Message); return(null); } }