public static HSSFWorkbook CycleParcele(CadSysContext context, string[] columnNames, string ruleSet)
{
var wbk = new HSSFWorkbook();
var sheet = wbk.CreateSheet("Sheet 1");
var validator = new ParcelaValidator(context);
var header = sheet.CreateRow(0);
for (var i = 0; i < columnNames.Length; i++)
{
var cell = header.CreateCell(i);
cell.SetCellValue(columnNames[i]);
}
foreach (var x in context.Parcele.ToList())
{
ExportParcela(sheet, columnNames, x, validator, ruleSet);
}
return(wbk);
}
static void ExportParcela(ISheet sheet, string[] columnNames, Parcela parcela, ParcelaValidator validator, string ruleSet)
{
var result = validator.Validate(parcela, ruleSet: ruleSet);
var excelDTO = new OutputParcela();
excelDTO.FromPOCO(parcela);
var row = sheet.CreateRow(excelDTO.RowIndex);
writeRow(row, columnNames, excelDTO, false, validator.Validate(parcela, ruleSet: ruleSet));
}
