//Add Data From Linked Tables for Display public void EditItemForDisplay(PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem) { //PolicyGroupName PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository(); PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policyHotelPropertyGroupItem.PolicyGroupId); policyHotelPropertyGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; //PolicyHotelStatus if (policyHotelPropertyGroupItem.PolicyHotelStatusId != null) { int policyHotelStatusId = (int)policyHotelPropertyGroupItem.PolicyHotelStatusId; PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository(); PolicyHotelStatus policyHotelStatus = new PolicyHotelStatus(); policyHotelStatus = policyHotelStatusRepository.GetPolicyHotelStatus(policyHotelStatusId); policyHotelPropertyGroupItem.PolicyHotelStatus = policyHotelStatus.PolicyHotelStatusDescription; } //HarpHotel HarpHotelRepository harpHotelRepository = new HarpHotelRepository(); HarpHotel harpHotel = new HarpHotel(); harpHotel = harpHotelRepository.GetHarpHotel(policyHotelPropertyGroupItem.HarpHotelId); if (harpHotel != null) { policyHotelPropertyGroupItem.HarpHotelName = harpHotel.HarpHotelName; } }
public ActionResult Delete(int id) { //Get PolicyHotelPropertyGroupItem PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); //Check Exists if (policyHotelPropertyGroupItem == null) { ViewData["ActionMethod"] = "GetDelete"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { return(View("Error")); } //populate new PolicyHotelPropertyGroupItem with known PolicyGroup Information policyHotelPropertyGroupItemRepository.EditItemForDisplay(policyHotelPropertyGroupItem); //Show 'Create' Form return(View(policyHotelPropertyGroupItem)); }
public ActionResult Delete(int id, string languageCode) { //Get Item PolicyHotelPropertyGroupItemLanguage policyHotelPropertyGroupItemLanguage = new PolicyHotelPropertyGroupItemLanguage(); policyHotelPropertyGroupItemLanguage = policyHotelPropertyGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyHotelPropertyGroupItemLanguage == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Add Linked Information policyHotelPropertyGroupItemLanguageRepository.EditItemForDisplay(policyHotelPropertyGroupItemLanguage); //Return View return(View(policyHotelPropertyGroupItemLanguage)); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(PolicyHotelPropertyGroupItemLanguage policyHotelPropertyGroupItemLanguage) { //Add LanguageName if (policyHotelPropertyGroupItemLanguage.LanguageCode != null) { LanguageRepository languageRepository = new LanguageRepository(); Language language = new Language(); language = languageRepository.GetLanguage(policyHotelPropertyGroupItemLanguage.LanguageCode); if (language != null) { policyHotelPropertyGroupItemLanguage.LanguageName = language.LanguageName; } } //Add PolicyGroupName PolicyHotelPropertyGroupItemRepository policyHotelPropertyGroupItemRepository = new PolicyHotelPropertyGroupItemRepository(); PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(policyHotelPropertyGroupItemLanguage.PolicyHotelPropertyGroupItemId); if (policyHotelPropertyGroupItem != null) { policyHotelPropertyGroupItemRepository.EditItemForDisplay(policyHotelPropertyGroupItem); policyHotelPropertyGroupItemLanguage.PolicyGroupName = policyHotelPropertyGroupItem.PolicyGroupName; policyHotelPropertyGroupItemLanguage.PolicyGroupId = policyHotelPropertyGroupItem.PolicyGroupId; } }
// GET: /Edit public ActionResult Edit(int id, string languageCode) { //Get Item PolicyHotelPropertyGroupItemLanguage policyHotelPropertyGroupItemLanguage = new PolicyHotelPropertyGroupItemLanguage(); policyHotelPropertyGroupItemLanguage = policyHotelPropertyGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyHotelPropertyGroupItemLanguage == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Language SelectList SelectList languageList = new SelectList(policyHotelPropertyGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; policyHotelPropertyGroupItemLanguageRepository.EditItemForDisplay(policyHotelPropertyGroupItemLanguage); return(View(policyHotelPropertyGroupItemLanguage)); }
public ActionResult Create(PolicyHotelPropertyGroupItemLanguage policyHotelPropertyGroupItemLanguage) { PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(policyHotelPropertyGroupItemLanguage.PolicyHotelPropertyGroupItemId); //Check Exists if (policyHotelPropertyGroupItem == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Model from Form try { UpdateModel(policyHotelPropertyGroupItemLanguage); } 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 { policyHotelPropertyGroupItemLanguageRepository.Add(policyHotelPropertyGroupItemLanguage); } 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 = policyHotelPropertyGroupItem.PolicyHotelPropertyGroupItemId })); }
//Delete public void Delete(PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeletePolicyHotelPropertyGroupItem_v1( policyHotelPropertyGroupItem.PolicyHotelPropertyGroupItemId, adminUserGuid, policyHotelPropertyGroupItem.VersionNumber ); }
public ActionResult Edit(int id, FormCollection collection) { PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); //Check Exists if (policyHotelPropertyGroupItem == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { return(View("Error")); } //Update PolicyHotelPropertyGroupItem Model From Form try { UpdateModel(policyHotelPropertyGroupItem); } catch { return(View("Error")); } //Database Update try { policyHotelPropertyGroupItemRepository.Update(policyHotelPropertyGroupItem); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/PolicyHotelPropertyGroupItem.mvc/Edit/" + policyHotelPropertyGroupItem.PolicyHotelPropertyGroupItemId.ToString(); 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 to Form return(RedirectToAction("List", new { id = policyHotelPropertyGroupItem.PolicyGroupId })); }
//GET:List public ActionResult List(int id, int?page, string sortField, int?sortOrder) { //Get PolicyHotelPropertyGroupItem PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); //Check Exists if (policyHotelPropertyGroupItem == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } //Set Access Rights ViewData["Access"] = ""; RolesRepository rolesRepository = new RolesRepository(); if (rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { ViewData["Access"] = "WriteAccess"; } //Parent Information ViewData["PolicyHotelPropertyGroupItemID"] = policyHotelPropertyGroupItem.PolicyHotelPropertyGroupItemId; ViewData["PolicyGroupID"] = policyHotelPropertyGroupItem.PolicyGroupId; ViewData["PolicyGroupName"] = policyGroupRepository.GetGroup(policyHotelPropertyGroupItem.PolicyGroupId).PolicyGroupName; //SortField+SortOrder settings if (sortField != "HotelAdvice") { sortField = "LanguageName"; } ViewData["CurrentSortField"] = sortField; if (sortOrder == 1) { ViewData["NewSortOrder"] = 0; ViewData["CurrentSortOrder"] = 1; } else { ViewData["NewSortOrder"] = 1; ViewData["CurrentSortOrder"] = 0; sortOrder = 0; } //Get data var cwtPaginatedList = policyHotelPropertyGroupItemLanguageRepository.PagePolicyHotelPropertyGroupItemHotelAdvice(id, page ?? 1, sortField, sortOrder ?? 0); return(View(cwtPaginatedList)); }
public ActionResult Delete(int id, string languageCode, FormCollection collection) { //Get Item PolicyHotelPropertyGroupItemLanguage policyHotelPropertyGroupItemLanguage = new PolicyHotelPropertyGroupItemLanguage(); policyHotelPropertyGroupItemLanguage = policyHotelPropertyGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyHotelPropertyGroupItemLanguage == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Delete Item try { policyHotelPropertyGroupItemLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]); policyHotelPropertyGroupItemLanguageRepository.Delete(policyHotelPropertyGroupItemLanguage); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/HotelPropertyAdvice.mvc/Delete/" + policyHotelPropertyGroupItemLanguage.PolicyHotelPropertyGroupItemId.ToString() + "/" + policyHotelPropertyGroupItemLanguage.LanguageCode; 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 = policyHotelPropertyGroupItemLanguage.PolicyHotelPropertyGroupItemId })); }
//Add public void Add(PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertPolicyHotelPropertyGroupItem_v1( policyHotelPropertyGroupItem.PolicyGroupId, policyHotelPropertyGroupItem.PolicyHotelStatusId, policyHotelPropertyGroupItem.HarpHotelId, policyHotelPropertyGroupItem.EnabledFlag, policyHotelPropertyGroupItem.EnabledDate, policyHotelPropertyGroupItem.ExpiryDate, policyHotelPropertyGroupItem.TravelDateValidFrom, policyHotelPropertyGroupItem.TravelDateValidTo, adminUserGuid ); }
// GET: /Edit public ActionResult Edit(int id) { //Get PolicyHotelPropertyGroupItem PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); //Check Exists if (policyHotelPropertyGroupItem == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { return(View("Error")); } //Populate List of PolicyHotelStatuses PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository(); SelectList policyHotelStatuses = new SelectList(policyHotelStatusRepository.GetAllPolicyHotelStatuses().ToList(), "PolicyHotelStatusId", "PolicyHotelStatusDescription"); ViewData["PolicyHotelStatusList"] = policyHotelStatuses; //Populate List of HarpHotels HarpHotelRepository harpHotelRepository = new HarpHotelRepository(); SelectList harpHotels = new SelectList(harpHotelRepository.GetAllHarpHotels().ToList(), "HarpHotelId", "HarpHotelName"); ViewData["HarpHotelList"] = harpHotels; //Populate new PolicyHotelPropertyGroupItem with known PolicyGroup Information PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelPropertyGroupItem.PolicyGroupId); policyHotelPropertyGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; //Show 'Edit' Form policyHotelPropertyGroupItemRepository.EditItemForDisplay(policyHotelPropertyGroupItem); return(View(policyHotelPropertyGroupItem)); }
// GET: /View public ActionResult View(int id) { //Get PolicyHotelPropertyGroupItem PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(id); //Check Exists if (policyHotelPropertyGroupItem == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } //populate new PolicyHotelPropertyGroupItem with known PolicyGroup Information policyHotelPropertyGroupItemRepository.EditItemForDisplay(policyHotelPropertyGroupItem); //Show 'View' Form return(View(policyHotelPropertyGroupItem)); }
public ActionResult Create(PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem) { PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelPropertyGroupItem.PolicyGroupId); if (policyGroup == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { return(View("Error")); } //Update Model from Form try { UpdateModel(policyHotelPropertyGroupItem); } catch { return(View("Error")); } //Add PolicyHotelPropertyGroupItem to database try { policyHotelPropertyGroupItemRepository.Add(policyHotelPropertyGroupItem); } catch { //Could not insert to database return(View("Error")); } return(RedirectToAction("List", new { id = policyHotelPropertyGroupItem.PolicyGroupId })); }
// GET: /Create public ActionResult Create(int id) { PolicyGroup policyGroup = policyGroupRepository.GetGroup(id); if (policyGroup == null) { ViewData["ActionMethod"] = "CreateGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(id)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); //Populate List of PolicyHotelStatuses PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository(); SelectList policyHotelStatuses = new SelectList(policyHotelStatusRepository.GetAllPolicyHotelStatuses().ToList(), "PolicyHotelStatusId", "PolicyHotelStatusDescription"); ViewData["PolicyHotelStatusList"] = policyHotelStatuses; //Populate List of HarpHotels HarpHotelRepository harpHotelRepository = new HarpHotelRepository(); SelectList harpHotels = new SelectList(harpHotelRepository.GetAllHarpHotels().ToList(), "HarpHotelId", "HarpHotelName"); ViewData["HarpHotelList"] = harpHotels; //populate new PolicyHotelPropertyGroupItem with known PolicyGroup Information policyHotelPropertyGroupItem.PolicyGroupId = id; policyHotelPropertyGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; //Show 'Create' Form return(View(policyHotelPropertyGroupItem)); }
public ActionResult Edit(int policyHotelPropertyGroupItemId, string languageCode, string hotelAdvice) { //Get Item PolicyHotelPropertyGroupItemLanguage policyHotelPropertyGroupItemLanguage = new PolicyHotelPropertyGroupItemLanguage(); policyHotelPropertyGroupItemLanguage = policyHotelPropertyGroupItemLanguageRepository.GetItem(policyHotelPropertyGroupItemId, languageCode); //Check Exists if (policyHotelPropertyGroupItemLanguage == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem = new PolicyHotelPropertyGroupItem(); policyHotelPropertyGroupItem = policyHotelPropertyGroupItemRepository.GetPolicyHotelPropertyGroupItem(policyHotelPropertyGroupItemId); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelPropertyGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Item from Form try { UpdateModel(policyHotelPropertyGroupItemLanguage); } 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")); } //Update CountryAdvice try { policyHotelPropertyGroupItemLanguageRepository.Update(policyHotelPropertyGroupItemLanguage); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/HotelPropertyAdvice.mvc/Edit/" + policyHotelPropertyGroupItemLanguage.PolicyHotelPropertyGroupItemId.ToString(); 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 = policyHotelPropertyGroupItemLanguage.PolicyHotelPropertyGroupItemId })); }