public async Task scoreTeam(Team t, Score s, int scoringTeam, string scoredBy) { string uri = "http://71.92.131.203:7475/db/data/cypher/"; string query = "MATCH (n: Team { number:" + t.number + " })" + "MERGE (s: Score { tNum: " + t.number + ", scoringTeam: " + scoringTeam + " }) WITH n, s " + "MERGE (n)-[r:HAS]->(s)" + //: Score { tNum:" + t.number + " } " ON MATCH SET s.scorer=\"" + scoredBy + "\", s.upScore0=" + s.upScore[0] + ", s.upScore1=" + s.upScore[1] + ", s.upScore2=" + s.upScore[2] + ", s.upScore3=" + s.upScore[3] + ", s.upScore4=" + s.upScore[4] + ", s.upScore5=" + s.upScore[5] + ", s.upScore6=" + s.upScore[6] + ", s.upScore7=" + s.upScore[7] + ", s.upScore8=" + s.upScore[8] + ", s.dnScore0=" + s.dnScore[0] + ", s.dnScore1=" + s.dnScore[1] + ", s.dnScore2=" + s.dnScore[2] + ", s.dnScore3=" + s.dnScore[3] + ", s.dnScore4=" + s.dnScore[4] + ", s.dnScore5=" + s.dnScore[5] + ", s.dnScore6=" + s.dnScore[6] + ", s.dnScore7=" + s.dnScore[7] + ", s.dnScore8=" + s.dnScore[8] + " ON CREATE SET s.scorer=\"" + scoredBy + "\", s.upScore0=" + s.upScore[0] + ", s.upScore1=" + s.upScore[1] + ", s.upScore2=" + s.upScore[2] + ", s.upScore3=" + s.upScore[3] + ", s.upScore4=" + s.upScore[4] + ", s.upScore5=" + s.upScore[5] + ", s.upScore6=" + s.upScore[6] + ", s.upScore7=" + s.upScore[7] + ", s.upScore8=" + s.upScore[8] + ", s.dnScore0=" + s.dnScore[0] + ", s.dnScore1=" + s.dnScore[1] + ", s.dnScore2=" + s.dnScore[2] + ", s.dnScore3=" + s.dnScore[3] + ", s.dnScore4=" + s.dnScore[4] + ", s.dnScore5=" + s.dnScore[5] + ", s.dnScore6=" + s.dnScore[6] + ", s.dnScore7=" + s.dnScore[7] + ", s.dnScore8=" + s.dnScore[8] + ", s.time=timestamp() RETURN s"; // Attach sender to Entr and return all diary entries for this timeline var r = SendAndReceiveJsonRequest(uri, query); string responseStr = await r; }
public async Task<Score> getScore(int tN, int stNum) { string uri = "http://71.92.131.203:7475/db/data/cypher/"; string query = "MATCH (n: Score { tNum: " + tN + ", scoringTeam: " + stNum + " }) RETURN n"; // Attach sender to Entr and return all diary entries for this timeline var r = SendAndReceiveJsonRequest(uri, query); string responseStr = await r; Score data = new Score(); try { neo4jData val = Newtonsoft.Json.JsonConvert.DeserializeObject<neo4jData>(responseStr); foreach (var kvp in val.data)// process column 'a' { foreach (var kv in kvp) { foreach (var k in kv) { if (k.Key == "data")// these are the events { string values = Newtonsoft.Json.JsonConvert.SerializeObject(k.Value); string ds = Newtonsoft.Json.JsonConvert.SerializeObject(k.Value); JToken token = JObject.Parse(ds); try { data.scoringTeam = (int)token.SelectToken("scoringTeam"); data.tNum = (int)token.SelectToken("tNum"); data.upScore[0] = (int)token.SelectToken("upScore0"); data.upScore[1] = (int)token.SelectToken("upScore1"); data.upScore[2] = (int)token.SelectToken("upScore2"); data.upScore[3] = (int)token.SelectToken("upScore3"); data.upScore[4] = (int)token.SelectToken("upScore4"); data.upScore[5] = (int)token.SelectToken("upScore5"); data.upScore[6] = (int)token.SelectToken("upScore6"); data.upScore[7] = (int)token.SelectToken("upScore7"); data.upScore[8] = (int)token.SelectToken("upScore8"); data.dnScore[0] = (int)token.SelectToken("dnScore0"); data.dnScore[1] = (int)token.SelectToken("dnScore1"); data.dnScore[2] = (int)token.SelectToken("dnScore2"); data.dnScore[3] = (int)token.SelectToken("dnScore3"); data.dnScore[4] = (int)token.SelectToken("dnScore4"); data.dnScore[5] = (int)token.SelectToken("dnScore5"); data.dnScore[6] = (int)token.SelectToken("dnScore6"); data.dnScore[7] = (int)token.SelectToken("dnScore7"); data.dnScore[8] = (int)token.SelectToken("dnScore8"); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Bad token: " + ex.Message); } return data; } } } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } return data; }
public async void getTeams() { blueAlliance.Clear(); redAlliance.Clear(); blueScore.Clear(); redScore.Clear(); try { REST neo = new REST(); // Get Team's for this match var result = neo.getTeam(int.Parse(match.blue1)); Team t = await result; blueAlliance.Insert(0, t); result = neo.getTeam(int.Parse(match.blue2)); t = await result; blueAlliance.Insert(1, t); result = neo.getTeam(int.Parse(match.blue3)); t = await result; blueAlliance.Insert(2, t); result = neo.getTeam(int.Parse(match.red1)); t = await result; redAlliance.Insert(0, t); result = neo.getTeam(int.Parse(match.red2)); t = await result; redAlliance.Insert(1, t); result = neo.getTeam(int.Parse(match.red3)); t = await result; redAlliance.Insert(2, t); // Get Score's recorded by this team var res = neo.getScore(int.Parse(match.blue1), MatchListPage.opt.teamNumber); Score s = await res; if (s == null) s = new Score(); blueScore.Insert(0, s); if (s.tNum == 0) { blueScore[0].tNum = int.Parse(match.blue1); blueScore[0].scoringTeam = MatchListPage.opt.teamNumber; } res = neo.getScore(int.Parse(match.blue2), MatchListPage.opt.teamNumber); s = await res; if (s == null) s = new Score(); blueScore.Insert(1, s); if (s.tNum == 0) { blueScore[1].tNum = int.Parse(match.blue2); blueScore[1].scoringTeam = MatchListPage.opt.teamNumber; } res = neo.getScore(int.Parse(match.blue3), MatchListPage.opt.teamNumber); s = await res; if (s == null) s = new Score(); blueScore.Insert(2, s); if (s.tNum == 0) { blueScore[2].tNum = int.Parse(match.blue3); blueScore[2].scoringTeam = MatchListPage.opt.teamNumber; } res = neo.getScore(int.Parse(match.red1), MatchListPage.opt.teamNumber); s = await res; if (s == null) s = new Score(); redScore.Insert(0, s); if (s.tNum == 0) { redScore[0].tNum = int.Parse(match.red1); redScore[0].scoringTeam = MatchListPage.opt.teamNumber; } res = neo.getScore(int.Parse(match.red2), MatchListPage.opt.teamNumber); s = await res; if (s == null) s = new Score(); redScore.Insert(1, s); if (s.tNum == 0) { redScore[1].tNum = int.Parse(match.red2); redScore[1].scoringTeam = MatchListPage.opt.teamNumber; } res = neo.getScore(int.Parse(match.red3), MatchListPage.opt.teamNumber); s = await res; if (s == null) s = new Score(); redScore.Insert(2, s); if (s.tNum == 0) { redScore[2].tNum = int.Parse(match.red3); redScore[2].scoringTeam = MatchListPage.opt.teamNumber; } whatColor(); } catch (Exception ex) { Debug.WriteLine(ex.Message); } }