// GET: /Edit
        public ActionResult Edit(string id, int travelPortTypeId, string languageCode)
        {
            //Get Item
            TravelPortLanguage travelPortLanguage = new TravelPortLanguage();

            travelPortLanguage = travelPortLanguageRepository.GetTravelPortLanguage(id, travelPortTypeId, languageCode);

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

            //AccessRights
            HierarchyRepository hierarchyRepository = new HierarchyRepository();

            if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            //Return View
            travelPortLanguageRepository.EditForDisplay(travelPortLanguage);
            return(View(travelPortLanguage));
        }
        //Add Data From Linked Tables for Display
        public void EditForDisplay(TravelPortLanguage travelPortLanguage)
        {
            //Add TravelPortTypeDescription
            TravelPortTypeRepository travelPortTypeRepository = new TravelPortTypeRepository();
            TravelPortType           travelPortType           = new TravelPortType();

            travelPortType = travelPortTypeRepository.GetTravelPortType(travelPortLanguage.TravelPortTypeId);
            if (travelPortType != null)
            {
                travelPortLanguage.TravelPortTypeDescription = travelPortType.TravelPortTypeDescription;
            }

            //Add LanguageName
            if (travelPortLanguage.LanguageCode != null)
            {
                LanguageRepository languageRepository = new LanguageRepository();
                Language           language           = new Language();
                language = languageRepository.GetLanguage(travelPortLanguage.LanguageCode);
                if (language != null)
                {
                    travelPortLanguage.LanguageName = language.LanguageName;
                }
            }

            //Add TravelPortCodeTravelPortName (name of original)
            TravelPortRepository travelPortRepository = new TravelPortRepository();
            TravelPort           travelPort           = new TravelPort();

            travelPort = travelPortRepository.GetTravelPort(travelPortLanguage.TravelPortCode);
            if (travelPort != null)
            {
                travelPortLanguage.TravelPortCodeTravelPortName = travelPort.TravelportName;
            }
        }
        //Add to DB
        public void Add(TravelPortLanguage travelPortLanguage)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_InsertTravelPortLanguage_v1(
                travelPortLanguage.TravelPortCode,
                travelPortLanguage.TravelPortTypeId,
                travelPortLanguage.LanguageCode,
                travelPortLanguage.TravelPortName,
                adminUserGuid
                );
        }
        //Delete From DB
        public void Delete(TravelPortLanguage travelPortLanguage)
        {
            string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];

            db.spDesktopDataAdmin_DeleteTravelPortLanguage_v1(
                travelPortLanguage.TravelPortCode,
                travelPortLanguage.TravelPortTypeId,
                travelPortLanguage.LanguageCode,
                adminUserGuid,
                travelPortLanguage.VersionNumber
                );
        }
        public ActionResult Delete(string id, int travelPortTypeId, string languageCode, FormCollection collection)
        {
            //Get Item
            TravelPortLanguage travelPortLanguage = new TravelPortLanguage();

            travelPortLanguage = travelPortLanguageRepository.GetTravelPortLanguage(id, travelPortTypeId, languageCode);

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

            //AccessRights
            HierarchyRepository hierarchyRepository = new HierarchyRepository();

            if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }


            //Delete Item
            try
            {
                travelPortLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]);
                travelPortLanguageRepository.Delete(travelPortLanguage);
            }
            catch (SqlException ex)
            {
                //Versioning Error - go to standard versionError page
                if (ex.Message == "SQLVersioningError")
                {
                    ViewData["ReturnURL"] = "/TravelPortLanguage.mvc/Delete/?id=" + travelPortLanguage.TravelPortCode + "&languageCode=" + travelPortLanguage.LanguageCode + "&travelPortTypeId=" + travelPortLanguage.TravelPortTypeId;
                    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"));
            }

            //Success
            return(RedirectToAction("List", new { id = travelPortLanguage.TravelPortCode }));
        }
        // GET: /Create
        public ActionResult Create(string id)
        {
            //Get Parent
            TravelPort travelPort = new TravelPort();

            travelPort = travelPortRepository.GetTravelPort(id);

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

            //AccessRights
            HierarchyRepository hierarchyRepository = new HierarchyRepository();

            if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            //New TravelPortLanguage
            TravelPortLanguage travelPortLanguage = new TravelPortLanguage();

            travelPortLanguage.TravelPortCode = id;
            travelPortLanguageRepository.EditForDisplay(travelPortLanguage);

            //Populate List of Languages
            LanguageRepository languageRepository = new LanguageRepository();
            SelectList         languages          = new SelectList(languageRepository.GetAllLanguages().ToList(), "LanguageCode", "LanguageName");

            ViewData["LanguageList"] = languages;

            //Populate List of Languages
            TravelPortTypeRepository travelPortTypeRepository = new TravelPortTypeRepository();
            SelectList travelPortTypes = new SelectList(travelPortTypeRepository.GetAllTravelPortTypes().ToList(), "TravelPortTypeId", "TravelPortTypeDescription");

            ViewData["TravelPortTypeList"] = travelPortTypes;

            //Show Create Form
            return(View(travelPortLanguage));
        }
        public ActionResult Create(TravelPortLanguage travelPortLanguage)
        {
            //AccessRights
            HierarchyRepository hierarchyRepository = new HierarchyRepository();

            if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }

            //Update  Model from Form
            try
            {
                UpdateModel(travelPortLanguage);
            }
            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
            {
                travelPortLanguageRepository.Add(travelPortLanguage);
            }
            catch
            {
                //Could not insert to database
                return(View("Error"));
            }

            ViewData["NewSortOrder"] = 0;
            return(RedirectToAction("List", new { id = travelPortLanguage.TravelPortCode }));
        }
        public ActionResult Edit(string id, int travelPortTypeId, string languageCode, FormCollection collection)
        {
            //Get Item
            TravelPortLanguage travelPortLanguage = new TravelPortLanguage();

            travelPortLanguage = travelPortLanguageRepository.GetTravelPortLanguage(id, travelPortTypeId, languageCode);

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

            //AccessRights
            HierarchyRepository hierarchyRepository = new HierarchyRepository();

            if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
            {
                ViewData["Message"] = "You do not have access to this item";
                return(View("Error"));
            }
            //Update Item from Form
            try
            {
                UpdateModel(travelPortLanguage);
            }
            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
            {
                travelPortLanguageRepository.Update(travelPortLanguage);
            }
            catch (SqlException ex)
            {
                //Versioning Error
                if (ex.Message == "SQLVersioningError")
                {
                    ViewData["ReturnURL"] = "/TravelPortLanguage.mvc/Edit/?id=" + travelPortLanguage.TravelPortCode + "&languageCode=" + travelPortLanguage.LanguageCode + "&travelPortTypeId=" + travelPortLanguage.TravelPortTypeId;
                    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"));
            }

            //Success
            return(RedirectToAction("List", new { id = travelPortLanguage.TravelPortCode }));
        }