partial void UpdatePLAYER(PLAYER instance);
partial void DeletePLAYER(PLAYER instance);
partial void InsertPLAYER(PLAYER instance);
private void LoadPlayerStats(PLAYER Player)
{
parser.OpenPage(string.Format(PLAYERSTATS_URL, Player.MlbComId));
foreach (Table table in parser.CurrentPage.Tables)
{
if (table.Rows[0].Text.Length >= 8)
{
if (table.Rows[0].Text.Substring(0, 8).ToLower() == "pitching")
{
foreach (TableRow row in table.Rows)
{
int year;
if (int.TryParse(row.Cells[0].Text, out year))
{
TEAM team = GetTeam(row.Cells[1].Text);
PLAYER_YEARLY_PITCHING pitching = (from p in mlbData.PLAYER_YEARLY_PITCHINGs
where p.Player == Player.PLAYER_ID && p.Year == year && p.Team == team.TEAM_ID
select p).SingleOrDefault();
if (pitching == null)
{
//add new
pitching = new PLAYER_YEARLY_PITCHING();
pitching.Player = Player.PLAYER_ID;
pitching.Year = year;
pitching.Team = team.TEAM_ID;
mlbData.PLAYER_YEARLY_PITCHINGs.InsertOnSubmit(pitching);
}
pitching.W = ParseInt(row.Cells[2].Text);
pitching.L = ParseInt(row.Cells[3].Text);
pitching.G = ParseInt(row.Cells[5].Text);
pitching.GS = ParseInt(row.Cells[6].Text);
pitching.CG = ParseInt(row.Cells[7].Text);
pitching.SHO = ParseInt(row.Cells[8].Text);
pitching.SV = ParseInt(row.Cells[9].Text);
pitching.SVO = ParseInt(row.Cells[10].Text);
string[] innings = row.Cells[11].Text.Split('.');
pitching.OUTS = (ParseInt(innings[0]) * 3) + ParseInt(innings[1]);
pitching.H = ParseInt(row.Cells[12].Text);
pitching.R = ParseInt(row.Cells[13].Text);
pitching.ER = ParseInt(row.Cells[14].Text);
pitching.HR = ParseInt(row.Cells[15].Text);
pitching.HBP = ParseInt(row.Cells[16].Text);
pitching.BB = ParseInt(row.Cells[17].Text);
pitching.SO = ParseInt(row.Cells[18].Text);
}
}
}
else if (table.Rows[0].Text.Substring(0, 7).ToLower() == "hitting")
{
foreach (TableRow row in table.Rows)
{
int year;
if (int.TryParse(row.Cells[0].Text, out year))
{
TEAM team = GetTeam(row.Cells[1].Text);
PLAYER_YEARLY_BATTING batting = (from b in mlbData.PLAYER_YEARLY_BATTINGs
where b.Player == Player.PLAYER_ID && b.Year == year && b.Team == team.TEAM_ID
select b).SingleOrDefault();
if (batting == null)
{
//add new
batting = new PLAYER_YEARLY_BATTING();
batting.Player = Player.PLAYER_ID;
batting.Year = year;
batting.Team = team.TEAM_ID;
mlbData.PLAYER_YEARLY_BATTINGs.InsertOnSubmit(batting);
}
batting.G = ParseInt(row.Cells[2].Text);
batting.AB = ParseInt(row.Cells[3].Text);
batting.R = ParseInt(row.Cells[4].Text);
batting.H = ParseInt(row.Cells[5].Text);
batting._2B = ParseInt(row.Cells[6].Text);
batting._3B = ParseInt(row.Cells[7].Text);
batting.HR = ParseInt(row.Cells[8].Text);
batting.RBI = ParseInt(row.Cells[9].Text);
batting.BB = ParseInt(row.Cells[11].Text);
batting.SO = ParseInt(row.Cells[12].Text);
batting.SB = ParseInt(row.Cells[13].Text);
batting.CS = ParseInt(row.Cells[14].Text);
}
}
}
}
}
}
private void LoadPlayerBio(PLAYER Player)
{
}
private PLAYER GetPlayer(int PlayerId, string PlayerName)
{
PLAYER player = (from p in mlbData.PLAYERs
where p.MlbComId == PlayerId
select p).SingleOrDefault();
if (player == null)
{
player = new PLAYER();
player.MlbComId = PlayerId;
player.Name = PlayerName;
mlbData.PLAYERs.InsertOnSubmit(player);
mlbData.SubmitChanges();
}
return player;
}
private void LoadPlayerStats2(PLAYER Player)
{
parser.OpenPage(string.Format(PLAYERSTATS2_URL, Player.MlbComId));
foreach (Table table in parser.CurrentPage.Tables)
{
if (table.Rows[0].Text.Length >= 8)
{
if (table.Rows[0].Text.Substring(0, 8).ToLower() == "pitching")
{
foreach (TableRow row in table.Rows)
{
int year;
if (int.TryParse(row.Cells[0].Text, out year))
{
TEAM team = GetTeam(row.Cells[1].Text);
PLAYER_YEARLY_PITCHING pitching = (from p in mlbData.PLAYER_YEARLY_PITCHINGs
where p.Player == Player.PLAYER_ID && p.Year == year && p.Team == team.TEAM_ID
select p).SingleOrDefault();
if (pitching == null)
{
//error, a record should have been added from the primary page
}
else
{
pitching.TB = ParseInt(row.Cells[3].Text);
pitching.BK = ParseInt(row.Cells[4].Text);
pitching.WP = ParseInt(row.Cells[5].Text);
pitching.IBB = ParseInt(row.Cells[6].Text);
pitching.SB = ParseInt(row.Cells[7].Text);
pitching.CS = ParseInt(row.Cells[8].Text);
pitching.PK = ParseInt(row.Cells[9].Text);
pitching.GO = ParseInt(row.Cells[10].Text);
pitching.AO = ParseInt(row.Cells[11].Text);
}
}
}
}
else if (table.Rows[0].Text.Substring(0, 7).ToLower() == "hitting")
{
foreach (TableRow row in table.Rows)
{
int year;
if (int.TryParse(row.Cells[0].Text, out year))
{
TEAM team = GetTeam(row.Cells[1].Text);
PLAYER_YEARLY_BATTING batting = (from b in mlbData.PLAYER_YEARLY_BATTINGs
where b.Player == Player.PLAYER_ID && b.Year == year && b.Team == team.TEAM_ID
select b).SingleOrDefault();
if (batting == null)
{
//error, a record should have been added from the primary page
}
else
{
batting.SF = ParseInt(row.Cells[2].Text);
batting.SH = ParseInt(row.Cells[3].Text);
batting.HBP = ParseInt(row.Cells[4].Text);
batting.IBB = ParseInt(row.Cells[5].Text);
batting.GDP = ParseInt(row.Cells[6].Text);
batting.PA = ParseInt(row.Cells[7].Text);
batting.NP = ParseInt(row.Cells[8].Text);
batting.GO = ParseInt(row.Cells[11].Text);
batting.AO = ParseInt(row.Cells[12].Text);
}
}
}
}
}
}
}