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