| | | 1 | | using FAU.DataAccess; |
| | | 2 | | using FAU.Entidades; |
| | | 3 | | using FAU.Logica.DTOs; |
| | | 4 | | using Microsoft.AspNetCore.Authorization; |
| | | 5 | | using Microsoft.AspNetCore.Mvc; |
| | | 6 | | using Microsoft.EntityFrameworkCore; |
| | | 7 | | |
| | | 8 | | namespace FAU.API.Controllers; |
| | | 9 | | |
| | | 10 | | /// <summary> |
| | | 11 | | /// Catálogo de acreedores para descuentos personales |
| | | 12 | | /// </summary> |
| | | 13 | | [ApiController] |
| | | 14 | | [Route("api/acreedores")] |
| | | 15 | | [Authorize] |
| | | 16 | | public class AcreedoresController : ControllerBase |
| | | 17 | | { |
| | | 18 | | private readonly ApplicationDbContext _context; |
| | | 19 | | private readonly ILogger<AcreedoresController> _logger; |
| | | 20 | | |
| | 3 | 21 | | public AcreedoresController( |
| | 3 | 22 | | ApplicationDbContext context, |
| | 3 | 23 | | ILogger<AcreedoresController> logger) |
| | | 24 | | { |
| | 3 | 25 | | _context = context; |
| | 3 | 26 | | _logger = logger; |
| | 3 | 27 | | } |
| | | 28 | | |
| | | 29 | | /// <summary> |
| | | 30 | | /// Listar acreedores activos para selección en formularios |
| | | 31 | | /// GET /api/acreedores |
| | | 32 | | /// </summary> |
| | | 33 | | [HttpGet] |
| | | 34 | | [FAU.API.Security.RequirePermission(PermisoEnum.CrearDescuentosPersonales)] |
| | | 35 | | public async Task<IActionResult> GetAcreedores([FromQuery] bool? activo = true) |
| | | 36 | | { |
| | | 37 | | try |
| | | 38 | | { |
| | 3 | 39 | | var query = _context.Acreedores.AsNoTracking(); |
| | | 40 | | |
| | 3 | 41 | | if (activo.HasValue) |
| | | 42 | | { |
| | 3 | 43 | | query = query.Where(acreedor => acreedor.Activo == activo.Value); |
| | | 44 | | } |
| | | 45 | | |
| | 3 | 46 | | var acreedores = await query |
| | 3 | 47 | | .OrderBy(acreedor => acreedor.OrdenLegalDeficit) |
| | 3 | 48 | | .ThenBy(acreedor => acreedor.Nombre) |
| | 3 | 49 | | .Select(acreedor => new AcreedorDto |
| | 3 | 50 | | { |
| | 3 | 51 | | Id = acreedor.Id, |
| | 3 | 52 | | Codigo = acreedor.Codigo, |
| | 3 | 53 | | Nombre = acreedor.Nombre, |
| | 3 | 54 | | CategoriaDeficit = acreedor.CategoriaDeficit, |
| | 3 | 55 | | OrdenLegalDeficit = acreedor.OrdenLegalDeficit, |
| | 3 | 56 | | FormatoArchivo = acreedor.FormatoArchivo, |
| | 3 | 57 | | Contacto = acreedor.Contacto, |
| | 3 | 58 | | Activo = acreedor.Activo |
| | 3 | 59 | | }) |
| | 3 | 60 | | .ToListAsync(); |
| | | 61 | | |
| | 3 | 62 | | return Ok(ApiResponse<IEnumerable<AcreedorDto>>.SuccessResult(acreedores)); |
| | | 63 | | } |
| | 0 | 64 | | catch (Exception ex) |
| | | 65 | | { |
| | 0 | 66 | | _logger.LogError(ex, "Error al obtener acreedores"); |
| | 0 | 67 | | return StatusCode(500, ApiResponse<string>.ErrorResult("Error interno del servidor")); |
| | | 68 | | } |
| | 3 | 69 | | } |
| | | 70 | | } |