public void ListContentEnExcelGeneraCadaItemEnUnaFila()
{
// arrange
var listContent = new Reporting.ListContent();
var nombreContent = new ExpressionContent();
nombreContent.Expression = "model.Nombre";
listContent.Content.AddContent(nombreContent);
var fechaContent = new ExpressionContent();
fechaContent.Expression = "model.Fecha";
listContent.Content.AddContent(fechaContent);
var datasource = DatasourceFactory.GetDatasourceList();
// act
listContent.Write(writer, datasource);
// assert
this.EndRenderCloseStream();
var sheet = GetSheet(this.filename);
var i = 0;
foreach (var item in datasource)
{
var row = sheet.GetRow(i);
row.Should("cantidad de rows = items").Not.Be.Null();
row.GetCell(0).StringCellValue.Should().Be.EqualTo(item.Nombre);
row.GetCell(1).StringCellValue.Should().Be.EqualTo(item.Fecha.ToString());
i++;
}
}
public void LaExpresionDeExpresionContentPuedeIncluirVariablesDeContextoComoFecha()
{
// arrange
var datasource = DatasourceFactory.GetDatasourceSimpleObject();
var writer = WriterFactory.MockWriter();
// act
var content = new ExpressionContent();
content.Expression = @"Context.Date.ToString(""dd/MM/yyyy"")";
content.Write(writer, datasource);
// assert
writer.LastWritedText.Should().Be.EqualTo(DateTime.Today.ToString("dd/MM/yyyy"));
}
public void HayUnContenidoQueEsUnaExpresionEvaluadaSobreElModelo()
{
// arrange
var datasource = DatasourceFactory.GetDatasourceSimpleObject();
var writer = WriterFactory.MockWriter();
// act
var content = new ExpressionContent();
content.Expression = "model.Nombre";
content.Write(writer, datasource);
// assert
writer.LastWritedText.Should().Be.EqualTo(datasource.Nombre);
}
public static ReportDefinition GetReport()
{
var reportDefinition = new ReportDefinition();
var staticContent = new StaticContent();
staticContent.Text = "pepe";
staticContent.X = 5;
staticContent.Y = 6;
reportDefinition.Contents.AddContent(staticContent);
staticContent = new StaticContent();
staticContent.Text = "pepe 2";
staticContent.X = 7;
staticContent.Y = 3;
reportDefinition.Contents.AddContent(staticContent);
var expressionContent = new ExpressionContent();
expressionContent.Expression = "model.NumeroEntero";
expressionContent.Y = 2;
expressionContent.X = 4;
reportDefinition.Contents.AddContent(expressionContent);
return(reportDefinition);
}
