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