public async Task <IActionResult> Edit(SuContentTypeEditGetWithListModel FromForm) { var CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.ContentType.Id), new SqlParameter("@LId", FromForm.ContentType.Lid), new SqlParameter("@Name", FromForm.ContentType.Name ?? ""), new SqlParameter("@Description", FromForm.ContentType.Description ?? ""), new SqlParameter("@MouseOver", FromForm.ContentType.MouseOver ?? ""), new SqlParameter("@MenuName", FromForm.ContentType.MenuName ?? ""), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@SecurityLevel", FromForm.ContentType.SecurityLevel), new SqlParameter("@ProcessTemplateId", FromForm.ContentType.ProcessTemplateId) }; _context.Database.ExecuteSqlCommand("ContentTypeEditPost " + "@OId" + ", @LId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @ModifierId" + ", @SecurityLevel" + ", @ProcessTemplateId", parameters); return(RedirectToAction("Index")); }
public async Task <IActionResult> Edit(int Id) { var CurrentUser = await _userManager.GetUserAsync(User); var DefaultLanguageID = CurrentUser.DefaultLanguageId; var UICustomizationArray = new UICustomization(_context); ViewBag.Terms = await UICustomizationArray.UIArray(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), DefaultLanguageID); Menus a = new Menus(_context); ViewBag.menuItems = await a.TopMenu(DefaultLanguageID); SqlParameter[] parameters = { new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId) , new SqlParameter("@Id", Id) }; var ContentTypeEditGet = _context.ZdbContentTypeEditGet.FromSql("ContentTypeEditGet @LanguageId, @Id", parameters).First(); var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId); List <SuTypeList> SecurityLevelFromDb = await _context.ZDbTypeList.FromSql("select Id, Name from DbSecurityLevel ORDER BY Name").ToListAsync(); List <SuStatusList> ProcessTemplateFromDb = await _context.ZDbStatusList.FromSql("ProcessTemplateList @LanguageId", parameter).ToListAsync(); List <SelectListItem> SecurityLevelList = new List <SelectListItem>(); foreach (var SecurityItem in SecurityLevelFromDb) { SecurityLevelList.Add(new SelectListItem { Value = SecurityItem.Id.ToString(), Text = SecurityItem.Name }); } List <SelectListItem> ProcessTemplateList = new List <SelectListItem>(); ProcessTemplateList.Add(new SelectListItem { Value = "0", Text = "No approval" }); foreach (var ProcessTemplateItem in ProcessTemplateFromDb) { ProcessTemplateList.Add(new SelectListItem { Value = ProcessTemplateItem.Id.ToString(), Text = ProcessTemplateItem.Name }); } SuContentTypeEditGetWithListModel ContentTypeWithLists = new SuContentTypeEditGetWithListModel(); ContentTypeWithLists.ContentType = ContentTypeEditGet; ContentTypeWithLists.SecurityLevelList = SecurityLevelList; ContentTypeWithLists.ProcessTemplateList = ProcessTemplateList; return(View(ContentTypeWithLists)); }