/// <summary>
///
/// </summary>
/// <param name="node"></param>
/// <returns></returns>
public static void InsertGameData(XmlNode node, Player player)
{
if (node.ChildNodes.Count != 19) throw new ArgumentException("Invalid number of childred in node. Maybe json has been updated");
PlayerGameData gameData = new PlayerGameData();
gameData.player = player.ID;
gameData.gameweek = int.Parse(node.ChildNodes[1].InnerText);
int otherTeam = new Team(node.ChildNodes[2].InnerText.Substring(0, 3)).teamID;
if ((gameData.game = DataAccess.Instance.GetGameIDByTeams(otherTeam, Form1.SEASON, gameData.gameweek, out gameData.team)) == 0)
{
throw new ArgumentOutOfRangeException("Game could not be found");
}
gameData.played = int.Parse(node.ChildNodes[3].InnerText);
gameData.goals = int.Parse(node.ChildNodes[4].InnerText);
gameData.assist = int.Parse(node.ChildNodes[5].InnerText);
gameData.cleansheets = int.Parse(node.ChildNodes[6].InnerText);
gameData.conceded = int.Parse(node.ChildNodes[7].InnerText);
gameData.ownGoal = int.Parse(node.ChildNodes[8].InnerText);
gameData.pensave = int.Parse(node.ChildNodes[9].InnerText);
gameData.penmiss = int.Parse(node.ChildNodes[10].InnerText);
gameData.yellow = int.Parse(node.ChildNodes[11].InnerText);
gameData.red = int.Parse(node.ChildNodes[12].InnerText);
gameData.saves = int.Parse(node.ChildNodes[13].InnerText);
gameData.bonus = int.Parse(node.ChildNodes[14].InnerText);
gameData.EAsports = int.Parse(node.ChildNodes[15].InnerText);
gameData.transfer = int.Parse(node.ChildNodes[16].InnerText);
gameData.value = double.Parse(node.ChildNodes[17].InnerText);
gameData.total = int.Parse(node.ChildNodes[18].InnerText);
if(gameData.played>0)gameData.Insert();
}
/// <summary>
///
/// </summary>
/// <param name="node"></param>
/// <returns></returns>
public static void InsertGameData(XmlNode node, Player player)
{
if (node.ChildNodes.Count != 19)
{
throw new ArgumentException("Invalid number of childred in node. Maybe json has been updated");
}
PlayerGameData gameData = new PlayerGameData();
gameData.player = player.ID;
gameData.gameweek = int.Parse(node.ChildNodes[1].InnerText);
int otherTeam = new Team(node.ChildNodes[2].InnerText.Substring(0, 3)).teamID;
if ((gameData.game = DataAccess.Instance.GetGameIDByTeams(otherTeam, Form1.SEASON, gameData.gameweek, out gameData.team)) == 0)
{
throw new ArgumentOutOfRangeException("Game could not be found");
}
gameData.played = int.Parse(node.ChildNodes[3].InnerText);
gameData.goals = int.Parse(node.ChildNodes[4].InnerText);
gameData.assist = int.Parse(node.ChildNodes[5].InnerText);
gameData.cleansheets = int.Parse(node.ChildNodes[6].InnerText);
gameData.conceded = int.Parse(node.ChildNodes[7].InnerText);
gameData.ownGoal = int.Parse(node.ChildNodes[8].InnerText);
gameData.pensave = int.Parse(node.ChildNodes[9].InnerText);
gameData.penmiss = int.Parse(node.ChildNodes[10].InnerText);
gameData.yellow = int.Parse(node.ChildNodes[11].InnerText);
gameData.red = int.Parse(node.ChildNodes[12].InnerText);
gameData.saves = int.Parse(node.ChildNodes[13].InnerText);
gameData.bonus = int.Parse(node.ChildNodes[14].InnerText);
gameData.EAsports = int.Parse(node.ChildNodes[15].InnerText);
gameData.transfer = int.Parse(node.ChildNodes[16].InnerText);
gameData.value = double.Parse(node.ChildNodes[17].InnerText);
gameData.total = int.Parse(node.ChildNodes[18].InnerText);
if (gameData.played > 0)
{
gameData.Insert();
}
}
public Boolean InsertPlayerGameData(PlayerGameData pgd, int playerID)
{
//TODO: The team information needs to be in here
SqlCommand verifyCmd = MyConnection.CreateCommand();
verifyCmd.CommandText = "SELECT * FROM PlayerGame WHERE Player = @PlayerID AND Game = @GameID";
verifyCmd.Parameters.AddWithValue("@PlayerID", pgd.player);
verifyCmd.Parameters.AddWithValue("@GameID", pgd.game);
MyConnection.Open();
SqlDataReader reader = verifyCmd.ExecuteReader();
bool hasRows = reader.HasRows;
MyConnection.Close();
int returnVal = 0;
if (!hasRows)
{
SqlCommand cmd = MyConnection.CreateCommand();
cmd.CommandText = "INSERT INTO PlayerGame(Played, Goals, Assists, Conceded, PenSave, PenMiss, Yellow, Red, Saves, Bonus, OwnGoal, Total, Game, Player, Team, NetTransfer, EASport, Value, CleanSheets) VALUES (@Played, @Goals, @Assists, @Conceded, @PenSave, @PenMiss, @Yellow, @Red, @Saves, @Bonus, @OwnGoal, @Total, @Game, @Player, @Team, @NetTransfer, @EASport, @Value, @CleanSheets)";
cmd.Parameters.Add(new SqlParameter("@Played", pgd.played));
cmd.Parameters.Add(new SqlParameter("@Goals", pgd.goals));
cmd.Parameters.Add(new SqlParameter("@Assists", pgd.assist));
cmd.Parameters.Add(new SqlParameter("@Conceded", pgd.conceded));
cmd.Parameters.Add(new SqlParameter("@PenSave", pgd.pensave));
cmd.Parameters.Add(new SqlParameter("@PenMiss", pgd.penmiss));
cmd.Parameters.Add(new SqlParameter("@Yellow", pgd.yellow));
cmd.Parameters.Add(new SqlParameter("@Red", pgd.red));
cmd.Parameters.Add(new SqlParameter("@Saves", pgd.saves));
cmd.Parameters.Add(new SqlParameter("@Bonus", pgd.bonus));
cmd.Parameters.Add(new SqlParameter("@OwnGoal", pgd.ownGoal));
cmd.Parameters.Add(new SqlParameter("@Total", pgd.total));
cmd.Parameters.Add(new SqlParameter("@Game", pgd.game));
cmd.Parameters.Add(new SqlParameter("@Player", playerID));
cmd.Parameters.Add(new SqlParameter("@Team", pgd.team)); //TODO: Fix with actual Team
cmd.Parameters.AddWithValue("@NetTransfer", pgd.transfer);
cmd.Parameters.AddWithValue("@EASport", pgd.EAsports);
cmd.Parameters.AddWithValue("@Value", pgd.value);
cmd.Parameters.AddWithValue("@CleanSheets", pgd.cleansheets);
MyConnection.Open();
returnVal = cmd.ExecuteNonQuery();
MyConnection.Close();
}
return returnVal != 0;
}