// GET: /Create
public ActionResult Create(int id)
{
//Get TripTypeGroup
TripTypeGroup tripTypeGroup = new TripTypeGroup();
tripTypeGroup = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (tripTypeGroup == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTripTypeGroup(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
SelectList tripTypeList = new SelectList(tripTypeItemRepository.GetUnUsedTripTypes(id).ToList(), "TripTypeId", "TripTypeDescription");
ViewData["TripTypes"] = tripTypeList;
TripTypeItem tripTypeItem = new TripTypeItem();
tripTypeItem.TripTypeGroupId = tripTypeGroup.TripTypeGroupId;
tripTypeItem.TripTypeGroupName = tripTypeGroup.TripTypeGroupName;
return(View(tripTypeItem));
}
// GET: Linked ClientSubUnits
public ActionResult LinkedClientSubUnits(int id)
{
//Get Group From Database
TripTypeGroup group = new TripTypeGroup();
group = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ClientSubUnitGet";
return(View("RecordDoesNotExistError"));
}
TripTypeGroupClientSubUnitCountriesVM tripTypeGroupClientSubUnits = new TripTypeGroupClientSubUnitCountriesVM();
tripTypeGroupClientSubUnits.TripTypeGroupId = id;
tripTypeGroupClientSubUnits.TripTypeGroupName = group.TripTypeGroupName;
List <ClientSubUnitCountryVM> clientSubUnitsAvailable = new List <ClientSubUnitCountryVM>();
clientSubUnitsAvailable = tripTypeGroupRepository.GetLinkedClientSubUnits(id, false);
tripTypeGroupClientSubUnits.ClientSubUnitsAvailable = clientSubUnitsAvailable;
List <ClientSubUnitCountryVM> clientSubUnitsUnAvailable = new List <ClientSubUnitCountryVM>();
clientSubUnitsUnAvailable = tripTypeGroupRepository.GetLinkedClientSubUnits(id, true);
tripTypeGroupClientSubUnits.ClientSubUnitsUnAvailable = clientSubUnitsUnAvailable;
return(View(tripTypeGroupClientSubUnits));
}
public ActionResult Delete(int id)
{
//Get Item From Database
TripTypeGroup group = new TripTypeGroup();
group = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (group == null || group.DeletedFlag == true)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTripTypeGroup(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Add Linked Items and Display
tripTypeGroupRepository.EditGroupForDisplay(group);
return(View(group));
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get Item From Database
TripTypeGroup group = new TripTypeGroup();
group = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTripTypeGroup(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(), "HierarchyLevelTableName", "HierarchyLevelTableName");
ViewData["HierarchyTypes"] = hierarchyTypesList;
tripTypeGroupRepository.EditGroupForDisplay(group);
return(View(group));
}
public ActionResult Create(TripTypeItem tripTypeItem)
{
//Get TripTypeGroup
TripTypeGroup tripTypeGroup = new TripTypeGroup();
tripTypeGroup = tripTypeGroupRepository.GetGroup(tripTypeItem.TripTypeGroupId);
//Check Exists
if (tripTypeGroup == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTripTypeGroup(tripTypeItem.TripTypeGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(tripTypeItem);
}
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"));
}
try
{
tripTypeItemRepository.Add(tripTypeItem);
}
catch (SqlException ex)
{
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 = tripTypeItem.TripTypeGroupId }));
}
//Change the deleted status on an item
public void UpdateGroupDeletedStatus(TripTypeGroup group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateTripTypeGroupDeletedStatus_v1(
group.TripTypeGroupId,
group.DeletedFlag,
adminUserGuid,
group.VersionNumber
);
}
// GET: /List
public ActionResult List(int id, int?page, string filter, string sortField, int?sortOrder)
{
TripTypeGroup tripTypeGroup = new TripTypeGroup();
tripTypeGroup = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (tripTypeGroup == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToTripTypeGroup(id))
{
ViewData["Access"] = "WriteAccess";
}
//SortField+SortOrder settings
if (sortField != "TripTypeDescription")
{
sortField = "TripTypeDescription";
}
ViewData["CurrentSortField"] = sortField;
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
sortOrder = 0;
}
ViewData["TripTypeGroupId"] = tripTypeGroup.TripTypeGroupId;
ViewData["TripTypeGroupName"] = tripTypeGroup.TripTypeGroupName;
//return items
var cwtPaginatedList = tripTypeItemRepository.PageTripTypeItems(id, page ?? 1, filter ?? "", sortField, sortOrder ?? 0);
return(View(cwtPaginatedList));
}
// GET: /View
public ActionResult View(int id)
{
TripTypeGroup group = new TripTypeGroup();
group = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
tripTypeGroupRepository.EditGroupForDisplay(group);
return(View(group));
}
public ActionResult Delete(int id, FormCollection collection)
{
System.Uri x = Request.UrlReferrer;
string c = x.AbsolutePath;
//Get Item From Database
TripTypeGroup group = new TripTypeGroup();
group = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (group == null || group.DeletedFlag == true)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTripTypeGroup(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 = true;
tripTypeGroupRepository.UpdateGroupDeletedStatus(group);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/TripTypeGroup.mvc/Delete/" + group.TripTypeGroupId;
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"));
}
// 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"));
}
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(), "HierarchyLevelTableName", "HierarchyLevelTableName");
ViewData["HierarchyTypes"] = hierarchyTypesList;
TripTypeGroup group = new TripTypeGroup();
return(View(group));
}
public ActionResult LinkedClientSubUnits(int tripTypeGroupId, string ClientSubUnitGuid)
{
//Get Item From Database
TripTypeGroup group = new TripTypeGroup();
group = tripTypeGroupRepository.GetGroup(tripTypeGroupId);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ClientSubUnitPost";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTripTypeGroup(tripTypeGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Database Update
try
{
tripTypeGroupRepository.UpdateLinkedClientSubUnit(tripTypeGroupId, ClientSubUnitGuid);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/TripTypeGroup.mvc/ClientSubUnit/" + tripTypeGroupId.ToString();
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("LinkedClientSubUnits", new { id = tripTypeGroupId }));
}
//Add Group
public void Add(TripTypeGroup group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertTripTypeGroup_v1(
group.TripTypeGroupName,
group.EnabledFlag,
group.EnabledDate,
group.ExpiryDate,
group.InheritFromParentFlag,
group.HierarchyType,
group.HierarchyCode,
group.TravelerTypeGuid,
group.ClientSubUnitGuid,
group.SourceSystemCode,
adminUserGuid
);
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(TripTypeItem tripTypeItem)
{
//Add Descrription
TripTypeRepository tripTypeRepository = new TripTypeRepository();
TripType tripType = new TripType();
tripType = tripTypeRepository.GetTripType(tripTypeItem.TripTypeId);
if (tripType != null)
{
tripTypeItem.TripTypeDescription = tripType.TripTypeDescription;
}
//Add PolicyGroupName
TripTypeGroupRepository tripTypeGroupRepository = new TripTypeGroupRepository();
TripTypeGroup tripTypeGroup = new TripTypeGroup();
tripTypeGroup = tripTypeGroupRepository.GetGroup(tripTypeItem.TripTypeGroupId);
if (tripTypeGroup != null)
{
tripTypeItem.TripTypeGroupName = tripTypeGroup.TripTypeGroupName;
}
}
public ActionResult Edit(int id, FormCollection collection)
{
//Get Item From Database
TripTypeGroup group = new TripTypeGroup();
group = tripTypeGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTripTypeGroup(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"));
}
//Dont check for multiple as We are not editing Hierarchy, we have alrady checked access to the item itself
if (group.HierarchyType != "Multiple")
{
//ClientSubUnitTravelerType has extra field
string hierarchyCode = group.HierarchyCode;
if (group.HierarchyType == "ClientSubUnitTravelerType")
{
group.ClientSubUnitGuid = hierarchyCode; //ClientSubUnitTravelerType has 2 primarykeys
}
//Check Access Rights to Hierarchy
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
{
tripTypeGroupRepository.Edit(group);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/TripTypeGroup.mvc/Edit/" + group.TripTypeGroupId.ToString();
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(TripTypeGroup 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
if (group.HierarchyType == "ClientSubUnitTravelerType")
{
group.ClientSubUnitGuid = group.HierarchyCode; //ClientSubUnitTravelerType has 2 primarykeys
}
//Database Update
try
{
tripTypeGroupRepository.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"));
}
//Add Data From Linked Tables for Display
public void EditGroupForDisplay(TripTypeGroup group)
{
group.TripTypeGroupName = Regex.Replace(group.TripTypeGroupName, @"[^\w\-()*]", "-");
//Hierarchy
HierarchyRepository hierarchyRepository = new HierarchyRepository();
ClientSubUnitRepository clientSubUnitRepository = new ClientSubUnitRepository();
List <fnDesktopDataAdmin_SelectTripTypeGroupHierarchy_v1Result> hierarchy = GetGroupHierarchy(group.TripTypeGroupId);
if (hierarchy.Count > 0)
{
if (hierarchy.Count == 1)
{
group.HierarchyCode = hierarchy[0].HierarchyCode.ToString();
group.HierarchyItem = hierarchy[0].HierarchyName.Trim();
group.HierarchyType = hierarchy[0].HierarchyType;
if (hierarchy[0].HierarchyType == "ClientSubUnitTravelerType")
{
group.ClientSubUnitGuid = hierarchy[0].HierarchyCode.ToString();
group.ClientSubUnitName = hierarchy[0].HierarchyName.Trim();
group.ClientTopUnitName = clientSubUnitRepository.GetClientSubUnitClientTopUnitName(group.ClientSubUnitGuid);
group.TravelerTypeGuid = hierarchy[0].TravelerTypeGuid;
group.TravelerTypeName = hierarchy[0].TravelerTypeName.Trim();
}
if (hierarchy[0].HierarchyType == "ClientSubUnit")
{
group.ClientTopUnitName = clientSubUnitRepository.GetClientSubUnitClientTopUnitName(hierarchy[0].HierarchyCode);
}
if (hierarchy[0].HierarchyType == "ClientAccount")
{
group.SourceSystemCode = hierarchy[0].SourceSystemCode;
}
}
else
{
List <MultipleHierarchyDefinition> multipleHierarchies = new List <MultipleHierarchyDefinition>();
foreach (fnDesktopDataAdmin_SelectTripTypeGroupHierarchy_v1Result item in hierarchy)
{
multipleHierarchies.Add(new MultipleHierarchyDefinition()
{
HierarchyType = item.HierarchyType,
HierarchyItem = item.HierarchyName,
HierarchyCode = item.HierarchyCode,
TravelerTypeGuid = item.TravelerTypeGuid,
SourceSystemCode = item.SourceSystemCode
});
}
group.ClientSubUnitsHierarchy = hierarchyRepository.GetClientSubUnitHierarchies(multipleHierarchies);
group.ClientTopUnitName = clientSubUnitRepository.GetClientSubUnitClientTopUnitName(group.ClientSubUnitsHierarchy.First().ClientSubUnitGuid);
}
}
if (hierarchy.Count > 1)
{
group.IsMultipleHierarchy = true;
group.HierarchyType = "Multiple";
group.HierarchyItem = "Multiple";
group.HierarchyCode = "Multiple";
}
else
{
group.IsMultipleHierarchy = false;
}
}
