private DataTable GetPictureOnCurrQuestion()
{
try
{
var isConnect = DbImageLoader.ConnectToDb(DbConnection);
var dataTable = new DataTable();
if (isConnect)
{
var query = "select distinct Pictures.picture " +
" from main.Pictures, " +
" main.Questions, " +
" main.Interview " +
" where Pictures.id = Questions.picture_id " +
" and Interview.question_id = Questions.id " +
" and Questions.name = '" + InterView.GetCurrentQuestionAndAnswer().Key.Name + "'" +
" and Interview.theme_id = '" + _interviewThemeId + "'";
var imgByte = DbImageLoader.GetBytePictureFromDb(query);
if (imgByte != null)
{
var img = DbImageLoader.GetImageFromImgBytes(imgByte, Options.PictureSize);
dataTable.Columns.Add(new DataColumn {
DataType = typeof(Bitmap)
});
var newRow = dataTable.NewRow();
newRow[0] = img;
dataTable.Rows.Add(newRow);
}
}
return(dataTable);
}
catch (Exception exp)
{
throw new Exception("GetPictureOnCurrQuestion " + exp);
}
}
private void InsertAnswerResult(SetDataType dataType)
{
var currQuestion = InterView.GetCurrentQuestionAndAnswer().Key;
var interviewIdRow = GetInteviewId(currQuestion, InterView.GetScoreByQuestionName(currQuestion.Name));
if (interviewIdRow.Rows.Count > 0)
{
var interviewId = interviewIdRow.Rows[0][0];
if (dataType == SetDataType.AnswerResultInsert)
{
AddAnswerResult(interviewId);
}
else
{
UpdateAnswerResult(currQuestion, interviewId);
}
}
}
