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());
}