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));
        }