public void Remove_Widget_From_Dashboard(long widget_id)
{
try
{
tblDashboard_Widget tbl_dashboard_widget = _dbcontext.tblDashboard_Widget.Single(widget => widget.Id == widget_id);
tbl_dashboard_widget.Is_Deleted = true;
_dbcontext.SaveChanges();
}
catch { }
}
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 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;
}
}
/// <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 static Dashboard_Widget_DTO Dashboard_Widget_DTO_Convert_Table_To_DTO(tblDashboard_Widget dashboard_widget_tbl)
{
Dashboard_Widget_DTO dashboard_widget_dto = new Dashboard_Widget_DTO();
try
{
dashboard_widget_dto.Id = dashboard_widget_tbl.Id;
dashboard_widget_dto.Chart_Type = (ChartType)Enums.TryParse(typeof(ChartType), dashboard_widget_tbl.Chart_Type.ToString());
dashboard_widget_dto.Dashboard_Id = dashboard_widget_tbl.Dashboard_Id;
dashboard_widget_dto.Widget_Title = dashboard_widget_tbl.Widget_Title;
dashboard_widget_dto.Is_Deleted = dashboard_widget_tbl.Is_Deleted;
dashboard_widget_dto.widget_height = dashboard_widget_tbl.widget_height;
dashboard_widget_dto.widget_width = dashboard_widget_tbl.widget_width;
dashboard_widget_dto.widget_x = dashboard_widget_tbl.widget_x;
dashboard_widget_dto.widget_y = dashboard_widget_tbl.widget_y;
//Every widget has only entry in the tblHomePage_Widget, thats why we get only first and default
dashboard_widget_dto.homepage_widgets = HomePage_WidgetDTO_Converter.Convert(dashboard_widget_tbl.tblHomePage_Widget.FirstOrDefault());
if (dashboard_widget_tbl.tblChart_Gauge.Any())
{
dashboard_widget_dto.GaugeDTO = ChartGaugeDTO_Convert.ChartGaugeDTO_Convert_Table_To_DTO(dashboard_widget_tbl.tblChart_Gauge);
}
else if (dashboard_widget_tbl.tblChart_TreeMap.Any())
{
dashboard_widget_dto.TreeMapDTO = ChartTreeMapDTO_Convert.ChartTreeMapDTO_Convert_Table_To_DTO(dashboard_widget_tbl.tblChart_TreeMap);
}
else if (dashboard_widget_tbl.tblChart_Bar.Any())
{
dashboard_widget_dto.BarDTO = ChartBarDTO_Convert.ChartBarDTO_Convert_Table_To_DTO(dashboard_widget_tbl.tblChart_Bar);
}
else if (dashboard_widget_tbl.tblChart_Pie.Any())
{
dashboard_widget_dto.PieDTO = ChartPieDTO_Convert.ChartPieDTO_Convert_Table_DTO(dashboard_widget_tbl.tblChart_Pie);
}
else if (dashboard_widget_tbl.tblChart_Donut.Any())
{
dashboard_widget_dto.DonutDTO = ChartDonutDTO_Convert.ChartDonutDTO_Convert_Table_DTO(dashboard_widget_tbl.tblChart_Donut);
}
else if (dashboard_widget_tbl.tblChart_Stacked.Any())
{
dashboard_widget_dto.StackedDTO = ChartStackedDTO_Convert.ChartStackedDTO_Convert_Table_DTO(dashboard_widget_tbl.tblChart_Stacked);
}
else if (dashboard_widget_tbl.tblChart_Line.Any())
{
dashboard_widget_dto.LineDTO = ChartLineDTO_Convert.ChartLineDTO_Convert_Table_DTO(dashboard_widget_tbl.tblChart_Line);
}
else if (dashboard_widget_tbl.tblChart_Heatmap.Any())
{
dashboard_widget_dto.HeapMapDTO = ChartHeatMapDTO_Convert.ChartHeatMapDTO_Convert_Table_To_DTO(dashboard_widget_tbl.tblChart_Heatmap);
}
else if (dashboard_widget_tbl.tblChart_Counter.Any())
{
dashboard_widget_dto.CounterDTO = ChartCounter_Converter.Convert_Table_To_DTO(dashboard_widget_tbl.tblChart_Counter);
}
}
catch (Exception ex)
{
throw ex;
}
return(dashboard_widget_dto);
}
public static tblDashboard_Widget Dashboard_Widget_DTO_Convert_DTO_To_Table(Dashboard_Widget_DTO dashboard_widget_dto)
{
tblDashboard_Widget tbl_dashboard_widget = new tblDashboard_Widget();
try
{
tbl_dashboard_widget.Id = dashboard_widget_dto.Id;
tbl_dashboard_widget.Chart_Type = dashboard_widget_dto.Chart_Type.ToString();
tbl_dashboard_widget.Dashboard_Id = dashboard_widget_dto.Dashboard_Id;
tbl_dashboard_widget.Widget_Title = dashboard_widget_dto.Widget_Title;
tbl_dashboard_widget.Is_Deleted = dashboard_widget_dto.Is_Deleted;
tbl_dashboard_widget.widget_height = dashboard_widget_dto.widget_height;
tbl_dashboard_widget.widget_width = dashboard_widget_dto.widget_width;
tbl_dashboard_widget.widget_x = dashboard_widget_dto.widget_x;
tbl_dashboard_widget.widget_y = dashboard_widget_dto.widget_y;
if (dashboard_widget_dto.GaugeDTO != null)
{
tbl_dashboard_widget.tblChart_Gauge = ChartGaugeDTO_Convert.ChartGaugeDTO_Convert_DTO_To_Table(dashboard_widget_dto.GaugeDTO);
}
else if (dashboard_widget_dto.TreeMapDTO != null)
{
tbl_dashboard_widget.tblChart_TreeMap = ChartTreeMapDTO_Convert.ChartTreeMapDTO_Convert_DTO_To_Table(dashboard_widget_dto.TreeMapDTO);
}
else if (dashboard_widget_dto.BarDTO != null)
{
tbl_dashboard_widget.tblChart_Bar = ChartBarDTO_Convert.ChartBarDTO_Convert_DTO_To_Table(dashboard_widget_dto.BarDTO);
}
else if (dashboard_widget_dto.PieDTO != null)
{
tbl_dashboard_widget.tblChart_Pie = ChartPieDTO_Convert.ChartPieDTO_Convert_DTO_Table(dashboard_widget_dto.PieDTO);
}
else if (dashboard_widget_dto.DonutDTO != null)
{
tbl_dashboard_widget.tblChart_Donut = ChartDonutDTO_Convert.ChartDonutDTO_Convert_DTO_Table(dashboard_widget_dto.DonutDTO);
}
else if (dashboard_widget_dto.StackedDTO != null)
{
tbl_dashboard_widget.tblChart_Stacked = ChartStackedDTO_Convert.ChartStackedDTO_Convert_DTO_Table(dashboard_widget_dto.StackedDTO);
}
else if (dashboard_widget_dto.LineDTO != null)
{
tbl_dashboard_widget.tblChart_Line = ChartLineDTO_Convert.ChartLineDTO_Convert_DTO_Table(dashboard_widget_dto.LineDTO);
}
else if (dashboard_widget_dto.HeapMapDTO != null)
{
tbl_dashboard_widget.tblChart_Heatmap = ChartHeatMapDTO_Convert.ChartHeatMapDTO_Convert_DTO_To_Table(dashboard_widget_dto.HeapMapDTO);
}
else if (dashboard_widget_dto.CounterDTO != null)
{
tbl_dashboard_widget.tblChart_Counter = ChartCounter_Converter.Convert_DTO_To_Table(dashboard_widget_dto.CounterDTO);
}
}
catch (Exception ex)
{
throw ex;
}
return(tbl_dashboard_widget);
}
/// <summary>
/// This function is used when all chart is_deleted for Dashboard_widget, than we also remove the dashboard widget from dahboard, other wise the black sapce will show
/// </summary>
/// <param name="widget_id"></param>
public void Remove_Widget_From_Dashboard_When_All_Chart_Set_Is_Deleted(long _id, ChartType _chart_type)
{
try
{
tblDashboard_Widget tbl_dashboard_widget = _dbcontext.tblDashboard_Widget.Single(chart => chart.Id == _id);
if (tbl_dashboard_widget != null)
{
switch (_chart_type)
{
case ChartType.Bar:
if (!tbl_dashboard_widget.tblChart_Bar.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.BarFixedPlacement:
if (!tbl_dashboard_widget.tblChart_Bar.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.Gauge:
if (!tbl_dashboard_widget.tblChart_Gauge.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.TreeMap:
if (!tbl_dashboard_widget.tblChart_TreeMap.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.HeatMap:
if (!tbl_dashboard_widget.tblChart_Heatmap.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.Pie:
if (!tbl_dashboard_widget.tblChart_Pie.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.Stacked:
if (!tbl_dashboard_widget.tblChart_Stacked.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.Line:
if (!tbl_dashboard_widget.tblChart_Line.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.Donut:
if (!tbl_dashboard_widget.tblChart_Donut.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
case ChartType.Counter:
if (!tbl_dashboard_widget.tblChart_Counter.Where(chart => chart.Is_Deleted == false).Any())
{
tbl_dashboard_widget.Is_Deleted = true;
}
break;
default:
throw new Exception(string.Format(Resources.Invalid_Chart_Type + " {0}", _chart_type));
}
_dbcontext.SaveChanges();
}
}
catch { }
}
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;
}
}
