public void ExportDataExtractToCSV(DataExtractModel model)
{
StringWriter sw = new Utf8StringWriter();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=Exported_Data.csv");
Response.ContentType = "text/csv; charset=utf-8";
string spName = "GetExtract";
if (int.Parse(model.ExtractType) > 3)
{
spName = "GetAnonExtract";
model.ExtractType = (int.Parse(model.ExtractType) - 3).ToString();
}
var result = _dataExtractManager.Get(spName, model.ExtractType, model.DateStart, model.DateEnd);
var rows = (IEnumerable <IDictionary <string, object> >)result.Entity;
if (rows != null)
{
foreach (var row in rows)
{
foreach (var column in row)
{
sw.Write(string.Format("\"{0}\",", column.Key));
}
sw.WriteLine();
break;
}
foreach (var row in rows)
{
foreach (var column in row)
{
if (column.Value != null && typeof(String) == column.Value.GetType())
{
sw.Write(string.Format("\"{0}\",", ((string)column.Value).Replace('’', '\'')));
}
else
{
sw.Write(string.Format("\"{0}\",", column.Value));
}
}
sw.WriteLine();
}
}
else
{
sw.WriteLine("Empty " + result.Success + " " + result.Message);
}
Response.Write(sw.ToString());
Response.End();
}
public RobotsMiddleware(SitemapSettings settings, ILocationHelper locationHelper)
{
var sw = new Utf8StringWriter();
foreach (var item in settings.GetUserAgents())
{
sw.Write("User-agent: {0}\n", item.UserAgent);
foreach (var allow in item.Allows)
{
sw.Write("Allow: {0}\n", allow);
}
foreach (var disallow in item.Disallows)
{
sw.Write("Disallow: {0}\n", disallow);
}
sw.WriteLine();
}
sw.Write("Sitemap: " + locationHelper.GetSitemapUrl(settings.SitemapPath));
Content = sw.ToString();
}
