public async Task <IActionResult> LeftMenuCreate(SuPreferenceLeftMenuCreateGetModel FromForm) { var CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@LeftMenuId", FromForm.CreateMenuUser.LeftMenuId), new SqlParameter("@MenuShow", FromForm.CreateMenuUser.MenuShow), new SqlParameter("@MenuAddShow", FromForm.CreateMenuUser.MenuAddShow), new SqlParameter("@SearchShow", FromForm.CreateMenuUser.SearchShow), new SqlParameter("@AdvancedSearchShow", FromForm.CreateMenuUser.AdvancedSearchShow), new SqlParameter("@MenuName", FromForm.CreateMenuUser.MenuName ?? ""), new SqlParameter("@MenuURL", FromForm.CreateMenuUser.MenuURL ?? ""), new SqlParameter("@Sequence", FromForm.CreateMenuUser.Sequence), new SqlParameter("@UserId", CurrentUser.Id), }; _context.Database.ExecuteSqlCommand("PreferenceLeftMenuCreatePost " + "@LeftMenuId" + ", @MenuShow" + ", @MenuAddShow" + ", @SearchShow" + ", @AdvancedSearchShow" + ", @MenuName" + ", @MenuURL" + ", @Sequence" + ", @UserId", parameters); return(RedirectToAction("LeftMenu")); }
public async Task <IActionResult> LeftMenuCreate() { 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); var parameter = new SqlParameter("@CurrentUser", CurrentUser.Id); List <SuTypeList> AvailableMenus = _context.ZDbTypeList.FromSql("PreferenceLeftMenuCreateGetAvailableMenus @CurrentUser", parameter).ToList(); if (AvailableMenus.Count() == 0) { return(RedirectToAction("LeftMenu")); } var AvailableMenuList = new List <SelectListItem>(); foreach (var AvailableMenu in AvailableMenus) { AvailableMenuList.Add(new SelectListItem { Text = AvailableMenu.Name, Value = AvailableMenu.Id.ToString() }); } List <SuStatusList> ExistingMenus = _context.ZDbStatusList.FromSql("PreferenceLeftMenuCreateGetExistingMenus @CurrentUser", parameter).ToList(); var ExistingMenuList = new List <SelectListItem>(); var maxlevel = 0; foreach (var ExistingMenu in ExistingMenus) { if (maxlevel < ExistingMenu.Id) { maxlevel = ExistingMenu.Id; } ExistingMenuList.Add(new SelectListItem { Text = ExistingMenu.Name, Value = ExistingMenu.Id.ToString() }); maxlevel++; } ExistingMenuList.Add(new SelectListItem { Text = "add at bottom", Value = maxlevel.ToString() }); SuPreferenceLeftMenuCreateGetModel BothMenuLists = new SuPreferenceLeftMenuCreateGetModel(); BothMenuLists.AvailableMenus = AvailableMenuList; BothMenuLists.ExistingMenus = ExistingMenuList; return(View(BothMenuLists)); }