// GET: /Edit public ActionResult Edit(int id, string languageCode) { //Get Item PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage(); policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyHotelVendorGroupItemLanguage == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Language SelectList SelectList languageList = new SelectList(policyHotelVendorGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; policyHotelVendorGroupItemLanguageRepository.EditItemForDisplay(policyHotelVendorGroupItemLanguage); return(View(policyHotelVendorGroupItemLanguage)); }
public ActionResult Delete(int id, string languageCode) { //Get Item PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage(); policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyHotelVendorGroupItemLanguage == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Add Linked Information policyHotelVendorGroupItemLanguageRepository.EditItemForDisplay(policyHotelVendorGroupItemLanguage); //Return View return(View(policyHotelVendorGroupItemLanguage)); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage) { //Add LanguageName if (policyHotelVendorGroupItemLanguage.LanguageCode != null) { LanguageRepository languageRepository = new LanguageRepository(); Language language = new Language(); language = languageRepository.GetLanguage(policyHotelVendorGroupItemLanguage.LanguageCode); if (language != null) { policyHotelVendorGroupItemLanguage.LanguageName = language.LanguageName; } } //Add PolicyGroupName PolicyHotelVendorGroupItemRepository policyHotelVendorGroupItemRepository = new PolicyHotelVendorGroupItemRepository(); PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId); if (policyHotelVendorGroupItem != null) { policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem); policyHotelVendorGroupItemLanguage.PolicyGroupName = policyHotelVendorGroupItem.PolicyGroupName; policyHotelVendorGroupItemLanguage.PolicyGroupId = policyHotelVendorGroupItem.PolicyGroupId; } }
public ActionResult Delete(int id) { //Get PolicyHotelVendorGroupItem PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); //Check Exists if (policyHotelVendorGroupItem == null) { ViewData["ActionMethod"] = "GetDelete"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //populate new PolicyHotelVendorGroupItem with known PolicyGroup Information policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem); //Show 'Create' Form return(View(policyHotelVendorGroupItem)); }
//Delete public void Delete(PolicyHotelVendorGroupItem policyHotelVendorGroupItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeletePolicyHotelVendorGroupItem_v1( policyHotelVendorGroupItem.PolicyHotelVendorGroupItemId, adminUserGuid, policyHotelVendorGroupItem.VersionNumber ); }
public ActionResult Create(PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage) { PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId); //Check Exists if (policyHotelVendorGroupItem == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { //AccessRights Error return(View("Error")); } //Update Model from Form try { UpdateModel(policyHotelVendorGroupItemLanguage); } 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 { policyHotelVendorGroupItemLanguageRepository.Add(policyHotelVendorGroupItemLanguage); } catch { //Insert Error return(View("Error")); } return(RedirectToAction("List", new { id = policyHotelVendorGroupItem.PolicyHotelVendorGroupItemId })); }
//GET:List public ActionResult List(int id, int?page, string sortField, int?sortOrder) { //Get PolicyHotelVendorGroupItem PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); //Check Exists if (policyHotelVendorGroupItem == null) { ViewData["ActionMethod"] = "ListGet"; return(View("RecordDoesNotExistError")); } //Set Access Rights ViewData["Access"] = ""; RolesRepository rolesRepository = new RolesRepository(); if (rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Access"] = "WriteAccess"; } //SortField+SortOrder settings if (sortField != "Name") { sortField = "LanguageName"; } ViewData["CurrentSortField"] = sortField; if (sortOrder == 1) { ViewData["NewSortOrder"] = 0; ViewData["CurrentSortOrder"] = 1; } else { ViewData["NewSortOrder"] = 1; ViewData["CurrentSortOrder"] = 0; sortOrder = 0; } PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId); ViewData["PolicyGroupName"] = policyGroup.PolicyGroupName; ViewData["PolicyHotelVendorGroupItemId"] = id; //Get data var cwtPaginatedList = policyHotelVendorGroupItemLanguageRepository.PagePolicyHotelVendorGroupItemHotelAdvice(id, page ?? 1, sortField, sortOrder ?? 0); return(View(cwtPaginatedList)); }
// GET: /Edit public ActionResult Edit(int id) { //Get PolicyHotelVendorGroupItem PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); //Check Exists if (policyHotelVendorGroupItem == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Populate List of PolicyLocations PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository(); SelectList policyLocations = new SelectList(policyLocationRepository.GetAllPolicyLocations().ToList(), "PolicyLocationId", "PolicyLocationName"); ViewData["PolicyLocationList"] = policyLocations; //Populate List of PolicyHotelStatuses PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository(); SelectList policyHotelStatuses = new SelectList(policyHotelStatusRepository.GetAllPolicyHotelStatuses().ToList(), "PolicyHotelStatusId", "PolicyHotelStatusDescription"); ViewData["PolicyHotelStatusList"] = policyHotelStatuses; //Populate List of Products ProductRepository productRepository = new ProductRepository(); SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName"); ViewData["ProductList"] = products; //Populate new PolicyHotelVendorGroupItem with known PolicyGroup Information PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId); policyHotelVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; //return edit form policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem); return(View(policyHotelVendorGroupItem)); }
public ActionResult Create(PolicyHotelVendorGroupItem policyHotelVendorGroupItem) { PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId); if (policyGroup == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Model from Form try { UpdateModel(policyHotelVendorGroupItem); } 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 { policyHotelVendorGroupItemRepository.Add(policyHotelVendorGroupItem); } 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 = policyHotelVendorGroupItem.PolicyGroupId })); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(PolicyHotelVendorGroupItem policyHotelVendorGroupItem) { //PolicyHotelStatusDescription if (policyHotelVendorGroupItem.PolicyHotelStatusId != null) { int policyHotelStatusId = (int)policyHotelVendorGroupItem.PolicyHotelStatusId; PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository(); PolicyHotelStatus policyHotelStatus = new PolicyHotelStatus(); policyHotelStatus = policyHotelStatusRepository.GetPolicyHotelStatus(policyHotelStatusId); policyHotelVendorGroupItem.PolicyHotelStatus = policyHotelStatus.PolicyHotelStatusDescription; } //PolicyGroupName PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository(); PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId); policyHotelVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; policyHotelVendorGroupItem.PolicyGroupId = policyGroup.PolicyGroupId; //SupplierName SupplierRepository supplierRepository = new SupplierRepository(); Supplier supplier = new Supplier(); supplier = supplierRepository.GetSupplier(policyHotelVendorGroupItem.SupplierCode, policyHotelVendorGroupItem.ProductId); if (supplier != null) { policyHotelVendorGroupItem.SupplierName = supplier.SupplierName; } //PolicyLocationName PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository(); PolicyLocation policyLocation = new PolicyLocation(); policyLocation = policyLocationRepository.GetPolicyLocation(policyHotelVendorGroupItem.PolicyLocationId); if (policyLocation != null) { policyHotelVendorGroupItem.PolicyLocationName = policyLocation.PolicyLocationName; } ProductRepository productRepository = new ProductRepository(); Product product = new Product(); product = productRepository.GetProduct(policyHotelVendorGroupItem.ProductId); if (product != null) { policyHotelVendorGroupItem.ProductName = product.ProductName; } }
public ActionResult Delete(int id, string languageCode, FormCollection collection) { //Get Item PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage(); policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyHotelVendorGroupItemLanguage == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Delete Item try { policyHotelVendorGroupItemLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]); policyHotelVendorGroupItemLanguageRepository.Delete(policyHotelVendorGroupItemLanguage); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/HotelAdvice.mvc/Delete/" + policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId.ToString() + "/" + policyHotelVendorGroupItemLanguage.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 = policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId })); }
public ActionResult Delete(int id, FormCollection collection) { //Get PolicyHotelVendorGroupItem PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); //Check Exists if (policyHotelVendorGroupItem == null) { ViewData["ActionMethod"] = "PostDelete"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { return(View("Error")); } //Delete Item try { policyHotelVendorGroupItem.VersionNumber = Int32.Parse(collection["VersionNumber"]); policyHotelVendorGroupItemRepository.Delete(policyHotelVendorGroupItem); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/PolicyHotelVendorGroupItem.mvc/Delete/" + policyHotelVendorGroupItem.PolicyHotelVendorGroupItemId; 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 return(RedirectToAction("List", new { id = policyHotelVendorGroupItem.PolicyGroupId })); }
//Add public void Add(PolicyHotelVendorGroupItem policyHotelVendorGroupItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertPolicyHotelVendorGroupItem_v1( policyHotelVendorGroupItem.PolicyGroupId, policyHotelVendorGroupItem.PolicyLocationId, policyHotelVendorGroupItem.SupplierCode, policyHotelVendorGroupItem.ProductId, policyHotelVendorGroupItem.PolicyHotelStatusId, policyHotelVendorGroupItem.EnabledFlag, policyHotelVendorGroupItem.EnabledDate, policyHotelVendorGroupItem.ExpiryDate, policyHotelVendorGroupItem.TravelDateValidFrom, policyHotelVendorGroupItem.TravelDateValidTo, adminUserGuid ); }
// GET: /View public ActionResult View(int id) { //Get PolicyHotelVendorGroupItem PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); //Check Exists if (policyHotelVendorGroupItem == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } //populate new PolicyHotelVendorGroupItem with known PolicyGroup Information policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem); //Show 'View' Form return(View(policyHotelVendorGroupItem)); }
// GET: /Create public ActionResult Create(int id) { //Get PolicyHotelVendorGroupItem PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id); //Check Exists if (policyHotelVendorGroupItem == null) { ViewData["ActionMethod"] = "CreateGet"; return(View("RecordDoesNotExistError")); } //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["ActionMethod"] = "ViewGet"; return(View("Error")); } //New PolicyHotelVendorGroupItemLanguage PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage(); policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId = id; policyHotelVendorGroupItemLanguageRepository.EditItemForDisplay(policyHotelVendorGroupItemLanguage); //Language SelectList SelectList languageList = new SelectList(policyHotelVendorGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; //Show Create Form return(View(policyHotelVendorGroupItemLanguage)); }
public ActionResult Edit(int policyHotelVendorGroupItemId, string languageCode, string hotelAdvice) { //Get Item PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage(); policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(policyHotelVendorGroupItemId, languageCode); //Check Exists if (policyHotelVendorGroupItemLanguage == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem(); policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(policyHotelVendorGroupItemId); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Item from Form try { UpdateModel(policyHotelVendorGroupItemLanguage); } 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 { policyHotelVendorGroupItemLanguageRepository.Update(policyHotelVendorGroupItemLanguage); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/HotelAdvice.mvc/Edit/" + policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId.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 = policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId })); }