public IHttpActionResult eliminarTipoMoneda(TipoMonedaRequest model)
{
TipoMonedaDataAccess _tipoMonedaDataAccess = new TipoMonedaDataAccess();
BaseResponse <string> result = new BaseResponse <string>();
result = _tipoMonedaDataAccess.EliminarTipoMoneda(model);
return(Ok(result));
}
public BaseResponse <string> insertNewTipoMoneda(TipoMonedaRequest model)
{
BaseResponse <string> result = new BaseResponse <string>();
using (MesaDineroContext context = new MesaDineroContext())
{
using (var transaccion = context.Database.BeginTransaction())
{
try
{
Tb_MD_TipoMoneda tipo = context.Tb_MD_TipoMoneda.Find(model.codigo);
if (tipo != null)
{
throw new Exception("Codigo ya existente,Ingrese otro codigo");
}
Tb_MD_TipoMoneda moneda = new Tb_MD_TipoMoneda();
moneda.vCodMoneda = model.codigo;
moneda.vDesMoneda = model.nombre;
moneda.vSimboloMoneda = model.simbolo;
moneda.dFechaCreacion = DateTime.Now;
moneda.iEstadoRegistro = model.estado;
context.Tb_MD_TipoMoneda.Add(moneda);
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 BaseResponse <string> EliminarTipoMoneda(TipoMonedaRequest model)
{
BaseResponse <string> result = new BaseResponse <string>();
using (MesaDineroContext context = new MesaDineroContext())
{
using (var transaccion = context.Database.BeginTransaction())
{
try
{
Tb_MD_TipoMoneda moneda = context.Tb_MD_TipoMoneda.Find(model.codigo);
if (moneda == null)
{
throw new Exception("Entidad Nula, Tipo Moneda no encontrado");
}
moneda.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);
}
