public void PutPollAnswers(GraphAnswerInfo answerInfo)
{
StartCoroutine(HTTPRequest.Instance.SaveVote(answerInfo));
}
public AnswerInfo GetPollAnswersB(string questionId)
{
GraphAnswerInfo answerInfo = new GraphAnswerInfo();
answerInfo.questionId = questionId;
Debug.Log("RETRIEVING TYPE 2 ANSWERS FROM " + questionId);
//List<int> numlist = new List<int>();
string numbers = "[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]";
try {
string query = "select id, scatter_plot_answer, updated_at from answer " +
"where question_id is " + answerInfo.questionId + " " +
"ORDER BY updated_at DESC Limit 1";
dbcmd.CommandText = query;
reader = dbcmd.ExecuteReader();
while (reader.Read())
{
string answers = reader["scatter_plot_answer"].ToString();
answerInfo.uniqueId = Convert.ToInt32(reader["id"]);
if (!string.IsNullOrEmpty(answers))
{
numbers = answers;
}
}
//REMOVES [ ]
numbers = numbers.Substring(1, numbers.Length - 2);
foreach (string number in numbers.Split(','))
{
answerInfo.numbers.Add(Int32.Parse(number));
}
while (answerInfo.numbers.Count < 40)
{
answerInfo.numbers.Add(0);
}
}
catch {
//NEW USER - NO DATA AVAILABLE
Debug.Log("FAILED TO PULL DATA - USER - NO DATA AVAILABLE");
List <int> numlist_error = new List <int>();
string numbers_error = "[1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]";
//REMOVES [ ]
numbers_error = numbers_error.Substring(1, numbers_error.Length - 2);
foreach (string num in numbers_error.Split(','))
{
numlist_error.Add(Int32.Parse(num));
}
answerInfo.numbers = numlist_error;
}
//scatter_plot_answer_arr = arr;
return(answerInfo);
}
