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("@Id", Id)
};
var Menu2EditGet = _context.ZdbMenu2EditGet.FromSql("Menu2EditGet @LanguageId, @Id", parameters).First();
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var Classifications = _context.ZDbTypeList.FromSql("Menu123EditGetClassificationList @LanguageId", parameter).ToList();
var ClassificationList = new List <SelectListItem>();
foreach (var Classification in Classifications)
{
ClassificationList.Add(new SelectListItem
{
Text = Classification.Name,
Value = Classification.Id.ToString()
});
}
var MenuTypes = _context.ZDbTypeList.FromSql("MenuTypeList").ToList();
var MenuTypeList = new List <SelectListItem>();
foreach (var MenuType in MenuTypes)
{
MenuTypeList.Add(new SelectListItem
{
Text = MenuType.Name,
Value = MenuType.Id.ToString()
});
}
SuMenu2EditGetWithListModel Menu2WithList = new SuMenu2EditGetWithListModel
{
Menu2 = Menu2EditGet,
ClassificationList = ClassificationList,
MenuTypeList = MenuTypeList
};
return(View(Menu2WithList));
}
public async Task <IActionResult> Edit(SuMenu2EditGetWithListModel FromForm)
{
var CurrentUser = await _userManager.GetUserAsync(User);
SqlParameter[] parameters =
{
new SqlParameter("@Id", FromForm.Menu2.Id),
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId),
new SqlParameter("@Sequence", FromForm.Menu2.Sequence),
new SqlParameter("@ClassificationId", FromForm.Menu2.ClassificationId),
new SqlParameter("@FeatureId", FromForm.Menu2.FeatureId),
new SqlParameter("@Controller", FromForm.Menu2.Controller ?? ""),
new SqlParameter("@Action", FromForm.Menu2.Action ?? ""),
new SqlParameter("@DestinationId", FromForm.Menu2.DestinationId),
new SqlParameter("@ModifierId", CurrentUser.Id),
new SqlParameter("@MenuName", FromForm.Menu2.MenuName),
new SqlParameter("@MouseOver", FromForm.Menu2.MouseOver)
};
_context.Database.ExecuteSqlCommand("Menu2EditPost " +
"@Id" +
", @LanguageId" +
", @Sequence" +
", @ClassificationId" +
", @FeatureId" +
", @Controller" +
", @Action" +
", @DestinationId" +
", @ModifierId" +
", @MenuName" +
", @MouseOver", parameters);
return(RedirectToAction("Index"));
}
