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