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