public void DeleteRelation(long SurveyID, long QuestionID)
{
SurveyDefinition surveyDefinitionToDelete = GetRelation(SurveyID, QuestionID);
DeleteRelation(surveyDefinitionToDelete);
DatabaseModel.SaveChanges();
}
public Survey GetByQuestion(long QuestionID)
{
SurveyDefinition selectedSurveyDefinition = (from surveyDefinition in DatabaseModel.SurveyDefinition
where surveyDefinition.QuestionID == QuestionID
select surveyDefinition).First();
Survey selectedSurvey = (from survey in DatabaseModel.Survey
where survey.SurveyID == selectedSurveyDefinition.SurveyID
select survey).First();
return(selectedSurvey);
}
public Dictionary <string, int> GetSurveyScoreByScale(string surveyType, IDictionary <string, int> surveyResponses)
{
SurveyDefinition surveyMapping = _GetSurveyDefinition(surveyType);
if (surveyMapping != null)
{
var scoresByScale = from def in surveyMapping.Definitions
select new
{
Scale = def.Name,
Score = GetScaleScore(def, surveyResponses)
};
return(scoresByScale.ToDictionary(a => a.Scale, a => a.Score));
}
return(new Dictionary <string, int>());
}
public void DeleteRelation(SurveyDefinition surveyDefinition)
{
DatabaseModel.SurveyDefinition.Remove(surveyDefinition);
DatabaseModel.SaveChanges();
}
