private void saveToRedis(IgracRedis igrac) { var json = JsonConvert.SerializeObject(igrac); var redisClient = new RedisClient(Config.SingleHost); switch (igrac.element_type) { case 1: redisClient.SAdd("golman", Encoding.ASCII.GetBytes(json)); break; case 2: redisClient.SAdd("odbrana", Encoding.ASCII.GetBytes(json)); break; case 3: redisClient.SAdd("sredina", Encoding.ASCII.GetBytes(json)); break; case 4: redisClient.SAdd("napad", Encoding.ASCII.GetBytes(json)); break; } }
private void btnIzmeni_Click(object sender, EventArgs e) { var redisClient = new RedisClient(Config.SingleHost); IgracRedis toEdit = new IgracRedis(i); toEdit.klub = klubovi[i.team - 1]; switch (i.element_type) { case 1: redisClient.SRem("golman", Encoding.ASCII.GetBytes(JsonConvert.SerializeObject(toEdit))); break; case 2: redisClient.SRem("odbrana", Encoding.ASCII.GetBytes(JsonConvert.SerializeObject(toEdit))); break; case 3: redisClient.SRem("sredina", Encoding.ASCII.GetBytes(JsonConvert.SerializeObject(toEdit))); break; case 4: redisClient.SRem("napad", Encoding.ASCII.GetBytes(JsonConvert.SerializeObject(toEdit))); break; default: break; } toEdit.goals_scored = Int32.Parse(txtGolovi.Text); toEdit.assists = Int32.Parse(txtAsistencije.Text); toEdit.points_per_game = txtPoeniPoUtakmici.Text; toEdit.total_points = Int32.Parse(txtUkupnoPoena.Text); toEdit.yellow_cards = Int32.Parse(txtZutiKartoni.Text); toEdit.red_cards = Int32.Parse(txtCrveniKartoni.Text); var json = JsonConvert.SerializeObject(toEdit); switch (i.element_type) { case 1: redisClient.SAdd("golman", Encoding.ASCII.GetBytes(json)); break; case 2: redisClient.SAdd("odbrana", Encoding.ASCII.GetBytes(json)); break; case 3: redisClient.SAdd("sredina", Encoding.ASCII.GetBytes(json)); break; case 4: redisClient.SAdd("napad", Encoding.ASCII.GetBytes(json)); break; } MessageBox.Show("Izmenjeno!"); }
private void loadPlayers() { var url = "https://fantasy.premierleague.com/drf/elements/"; using (var w = new WebClient()) { byte[] bitovi; Encoding iso = Encoding.GetEncoding("ISO-8859-1"); Encoding utf8 = Encoding.UTF8; try { bitovi = w.DownloadData(url); byte[] isoBytes = Encoding.Convert(utf8, iso, bitovi); string msg = iso.GetString(isoBytes); List <Igrac> list = JsonConvert.DeserializeObject <List <Igrac> >(msg); foreach (Igrac b in list) { Dictionary <string, object> queryDict = new Dictionary <string, object>(); queryDict.Add("first_name", b.first_name); queryDict.Add("second_name", b.second_name); queryDict.Add("id", b.id); queryDict.Add("team", b.team); queryDict.Add("element_type", b.element_type); /*queryDict.Add("goals_scored", b.goals_scored); * queryDict.Add("assists", b.assists); * queryDict.Add("minutes", b.minutes); * queryDict.Add("yellow_cards", b.yellow_cards); * queryDict.Add("red_cards", b.red_cards); * queryDict.Add("dreamteam_count", b.dreamteam_count); * queryDict.Add("points_per_game", b.points_per_game); * queryDict.Add("total_points", b.total_points); * * var query = new Neo4jClient.Cypher.CypherQuery("MERGE (n:Igrac {id:" + b.id + ", first_name:'" + b.first_name + * "', second_name:'" + b.second_name + "', goals_scored:" + b.goals_scored + ", assists:" + b.assists + ", minutes:" + b.minutes + * ", yellow_cards:" + b.yellow_cards + ", red_cards:" + b.red_cards + ", dreamteam_count:" + b.dreamteam_count + * ", points_per_game:'" + b.points_per_game + "', team:" + b.team + ", element_type:" + b.element_type + ", total_points:" + b.total_points + "}) return n", queryDict, CypherResultMode.Set);*/ var query = new Neo4jClient.Cypher.CypherQuery("MERGE (n:Igrac {id:" + b.id + ", first_name:'" + b.first_name + "', second_name:'" + b.second_name + "', team:" + b.team + ", element_type:" + b.element_type + "}) return n", queryDict, CypherResultMode.Set); ((IRawGraphClient)client).ExecuteCypherAsync(query); IgracRedis igrac = new IgracRedis(b); igrac.klub = klubovi[b.team - 1]; saveToRedis(igrac); } } catch (Exception eb) { MessageBox.Show(eb.Message); } } }
public void LoadTop11() { label1.Text = "Ucitavam..."; odbrana = new List <Igrac>(); sredina = new List <Igrac>(); napad = new List <Igrac>(); /* * //odbrana * var query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.element_type = 2 RETURN player ORDER BY player.total_points DESC LIMIT 4", * new Dictionary<string, object>(), CypherResultMode.Set); * odbrana = ((IRawGraphClient)client).ExecuteGetCypherResults<Igrac>(query).ToList(); * * * //sredina * query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.element_type = 3 RETURN player ORDER BY player.total_points DESC LIMIT 4", * new Dictionary<string, object>(), CypherResultMode.Set); * sredina = ((IRawGraphClient)client).ExecuteGetCypherResults<Igrac>(query).ToList(); * * * //napad * query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.element_type = 4 RETURN player ORDER BY player.total_points DESC LIMIT 2", * new Dictionary<string, object>(), CypherResultMode.Set); * napad = ((IRawGraphClient)client).ExecuteGetCypherResults<Igrac>(query).ToList(); * * * //golman * query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.element_type = 1 RETURN player ORDER BY player.total_points DESC LIMIT 1", * new Dictionary<string, object>(), CypherResultMode.Set); * golman = ((IRawGraphClient)client).ExecuteGetCypherResults<Igrac>(query).FirstOrDefault();*/ //golman List <IgracRedis> listaGolman = readFromRedis("golman"); IgracRedis golmanRedis = listaGolman.OrderByDescending(x => x.total_points).ToList().FirstOrDefault(); if (golmanRedis == null) { return; } var query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.id = " + golmanRedis.id + " RETURN player LIMIT 1", new Dictionary <string, object>(), CypherResultMode.Set); Igrac golman1 = ((IRawGraphClient)client).ExecuteGetCypherResults <Igrac>(query).FirstOrDefault(); golman = new Igrac(golman1, golmanRedis); //odbrana List <IgracRedis> listaOdbrana = readFromRedis("odbrana"); List <IgracRedis> odbranaRedisList = listaOdbrana.OrderByDescending(x => x.total_points).Take(4).ToList(); for (int i = 0; i < odbranaRedisList.Count; i++) { query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.id = " + odbranaRedisList[i].id + " RETURN player LIMIT 1", new Dictionary <string, object>(), CypherResultMode.Set); Igrac igrac = ((IRawGraphClient)client).ExecuteGetCypherResults <Igrac>(query).FirstOrDefault(); odbrana.Add(new Igrac(igrac, odbranaRedisList[i])); } //sredina List <IgracRedis> listaSredina = readFromRedis("sredina"); List <IgracRedis> sredinaRedisList = listaSredina.OrderByDescending(x => x.total_points).Take(4).ToList(); for (int i = 0; i < sredinaRedisList.Count; i++) { query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.id = " + sredinaRedisList[i].id + " RETURN player LIMIT 1", new Dictionary <string, object>(), CypherResultMode.Set); Igrac igrac = ((IRawGraphClient)client).ExecuteGetCypherResults <Igrac>(query).FirstOrDefault(); sredina.Add(new Igrac(igrac, sredinaRedisList[i])); } //napad List <IgracRedis> listaNapad = readFromRedis("napad"); List <IgracRedis> NapadRedisList = listaNapad.OrderByDescending(x => x.total_points).Take(2).ToList(); for (int i = 0; i < NapadRedisList.Count; i++) { query = new Neo4jClient.Cypher.CypherQuery("MATCH (player:Igrac) WHERE player.id = " + NapadRedisList[i].id + " RETURN player LIMIT 1", new Dictionary <string, object>(), CypherResultMode.Set); Igrac igrac = ((IRawGraphClient)client).ExecuteGetCypherResults <Igrac>(query).FirstOrDefault(); napad.Add(new Igrac(igrac, NapadRedisList[i])); } }