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); }