public ActionResult Delete(int id) { //AccessRights ServicingOptionItem servicingOptionItem = new ServicingOptionItem(); servicingOptionItem = servicingOptionItemRepository.GetItem(id); //Check Exists if (servicingOptionItem == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //Check Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToServicingOptionGroup(servicingOptionItem.ServicingOptionGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Add Linked Information servicingOptionItemRepository.EditItemForDisplay(servicingOptionItem); //Return return(View(servicingOptionItem)); }
public ActionResult Edit(int id, FormCollection collection) { ServicingOptionItem servicingOptionItem = new ServicingOptionItem(); servicingOptionItem = servicingOptionItemRepository.GetItem(id); //Check Exists if (servicingOptionItem == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToServicingOptionGroup(servicingOptionItem.ServicingOptionGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } 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")); } try { servicingOptionItemRepository.Edit(servicingOptionItem); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/ServicingOptionItem.mvc/Edit/" + servicingOptionItem.ServicingOptionItemId; return(View("VersionError")); } //Generic Error 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 })); }
//Delete ServicingOptionItem public void Delete(ServicingOptionItem servicingOptionItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeleteServicingOptionItem_v1( servicingOptionItem.ServicingOptionItemId, adminUserGuid, servicingOptionItem.VersionNumber); }
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 })); }
// GET: /View public ActionResult View(int id) { ServicingOptionItem servicingOptionItem = new ServicingOptionItem(); servicingOptionItem = servicingOptionItemRepository.GetItem(id); if (servicingOptionItem == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } servicingOptionItemRepository.EditItemForDisplay(servicingOptionItem); return(View(servicingOptionItem)); }
// GET: /Edit public ActionResult Edit(int id) { ServicingOptionItem servicingOptionItem = new ServicingOptionItem(); servicingOptionItem = servicingOptionItemRepository.GetItem(id); //Check Exists if (servicingOptionItem == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToServicingOptionGroup(servicingOptionItem.ServicingOptionGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } ServicingOptionRepository servicingOptionRepository = new ServicingOptionRepository(); SelectList servicingOptionsList = new SelectList(servicingOptionRepository.GetAllServicingOptions().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", servicingOptionItem.DepartureTimeWindowMinutes); ViewData["ArrivalTimeWindowMinutesList"] = new SelectList( servicingOptionRepository.GetServicingOptionArrivalTimeWindows().Select( x => new { value = x, text = x } ), "value", "text", servicingOptionItem.ArrivalTimeWindowMinutes); ViewData["MaximumStopsList"] = new SelectList( servicingOptionRepository.GetServicingOptionMaximumStops().Select( x => new { value = x, text = x } ), "value", "text", servicingOptionItem.MaximumStops); servicingOptionItemRepository.EditItemForDisplay(servicingOptionItem); return(View(servicingOptionItem)); }
//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 Delete(int id, FormCollection collection) { //Get Parent ServicingOptionItem servicingOptionItem = new ServicingOptionItem(); servicingOptionItem = servicingOptionItemRepository.GetItem(id); //Check Exists if (servicingOptionItem == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //Check Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToServicingOptionGroup(servicingOptionItem.ServicingOptionGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Delete Item try { servicingOptionItem.VersionNumber = Int32.Parse(collection["VersionNumber"]); servicingOptionItemRepository.Delete(servicingOptionItem); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/ServicingOptionItem.mvc/Delete/" + servicingOptionItem.ServicingOptionItemId; return(View("VersionError")); } //Generic Error ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } //Return return(RedirectToAction("List", new { id = servicingOptionItem.ServicingOptionGroupId })); }
//Add ServicingOptionItem public void Add(ServicingOptionItem servicingOptionItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertServicingOptionItem_v1( servicingOptionItem.ServicingOptionGroupId, servicingOptionItem.ServicingOptionId, servicingOptionItem.ServicingOptionItemValue, servicingOptionItem.GDSCode, servicingOptionItem.ServicingOptionItemInstruction, servicingOptionItem.DisplayInApplicationFlag, servicingOptionItem.DepartureTimeWindowMinutes, servicingOptionItem.ArrivalTimeWindowMinutes, servicingOptionItem.MaximumStops, servicingOptionItem.MaximumConnectionTimeMinutes, servicingOptionItem.UseAlternateAirportFlag, servicingOptionItem.NoPenaltyFlag, servicingOptionItem.NoRestrictionsFlag, adminUserGuid ); }
// 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)); }