public List <VmPlayer> GetPlayers() { var db = new MyTeamTrackerContext(); var players = db.Players.ToList().Select(x => new VmPlayer(x)).ToList(); return(players); }
public VmTeam PostTeamChanges(VmTeam teamToSave) { var db = new MyTeamTrackerContext(); Team team; if (teamToSave.Id == 0) { team = db.Teams.SingleOrDefault(x => x.Name == teamToSave.Name); if (team == null) { team = new Team { Name = teamToSave.Name }; db.Teams.Add(team); } else { } } else { team = db.Teams.Single(x => x.Id == teamToSave.Id); team.Name = teamToSave.Name; } db.SaveChanges(); return(new VmTeam(team)); }
public List <VmTeam> GetTeams() { var db = new MyTeamTrackerContext(); var teams = db.Teams.ToList().Select(x => new VmTeam(x)).ToList(); return(teams); }
public VmPlayer PostPlayerChanges(VmPlayer memberToSave) { var db = new MyTeamTrackerContext(); Player player; if (memberToSave.Id == 0) { player = db.Players.SingleOrDefault(x => x.FirstName == memberToSave.FirstName && x.LastName == memberToSave.LastName); if (player == null) { player = new Player { LastName = memberToSave.LastName, FirstName = memberToSave.FirstName }; db.Players.Add(player); } else { } } else { player = db.Players.Single(x => x.Id == memberToSave.Id); player.FirstName = memberToSave.FirstName; player.LastName = memberToSave.LastName; } db.SaveChanges(); return(new VmPlayer(player)); }
public void DeletePlayer(int playerId) { var db = new MyTeamTrackerContext(); var playerToRemove = db.Players.Single(x => x.Id == playerId); db.Players.Remove(playerToRemove); db.SaveChanges(); }
public void DeleteTeam(int teamId) { var db = new MyTeamTrackerContext(); var teamToRemove = db.Teams.Single(x => x.Id == teamId); db.Teams.Remove(teamToRemove); db.SaveChanges(); }
public List <VmPlayer> GetTeamMembers(int teamId) { var teamMembers = new List <VmPlayer>(); var db = new MyTeamTrackerContext(); var team = db.Teams.Single(x => x.Id == teamId); teamMembers = team.Players.ToList().Select(x => new VmPlayer(x)).ToList(); return(teamMembers); }
public void AddPlayerToTeam(int playerId, int teamId) { var db = new MyTeamTrackerContext(); var playerToAdd = db.Players.Single(x => x.Id == playerId); var team = db.Teams.Single(x => x.Id == teamId); team.Players.Add(playerToAdd); db.SaveChanges(); }
public void PostRemovePlayerFromTeam(int playerId, int teamId) { var db = new MyTeamTrackerContext(); var playerToRemove = db.Players.Single(x => x.Id == playerId); var team = db.Teams.Single(x => x.Id == teamId); team.Players.Remove(playerToRemove); db.SaveChanges(); }