public async Task <Response <List <Rol> > > GetAllAsync() => ReturnResult((await CreateMapper()).MapList((await SqlAccessService.SelectData("with recursivo as ( select SP2.RolId, " + "SP2.PermisoId from Rol_Permiso SP2 where " + " sp2.RolId is null UNION ALL select sp.RolId," + " sp.PermisoId from Rol_Permiso sp join recursivo r " + "on r.PermisoId= sp.RolId) select * from recursivo r " + "inner join permiso p on r.PermisoId = p.Id"))));
public new async Task <Response <List <TraduccionValue> > > Get(List <Idioma> idiomas) { var result = (await CreateMapper()).MapList(await SqlAccessService.SelectData("SELECT Tr.Id," + "Tr.Traduccion," + "T.KeyValue," + "Tr.Id_Idioma," + "Tr.Id_Termino " + "FROM Traducciones AS Tr " + "INNER JOIN Terminos T " + "ON Tr.Id_Termino = T.Id " + $"WHERE Tr.Id_Idioma IN ({ string.Join(",", idiomas.Select(x => x.Id))})")); return(Response <List <TraduccionValue> > .From(result)); }
public async Task <Response <Rol> > GetByUsuarioIdAsync(int usuarioId) { var query = await SqlAccessService.SelectData(" with recursivo as" + " (" + " select SP2.RolId, SP2.PermisoId from Rol_Permiso SP2" + " join Usuarios ur on ur.Rol_Id = sp2.PermisoId" + $" where sp2.RolId is null and ur.Id = {usuarioId}" + " UNION ALL" + " select sp.RolId, sp.PermisoId from Rol_Permiso sp" + " join recursivo r on r.PermisoId= sp.RolId" + ")" + " select * from recursivo r inner join permiso p on r.PermisoId = p.Id"); var map = (await CreateMapper()).Map(query); return(ReturnResult(map)); }
public async Task <Response <List <Rol> > > Get() { var query = await SqlAccessService.SelectData(" with recursivo as" + " (" + " select SP2.RolId, SP2.PermisoId from Rol_Permiso SP2" + " where sp2.RolId is null" + " UNION ALL" + " select sp.RolId, sp.PermisoId from Rol_Permiso sp" + " join recursivo r on r.PermisoId= sp.RolId" + ")" + " select * from recursivo r inner join permiso p on r.PermisoId = p.Id" + " group by RolId, PermisoId, Id, Nombre, Descripcion, ByDefault,[Type]"); var map = (await CreateMapper()).MapList(query); return(ReturnResult(map)); }
public async Task <Response <List <TraduccionValue> > > GetAllKeys() { var result = (await CreateMapper()).MapList(await SqlAccessService.SelectData("SELECT Id as Id_Termino, KeyValue FROM Terminos")); return(Response <List <TraduccionValue> > .From(result)); }
public async Task <Response <List <TEntity> > > GetAsync() => ReturnResult((await CreateMapper()).MapList((await SqlAccessService.SelectData((await EntityToColumns <TEntity> .MapAsync()) .Send()))));