public void BuildWithOneRow3Columns()
{
var utils = new DeviceArchiveReportUtils();
var dataSet = new List <Dictionary <string, object> >();
dataSet.Add(CreateRow(new KeyValuePair <string, object>("One", "Row1One"), new KeyValuePair <string, object>("Two", "Row1Two"), new KeyValuePair <string, object>("Three", "Row1Three")));
var result = utils.CreateNormalizedDeviceArchiveResult(dataSet);
Assert.AreEqual(2 + 3, result.Columns.Count());
Assert.AreEqual(result.Columns.ToList()[0].Header, nameof(DeviceArchive.Timestamp));
Assert.AreEqual(result.Columns.ToList()[0].Header, nameof(DeviceArchive.Timestamp));
Assert.AreEqual(result.Columns.ToList()[1].Header, nameof(DeviceArchive.PEMMessageId));
Assert.AreEqual(result.Columns.ToList()[1].Header, nameof(DeviceArchive.PEMMessageId));
Assert.AreEqual(result.Columns.ToList()[2].FieldName, "One");
Assert.AreEqual(result.Columns.ToList()[2].Header, "One");
Assert.AreEqual(result.Columns.ToList()[3].FieldName, "Two");
Assert.AreEqual(result.Columns.ToList()[3].Header, "Two");
Assert.AreEqual(result.Columns.ToList()[4].FieldName, "Three");
Assert.AreEqual(result.Columns.ToList()[4].Header, "Three");
Assert.AreEqual(result.Model.ToList()[0].Count(), 5);
Assert.AreEqual(1, result.Model.Count());
Assert.AreEqual("Row1One", result.Model.ToList()[0][2]);
Assert.AreEqual("Row1Two", result.Model.ToList()[0][3]);
Assert.AreEqual("Row1Three", result.Model.ToList()[0][4]);
}
public void BuildWithEmpty()
{
var utils = new DeviceArchiveReportUtils();
var dataSet = new List <Dictionary <string, object> >();
var result = utils.CreateNormalizedDeviceArchiveResult(dataSet);
Assert.AreEqual(2, result.Columns.Count());
Assert.AreEqual(result.Columns.ToList()[0].Header, nameof(DeviceArchive.Timestamp));
Assert.AreEqual(result.Columns.ToList()[0].Header, nameof(DeviceArchive.Timestamp));
Assert.AreEqual(result.Columns.ToList()[1].Header, nameof(DeviceArchive.PEMMessageId));
Assert.AreEqual(result.Columns.ToList()[1].Header, nameof(DeviceArchive.PEMMessageId));
Assert.AreEqual(0, result.Model.Count());
}
public void BuildWithFourRows5Columns_Uneven()
{
var utils = new DeviceArchiveReportUtils();
var dataSet = new List <Dictionary <string, object> >();
dataSet.Add(CreateRow(new KeyValuePair <string, object>("One", "Row1One"), new KeyValuePair <string, object>("Two", "Row1Two"), new KeyValuePair <string, object>("Three", "Row1Three")));
dataSet.Add(CreateRow(new KeyValuePair <string, object>("One", "Row2One"), new KeyValuePair <string, object>("Two", "Row2Two"), new KeyValuePair <string, object>("Three", "Row2Three")));
dataSet.Add(CreateRow(new KeyValuePair <string, object>("Two", "Row3Two"), new KeyValuePair <string, object>("Three", "Row3Three"), new KeyValuePair <string, object>("Four", "Row3Four")));
dataSet.Add(CreateRow(new KeyValuePair <string, object>("One", "Row4One"), new KeyValuePair <string, object>("Three", "Row4Three"), new KeyValuePair <string, object>("Four", "Row4Four")));
var result = utils.CreateNormalizedDeviceArchiveResult(dataSet);
Assert.AreEqual(4, result.Model.Count());
Assert.AreEqual(2 + 4, result.Columns.Count());
Assert.AreEqual(result.Columns.ToList()[2].FieldName, "One");
Assert.AreEqual(result.Columns.ToList()[2].Header, "One");
Assert.AreEqual(result.Columns.ToList()[3].FieldName, "Two");
Assert.AreEqual(result.Columns.ToList()[3].Header, "Two");
Assert.AreEqual(result.Columns.ToList()[4].FieldName, "Three");
Assert.AreEqual(result.Columns.ToList()[5].Header, "Four");
Assert.AreEqual(result.Columns.ToList()[5].Header, "Four");
Assert.AreEqual("Row1One", result.Model.ToList()[0][2]);
Assert.AreEqual("Row1Two", result.Model.ToList()[0][3]);
Assert.AreEqual("Row1Three", result.Model.ToList()[0][4]);
Assert.IsNull(result.Model.ToList()[0][5]);
Assert.AreEqual("Row2One", result.Model.ToList()[1][2]);
Assert.AreEqual("Row2Two", result.Model.ToList()[1][3]);
Assert.AreEqual("Row2Three", result.Model.ToList()[1][4]);
Assert.IsNull(result.Model.ToList()[1][5]);
Assert.IsNull(result.Model.ToList()[2][2]);
Assert.AreEqual("Row3Two", result.Model.ToList()[2][3]);
Assert.AreEqual("Row3Three", result.Model.ToList()[2][4]);
Assert.AreEqual("Row3Four", result.Model.ToList()[2][5]);
Assert.AreEqual("Row4One", result.Model.ToList()[3][2]);
Assert.IsNull(result.Model.ToList()[3][3]);
Assert.AreEqual("Row4Three", result.Model.ToList()[3][4]);
Assert.AreEqual("Row4Four", result.Model.ToList()[3][5]);
}
public void BuildWithTwoRows3Columns()
{
var utils = new DeviceArchiveReportUtils();
var dataSet = new List <Dictionary <string, object> >();
dataSet.Add(CreateRow(new KeyValuePair <string, object>("One", "Row1One"), new KeyValuePair <string, object>("Two", "Row1Two"), new KeyValuePair <string, object>("Three", "Row1Three")));
dataSet.Add(CreateRow(new KeyValuePair <string, object>("One", "Row2One"), new KeyValuePair <string, object>("Two", "Row2Two"), new KeyValuePair <string, object>("Three", "Row2Three")));
var result = utils.CreateNormalizedDeviceArchiveResult(dataSet);
Assert.AreEqual(2, result.Model.Count());
Assert.AreEqual(2 + 3, result.Columns.Count());
Assert.AreEqual(result.Model.ToList()[0].Count(), 5);
Assert.AreEqual("Row1One", result.Model.ToList()[0][2]);
Assert.AreEqual("Row1Two", result.Model.ToList()[0][3]);
Assert.AreEqual("Row1Three", result.Model.ToList()[0][4]);
Assert.AreEqual(result.Model.ToList()[1].Count(), 5);
Assert.AreEqual("Row2One", result.Model.ToList()[1][2]);
Assert.AreEqual("Row2Two", result.Model.ToList()[1][3]);
Assert.AreEqual("Row2Three", result.Model.ToList()[1][4]);
}