/// <summary>
/// this method use for to add new tab into the widget, tblDashboard_Widget will not change, only add new chart
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Dashboard_Widget_VM_DTO Get_Dashboard_Widget_By_Id_New_Chart(int widget_Id)
{
tblDashboard_Widget tbl_dashboard_widget = _dbcontext.tblDashboard_Widget.SingleOrDefault(DashboardWidget => DashboardWidget.Id == widget_Id);
if (tbl_dashboard_widget != null)
{
Dashboard_Widget_VM_DTO _dto = Dashboard_Widget_VM_DTO_Convert.Dashboard_Widget_DTO_Convert_Table_To_DTO(tbl_dashboard_widget);
_dto.BarDTO = new ChartBarDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.DonutDTO = new ChartDonutDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.GaugeDTO = new ChartGaugeDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.HeapMapDTO = new ChartHeatMapDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.PieDTO = new ChartPieDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.StackedDTO = new ChartStackedDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.LineDTO = new ChartLineDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.TreeMapDTO = new ChartTreeMapDTO {
Dashboard_Widget_Id = widget_Id
};
_dto.CounterDTO = new ChartCounterDTO {
Dashboard_Widget_Id = widget_Id
};
return(_dto);
}
else
{
return(null);
}
}
public long Edit_Dashboard_Widget(Dashboard_Widget_VM_DTO dashboard_widget)
{
try
{
dashboard_widget = Set_Primary_Key_For_Multi_Metrics(dashboard_widget);
tblDashboard_Widget tbl_dashboard_widget = _dbcontext.tblDashboard_Widget.Find(dashboard_widget.Id);
tblDashboard_Widget tbl_dashboard_widget_new = Dashboard_Widget_VM_DTO_Convert.Dashboard_Widget_DTO_Convert_DTO_To_Table(dashboard_widget);
_dbcontext.Entry(tbl_dashboard_widget).CurrentValues.SetValues(tbl_dashboard_widget_new);
foreach (tblChart_Gauge tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Gauge)
{
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Gauge.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_Bar tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Bar)
{
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Bar.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_TreeMap tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_TreeMap)
{
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_TreeMap.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_Pie tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Pie)
{
foreach (tblChart_Metric tbl_chart_metric in tbl_dashboard_widget_Chart.tblChart_Metric)
{
_dbcontext.Entry(tbl_chart_metric).State = System.Data.Entity.EntityState.Added;
}
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Pie.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_Donut tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Donut)
{
foreach (tblChart_Metric tbl_chart_metric in tbl_dashboard_widget_Chart.tblChart_Metric)
{
_dbcontext.Entry(tbl_chart_metric).State = System.Data.Entity.EntityState.Added;
}
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Donut.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_Stacked tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Stacked)
{
foreach (tblChart_Metric tbl_chart_metric in tbl_dashboard_widget_Chart.tblChart_Metric)
{
_dbcontext.Entry(tbl_chart_metric).State = System.Data.Entity.EntityState.Added;
}
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Stacked.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_Line tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Line)
{
foreach (tblChart_Metric tbl_chart_metric in tbl_dashboard_widget_Chart.tblChart_Metric)
{
_dbcontext.Entry(tbl_chart_metric).State = System.Data.Entity.EntityState.Added;
}
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Line.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_Heatmap tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Heatmap)
{
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Heatmap.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
foreach (tblChart_Counter tbl_dashboard_widget_Chart in tbl_dashboard_widget_new.tblChart_Counter)
{
if (tbl_dashboard_widget_Chart.Id > 0)
{
_dbcontext.tblChart_Counter.Attach(tbl_dashboard_widget_Chart);
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Modified;
}
else
{
_dbcontext.Entry(tbl_dashboard_widget_Chart).State = System.Data.Entity.EntityState.Added;
}
}
_dbcontext.SaveChanges();
return(tbl_dashboard_widget.Id);
}
catch (Exception ex)
{
throw ex;
}
}
public long Add_Dashboard_Widget(Dashboard_Widget_VM_DTO dashboard_widget)
{
try
{
dashboard_widget = Set_Primary_Key_For_Multi_Metrics(dashboard_widget);
tblDashboard_Widget tbl_dashboard_widget = _dbcontext.tblDashboard_Widget.Add(Dashboard_Widget_VM_DTO_Convert.Dashboard_Widget_DTO_Convert_DTO_To_Table(dashboard_widget));
_dbcontext.SaveChanges();
return(tbl_dashboard_widget.Id);
}
catch (Exception ex)
{
throw ex;
}
}
