public AnswerInfo GetPollAnswersA(string questionId) { string query = "select * from answer " + "where question_id is " + questionId + " " + "ORDER BY updated_at DESC Limit 1"; AOrBAnswerInfo answerInfo = new AOrBAnswerInfo(); answerInfo.questionId = questionId; try { dbcmd.CommandText = query; reader = dbcmd.ExecuteReader(); object ans1Obj = null; object ans2Obj = null; while (reader.Read()) { answerInfo.uniqueId = Convert.ToInt32(reader["id"]); ans1Obj = reader["answer_text_a"].ToString(); ans2Obj = reader["answer_text_b"].ToString(); } string ans1 = ans1Obj.ToString(); string ans2 = ans2Obj.ToString(); answerInfo.answerA = Convert.ToInt32(string.IsNullOrEmpty(ans1) ? "1" : ans1); answerInfo.answerB = Convert.ToInt32(string.IsNullOrEmpty(ans2) ? "1" : ans2); } catch { //TODO: DONT HARDCODE THIS Debug.Log("ERROR RETRIEVING DATA"); } Debug.Log(answerInfo.answerA + " " + answerInfo.answerA); return(answerInfo); }
public void PutPollAnswers(AOrBAnswerInfo answerInfo) { StartCoroutine(HTTPRequest.Instance.SaveVote(answerInfo)); }