public List <Menu> GetMenuData(string[] userRoles)
{
List <Menu> menuItems;
using (var context = new AppMenuEntities())
{
var menuData = from menu in context.Menus
where (menu.MenuRoles.Any(role => userRoles.Contains(role.RoleName)))
orderby menu.OrderNumber ascending
select menu;
menuItems = menuData.ToList();
}
return(menuItems);
}
//Get all sub menu links data by top menu ID
public List <SubMenuLink> GetAllSubMenuLinkData(int TopMenuID, string[] userRoles)
{
List <SubMenuLink> subMenuLinkItems;
using (var context = new AppMenuEntities())
{
var subMenuLinkData = from subMenuLink in context.SubMenuLinks
where ((subMenuLink.SubMenuLinkRoles.Any(role => userRoles.Contains(role.RoleName))) &&
(subMenuLink.SubMenu.MenuID == TopMenuID))
orderby subMenuLink.OrderNumber ascending
select subMenuLink;
subMenuLinkItems = subMenuLinkData.ToList();
}
return(subMenuLinkItems);
}
public List <SubMenu> GetSubMenuData(int MenuID, string[] userRoles)
{
List <SubMenu> subMenuItems;
using (var context = new AppMenuEntities())
{
var subMenuData = from subMenu in context.SubMenus
where ((subMenu.SubMenuRoles.Any(role => userRoles.Contains(role.RoleName))) &&
(subMenu.MenuID == MenuID))
orderby subMenu.OrderNumber ascending
select subMenu;
subMenuItems = subMenuData.ToList();
}
return(subMenuItems);
}
