public IEnumerable <MenuAcaoList> GetListMenuUsuario(string IdUsuario, long IdCtaAcessoSist)
{
List <MenuAcaoList> acaoMenuList = new List <MenuAcaoList>();
var listaAcaoMenu =
from M in this._contextRepository.DbMenu.Where(m => m.IdCtaAcessoSist == IdCtaAcessoSist)
join A1 in this._contextRepository.DbAcao.Where(a1 => a1.IdCtaAcessoSist == IdCtaAcessoSist) on M.IdAcao equals A1.Id into _a
from A1 in _a.DefaultIfEmpty()
join UA in this._contextRepository.DbUsuarioAcao.Where(ua2 => ua2.IdUsuario == IdUsuario) on A1.Id equals UA.IdAcao into _ua
from UA in _ua.DefaultIfEmpty()
orderby(M.Ordem)
select new
{
Id = M.Id,
IdMenuPai = M.IdMenuPai,
IdAcao = M.IdAcao,
IdTipoMenu = M.IdTipoMenu,
IdClaimRole = A1.IdClaimRole,
IdCtaAcessoSist = M.IdCtaAcessoSist,
Ordem = M.Ordem,
DescricaoMenu = M.DescricaoMenu ?? A1.DescricaoPequeno,
DescricaoMenuMobile = M.DescricaoMenuMobile ?? A1.DescricaoPequeno,
IconeWeb = M.IconeWeb ?? A1.IconeWeb ?? "fa-angle-double-right",
IconeMobile = M.IconeMobile ?? A1.IconeMobile ?? "fa-angle-double-right",
Action = A1.Action,
Controller = A1.Controller,
Parametros = A1.Parametros,
DescricaoBalao = A1.DescricaoBalao,
DescricaoTip = A1.DescricaoTip,
Orientacao = A1.Orientacao,
Permissao = UA.Equals(null) ? false : true,
Ativo = M.Ativo,
EmManutencao = (!A1.EmManutencao) ? M.EmManutencao : A1.EmManutencao
};
foreach (var acaoMenu in listaAcaoMenu)
{
acaoMenuList.Add(new MenuAcaoList
{
Id = acaoMenu.Id,
IdMenuPai = acaoMenu.IdMenuPai,
IdAcao = acaoMenu.IdAcao,
IdTipoMenu = acaoMenu.IdTipoMenu,
IdClaimRole = acaoMenu.IdClaimRole,
IdCtaAcessoSist = acaoMenu.IdCtaAcessoSist,
Action = acaoMenu.Action,
Ativo = acaoMenu.Ativo,
Controller = acaoMenu.Controller,
DescricaoBalao = acaoMenu.DescricaoBalao,
DescricaoMenu = acaoMenu.DescricaoMenu,
DescricaoMenuMobile = acaoMenu.DescricaoMenuMobile,
DescricaoTip = acaoMenu.DescricaoTip,
EmManutencao = acaoMenu.EmManutencao,
IconeMobile = acaoMenu.IconeMobile,
IconeWeb = acaoMenu.IconeWeb,
Ordem = acaoMenu.Ordem,
Orientacao = acaoMenu.Orientacao,
Parametros = acaoMenu.Parametros,
Permissao = acaoMenu.Permissao
});
}
return(acaoMenuList);
}