public DashboardDTO Get_Dashboard(int Id, string User_Id)
{
tblDashboard tbl_dashboard = _dbcontext.tblDashboards.SingleOrDefault(dashboard => dashboard.Id == Id && dashboard.Is_Deleted == false);
if (tbl_dashboard != null)
{
tbl_dashboard.tblDashboard_Widget = tbl_dashboard.tblDashboard_Widget.Where(widget => widget.Is_Deleted == false).ToList();
foreach (tblDashboard_Widget dashboard_widget in tbl_dashboard.tblDashboard_Widget)
{
dashboard_widget.tblChart_TreeMap = dashboard_widget.tblChart_TreeMap.Where(bar => bar.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Bar = dashboard_widget.tblChart_Bar.Where(bar => bar.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Donut = dashboard_widget.tblChart_Donut.Where(donut => donut.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Gauge = dashboard_widget.tblChart_Gauge.Where(gauge => gauge.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Heatmap = dashboard_widget.tblChart_Heatmap.Where(heatmap => heatmap.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Pie = dashboard_widget.tblChart_Pie.Where(pie => pie.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Stacked = dashboard_widget.tblChart_Stacked.Where(stacked => stacked.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Line = dashboard_widget.tblChart_Line.Where(line => line.Is_Deleted == false).ToList();
dashboard_widget.tblChart_Counter = dashboard_widget.tblChart_Counter.Where(counter => counter.Is_Deleted == false).ToList();
dashboard_widget.tblHomePage_Widget = dashboard_widget.tblHomePage_Widget.Where(homepagewidget => homepagewidget.User_Id == User_Id).ToList();
}
}
return(ConvertDashboard.ConvertDashboardTable_To_DTO(tbl_dashboard));
}
public DashboardDTO Get_Dashboard_By_Id(int Id)
{
try
{
tblDashboard tbl_dashboard = _dbcontext.tblDashboards.SingleOrDefault(dashboard => dashboard.Id == Id);
if (tbl_dashboard == null)
{
throw new DashboardException(Resources.DashboardException);
}
return(ConvertDashboard.ConvertDashboardTable_To_DTO(tbl_dashboard));
}
catch (Exception ex)
{
throw ex;
}
}
