//Add Data From Linked Tables for Display
        public void EditItemForDisplay(ReasonCodeAlternativeDescription reasonCodeAlternativeDescription)
        {
            //Add LanguageName
            if (reasonCodeAlternativeDescription.LanguageCode != null)
            {
                LanguageRepository languageRepository = new LanguageRepository();
                Language           language           = new Language();
                language = languageRepository.GetLanguage(reasonCodeAlternativeDescription.LanguageCode);
                if (language != null)
                {
                    reasonCodeAlternativeDescription.LanguageName = language.LanguageName;
                }
            }

            //Add PolicyGroupName
            ReasonCodeItemRepository reasonCodeItemRepository = new ReasonCodeItemRepository();
            ReasonCodeItem           reasonCodeItem           = new ReasonCodeItem();

            reasonCodeItem = reasonCodeItemRepository.GetItem(reasonCodeAlternativeDescription.ReasonCodeItemId);
            if (reasonCodeItem != null)
            {
                reasonCodeItemRepository.EditItemForDisplay(reasonCodeItem);
                reasonCodeAlternativeDescription.ReasonCodeItemDisplayOrder = reasonCodeItem.DisplayOrder;
            }
        }
        //GET: View
        public ActionResult View(int id, string languageCode)
        {
            //Get Item
            ReasonCodeAlternativeDescription reasonCodeAlternativeDescription = new ReasonCodeAlternativeDescription();

            reasonCodeAlternativeDescription = reasonCodeAlternativeDescriptionRepository.GetItem(id, languageCode);

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

            //Parent Information
            ReasonCodeItem reasonCodeItem = new ReasonCodeItem();

            reasonCodeItem = reasonCodeItemRepository.GetItem(id);
            reasonCodeItemRepository.EditItemForDisplay(reasonCodeItem);
            ViewData["ReasonCodeItem"]        = reasonCodeItem.ReasonCode + "/" + reasonCodeItem.ReasonCodeTypeDescription + "/" + reasonCodeItem.ProductName;
            ViewData["ReasonCodeItemId"]      = reasonCodeItem.ReasonCodeItemId;
            ViewData["ReasonCodeGroupId"]     = reasonCodeItem.ReasonCodeGroupId;
            ViewData["ReasonCodeGroupName"]   = reasonCodeGroupRepository.GetGroup(reasonCodeItem.ReasonCodeGroupId).ReasonCodeGroupName;
            ViewData["ReasonCodeDescription"] = reasonCodeItem.ReasonCodeDescription;

            reasonCodeAlternativeDescriptionRepository.EditItemForDisplay(reasonCodeAlternativeDescription);
            return(View(reasonCodeAlternativeDescription));
        }
        public ActionResult Create(ReasonCodeAlternativeDescription reasonCodeAlternativeDescription)
        {
            ReasonCodeItem reasonCodeItem = new ReasonCodeItem();

            reasonCodeItem = reasonCodeItemRepository.GetItem(reasonCodeAlternativeDescription.ReasonCodeItemId);

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

            //AccessRights
            RolesRepository rolesRepository = new RolesRepository();

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

            //Update  Model from Form
            try
            {
                UpdateModel(reasonCodeAlternativeDescription);
            }
            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
            {
                reasonCodeAlternativeDescriptionRepository.Add(reasonCodeAlternativeDescription);
            }
            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 = reasonCodeItem.ReasonCodeItemId }));
        }
        //Delete From DB
        public void Delete(ReasonCodeAlternativeDescription reasonCodeAlternativeDescription)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_DeleteReasonCodeAlternativeDescription_v1(
                reasonCodeAlternativeDescription.ReasonCodeItemId,
                reasonCodeAlternativeDescription.LanguageCode,
                adminUserGuid,
                reasonCodeAlternativeDescription.VersionNumber
                );
        }
        //Add to DB
        public void Add(ReasonCodeAlternativeDescription reasonCodeAlternativeDescription)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_InsertReasonCodeAlternativeDescription_v1(
                reasonCodeAlternativeDescription.ReasonCodeItemId,
                reasonCodeAlternativeDescription.LanguageCode,
                reasonCodeAlternativeDescription.ReasonCodeAlternativeDescription1,
                adminUserGuid
                );
        }
        public ActionResult Delete(int id, string languageCode, FormCollection collection)
        {
            //Get Item
            ReasonCodeAlternativeDescription reasonCodeAlternativeDescription = new ReasonCodeAlternativeDescription();

            reasonCodeAlternativeDescription = reasonCodeAlternativeDescriptionRepository.GetItem(id, languageCode);

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

            //Check AccessRights
            ReasonCodeItem reasonCodeItem = new ReasonCodeItem();

            reasonCodeItem = reasonCodeItemRepository.GetItem(id);
            RolesRepository rolesRepository = new RolesRepository();

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

            //Delete
            try
            {
                reasonCodeAlternativeDescription.VersionNumber = Int32.Parse(collection["VersionNumber"]);
                reasonCodeAlternativeDescriptionRepository.Delete(reasonCodeAlternativeDescription);
            }
            catch (SqlException ex)
            {
                //Versioning Error - go to standard versionError page
                if (ex.Message == "SQLVersioningError")
                {
                    ViewData["ReturnURL"] = "/ReasonCodeAlternativeDescription.mvc/Delete/" + reasonCodeAlternativeDescription.ReasonCodeItemId.ToString() + "/" + reasonCodeAlternativeDescription.LanguageCode;
                    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
            return(RedirectToAction("List", new { id = reasonCodeAlternativeDescription.ReasonCodeItemId }));
        }
        // GET: /Create
        public ActionResult Create(int id)
        {
            //Get PolicyAirVendorGroupItem
            ReasonCodeItem reasonCodeItem = new ReasonCodeItem();

            reasonCodeItem = reasonCodeItemRepository.GetItem(id);

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

            //AccessRights
            RolesRepository rolesRepository = new RolesRepository();

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

            //New ReasonCodeAlternativeDescription
            ReasonCodeAlternativeDescription reasonCodeAlternativeDescription = new ReasonCodeAlternativeDescription();

            reasonCodeAlternativeDescription.ReasonCodeItemId = id;


            //Language SelectList
            SelectList languageList = new SelectList(reasonCodeAlternativeDescriptionRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName");

            ViewData["Languages"] = languageList;

            //ParentInformation
            reasonCodeItemRepository.EditItemForDisplay(reasonCodeItem);
            ViewData["ReasonCodeItem"]        = reasonCodeItem.ReasonCode + "/" + reasonCodeItem.ReasonCodeTypeDescription + "/" + reasonCodeItem.ProductName;
            ViewData["ReasonCodeItemId"]      = reasonCodeItem.ReasonCodeItemId;
            ViewData["ReasonCodeGroupId"]     = reasonCodeItem.ReasonCodeGroupId;
            ViewData["ReasonCodeGroupName"]   = reasonCodeGroupRepository.GetGroup(reasonCodeItem.ReasonCodeGroupId).ReasonCodeGroupName;
            ViewData["ReasonCodeDescription"] = reasonCodeItem.ReasonCodeDescription;

            //Show Create Form
            reasonCodeAlternativeDescriptionRepository.EditItemForDisplay(reasonCodeAlternativeDescription);
            return(View(reasonCodeAlternativeDescription));
        }
        public ActionResult Delete(int id, string languageCode)
        {
            //Get Item
            ReasonCodeAlternativeDescription reasonCodeAlternativeDescription = new ReasonCodeAlternativeDescription();

            reasonCodeAlternativeDescription = reasonCodeAlternativeDescriptionRepository.GetItem(id, languageCode);

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

            //Check Access Rights
            ReasonCodeItem reasonCodeItem = new ReasonCodeItem();

            reasonCodeItem = reasonCodeItemRepository.GetItem(id);

            RolesRepository rolesRepository = new RolesRepository();

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

            //Parent Information
            reasonCodeItemRepository.EditItemForDisplay(reasonCodeItem);
            ViewData["ReasonCodeItem"]        = reasonCodeItem.ReasonCode + "/" + reasonCodeItem.ReasonCodeTypeDescription + "/" + reasonCodeItem.ProductName;
            ViewData["ReasonCodeItemId"]      = reasonCodeItem.ReasonCodeItemId;
            ViewData["ReasonCodeGroupId"]     = reasonCodeItem.ReasonCodeGroupId;
            ViewData["ReasonCodeGroupName"]   = reasonCodeGroupRepository.GetGroup(reasonCodeItem.ReasonCodeGroupId).ReasonCodeGroupName;
            ViewData["ReasonCodeDescription"] = reasonCodeItem.ReasonCodeDescription;

            //Add Linked Information
            reasonCodeAlternativeDescriptionRepository.EditItemForDisplay(reasonCodeAlternativeDescription);

            //Return View
            return(View(reasonCodeAlternativeDescription));
        }
        public ActionResult Edit(int id, string languageCode, string reasonCodeAlternativeDescription1)
        {
            //Get Item
            ReasonCodeAlternativeDescription reasonCodeAlternativeDescription = new ReasonCodeAlternativeDescription();

            reasonCodeAlternativeDescription = reasonCodeAlternativeDescriptionRepository.GetItem(id, languageCode);

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

            //Check AccessRights
            ReasonCodeItem reasonCodeItem = new ReasonCodeItem();

            reasonCodeItem = reasonCodeItemRepository.GetItem(id);

            RolesRepository rolesRepository = new RolesRepository();

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

            //Update  Model from Form
            try
            {
                UpdateModel(reasonCodeAlternativeDescription);
            }
            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"));
            }


            //Update AirlineAdvice
            try
            {
                reasonCodeAlternativeDescriptionRepository.Update(reasonCodeAlternativeDescription);
            }
            catch (SqlException ex)
            {
                //Versioning Error - go to standard versionError page
                if (ex.Message == "SQLVersioningError")
                {
                    ViewData["ReturnURL"] = "/ReasonCodeAlternativeDescription.mvc/Edit/" + reasonCodeAlternativeDescription.ReasonCodeItemId.ToString() + "/" + reasonCodeAlternativeDescription.LanguageCode;
                    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("List", new { id = reasonCodeItem.ReasonCodeItemId }));
        }