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