94 lines
No EOL
2.3 KiB
C#
94 lines
No EOL
2.3 KiB
C#
using Microsoft.EntityFrameworkCore;
|
|
using REC_HUMA.CORE.Entities;
|
|
using REC_HUMA.CORE.Interfaces;
|
|
using REC_HUMA.INFRASTRUCTURE;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace REC_HUMA.INFRASTRUCTURE.Repositories
|
|
{
|
|
public class EstadoCivilRepo : IEstadoCivilRepo
|
|
{
|
|
private readonly RECHUMAContext _Context;
|
|
public EstadoCivilRepo(RECHUMAContext Context)
|
|
{
|
|
_Context = Context;
|
|
}
|
|
|
|
public async Task<IEnumerable<EstadoCivil>> GetEstadoCivils()
|
|
{
|
|
try
|
|
{
|
|
var estadocivils = await _Context.EstadoCivil.AsNoTracking().ToListAsync();
|
|
return estadocivils;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
|
|
throw;
|
|
}
|
|
}
|
|
|
|
public async Task<EstadoCivil> GetEstadoCivil(int IdEstadoCivil)
|
|
{
|
|
try
|
|
{
|
|
var estadocivils = await _Context.EstadoCivil.Where(s => s.IdEstadoCivil == IdEstadoCivil).FirstOrDefaultAsync();
|
|
return estadocivils;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
|
|
throw;
|
|
}
|
|
}
|
|
|
|
public async Task PutEstadoCivil(EstadoCivil estadoCivil)
|
|
{
|
|
try
|
|
{
|
|
_Context.EstadoCivil.Update(estadoCivil);
|
|
await _Context.SaveChangesAsync();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
|
|
throw;
|
|
}
|
|
|
|
}
|
|
|
|
public async Task PostEstadoCivil(EstadoCivil estadoCivil)
|
|
{
|
|
try
|
|
{
|
|
_Context.EstadoCivil.Add(estadoCivil);
|
|
await _Context.SaveChangesAsync();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
|
|
throw;
|
|
}
|
|
}
|
|
|
|
public async Task DeleteEstadoCivil(int IdEstadoCivil)
|
|
{
|
|
try
|
|
{
|
|
var estadocivil = _Context.EstadoCivil.Where(s => s.IdEstadoCivil == IdEstadoCivil).FirstOrDefault();
|
|
_Context.EstadoCivil.Remove(estadocivil);
|
|
await _Context.SaveChangesAsync();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
|
|
throw;
|
|
}
|
|
}
|
|
|
|
}
|
|
} |