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 DeleteTeam(int teamId)
{
var db = new MyTeamTrackerContext();
var teamToRemove = db.Teams.Single(x => x.Id == teamId);
db.Teams.Remove(teamToRemove);
db.SaveChanges();
}
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 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();
}
public List<VmTeam> GetTeams()
{
var db = new MyTeamTrackerContext();
var teams = db.Teams.ToList().Select(x => new VmTeam(x)).ToList();
return teams;
}
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);
}
