private void CreateRowOfTotalFor(ISheet sheet, ReportTotalForGroupTypeView groupedItems, XSSFWorkbook workbook)
{
sheet.AddMergedRegion(new CellRangeAddress(RowIndex, RowIndex, 0, 1));
var rowTotalFor = sheet.CreateRow(RowIndex);
var cellIndex = 0;
var cellValueTotalFor = groupedItems.TimeTotalFor.DisplayNameTimeActualTotalFor.ToUpper() + groupedItems.GroupByType.GroupByTypeDisplayNameValue?.ToUpper();
CreateCellItem(workbook, rowTotalFor, ref cellIndex, cellValueTotalFor, CreateFontColorAqua(workbook));
if (groupedItems.DisplayNames.DisplayNameDate != null || groupedItems.GroupByTypeId == (int)Constants.ReportsGroupByIds.Date)
{
rowTotalFor.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
rowTotalFor.CreateCell(++cellIndex).SetCellValue(string.Empty);
rowTotalFor.CreateCell(++cellIndex).SetCellValue(string.Empty);
if (groupedItems.DisplayNames.DisplayNameTimeFrom != null)
{
rowTotalFor.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
if (groupedItems.DisplayNames.DisplayNameTimeTo != null)
{
rowTotalFor.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
// 1
var cellValueActTotal = ConvertModelToView.UpdateTimeFormatForValue(groupedItems.TimeTotalFor.TimeActualTotalFor.ToString());
CreateCellItem(workbook, rowTotalFor, ref cellIndex, cellValueActTotal, CreateFontBold(workbook));
// 2
if (groupedItems.DisplayNames.DisplayNameTimeEstimated != null)
{
var cellValueEstTotal = groupedItems.TimeTotalFor.TimeEstimatedTotalFor == 0
? null
: ConvertModelToView.UpdateTimeFormatForValue(groupedItems.TimeTotalFor.TimeEstimatedTotalFor.ToString());
CreateCellItem(workbook, rowTotalFor, ref cellIndex, cellValueEstTotal, CreateFontBold(workbook));
}
if (groupedItems.DisplayNames.DisplayNameNotes != null)
{
rowTotalFor.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
}
private void CreateRowOfTotal(ReportTotalView reportTotalView, ISheet sheet, XSSFWorkbook workbook)
{
var rowTotal = sheet.CreateRow(RowIndex);
var cellIndex = 0;
var cellValueTotal = reportTotalView.TimeTotal.DisplayNameTimeActualTotal.ToUpper();
CreateCellItem(workbook, rowTotal, ref cellIndex, cellValueTotal, CreateFontColorAqua(workbook));
if (reportTotalView.DisplayNames.DisplayNameDate != null || reportTotalView.GroupByTypeId == (int)Constants.ReportsGroupByIds.Date)
{
rowTotal.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
rowTotal.CreateCell(++cellIndex).SetCellValue(string.Empty);
rowTotal.CreateCell(++cellIndex).SetCellValue(string.Empty);
if (reportTotalView.DisplayNames.DisplayNameTimeFrom != null)
{
rowTotal.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
if (reportTotalView.DisplayNames.DisplayNameTimeTo != null)
{
rowTotal.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
// 1
var cellValueActTotal = ConvertModelToView.UpdateTimeFormatForValue(reportTotalView.TimeTotal.TimeActualTotal.ToString());
CreateCellItem(workbook, rowTotal, ref cellIndex, cellValueActTotal, CreateFontBold(workbook));
// 2
if (reportTotalView.DisplayNames.DisplayNameTimeEstimated != null)
{
var cellValueEstTotal = reportTotalView.TimeTotal.TimeEstimatedTotal == 0
? null
: ConvertModelToView.UpdateTimeFormatForValue(reportTotalView.TimeTotal.TimeEstimatedTotal.ToString());
CreateCellItem(workbook, rowTotal, ref cellIndex, cellValueEstTotal, CreateFontBold(workbook));
}
if (reportTotalView.DisplayNames.DisplayNameNotes != null)
{
rowTotal.CreateCell(++cellIndex).SetCellValue(string.Empty);
}
}
private void CreateRowOfItems(ReportTotalView reportTotalView, ReportTotalForGroupTypeView groupedItems, ReportItemsView groupedItem, ISheet sheet, XSSFWorkbook workbook)
{
var rowListOfValues = sheet.CreateRow(RowIndex);
var cellIndex = 0;
if (groupedItems.DisplayNames.DisplayNameDate != null)
{
var cellValue = ConvertModelToView.UpdateDateFormat(groupedItem.Date, reportTotalView.DateFormatId);
CreateCellItem(workbook, rowListOfValues, ref cellIndex, cellValue, CreateDefaultFont(workbook));
}
if (groupedItems.DisplayNames.DisplayNameClient != null)
{
CreateCellItem(workbook, rowListOfValues, ref cellIndex, groupedItem.ClientName, CreateDefaultFont(workbook));
}
if (groupedItems.DisplayNames.DisplayNameProject != null)
{
CreateCellItem(workbook, rowListOfValues, ref cellIndex, groupedItem.ProjectName, CreateDefaultFont(workbook));
}
if (groupedItems.DisplayNames.DisplayNameMember != null)
{
CreateCellItem(workbook, rowListOfValues, ref cellIndex, groupedItem.MemberName, CreateDefaultFont(workbook));
}
CreateCellItem(workbook, rowListOfValues, ref cellIndex, groupedItem.TaskName, CreateDefaultFont(workbook));
// 1
if (groupedItems.DisplayNames.DisplayNameTimeFrom != null)
{
var cellValue = groupedItem.TimeValues.TimeFrom == 0
? null
: ConvertModelToView.UpdateTimeFormatForValue(groupedItem.TimeValues.TimeFrom.ToString());
CreateCellItem(workbook, rowListOfValues, ref cellIndex, cellValue, CreateDefaultFont(workbook));
}
// 2
if (groupedItems.DisplayNames.DisplayNameTimeTo != null)
{
var cellValue = groupedItem.TimeValues.TimeTo == 0
? null
: ConvertModelToView.UpdateTimeFormatForValue(groupedItem.TimeValues.TimeTo.ToString());
CreateCellItem(workbook, rowListOfValues, ref cellIndex, cellValue, CreateDefaultFont(workbook));
}
// 3
var cellActValue = ConvertModelToView.UpdateTimeFormatForValue(groupedItem.TimeValues.TimeActual.ToString());
CreateCellItem(workbook, rowListOfValues, ref cellIndex, cellActValue, CreateDefaultFont(workbook));
// 4
if (groupedItems.DisplayNames.DisplayNameTimeEstimated != null)
{
var cellValue = groupedItem.TimeValues.TimeEstimated == 0
? null
: ConvertModelToView.UpdateTimeFormatForValue(groupedItem.TimeValues.TimeEstimated.ToString());
CreateCellItem(workbook, rowListOfValues, ref cellIndex, cellValue, CreateDefaultFont(workbook));
}
if (groupedItems.DisplayNames.DisplayNameNotes != null)
{
CreateCellItem(workbook, rowListOfValues, ref cellIndex, groupedItem.Notes, CreateDefaultFont(workbook));
}
}
