public JsonResult GetTypeSalutation()
        {
            CommonRepository modelRepo = new CommonRepository();
            // var status = modelRepo.ReadAllStatus();

            return Json(modelRepo.ReadAllTitles().OrderBy(o => o.TitleName).Select(c => new { TitleID = c.TitleID, TitleName = c.TitleName }).OrderBy(o => o.TitleName), JsonRequestBehavior.AllowGet);
            //return Json(modelRepo.ReadAllTitles(), JsonRequestBehavior.AllowGet);
        }
        public static SelectList GetTitle(long? TitleID)
        {
            CommonRepository modelRepo = new CommonRepository();
            var status = modelRepo.ReadAllTitles();

            List<SelectListItem> _ListTitle = new List<SelectListItem>();

                foreach (var item in status)
                {
                    SelectListItem itr = new SelectListItem();
                    itr.Text = item.TitleName;
                    itr.Value = item.TitleID.ToString();
                    itr.Selected = false;

                    _ListTitle.Add(itr);
                }

            return new SelectList(_ListTitle, "Value", "Text", TitleID);
        }