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 ListContentPuedeSuministrarUnItemTemplate() { // arrange var listContent = ListContentWithRowNumber(); // act listContent.ItemTemplates.Add(typeof(ExcelWriter), "15"); listContent.Write(writer, DatasourceFactory.GetDatasourceList()); // assert this.EndRenderCloseStream(); var sheet = GetSheet(this.filename); for (int i = 0; i < DatasourceFactory.GetDatasourceList().Count; i++) { // en el template en col 5 empieza la serie 1,2,3,4,5 con alineamineto centrado y border THIN sheet.GetRow(i).GetCell(5, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue.Should().Be.EqualTo(1); sheet.GetRow(i).GetCell(6, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue.Should().Be.EqualTo(2); sheet.GetRow(i).GetCell(7, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue.Should().Be.EqualTo(3); sheet.GetRow(i).GetCell(8, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue.Should().Be.EqualTo(4); sheet.GetRow(i).GetCell(9, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue.Should().Be.EqualTo(5); for (var j = 0; j < 5; j++) { sheet.GetRow(i).GetCell(5 + j, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).CellStyle.Alignment. Should().Be.EqualTo(NPOIUserModel.HorizontalAlignment.CENTER); sheet.GetRow(i).GetCell(5 + j, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).CellStyle. BorderBottom.Should().Be.EqualTo(NPOIUserModel.BorderStyle.THIN); sheet.GetRow(i).GetCell(5 + j, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).CellStyle.BorderTop. Should().Be.EqualTo(NPOIUserModel.BorderStyle.THIN); } } }
public void ListContentSiElItemTemplateNoTieneNadaGeneraInvalidOperationException() { // arrange var listContent = ListContentWithRowNumber(); // act listContent.ItemTemplates.Add(typeof(ExcelWriter), "100"); Executing.This(() => listContent.Write(writer, DatasourceFactory.GetDatasourceList())).Should().Throw <InvalidOperationException>(); this.EndRenderCloseStream(); }
public void ListContentCreaUnaNuevaFilaPorCadaItem() { // arrange var listContent = ListContentWith1StaticContent(); var writer = WriterFactory.MockWriter(); // act listContent.Write(writer, DatasourceFactory.GetDatasourceList()); // assert writer.RowCount.Should().Be.EqualTo(3); }
public void ListContentEnElWriteDebeIterarLaLista() { // arrange var listContent = ListContentWith1StaticContent(); var writer = WriterFactory.MockWriter(); // act var datasourceList = DatasourceFactory.GetDatasourceList(); listContent.Write(writer, datasourceList); // assert writer.WriteCount.Should().Be.EqualTo(datasourceList.Count); }
public void ListContentEmpiezaARenderizarDesdeUnaPosicionXY() { // arrange var listContent = ListContentWith1StaticContent(); var writer = WriterFactory.MockWriter(); // act listContent.X = 5; listContent.Y = 2; listContent.Write(writer, DatasourceFactory.GetDatasourceList()); // assert writer.WritedElements.First().X.Should().Be.EqualTo(listContent.X); writer.WritedElements.First().Y.Should().Be.EqualTo(listContent.Y); }
public void ListContentPuedeIterarHorizontalmente() { // arrange var listContent = ListContentWith1StaticContent(); var writer = WriterFactory.MockWriter(); // act listContent.Direction = DirectionEnum.Horinzontal; var datasourceList = DatasourceFactory.GetDatasourceList(); listContent.Write(writer, datasourceList); // assert writer.RowCount.Should().Be.EqualTo(0); writer.WriteCount.Should().Be.EqualTo(datasourceList.Count); }
public void SiElItemTemplateDeListContentTieneCeldasConMergeSeDebeRespetarElMerge() { // arrange var listContent = ListContentWithRowNumber(); // act listContent.ItemTemplates.Add(typeof(ExcelWriter), "15"); listContent.Write(writer, DatasourceFactory.GetDatasourceList()); // assert this.EndRenderCloseStream(); var sheet = GetSheet(this.filename); for (int i = 0; i < DatasourceFactory.GetDatasourceList().Count; i++) { sheet.GetRow(i).GetCell(10, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).NumericCellValue.Should().Be.EqualTo(6); sheet.GetRow(i).GetCell(10).IsMergedCell.Should().Be(true); sheet.GetRow(i).GetCell(11).IsMergedCell.Should().Be(true); } }
public void ListContentEmpiezaARenderizarDesdeUnaPosicionXY() { // arrange var listContent = ListContentWithRowNumber(); // act listContent.X = 5; listContent.Y = 2; listContent.Write(writer, DatasourceFactory.GetDatasourceList()); // assert this.EndRenderCloseStream(); var sheet = GetSheet(this.filename); sheet.GetRow(listContent.Y.Value).GetCell(listContent.X.Value, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).StringCellValue.Should().Be.EqualTo( "1"); sheet.GetRow(listContent.Y.Value + 1).GetCell(listContent.X.Value, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).StringCellValue.Should().Be.EqualTo( "2"); sheet.GetRow(listContent.Y.Value + 2).GetCell(listContent.X.Value, NPOIUserModel.MissingCellPolicy.CREATE_NULL_AS_BLANK).StringCellValue.Should().Be.EqualTo( "3"); }
public void ListContentPuedeRenderizarElNumeroDeItemAIterar() { // arrange var listContent = new ListContent(); listContent.Content.AddContent(new ExpressionContent { Expression = "Context.ItemNumber" }); var writer = WriterFactory.MockWriter(); // act var datasourceList = DatasourceFactory.GetDatasourceList(); listContent.Write(writer, datasourceList); // assert for (int i = 0; i < writer.TextWrited.Count(); i++) { writer.WritedElements.ToArray()[i].Text.Should().Be.EqualTo((i + 1).ToString()); } }
public void ConListAnidadosDebeMantenerElItemNumberDeCadaListaIndependiente() { // arrange var listContentMaster = new ListContent(); listContentMaster.Content.AddContent(new ExpressionContent { Expression = "Context.ItemNumber" }); var listContentChild = new ListContent(); listContentMaster.Content.AddContent(listContentChild); listContentChild.Content.AddContent(new ExpressionContent { Expression = "Context.ItemNumber" }); var datasourceList = DatasourceFactory.GetDatasourceList(); listContentChild.DataSource = datasourceList; var writer = WriterFactory.MockWriter(); // act listContentMaster.Write(writer, datasourceList); // assert int textWritedCounter = 0; for (int i = 0; i < datasourceList.Count; i++) { Console.WriteLine(textWritedCounter.ToString() + ": " + writer.WritedElements.ToArray()[textWritedCounter].Text); writer.WritedElements.ToArray()[textWritedCounter].Text.Should().Be.EqualTo((i + 1).ToString()); textWritedCounter++; for (int j = 0; j < datasourceList.Count; j++) { Console.WriteLine(textWritedCounter.ToString() + ": " + writer.WritedElements.ToArray()[textWritedCounter].Text); writer.WritedElements.ToArray()[textWritedCounter].Text.Should().Be.EqualTo((j + 1).ToString()); textWritedCounter++; } } }