public BaseResponse <string> EliminarProvincia(ProvinciaRequest model)
{
BaseResponse <string> result = new BaseResponse <string>();
using (MesaDineroContext context = new MesaDineroContext())
{
using (var transaccion = context.Database.BeginTransaction())
{
try
{
Tb_MD_Provincia prov = context.Tb_MD_Provincia.Find(model.codigo);
if (prov == null)
{
throw new Exception("Entidad Nula, Provincia no encontrado");
}
prov.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 BaseResponse <string> insertNewProvincia(ProvinciaRequest model)
{
BaseResponse <string> result = new BaseResponse <string>();
using (MesaDineroContext context = new MesaDineroContext())
{
using (var transaccion = context.Database.BeginTransaction())
{
try
{
Tb_MD_Provincia prov = new Tb_MD_Provincia();
prov.Nombre = model.nombre;
prov.iEstadoRegistro = model.estado;
context.Tb_MD_Provincia.Add(prov);
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);
}
