private static IResponse ToRssResponse(SelectResult result, string rssUrl, string query, string itemUrlWithoutId)
{
DateTime utcNow = DateTime.UtcNow;
const string outputMimeType = "application/rss+xml; encoding=utf-8";
var resp = new StreamWriterResponse(outputMimeType, async(s) =>
{
SerializationContext context = new SerializationContext(s);
RssWriter w = new RssWriter(context);
ByteBlock queryBB = (ByteBlock)query;
w.WriteRssHeader(queryBB, queryBB, rssUrl, utcNow, TimeSpan.FromHours(1));
ByteBlock baseLink = itemUrlWithoutId;
var items = result.Values;
for (int row = 0; row < items.RowCount; ++row)
{
ByteBlock id = ConvertToByteBlock(items[row, 0]);
w.WriteItem(id, id, id, baseLink, utcNow);
}
w.WriteRssFooter();
context.Writer.Flush();
await s.FlushAsync();
});
return(resp);
}
private static IResponse ToCsvResponse(SelectResult result, string fileName)
{
const string outputMimeType = "text/csv; encoding=utf-8";
var resp = new StreamWriterResponse(outputMimeType, async(s) =>
{
SerializationContext context = new SerializationContext(s);
var items = result.Values;
// ***Crazy Excel Business***
// This is pretty ugly. If the first 2 chars in a CSV file as ID, then excel is thinks the file is a SYLK
// file not a CSV File (!) and will alert the user. Excel does not care about output mime types.
//
// To work around this, and have a _nice_ experience for csv export, we'll modify
// the first column name to " ID" to trick Excel. It's not perfect, but it'll do.
//
// As a mitigation for round-tripping, the CsvReader will trim column names. Sigh.
List <string> columns = new List <string>();
foreach (ColumnDetails column in items.Columns)
{
if (columns.Count == 0 && column.Name.Equals("ID", StringComparison.OrdinalIgnoreCase))
{
columns.Add(" ID");
}
else
{
columns.Add(column.Name);
}
}
CsvWriter writer = new CsvWriter(context, columns);
for (int row = 0; row < items.RowCount; ++row)
{
for (int col = 0; col < items.ColumnCount; ++col)
{
writer.AppendValue(items[row, col]);
}
writer.AppendRowSeparator();
}
context.Writer.Flush();
await s.FlushAsync();
});
resp.AddHeader("Content-Disposition", String.Concat("attachment;filename=\"", fileName, "\";"));
return(resp);
}
