public JsonResult ChartSeries(int WidgetID) { DashBoard.Models.Widget result; ApiChart barChart = new ApiChart(); using (var dbContext = new DashBoardDBEntities()) { result = dbContext.Widgets.Where(t => t.WidgetID == WidgetID).FirstOrDefault(); if (result != null) { barChart = JsonConvert.DeserializeObject <ApiChart>(result.WidgetTypeInputParamValues); } } return(Json(new { Data = barChart.series })); }
//get widget details based on widgetID public JsonResult WidgetDetails(int WidgetID) { DashBoard.Models.Widget result; ApiChart barChart = new ApiChart(); DonutChart donutChart = new DonutChart(); using (var dbContext = new DashBoardDBEntities()) { result = dbContext.Widgets.Include(r => r.DataSource).Where(t => t.WidgetID == WidgetID).FirstOrDefault(); if (result != null) { if (result.WidgetTypeID != 4) { barChart = JsonConvert.DeserializeObject <ApiChart>(result.WidgetTypeInputParamValues); var data = new WidgetModel() { DataSourceName = result.DataSource.DataSourceType, ApiChart = barChart, WidgetTypeID = result.WidgetTypeID, WidgetID = WidgetID }; return(Json(new { Data = data })); } else { donutChart = JsonConvert.DeserializeObject <DonutChart>(result.WidgetTypeInputParamValues); var data = new WidgetModel() { DataSourceName = result.DataSource.DataSourceType, DonutChart = donutChart, WidgetTypeID = result.WidgetTypeID, WidgetID = WidgetID }; return(Json(new { Data = data })); } } } return(Json(new { Data = "Data not found" })); }