Esempio n. 1
0
        public void can_run_trigger_logic()
        {
            var msgList =
            SqlConnectionFactory.GetInsertedRecords(new QueryWrapper("server=automation2;database=automation;user=asctracdbo;password=dbo2006",
            "SELECT 0,'','','','',cast(0 as decimal(5,5)),cast(0 as decimal(5,5)),'','','5/5/2005','',''"),

            new ArOpenReceiptsUpdatedMessageMapper());
            var q = new MessageQueue("automation2", "reporting_aropenreceipts");
            var source = new QueueAddress("sql", "triggers");
            q.SendAll(msgList, source);
        }
Esempio n. 2
0
 private static void sendArOpenReceiptsMsgList(IEnumerable<IFlatMessage> msgList)
 {
     var q = new MessageQueue("automation2", "reporting_aropenreceipts");
     var source = new QueueAddress("sql", "triggers");
     var lst = q.SendAll(msgList, source);
     foreach (var i in lst)
     {
         if (i != 0)
             SqlContext.Pipe.Send(((MessageQueueResponseCode)i).Text());
     }
 }