public void deleteDashboardWidget(int id)
{
DBHelper._DashboardWidget dbhelp = new DBHelper._DashboardWidget();
DashboardWidgets existingDashboardWidget = dbhelp.GetByid(id);
dbhelp.Delete(existingDashboardWidget);
}
public int addDashboardWidget(Add dashboardWidget)
{
DBHelper._DashboardWidget dbhelp = new DBHelper._DashboardWidget();
var newDashboardWidget = new DashboardWidgets()
{
DashboardID = dashboardWidget.DashboardId,
WidgetCatalogID = dashboardWidget.WidgetCatalogId,
RowNo = dashboardWidget.RowNo,
ColumnSeq = dashboardWidget.ColumnSeq,
WidthSpace = dashboardWidget.WidthSpace,
HeightPixel = dashboardWidget.HeightPixel
};
return(dbhelp.Add(newDashboardWidget));
}
public List <Detail> getAllDashboardWidgetByDashboardId(int dashboardId)
{
DBHelper._DashboardWidget dbhelp = new DBHelper._DashboardWidget();
return(dbhelp.GetAllByDashboardId(dashboardId).Select(s => new Detail()
{
Id = s.Id,
DashboardId = s.DashboardID,
WidgetCatalogId = s.WidgetCatalogID,
WidgetCatalogName = (s.WidgetCatalog == null ? "" : s.WidgetCatalog.Name),
RowNo = s.RowNo,
ColumnSeq = s.ColumnSeq,
WidthSpace = s.WidthSpace,
HeightPixel = s.HeightPixel
}).ToList <Detail>());
}
public Detail getDashboardWidgetById(int id)
{
DBHelper._DashboardWidget dbhelp = new DBHelper._DashboardWidget();
DashboardWidgets dashboardWidget = dbhelp.GetByid(id);
return(new Detail()
{
Id = dashboardWidget.Id,
DashboardId = dashboardWidget.DashboardID,
WidgetCatalogId = dashboardWidget.WidgetCatalogID,
WidgetCatalogName = (dashboardWidget.WidgetCatalog == null ? "" : dashboardWidget.WidgetCatalog.Name),
RowNo = dashboardWidget.RowNo,
ColumnSeq = dashboardWidget.ColumnSeq,
WidthSpace = dashboardWidget.WidthSpace,
HeightPixel = dashboardWidget.HeightPixel
});
}
public void updateDashboardWidget(Update dashboardWidget)
{
if (dashboardWidget != null && dashboardWidget.Widget != null)
{
DBHelper._DashboardWidget dbhelp = new DBHelper._DashboardWidget();
List <DashboardWidgets> dashboardWidgetList = new List <DashboardWidgets>();
foreach (var widget in dashboardWidget.Widget)
{
DashboardWidgets existingWidget = new DashboardWidgets();
existingWidget.Id = widget.Id;
existingWidget.DashboardID = dashboardWidget.DashboardId;
existingWidget.WidgetCatalogID = widget.WidgetCatalogId;
existingWidget.RowNo = widget.RowNo;
existingWidget.ColumnSeq = widget.ColumnSeq;
existingWidget.WidthSpace = widget.WidthSpace;
existingWidget.HeightPixel = widget.HeightPixel;
dashboardWidgetList.Add(existingWidget);
}
dbhelp.Update(dashboardWidgetList);
}
}
