public void AnswerUpdateOnDbSide(Model.Answer ans)
{
var a = _db.SingleOrDefault <Answer>($"SELECT * FROM {_tblA} WHERE answer_id={ans.Id}");
a.text = ans.Text;
_db.Update(a);
}
public void GameAdd(User user, Model.Answer answ, Dictionary <Model.Question, Reaction> gameHistory)
{
GameHistory gh = new GameHistory();
gh.answer_id = answ.Id;
gh.approved_by_moderator = false;
gh.user_id = user.user_id;
_db.Insert(gh);
foreach (var keyPair in gameHistory)
{
GameDetails grh = new GameDetails();
grh.game_id = gh.game_id;
grh.question_id = keyPair.Key.Id;
grh.reaction_id = (int)keyPair.Value;
_db.Insert(grh);
}
}
public void AnswerRemove(Model.Answer ans)
{
AnswerRemove(ans.Id);
}
public void AnswerAdd(ref Model.Answer a)
{
a.Id = AnswerAdd(a.Text);
}
public int QuestionReactionCountWhenThinkAboutAnswer(Model.Question q, Reaction react, Model.Answer ans)
{
var query =
$"SELECT Count(*) FROM {_tblGdetails} INNER JOIN {_tblGhistory} ON ({_tblGdetails}.game_id = {_tblGhistory}.game_id) WHERE question_id = {q.Id} AND reaction_id = {(int) react} AND answer_id={ans.Id}";
return(_db.SingleOrDefault <int>(query));
}
public int QuestionAskedWhenThinkAboutAnswer(Model.Question q, Model.Answer ans)
{
return(QuestionAskedWhenThinkAboutAnswer(q.Id, ans.Id));
}
