public ServicingOptionItemSequencesVM(CWTPaginatedList <spDesktopDataAdmin_SelectServicingOptionItemSequences_v1Result> servicingOptionItemSequences, ServicingOptionGroup servicingOptionGroup, int servicingOptionId, ServicingOption servicingOption) { ServicingOptionItemSequences = servicingOptionItemSequences; ServicingOptionGroup = servicingOptionGroup; ServicingOption = servicingOption; ServicingOptionId = servicingOptionId; }
public JsonResult GetServicingOptionGDSRequired(int servicingOptionId) { ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository(); ServicingOption servicingOption = new ServicingOption(); servicingOption = servicingOptionRepository.GetServicingOption(servicingOptionId); var result = (servicingOption != null && servicingOption.GDSRequiredFlag == true) ? true : false; return(Json(result)); }
public JsonResult GetServicingOptionParametersRequired(int servicingOptionId) { ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository(); ServicingOption servicingOption = new ServicingOption(); servicingOption = servicingOptionRepository.GetServicingOption(servicingOptionId); var result = (servicingOption != null && ( servicingOption.ServicingOptionId == 1 || servicingOption.ServicingOptionId == 2 || servicingOption.ServicingOptionId == 90 || servicingOption.ServicingOptionId == 291) ) ? true : false; return(Json(result)); }
//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 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 })); }