public ActionResult Create(Personnel personnel)
        {
            if (ModelState.IsValid)
            {
                db.Personnels.Add(personnel);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "Description", personnel.LocationID);
            ViewBag.UserID = new SelectList(db.Users, "UserID", "FullName",personnel.UserID);
            ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", personnel.ValidationStateID);
            return View(personnel);
        }
 public ActionResult Edit(Personnel personnel)
 {
     if (ModelState.IsValid)
     {
         db.Entry(personnel).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "Description", personnel.LocationID);
     ViewBag.UserID = new SelectList(db.Users, "UserID", "FullName", personnel.UserID);
     ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", personnel.ValidationStateID);
     return View(personnel);
 }