public async Task <List <NavigationMenu> > GetNavigationMenus(int applicationId) { using (var ctx = new MenuManagementDevContext()) { var result = await ctx.NavigationMenu.Where(m => m.ApplicationId == applicationId).ToListAsync(); return(result); } }
public async Task <ILookup <int, NavigationMenu> > GetNavigationMenusChildren(IEnumerable <int> ids) { using (var ctx = new MenuManagementDevContext()) { var result = await ctx.NavigationMenu.Where(m => ids.Contains(m.Id)).ToListAsync(); return(result.ToLookup(n => n.ParentId.GetValueOrDefault())); } }
public async Task <ILookup <int, RoleNavigationMenu> > GetRoleNavigationMenus(IEnumerable <int> navigationIds) { using (var ctx = new MenuManagementDevContext()) { var result = await ctx.RoleNavigationMenu.Where(m => navigationIds.Contains(m.NavigationMenuId)).ToListAsync(); return(result.ToLookup(r => r.NavigationMenuId)); } }