//Delete From DB
        public void Delete(ClientFeeItem clientFeeItem)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_DeleteClientFeeItem_v1(
                clientFeeItem.ClientFeeItemId,
                adminUserGuid,
                clientFeeItem.VersionNumber
                );
        }
        //Add to DB
        public void Add(ClientFeeItem clientFeeItem)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_InsertClientFeeItem_v1(
                clientFeeItem.ClientFeeGroupId,
                clientFeeItem.ClientFeeId,
                clientFeeItem.ValueAmount,
                clientFeeItem.ValuePercentage,
                adminUserGuid
                );
        }
        //Update in DB
        public void Update(ClientFeeItem clientFeeItem)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_UpdateClientFeeItem_v1(
                clientFeeItem.ClientFeeItemId,
                clientFeeItem.ClientFeeId,
                clientFeeItem.ValueAmount,
                clientFeeItem.ValuePercentage,
                adminUserGuid,
                clientFeeItem.VersionNumber
                );
        }
        public ActionResult Edit(ClientFeeItemVM clientFeeItemVM)
        {
            ClientFeeItem clientFeeItem = new ClientFeeItem();

            clientFeeItem = clientFeeItemRepository.GetItem(clientFeeItemVM.ClientFeeItem.ClientFeeItemId);

            //Check Exists
            if (clientFeeItem == null)
            {
                ViewData["ActionMethod"] = "EditPost";
                return(View("RecordDoesNotExistError"));
            }

            //Update  Model from Form
            try
            {
                UpdateModel <ClientFeeItem>(clientFeeItem, "ClientFeeItem");
            }
            catch
            {
                string n = "";
                foreach (ModelState modelState in ViewData.ModelState.Values)
                {
                    foreach (ModelError error in modelState.Errors)
                    {
                        n += error.ErrorMessage;
                    }
                }
                ViewData["Message"] = "ValidationError : " + n;
                return(View("Error"));
            }

            //Database Update
            try
            {
                clientFeeItemRepository.Update(clientFeeItem);
            }
            catch (SqlException ex)
            {
                LogRepository logRepository = new LogRepository();
                logRepository.LogError(ex.Message);

                ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
                return(View("Error"));
            }

            return(RedirectToAction("List", new { id = clientFeeItem.ClientFeeGroup.ClientFeeGroupId }));
        }
        public ActionResult Delete(int id)
        {
            //Get Item From Database
            ClientFeeItem clientFeeItem = new ClientFeeItem();

            clientFeeItem = clientFeeItemRepository.GetItem(id);

            //Check Exists
            if (clientFeeItem == null)
            {
                ViewData["ActionMethod"] = "EditGet";
                return(View("RecordDoesNotExistError"));
            }

            //Check Access
            RolesRepository rolesRepository = new RolesRepository();

            if (!rolesRepository.HasWriteAccessToClientFeeGroup(clientFeeItem.ClientFeeGroupId))
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            ClientFeeItemVM clientFeeItemVM = new ClientFeeItemVM();

            clientFeeItemVM.ClientFeeItem = clientFeeItem;

            FeeTypeRepository feeTypeRepository = new FeeTypeRepository();
            FeeType           feeType           = new FeeType();

            feeType = feeTypeRepository.GetFeeType(clientFeeItem.ClientFee.FeeTypeId);
            if (feeType.FeeTypeDescription == "Client Fee")
            {
                feeType.FeeTypeDescription = "Transaction Fee";
            }
            clientFeeItemVM.FeeType = feeType;

            SelectList clientFees = new SelectList(clientFeeRepository.GetClientFeesByType(clientFeeItem.ClientFee.FeeTypeId).ToList(), "ClientFeeId", "ClientFeeDescription");

            clientFeeItemVM.ClientFees = clientFees;

            return(View(clientFeeItemVM));
        }
        public ActionResult Delete(ClientFeeItemVM clientFeeItemVM)
        {
            //Get Item
            ClientFeeItem clientFeeItem = new ClientFeeItem();

            clientFeeItem = clientFeeItemRepository.GetItem(clientFeeItemVM.ClientFeeItem.ClientFeeItemId);

            //Check Exists
            if (clientFeeItem == null)
            {
                ViewData["ActionMethod"] = "DeletePost";
                return(View("RecordDoesNotExistError"));
            }


            //Delete Item
            try
            {
                clientFeeItemRepository.Delete(clientFeeItemVM.ClientFeeItem);
            }
            catch (SqlException ex)
            {
                //Versioning Error - go to standard versionError page
                if (ex.Message == "SQLVersioningError")
                {
                    ViewData["ReturnURL"] = "/ClientFeeItem.mvc/Delete/" + clientFeeItem.ClientFeeItemId.ToString();
                    return(View("VersionError"));
                }
                //Generic Error
                ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
                return(View("Error"));
            }

            //Return
            return(RedirectToAction("List", new { id = clientFeeItem.ClientFeeGroup.ClientFeeGroupId }));
        }
        // GET: /View
        public ActionResult View(int id)
        {
            //Check Exists
            ClientFeeItem clientFeeItem = new ClientFeeItem();

            clientFeeItem = clientFeeItemRepository.GetItem(id);
            if (clientFeeItem == null)
            {
                ViewData["ActionMethod"] = "ViewGet";
                return(View("RecordDoesNotExistError"));
            }


            FeeTypeRepository feeTypeRepository = new FeeTypeRepository();
            FeeType           feeType           = new FeeType();

            feeType = feeTypeRepository.GetFeeType(clientFeeItem.ClientFee.FeeTypeId);

            ViewData["FeeTypeDescription"] = feeType.FeeTypeDescription;
            ViewData["ClientFeeGroupName"] = clientFeeItem.ClientFeeGroup.ClientFeeGroupName;
            ViewData["ClientFeeGroupId"]   = clientFeeItem.ClientFeeGroup.ClientFeeGroupId;

            return(View(clientFeeItem));
        }