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; } }