public bool DeletePlayer(int playerId) { using (var ctx = new ApplicationDbContext()) { var entity = ctx .Players .Single(e => e.PlayerId == playerId); ctx.Players.Remove(entity); return(ctx.SaveChanges() == 1); } }
public DetailPlayer GetPlayerByID(int playerId) { using (var ctx = new ApplicationDbContext()) { var entity = ctx .Players .Single(e => e.PlayerId == playerId); List <ListPlayerStats> roster = entity.PlayerStats .Select( e => new ListPlayerStats { PlayerStatsId = e.PlayerStatsId, PlayerId = e.PlayerId, PassingYards = e.PassingYards, PassingTouchdowns = e.PassingTouchdowns, InterceptionThrown = e.InterceptionThrown, RushingYards = e.RushingYards, RushingAttempts = e.RushingAttempts, RushingTouchDowns = e.RushingTouchDowns, ReceivingYards = e.ReceivingYards, Catches = e.Catches, ReceivingTouchDowns = e.ReceivingTouchDowns, Fumbles = e.Fumbles, Tackles = e.Tackles, Sacks = e.Sacks, Interceptions = e.Interceptions, ForcedFumbles = e.ForcedFumbles, FumbleRecovery = e.FumbleRecovery, Safety = e.Safety, BlockedKick = e.BlockedKick, ReturnTouchDown = e.ReturnTouchDown } ).ToList(); return (new DetailPlayer { PlayerId = entity.PlayerId, TeamId = entity.TeamId, TeamName = entity.Team.TeamName, PlayerFirstName = entity.PlayerFirstName, PlayerLastName = entity.PlayerLastName, PlayerPosition = entity.PlayerPosition, PlayerJerseyNumber = entity.PlayerJerseyNumber, PlayerHeightByInches = entity.PlayerHeightByInches, PlayerWeightByPounds = entity.PlayerWeightByPounds, PlayerStats = roster }); } }
public bool CreatePlayer(CreatePlayer model) { var entity = new Player() { TeamId = model.TeamId, PlayerFirstName = model.PlayerFirstName, PlayerLastName = model.PlayerLastName, PlayerPosition = model.PlayerPosition, PlayerJerseyNumber = model.PlayerJerseyNumber, PlayerHeightByInches = model.PlayerHeightByInches, PlayerWeightByPounds = model.PlayerWeightByPounds }; using (var ctx = new ApplicationDbContext()) { ctx.Players.Add(entity); return(ctx.SaveChanges() == 1); } }
public bool UpdatePlayer(EditPlayer model) { using (var ctx = new ApplicationDbContext()) { var entity = ctx .Players .Single(e => e.PlayerId == model.PlayerId); entity.PlayerId = model.PlayerId; entity.TeamId = model.TeamId; entity.PlayerFirstName = model.PlayerFirstName; entity.PlayerLastName = model.PlayerLastName; entity.PlayerPosition = model.PlayerPosition; entity.PlayerJerseyNumber = model.PlayerJerseyNumber; entity.PlayerHeightByInches = model.PlayerHeightByInches; entity.PlayerWeightByPounds = model.PlayerWeightByPounds; return(ctx.SaveChanges() == 1); } }
public IEnumerable <ListPlayer> GetPlayer() { using (var ctx = new ApplicationDbContext()) { var query = ctx .Players .Select( e => new ListPlayer { PlayerId = e.PlayerId, TeamID = e.TeamId, TeamName = e.Team.TeamName, //available because of 'virtual' PlayerFirstName = e.PlayerFirstName, PlayerLastName = e.PlayerLastName, } ); return(query.ToArray()); } }