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