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