public void TestTwoDimensionRangeFromArray() { var range = new MockRange(new[] { "One", "two" }, 1, 1, true); var value = range.Value2; Assert.IsNotNull(value); Assert.IsTrue(typeof(object[, ]) == value.GetType()); Assert.AreEqual(2, range.Count); Assert.AreEqual(1, range.Row); Assert.AreEqual(1, range.Column); Assert.AreEqual(1, range.Rows.Count); Assert.IsTrue(typeof(object[, ]) == range.Rows.Value2.GetType()); Assert.AreEqual(2, range.Columns.Count); Assert.IsTrue(typeof(object[, ]) == range.Columns.Value2.GetType()); Assert.AreEqual(2, range.Cells.Count); var getValue = range.get_Value(XlRangeValueDataType.xlRangeValueDefault); Assert.IsNotNull(getValue); Assert.IsTrue(typeof(object[, ]) == getValue.GetType()); var asObjectArray = (object[, ])getValue; Assert.AreEqual(1, asObjectArray.GetLength(0)); Assert.AreEqual(2, asObjectArray.GetLength(1)); Assert.AreEqual(1, asObjectArray.GetLowerBound(0)); Assert.AreEqual(1, asObjectArray.GetLowerBound(1)); }
public void TestServerPublish() { _receivedMessage = null; var config = new AppConfiguration { MarketDataBrokerUrl = BrokerFactoryTest.Nyws802 }; var temp = AppConfiguration.AssemblyPath; var publisher = new ActiveMQPublisher(config); var testMessageConsumer = StartTestListener(BrokerFactory.Broker(config.MarketDataBrokerUrl), "Test.Topic.Publish"); var publisherResult = publisher.AMQPub("Test.Topic.Publish", "FieldName", "FieldValue"); Assert.IsNotNull(publisherResult); Assert.IsTrue(publisherResult.ToString().StartsWith("Submitted")); WaitFor(HasMessageArrived, this, 10 * 1000); Assert.IsNotNull(_receivedMessage); Assert.AreEqual(true, _receivedMessage.Contains("FieldName")); _receivedMessage = null; var fieldNameRange = new MockRange("FieldName", 1, 1); var fieldValueRange = new MockRange("FieldValueUpdate", 2, 1); publisherResult = publisher.AMQPub("Test.Topic.Publish", fieldNameRange, fieldValueRange); Assert.IsNotNull(publisherResult); Assert.IsTrue(publisherResult.ToString().StartsWith("Submitted")); WaitFor(HasMessageArrived, this, 10 * 1000); Assert.IsNotNull(_receivedMessage); Assert.AreEqual(true, _receivedMessage.Contains("FieldValueUpdate")); var fieldNameRange2 = new MockRange(new[] { "FieldName1", "FieldName2" }, 1, 1, true); var fieldValueRange2 = new MockRange(new[] { "FieldValueUpdate1", "FieldValueUpdate2" }, 1, 1, true); publisherResult = publisher.AMQPub("Test.Topic.Publish", fieldNameRange2, fieldValueRange2); Assert.IsNotNull(publisherResult); Assert.IsTrue(publisherResult.ToString().StartsWith("Submitted")); WaitFor(HasMessageArrived, this, 10 * 1000); Assert.IsNotNull(_receivedMessage); Assert.AreEqual(true, _receivedMessage.Contains("FieldValueUpdate")); StopTestListener(testMessageConsumer); }
public void TestTwoDimensionRangeCreate() { var lengths = new[] { 1, 2 }; var lowerBounds = new[] { 1, 1 }; // create the array in Excel format and convert to what we need var myArray = Array.CreateInstance(typeof(object), lengths, lowerBounds); var value2 = (object[, ])myArray; value2[1, 1] = "one"; value2[1, 2] = "two"; var range = new MockRange(value2, 1, 1); var value = range.Value2; Assert.IsNotNull(value); Assert.IsTrue(typeof(object[, ]) == value.GetType()); Assert.AreEqual(2, range.Count); Assert.AreEqual(1, range.Row); Assert.AreEqual(1, range.Column); Assert.AreEqual(1, range.Rows.Count); Assert.IsTrue(typeof(object[, ]) == range.Rows.Value2.GetType()); Assert.AreEqual(2, range.Columns.Count); Assert.IsTrue(typeof(object[, ]) == range.Columns.Value2.GetType()); Assert.AreEqual(2, range.Cells.Count); var getValue = range.get_Value(XlRangeValueDataType.xlRangeValueDefault); Assert.IsNotNull(getValue); Assert.IsTrue(typeof(object[, ]) == getValue.GetType()); var asObjectArray = (object[, ])getValue; Assert.AreEqual(1, asObjectArray.GetLength(0)); Assert.AreEqual(2, asObjectArray.GetLength(1)); Assert.AreEqual(1, asObjectArray.GetLowerBound(0)); Assert.AreEqual(1, asObjectArray.GetLowerBound(1)); }
public void TestCellRange() { var range = new MockRange("simple_string", 1, 1); var value = range.Value2; Assert.IsNotNull(value); Assert.IsTrue(typeof(string) == value.GetType()); Assert.AreEqual(1, range.Count); Assert.AreEqual(1, range.Row); Assert.AreEqual(1, range.Column); Assert.AreEqual(1, range.Rows.Count); Assert.IsTrue(typeof(string) == range.Rows.Value2.GetType()); Assert.AreEqual(1, range.Columns.Count); Assert.IsTrue(typeof(string) == range.Columns.Value2.GetType()); Assert.AreEqual(1, range.Cells.Count); var getValue = range.get_Value(XlRangeValueDataType.xlRangeValueDefault); Assert.IsNotNull(getValue); Assert.IsTrue(typeof(string) == getValue.GetType()); }