public DbStatus VerifyResearcherDB(int resID)
{
Researcher researcher = _context.Researcher.FirstOrDefault(res => res.IdResearcher == resID);
DbStatus verifyResearcherStatus = new DbStatus();
if (researcher != null)
{
if (researcher.Isverified == false)
{
//Verify researcher
researcher.Isverified = true;
_context.Update(researcher);
_context.SaveChanges();
verifyResearcherStatus.success = true;
}
else
{
//Researcher was all ready verified
verifyResearcherStatus.success = false;
verifyResearcherStatus.errormessage = "Researcher is all ready verified";
}
}
else
{
//Researcher does not exists
verifyResearcherStatus.success = false;
verifyResearcherStatus.errormessage = "Researcher with this ID does not exists";
}
return(verifyResearcherStatus);
}
public void CreateStudyDB(Study study, Inclusioncriteria inclusioncriteria)
{
//Adds the study to the database and saves
_context.Study.Add(study);
_context.SaveChanges();
//Retrieves the id from the study just saved and sets the study_id in inclusioncriteria.
var dbStudy = (_context.Study.FirstOrDefault(stud =>
stud.Name == study.Name && stud.DateCreated == study.DateCreated)) ??
_context.Study.Local.FirstOrDefault(stud =>
stud.Name == study.Name && stud.DateCreated == study.DateCreated);
inclusioncriteria.IdStudy = dbStudy.IdStudy;
//Sets the direct study link with the generated ID
if (dbStudy != null)
{
//Todo OBS!!! Direct Study link currently hardcoded - fix or rewrite when published.
dbStudy.DirectStudyLink = "http://localhost:61728/ViewStudy/ViewStudy?studyID=" + dbStudy.IdStudy;
_context.Study.Update(dbStudy);
}
//Saves the inclusioncriteria and the study link
_context.Inclusioncriteria.Add(inclusioncriteria);
_context.SaveChanges();
}
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 bool RegisterParticipantDB(Participant participant)
{
if (_context.Participant.Any(part => part.Email == participant.Email))
{
//Email allready exists
return(false);
}
else
{
//Register participant
_context.Participant.Add(participant);
_context.SaveChanges();
return(true);
}
}
public DbStatus ChangePasswordResearcherDB(Researcher researcher, string oldPassword)
{
Researcher oldResearcher = _context.Researcher.FirstOrDefault(res => res.IdResearcher == researcher.IdResearcher);
DbStatus status = new DbStatus();
if (oldResearcher.Password == oldPassword)
{
//The old password matches, and will be changed to new one
oldResearcher.Password = researcher.Password;
_context.Researcher.Update(oldResearcher);
_context.SaveChanges();
status.success = true;
}
else
{
//Old password did not match. Password will not be changed
status.success = false;
status.errormessage = "The old password was incorrect. Please try again";
}
return(status);
}
