public ActionResult PickGames(BulkPickEditor bpe)
{
bpe.Player = db.Players.Find(bpe.PlayerId);
var pgs = from g in db.Games.Where(q => q.Week == bpe.Week && q.Year == bpe.Year)
join p in db.Picks.Where(q => q.PlayerId == bpe.PlayerId) on g.Id equals p.GameId into j1
from j2 in j1.DefaultIfEmpty()
select new { Game = g, Pick = j2 };
List<Pick> picks = new List<Pick>();
foreach (var pg in pgs)
{
Pick pick = pg.Pick ?? new Pick();
pick.GameId = pg.Game.Id;
pick.Game = pg.Game;
pick.PlayerId = bpe.PlayerId;
pick.Player = bpe.Player;
picks.Add(pick);
}
bpe.Picks = picks;
return View(bpe);
}
public ActionResult SubmitPicks(BulkPickEditor bpe)
{
if (ModelState.IsValid)
{
foreach (var pick in bpe.Picks)
{
if (pick.Id != 0)
{
db.Entry(pick).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.Picks.Add(pick);
}
}
db.SaveChanges();
}
return RedirectToAction("Index");
}
