//Delete From DB public void Delete(ReasonCodeProductTypeDescription reasonCodeProductTypeDescription) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeleteReasonCodeProductTypeDescription_v1( reasonCodeProductTypeDescription.ReasonCode, reasonCodeProductTypeDescription.ProductId, reasonCodeProductTypeDescription.ReasonCodeTypeId, reasonCodeProductTypeDescription.LanguageCode, adminUserGuid, reasonCodeProductTypeDescription.VersionNumber ); }
//GET: View public ActionResult View(string reasonCode, int productId, int reasonCodeTypeId, string languageCode) { ReasonCodeProductTypeDescription reasonCodeProductTypeDescription = new ReasonCodeProductTypeDescription(); reasonCodeProductTypeDescription = reasonCodeProductTypeDescriptionRepository.GetItem(languageCode, reasonCode, productId, reasonCodeTypeId); if (reasonCodeProductTypeDescription == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } reasonCodeProductTypeDescriptionRepository.EditItemForDisplay(reasonCodeProductTypeDescription); return(View(reasonCodeProductTypeDescription)); }
//Add to DB public void Add(ReasonCodeProductTypeDescription reasonCodeProductTypeDescription) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertReasonCodeProductTypeDescription_v1( reasonCodeProductTypeDescription.ReasonCode, reasonCodeProductTypeDescription.ProductId, reasonCodeProductTypeDescription.ReasonCodeTypeId, reasonCodeProductTypeDescription.LanguageCode, reasonCodeProductTypeDescription.ReasonCodeProductTypeDescription1, adminUserGuid ); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(ReasonCodeProductTypeDescription reasonCodeProductTypeDescription) { //Add LanguageName if (reasonCodeProductTypeDescription.LanguageCode != null) { LanguageRepository languageRepository = new LanguageRepository(); Language language = new Language(); language = languageRepository.GetLanguage(reasonCodeProductTypeDescription.LanguageCode); if (language != null) { reasonCodeProductTypeDescription.LanguageName = language.LanguageName; } } }
// GET: /Create public ActionResult Create(string reasonCode, int productId, int reasonCodeTypeId) { //Get Item ReasonCodeProductType reasonCodeProductType = new ReasonCodeProductType(); reasonCodeProductType = reasonCodeProductTypeRepository.GetReasonCodeProductType(reasonCode, productId, reasonCodeTypeId); //Check Exists if (reasonCodeProductType == null) { ViewData["ActionMethod"] = "CreateGet"; return(View("RecordDoesNotExistError")); } //New ReasonCodeProductTypeDescription ReasonCodeProductTypeDescription reasonCodeProductTypeDescription = new ReasonCodeProductTypeDescription(); reasonCodeProductTypeDescription.ReasonCode = reasonCode; reasonCodeProductTypeDescription.ProductId = productId; reasonCodeProductTypeDescription.ReasonCodeTypeId = reasonCodeTypeId; reasonCodeProductTypeDescriptionRepository.EditItemForDisplay(reasonCodeProductTypeDescription); ProductRepository productRepository = new ProductRepository(); Product product = new Product(); product = productRepository.GetProduct(productId); ReasonCodeTypeRepository reasonCodeTypeRepository = new ReasonCodeTypeRepository(); ReasonCodeType reasonCodeType = new ReasonCodeType(); reasonCodeType = reasonCodeTypeRepository.GetItem(reasonCodeTypeId); ReasonCodeItemRepository reasonCodeItemRepository = new ReasonCodeItemRepository(); ReasonCodeItem reasonCodeItem = new ReasonCodeItem(); reasonCodeItem = reasonCodeItemRepository.GetItem(1); ViewData["ReasonCodeItem"] = reasonCode + "/" + reasonCodeType.ReasonCodeTypeDescription + "/" + product.ProductName; //Language SelectList SelectList languageList = new SelectList(reasonCodeProductTypeDescriptionRepository.GetUnUsedLanguages(reasonCode, productId, reasonCodeTypeId).ToList(), "LanguageCode", "LanguageName"); ViewData["Languages"] = languageList; //Show Create Form return(View(reasonCodeProductTypeDescription)); }
public ActionResult Delete(string reasonCode, int productId, int reasonCodeTypeId, string languageCode) { //Get Item ReasonCodeProductTypeDescription reasonCodeProductTypeDescription = new ReasonCodeProductTypeDescription(); reasonCodeProductTypeDescription = reasonCodeProductTypeDescriptionRepository.GetItem(languageCode, reasonCode, productId, reasonCodeTypeId); //Check Exists if (reasonCodeProductTypeDescription == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //Add Linked Information reasonCodeProductTypeDescriptionRepository.EditItemForDisplay(reasonCodeProductTypeDescription); //Return View return(View(reasonCodeProductTypeDescription)); }
public ActionResult Delete(string reasonCode, int productId, int reasonCodeTypeId, string languageCode, FormCollection collection) { //Get Item ReasonCodeProductTypeDescription reasonCodeProductTypeDescription = new ReasonCodeProductTypeDescription(); reasonCodeProductTypeDescription = reasonCodeProductTypeDescriptionRepository.GetItem(languageCode, reasonCode, productId, reasonCodeTypeId); //Check Exists if (reasonCodeProductTypeDescription == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Delete Item try { reasonCodeProductTypeDescription.VersionNumber = Int32.Parse(collection["VersionNumber"]); reasonCodeProductTypeDescriptionRepository.Delete(reasonCodeProductTypeDescription); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/AirlineAdvice.mvc/Delete?reasonCodeTypeId=" + reasonCodeTypeId.ToString() + "&languagCode=" + languageCode + "&reasonCode=" + reasonCode.ToString() + "&productId=" + productId.ToString() + "&reasonCodeTypeId=" + reasonCodeTypeId.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 return(RedirectToAction("List", new { reasonCode = reasonCode, productId = productId, reasonCodeTypeId = reasonCodeTypeId })); }
//Add Data From Linked Tables for Display public void EditItemForDisplay(ReasonCodeItem reasonCodeItem) { ProductRepository productRepository = new ProductRepository(); Product product = new Product(); product = productRepository.GetProduct(reasonCodeItem.ProductId); if (product != null) { reasonCodeItem.ProductName = product.ProductName; } ReasonCodeTypeRepository reasonCodeTypeRepository = new ReasonCodeTypeRepository(); ReasonCodeType reasonCodeType = new ReasonCodeType(); reasonCodeType = reasonCodeTypeRepository.GetItem(reasonCodeItem.ReasonCodeTypeId); if (reasonCodeType != null) { reasonCodeItem.ReasonCodeTypeDescription = reasonCodeType.ReasonCodeTypeDescription; } ReasonCodeProductTypeDescriptionRepository reasonCodeProductTypeDescriptionRepository = new ReasonCodeProductTypeDescriptionRepository(); ReasonCodeProductTypeDescription reasonCodeProductTypeDescription = new ReasonCodeProductTypeDescription(); reasonCodeProductTypeDescription = reasonCodeProductTypeDescriptionRepository.GetItem( "en-GB", reasonCodeItem.ReasonCode, reasonCodeItem.ProductId, reasonCodeItem.ReasonCodeTypeId ); reasonCodeItem.ReasonCodeDescription = (reasonCodeProductTypeDescription != null) ? reasonCodeProductTypeDescription.ReasonCodeProductTypeDescription1 : String.Empty; ReasonCodeGroupRepository reasonCodeGroupRepository = new ReasonCodeGroupRepository(); ReasonCodeGroup reasonCodeGroup = new ReasonCodeGroup(); reasonCodeGroup = reasonCodeGroupRepository.GetGroup(reasonCodeItem.ReasonCodeGroupId); if (reasonCodeGroup != null) { reasonCodeItem.ReasonCodeGroupName = reasonCodeGroup.ReasonCodeGroupName; } }
public ActionResult Create(ReasonCodeProductTypeDescription reasonCodeProductTypeDescription) { //Get Item ReasonCodeProductType reasonCodeProductType = new ReasonCodeProductType(); reasonCodeProductType = reasonCodeProductTypeRepository.GetReasonCodeProductType(reasonCodeProductTypeDescription.ReasonCode, reasonCodeProductTypeDescription.ProductId, reasonCodeProductTypeDescription.ReasonCodeTypeId); //Check Exists if (reasonCodeProductType == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //Update Model from Form try { UpdateModel(reasonCodeProductTypeDescription); } 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")); } reasonCodeProductTypeDescriptionRepository.Add(reasonCodeProductTypeDescription); return(RedirectToAction("List", new { reasonCode = reasonCodeProductTypeDescription.ReasonCode, productId = reasonCodeProductTypeDescription.ProductId, reasonCodeTypeId = reasonCodeProductTypeDescription.ReasonCodeTypeId })); }
public ActionResult Edit(string reasonCode, int productId, int reasonCodeTypeId, string languageCode, FormCollection formCollection) { //Get Item ReasonCodeProductTypeDescription reasonCodeProductTypeDescription = new ReasonCodeProductTypeDescription(); reasonCodeProductTypeDescription = reasonCodeProductTypeDescriptionRepository.GetItem(languageCode, reasonCode, productId, reasonCodeTypeId); //Check Exists if (reasonCodeProductTypeDescription == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Update Item from Form try { UpdateModel(reasonCodeProductTypeDescription); } 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 try { reasonCodeProductTypeDescriptionRepository.Update(reasonCodeProductTypeDescription); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/ReasonCodeProductTypeDescription.mvc/Edit?reasonCodeTypeId=" + reasonCodeTypeId.ToString() + "&languagCode=" + languageCode + "&reasonCode=" + reasonCode.ToString() + "&productId=" + productId.ToString() + "&reasonCodeTypeId=" + reasonCodeTypeId.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 { reasonCode = reasonCode, productId = productId, reasonCodeTypeId = reasonCodeTypeId })); }