// 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;
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(), "HierarchyLevelTableName", "HierarchyLevelTableName");
ViewData["HierarchyTypes"] = hierarchyTypesList;
List <Meeting> meetings = new List <Meeting>();
SelectList meetingsList = new SelectList(meetings.ToList(), "MeetingID", "MeetingName");
ViewData["Meetings"] = meetingsList;
ServicingOptionGroup group = new ServicingOptionGroup();
return(View(group));
}
public ServicingOptionItemSequencesVM(CWTPaginatedList <spDesktopDataAdmin_SelectServicingOptionItemSequences_v1Result> servicingOptionItemSequences, ServicingOptionGroup servicingOptionGroup, int servicingOptionId, ServicingOption servicingOption)
{
ServicingOptionItemSequences = servicingOptionItemSequences;
ServicingOptionGroup = servicingOptionGroup;
ServicingOption = servicingOption;
ServicingOptionId = servicingOptionId;
}
// GET: /ServicingOptionSelect
public ActionResult SelectServicingOptionToOrder(int id)
{
//Get Group
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (servicingOptionGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToServicingOptionGroup(id))
{
ViewData["Access"] = "WriteAccess";
}
ServicingOptionHFLFVM servicingOptionHFLFVM = new ServicingOptionHFLFVM();
ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository();
servicingOptionHFLFVM.ServicingOptionGroup = servicingOptionGroup;
servicingOptionHFLFVM.ServicingOptions = new SelectList(servicingOptionRepository.GetServicingOptionsHFLFSelectList(id).ToList(), "ServicingOptionId", "ServicingOptionName");
return(View(servicingOptionHFLFVM));
}
public ActionResult Create(ServicingOptionItem servicingOptionItem)
{
//Check Exists
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(servicingOptionItem.ServicingOptionGroupId);
//Check Exists
if (servicingOptionGroup == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(servicingOptionItem.ServicingOptionGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(servicingOptionItem);
}
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
{
servicingOptionItemRepository.Add(servicingOptionItem);
}
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 = servicingOptionItem.ServicingOptionGroupId }));
}
//Change the deleted status on an item
public void UpdateGroupDeletedStatus(ServicingOptionGroup group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateServicingOptionGroupDeletedStatus_v1(
group.ServicingOptionGroupId,
group.DeletedFlag,
adminUserGuid,
group.VersionNumber
);
}
// GET: /View
public ActionResult View(int id)
{
ServicingOptionGroup group = new ServicingOptionGroup();
group = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
servicingOptionGroupRepository.EditGroupForDisplay(group);
return(View(group));
}
// GET: List/
public ActionResult List(int id, int?page, string sortField, int?sortOrder)
{
//Get Group
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (servicingOptionGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToServicingOptionGroup(id))
{
ViewData["Access"] = "WriteAccess";
}
if (sortField != "ServicingOptionItemSequence")
{
sortField = "ServicingOptionName";
}
ViewData["CurrentSortField"] = sortField;
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
}
ViewData["ServicingOptionGroupId"] = servicingOptionGroup.ServicingOptionGroupId;
ViewData["ServicingOptionGroupName"] = servicingOptionGroup.ServicingOptionGroupName;
//return items
var cwtPaginatedList = servicingOptionItemRepository.PageServicingOptionItems(id, page ?? 1, sortField, sortOrder ?? 0);
return(View(cwtPaginatedList));
}
public ActionResult UnDelete(int id, FormCollection collection)
{
//Get Item From Database
ServicingOptionGroup group = new ServicingOptionGroup();
group = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (group == null || group.DeletedFlag == false)
{
ViewData["ActionMethod"] = "UnDeletePost";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(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;
servicingOptionGroupRepository.UpdateGroupDeletedStatus(group);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/ServicingOptionGroup.mvc/UnDelete/" + group.ServicingOptionGroupId;
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"));
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(ServicingOptionItem servicingOptionItem)
{
ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository();
ServicingOption servicingOption = new ServicingOption();
servicingOption = servicingOptionRepository.GetServicingOption(servicingOptionItem.ServicingOptionId);
if (servicingOption != null)
{
servicingOptionItem.ServicingOptionName = servicingOption.ServicingOptionName;
servicingOptionItem.GDSRequiredFlag = servicingOption.GDSRequiredFlag;
}
ServicingOptionGroupRepository servicingOptionGroupRepository = new ServicingOptionGroupRepository();
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(servicingOptionItem.ServicingOptionGroupId);
if (servicingOptionGroup != null)
{
servicingOptionItem.ServicingOptionGroupName = servicingOptionGroup.ServicingOptionGroupName;
}
if(servicingOptionItem.GDSCode!=null){
GDSRepository gDSRepository = new GDSRepository();
GDS gds = new GDS();
gds = gDSRepository.GetGDS(servicingOptionItem.GDSCode);
if (gds != null)
{
servicingOptionItem.GDSName = gds.GDSName;
}
}
//Get ServicingOptionFareCalculations
ServicingOptionFareCalculation servicingOptionFareCalculation = new ServicingOptionFareCalculation();
servicingOptionFareCalculation = db.ServicingOptionFareCalculations.SingleOrDefault(c => c.ServicingOptionItemId == servicingOptionItem.ServicingOptionItemId);
if (servicingOptionFareCalculation != null)
{
servicingOptionItem.DepartureTimeWindowMinutes = servicingOptionFareCalculation.DepartureTimeWindowMinutes;
servicingOptionItem.ArrivalTimeWindowMinutes = servicingOptionFareCalculation.ArrivalTimeWindowMinutes;
servicingOptionItem.MaximumConnectionTimeMinutes = servicingOptionFareCalculation.MaximumConnectionTimeMinutes;
servicingOptionItem.MaximumStops = servicingOptionFareCalculation.MaximumStops;
servicingOptionItem.UseAlternateAirportFlag = servicingOptionFareCalculation.UseAlternateAirportFlag;
servicingOptionItem.NoPenaltyFlag = servicingOptionFareCalculation.NoPenaltyFlag;
servicingOptionItem.NoRestrictionsFlag = servicingOptionFareCalculation.NoRestrictionsFlag;
}
}
public ActionResult LinkedClientSubUnits(int ServicingOptionGroupId, string ClientSubUnitGuid)
{
//Get Item From Database
ServicingOptionGroup group = new ServicingOptionGroup();
group = servicingOptionGroupRepository.GetGroup(ServicingOptionGroupId);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ClientSubUnitPost";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(ServicingOptionGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Database Update
try
{
servicingOptionGroupRepository.UpdateLinkedClientSubUnit(ServicingOptionGroupId, ClientSubUnitGuid);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/ServicingOptionGroup.mvc/ClientSubUnit/" + ServicingOptionGroupId.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 = ServicingOptionGroupId }));
}
//Add Group
public void Add(ServicingOptionGroup group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertServicingOptionGroup_v1(
group.ServicingOptionGroupName,
group.EnabledFlag,
group.EnabledDate,
group.ExpiryDate,
group.TripTypeId,
group.HierarchyType,
group.HierarchyCode,
group.TravelerTypeGuid,
group.ClientSubUnitGuid,
group.SourceSystemCode,
group.MeetingID,
adminUserGuid
);
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get Item From Database
ServicingOptionGroup group = new ServicingOptionGroup();
group = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(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", group.TripTypeId);
ViewData["TripTypes"] = tripTypesList;
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(), "HierarchyLevelTableName", "HierarchyLevelTableName");
ViewData["HierarchyTypes"] = hierarchyTypesList;
servicingOptionGroupRepository.EditGroupForDisplay(group);
//Meetings
MeetingRepository meetingRepository = new MeetingRepository();
List <Meeting> meetings = meetingRepository.GetAvailableMeetings(group.HierarchyType, group.HierarchyCode, null, group.SourceSystemCode, group.TravelerTypeGuid);
SelectList meetingsList = new SelectList(meetings.ToList(), "MeetingID", "MeetingDisplayName", group.MeetingID != null ? group.MeetingID.ToString() : "");
ViewData["Meetings"] = meetingsList;
return(View(group));
}
public ActionResult SelectServicingOptionToOrder(ServicingOptionHFLFVM servicingOptionHFLFVM)
{
int groupId = servicingOptionHFLFVM.ServicingOptionGroup.ServicingOptionGroupId;
int id = servicingOptionHFLFVM.ServicingOptionId;
//Get Group
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(groupId);
//Check Exists
if (servicingOptionGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Return
return(RedirectToAction("EditSequence", new { groupid = groupId, id = id }));
}
// GET: Linked ClientSubUnits
public ActionResult LinkedClientSubUnits(int id)
{
//Get Group From Database
ServicingOptionGroup group = new ServicingOptionGroup();
group = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ClientSubUnitGet";
return(View("RecordDoesNotExistError"));
}
ServicingOptionGroupClientSubUnitCountriesVM servicingOptionGroupClientSubUnits = new ServicingOptionGroupClientSubUnitCountriesVM();
servicingOptionGroupClientSubUnits.ServicingOptionGroupId = id;
servicingOptionGroupClientSubUnits.ServicingOptionGroupName = group.ServicingOptionGroupName;
List <ClientSubUnitCountryVM> clientSubUnitsAvailable = new List <ClientSubUnitCountryVM>();
clientSubUnitsAvailable = servicingOptionGroupRepository.GetLinkedClientSubUnits(id, false);
servicingOptionGroupClientSubUnits.ClientSubUnitsAvailable = clientSubUnitsAvailable;
List <ClientSubUnitCountryVM> clientSubUnitsUnAvailable = new List <ClientSubUnitCountryVM>();
clientSubUnitsUnAvailable = servicingOptionGroupRepository.GetLinkedClientSubUnits(id, true);
servicingOptionGroupClientSubUnits.ClientSubUnitsUnAvailable = clientSubUnitsUnAvailable;
//Check User Access
servicingOptionGroupClientSubUnits.HasWriteAccess = false;
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToServicingOptionGroup(id))
{
servicingOptionGroupClientSubUnits.HasWriteAccess = true;
}
return(View(servicingOptionGroupClientSubUnits));
}
// GET: /Create
public ActionResult Create(int id)
{
//Check Exists
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(id);
if (servicingOptionGroup == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository();
SelectList servicingOptionsList = new SelectList(servicingOptionRepository.GetAvailableServicingOptions(id).ToList(), "ServicingOptionId", "ServicingOptionName");
ViewData["ServicingOptions"] = servicingOptionsList;
GDSRepository gdsRepository = new GDSRepository();
SelectList gDSList = new SelectList(gdsRepository.GetAllGDSsExceptALL().ToList(), "GDSCode", "GDSName");
ViewData["GDSs"] = gDSList;
ViewData["DepartureTimeWindowMinutesList"] = new SelectList(servicingOptionRepository.GetServicingOptionDepartureTimeWindows().Select(x => new { value = x, text = x }), "value", "text");
ViewData["ArrivalTimeWindowMinutesList"] = new SelectList(servicingOptionRepository.GetServicingOptionArrivalTimeWindows().Select(x => new { value = x, text = x }), "value", "text");
ViewData["MaximumStopsList"] = new SelectList(servicingOptionRepository.GetServicingOptionMaximumStops().Select(x => new { value = x, text = x }), "value", "text");
ServicingOptionItem servicingOptionItem = new ServicingOptionItem();
servicingOptionItem.ServicingOptionGroupName = servicingOptionGroup.ServicingOptionGroupName;
servicingOptionItem.ServicingOptionGroupId = servicingOptionGroup.ServicingOptionGroupId;
return(View(servicingOptionItem));
}
// GET: /EditSequence
public ActionResult EditSequence(int groupid, int id, int?page)
{
//Check Exists
//Get Group
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(groupid);
//Check Exists
if (servicingOptionGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(groupid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ServicingOptionItemSequenceRepository servicingOptionItemSequenceRepository = new ServicingOptionItemSequenceRepository();
ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository();
ServicingOptionItemSequencesVM servicingOptionItemSequencesVM = new ServicingOptionItemSequencesVM();
servicingOptionItemSequencesVM.ServicingOptionItemSequences = servicingOptionItemSequenceRepository.GetServicingOptionItemSequences(groupid, id, page ?? 1);
servicingOptionItemSequencesVM.ServicingOptionGroup = servicingOptionGroup;
servicingOptionItemSequencesVM.ServicingOption = servicingOptionRepository.GetServicingOption(id);
servicingOptionItemSequencesVM.ServicingOptionId = id;
ViewData["Page"] = page ?? 1;
return(View(servicingOptionItemSequencesVM));
}
// GET: /UnDelete
public ActionResult UnDelete(int id)
{
//Get Item From Database
ServicingOptionGroup group = new ServicingOptionGroup();
group = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (group == null || group.DeletedFlag == false)
{
ViewData["ActionMethod"] = "UnDeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
servicingOptionGroupRepository.EditGroupForDisplay(group);
return(View(group));
}
public ServicingOptionHFLFVM(IEnumerable <SelectListItem> servicingOptions, int servicingOptionId, ServicingOptionGroup servicingOptionGroup)
{
ServicingOptionId = servicingOptionId;
ServicingOptions = servicingOptions;
ServicingOptionGroup = servicingOptionGroup;
}
public ActionResult EditSequence(int groupid, int page, int id, FormCollection collection)
{
//Check Exists
ServicingOptionGroup servicingOptionGroup = new ServicingOptionGroup();
servicingOptionGroup = servicingOptionGroupRepository.GetGroup(groupid);
if (servicingOptionGroup == null)
{
ViewData["ActionMethod"] = "EditSequencePost";
return(View("RecordDoesNotExistError"));
}
//Check Exists
ServicingOption servicingOption = new ServicingOption();
ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository();
servicingOption = servicingOptionRepository.GetServicingOption(id);
if (servicingOption == null)
{
ViewData["ActionMethod"] = "EditSequencePost";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(groupid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
string[] sequences = collection["Sequence"].Split(new char[] { ',' });
int sequence = (page - 1 * 5) - 2;
if (sequence < 0)
{
sequence = 1;
}
XmlDocument doc = new XmlDocument();// Create the XML Declaration, and append it to XML document
XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", null, null);
doc.AppendChild(dec);
XmlElement root = doc.CreateElement("SequenceXML");
doc.AppendChild(root);
foreach (string s in sequences)
{
string[] primaryKey = s.Split(new char[] { '_' });
int servicingOptionItemId = Convert.ToInt32(primaryKey[0]);
int versionNumber = Convert.ToInt32(primaryKey[1]);
XmlElement xmlItem = doc.CreateElement("Item");
root.AppendChild(xmlItem);
XmlElement xmlSequence = doc.CreateElement("Sequence");
xmlSequence.InnerText = sequence.ToString();
xmlItem.AppendChild(xmlSequence);
XmlElement xmlServicingOptionItemId = doc.CreateElement("ServicingOptionItemId");
xmlServicingOptionItemId.InnerText = servicingOptionItemId.ToString();
xmlItem.AppendChild(xmlServicingOptionItemId);
XmlElement xmlVersionNumber = doc.CreateElement("VersionNumber");
xmlVersionNumber.InnerText = versionNumber.ToString();
xmlItem.AppendChild(xmlVersionNumber);
sequence = sequence + 1;
}
try
{
ServicingOptionItemSequenceRepository servicingOptionItemSequenceRepository = new ServicingOptionItemSequenceRepository();
servicingOptionItemSequenceRepository.UpdateServicingOptionItemSequences(System.Xml.Linq.XElement.Parse(doc.OuterXml));
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/servicingOptionItem.mvc/EditSequence?page=" + page + "&id=" + id + "&groupid=" + groupid;
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 = groupid }));
}
//Add Data From Linked Tables for Display
public void EditGroupForDisplay(ServicingOptionGroup group)
{
TripTypeRepository tripTypeRepository = new TripTypeRepository();
TripType tripType = new TripType();
tripType = tripTypeRepository.GetTripType(group.TripTypeId);
if (tripType != null)
{
group.TripType = tripType.TripTypeDescription;
}
group.ServicingOptionGroupName = Regex.Replace(group.ServicingOptionGroupName, @"[^\w\-()*]", "-");
//Hierarchy
HierarchyRepository hierarchyRepository = new HierarchyRepository();
List <fnDesktopDataAdmin_SelectServicingOptionGroupHierarchy_v1Result> hierarchy = GetGroupHierarchy(group.ServicingOptionGroupId);
if (hierarchy.Count > 0)
{
if (hierarchy.Count == 1)
{
HierarchyGroup hierarchyGroup = hierarchyRepository.GetHierarchyGroup(
hierarchy[0].HierarchyType ?? "",
hierarchy[0].HierarchyCode ?? "",
hierarchy[0].HierarchyName ?? "",
hierarchy[0].TravelerTypeGuid ?? "",
hierarchy[0].TravelerTypeName ?? "",
hierarchy[0].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;
}
}
else
{
List <MultipleHierarchyDefinition> multipleHierarchies = new List <MultipleHierarchyDefinition>();
foreach (fnDesktopDataAdmin_SelectServicingOptionGroupHierarchy_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);
ClientSubUnitRepository clientSubUnitRepository = new ClientSubUnitRepository();
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;
}
//Meetings
if (group.MeetingID != null)
{
int meetingID = Int32.Parse(group.MeetingID.ToString());
MeetingRepository meetingRepository = new MeetingRepository();
Meeting meeting = meetingRepository.GetGroup(meetingID);
if (meeting != null)
{
group.Meeting = meeting;
}
}
}
public ActionResult Create(ServicingOptionGroup 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
{
servicingOptionGroupRepository.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"));
}
public ActionResult Edit(int id, FormCollection collection)
{
//Get Item From Database
ServicingOptionGroup group = new ServicingOptionGroup();
group = servicingOptionGroupRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToServicingOptionGroup(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 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
{
servicingOptionGroupRepository.Edit(group);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/WorkFlowGroup.mvc/Edit/" + group.ServicingOptionGroupId.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"));
}
