public bool UpdatePlayerStats(PlayerStatEdit playerStat)
{
using (var db = new ApplicationDbContext())
{
var entity =
db
.PlayerStats
.Single(e => e.PlayerID == playerStat.PlayerID && e.YearOfSeason == playerStat.YearOfSeason && e.GameNumber == playerStat.GameNumber && e.CoachID == _userID);
entity.PlayerID = playerStat.PlayerID;
entity.YearOfSeason = playerStat.YearOfSeason;
entity.GameNumber = playerStat.GameNumber;
entity.Goals = playerStat.Goals;
entity.Assists = playerStat.Assists;
entity.Shots = playerStat.Shots;
return(db.SaveChanges() == 1);
}
}
public ActionResult Edit(int id, int year, int game, PlayerStatEdit playerStat)
{
if (!ModelState.IsValid)
{
return(View(playerStat));
}
if (playerStat.PlayerID != id || playerStat.YearOfSeason != year || playerStat.GameNumber != game)
{
ModelState.AddModelError("", "ID Mismatch");
return(View(playerStat));
}
var service = CreatePlayerStatService();
if (service.UpdatePlayerStats(playerStat))
{
TempData["SaveResult"] = "Stats were updated.";
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", "Stats could not be updated.");
return(View(playerStat));
}
// GET: PlayerStat/Edit/5
public ActionResult Edit(int id, int year, int game)
{
var teams = _db.Teams.ToList().Where(t => t.CoachID == Guid.Parse(User.Identity.GetUserId()));
var players = _db.Players.ToList().Where(t => t.CoachID == Guid.Parse(User.Identity.GetUserId()));
ViewBag.PlayerID = new SelectList(players, "PlayerID", "FullName");
ViewBag.TeamID = new SelectList(teams, "TeamID", "TeamName");
var service = CreatePlayerStatService();
var detail = service.GetStatByID(id, year, game);
var model =
new PlayerStatEdit
{
PlayerID = detail.PlayerID,
FullName = detail.FullName,
YearOfSeason = detail.YearOfSeason,
GameNumber = detail.GameNumber,
Goals = detail.Goals,
Assists = detail.Assists,
Shots = detail.Shots
};
return(View(model));
}
