public ActionResult Delete(int id, string languageCode) { //Get Item PolicyCarTypeGroupItemLanguage policyCarTypeGroupItemLanguage = new PolicyCarTypeGroupItemLanguage(); policyCarTypeGroupItemLanguage = policyCarTypeGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyCarTypeGroupItemLanguage == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Add Linked Information policyCarTypeGroupItemLanguageRepository.EditItemForDisplay(policyCarTypeGroupItemLanguage); //Return View return(View(policyCarTypeGroupItemLanguage)); }
public ActionResult Delete(int id) { //Get PolicyCarTypeGroupItem PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); //Check Exists if (policyCarTypeGroupItem == null) { ViewData["ActionMethod"] = "GetDelete"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //populate new PolicyCarTypeGroupItem with known PolicyGroup Information policyCarTypeGroupItemRepository.EditItemForDisplay(policyCarTypeGroupItem); //Show 'Create' Form return(View(policyCarTypeGroupItem)); }
// GET: /Edit public ActionResult Edit(int id, string languageCode) { //Get Item PolicyCarTypeGroupItemLanguage policyCarTypeGroupItemLanguage = new PolicyCarTypeGroupItemLanguage(); policyCarTypeGroupItemLanguage = policyCarTypeGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyCarTypeGroupItemLanguage == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Language SelectList SelectList languageList = new SelectList(policyCarTypeGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; policyCarTypeGroupItemLanguageRepository.EditItemForDisplay(policyCarTypeGroupItemLanguage); return(View(policyCarTypeGroupItemLanguage)); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(PolicyCarTypeGroupItemLanguage policyCarTypeGroupItemLanguage) { //Add LanguageName if (policyCarTypeGroupItemLanguage.LanguageCode != null) { LanguageRepository languageRepository = new LanguageRepository(); Language language = new Language(); language = languageRepository.GetLanguage(policyCarTypeGroupItemLanguage.LanguageCode); if (language != null) { policyCarTypeGroupItemLanguage.LanguageName = language.LanguageName; } } //Add PolicyGroupName PolicyCarTypeGroupItemRepository policyCarTypeGroupItemRepository = new PolicyCarTypeGroupItemRepository(); PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(policyCarTypeGroupItemLanguage.PolicyCarTypeGroupItemId); if (policyCarTypeGroupItem != null) { policyCarTypeGroupItemRepository.EditItemForDisplay(policyCarTypeGroupItem); policyCarTypeGroupItemLanguage.PolicyGroupName = policyCarTypeGroupItem.PolicyGroupName; policyCarTypeGroupItemLanguage.PolicyGroupId = policyCarTypeGroupItem.PolicyGroupId; } }
public ActionResult Create(PolicyCarTypeGroupItemLanguage policyCarTypeGroupItemLanguage) { PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(policyCarTypeGroupItemLanguage.PolicyCarTypeGroupItemId); //Check Exists if (policyCarTypeGroupItem == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { //AccessRights Error return(View("Error")); } //Update Model from Form try { UpdateModel(policyCarTypeGroupItemLanguage); } 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 { policyCarTypeGroupItemLanguageRepository.Add(policyCarTypeGroupItemLanguage); } 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 = policyCarTypeGroupItem.PolicyCarTypeGroupItemId })); }
//Delete public void Delete(PolicyCarTypeGroupItem policyCarTypeGroupItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeletePolicyCarTypeGroupItem_v1( policyCarTypeGroupItem.PolicyCarTypeGroupItemId, adminUserGuid, policyCarTypeGroupItem.VersionNumber ); }
//GET:List public ActionResult List(int id, int?page, string sortField, int?sortOrder) { //Get PolicyCarTypeGroupItem PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); //Check Exists if (policyCarTypeGroupItem == null) { ViewData["ActionMethod"] = "ListGet"; return(View("RecordDoesNotExistError")); } //Set Access Rights ViewData["Access"] = ""; RolesRepository rolesRepository = new RolesRepository(); if (rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { ViewData["Access"] = "WriteAccess"; } //Parent Information ViewData["PolicyCarTypeGroupItemID"] = policyCarTypeGroupItem.PolicyCarTypeGroupItemId; ViewData["PolicyGroupID"] = policyCarTypeGroupItem.PolicyGroupId; ViewData["PolicyGroupName"] = policyGroupRepository.GetGroup(policyCarTypeGroupItem.PolicyGroupId).PolicyGroupName; //SortField+SortOrder settings if (sortField != "CarTypeAdvice") { 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 = policyCarTypeGroupItemLanguageRepository.PagePolicyCarTypeGroupItemCarTypeAdvice(id, page ?? 1, sortField, sortOrder ?? 0); return(View(cwtPaginatedList)); }
// GET: /Edit public ActionResult Edit(int id) { //Get PolicyCarTypeGroupItem PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); //Check Exists if (policyCarTypeGroupItem == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { 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 PolicyCarStatuses PolicyCarStatusRepository policyCarStatusRepository = new PolicyCarStatusRepository(); SelectList carStatuses = new SelectList(policyCarStatusRepository.GetAllPolicyCarStatuses().ToList(), "PolicyCarStatusId", "PolicyCarStatusDescription"); ViewData["PolicyCarStatusList"] = carStatuses; //Populate List of CarTypeCategories CarTypeCategoryRepository carTypeCategoryRepository = new CarTypeCategoryRepository(); SelectList carTypes = new SelectList(carTypeCategoryRepository.GetAllCarTypeCategories().ToList(), "CarTypeCategoryId", "CarTypeCategoryName"); ViewData["CarTypeCategoryList"] = carTypes; //Populate new PolicyCarTypeGroupItem with known PolicyGroup Information PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyCarTypeGroupItem.PolicyGroupId); policyCarTypeGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; //Show 'Edit' Form policyCarTypeGroupItemRepository.EditItemForDisplay(policyCarTypeGroupItem); return(View(policyCarTypeGroupItem)); }
public ActionResult Delete(int id, string languageCode, FormCollection collection) { //Get Item PolicyCarTypeGroupItemLanguage policyCarTypeGroupItemLanguage = new PolicyCarTypeGroupItemLanguage(); policyCarTypeGroupItemLanguage = policyCarTypeGroupItemLanguageRepository.GetItem(id, languageCode); //Check Exists if (policyCarTypeGroupItemLanguage == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Check AccessRights PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Delete Item try { policyCarTypeGroupItemLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]); policyCarTypeGroupItemLanguageRepository.Delete(policyCarTypeGroupItemLanguage); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/CarTypeAdvice.mvc/Delete/" + policyCarTypeGroupItemLanguage.PolicyCarTypeGroupItemId.ToString() + "/" + policyCarTypeGroupItemLanguage.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 = policyCarTypeGroupItemLanguage.PolicyCarTypeGroupItemId })); }
// 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")); } //Populate List of PolicyLocations PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository(); SelectList policyLocations = new SelectList(policyLocationRepository.GetAllPolicyLocations().ToList(), "PolicyLocationId", "PolicyLocationName"); ViewData["PolicyLocationList"] = policyLocations; //Populate List of PolicyCarStatuses PolicyCarStatusRepository policyCarStatusRepository = new PolicyCarStatusRepository(); SelectList carStatuses = new SelectList(policyCarStatusRepository.GetAllPolicyCarStatuses().ToList(), "PolicyCarStatusId", "PolicyCarStatusDescription"); ViewData["PolicyCarStatusList"] = carStatuses; //Populate List of CarTypeCategories CarTypeCategoryRepository carTypeCategoryRepository = new CarTypeCategoryRepository(); SelectList carTypes = new SelectList(carTypeCategoryRepository.GetAllCarTypeCategories().ToList(), "CarTypeCategoryId", "CarTypeCategoryName"); ViewData["CarTypeCategoryList"] = carTypes; //populate new PolicyCarTypeGroupItem with known PolicyGroup Information PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem.PolicyGroupId = id; policyCarTypeGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; //Show 'Create' Form return(View(policyCarTypeGroupItem)); }
//Add public void Add(PolicyCarTypeGroupItem policyCarTypeGroupItem) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertPolicyCarTypeGroupItem_v1( policyCarTypeGroupItem.PolicyGroupId, policyCarTypeGroupItem.PolicyLocationId, policyCarTypeGroupItem.PolicyCarStatusId, policyCarTypeGroupItem.EnabledFlag, policyCarTypeGroupItem.EnabledDate, policyCarTypeGroupItem.ExpiryDate, policyCarTypeGroupItem.CarTypeCategoryId, policyCarTypeGroupItem.TravelDateValidFrom, policyCarTypeGroupItem.TravelDateValidTo, adminUserGuid ); }
// GET: /View public ActionResult View(int id) { //Get PolicyCarTypeGroupItem PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); //Check Exists if (policyCarTypeGroupItem == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } //populate new PolicyCarTypeGroupItem with known PolicyGroup Information policyCarTypeGroupItemRepository.EditItemForDisplay(policyCarTypeGroupItem); //Show 'View' Form return(View(policyCarTypeGroupItem)); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(PolicyCarTypeGroupItem policyCarTypeGroupItem) { //PolicyGroupName PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository(); PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policyCarTypeGroupItem.PolicyGroupId); policyCarTypeGroupItem.PolicyGroupName = policyGroup.PolicyGroupName; //CarStatus PolicyCarStatusRepository policyCarStatusRepository = new PolicyCarStatusRepository(); PolicyCarStatus policyCarStatus = new PolicyCarStatus(); policyCarStatus = policyCarStatusRepository.GetPolicyCarStatus(policyCarTypeGroupItem.PolicyCarStatusId); policyCarTypeGroupItem.PolicyCarStatusDescription = policyCarStatus.PolicyCarStatusDescription; //CarType Category CarTypeCategoryRepository carTypeCategoryRepository = new CarTypeCategoryRepository(); CarTypeCategory carTypeCategory = new CarTypeCategory(); carTypeCategory = carTypeCategoryRepository.GetCarTypeCategory(policyCarTypeGroupItem.CarTypeCategoryId); if (carTypeCategory != null) { policyCarTypeGroupItem.CarTypeCategoryName = carTypeCategory.CarTypeCategoryName; } //PolicyLocation PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository(); PolicyLocation policyLocation = new PolicyLocation(); policyLocation = policyLocationRepository.GetPolicyLocation(policyCarTypeGroupItem.PolicyLocationId); if (policyLocation != null) { policyCarTypeGroupItem.PolicyLocation = policyLocation.PolicyLocationName; } }
public ActionResult Edit(int id, FormCollection collection) { PolicyCarTypeGroupItem policyCarTypeGroupItem = new PolicyCarTypeGroupItem(); policyCarTypeGroupItem = policyCarTypeGroupItemRepository.GetPolicyCarTypeGroupItem(id); //Check Exists if (policyCarTypeGroupItem == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Check AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarTypeGroupItem.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update PolicyCarTypeGroupItem Model From Form try { UpdateModel(policyCarTypeGroupItem); } 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 { policyCarTypeGroupItemRepository.Update(policyCarTypeGroupItem); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/PolicyCarTypeGroupItem.mvc/Edit/" + policyCarTypeGroupItem.PolicyCarTypeGroupItemId.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 = policyCarTypeGroupItem.PolicyGroupId })); }