// GET: /Create
public ActionResult Create()
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
TripTypeRepository tripTypeRepository = new TripTypeRepository();
SelectList tripTypesList = new SelectList(tripTypeRepository.GetAllTripTypes().ToList(), "TripTypeId", "TripTypeDescription");
ViewData["TripTypes"] = tripTypesList;
ExternalSystemParameterTypeRepository externalSystemParameterTypeRepository = new ExternalSystemParameterTypeRepository();
SelectList externalSystemParameterTypeList = new SelectList(externalSystemParameterTypeRepository.GetAllExternalSystemParameterTypes().ToList(), "ExternalSystemParameterTypeId", "ExternalSystemParameterTypeName");
ViewData["ExternalSystemParameterTypes"] = externalSystemParameterTypeList;
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(), "HierarchyLevelTableName", "HierarchyLevelTableName");
ViewData["HierarchyTypes"] = hierarchyTypesList;
ExternalSystemParameter group = new ExternalSystemParameter();
return(View(group));
}
//Change the deleted status on an item
public void UpdateGroupDeletedStatus(ExternalSystemParameter group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateExternalSystemParameterDeletedStatus_v1(
group.ExternalSystemParameterId,
group.DeletedFlag,
adminUserGuid,
group.VersionNumber
);
}
//Add Data From Linked Tables for Display
public void EditGroupForDisplay(ExternalSystemParameter group)
{
TripTypeRepository tripTypeRepository = new TripTypeRepository();
TripType tripType = new TripType();
tripType = tripTypeRepository.GetTripType(group.TripTypeId);
if (tripType != null)
{
group.TripType = tripType.TripTypeDescription;
}
ExternalSystemParameterTypeRepository externalSystemParameterTypeRepository = new ExternalSystemParameterTypeRepository();
ExternalSystemParameterType externalSystemParameterType = new ExternalSystemParameterType();
externalSystemParameterType = externalSystemParameterTypeRepository.GetExternalSystemParameterType(group.ExternalSystemParameterTypeId);
if (externalSystemParameterType != null)
{
group.ExternalSystemParameterType = externalSystemParameterType.ExternalSystemParameterTypeName;
}
fnDesktopDataAdmin_SelectExternalSystemParameterHierarchy_v1Result hierarchy = new fnDesktopDataAdmin_SelectExternalSystemParameterHierarchy_v1Result();
hierarchy = GetGroupHierarchy(group.ExternalSystemParameterId);
if (hierarchy != null)
{
HierarchyRepository hierarchyRepository = new HierarchyRepository();
HierarchyGroup hierarchyGroup = hierarchyRepository.GetHierarchyGroup(
hierarchy.HierarchyType ?? "",
hierarchy.HierarchyCode ?? "",
hierarchy.HierarchyName ?? "",
hierarchy.TravelerTypeGuid ?? "",
hierarchy.TravelerTypeName ?? "",
hierarchy.SourceSystemCode ?? ""
);
if (hierarchyGroup != null)
{
group.HierarchyType = hierarchyGroup.HierarchyType;
group.HierarchyCode = hierarchyGroup.HierarchyCode;
group.HierarchyItem = hierarchyGroup.HierarchyItem;
group.ClientSubUnitGuid = hierarchyGroup.ClientSubUnitGuid;
group.ClientSubUnitName = hierarchyGroup.ClientSubUnitName;
group.TravelerTypeGuid = hierarchyGroup.TravelerTypeGuid;
group.TravelerTypeName = hierarchyGroup.TravelerTypeName;
group.ClientTopUnitName = hierarchyGroup.ClientTopUnitName;
group.SourceSystemCode = hierarchyGroup.SourceSystemCode;
}
}
}
// GET: /View
public ActionResult View(int id)
{
ExternalSystemParameter group = new ExternalSystemParameter();
group = externalSystemParameterRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
externalSystemParameterRepository.EditGroupForDisplay(group);
return(View(group));
}
//Add Group
public void Add(ExternalSystemParameter group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertExternalSystemParameter_v1(
group.ExternalSystemParameterTypeId,
group.ExternalSystemParameterValue,
group.EnabledFlag,
group.EnabledDate,
group.ExpiryDate,
group.TripTypeId,
group.HierarchyType,
group.HierarchyCode,
group.TravelerTypeGuid,
group.ClientSubUnitGuid,
group.SourceSystemCode,
adminUserGuid
);
}
public ActionResult UnDelete(int id, FormCollection collection)
{
//Get Item From Database
ExternalSystemParameter group = new ExternalSystemParameter();
group = externalSystemParameterRepository.GetGroup(id);
//Check Exists
if (group == null || group.DeletedFlag == false)
{
ViewData["ActionMethod"] = "UnDeletePost";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToExternalSystemParameter(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
} //Delete Item
try
{
group.VersionNumber = Int32.Parse(collection["VersionNumber"]);
group.DeletedFlag = false;
externalSystemParameterRepository.UpdateGroupDeletedStatus(group);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/ExternalSystemParameter.mvc/UnDelete/" + group.ExternalSystemParameterId;
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("ListDeleted"));
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get Item From Database
ExternalSystemParameter group = new ExternalSystemParameter();
group = externalSystemParameterRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToExternalSystemParameter(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
TripTypeRepository tripTypeRepository = new TripTypeRepository();
SelectList tripTypesList = new SelectList(tripTypeRepository.GetAllTripTypes().ToList(), "TripTypeId", "TripTypeDescription");
ViewData["TripTypes"] = tripTypesList;
ExternalSystemParameterTypeRepository externalSystemParameterTypeRepository = new ExternalSystemParameterTypeRepository();
SelectList externalSystemParameterTypeList = new SelectList(externalSystemParameterTypeRepository.GetAllExternalSystemParameterTypes().ToList(), "ExternalSystemParameterTypeId", "ExternalSystemParameterTypeName");
ViewData["ExternalSystemParameterTypes"] = externalSystemParameterTypeList;
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(), "HierarchyLevelTableName", "HierarchyLevelTableName");
ViewData["HierarchyTypes"] = hierarchyTypesList;
externalSystemParameterRepository.EditGroupForDisplay(group);
return(View(group));
}
// GET: /UnDelete
public ActionResult UnDelete(int id)
{
ExternalSystemParameter group = new ExternalSystemParameter();
group = externalSystemParameterRepository.GetGroup(id);
//Check Exists
if (group == null || group.DeletedFlag == false)
{
ViewData["ActionMethod"] = "UnDeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToExternalSystemParameter(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
externalSystemParameterRepository.EditGroupForDisplay(group);
return(View(group));
}
public ActionResult Edit(int id, FormCollection collection)
{
//Get Item From Database
ExternalSystemParameter group = new ExternalSystemParameter();
group = externalSystemParameterRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToExternalSystemParameter(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model From Form + Validate against DB
try
{
UpdateModel(group);
}
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"));
}
//ClientSubUnitTravelerType has extra field
string hierarchyCode = group.HierarchyCode;
if (group.HierarchyType == "ClientSubUnitTravelerType")
{
group.ClientSubUnitGuid = hierarchyCode; //ClientSubUnitTravelerType has 2 primarykeys
}
//Check Access Rights to PolicyGroup
HierarchyRepository hierarchyRepository = new HierarchyRepository();
if (!hierarchyRepository.AdminHasDomainHierarchyWriteAccess(group.HierarchyType, hierarchyCode, group.SourceSystemCode, groupName))
{
ViewData["Message"] = "You cannot add to this hierarchy item";
return(View("Error"));
}
//Database Update
try
{
externalSystemParameterRepository.Edit(group);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/ExternalSystemParameter.mvc/Edit/" + group.ExternalSystemParameterId;
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("ListUnDeleted"));
}
public ActionResult Create(ExternalSystemParameter group)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
} //Check Access Rights to Domain Hierarchy
if (!hierarchyRepository.AdminHasDomainHierarchyWriteAccess(group.HierarchyType, group.HierarchyCode, group.SourceSystemCode, groupName))
{
ViewData["Message"] = "You cannot add to this hierarchy item";
return(View("Error"));
}
//Update Model From Form + Validate against DB
try
{
UpdateModel(group);
}
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"));
}
//ClientSubUnitTravelerType has extra field
string hierarchyCode = group.HierarchyCode;
if (group.HierarchyType == "ClientSubUnitTravelerType")
{
group.ClientSubUnitGuid = hierarchyCode; //ClientSubUnitTravelerType has 2 primarykeys
}
//Database Update
try
{
externalSystemParameterRepository.Add(group);
}
catch (SqlException ex)
{
//Non-Unique Name
if (ex.Message == "NonUniqueName")
{
return(View("NonUniqueNameError"));
}
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"));
}
ViewData["NewSortOrder"] = 0;
return(RedirectToAction("ListUnDeleted"));
}
