public IActionResult EnterFieldExcavation(Excavation e) { var exeid = context.Excavation.Skip(context.Excavation.Count() - 1).Take(1).FirstOrDefault().ExcavationId; exeid++; e.ExcavationId = exeid; //first check data to make sure it's good before passing to Model and DB if (ModelState.IsValid) { NewMummy.burial.ExcavationId = e.ExcavationId; NewMummy.excavation = e; //Update Database context.Excavation.Add(e); context.SaveChanges(); return(View("EnterTablesMenuPage", NewMummy)); } //Otherwise return(View()); }
public IActionResult EditFieldExcavation2(Excavation e, int ExcavationID) { if (ModelState.IsValid) { var exc = context.Excavation.SingleOrDefault(x => x.ExcavationId == e.ExcavationId); context.Entry(exc).Property(x => x.ExcYear).CurrentValue = e.ExcYear; context.Entry(exc).Property(x => x.ExcMonth).CurrentValue = e.ExcMonth; context.Entry(exc).Property(x => x.ExcDayOfMonth).CurrentValue = e.ExcDayOfMonth; context.Entry(exc).Property(x => x.FieldBook).CurrentValue = e.FieldBook; context.Entry(exc).Property(x => x.FieldBookPageNum).CurrentValue = e.FieldBookPageNum; context.Entry(exc).Property(x => x.InitialsOfEntryExpert).CurrentValue = e.InitialsOfEntryExpert; context.Entry(exc).Property(x => x.InitialsOfEntryChecker).CurrentValue = e.InitialsOfEntryChecker; context.Entry(exc).Property(x => x.Byusample).CurrentValue = e.Byusample; context.SaveChanges(); return(RedirectToAction("BurialList")); } else { return(View()); } }
public IActionResult EditFieldExcavation(int ExcavationID) { Excavation e = context.Excavation.Single(x => x.ExcavationId == ExcavationID); return(View("EditFieldExcavation", e)); }