public async Task <IActionResult> Edit(SuClassificationPageEditGetWithListModel FromForm) { SuUserModel CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@OId", FromForm.ClassificationPage.OId), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@StatusId", FromForm.ClassificationPage.StatusId), new SqlParameter("@ShowTitleName", FromForm.ClassificationPage.ShowTitleName), new SqlParameter("@ShowTitleDescription", FromForm.ClassificationPage.ShowTitleDescription), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.ClassificationPage.Name), new SqlParameter("@Description", FromForm.ClassificationPage.Description), new SqlParameter("@MouseOver", FromForm.ClassificationPage.MouseOver), new SqlParameter("@MenuName", FromForm.ClassificationPage.MenuName), new SqlParameter("@TitleName", FromForm.ClassificationPage.TitleName), new SqlParameter("@TitleDescription", FromForm.ClassificationPage.TitleDescription) }; _context.Database.ExecuteSqlCommand("ClassificationPageEditPost " + "@OId" + ", @LanguageId" + ", @StatusId" + ", @ShowTitleName" + ", @ShowTitleDescription" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @TitleName" + ", @TitleDescription", parameters); return(RedirectToAction("Index", new { Id = FromForm.ClassificationPage.PId })); }
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("@OId", Id) }; SuClassificationPageEditGetModel ClassificationPageEditGet = _context.ZdbClassificationPageEditGet.FromSql("ClassificationPageEditGet @LanguageId, @OId", parameters).First(); var StatusList = new List <SelectListItem>(); var ContentStatusFromDb = _context.ZDbStatusList.FromSql("PageStatusSelectAll").ToList(); foreach (var StatusFromDb in ContentStatusFromDb) { StatusList.Add(new SelectListItem { Text = StatusFromDb.Name, Value = StatusFromDb.Id.ToString() }); } SuClassificationPageEditGetWithListModel ClassificationPageWithList = new SuClassificationPageEditGetWithListModel { ClassificationPage = ClassificationPageEditGet , StatusList = StatusList }; return(View(ClassificationPageWithList)); }