public async Task <IActionResult> LeftMenuEdit(SuPreferenceLeftMenuEditGetModelWithList FromForm) { var CurrentUser = await _userManager.GetUserAsync(User); if (ModelState.IsValid) { SqlParameter[] parameters = { new SqlParameter("@Id", FromForm.MenuEdit.UserMenuId), new SqlParameter("@MenuShow", FromForm.MenuEdit.MenuShow), new SqlParameter("@MenuAddShow", FromForm.MenuEdit.MenuAddShow), new SqlParameter("@SearchShow", FromForm.MenuEdit.SearchShow), new SqlParameter("@AdvancedSearchShow", FromForm.MenuEdit.AdvancedSearchShow), new SqlParameter("@MenuName", FromForm.MenuEdit.MenuName ?? ""), new SqlParameter("@MenuURL", FromForm.MenuEdit.MenuURL ?? ""), new SqlParameter("@Sequence", FromForm.MenuEdit.Sequence), new SqlParameter("@UserId", CurrentUser.Id) //, }; _context.Database.ExecuteSqlCommand("PreferenceLeftMenuEditPost " + "@Id" + ", @MenuShow" + ", @MenuAddShow" + ", @SearchShow" + ", @AdvancedSearchShow" + ", @MenuName" + ", @MenuURL" + ", @Sequence" + ", @UserId", parameters); } return(RedirectToAction("LeftMenu")); }
public async Task <IActionResult> LeftMenuEdit(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("@Id", Id), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId) }; SqlParameter[] parameters2 = { new SqlParameter("@CurrentUser", CurrentUser.Id), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId) }; SuPreferenceLeftMenuEditGetModel MenuEditGet = _context.ZdbPreferenceLeftMenuEditGet.FromSql("PreferenceLeftMenuEditGet @Id, @LanguageId", parameters).First(); List <SuTypeList> OtherMenus = _context.ZDbTypeList.FromSql("PreferenceLeftMenuEditGetOtherMenus @CurrentUser, @LanguageId", parameters2).ToList(); var MenuList = new List <SelectListItem>(); foreach (var OtherMenu in OtherMenus) { MenuList.Add(new SelectListItem { Text = OtherMenu.Name, Value = OtherMenu.Id.ToString() }); } SuPreferenceLeftMenuEditGetModelWithList MenuWithList = new SuPreferenceLeftMenuEditGetModelWithList { MenuEdit = MenuEditGet, OtherMenus = MenuList }; return(View(MenuWithList)); }