// GET: UserMenuPermissions/Create public ActionResult Create(int?id) { DataTable dt = GetMenuInformation(); List <MenuInfoViewModel> menuInformation = DatatoObject(dt); ViewBag.UserID = new SelectList(db.UserInformations, "Id", "UserFullName"); List <MenuInfoViewModel> data = null; if (id != null) { var val = db.UserInformations.Find(id); data = (from m in menuInformation join um in db.CmnUserMenuPermissions.Where(p => p.UserID == id) on m.ID equals um.MenuID into Gpum from pum in Gpum.DefaultIfEmpty() select new MenuInfoViewModel { ID = m.ID, Menu = m.Menu, ParentMenu = m.ParentMenu, IsActive = pum?.IsActive ?? false }).OrderByDescending(p => p.IsActive).ToList(); ViewData["menuInformation"] = data; ViewData["userID"] = val; ViewBag.UserID = new SelectList(db.UserInformations, "Id", "UserFullName", val.Id); } else { ViewData["menuInformation"] = menuInformation; } return(View()); }
public ActionResult GetselectUserMenu(int UserId) { DataTable dt = GetMenuInformation(); List <MenuInfoViewModel> menuInformation = DatatoObject(dt); List <MenuInfoViewModel> data = (from m in menuInformation join um in db.CmnUserMenuPermissions.Where(p => p.UserID == UserId) on m.ID equals um.MenuID into Gpum from pum in Gpum.DefaultIfEmpty() select new MenuInfoViewModel { ID = m.ID, Menu = m.Menu, ParentMenu = m.ParentMenu, IsActive = pum?.IsActive ?? false }).OrderByDescending(p => p.IsActive).ToList(); return(PartialView("_LoadDataByFilter", data)); }