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); }
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()); } }