public JsonResult data(publicDataFromClient dataToSend)
{
string area = dataToSend.areaName;
int year = Convert.ToInt32(dataToSend.year);
var data = (from records in publicModel.context().regional_db
where records.areaName == area &&
records.year == year &&
industries.Contains(records.industryID) &&
records.measureName == "wages"
orderby records.value
select records);
return(Json(data, "application/json"));
}
public FileContentResult downloadData(publicDataFromClient pData)
{
int year = Convert.ToInt32(pData.year);
List <string> industryIDs = new List <string>(industries);
var data = (from records in publicModel.context().data_table
where records.series.area.areaName == pData.areaName &&
records.year == year &&
records.series.measure.measureName == "employment" &&
industryIDs.Contains(records.series.industryID)
orderby records.value
select records).ToList();
string csv = string.Concat(data.Select(result => string.Format("{0},{1},{2}\n", result.series.area.areaName, result.series.industry.industryName, result.value)));
Response.AddHeader("Content-Disposition", "attachment; filename=download.csv");
return(File(new System.Text.UTF8Encoding().GetBytes(csv), "text/csv"));
}
public JsonResult data(publicDataFromClient dataToSend)
{
string area = dataToSend.areaName;
int year = Convert.ToInt32(dataToSend.year);
List <string> industryIDs = new List <string>(industries);
var data = (from records in publicModel.context().regional_db
where records.areaName == dataToSend.areaName &&
records.year == year &&
records.measureName == "employment" &&
industryIDs.Contains(records.industryID)
orderby records.value
select records);
return(Json(data, "application/json"));
//return View(data);
}
