| | | 1 | | using FAU.Entidades; |
| | | 2 | | using Microsoft.EntityFrameworkCore; |
| | | 3 | | |
| | | 4 | | namespace FAU.DataAccess.Repositories; |
| | | 5 | | |
| | | 6 | | public class CompPersonal048018Repository : ICompPersonal048018Repository |
| | | 7 | | { |
| | | 8 | | private readonly ApplicationDbContext _contexto; |
| | | 9 | | |
| | 12 | 10 | | public CompPersonal048018Repository(ApplicationDbContext contexto) |
| | | 11 | | { |
| | 12 | 12 | | _contexto = contexto; |
| | 12 | 13 | | } |
| | | 14 | | |
| | | 15 | | public Task<CompPersonal048018?> ObtenerPorIdAsync(long id) => |
| | 20 | 16 | | ConsultaCompleta().FirstOrDefaultAsync(c => c.Id == id); |
| | | 17 | | |
| | | 18 | | public Task<CompPersonal048018?> ObtenerActivoPorPersonaAsync(long personaId) => |
| | 12 | 19 | | ConsultaCompleta().FirstOrDefaultAsync(c => c.PersonaId == personaId && c.Estado == "activo"); |
| | | 20 | | |
| | | 21 | | public async Task<(IReadOnlyList<CompPersonal048018> Items, int Total)> ObtenerPaginadoAsync( |
| | | 22 | | int pagina, |
| | | 23 | | int tamano, |
| | | 24 | | string? busqueda, |
| | | 25 | | string? estado) |
| | | 26 | | { |
| | 0 | 27 | | var consulta = ConsultaCompleta().AsNoTracking(); |
| | | 28 | | |
| | 0 | 29 | | if (!string.IsNullOrWhiteSpace(busqueda)) |
| | | 30 | | { |
| | 0 | 31 | | var texto = busqueda.Trim(); |
| | 0 | 32 | | consulta = consulta.Where(c => |
| | 0 | 33 | | c.Persona.Cedula.Contains(texto) || |
| | 0 | 34 | | c.Persona.PrimerNombre.Contains(texto) || |
| | 0 | 35 | | c.Persona.PrimerApellido.Contains(texto) || |
| | 0 | 36 | | (c.Persona.SegundoNombre != null && c.Persona.SegundoNombre.Contains(texto)) || |
| | 0 | 37 | | (c.Persona.SegundoApellido != null && c.Persona.SegundoApellido.Contains(texto))); |
| | | 38 | | } |
| | | 39 | | |
| | 0 | 40 | | if (!string.IsNullOrWhiteSpace(estado)) |
| | 0 | 41 | | consulta = consulta.Where(c => c.Estado == estado); |
| | | 42 | | |
| | 0 | 43 | | var total = await consulta.CountAsync(); |
| | 0 | 44 | | var items = await consulta |
| | 0 | 45 | | .OrderBy(c => c.Persona.PrimerApellido) |
| | 0 | 46 | | .ThenBy(c => c.Persona.PrimerNombre) |
| | 0 | 47 | | .Skip((pagina - 1) * tamano) |
| | 0 | 48 | | .Take(tamano) |
| | 0 | 49 | | .ToListAsync(); |
| | | 50 | | |
| | 0 | 51 | | return (items, total); |
| | 0 | 52 | | } |
| | | 53 | | |
| | | 54 | | public async Task<CompPersonal048018> CrearAsync(CompPersonal048018 entidad) |
| | | 55 | | { |
| | 11 | 56 | | _contexto.CompPersonal048018.Add(entidad); |
| | 11 | 57 | | await _contexto.SaveChangesAsync(); |
| | 11 | 58 | | return entidad; |
| | 11 | 59 | | } |
| | | 60 | | |
| | | 61 | | public async Task<CompPersonal048018> ActualizarAsync(CompPersonal048018 entidad) |
| | | 62 | | { |
| | 7 | 63 | | _contexto.CompPersonal048018.Update(entidad); |
| | 7 | 64 | | await _contexto.SaveChangesAsync(); |
| | 7 | 65 | | return entidad; |
| | 7 | 66 | | } |
| | | 67 | | |
| | | 68 | | private IQueryable<CompPersonal048018> ConsultaCompleta() => |
| | 32 | 69 | | _contexto.CompPersonal048018.Include(c => c.Persona); |
| | | 70 | | } |