/*
* CREATED: H. Conant MAR 20 2018
*
* DeactivatePossibleAnswer()
* This method deactivates a PossibleAnswer in the MSS databse.
*
* PARAMETERS:
* PossibleAnswerDTO deactivatedPossibleAnswer - the PossibleAnswer that is to be deactivated in the database
*
* RETURNS:
* void
*
* ODEV METHOD CALLS:
* None
*/
public void DeactivatePossibleAnswer(PossibleAnswerDTO deactivatedPossibleAnswer)
{
using (var context = new MSSContext())
{
var possibleAnswer = context.units.Find(deactivatedPossibleAnswer.possibleanswerid);
possibleAnswer.activeyn = false;
var existingPossibleAnswer = context.Entry(possibleAnswer);
existingPossibleAnswer.State = EntityState.Modified;
context.SaveChanges();
}
}
public void UpdatePossibleAnswer(PossibleAnswerDTO updatedPossibleAnswer)
{
using (var context = new MSSContext())
{
var possibleAnswer = context.possibleanswers.Find(updatedPossibleAnswer.possibleanswerid);
possibleAnswer.possibleanswertext = updatedPossibleAnswer.possibleanswertext;
possibleAnswer.surveyquestionid = updatedPossibleAnswer.surveyquestionid;
var existingPossibleAnswer = context.Entry(possibleAnswer);
existingPossibleAnswer.State = EntityState.Modified;
context.SaveChanges();
}
}
public void AddPossibleAnswer(PossibleAnswerDTO tempPossibleAnswer)
{
using (var context = new MSSContext())
{
possibleanswer newPossibleAnswer = new possibleanswer();
newPossibleAnswer.possibleanswerid = tempPossibleAnswer.possibleanswerid;
newPossibleAnswer.possibleanswertext = tempPossibleAnswer.possibleanswertext;
newPossibleAnswer.activeyn = true;
newPossibleAnswer.surveyquestionid = tempPossibleAnswer.surveyquestionid;
context.possibleanswers.Add(newPossibleAnswer);
context.SaveChanges();
}
}
public List <PossibleAnswerDTO> GetPossibleAnswers(int surveyQuestionID)
{
using (var context = new MSSContext())
{
var possibleAnswers = from aAnswer in context.possibleanswers
where aAnswer.surveyquestionid == surveyQuestionID && aAnswer.activeyn == true
select aAnswer;
List <PossibleAnswerDTO> possibleAnswerDTOs = new List <PossibleAnswerDTO>();
foreach (possibleanswer possibleanswer in possibleAnswers)
{
PossibleAnswerDTO temp = new PossibleAnswerDTO();
temp.possibleanswerid = possibleanswer.possibleanswerid;
temp.possibleanswertext = possibleanswer.possibleanswertext;
possibleAnswerDTOs.Add(temp);
}
return(possibleAnswerDTOs);
}
}
