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