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