public void Test_CSV( ) { string csv = "TestString,TestNumber\nA,1\nB,2\nC,3\nD,4\nE,5\nA,1\nB,2\nC,3\nD,4\nE,5\n,A,1\nB,2\nC,3\nD,4\nE,5\n"; var service = new CsvFileReaderService( ); var settings = new DataFileReaderSettings( ); SampleDataCreator creator = new SampleDataCreator( ); using (Stream stream = SheetTestHelper.GetCsvStream(csv)) { SampleTable table = creator.CreateSample(stream, settings, service); Assert.That(table, Is.Not.Null); Assert.That(table.Columns, Has.Count.EqualTo(2)); Assert.That(table.Rows, Has.Count.EqualTo(10)); SampleColumn column = table.Columns[0]; Assert.That(column.ColumnName, Is.EqualTo("1")); Assert.That(column.Name, Is.EqualTo("TestString")); column = table.Columns[1]; Assert.That(column.ColumnName, Is.EqualTo("2")); Assert.That(column.Name, Is.EqualTo("TestNumber")); SampleRow row = table.Rows[0]; Assert.That(row.Values, Has.Count.EqualTo(2)); Assert.That(row.Values[0], Is.EqualTo("A")); Assert.That(row.Values[1], Is.EqualTo("1")); row = table.Rows[9]; Assert.That(row.Values, Has.Count.EqualTo(2)); Assert.That(row.Values[0], Is.EqualTo("E")); Assert.That(row.Values[1], Is.EqualTo("5")); } }
public void Test_CSV_HeadingBeyondData( ) { string csv = "\n1,2\nA,B"; var service = new CsvFileReaderService( ); var settings = new DataFileReaderSettings( ); settings.FirstDataRowNumber = 2; settings.HeadingRowNumber = 3; SampleDataCreator creator = new SampleDataCreator( ); using (Stream stream = SheetTestHelper.GetCsvStream(csv)) { SampleTable table = creator.CreateSample(stream, settings, service); Assert.That(table, Is.Not.Null); Assert.That(table.Columns, Has.Count.EqualTo(2)); Assert.That(table.Rows, Has.Count.EqualTo(0)); SampleColumn column = table.Columns [0]; Assert.That(column.ColumnName, Is.EqualTo("1")); Assert.That(column.Name, Is.EqualTo("A")); column = table.Columns [1]; Assert.That(column.ColumnName, Is.EqualTo("2")); Assert.That(column.Name, Is.EqualTo("B")); } }
public void Test_Excel_Test4_AdditionalColumnsFromDataRows( ) { var service = new ExcelFileReaderService( ); SampleDataCreator creator = new SampleDataCreator( ); using (Stream stream = SheetTestHelper.GetStream("SampleDataTests.xlsx")) // IMPORTANT: Ensure TestRowNumbers has the right number of rows { var settings = new DataFileReaderSettings( ); settings.SheetId = SheetTestHelper.GetSheetId("SampleDataTests.xlsx", "Test4"); settings.HeadingRowNumber = 3; settings.FirstDataRowNumber = 4; SampleTable table = creator.CreateSample(stream, settings, service); Assert.That(table, Is.Not.Null); Assert.That(table.Columns, Has.Count.EqualTo(4)); Assert.That(table.Rows, Has.Count.EqualTo(2)); Assert.That(table.Columns [0].ColumnName, Is.EqualTo("A")); Assert.That(table.Columns [0].Name, Is.EqualTo("Heading 1")); Assert.That(table.Columns [1].ColumnName, Is.EqualTo("B")); Assert.That(table.Columns [1].Name, Is.EqualTo("Heading 2")); Assert.That(table.Columns [2].ColumnName, Is.EqualTo("C")); Assert.That(table.Columns [2].Name, Is.EqualTo("C")); Assert.That(table.Columns [3].ColumnName, Is.EqualTo("D")); Assert.That(table.Columns [3].Name, Is.EqualTo("D")); } }
static void Main(string[] args) { var connectionFactory = ConnectionFactoryProvider.Get(); var connection = connectionFactory.CreateConnection(); var channel = connection.CreateModel(); var payments = new SampleDataCreator().CreatePayments(20); CreateQueue(channel); Console.WriteLine("-----------------------------------------------------------------------------"); Console.WriteLine(string.Format("|{0,22}|{1,15}|{2,15}|{3,20}|", "Description", "Card Number", "Amount", "Name")); Console.WriteLine("-----------------------------------------------------------------------------"); foreach (var payment in payments) { SendMessage(payment, channel); } Console.WriteLine(); Console.WriteLine("---------------------------------------------------------------------------------"); Console.WriteLine(string.Format("|{0,26}|{1,15}|{2,15}|{3,20}|", "Description", "Card Number", "Amount", "Name")); Console.WriteLine("---------------------------------------------------------------------------------"); ReceiveMessages(channel); }
public void Test_Excel_Test2_NoHeadingRow( ) { var service = new ExcelFileReaderService( ); SampleDataCreator creator = new SampleDataCreator( ); using (Stream stream = SheetTestHelper.GetStream("SampleDataTests.xlsx")) // IMPORTANT: Ensure TestRowNumbers has the right number of rows { var settings = new DataFileReaderSettings( ); settings.SheetId = SheetTestHelper.GetSheetId("SampleDataTests.xlsx", "Test2"); settings.HeadingRowNumber = 0; settings.FirstDataRowNumber = 3; SampleTable table = creator.CreateSample(stream, settings, service); Assert.That(table, Is.Not.Null); Assert.That(table.Columns, Has.Count.EqualTo(3)); Assert.That(table.Rows, Has.Count.EqualTo(2)); SampleColumn column = table.Columns [0]; Assert.That(column.ColumnName, Is.EqualTo("A")); Assert.That(column.Name, Is.EqualTo("A")); column = table.Columns [2]; Assert.That(column.ColumnName, Is.EqualTo("C")); Assert.That(column.Name, Is.EqualTo("C")); SampleRow row = table.Rows [0]; Assert.That(row.Values, Has.Count.EqualTo(3)); Assert.That(row.Values [2], Is.EqualTo("3")); } }
public void Test_CSV_NoData( ) { string csv = ""; var service = new CsvFileReaderService( ); var settings = new DataFileReaderSettings( ); SampleDataCreator creator = new SampleDataCreator( ); using (Stream stream = SheetTestHelper.GetCsvStream(csv)) { SampleTable table = creator.CreateSample(stream, settings, service); Assert.That(table, Is.Not.Null); Assert.That(table.Columns, Has.Count.EqualTo(0)); Assert.That(table.Rows, Has.Count.EqualTo(0)); } }
static void Main(string[] args) { var connectionFactory = ConnectionFactoryProvider.Get(); var connection = connectionFactory.CreateConnection(); var channel = connection.CreateModel(); var dataCreator = new SampleDataCreator(); var payments = dataCreator.CreatePayments(100); var purchaseOrders = dataCreator.CreatePurchaseOrder(100); CreateConnection(channel); var paymentsQueue = new Queue <Payment>(payments); var purchaseOrdersQueue = new Queue <PurchaseOrder>(purchaseOrders); var onOff = true; var count = payments.Count() + purchaseOrders.Count(); Console.WriteLine("---------------------------------------------------------------------------------------------------------------"); Console.WriteLine(string.Format("|{0,25}|{1,20}|{2,20}|{3,20}|{4,20}|", "Description", "Name", "Amount", "Number", "Other")); Console.WriteLine("---------------------------------------------------------------------------------------------------------------"); for (int i = 0; i < count; i++) { if (onOff) { var payment = paymentsQueue.Dequeue(); SendMessage(payment.Serialize(), "CardPayment", channel); Console.WriteLine(string.Format("|{0,25}|{1,20}|{2,20}|{3,20}|", "Payment message sent: ", payment.Name, payment.Amount, payment.CardNumber)); onOff = false; } else { var purchaseOrder = purchaseOrdersQueue.Dequeue(); SendMessage(purchaseOrder.Serialize(), "PurchaseOrder", channel); Console.WriteLine(string.Format("|{0,25}|{1,20}|{2,20}|{3,20}|{4,20}|", "Purchase order sent: ", purchaseOrder.CompanyName, purchaseOrder.Amount, purchaseOrder.PurchaseOrderNumber, purchaseOrder.PaymentDayTerms)); Console.WriteLine("---------------------------------------------------------------------------------------------------------------"); onOff = true; } } }
public MainPage() { InitializeComponent(); CarouselView.ItemsSource = SampleDataCreator.CreateSampleData(100); }
public void Init() { _dataCreator = new SampleDataCreator(); _sampleMaterial = _dataCreator.GetSampleMaterial(); }
public void Init() { _dataConnector = new DataConnector("saf"); _dataCreator = new SampleDataCreator(); }
public void Init() { _repo = new NormRepository("some path"); _dataCreator = new SampleDataCreator(); }