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