public ActionResult ExportData(int id) { List <GraphicReportWrapper> result = new List <GraphicReportWrapper>(); List <GraphicDataWrapper> results = GraphicWrapper.All(p => p.date, id).OrderBy(p => p.date).ThenBy(p => p.lokasi_sampling.id).ToList(); graphic_type gt = db.graphic_type.Find(id); foreach (GraphicDataWrapper gdw in results) { GraphicReportWrapper rep = new GraphicReportWrapper { date = gdw.date != null?gdw.date.Value.ToShortDateString() : "", lokasi_sampling = gdw.lokasi_sampling.name, graphic_parameter = gdw.graphic_parameter.name, hasil_analisis = (gdw.is_galat == 1 ? "< " : "") + gdw.hasil_analisis }; result.Add(rep); } GridView gv = new GridView(); gv.Caption = "" + gt.name; gv.DataSource = result; if (result.Count == 0) { return(new JavaScriptResult()); } gv.DataBind(); gv.HeaderRow.Cells[0].Text = "Date"; gv.HeaderRow.Cells[1].Text = "Lokasi Sampling"; gv.HeaderRow.Cells[2].Text = "Parameter"; gv.HeaderRow.Cells[3].Text = "Hasil Analisis"; if (gv != null) { return(new DownloadFileActionResult(gv, "Environmental Monitoring for " + gt.name + ".xls")); } else { return(new JavaScriptResult()); } }
public JsonResult Binding(int type) { List <GraphicDataWrapper> result = GraphicWrapper.All(p => p.date, type); return(Json(result)); }