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