private static void PopulateData(SqadXlsxSheetBuilderBase sheetBuilder, DataColumnCollection columns, IEnumerable <FormattedExcelDataRow> records)
{
foreach (var record in records)
{
var dataRow = record.GetExcelCells(columns);
sheetBuilder.AppendRow(dataRow);
}
}
private static void AppendColumnsAndRows(SqadXlsxSheetBuilderBase sheetBuilder, DataTable dataTable)
{
var columns = dataTable.Columns;
sheetBuilder.AppendColumns(columns);
var records = dataTable.Rows.Cast <DataRow>().Select(x => new ExcelDataRow(x));
foreach (var record in records)
{
var row = record.GetExcelCells(columns);
sheetBuilder.AppendRow(row);
}
}
private void PopulateNames(SqadXlsxSheetBuilderBase sheetBuilder, string exp, string sec, string cellname, List <string> names = null)
{
bool emptycell = false;
foreach (var name in names)
{
List <ExcelCell> row = new List <ExcelCell>();
var cell = new ExcelCell();
cell.CellHeader = exp;
cell.CellValue = (!emptycell) ? cellname : string.Empty;
row.Add(cell);
cell = new ExcelCell();
cell.CellHeader = sec;
cell.CellValue = $"{name}";
row.Add(cell);
sheetBuilder.AppendRow(row);
emptycell = true;
}
}
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);
}
}
