private void SetFactorsNameAndScore() { if (InterView.GetInterviewCompleteness()) { _maxInterviewNum = GetMaxInterviewNum(); _factorDependence = CheckForFactorDependence(); var factorIdCollection = !_factorDependence ? GetFactorsIdWithoutFactorDependence() : GetFactorsIdWithFactorDependence(); SetFactorScore(factorIdCollection); } }
private void UpdateAnswerResult(Question currQuestion, object interviewId) { var query = "select max(AnswerResults.id) " + " from main.AnswerResults, " + " main.Interview," + " main.Questions " + " where Interview.theme_id = '" + _interviewThemeId + "'" + " and AnswerResults.respondent_id = '" + _respondentId + "' " + " and Interview.id = AnswerResults.interview_id " + " and Interview.question_id = Questions.id " + " and Questions.Name = '" + currQuestion.Name + "'"; try { var answerResultRow = DbConnection.SelectFromDb(query); if (answerResultRow.Rows[0][0].ToString() != "") { var answerResultId = answerResultRow.Rows[0][0]; if (InterView.GetHaveHistory()) { query = " update main.AnswerResults" + " set Interview_id = '" + interviewId + "'" + ", answer_date = current_date " + " where id = '" + answerResultId + "'"; } else { var nextInterviewNum = InterView.GetInterviewCompleteness() ? _nextInterviewNum : _nextInterviewNum + 1; query = " update main.AnswerResults" + " set Interview_id = '" + interviewId + "'" + ", interview_number = '" + nextInterviewNum + "'" + ", answer_date = current_date " + " where id = '" + answerResultId + "'"; } DbConnection.DmlOperation(query); } else { AddAnswerResult(interviewId); } } catch (Exception exp) { throw new Exception("UpdateAnswerResult" + exp); } }
public bool GetInterviewCompleteness() { return(InterView.GetInterviewCompleteness()); }