/// <summary>
/// Downloads the selected time series into a single file.
/// </summary>
/// <param name="dataQueryForm">The data query form.</param>
/// <param name="form">Parameters passed to the server.</param>
public void DownloadToSingleFile(DataQueryFormModel dataQueryForm, FormCollection form)
{
HttpContext.Response.Clear();
string fileName = String.Format("data-{0}.csv", DateTime.Now.ToString("yyyy-MMM-dd-HHmmss"));
HttpContext.Response.ContentType = "text/csv";
HttpContext.Response.AddHeader("content-disposition", "filename=" + fileName);
DataQueryRepository.Download(db, dataQueryForm, form);
HttpContext.Response.End();
}
public ActionResult DataQuery(UnparsedDataQueryFormModel unparsedDataQueryForm, string submit, FormCollection form)
{
DateTime startTime = new DateTime();
DateTime endTime = new DateTime();
if (unparsedDataQueryForm.StartTime != null)
{
if (!DateTime.TryParse(unparsedDataQueryForm.StartTime.ToString(), out startTime))
{
ViewData["startTime"] = "Invalid start date!";
return(View(DataQueryRepository.NewDataQueryModel(db)));
}
}
if (unparsedDataQueryForm.EndTime != null)
{
if (!DateTime.TryParse(unparsedDataQueryForm.EndTime.ToString(), out endTime))
{
ViewData["endTime"] = "Invalid end date!";
return(View(DataQueryRepository.NewDataQueryModel(db)));
}
}
DataQueryFormModel dataQueryForm = DataQueryRepository.ParsedDataQueryForm(unparsedDataQueryForm);
ViewData["norecords"] = "No records found.";
switch (submit)
{
case "Query":
return(View(DataQueryRepository.NewDataQueryModel(db, dataQueryForm)));
break;
case "Download":
DownloadToSingleFile(dataQueryForm, form);
return(View("Download"));
break;
}
return(View(DataQueryRepository.NewDataQueryModel(db)));
}
