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