private void CreatePropertySheet(IXlsxDocumentBuilder document, ActualExport value)
{
string name = "Properties";
//var instructionsDataTable = tables[InstructionsTableName];
var properties = new XlsxExportImport.Base.Builders.SqadXlsxSheetBuilder(name);
properties.ActualRow = true;
document.AppendSheet(properties);
AppendColumnsAndRows(properties, value);
}
private void PopulateSheets(IXlsxDocumentBuilder document, ActualExport export)
{
foreach (var item in export.Sheets)
{
var sheet = new XlsxExportImport.Base.Builders.SqadXlsxSheetBuilder(item.MediaType.Name);
sheet.ExternalActualsLabel = export.ExternalActualsLabel;
sheet.ActualRow = true;
sheet.ColNames = PopulateNameCollection(item);
// get offset
var offset = export.Flights.FirstOrDefault(x => x.MediaTypeID == item.MediaType.Id);
item.SetActualWorksheet(offset.CustomColumnsValues.Count);
FormatWorkSheet(sheet, item, offset.CustomColumnsValues);
PopulateSheetData(export.Flights.Where(x => x.MediaTypeID == item.MediaType.Id).ToList(), sheet, item);
//HideShowMeasureColumns(sheet, item);
document.AppendSheet(sheet);
}
}
private void AppendColumnsAndRows(SqadXlsxSheetBuilderBase sheetBuilder, ActualExport value)
{
var exp = "Export Properties";
var sec = " ";
var excelinfo = new ExcelColumnInfo(exp, null, new ExcelColumnAttribute(), null);
sheetBuilder.AppendColumnHeaderRowItem(excelinfo);
excelinfo = new ExcelColumnInfo(sec, null, new ExcelColumnAttribute(), null);
sheetBuilder.AppendColumnHeaderRowItem(excelinfo);
List <ExcelCell> row = new List <ExcelCell>();
ExcelCell cell = new ExcelCell();
cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = $"Resource Set";
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = $"{value.ResourceName}";
row.Add(cell);
sheetBuilder.AppendRow(row);
cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = $"Client";
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = $"{value.ClientName}";
row.Add(cell);
sheetBuilder.AppendRow(row);
cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = $"From Date";
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = $"{value.Request.FromDate.ToString("dddd, MMMM dd, yyyy")}";
row.Add(cell);
sheetBuilder.AppendRow(row);
cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = $"To Date";
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = $"{value.Request.ToDate.ToString("dddd, MMMM dd, yyyy")}";
row.Add(cell);
sheetBuilder.AppendRow(row);
cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = $"Created By";
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = $"{value.CreatedBy}";
row.Add(cell);
sheetBuilder.AppendRow(row);
cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = $"Created On";
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = $"{value.Request.CreateDate.ToString("dddd, MMMM dd, yyyy HH:mm")}";
row.Add(cell);
sheetBuilder.AppendRow(row);
cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = string.Empty;
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = string.Empty;
row.Add(cell);
sheetBuilder.AppendRow(row);
//PopulateNames(sheetBuilder, exp, sec, "Products", value.Flights.Select(x=>x.ProductName).Distinct().ToList());
PopulateNames(sheetBuilder, exp, sec, "Products", value.ProductNames);
if (value.PlanTypeNames.Any())
{
PopulateNames(sheetBuilder, exp, sec, "Plan Types", value.PlanTypeNames);
}
}
