Esempio n. 1
0
    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);
    }
Esempio n. 2
0
 public void PutPollAnswers(AOrBAnswerInfo answerInfo)
 {
     StartCoroutine(HTTPRequest.Instance.SaveVote(answerInfo));
 }