//Add Data From Linked Tables for Display public void EditItemForDisplay(ControlValueLanguage controlValueLanguage) { //Add LanguageName if (controlValueLanguage.LanguageCode != null) { LanguageRepository languageRepository = new LanguageRepository(); Language language = new Language(); language = languageRepository.GetLanguage(controlValueLanguage.LanguageCode); if (language != null) { controlValueLanguage.LanguageName = language.LanguageName; } } //Add PolicyGroupName ControlValueRepository controlValueRepository = new ControlValueRepository(); ControlValue controlValue = new ControlValue(); controlValue = controlValueRepository.GetControlValue(controlValueLanguage.ControlValueId); if (controlValue != null) { controlValueRepository.EditForDisplay(controlValue); //controlValueLanguage.ControlValue = controlValue.ControlValue1; } }
//Delete From DB public void Delete(ControlValueLanguage controlValueLanguage) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeleteControlValueLanguage_v1( controlValueLanguage.ControlValueId, controlValueLanguage.LanguageCode, adminUserGuid, controlValueLanguage.VersionNumber ); }
//Add to DB public void Add(ControlValueLanguage controlValueLanguage) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertControlValueLanguage_v1( controlValueLanguage.ControlValueId, controlValueLanguage.LanguageCode, controlValueLanguage.ControlValueTranslation, adminUserGuid ); }
//GET: View public ActionResult View(int id, string languageCode) { ControlValueLanguage controlValueLanguage = new ControlValueLanguage(); controlValueLanguage = controlValueLanguageRepository.GetItem(id, languageCode); if (controlValueLanguage == null) { ViewData["ActionMethod"] = "ListGet"; return(View("RecordDoesNotExistError")); } controlValueLanguageRepository.EditItemForDisplay(controlValueLanguage); return(View(controlValueLanguage)); }
public ActionResult Create(ControlValueLanguage controlValueLanguage) { ControlValue controlValue = new ControlValue(); controlValue = controlValueRepository.GetControlValue(controlValueLanguage.ControlValueId); //Check Exists if (controlValue == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToReferenceInfo()) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Model from Form try { UpdateModel(controlValueLanguage); } 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")); } controlValueLanguageRepository.Add(controlValueLanguage); return(RedirectToAction("List", new { id = controlValue.ControlValueId })); }
public ActionResult Delete(int id, string languageCode, FormCollection collection) { ControlValueLanguage controlValueLanguage = new ControlValueLanguage(); controlValueLanguage = controlValueLanguageRepository.GetItem(id, languageCode); if (controlValueLanguage == null) { //Doesn't Exist Error ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToReferenceInfo()) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Delete Item try { controlValueLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]); controlValueLanguageRepository.Delete(controlValueLanguage); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/ControlValueTranslation.mvc/Delete/" + controlValueLanguage.ControlValueId.ToString() + "/" + controlValueLanguage.LanguageCode; return(View("VersionError")); } //Generic Error return(View("Error")); } //Return return(RedirectToAction("List", new { id = controlValueLanguage.ControlValueId })); }
// GET: /Create public ActionResult Create(int id) { //Get ControlValue ControlValue controlValue = new ControlValue(); controlValue = controlValueRepository.GetControlValue(id); //Check Exists if (controlValue == null) { ViewData["ActionMethod"] = "CreateGet"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToReferenceInfo()) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Parent data ViewData["ControlValueId"] = id; ViewData["ControlValue"] = controlValue.ControlValue1; //New ControlValueLanguage ControlValueLanguage controlValueLanguage = new ControlValueLanguage(); controlValueLanguage.ControlValueId = id; controlValueLanguageRepository.EditItemForDisplay(controlValueLanguage); //Language SelectList SelectList languageList = new SelectList(controlValueLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; //Show Create Form return(View(controlValueLanguage)); }
public ActionResult Delete(int id, string languageCode) { ControlValueLanguage controlValueLanguage = new ControlValueLanguage(); controlValueLanguage = controlValueLanguageRepository.GetItem(id, languageCode); if (controlValueLanguage == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToReferenceInfo()) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } controlValueLanguageRepository.EditItemForDisplay(controlValueLanguage); return(View(controlValueLanguage)); }
public ActionResult Edit(int id, string languageCode, string controlValueTranslation) { //Get Item ControlValueLanguage controlValueLanguage = new ControlValueLanguage(); controlValueLanguage = controlValueLanguageRepository.GetItem(id, languageCode); //Check Exists if (controlValueLanguage == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToReferenceInfo()) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Item from Form try { UpdateModel(controlValueLanguage); } 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 { controlValueLanguageRepository.Update(controlValueLanguage); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/ControlValueTranslation.mvc/Edit/" + controlValueLanguage.ControlValueId + "/" + controlValueLanguage.LanguageCode; 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")); } //Update AirlineAdvice try { UpdateModel(controlValueLanguage); } 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")); } return(RedirectToAction("List", new { id = controlValueLanguage.ControlValueId })); }