public void WriteRow(ExcelWorksheet ws, DiaRelatorioViewModel dia, Cell cell) { ws.Cells[cell.format()].Value = dia.Data; cell.nextColumn(); ws.Cells[cell.format()].Value = dia.Info; if (!WriteWorkDay(ws, dia, cell)) { for (int i = 0; i < 4; i++) //Skip cells { cell.nextColumn(); } } cell.nextColumn(); WriteTimeCell(ws, cell, dia.HorasTrabalhadas); cell.nextColumn(); WriteTimeCell(ws, cell, dia.HorasDevedoras); cell.nextColumn(); WriteTimeCell(ws, cell, dia.HorasExtras); cell.nextColumn(); WriteTimeCell(ws, cell, dia.HorasExtras100); }
private bool WriteWorkDay(ExcelWorksheet ws, DiaRelatorioViewModel dia, Cell cell) { if (dia.DiaRelatorio is IDiaComPonto) { var diaComPonto = (dia.DiaRelatorio as IDiaComPonto); if (diaComPonto.PontoDia is DiaTrabalho) { var diaTrabalho = (diaComPonto.PontoDia as DiaTrabalho); cell.nextColumn(); WriteTimeCell(ws, cell, diaTrabalho.Inicio.ToString()); if (!WriteInterval(ws, diaTrabalho, cell)) { cell.nextColumn();//Skip cell.nextColumn(); } cell.nextColumn(); WriteTimeCell(ws, cell, diaTrabalho.Fim.ToString()); return(true); } } return(false); }