public ActionResult UnDelete(int id)
        {
            ServiceAccountGDSAccessRight serviceAccountGDSAccessRight = new ServiceAccountGDSAccessRight();

            serviceAccountGDSAccessRight = serviceAccountGDSAccessRightRepository.GetServiceAccountGDSAccessRight(id);

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

            //Check AccessRights
            if (!rolesRepository.HasWriteAccessToServiceAccounts())
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            ServiceAccountGDSAccessRightVM serviceAccountGDSAccessRightVM = new ServiceAccountGDSAccessRightVM();

            //System User
            ServiceAccount serviceAccount = new ServiceAccount();

            serviceAccount = serviceAccountRepository.GetServiceAccount(serviceAccountGDSAccessRight.ServiceAccountId);
            if (serviceAccount != null)
            {
                serviceAccountGDSAccessRightVM.ServiceAccount = serviceAccount;
            }

            serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight = serviceAccountGDSAccessRight;

            return(View(serviceAccountGDSAccessRightVM));
        }
        public ActionResult View(int id)
        {
            ServiceAccountGDSAccessRight serviceAccountGDSAccessRight = new ServiceAccountGDSAccessRight();

            serviceAccountGDSAccessRight = serviceAccountGDSAccessRightRepository.GetServiceAccountGDSAccessRight(id);

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

            ServiceAccountGDSAccessRightVM serviceAccountGDSAccessRightVM = new ServiceAccountGDSAccessRightVM();

            //System User
            ServiceAccount serviceAccount = new ServiceAccount();

            serviceAccount = serviceAccountRepository.GetServiceAccount(serviceAccountGDSAccessRight.ServiceAccountId);
            if (serviceAccount != null)
            {
                serviceAccountGDSAccessRightVM.ServiceAccount = serviceAccount;
            }

            serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight = serviceAccountGDSAccessRight;

            return(View(serviceAccountGDSAccessRightVM));
        }
        public ActionResult Create(string id)
        {
            //Set Access Rights
            ViewData["Access"] = "";
            if (rolesRepository.HasWriteAccessToServiceAccounts())
            {
                ViewData["Access"] = "WriteAccess";
            }

            ServiceAccountGDSAccessRightVM serviceAccountGDSAccessRightVM = new ServiceAccountGDSAccessRightVM();

            ServiceAccountGDSAccessRight serviceAccountGDSAccessRight = new ServiceAccountGDSAccessRight();

            serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight = serviceAccountGDSAccessRight;

            //GDS
            serviceAccountGDSAccessRightVM.GDSs = new SelectList(gdsRepository.GetAllGDSs().ToList(), "GDSCode", "GDSName");

            //GDSAccessTypes
            serviceAccountGDSAccessRightVM.GDSAccessTypes = new SelectList(gdsAccessTypeRepository.GetAllGDSAccessTypes().ToList(), "GDSAccessTypeId", "GDSAccessTypeName");

            //ServiceAccount
            ServiceAccount serviceAccount = new ServiceAccount();

            serviceAccount = serviceAccountRepository.GetServiceAccount(id);
            if (serviceAccount != null)
            {
                serviceAccountGDSAccessRightVM.ServiceAccount = serviceAccount;
                serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight.ServiceAccountId = serviceAccount.ServiceAccountId;
            }

            return(View(serviceAccountGDSAccessRightVM));
        }
        //UpdateDeletedStatus ServiceAccountGDSAccessRight
        public void UpdateDeletedStatus(ServiceAccountGDSAccessRightVM gdsAccessTypeVM)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_UpdateServiceAccountGDSAccessRightDeletedStatus_v1(
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.ServiceAccountGDSAccessRightId,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.DeletedFlag,
                adminUserGuid,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.VersionNumber
                );
        }
        // GET: /Edit
        public ActionResult Edit(int id)
        {
            //Set Access Rights
            ViewData["Access"] = "";
            if (rolesRepository.HasWriteAccessToServiceAccounts())
            {
                ViewData["Access"] = "WriteAccess";
            }

            ServiceAccountGDSAccessRight serviceAccountGDSAccessRight = serviceAccountGDSAccessRightRepository.GetServiceAccountGDSAccessRight(id);

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

            //Check Access
            if (!rolesRepository.HasWriteAccessToServiceAccounts())
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            ServiceAccountGDSAccessRightVM serviceAccountGDSAccessRightVM = new ServiceAccountGDSAccessRightVM();

            serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight = serviceAccountGDSAccessRight;

            //GDS
            serviceAccountGDSAccessRightVM.GDSs = new SelectList(gdsRepository.GetAllGDSs().ToList(), "GDSCode", "GDSName", serviceAccountGDSAccessRight.GDSCode);

            //GDSAccessTypes
            serviceAccountGDSAccessRightVM.GDSAccessTypes = new SelectList(gdsAccessTypeRepository.GetGDSAccessTypesByGDSCode(serviceAccountGDSAccessRight.GDSCode).ToList(), "GDSAccessTypeId", "GDSAccessTypeName", serviceAccountGDSAccessRight.GDSAccessTypeId);

            //PseudoCityOrOfficeIds
            serviceAccountGDSAccessRightVM.PseudoCityOrOfficeIds = new SelectList(
                serviceAccountRepository.GetServiceAccountPseudoCityOrOfficeIdsByGDSCode(serviceAccountGDSAccessRight.GDSCode, serviceAccountGDSAccessRight.ServiceAccountId).ToList(),
                "PseudoCityOrOfficeId",
                "PseudoCityOrOfficeId",
                serviceAccountGDSAccessRight.PseudoCityOrOfficeId
                );

            //System User
            ServiceAccount serviceAccount = new ServiceAccount();

            serviceAccount = serviceAccountRepository.GetServiceAccount(serviceAccountGDSAccessRight.ServiceAccountId);
            if (serviceAccount != null)
            {
                serviceAccountGDSAccessRightVM.ServiceAccount = serviceAccount;
            }

            return(View(serviceAccountGDSAccessRightVM));
        }
        public ActionResult Create(ServiceAccountGDSAccessRightVM serviceAccountGDSAccessRightVM)
        {
            //Set Access Rights
            ViewData["Access"] = "";
            if (rolesRepository.HasWriteAccessToServiceAccounts())
            {
                ViewData["Access"] = "WriteAccess";
            }

            //Check Access
            if (!rolesRepository.HasWriteAccessToServiceAccounts())
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            //Update  Model from Form
            try
            {
                TryUpdateModel <ServiceAccountGDSAccessRightVM>(serviceAccountGDSAccessRightVM, "ServiceAccountGDSAccessRightVM");
            }
            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"));
            }

            try
            {
                serviceAccountGDSAccessRightRepository.Add(serviceAccountGDSAccessRightVM);
            }
            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("ListUnDeleted", new { id = serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight.ServiceAccountId }));
        }
        //Add ServiceAccountGDSAccessRight
        public void Add(ServiceAccountGDSAccessRightVM gdsAccessTypeVM)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_InsertServiceAccountGDSAccessRight_v1(
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.GDSSignOnID,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.GDSCode,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.PseudoCityOrOfficeId,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.TAGTIDCertificate,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.GDSAccessTypeId,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.RequestId,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.EnabledDate,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.ServiceAccountGDSAccessRightInternalRemark,
                gdsAccessTypeVM.ServiceAccountGDSAccessRight.ServiceAccountId,
                adminUserGuid
                );
        }
        public ActionResult UnDelete(ServiceAccountGDSAccessRightVM serviceAccountGDSAccessRightVM, FormCollection collection)
        {
            //Check Access
            if (!rolesRepository.HasWriteAccessToServiceAccounts())
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            //Get Item From Database
            ServiceAccountGDSAccessRight serviceAccountGDSAccessRight = new ServiceAccountGDSAccessRight();

            serviceAccountGDSAccessRight = serviceAccountGDSAccessRightRepository.GetServiceAccountGDSAccessRight(
                serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight.ServiceAccountGDSAccessRightId
                );

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

            //Delete Item
            try
            {
                serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight.DeletedFlag = false;
                serviceAccountGDSAccessRightRepository.UpdateDeletedStatus(serviceAccountGDSAccessRightVM);
            }
            catch (SqlException ex)
            {
                //Versioning Error - go to standard versionError page
                if (ex.Message == "SQLVersioningError")
                {
                    ViewData["ReturnURL"] = "/ServiceAccountGDSAccessRight.mvc/Delete/" + serviceAccountGDSAccessRight.ServiceAccountGDSAccessRightId;
                    return(View("VersionError"));
                }
                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("ListDeleted", new { id = serviceAccountGDSAccessRightVM.ServiceAccountGDSAccessRight.ServiceAccountId }));
        }