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