public void AddSurveyAnswer(int surveyId, int possibleAnswerId, string historicalQuestion, string answer)
{
using (var context = new MSSContext())
{
surveyanswer surveyAnswer = new surveyanswer();
surveyAnswer.surveyid = surveyId;
surveyAnswer.possibleanswerid = possibleAnswerId;
surveyAnswer.historicalquestion = historicalQuestion;
surveyAnswer.answer = answer;
context.surveyanswers.Add(surveyAnswer);
context.SaveChanges();
}
}
public List <surveyanswer> GetSurveyAnswer(int surveyId, int surveyQuestionId)
{
using (var context = new MSSContext())
{
var surveyAnswer = from aSurveyAnswer in context.surveyanswers
where aSurveyAnswer.surveyid == surveyId && aSurveyAnswer.surveyquestionid == surveyQuestionId
select aSurveyAnswer;
List <surveyanswer> surveyAnswersList = new List <surveyanswer>();
foreach (surveyanswer surveyanswer in surveyAnswer)
{
surveyanswer temp = new surveyanswer();
temp.surveyid = surveyanswer.surveyid;
temp.surveyquestionid = surveyanswer.surveyquestionid;
temp.historicalquestion = surveyanswer.historicalquestion;
temp.answer = surveyanswer.answer;
surveyAnswersList.Add(temp);
}
return(surveyAnswersList);
}
}
public List <surveyanswer> GetSurveyAnswers(int surveyId)
{
using (var context = new MSSContext())
{
var surveyAnswer = (from aSurveyAnswer in context.surveyanswers
where aSurveyAnswer.surveyid == surveyId
select aSurveyAnswer).ToList();
List <surveyanswer> surveyAnswersList = new List <surveyanswer>();
foreach (surveyanswer answer in surveyAnswer)
{
surveyanswer temp = new surveyanswer();
temp.surveyid = answer.surveyid;
temp.possibleanswerid = answer.possibleanswerid;
temp.historicalquestion = answer.historicalquestion;
temp.answer = answer.answer;
temp.possibleanswer = answer.possibleanswer;
surveyAnswersList.Add(temp);
}
return(surveyAnswersList);
}
}
