/// <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 AddPlayer(Player player) { if (m_price + player.Price <= TEAMPRICE) { if (IsValidFormation(player.Position)) { m_form += player.Form; m_price += player.Price; m_points += player.Points; m_PositionCounts[(int)player.Position]++; m_Players.Add(player); return true; } return false; } return false; }
public void RemovePlayer(Player p) { m_Players.Remove(p); m_form -= p.Form; m_price -= p.Price; m_points -= p.Points; m_PositionCounts[(int)p.Position]--; }
public Boolean IsValidFormation(Player.Positions position) { int positionIndex = (int) position; if (m_PositionCounts[positionIndex] + 1 <= m_PositionMax[positionIndex]) { int playersNeededNotInThisPosition = 0; for (int x = 0; x < 4; x++) { if (x != positionIndex) playersNeededNotInThisPosition += Math.Max(m_PositionMin[x] - m_PositionCounts[x],0); } return (PlayersNeeded - 1) >= playersNeededNotInThisPosition; } else return false; }
public bool UpdatePlayer(Player P) { SqlCommand cmd = MyConnection.CreateCommand(); cmd.CommandText = "UPDATE Players SET Team = @Team, LastName = @LastName, Position = @Position, FLID = @FLID, Active = @Active, Price = @Price, FirstName = @FirstName, PhotoURL = @PhotoURL WHERE ID = @ID"; cmd.Parameters.Add(new SqlParameter("@Team", P.TeamID)); cmd.Parameters.Add(new SqlParameter("@LastName", P.PlayerName)); cmd.Parameters.Add(new SqlParameter("@Position", System.Enum.GetName(typeof(Player.Positions), P.Position))); cmd.Parameters.Add(new SqlParameter("@FLID", P.FLID)); cmd.Parameters.Add(new SqlParameter("@Active", P.Active ? 1 : 0)); cmd.Parameters.Add(new SqlParameter("@Price", P.Price)); cmd.Parameters.Add(new SqlParameter("@ID", P.ID)); cmd.Parameters.AddWithValue("@FirstName", P.FirstName); cmd.Parameters.AddWithValue("@PhotoURL", P.PhotoURL); MyConnection.Open(); int result = cmd.ExecuteNonQuery(); MyConnection.Close(); return result == 1; }
public List<Player> GetPlayers(params string[] parameters) { SqlCommand cmd = MyConnection.CreateCommand(); List<Player> players = new List<Player>(); cmd.CommandText = "SELECT * FROM Players"; cmd.CommandText += WhereClauseInterpreter(parameters); MyConnection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Player player = new Player() { Price = GetDBDouble(reader, "Price"), ID = GetDBInt(reader, "ID"), PlayerName = GetDBString(reader, "LastName"), TeamID = GetDBInt(reader, "Team"), Active = GetDBBool(reader, "Active"), FLID = GetDBInt(reader, "FLID"), Points = GetDBDouble(reader, "TotalPredicted"), FirstName = GetDBString (reader, "FirstName"), PhotoURL = GetDBString(reader, "PhotoURL"), Position = Player.GetPositionFromString(GetDBString(reader, "Position")), }; players.Add(player); } MyConnection.Close(); return players; }