public async Task <ActionResult <Respuesta> > PostPaises([FromBody] PaisRequest paisRequest)
{
if (!ModelState.IsValid)
{
return(this.BadRequest(new Respuesta
{
EsExitoso = false,
Mensaje = "Modelo incorrecto.",
Resultado = ModelState
}));
}
var user = await this.context.Users.FindAsync("1");
if (user == null)
{
return(BadRequest(new Respuesta
{
EsExitoso = false,
Mensaje = "Usuario Invalido.",
Resultado = null
}));
}
var entity = new Paises
{
CodigoPais = paisRequest.CodigoPais,
NombrePais = paisRequest.NombrePais,
Usuario = user,
};
BaseController.CompletaRegistro(entity, 1, "", user, false);
await this.context.Set <Paises>().AddAsync(entity);
try
{
await this.context.SaveChangesAsync();
}
catch (Exception ee)
{
return(this.BadRequest(new Respuesta
{
EsExitoso = false,
Mensaje = "Registro no grabado, controlar.",
Resultado = null
}));
}
return(Ok(new Respuesta
{
EsExitoso = true,
Mensaje = "",
Resultado = new PaisRespuesta
{
PaisId = entity.Id,
NombrePais = entity.NombrePais,
}
}));
}
public async Task <ActionResult <Respuesta> > PutPaises(int id, [FromBody] PaisRequest paisRequest)
{
var pais = await this.context.Paises.FindAsync(id);
if (pais == null)
{
return(BadRequest(new Respuesta
{
EsExitoso = false,
Mensaje = "Pais no existe.",
Resultado = null
}));
}
var entity = await this.context.Set <Paises>().FindAsync(id);
entity.NombrePais = paisRequest.NombrePais;
this.context.Entry(entity).State = EntityState.Modified;
await this.context.SaveChangesAsync();
return(Ok(new Respuesta
{
EsExitoso = true,
Mensaje = "",
Resultado = new PaisRespuesta
{
PaisId = entity.Id,
NombrePais = entity.NombrePais
}
}));
}
public IHttpActionResult eliminarPais(PaisRequest model)
{
PaisDataAccess _paisDataAccess = new PaisDataAccess();
BaseResponse <string> result = new BaseResponse <string>();
result = _paisDataAccess.EliminarPais(model);
return(Ok(result));
}
private void AlterarPais(Guid id, PaisRequest paisRequest)
{
var pais = _context.Pais.Find(id);
pais = _mapper.Map(paisRequest, pais);
_context.Pais.Update(pais);
_context.SaveChanges();
}
public async Task <IActionResult> PutPaises(int id, [FromBody] PaisRequest paisRequest)
{
var entity = await this.context.Set <Paises>().FindAsync(id);
entity.NombrePais = paisRequest.NombrePais;
this.context.Entry(entity).State = EntityState.Modified;
await this.context.SaveChangesAsync();
return(Ok(entity));
}
private PaisResponse CriarPais(PaisRequest paisResquest)
{
var pais = _mapper.Map <Pais>(paisResquest);
pais.Id = Guid.NewGuid();
_context.Pais.Add(pais);
_context.SaveChanges();
return(_mapper.Map <PaisResponse>(pais));;
}
public BaseResponse <string> insertNewPais(PaisRequest model)
{
BaseResponse <string> result = new BaseResponse <string>();
using (MesaDineroContext context = new MesaDineroContext())
{
using (var transaccion = context.Database.BeginTransaction())
{
try
{
Tb_MD_Pais vpais = context.Tb_MD_Pais.Find(model.codigo);
if (vpais != null)
{
throw new Exception("Codigo ya existente,Ingrese otro codigo");
}
Tb_MD_Pais pais = new Tb_MD_Pais();
pais.IdPais = model.codigo;
pais.Nombre = model.nombre;
pais.iEstadoRegistro = model.estado;
context.Tb_MD_Pais.Add(pais);
context.SaveChanges();
transaccion.Commit();
result.success = true;
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
#region Error EntityFramework
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var fullErrorMessage = string.Join("; ", errorMessages);
result.success = false;
result.error = fullErrorMessage;
transaccion.Rollback();
#endregion
}
catch (Exception ex)
{
result.success = false;
transaccion.Rollback();
result.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
}
}
return(result);
}
public ActionResult Put([FromRoute] Guid id, [FromBody] PaisRequest paisRequest)
{
var response = BuscarPaisPor(id);
if (response == null)
{
return(NotFound());
}
AlterarPais(id, paisRequest);
return(NoContent());
}
public ActionResult Post([FromBody] PaisRequest paisRequest)
{
var error = paisRequest.Errors();
if (error.Any())
{
return(UnprocessableEntity(error));
}
var response = CriarPais(paisRequest);
return(CreatedAtAction(nameof(Get), new { response.Id }, response));
}
public BaseResponse <string> EliminarPais(PaisRequest model)
{
BaseResponse <string> result = new BaseResponse <string>();
using (MesaDineroContext context = new MesaDineroContext())
{
using (var transaccion = context.Database.BeginTransaction())
{
try
{
Tb_MD_Pais pais = context.Tb_MD_Pais.Find(model.codigo);
if (pais == null)
{
throw new Exception("Entidad Nula, Cargo no encontrado");
}
pais.iEstadoRegistro = EstadoRegistroTabla.Eliminado;
context.SaveChanges();
transaccion.Commit();
result.success = true;
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
#region Error EntityFramework
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var fullErrorMessage = string.Join("; ", errorMessages);
result.success = false;
result.error = fullErrorMessage;
transaccion.Rollback();
#endregion
}
catch (Exception ex)
{
result.success = false;
transaccion.Rollback();
result.error = ex.InnerException != null ? ex.InnerException.Message : ex.Message;
}
}
}
return(result);
}
public async Task <IActionResult> PostPaises([FromBody] PaisRequest paisRequest)
{
if (!ModelState.IsValid)
{
return(this.BadRequest(ModelState));
}
var user = await this.context.Users.FindAsync("1");
if (user == null)
{
return(this.BadRequest("Usuario Invalido"));
}
var entity = new Paises
{
CodigoPais = paisRequest.CodigoPais,
NombrePais = paisRequest.NombrePais,
Usuario = user,
};
BaseController.CompletaRegistro(entity, 1, "", user, false);
await this.context.Set <Paises>().AddAsync(entity);
try
{
await this.context.SaveChangesAsync();
}
catch (Exception ee)
{
return(this.BadRequest("Registro no grabado, controlar."));
}
return(Ok(entity));
}
