protected void JqgridHomeTeam_RowEditing(object sender, JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var team = dc.TeamMatches.Single(item => item.TeamMatchId == Convert.ToInt32(e.RowKey));
team.TeamGoalFor = Convert.ToInt32(e.RowData["TeamGoalFor"]);
team.TeamRedCard = Convert.ToInt32(e.RowData["TeamRedCard"]);
team.TeamYellowCard = Convert.ToInt32(e.RowData["TeamYellowCard"]);
if (team.TeamGoalFor == -1 && team.TeamRedCard == -1 && team.TeamYellowCard == -1)
{
team.TeamEdited = 0;
team.TeamStatus = 0;
team.TeamGoalAgainst = 0;
team.TeamGoalFor = 0;
team.TeamRedCard = 0;
team.TeamYellowCard = 0;
}
else
{
team.TeamEdited = 1;
var teamAgainst = dc.TeamMatches.Single(item => item.MatchId == Convert.ToInt32(e.ParentRowKey) && item.TeamHome == 0);
teamAgainst.TeamGoalAgainst = Convert.ToInt32(e.RowData["TeamGoalFor"]);
if (teamAgainst.TeamEdited == 1)
{
if (team.TeamGoalFor < teamAgainst.TeamGoalFor)
{
team.TeamStatus = 3;
teamAgainst.TeamStatus = 1;
}
else if (team.TeamGoalFor > teamAgainst.TeamGoalFor)
{
team.TeamStatus = 1;
teamAgainst.TeamStatus = 3;
}
else
{
team.TeamStatus = 2;
teamAgainst.TeamStatus = 2;
}
dc.SubmitChanges();
CalculateTeamResult(team, teamAgainst, Convert.ToInt32(Session["seasonid"]));
}
}
dc.SubmitChanges();
var removePlayerList =
dc.PlayerMatches.Where(item => item.TeamId == team.TeamId && item.MatchId == team.MatchId && item.SeasonId == team.SeasonId);
dc.PlayerMatches.DeleteAllOnSubmit(removePlayerList);
dc.SubmitChanges();
for (int i = 0; i < team.TeamGoalFor; i++)
{
var player = new PlayerMatch { PlayerGoal = 1, TeamId = team.TeamId, MatchId = team.MatchId, SeasonId = team.SeasonId };
dc.PlayerMatches.InsertOnSubmit(player);
dc.SubmitChanges();
}
for (int i = 0; i < team.TeamRedCard; i++)
{
var player = new PlayerMatch { PlayerRedCard = 1, TeamId = team.TeamId, MatchId = team.MatchId, SeasonId = team.SeasonId };
dc.PlayerMatches.InsertOnSubmit(player);
dc.SubmitChanges();
}
for (int i = 0; i < team.TeamYellowCard; i++)
{
var player = new PlayerMatch { PlayerYellowCard = 1, TeamId = team.TeamId, MatchId = team.MatchId, SeasonId = team.SeasonId };
dc.PlayerMatches.InsertOnSubmit(player);
dc.SubmitChanges();
}
}
}
partial void DeletePlayerMatch(PlayerMatch instance);
partial void UpdatePlayerMatch(PlayerMatch instance);
partial void InsertPlayerMatch(PlayerMatch instance);
private void detach_PlayerMatches(PlayerMatch entity)
{
this.SendPropertyChanging();
entity.Player = null;
}
private void attach_PlayerMatches(PlayerMatch entity)
{
this.SendPropertyChanging();
entity.Player = this;
}