public Transaccion GetTransaccionByID(int idTransaccion)
        {
            var transaccion = new Transaccion();
            var result      = _dao.ExecuteQuery($"select * from ttr_transaccion where id_transaccion = {idTransaccion}");

            if (result.Tables[0].Rows.Count > 0)
            {
                DataRow dr = result.Tables[0].Rows[0];
                transaccion = MapearTransaccion(dr);
            }

            return(transaccion);
        }
 public void CancelarOrden(Transaccion transaccion, NovedadFIXDTO concertacion)
 {
     _dao.ExecuteQuery($"update ttr_transaccion set estado = 5 where id_transaccion = {transaccion.ID}");
 }