public Dashboard_Widget_DTO Get_Dashboard_Widget_By_Id(int Id) { tblDashboard_Widget tbl_dashboard_widget = _dbcontext.tblDashboard_Widget.SingleOrDefault(DashboardWidget => DashboardWidget.Id == Id); if (tbl_dashboard_widget != null) { return(Dashboard_Widget_DTO_Convert.Dashboard_Widget_DTO_Convert_Table_To_DTO(tbl_dashboard_widget)); } else { return(null); } }
public IList <Dashboard_Widget_DTO> Get_Dashboard_Widget_For_Home_Page_By_User_ID(string user_id) { IList <tblDashboard_Widget> tbl_dashboard_widgets = (from dashboardwidget in _dbcontext.tblDashboard_Widget join homepage_widget in _dbcontext.tblHomePage_Widget on dashboardwidget equals homepage_widget.tblDashboard_Widget into dh from homepage_widget in dh.DefaultIfEmpty() where homepage_widget.User_Id == user_id select dashboardwidget).ToList(); foreach (var tbl_dashboard_widget in tbl_dashboard_widgets) { tbl_dashboard_widget.tblHomePage_Widget = tbl_dashboard_widget.tblHomePage_Widget.Where(s => s.User_Id == user_id).ToList(); } return(Dashboard_Widget_DTO_Convert.Dashboard_Widget_DTO_Convert_List_Table_To_DTO(tbl_dashboard_widgets)); }
public IList <Dashboard_Widget_DTO> Get_Dashboard_Widget_By_Dashboard_Id(int Dashboard_Id) { IList <tblDashboard_Widget> tbl_dashboard_widgets = _dbcontext.tblDashboard_Widget.Where(DashboardWidget => DashboardWidget.Dashboard_Id == Dashboard_Id).ToList(); return(Dashboard_Widget_DTO_Convert.Dashboard_Widget_DTO_Convert_List_Table_To_DTO(tbl_dashboard_widgets)); }