public void CompleteMessageTest() { this.SubmitRequestWithPropertiesTest(); var manager = new QueueMessageManagerSql(); var item = new QueueMessageItem() { TextInput = "My input", Message = "Getting started." }; manager.CreateItem(item); manager.Properties["Time"] = DateTime.Now; Assert.IsTrue(manager.Save(), manager.ErrorMessage); string reqId = item.Id; manager = new QueueMessageManagerSql(); item = manager.GetNextQueueMessage(); DateTime?time = manager.GetProperty("Time") as DateTime?; Assert.IsNotNull(time); manager.CompleteRequest(item, "Message completed @" + DateTime.Now.ToString("t")); Assert.IsTrue(manager.Save(), manager.ErrorMessage); }
public void LoadRequestWithPropertiesTest() { var manager = new QueueMessageManagerSql(); var db = manager.Db; var item = db.Find <QueueMessageItem>("select TOP 1 * from queueMessageItems where IsComplete = 0 and XmlProperties is not null"); // no pending items - nothing to do if (item == null) { Console.WriteLine("No pending items... nothing to do."); return; } string reqId = item.Id; // clear out item item = null; // load through manager item = manager.Load(reqId); Assert.IsNotNull(item, manager.ErrorMessage); item.Message = "Updated @ " + DateTime.Now.ToString("t"); item.PercentComplete = 10; // Update Properties object t = manager.GetProperty("Time"); DateTime?time3 = t as DateTime?; Assert.IsNotNull(t, "Time Property is null and shouldn't be."); Assert.IsTrue(manager.Save(), manager.ErrorMessage); Console.WriteLine(item.XmlProperties); }
public void CompleteMessageTest() { this.SubmitRequestWithPropertiesTest(); var manager = new QueueMessageManagerSql(); var item = new QueueMessageItem() { TextInput = "My input", Message = "Getting started." }; manager.CreateItem(item); manager.Properties["Time"] = DateTime.Now; Assert.IsTrue(manager.Save(),manager.ErrorMessage); string reqId = item.Id; manager = new QueueMessageManagerSql(); item = manager.GetNextQueueMessage(); DateTime? time = manager.GetProperty("Time") as DateTime?; Assert.IsNotNull(time); manager.CompleteRequest(item,"Message completed @" + DateTime.Now.ToString("t")); Assert.IsTrue(manager.Save(), manager.ErrorMessage); }
public void LoadRequestWithPropertiesTest() { var manager = new QueueMessageManagerSql(); var db = manager.Db; var item = db.Find<QueueMessageItem>("select TOP 1 * from queueMessageItems where IsComplete = 0 and XmlProperties is not null"); // no pending items - nothing to do if (item == null) { Console.WriteLine("No pending items... nothing to do."); return; } string reqId = item.Id; // clear out item item = null; // load through manager item = manager.Load(reqId); Assert.IsNotNull(item, manager.ErrorMessage); item.Message = "Updated @ " + DateTime.Now.ToString("t"); item.PercentComplete = 10; // Update Properties object t = manager.GetProperty("Time"); DateTime? time3 = t as DateTime?; Assert.IsNotNull(t, "Time Property is null and shouldn't be."); Assert.IsTrue(manager.Save(), manager.ErrorMessage); Console.WriteLine(item.XmlProperties); }