public IList <Dashboard_Menu_DTO> Get_Dashboard_Menu_ByID(int?menuID)
{
_dbcontext = new InnonAnalyticsEngineEntities();
IList <tblDashboard> tbl_dashboards = (from e in _dbcontext.tblDashboards
where (menuID.HasValue ? e.Parent_Id == menuID : e.Parent_Id == null) &&
e.Is_Deleted == false
orderby e.Title
select e).ToList();
return(Dashboard_Menu_DTO_Converter.Dashboard_Menu_DTO_Converter_list_Table_To_DTO(tbl_dashboards));
}
public IList <Dashboard_Menu_DTO> Get_Dashboard_Menu_ByID_ByUserId(int?menuID, string user_ID)
{
_dbcontext = new InnonAnalyticsEngineEntities();
IList <tblDashboard> tbl_dashboards = _dbcontext.AspNetUserDashboards.Where(userdashboard => userdashboard.User_Id == user_ID)
.Select(dashboard => dashboard.tblDashboard).ToList();
tbl_dashboards = (from e in tbl_dashboards
where (menuID.HasValue ? e.Parent_Id == menuID : e.Parent_Id == null) &&
e.Is_Deleted == false
orderby e.Title
select e).ToList();
return(Dashboard_Menu_DTO_Converter.Dashboard_Menu_DTO_Converter_list_Table_To_DTO(tbl_dashboards));
}
public IList <Dashboard_Menu_DTO> Get_Dashboard_Menu()
{
IList <tblDashboard> tbl_dashboards = _dbcontext.tblDashboards.Where(dashboard => dashboard.Is_Deleted == false && dashboard.Parent_Id == null).ToList();
return(Dashboard_Menu_DTO_Converter.Dashboard_Menu_DTO_Converter_list_Table_To_DTO(tbl_dashboards));
}
public IList <Dashboard_Menu_DTO> Get_All_Parent_Child_Dashboards_By_User_Id(IEnumerable <string> user_ids)
{
IList <tblDashboard> tbl_dashboards = _dbcontext.AspNetUserDashboards.Where(userdashboard => user_ids.Contains(userdashboard.User_Id)).Select(dashboard => dashboard.tblDashboard).ToList();
return(Dashboard_Menu_DTO_Converter.Dashboard_Menu_DTO_Converter_list_Table_To_DTO(tbl_dashboards));
}