public FileDto ExportToExcelMarketingFactor(ExportMarketingFactorListDto exportMarketingListDto)
{
return(CreateExcelPackage(
exportMarketingListDto.schemeName + ".xlsx",
excelPackage =>
{
var sheet = excelPackage.Workbook.Worksheets.Add("Sheet 1");
var headerCells = sheet.Cells[1, 1];
var headerFont = headerCells.Style.Font;
headerFont.Size = 16;
headerFont.Bold = true;
headerFont.Italic = true;
headerCells.Value = "View Detail Unit";
sheet.DefaultColWidth = 25;
AddHeaders(
sheet,
3,
L("UnitCode"),
L("UnitNo"),
L("Price/m2")
);
AddObjects(
sheet, 4, exportMarketingListDto.unit,
_ => _.unitCode,
_ => _.unitNo,
_ => _.priceM2
);
}
));
}
public FileDto ExportToExcelMarketingFactor(ExportMarketingFactorListDto param)
{
var fileExcel = _marketingFactorExporter.ExportToExcelMarketingFactor(param);
var filePath = Path.Combine(AppFolders.TempFileDownloadFolder, fileExcel.FileToken);
if (!System.IO.File.Exists(filePath))
{
throw new UserFriendlyException(L("RequestedFileDoesNotExists"));
}
var pathExport = ConfigurationManager.AppSettings["marketingFactorExportPath"].ToString();
//retrieve data excel from temporary download folder
var fileBytes = System.IO.File.ReadAllBytes(filePath);
//write excel file to share folder / local folder
File.WriteAllBytes(pathExport + fileExcel.FileName, fileBytes);
return(fileExcel);
}
