public static void populateGWData()
{
Console.WriteLine("Fetching Game Week data...");
foreach (var player in PlayersToCheck)
{
FPL.GWData GWPlayerData = populateStats(player);
Console.WriteLine("Writing Game Week data to DB for " + playerNames[player] + "...");
WriteGWToDB(GWPlayerData, playerNames[player]);
}
}
public static FPL.GWData populateStats(int playernum)
{
string htmlCode;
using (WebClient client = new WebClient())
{
client.Encoding = Encoding.UTF8;
string StatString = "https://fantasy.premierleague.com/api/element-summary/" + playernum.ToString() + "/";
htmlCode = client.DownloadString(@StatString);
}
FPL.GWData GWPlayerStats = JsonConvert.DeserializeObject <FPL.GWData>(htmlCode);
return(GWPlayerStats);
}
public static void WriteGWToDB(FPL.GWData GWPlayerData, string player)
{
con.ConnectionString = PostGresql;
try
{
con.Open();
for (int i = 0; i < GWPlayerData.history.Length; i++)
{
string CommandText = Script.getGWStatsString(GWPlayerData.history[i], player);
NpgsqlCommand updatePlayers = new NpgsqlCommand(CommandText, con);
updatePlayers.ExecuteNonQuery();
}
con.Close();
}
catch (Exception E)
{
Console.WriteLine("Exception " + E.Message + " Stack trace " + E.StackTrace);
}
}
