private void BtnBUQuestion_Click(object sender, RoutedEventArgs e)
{
DecodeQuestion decodeQuestion = DAO.BUDecodeQuestionDAO.Instance.getQuestion(currentRow, currentCol);
eWDecode.txtBlockQuestion2.Text = eWDecode.txtBlockQuestion1.Text = txtBlockQuestion.Text = decodeQuestion.Detail;
mediaAct.Upload(eWDecode.imgQuestion, decodeQuestion.QuestionImageName);
mediaAct.Upload(eWDecode.videoQuestion, decodeQuestion.QuestionVideoName);
txtBlockAnswer.Text = decodeQuestion.Answer;
if (decodeQuestion.QuestionImageName == "" && decodeQuestion.QuestionVideoName == "")
{
eWDecode.txtBlockQuestion1.Text = "";
}
else
{
eWDecode.txtBlockQuestion2.Text = "";
}
eWDecode.HideAll();
eWDecode.gridQuestion.Visibility = Visibility.Visible;
mediaAct.Play(eWDecode.videoQuestionStart);
ResetAnswerList();
ResetTxtBlockAnswerAndPoint();
for (int i = 0; i < server.ClientList.Count; i++)
{
server.Send(server.ClientList[i], "5_1_" + decodeQuestion.Detail);
}
}
public DecodeQuestion getQuestion(int row, int col, string matchID, int isBackup = 0)
{
string query = string.Format(@"
SELECT * FROM tblDECODEQUESTION
WHERE row = {0} AND col = {1} AND matchID = '{2}' AND isBackup = {3}", row + 1, col + 1, matchID, isBackup);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
DecodeQuestion result = new DecodeQuestion(data.Rows[0]);
return(result);
}
public DecodeQuestion getQuestion(int row, int col)
{
string query = string.Format(@"
SELECT * FROM DECODEQUESTION
WHERE Row = {0} AND Col = {1}", row + 1, col + 1);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
DecodeQuestion result = new DecodeQuestion(data.Rows[0]);
return(result);
}
