public ActionResult Schedule(DateTime? date, ScheduleEditModel model)
{
var modelsForUpdate = model.Buckets
.SelectMany(b => b.Games.Where(g => g.HomeParticipant != null &&
g.RoadParticipant != null &&
(g.HomeParticipant.RunsScored != 0 || g.RoadParticipant.RunsScored != 0)))
.ToList();
var gameIds = modelsForUpdate.Select(g => g.GameId)
.ToArray();
var toUpdate = DbContext.Games
.Where(g => gameIds.Contains(g.GameId))
.ToList()
.Join(modelsForUpdate, g => g.GameId, m => m.GameId, (g, m) => new {Game = g, Model = m});
foreach (var row in toUpdate)
{
row.Game.GameStatusId = GameStatus.Final;
row.Game.RoadParticipant.RunsScored = row.Model.RoadParticipant.RunsScored;
row.Game.HomeParticipant.RunsScored = row.Model.HomeParticipant.RunsScored;
row.Game.IsFinalized = true;
row.Game.AddResultReportFromLeague();
}
DbContext.SaveChanges(User.Identity.GetUserId());
return RedirectToAction("Schedule", new { date = date?.ToString(Consts.DateFormat) });
}
public ActionResult Schedule(DateTime? date)
{
var now = CentralTimeZone.Now;
var games = date == null
? DbContext.Games.Where(g => !g.GameStatus.DisplayOutcome && g.GameDate < now && g.GameDate.Year == Consts.CurrentYear)
: DbContext.Games.Where(g => SqlFunctions.DateDiff("day", g.GameDate, date.Value) == 0);
var bucketedGames = games.ToList()
.ToLookup(g => ScheduleService.GetGameBucketForEdit(g, date != null));
var model = new ScheduleEditModel
{
Label = date?.ToString(Consts.DateFormatDisplay) ?? "All Unrecorded Games",
Date = date ?? now,
Buckets = Mapper.Map<List<ScheduleBucketEditModel>>(bucketedGames.OrderBy(g => g.Key.Sort))
};
return View(model);
}