public IActionResult PostCityLanguage([FromBody] CityLanguage cityLanguage) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } this._cityLanguageRepository.AddCityLanguage(cityLanguage); try { if (this._cityLanguageRepository.Save()) { return(Ok(cityLanguage.CityId)); } else { return(Ok(0)); } } catch (Exception Error) { return(Ok(0)); } }
// GET: /Edit public ActionResult Edit(string id, string languageCode) { //Get Item CityLanguage cityLanguage = new CityLanguage(); cityLanguage = cityLanguageRepository.GetItem(id, languageCode); //Check Exists if (cityLanguage == null) { ViewData["ActionMethod"] = "EditGet"; 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")); } //Parent data ViewData["CityCode"] = id; ViewData["CityName"] = cityLanguage.City.Name; //Language SelectList SelectList languageList = new SelectList(cityLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; cityLanguageRepository.EditItemForDisplay(cityLanguage); return(View(cityLanguage)); }
// GET: /View public ActionResult ViewItem(string id, string languageCode) { //Get Item CityLanguage cityLanguage = new CityLanguage(); cityLanguage = cityLanguageRepository.GetItem(id, languageCode); //Check Exists if (cityLanguage == null) { ViewData["ActionMethod"] = "ViewItemGet"; return(View("RecordDoesNotExistError")); } //Parent data ViewData["CityCode"] = id; ViewData["CityName"] = cityLanguage.City.Name; ViewData["CountryName"] = cityLanguage.City.Country.CountryName; //Language SelectList SelectList languageList = new SelectList(cityLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; cityLanguageRepository.EditItemForDisplay(cityLanguage); return(View(cityLanguage)); }
public void AddLanguageToCity(int cityId, int languageId) { var link = new CityLanguage { CityId = cityId, LanguageId = languageId }; _context.CityLanguages.Add(link); }
//Delete From DB public void Delete(CityLanguage cityLanguage) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeleteCityLanguage_v1( cityLanguage.CityCode, cityLanguage.LanguageCode, adminUserGuid, cityLanguage.VersionNumber ); }
//Add to DB public void Add(CityLanguage cityLanguage) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertCityLanguage_v1( cityLanguage.CityCode, cityLanguage.LanguageCode, cityLanguage.CityName, adminUserGuid ); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(CityLanguage cityLanguage) { //Add LanguageName if (cityLanguage.LanguageCode != null) { LanguageRepository languageRepository = new LanguageRepository(); Language language = new Language(); language = languageRepository.GetLanguage(cityLanguage.LanguageCode); if (language != null) { cityLanguage.LanguageName = language.LanguageName; } } }
public ActionResult Delete(string id, string languageCode, FormCollection collection) { //Get Item CityLanguage cityLanguage = new CityLanguage(); cityLanguage = cityLanguageRepository.GetItem(id, languageCode); //Check Exists if (cityLanguage == null) { ViewData["ActionMethod"] = "EditPost"; 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 { cityLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]); cityLanguageRepository.Delete(cityLanguage); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/CityLanguage.mvc/Delete?id=" + cityLanguage.CityCode + "&languageCode=" + cityLanguage.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")); } //Return return(RedirectToAction("List", new { id = cityLanguage.CityCode })); }
public ActionResult Create(CityLanguage cityLanguage) { City city = new City(); city = cityRepository.GetCity(cityLanguage.CityCode); //Check Exists if (city == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } 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(cityLanguage); } 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")); } cityLanguageRepository.Add(cityLanguage); return(RedirectToAction("List", new { id = cityLanguage.CityCode })); }
public void AddCityLanguage(CityLanguage cityLanguage) { _context.CityLanguages.Add(cityLanguage); }
public ActionResult Edit(string id, string languageCode, FormCollection formCollection) { //Get Item CityLanguage cityLanguage = new CityLanguage(); cityLanguage = cityLanguageRepository.GetItem(id, languageCode); //Check Exists if (cityLanguage == null) { ViewData["ActionMethod"] = "EditPost"; 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(cityLanguage); } 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 { cityLanguageRepository.Update(cityLanguage); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/CityLanguage.mvc/Edit?id=" + cityLanguage.CityCode + "&languageCode=" + cityLanguage.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")); } return(RedirectToAction("List", new { id = cityLanguage.CityCode })); }
public void RemoveLanguageToCity(CityLanguage cityLanguage) { _context.CityLanguages.Remove(cityLanguage); }