public static HSSFWorkbook CycleActeProprietate(CadSysContext context, string[] columnNames, string ruleSet)
{
var wbk = new HSSFWorkbook();
var sheet = wbk.CreateSheet("Sheet 1");
var validator = new ActProprietateValidator(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.ActeProprietate.Include(y => y.TipActProprietate))
{
ExportAct(sheet, columnNames, x, validator, ruleSet);
}
return(wbk);
}
static void ExportAct(ISheet sheet, string[] columnNames, ActProprietate act, ActProprietateValidator validator, string ruleSet)
{
var result = validator.Validate(act, ruleSet: ruleSet);
var excelDTO = new OutputActProprietate();
excelDTO.FromPOCO(act);
var row = sheet.CreateRow(excelDTO.RowIndex);
writeRow(row, columnNames, excelDTO, false, validator.Validate(act, ruleSet: ruleSet));
}
