// 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 })); }