/// <summary>
/// Export Data to CSV document.
/// </summary>
/// <returns>ExportDataInfo</returns>
public static ExportDataInfo ExportToCsvDocument(QueryResult queryResult)
{
byte[] bytesInStream = CreateCsvDocument(queryResult);
var export = new ExportDataInfo
{
FileStream = bytesInStream
};
return(export);
}
/// <summary>
/// Export to word document.
/// </summary>
/// <param name="dataTable">Data table</param>
/// <returns>ExportInfo</returns>
public static ExportDataInfo ExportToWord(QueryResult queryResult, string reportName)
{
MemoryStream ms = new MemoryStream( );
ms = CreateWordDocument(queryResult, reportName);
//Convert the memory stream to the byte array.
byte[] bytesInStream = new byte[ms.Length];
ms.Position = 0;
ms.Read(bytesInStream, 0, bytesInStream.Length);
ExportDataInfo export = new ExportDataInfo( );
export.FileStream = bytesInStream;
ms.Close( );
return(export);
}
/// <summary>
/// Export Data to Excel document.
/// </summary>
/// <param name="queryResult">The query data.</param>
/// <returns>ExportDataInfo</returns>
public static ExportDataInfo ExportToExcelDocument(QueryResult queryResult)
{
var ms = CreateExcelDocument(queryResult);
// Convert the memory stream to the byte array.
var bytesInStream = new byte[ms.Length];
ms.Position = 0;
ms.Read(bytesInStream, 0, bytesInStream.Length);
var export = new ExportDataInfo
{
FileStream = bytesInStream
};
ms.Close( );
return(export);
}
