protected void getIDPSData() { List<ids> lstIDPS = new List<ids>(); idsBus oIDPS = new idsBus(); lstIDPS = oIDPS.idsGetAll(); if (lstIDPS.Count > 0) { ddlIDPS.DataSource = lstIDPS; ddlIDPS.DataValueField = "idsId"; ddlIDPS.DataTextField = "idsName"; ddlIDPS.DataBind(); } }
protected void generateFunnelChart() { DataTable dttIntrusionByIDPS = new DataTable(); dttIntrusionByIDPS.Columns.Add(new DataColumn("idpsId", System.Type.GetType("System.Int32"))); dttIntrusionByIDPS.Columns.Add(new DataColumn("idpsName", System.Type.GetType("System.String"))); dttIntrusionByIDPS.Columns.Add(new DataColumn("Quantity", System.Type.GetType("System.Int32"))); List<eventsdetection> lstEventsDetection = new List<eventsdetection>(); eventsdetectionBus oEventsDetection = new eventsdetectionBus(); List<ids> lstIDPS = new List<ids>(); idsBus oIDPS = new idsBus(); lstIDPS = oIDPS.idsGetAll(); if (lstIDPS.Count > 0) { foreach (ids rowIDPS in lstIDPS) { int qtyIntrusion = 0; if (Convert.ToBoolean(rowIDPS.Active)) { lstEventsDetection = oEventsDetection.eventsdetectionGetAll(); foreach (eventsdetection rowEvent in lstEventsDetection) { if (rowEvent.IdsId == rowIDPS.IdsId) qtyIntrusion++; } dttIntrusionByIDPS.Rows.Add(rowIDPS.IdsId, rowIDPS.idsName, qtyIntrusion); } } } funnelChart.Legends.Add(new Legend("Leyenda")); funnelChart.Legends["Leyenda"].DockedToChartArea = "ChartArea1"; funnelChart.Legends["Leyenda"].IsDockedInsideChartArea = false; funnelChart.Series["Series1"].Legend = "Leyenda"; funnelChart.Series["Series1"].IsVisibleInLegend = true; funnelChart.Series[0].XValueMember = "idpsName"; funnelChart.Series[0].YValueMembers = "Quantity"; funnelChart.DataSource = dttIntrusionByIDPS; funnelChart.DataBind(); }
protected void getIDPSData() { DataTable dttIDPS = new DataTable(); dttIDPS.Columns.Add(new DataColumn("idsId" , System.Type.GetType("System.Int32"))); dttIDPS.Columns.Add(new DataColumn("idsName" , System.Type.GetType("System.String"))); dttIDPS.Columns.Add(new DataColumn("idsversion" , System.Type.GetType("System.String"))); dttIDPS.Columns.Add(new DataColumn("idsTypeId" , System.Type.GetType("System.Int32"))); dttIDPS.Columns.Add(new DataColumn("idsTypeDesc" , System.Type.GetType("System.String"))); dttIDPS.Columns.Add(new DataColumn("databaseTypeId" , System.Type.GetType("System.Int32"))); dttIDPS.Columns.Add(new DataColumn("databaseTypeDesc", System.Type.GetType("System.String"))); dttIDPS.Columns.Add(new DataColumn("idsIP" , System.Type.GetType("System.String"))); dttIDPS.Columns.Add(new DataColumn("active" , System.Type.GetType("System.Boolean"))); List<ids> lstIDPS = new List<ids>(); idsBus oIDPS = new idsBus(); idstype auxIDPSType = new idstype(); idstypeBus oIDPSType = new idstypeBus(); databasestype auxDatabaseType = new databasestype(); databasestypeBus oDatabaseType = new databasestypeBus(); lstIDPS = oIDPS.idsGetAll(); if (lstIDPS.Count > 0) { foreach (ids row in lstIDPS) { auxIDPSType = oIDPSType.idstypeGetById(row.IdsTypeId); auxDatabaseType = oDatabaseType.databasestypeGetById(row.DatabaseTypeId); dttIDPS.Rows.Add( row.IdsId, row.idsName, row.IdsVersion, row.IdsTypeId, auxIDPSType.IdsTypeName, row.DatabaseTypeId, auxDatabaseType.DatabaseName, row.IdsIP, row.Active); } gvIDPS.DataSource = dttIDPS; gvIDPS.DataBind(); } }