public ActionResult New()
        {
            PersonnelFormViewModels vm = new PersonnelFormViewModels()
            {
                departments = db.tblDepartment.ToList(),
                personnel   = new tblPersonnel()
            };

            return(View("PersonnelForm", vm));
        }
        public ActionResult Update(int ID)
        {
            var model = new PersonnelFormViewModels()
            {
                departments = db.tblDepartment.ToList(),
                personnel   = db.tblPersonnel.Find(ID)
            };

            if (model == null)
            {
                return(HttpNotFound());
            }
            return(View("PersonnelForm", model));
        }
        public ActionResult Save(tblPersonnel personnel)
        {
            if (!ModelState.IsValid)
            {
                var model = new PersonnelFormViewModels()
                {
                    departments = db.tblDepartment.ToList(),
                    personnel   = personnel
                };
                return(View("PersonnelForm", model));
            }
            if (personnel.p_ID == 0)
            {
                personnel.p_IsActive = true;
                db.tblPersonnel.Add(personnel);
            }
            else
            {
                db.Entry(personnel).State = EntityState.Modified;
            }

            db.SaveChanges();
            return(RedirectToAction("Index"));
        }