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