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); }