private void SetupMissingWeeks()
{
BuffetRotatingWeek newWeek = new BuffetRotatingWeek();
//get most recent week
BuffetRotatingWeek recentMostWeek = _dbContext.BuffetRotatingWeeks
.Include("Meat.NextItem")
.Include("Casserole.NextItem")
.Include("Corn.NextItem")
.Include("Beans.NextItem").OrderByDescending(brw => brw.SundayDate).First();
newWeek.SundayDate = recentMostWeek.SundayDate.AddDays(7);
newWeek.Meat = recentMostWeek.Meat.NextItem;
newWeek.Casserole = recentMostWeek.Casserole.NextItem;
newWeek.Corn = recentMostWeek.Corn.NextItem;
newWeek.Beans = recentMostWeek.Beans.NextItem;
_dbContext.BuffetRotatingWeeks.Add(newWeek);
_dbContext.SaveChanges();
}
public ActionResult EditRotating(BuffetRotatingWeek week)
{
if (ModelState.IsValid)
{
BuffetRotatingWeek oldWeek = _dbContext.BuffetRotatingWeeks.First(bi => bi.Id == week.Id);
int meatId;
int cornId;
int casseroleId;
int beansId;
if (int.TryParse(Request.Form["Meat.Id"], out meatId) &&
int.TryParse(Request.Form["Corn.Id"], out cornId) &&
int.TryParse(Request.Form["Casserole.Id"], out casseroleId) &&
int.TryParse(Request.Form["Beans.Id"], out beansId))
{
oldWeek.Meat = _dbContext.BuffetSchedules.First(bi => bi.Id == meatId);
oldWeek.Corn = _dbContext.BuffetSchedules.First(bi => bi.Id == cornId);
oldWeek.Casserole = _dbContext.BuffetSchedules.First(bi => bi.Id == casseroleId);
oldWeek.Beans = _dbContext.BuffetSchedules.First(bi => bi.Id == beansId);
oldWeek.SundayDate = week.SundayDate;
_dbContext.SaveChanges();
return RedirectToAction("Index");
}
}
ViewBag.FoodTypes = new SelectList(_dbContext.FoodTypes.ToList(), "Id", "Name");
return View(week);
}
