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));
}
