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