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