public DbStatus AddParticipantToStudyDB(int partID, int studyID) { DbStatus manageParticipantStatus = new DbStatus(); Studyparticipant studpart = _context.Studyparticipant.FirstOrDefault(x => x.IdStudy == studyID && x.IdParticipant == partID); if (studpart == null) { Participant participant = _context.Participant.FirstOrDefault(part => part.IdParticipant == partID); if (participant != null) { //Participant exists, but is not enrolled. studpart = new Studyparticipant(); studpart.IdParticipant = partID; studpart.IdStudy = studyID; _context.Studyparticipant.Add(studpart); _context.SaveChanges(); manageParticipantStatus.success = true; } else { //Participant with this ID does not exists. manageParticipantStatus.success = false; manageParticipantStatus.errormessage = "Participant with this ID does not exist in the system"; } } else { //Participant allready enrolled in study manageParticipantStatus.success = false; manageParticipantStatus.errormessage = "Participant is already enrolled instudy."; } return(manageParticipantStatus); }
public DbStatus RemoveParticipantFromStudyDB(int partID, int studyID) { DbStatus manageParticipantStatus = new DbStatus(); Studyparticipant studPart = _context.Studyparticipant.FirstOrDefault(x => x.IdParticipant == partID && x.IdStudy == studyID); if (studPart != null) { //Participant is enrolled in study _context.Studyparticipant.Remove(studPart); _context.SaveChanges(); manageParticipantStatus.success = true; } else { //Participant is not enrolled in study manageParticipantStatus.errormessage = "Participant is not enrolled in study"; manageParticipantStatus.success = false; } return(manageParticipantStatus); }