public void UpdateMentor(Mentor mentor, PersonDTO personDTO)
{
Domain.Mentor updateMentor = _context.Mentors.FirstOrDefault(m => m.Id == mentor.Id);
updateMentor.Name = personDTO.Name;
updateMentor.Photo = personDTO.Photo;
updateMentor.BirthDate = personDTO.BirthDate;
_context.SaveChanges();
}
public Mentor GetCatalogueMentor(int id, int schoolId, int catalogueId)
{
var catalogue = _context.Catalogues.Select(c => new
{
Catalogue = c,
Mentors = c.MentorCatalogues.Select(mc => mc.Mentor),
}).Where(c => c.Catalogue.SchoolId == schoolId)
.FirstOrDefault(c => c.Catalogue.Id == catalogueId);
Domain.Mentor mentor = catalogue.Mentors.FirstOrDefault(m => m.Id == id);
return(_mapper.Map <Mentor>(mentor));
}
public Mentor AddMentor(Mentor mentor, int schoolId)
{
Domain.Mentor newMentor = new Domain.Mentor()
{
Name = mentor.Name,
Photo = mentor.Photo,
BirthDate = mentor.BirthDate,
AccessRights = (Domain.AccessRights)mentor.AccessRights,
SchoolId = schoolId
};
_context.Mentors.Add(newMentor);
_context.SaveChanges();
mentor.Id = newMentor.Id;
return(mentor);
}
public void DeleteMentor(Mentor mentor, int schoolId)
{
// firstly, delete mentor in catalogues
List <Domain.Catalogue> catalogues = _context.Catalogues
.Include(c => c.MentorCatalogues).Where(c => c.SchoolId == schoolId).ToList();
List <Domain.MentorCatalogue> deleteMentorCatalogues = catalogues
.SelectMany(c => c.MentorCatalogues).Where(mc => mc.MentorId == mentor.Id).ToList();
_context.RemoveRange(deleteMentorCatalogues);
_context.SaveChanges();
// secondly, delete mentor in school
Domain.Mentor deleteMentor = _context.Mentors.FirstOrDefault(m => m.Id == mentor.Id);
_context.Mentors.Remove(deleteMentor);
_context.SaveChanges();
}
public Mentor GetMentor(int id, int schoolId)
{
Domain.Mentor mentor = _context.Mentors.Where(m => m.SchoolId == schoolId).FirstOrDefault(m => m.Id == id);
return(_mapper.Map <Mentor>(mentor));
}
