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