private void AddAllPlayers(League lge) { DataTable tablePlayer; tablePlayer = DbUtils.GetDataTable(string.Format("select * from players")); if (tablePlayer.Rows.Count == 0) { return; } else { foreach (DataRow row in tablePlayer.Rows) { bool isBatter = Boolean.Parse(row["batter"].ToString()); if (isBatter) { Batter batter = new Batter(row); lge.AddPlayer(batter); } else { Pitcher pitcher = new Pitcher(row); lge.AddPlayer(pitcher); } } } return; }
private void AddAllPlayers2(League lge) { Dictionary<long, DataRow> batterStats = LoadDictionary("select * from batter_stats", "player_id"); Dictionary<long, DataRow> batterSkill = LoadDictionary("select * from batting_skill", "player_id"); Dictionary<long, DataRow> pitcherStats = LoadDictionary("select * from pitcher_stats", "player_id"); Dictionary<long, DataRow> pitcherSkill = LoadDictionary("select * from pitcher_skill", "player_id"); long id; DataTable tablePlayer; tablePlayer = DbUtils.GetDataTable(string.Format("select * from players")); if (tablePlayer.Rows.Count == 0) { return; } else { foreach (DataRow row in tablePlayer.Rows) { id = long.Parse(row["player_id"].ToString()); bool isBatter = Boolean.Parse(row["batter"].ToString()); if (isBatter) { Batter batter = new Batter(row, batterStats[id], batterSkill[id]); lge.AddPlayer(batter); } else { Pitcher pitcher = new Pitcher(row, pitcherStats[id], pitcherSkill[id]); lge.AddPlayer(pitcher); } } } return; }