// Catalogue Students
public ICollection <Student> GetAllCatalogueStudents(int schoolId, int catalogueId)
{
Domain.Catalogue catalogue = _context.Catalogues.Where(c => c.SchoolId == schoolId)
.Include(c => c.Students).FirstOrDefault(c => c.Id == catalogueId);
return((ICollection <Student>)_mapper.Map <IEnumerable <Student> >(catalogue.Students));
}
public void UpdateCatalogue(Catalogue catalogue, CatalogueDTO catalogueDTO)
{
Domain.Catalogue updateCatalogue = _context.Catalogues.FirstOrDefault(c => c.Id == catalogue.Id);
updateCatalogue.Name = catalogueDTO.Name;
_context.SaveChanges();
}
public Student GetCatalogueStudent(int id, int schoolId, int catalogueId)
{
Domain.Catalogue catalogue = _context.Catalogues.Where(c => c.SchoolId == schoolId)
.Include(c => c.Students).FirstOrDefault(c => c.Id == catalogueId);
Domain.Student student = catalogue.Students.FirstOrDefault(s => s.Id == id);
return(_mapper.Map <Student>(student));
}
public void DeleteCatalogueCourse(Course course, int schoolId, int catalogueId)
{
Domain.Catalogue catalogue = _context.Catalogues.Where(c => c.SchoolId == schoolId)
.Include(c => c.CourseCatalogues).FirstOrDefault(c => c.Id == catalogueId);
Domain.CourseCatalogue deleteCatalogueCourse = catalogue.CourseCatalogues
.FirstOrDefault(cc => cc.CourseId == course.Id);
catalogue.CourseCatalogues.Remove(deleteCatalogueCourse);
_context.SaveChanges();
}
public void DeleteCatalogueMentor(Mentor mentor, int schoolId, int catalogueId)
{
Domain.Catalogue catalogue = _context.Catalogues.Where(c => c.SchoolId == schoolId)
.Include(c => c.MentorCatalogues).FirstOrDefault(c => c.Id == catalogueId);
Domain.MentorCatalogue deleteCatalogueMentor = catalogue.MentorCatalogues
.FirstOrDefault(mc => mc.MentorId == mentor.Id);
catalogue.MentorCatalogues.Remove(deleteCatalogueMentor);
_context.SaveChanges();
}
public Catalogue AddCatalogue(Catalogue catalogue, int schoolId)
{
Domain.Catalogue newCatalogue = new Domain.Catalogue()
{
Name = catalogue.Name,
SchoolId = schoolId
};
_context.Catalogues.Add(newCatalogue);
_context.SaveChanges();
catalogue.Id = newCatalogue.Id;
return(catalogue);
}
public Course AddCatalogueCourse(Course course, int schoolId, int catalogueId)
{
Domain.CourseCatalogue newCourseCatalogue = new Domain.CourseCatalogue()
{
CourseId = course.Id,
CatalogueId = catalogueId
};
Domain.Catalogue catalogue = _context.Catalogues.Where(c => c.SchoolId == schoolId)
.FirstOrDefault(c => c.Id == catalogueId);
catalogue.CourseCatalogues.Add(newCourseCatalogue);
_context.SaveChanges();
return(course);
}
public Mentor AddCatalogueMentor(Mentor mentor, int schoolId, int catalogueId)
{
Domain.MentorCatalogue newCatalogueMentor = new Domain.MentorCatalogue()
{
MentorId = mentor.Id,
CatalogueId = catalogueId
};
Domain.Catalogue catalogue = _context.Catalogues.Where(c => c.SchoolId == schoolId)
.FirstOrDefault(c => c.Id == catalogueId);
catalogue.MentorCatalogues.Add(newCatalogueMentor);
_context.SaveChanges();
return(mentor);
}
public void DeleteCatalogue(Catalogue catalogue, int schoolId)
{
Domain.Catalogue deleteCatalogue = _context.Catalogues.Include(c => c.CourseCatalogues)
.Include(c => c.MentorCatalogues).FirstOrDefault(c => c.Id == catalogue.Id);
//A. delete catalogue grades
List <Domain.Grade> deleteGrades = _context.Grades.Where(g => g.CatalogueId == catalogue.Id).ToList();
_context.Grades.RemoveRange(deleteGrades);
_context.SaveChanges();
//B. delete catalogues students
List <Domain.Student> deleteStudents = _context.Students.Where(s => s.CatalogueId == catalogue.Id).ToList();
foreach (Domain.Student student in deleteStudents)
{
student.CatalogueId = null;
}
_context.SaveChanges();
_context.Catalogues.Remove(deleteCatalogue);
_context.SaveChanges();
}
