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 static Dashboard_Menu_DTO Dashboard_Menu_DTO_Converter_Table_To_DTO(tblDashboard _tbl_Dashboard)
{
Dashboard_Menu_DTO dashboard_menu = new Dashboard_Menu_DTO();
dashboard_menu.Id = _tbl_Dashboard.Id;
dashboard_menu.Title = _tbl_Dashboard.Title;
dashboard_menu.Parent_Dashboard_Id = _tbl_Dashboard.Parent_Id;
dashboard_menu.Child_Menu = Dashboard_Menu_DTO_Converter_list_Table_To_DTO(_tbl_Dashboard.tblDashboard1.ToList());
dashboard_menu.Dashboard_Type = (DashboardType)Enum.Parse(typeof(DashboardType), _tbl_Dashboard.Dashboard_Type);
return(dashboard_menu);
}
public void Change_Dashboard_Layout(int dashboard_id, int layout_id)
{
try
{
tblDashboard tbl_dashboard = _dbcontext.tblDashboards.Single(dashboard => dashboard.Id == dashboard_id);
tbl_dashboard.Layout_Option = layout_id;
_dbcontext.SaveChanges();
}
catch (Exception ex)
{ }
}
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 static DashboardDTO ConvertDashboardTable_To_DTO(tblDashboard dashboard)
{
DashboardDTO dto_Dashboard = new DashboardDTO();
try
{
dto_Dashboard.Id = dashboard.Id;
dto_Dashboard.Layout_Option = dashboard.Layout_Option;
dto_Dashboard.Is_Deleted = dashboard.Is_Deleted;
dto_Dashboard.Accessibility = (Accessibility_Type)Enums.TryParse(typeof(Accessibility_Type), dashboard.Accessibility.ToString());
dto_Dashboard.Widget_Positions = dashboard.Widget_Positions;
dto_Dashboard.Title = dashboard.Title;
dto_Dashboard.Parent_Id = dashboard.Parent_Id;
dto_Dashboard.Dashboard_Type = (DashboardType)Enum.Parse(typeof(DashboardType), dashboard.Dashboard_Type);
dto_Dashboard.Dashboard_Widgets = Dashboard_Widget_DTO_Convert.Dashboard_Widget_DTO_Convert_List_Table_To_DTO(dashboard.tblDashboard_Widget);
}
catch { }
return(dto_Dashboard);
}
public static tblDashboard ConvertDashboardDTO_To_Table(DashboardDTO dashboard)
{
tblDashboard tbl_Dashboard = new tblDashboard();
tbl_Dashboard.Id = dashboard.Id;
tbl_Dashboard.Layout_Option = dashboard.Layout_Option;
tbl_Dashboard.Is_Deleted = dashboard.Is_Deleted;
if (dashboard.Accessibility == 0)
{
tbl_Dashboard.Accessibility = Accessibility_Type.Private.ToString();
}
else
{
tbl_Dashboard.Accessibility = dashboard.Accessibility.ToString();
}
tbl_Dashboard.Parent_Id = dashboard.Parent_Id;
tbl_Dashboard.Title = dashboard.Title;
tbl_Dashboard.Dashboard_Type = dashboard.Dashboard_Type.ToString();
return(tbl_Dashboard);
}
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);
}
