public void CalculatePlayerResult(Player playerInput) { using (var dc = ThaitaeDataDataContext.Create()) { var playerTeamList = dc.Players.Where(item => item.SeasonId == playerInput.SeasonId && item.TeamId == playerInput.TeamId).ToList(); foreach (var player in playerTeamList) { var playerUpdate = dc.Players.Single(item => item.PlayerId == player.PlayerId); playerUpdate.PlayerGoal = dc.PlayerMatches.Count( item => item.PlayerGoal == 1 && item.PlayerId == player.PlayerId && item.TeamId == player.TeamId && item.SeasonId == player.SeasonId); playerUpdate.PlayerRedCard = dc.PlayerMatches.Count( item => item.PlayerRedCard == 1 && item.PlayerId == player.PlayerId && item.TeamId == player.TeamId && item.SeasonId == player.SeasonId); playerUpdate.PlayerYellowCard = dc.PlayerMatches.Count( item => item.PlayerYellowCard == 1 && item.PlayerId == player.PlayerId && item.TeamId == player.TeamId && item.SeasonId == player.SeasonId); dc.SubmitChanges(); } } }
public Player CalculatePlayerMatch(int playerMatchId, int playerNumber, string playerName) { Player playerUpdate; using (var dc = ThaitaeDataDataContext.Create()) { var playerMatch = dc.PlayerMatches.Single(item => item.PlayerMatchId == playerMatchId); var playerCheck = dc.Players.Count( item => item.SeasonId == playerMatch.SeasonId && item.TeamId == playerMatch.TeamId && item.PlayerNumber == playerNumber); if (playerCheck == 0) { var player = new Player { PlayerNumber = playerNumber, PlayerName = playerName, TeamId = playerMatch.TeamId, SeasonId = playerMatch.SeasonId }; dc.Players.InsertOnSubmit(player); dc.SubmitChanges(); playerMatch.PlayerId = player.PlayerId; dc.SubmitChanges(); playerUpdate = player; } else { var player = dc.Players.Single( item => item.SeasonId == playerMatch.SeasonId && item.TeamId == playerMatch.TeamId && item.PlayerNumber == playerNumber); playerMatch.PlayerId = player.PlayerId; playerMatch.PlayerId = player.PlayerId; if (!string.IsNullOrEmpty(playerName)) { player.PlayerName = playerName; } dc.SubmitChanges(); playerUpdate = player; } } return playerUpdate; }
partial void DeletePlayer(Player instance);
partial void UpdatePlayer(Player instance);
partial void InsertPlayer(Player instance);
private void detach_Players(Player entity) { this.SendPropertyChanging(); entity.Team = null; }
private void attach_Players(Player entity) { this.SendPropertyChanging(); entity.Team = this; }