/* * 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); } }