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); } }