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 IList <DashboardDTO> Get_All_Parent_Dashboards(string user_id) { IList <tblDashboard> tbl_dashboards = _dbcontext.AspNetUserDashboards.Where(userdashboard => userdashboard.User_Id == user_id && userdashboard.tblDashboard.Is_Deleted == false && userdashboard.tblDashboard.Dashboard_Type == DashboardType.Folder.ToString()) .Select(user_dashboar => user_dashboar.tblDashboard).ToList(); //.tblDashboards.Where(dashboard => dashboard.Is_Deleted == false && dashboard.Dashboard_Type == DashboardType.Folder.ToString()).ToList(); return(ConvertDashboard.ConvertDashboard_List_Table_To_DTO(tbl_dashboards)); }
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; } }
public int Create_Dashboard(DashboardDTO dashboard, string user_id) { tblDashboard tbl_dashboard = _dbcontext.tblDashboards.Find(dashboard.Id); if (tbl_dashboard == null) { AspNetUserDashboard aspnetuser_dashbaord = new AspNetUserDashboard() { User_Id = user_id }; tbl_dashboard = _dbcontext.tblDashboards.Add(ConvertDashboard.ConvertDashboardDTO_To_Table(dashboard)); tbl_dashboard.AspNetUserDashboards.Add(aspnetuser_dashbaord); } else { tblDashboard tbl_dashboard_new = ConvertDashboard.ConvertDashboardDTO_To_Table(dashboard); _dbcontext.Entry(tbl_dashboard).CurrentValues.SetValues(tbl_dashboard_new); } _dbcontext.SaveChanges(); return(tbl_dashboard.Id); }
/// <summary> /// All dashboards parent_id=null are parent dashboards /// </summary> /// <returns></returns> public IList <DashboardDTO> Get_All_Parent_Dashboards() { IList <tblDashboard> tbl_dashboards = _dbcontext.tblDashboards.Where(dashboard => dashboard.Is_Deleted == false && dashboard.Dashboard_Type == DashboardType.Folder.ToString()).ToList(); return(ConvertDashboard.ConvertDashboard_List_Table_To_DTO(tbl_dashboards)); }
/// <summary> /// Get only child dashboards /// </summary> /// <param name="Is_Deleted"></param> /// <returns></returns> public IList <DashboardDTO> Get_Dashboard_Is_Deleted(bool Is_Deleted) { IList <tblDashboard> tbl_dashboards = _dbcontext.tblDashboards.Where(dashboard => dashboard.Is_Deleted == Is_Deleted && dashboard.Parent_Id != null).ToList(); return(ConvertDashboard.ConvertDashboard_List_Table_To_DTO(tbl_dashboards)); }