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

            var  repo     = new AdditionOrDeductionRepository();
            bool isexists = repo.IsFieldExists(repo.ConnectionString(), "AdditionDeduction", "AddDedName", model.AddDedName, null, null);

            if (!isexists)
            {
                var result = new AdditionOrDeductionRepository().Insert(model);
                if (result.AddDedId > 0)
                {
                    TempData["Success"]     = "Added Successfully!";
                    TempData["AddDedRefNo"] = result.AddDedRefNo;
                    return(RedirectToAction("Create"));
                }

                else
                {
                    FillAdditionDeduction();
                    TempData["error"]       = "Oops!!..Something Went Wrong!!";
                    TempData["AddDedRefNo"] = null;
                    return(View("Create", model));
                }
            }
            else
            {
                FillAdditionDeduction();
                TempData["error"]       = "This Name Alredy Exists!!";
                TempData["AddDedRefNo"] = null;
                return(View("Create", model));
            }
        }
        public ActionResult Delete(AdditionOrDeduction model)
        {
            int result = new AdditionOrDeductionRepository().Delete(model);

            if (result == 0)
            {
                TempData["Success"]     = "Deleted Successfully!";
                TempData["AddDedRefNo"] = model.AddDedRefNo;
                return(RedirectToAction("Create"));
            }
            else
            {
                if (result == 1)
                {
                    TempData["error"]       = "Sorry!! You Cannot Delete This Addition/Deduction It Is Already In Use";
                    TempData["AddDedRefNo"] = null;
                }
                else
                {
                    TempData["error"]       = "Oops!!..Something Went Wrong!!";
                    TempData["AddDedRefNo"] = null;
                }
                return(RedirectToAction("Create"));
            }
        }
        //    var result = new AdditionOrDeductionRepository().Update(model);

        //    if (result.AddDedId > 0)
        //    {
        //        TempData["Success"] = "Updated Successfully!";
        //        TempData["AddDedRefNo"] = result.AddDedRefNo;
        //        return RedirectToAction("Create");
        //    }
        //    else
        //    {
        //        TempData["error"] = "Oops!!..Something Went Wrong!!";
        //        TempData["AddDedRefNo"] = null;
        //        return View("Edit", model);
        //    }

        //}

        public ActionResult Delete(int Id)
        {
            FillAdditionDeduction();
            ViewBag.Title = "Delete";
            AdditionOrDeduction objAdditionOrDeduction = new AdditionOrDeductionRepository().GetAdditionOrDeduction(Id);

            return(View("Create", objAdditionOrDeduction));
        }
        public ActionResult FillAdditionDeductionList(int?page)
        {
            int itemsPerPage = 10;
            int pageNumber   = page ?? 1;
            var rep          = new AdditionOrDeductionRepository();
            var List         = rep.FillAdditionDeductionList();

            return(PartialView("AdditionDeductionListView", List));
        }