// GET: /PolicyOtherGroupHeaderTableNameLanguage/Edit
public ActionResult Edit(int id)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Get Item From Database
PolicyOtherGroupHeaderTableNameLanguage policyOtherGroupHeaderTableNameLanguage = new PolicyOtherGroupHeaderTableNameLanguage();
policyOtherGroupHeaderTableNameLanguage = policyOtherGroupHeaderTableNameLanguageRepository.GetPolicyOtherGroupHeaderTableNameLanguage(id);
//Check Exists
if (policyOtherGroupHeaderTableNameLanguage == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
PolicyOtherGroupHeaderTableNameLanguageVM policyOtherGroupHeaderTableNameLanguageVM = new PolicyOtherGroupHeaderTableNameLanguageVM();
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableNameLanguage = policyOtherGroupHeaderTableNameLanguage;
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName = new PolicyOtherGroupHeaderTableName();
policyOtherGroupHeaderTableName = policyOtherGroupHeaderTableNameRepository.GetPolicyOtherGroupHeaderTableNameByPolicyOtherGroupHeaderTableNameId(
policyOtherGroupHeaderTableNameLanguage.PolicyOtherGroupHeaderTableNameId
);
if (policyOtherGroupHeaderTableName != null)
{
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
}
PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader();
policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(policyOtherGroupHeaderTableName.PolicyOtherGroupHeaderId);
if (policyOtherGroupHeader != null)
{
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeader = policyOtherGroupHeader;
}
//Languages
List <Language> availableLanguages = policyOtherGroupHeaderTableNameLanguageRepository.GetAvailableLanguages(policyOtherGroupHeaderTableName.PolicyOtherGroupHeaderId).ToList();
Language selectedLanguage = new Language();
LanguageRepository languageRepository = new LanguageRepository();
selectedLanguage = languageRepository.GetLanguage(policyOtherGroupHeaderTableNameLanguage.LanguageCode);
if (selectedLanguage != null)
{
availableLanguages.Add(selectedLanguage);
}
SelectList languages = new SelectList(availableLanguages.OrderBy(x => x.LanguageCode), "LanguageCode", "LanguageName", policyOtherGroupHeaderTableNameLanguage.LanguageCode);
policyOtherGroupHeaderTableNameLanguageVM.Languages = languages;
return(View(policyOtherGroupHeaderTableNameLanguageVM));
}
//Get one PolicyOtherGroupHeader
public PolicyOtherGroupHeader GetPolicyOtherGroupHeader(int policyOtherGroupHeaderId)
{
PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader();
policyOtherGroupHeader = db.PolicyOtherGroupHeaders.Where(c => c.PolicyOtherGroupHeaderId == policyOtherGroupHeaderId).FirstOrDefault();
if (policyOtherGroupHeader != null)
{
//Labels
PolicyOtherGroupHeaderLabel policyOtherGroupHeaderLabel = new PolicyOtherGroupHeaderLabel();
policyOtherGroupHeaderLabel = db.PolicyOtherGroupHeaderLabels.Where(x => x.PolicyOtherGroupHeaderId == policyOtherGroupHeaderId).FirstOrDefault();
if (policyOtherGroupHeaderLabel != null)
{
policyOtherGroupHeader.Label = policyOtherGroupHeaderLabel.Label;
policyOtherGroupHeader.LabelLanguageCode = "en-gb";
}
//Table Name
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName = new PolicyOtherGroupHeaderTableName();
policyOtherGroupHeaderTableName = db.PolicyOtherGroupHeaderTableNames.Where(x => x.PolicyOtherGroupHeaderId == policyOtherGroupHeaderId).SingleOrDefault();
if (policyOtherGroupHeaderTableName != null)
{
policyOtherGroupHeader.TableName = policyOtherGroupHeaderTableName.TableName;
policyOtherGroupHeader.TableNameLanguageCode = "en-gb";
}
}
return(policyOtherGroupHeader);
}
public PolicyOtherGroupHeaderColumnNameVM(
PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName,
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName,
PolicyOtherGroupHeader policyOtherGroupHeader)
{
PolicyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnName;
PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
PolicyOtherGroupHeader = policyOtherGroupHeader;
}
public PolicyOtherGroupHeaderTableNameLanguageVM(
PolicyOtherGroupHeaderTableNameLanguage policyOtherGroupHeaderTableNameLanguage,
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName,
PolicyOtherGroupHeader policyOtherGroupHeader,
IEnumerable <SelectListItem> languages)
{
PolicyOtherGroupHeaderTableNameLanguage = policyOtherGroupHeaderTableNameLanguage;
PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
PolicyOtherGroupHeader = policyOtherGroupHeader;
Languages = languages;
}
public ActionResult Delete(int id)
{
//Get Item From Database
PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName = new PolicyOtherGroupHeaderColumnName();
policyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnNameRepository.GetPolicyOtherGroupHeaderColumnName(id);
//Check Exists
if (policyOtherGroupHeaderColumnName == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Get Table Name
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName = new PolicyOtherGroupHeaderTableName();
policyOtherGroupHeaderTableName = policyOtherGroupHeaderTableNameRepository.GetPolicyOtherGroupHeaderTableNameByPolicyOtherGroupHeaderTableNameId(policyOtherGroupHeaderColumnName.PolicyOtherGroupHeaderTableNameId);
//Check Exists
if (policyOtherGroupHeaderTableName == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Get Item From Database
PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader();
policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(policyOtherGroupHeaderTableName.PolicyOtherGroupHeaderId);
//Check Exists
if (policyOtherGroupHeader == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
PolicyOtherGroupHeaderColumnNameVM policyOtherGroupHeaderColumnNameVM = new PolicyOtherGroupHeaderColumnNameVM();
policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnName;
policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeader = policyOtherGroupHeader;
return(View(policyOtherGroupHeaderColumnNameVM));
}
public PolicyOtherGroupHeaderColumnNameLanguagesVM(
PolicyOtherGroupHeader policyOtherGroupHeader,
CWTPaginatedList <spDesktopDataAdmin_SelectPolicyOtherGroupHeaderColumnNameLanguages_v1Result> policyOtherGroupHeaderColumnNameLanguages,
PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName,
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName,
bool hasWriteAccess)
{
PolicyOtherGroupHeader = policyOtherGroupHeader;
PolicyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnName;
PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
PolicyOtherGroupHeaderColumnNameLanguages = policyOtherGroupHeaderColumnNameLanguages;
HasWriteAccess = hasWriteAccess;
}
//
// GET: /PolicyOtherGroupHeaderTableNameLanguage/Create
public ActionResult Create(int id)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Get Item From Database
PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader();
policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(id);
//Check Exists
if (policyOtherGroupHeader == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
PolicyOtherGroupHeaderTableNameLanguageVM policyOtherGroupHeaderTableNameLanguageVM = new PolicyOtherGroupHeaderTableNameLanguageVM();
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeader = policyOtherGroupHeader;
PolicyOtherGroupHeaderTableNameLanguage policyOtherGroupHeaderTableNameLanguage = new PolicyOtherGroupHeaderTableNameLanguage();
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableNameLanguage = policyOtherGroupHeaderTableNameLanguage;
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName = new PolicyOtherGroupHeaderTableName();
policyOtherGroupHeaderTableName = policyOtherGroupHeaderTableNameRepository.GetPolicyOtherGroupHeaderTableName(
policyOtherGroupHeader.PolicyOtherGroupHeaderId
);
if (policyOtherGroupHeaderTableName != null)
{
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
}
//Languages
SelectList languages = new SelectList(policyOtherGroupHeaderTableNameLanguageRepository.GetAvailableLanguages(id).ToList(), "LanguageCode", "LanguageName");
policyOtherGroupHeaderTableNameLanguageVM.Languages = languages;
return(View(policyOtherGroupHeaderTableNameLanguageVM));
}
//
// GET: /PolicyOtherGroupHeaderColumnNameLanguage/List
public ActionResult List(int id, string filter, int?page, string sortField, int?sortOrder)
{
//SortField
if (sortField == string.Empty)
{
sortField = "LanguageName";
}
ViewData["CurrentSortField"] = sortField;
//SortOrder
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
sortOrder = 0;
}
PolicyOtherGroupHeaderColumnNameLanguagesVM policyOtherGroupHeaderColumnNameLanguagesVM = new PolicyOtherGroupHeaderColumnNameLanguagesVM();
//Get Column Name
PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName = new PolicyOtherGroupHeaderColumnName();
policyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnNameRepository.GetPolicyOtherGroupHeaderColumnName(id);
if (policyOtherGroupHeaderColumnName != null)
{
policyOtherGroupHeaderColumnNameLanguagesVM.PolicyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnName;
}
//Check Exists
if (policyOtherGroupHeaderColumnName == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Get Table Name
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName = new PolicyOtherGroupHeaderTableName();
policyOtherGroupHeaderTableName = policyOtherGroupHeaderTableNameRepository.GetPolicyOtherGroupHeaderTableNameByPolicyOtherGroupHeaderTableNameId(policyOtherGroupHeaderColumnName.PolicyOtherGroupHeaderTableNameId);
if (policyOtherGroupHeaderTableName != null)
{
policyOtherGroupHeaderColumnNameLanguagesVM.PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
}
//Check Exists
if (policyOtherGroupHeaderTableName == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Get Policy Header
PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader();
policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(policyOtherGroupHeaderTableName.PolicyOtherGroupHeaderId);
if (policyOtherGroupHeader != null)
{
policyOtherGroupHeaderColumnNameLanguagesVM.PolicyOtherGroupHeader = policyOtherGroupHeader;
}
//Set Access Rights
if (hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
policyOtherGroupHeaderColumnNameLanguagesVM.HasWriteAccess = true;
}
//Get Items
if (policyOtherGroupHeaderColumnNameLanguageRepository != null)
{
var policyOtherGroupHeaderColumnNameLanguages = policyOtherGroupHeaderColumnNameLanguageRepository.PagePolicyOtherGroupHeaderColumnNameLanguages(id, page ?? 1, filter ?? "", sortField, sortOrder ?? 0);
if (policyOtherGroupHeaderColumnNameLanguages != null)
{
policyOtherGroupHeaderColumnNameLanguagesVM.PolicyOtherGroupHeaderColumnNameLanguages = policyOtherGroupHeaderColumnNameLanguages;
}
}
//return items
return(View(policyOtherGroupHeaderColumnNameLanguagesVM));
}
public ActionResult Delete(PolicyOtherGroupHeaderTableNameLanguageVM policyOtherGroupHeaderTableNameLanguageVM)
{
//Check Valid Item passed in Form
if (policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableNameLanguage == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Get Item From Database
PolicyOtherGroupHeaderTableNameLanguage policyOtherGroupHeaderTableNameLanguage = new PolicyOtherGroupHeaderTableNameLanguage();
policyOtherGroupHeaderTableNameLanguage = policyOtherGroupHeaderTableNameLanguageRepository.GetPolicyOtherGroupHeaderTableNameLanguage(policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableNameLanguage.PolicyOtherGroupHeaderTableNameLanguageId);
//Check Exists
if (policyOtherGroupHeaderTableNameLanguage == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName = new PolicyOtherGroupHeaderTableName();
policyOtherGroupHeaderTableName = policyOtherGroupHeaderTableNameRepository.GetPolicyOtherGroupHeaderTableNameByPolicyOtherGroupHeaderTableNameId(
policyOtherGroupHeaderTableNameLanguage.PolicyOtherGroupHeaderTableNameId
);
if (policyOtherGroupHeaderTableName != null)
{
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName;
}
PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader();
policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(policyOtherGroupHeaderTableName.PolicyOtherGroupHeaderId);
if (policyOtherGroupHeader != null)
{
policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeader = policyOtherGroupHeader;
}
//Delete Form Item
try
{
policyOtherGroupHeaderTableNameLanguageRepository.Delete(policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableNameLanguage);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/PolicyOtherGroupHeaderTableNameLanguage.mvc/Delete/" + policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeaderTableNameLanguage.PolicyOtherGroupHeaderTableNameLanguageId;
return(View("VersionError"));
}
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
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 = policyOtherGroupHeaderTableNameLanguageVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId }));
}
