public IActionResult Create() { ViewData["ShaftId"] = new SelectList(_context.ShaftLocations.Where(s => s.Yupper != null && s.Xupper != null), "ShaftId", "Lookup"); ViewData["TombId"] = new SelectList(_context.TombLocations, "TombLocationId", "LookupValue"); ViewBag.Goods = new SelectList(YesNo.GetValues()); ViewBag.AgeCodeSingle = new SelectList(AgeCodes.GetValues()); ViewBag.BurialMaterials = new SelectList(YesNo.GetValues()); ViewBag.ArtifactFound = new SelectList(YesNo.GetValues()); ViewBag.HairColorCode = new SelectList(_context.HairColorCodes.ToList(), "HairColorCode", "HairColorDescription"); ViewData["PresIndex"] = new SelectList(_context.Mummies.Select(m => m.PreservationIndex).Distinct(), ViewBag.PresIndex); ViewData["HeadDirection"] = new SelectList(_context.Mummies.Select(m => m.HeadDirection).Distinct(), ViewBag.HeadDirection); return(View()); }