public ActionResult DesignationCreate(DesignationDTO data)
        {
            try
            {
                if (!ModelState.IsValid)
                {
                    return(View(data));
                }
                DesignationDTO resDesgDTO = new DesignationDTO();
                resDesgDTO = _designationServices.InsertDesignation(data);
                ViewBag.designationList = _designationServices.GetDesignationList();
                ViewBag.levelList       = _levelService.GetLevellist();
                List <SelectListItem> GradeList = new List <SelectListItem>();

                ViewBag.gradeList = GradeList;
                ViewBag.success   = String.Format("The designation with code {0} has been inserted.", resDesgDTO.DesgCode);
                ModelState.Clear();
                return(View());
            }
            catch (Exception Ex)
            {
                ViewBag.error = Ex.Message;
                return(View());
            }
        }