partial void DeletePLAYER_GAME_PASSING(PLAYER_GAME_PASSING instance);
partial void UpdatePLAYER_GAME_PASSING(PLAYER_GAME_PASSING instance);
partial void InsertPLAYER_GAME_PASSING(PLAYER_GAME_PASSING instance);
private void detach_PLAYER_GAME_PASSINGs(PLAYER_GAME_PASSING entity)
{
this.SendPropertyChanging();
entity.GAME1 = null;
}
private void attach_PLAYER_GAME_PASSINGs(PLAYER_GAME_PASSING entity)
{
this.SendPropertyChanging();
entity.PLAYER1 = this;
}
private void LoadGameStats(GAME Game, Page GamePage)
{
Table statTable = GamePage.Tables[4];
PLAYER player;
for (int i = 2; i < statTable.Rows.Count - 1; i++)
{
player = GetPlayer(statTable.Rows[i].Cells[0]);
PLAYER_GAME_PASSING passing = (from p in nflData.PLAYER_GAME_PASSINGs
where p.Game == Game.GAME_ID && p.Player == player.PLAYER_ID && p.Team == Game.AwayTeam
select p).SingleOrDefault();
if (passing == null)
{
passing = new PLAYER_GAME_PASSING();
passing.Game = Game.GAME_ID;
passing.Player = player.PLAYER_ID;
passing.Team = Game.AwayTeam;
nflData.PLAYER_GAME_PASSINGs.InsertOnSubmit(passing);
}
passing.Attempts = int.Parse(statTable.Rows[i].Cells[1].Text.Split('/')[0]);
passing.Completions = int.Parse(statTable.Rows[i].Cells[1].Text.Split('/')[1]);
passing.Yards = int.Parse(statTable.Rows[i].Cells[2].Text);
passing.Touchdowns = int.Parse(statTable.Rows[i].Cells[4].Text);
passing.Interceptions = int.Parse(statTable.Rows[i].Cells[5].Text);
//set the rest of the stats
}
nflData.SubmitChanges();
}