public void UpdateSubject(Subject subject, SubjectDTO subjectDTO)
{
Domain.Subject updateSubject = _context.Subjects.FirstOrDefault(s => s.Id == subject.Id);
updateSubject.Name = subjectDTO.Name;
_context.SaveChanges();
}
public Subject AddSubject(Subject subject, int schoolId)
{
Domain.Subject newSubject = new Domain.Subject()
{
Name = subject.Name,
SchoolId = schoolId
};
_context.Subjects.Add(newSubject);
_context.SaveChanges();
subject.Id = newSubject.Id;
return(subject);
}
public Course GetCatalogueCourse(int id, int schoolId, int catalogueId)
{
var course = _context.Catalogues.Select(c => new
{
Catalogue = c,
Course = c.CourseCatalogues.Select(cc => cc.Course).FirstOrDefault(c => c.Id == id),
Subjects = c.CourseCatalogues.Select(cc => cc.Course).Select(c => c.Subject)
}).Where(c => c.Catalogue.SchoolId == schoolId).FirstOrDefault(c => c.Catalogue.Id == catalogueId);
Course courseModel = _mapper.Map <Course>(course.Course);
Domain.Subject subject = course.Subjects.FirstOrDefault(s => s.Id == course.Course.SubjectId);
courseModel.Subject = _mapper.Map <Subject>(subject);
return(courseModel);
}
// Catalogue Courses
public ICollection <Course> GetAllCatalogueCourses(int schoolId, int catalogueId)
{
var catalogue = _context.Catalogues.Select(c => new
{
Catalogue = c,
Courses = c.CourseCatalogues.Select(cc => cc.Course),
Subjects = c.CourseCatalogues.Select(cc => cc.Course).Select(c => c.Subject)
}).Where(c => c.Catalogue.SchoolId == schoolId)
.FirstOrDefault(c => c.Catalogue.Id == catalogueId);
List <Course> courses = new List <Course>();
foreach (var catalogueCourse in catalogue.Courses)
{
Course courseModel = _mapper.Map <Course>(catalogueCourse);
Domain.Subject subject = catalogue.Subjects.FirstOrDefault(s => s.Id == catalogueCourse.SubjectId);
courseModel.Subject = _mapper.Map <Subject>(subject);
courses.Add(courseModel);
}
return(courses);
}
public void DeleteSubject(Subject subject, int schoolId)
{
Domain.Subject deleteSubject = _context.Subjects.FirstOrDefault(s => s.Id == subject.Id);
_context.Subjects.Remove(deleteSubject);
_context.SaveChanges();
}
public Subject GetSubject(int id, int schoolId)
{
Domain.Subject subject = _context.Subjects.FirstOrDefault(sbj => sbj.Id == id);
return(_mapper.Map <Subject>(subject));
}
