public ActionResult Edit(EmployeeCategory model)
        {
            model.OrganizationId = OrganizationId;
            model.CreatedDate    = System.DateTime.Now;
            model.CreatedBy      = UserID.ToString();

            var  repo     = new EmployeeCategoryRepository();
            bool isexists = repo.IsFieldExists(repo.ConnectionString(), "EmployeeCategory", "EmpCategoryName", model.EmpCategoryName, " EmpCategoryId", model.EmpCategoryId);

            if (!isexists)
            {
                var result = new EmployeeCategoryRepository().UpdateEmployeeCategory(model);
                if (result.EmpCategoryId > 0)
                {
                    TempData["Success"] = "Updated Successfully!";
                    TempData["RefNo"]   = result.EmpCategoryRefNo;
                    return(RedirectToAction("Create"));
                }

                else
                {
                    TempData["error"] = "Oops!!..Something Went Wrong!!";
                    TempData["RefNo"] = null;
                    return(View("Create", model));
                }
            }
            else
            {
                TempData["error"] = "This Name Alredy Exists!!";
                TempData["RefNo"] = null;
                return(View("Create", model));
            }
        }
        public ActionResult Create(EmployeeCategory model)
        {
            model.CreatedBy = UserID.ToString();

            var repo = new EmployeeCategoryRepository();

            bool isexists = repo.IsFieldExists(repo.ConnectionString(), "EmployeeCategory", "EmpCategoryName", model.EmpCategoryName, null, null);

            if (!isexists)
            {
                var result = new EmployeeCategoryRepository().InsertEmployeeCategory(model);
                if (result.EmpCategoryId > 0)
                {
                    TempData["Success"] = "Added Successfully!";
                    TempData["RefNo"]   = result.EmpCategoryRefNo;
                    return(RedirectToAction("Create"));
                }

                else
                {
                    TempData["error"] = "Oops!!..Something Went Wrong!!";
                    TempData["RefNo"] = null;
                    return(View("Create", model));
                }
            }
            else
            {
                TempData["error"] = "This Name Alredy Exists!!";
                TempData["RefNo"] = null;
                return(View("Create", model));
            }
        }