public string deleteOldLeftOverAnswers(Entities.QuizQuestion _updatedQuestion) { string _deletionResult = "Answers Deleted Successfully"; try { List <FarmworkersWebAPI.Entities.QuizAnswer> _oldAnswers = _context.QuizAnswers. Where(q => q.QuizID.Equals(_updatedQuestion.QuizID) && q.QuizVersion.Equals(_updatedQuestion.QuizVersion) && q.QuestionID.Equals(_updatedQuestion.QuestionID) && q.IsActive.Equals("1")).ToList(); if (_oldAnswers.Count > _updatedQuestion.QuizAnswers.Count && _updatedQuestion.QuizAnswers.Count != 0) { for (int i = _updatedQuestion.QuizAnswers.Count + 1; i <= _oldAnswers.Count; i++) { Entities.QuizAnswer _answerToDelete = new Entities.QuizAnswer(); FarmworkersWebAPI.Entities.QuizAnswer original = _context.QuizAnswers. Where(q => q.QuizID.Equals(_updatedQuestion.QuizID) && q.QuizVersion.Equals(_updatedQuestion.QuizVersion) && q.QuestionID.Equals(_updatedQuestion.QuestionID) && q.AnswerID.Equals(i)).FirstOrDefault(); _answerToDelete.QuizID = _updatedQuestion.QuizID; _answerToDelete.QuizVersion = _updatedQuestion.QuizVersion; _answerToDelete.QuestionID = _updatedQuestion.QuestionID; _answerToDelete.AnswerID = i; _answerToDelete.Answer = original.Answer; _answerToDelete.IsCorrect = original.IsCorrect; _answerToDelete.IsActive = "0"; _answerToDelete.DateModified = original.DateModified; _context.Entry(original).CurrentValues.SetValues(_answerToDelete); _context.SaveChanges(); } } } catch (Exception ex) { return(InternalServerError(ex).ToString()); } return(_deletionResult); }
public string EFdeleteQuizAnswer(FarmworkersWebAPI.Entities.QuizAnswer _deletedQuizAnswer) { _context.Configuration.ProxyCreationEnabled = false; try { _context.QuizAnswers.Attach(_deletedQuizAnswer); _context.QuizAnswers.Remove(_deletedQuizAnswer); _context.SaveChanges(); return("Answer Deleted Successfully"); } catch (Exception ex) { return(InternalServerError(ex).ToString()); } }
public string EFinsertQuizAnswer(FarmworkersWebAPI.Entities.QuizAnswer _newQuizAnswer) { _context.Configuration.ProxyCreationEnabled = false; FarmworkersWebAPI.Entities.QuizAnswer _quizAnswerContentData = new FarmworkersWebAPI.Entities.QuizAnswer(); try { _quizAnswerContentData = _context.QuizAnswers.Add(_newQuizAnswer); _context.SaveChanges(); return("Answer Inserted Successfully"); } catch (Exception ex) { return(InternalServerError(ex).ToString()); } }
public string EFupdateQuizAnswer(FarmworkersWebAPI.Entities.QuizAnswer _updatedQuizAnswer) { if (_updatedQuizAnswer.AnswerID < 0) { return("Quiz Answer ID can not be negative"); } if (_updatedQuizAnswer.AnswerID == 0) { return("Quiz Answer ID Not Specified"); } _context.Configuration.ProxyCreationEnabled = false; try { FarmworkersWebAPI.Entities.QuizAnswer original = _context.QuizAnswers. Where(q => q.QuizID.Equals(_updatedQuizAnswer.QuizID) && q.QuizVersion.Equals(_updatedQuizAnswer.QuizVersion) && q.QuestionID.Equals(_updatedQuizAnswer.QuestionID) && q.AnswerID.Equals(_updatedQuizAnswer.AnswerID)).FirstOrDefault(); if (original != null) { _context.Entry(original).CurrentValues.SetValues(_updatedQuizAnswer); _context.SaveChanges(); return("Answer Updated Successfully"); } else //If during the update process, there is a new answer that wasn't there before. { string _insertAnswerResult = EFinsertQuizAnswer(_updatedQuizAnswer); if (_insertAnswerResult != "Answer Inserted Successfully") { return(_insertAnswerResult); } return("Answer Updated Successfully"); } } catch (Exception ex) { return(InternalServerError(ex).ToString()); } }