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