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