public IHttpActionResult Players() { var dc = new AuctionTrackerContext(); var teams = dc.Teams.Include(t => t.Players).ToList(); return(Ok(teams)); }
public void DeletePlayer(Player player) { var dc = new AuctionTrackerContext(); dc.Players.Attach(player); dc.Entry <Player>(player).State = System.Data.Entity.EntityState.Deleted; dc.SaveChanges(); Clients.All.playerDeleted(player); }
public void UpdatePlayer(Player player, int originalTeamId) { var dc = new AuctionTrackerContext(); dc.Players.Attach(player); dc.Entry <Player>(player).State = System.Data.Entity.EntityState.Modified; dc.SaveChanges(); player.TeamName = dc.Teams.Single(t => t.ID == player.TeamID).Name; Clients.All.playerUpdated(player, originalTeamId); }
public void AuctionPlayer(Player player) { var dc = new AuctionTrackerContext(); dc.Players.Add(player); dc.SaveChanges(); var team = dc.Teams.Where(t => t.Players.Count() < 16).OrderBy(t => t.LastBid).First(); team.LastBid = DateTime.Now; dc.SaveChanges(); player.TeamName = team.Name; Clients.All.playerAuctioned(player); }
public IHttpActionResult Get() { var dc = new AuctionTrackerContext(); var result = (from p in dc.Players orderby p.ID descending select new { ID = p.ID, NflTeam = p.NflTeam, Team = p.Team.Name, TeamId = p.TeamID, FullName = p.FullName, Position = p.Position, AuctionAmount = p.AuctionAmount, }).Take(3); return(Ok(result.ToList())); }