public void RegistrarInsidencia(ReturnHeader retorno, Operacion op)
        {
            _baseDeDatosServicio.BeginTransaction();

            try
            {
                var sb = new StringBuilder();
                sb.Append(" Update SWIFT_RECEPTION_HEADER");
                sb.Append(" SET ");
                sb.AppendFormat(" IS_POSTED_ERP ={0}", Enums.GetStringValue(SiNo.No));
                sb.AppendFormat(", POSTED_RESPONSE='{0}'", op.Mensaje);
                sb.Append(" , ATTEMPTED_WITH_ERROR = isnull(ATTEMPTED_WITH_ERROR,0) +1");
                sb.AppendFormat(", POSTED_ERP={0}", " GetDate() ");
                sb.Append(" WHERE ");
                sb.AppendFormat(" RECEPTION_HEADER ={0}", retorno.DocEntry);

                _baseDeDatosServicio.ExecuteNonQuery(sb.ToString());

                _baseDeDatosServicio.Commit();
            }
            catch (Exception)
            {
                _baseDeDatosServicio.Rollback();
                throw;
            }
        }
 public void Actualizar(SwiftTxn transaccion)
 {
     //var baseDeDatosServicio = Mvx.Resolve<IBaseDeDatosServicio>();
     _baseDeDatosServicio.BeginTransaction();
     _baseDeDatosServicio.Update(transaccion);
     _baseDeDatosServicio.Commit();
 }
        public Operacion InsertarLogDeTransaccion(string erpTarget, string operationType, string objectName, string message, string docId, string erpReference, int erpPostingAttempts)
        {
            try
            {
                _baseDeDatosServicio.BeginTransaction();
                DbParameter[] parameters =
                {
                    new OAParameter
                    {
                        ParameterName = "@ERP_TARGET",
                        Value         = erpTarget
                    }
                    , new OAParameter
                    {
                        ParameterName = "@OPERATION_TYPE",
                        Value         = operationType
                    }
                    , new OAParameter
                    {
                        ParameterName = "@OBJECT_NAME",
                        Value         = objectName
                    }
                    , new OAParameter
                    {
                        ParameterName = "@MESSAGE",
                        Value         = message
                    }
                    , new OAParameter
                    {
                        ParameterName = "@DOC_ID",
                        Value         = docId
                    }
                    , new OAParameter
                    {
                        ParameterName = "@ERP_REFERENCE",
                        Value         = erpReference
                    }
                    , new OAParameter
                    {
                        ParameterName = "@ERP_POSTING_ATTEMPTS",
                        Value         = erpPostingAttempts
                    }
                };

                var op = _baseDeDatosServicio.ExecuteQuery <Operacion>("SWIFT_SP_INSERT_LOG_INTERFACE", CommandType.StoredProcedure, parameters).ToList()[0];
                _baseDeDatosServicio.Commit();
                return(op);
            }
            catch (Exception e)
            {
                _baseDeDatosServicio.Rollback();
                return(new Operacion
                {
                    Codigo = -1,
                    Mensaje = e.Message,
                    Resultado = ResultadoOperacionTipo.Error
                });
            }
        }