public ActionResult Delete(IEnumerable <GraphicDataWrapper> models, int type) { foreach (var source in models) { GraphicWrapper.Delete(source.id, type); } return(Json(null)); }
public ActionResult Create(IEnumerable <GraphicDataWrapper> models) { List <GraphicDataWrapper> ss = new List <GraphicDataWrapper>(); foreach (var source in models) { int id = GraphicWrapper.Insert(source); GraphicLokasiSamplingSelect ls = db.lokasi_sampling.Select(p => new GraphicLokasiSamplingSelect { id = p.id, name = p.lokasi_sampling1 }).Where(p => p.id == source.id_lokasi).FirstOrDefault(); GraphicParameterSelect pr = db.graphic_parameter.Select(p => new GraphicParameterSelect { id = p.id, name = p.parameter }).Where(p => p.id == source.id_parameter).FirstOrDefault(); // store the product in the result ss.Add(new GraphicDataWrapper { id = id, lokasi_sampling = ls, id_lokasi = source.id_lokasi, id_parameter = source.id_parameter, date = source.date, hasil_analisis = source.hasil_analisis }); } return(Json(ss.ToList())); }
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)); }