public List<intrusionevents> intrusioneventsGetAll() { List<intrusionevents> lstintrusionevents = new List<intrusionevents>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "intrusioneventsGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colIntrusionEventsId = dt.Columns["IntrusionEventsId"].Ordinal; int colIntrusionEventDetail = dt.Columns["IntrusionEventDetail"].Ordinal; int colCVEId = dt.Columns["CVEId"].Ordinal; int colCWEId = dt.Columns["CWEId"].Ordinal; int colCAPECId = dt.Columns["CAPECId"].Ordinal; int colOWASPId = dt.Columns["OWASPId"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { intrusionevents NewEnt = new intrusionevents(); NewEnt.IntrusionEventsId = Int32.Parse(dt.Rows[i].ItemArray[colIntrusionEventsId].ToString()); NewEnt.IntrusionEventDetail = dt.Rows[i].ItemArray[colIntrusionEventDetail].ToString(); NewEnt.CVEId = dt.Rows[i].ItemArray[colCVEId].ToString(); NewEnt.CWEId = dt.Rows[i].ItemArray[colCWEId].ToString(); NewEnt.CAPECId = dt.Rows[i].ItemArray[colCAPECId].ToString(); NewEnt.OWASPId = dt.Rows[i].ItemArray[colOWASPId].ToString(); lstintrusionevents.Add(NewEnt); } } return lstintrusionevents; } catch(Exception ex) { throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { intrusionevents auxNewIntrusionEvents = new intrusionevents(); intrusioneventsBus oIntrusionEvents = new intrusioneventsBus(); bool needRequiredFields = false; int saveType = 0; if (btnNew.Enabled) saveType = 2; if (!btnNew.Enabled) saveType = 1; if (String.IsNullOrEmpty(txtIntrusionDetail.Text)) needRequiredFields = true; if ((String.IsNullOrEmpty(txtCVEId.Text)) && (String.IsNullOrEmpty(txtCWEId.Text)) && (String.IsNullOrEmpty(txtCAPECId.Text)) && (String.IsNullOrEmpty(txtOWASPId.Text))) needRequiredFields = true; if (!needRequiredFields) { if (txtIntrusionDetail.Text.Length > 49) auxNewIntrusionEvents.IntrusionEventDetail = txtIntrusionDetail.Text.Substring(0, 49); else auxNewIntrusionEvents.IntrusionEventDetail = txtIntrusionDetail.Text; auxNewIntrusionEvents.CVEId = txtCVEId.Text; auxNewIntrusionEvents.CWEId = txtCWEId.Text; auxNewIntrusionEvents.CAPECId = txtCAPECId.Text; auxNewIntrusionEvents.OWASPId = txtOWASPId.Text; switch (saveType) { case 1: //save if (oIntrusionEvents.intrusioneventsAdd(auxNewIntrusionEvents) > 0) { lblMessage.Text = "Datos guardados correctamente!"; clearFields(); activateFields(false, true); btnNew.Enabled = true; getIntrusionEventsData(); } else lblMessage.Text = "Error al guardar los datos!"; break; case 2: //update auxNewIntrusionEvents.IntrusionEventsId = Convert.ToInt32(txtIntrusionEventId.Text); if (oIntrusionEvents.intrusioneventsUpdate(auxNewIntrusionEvents)) { lblMessage.Text = "Datos actualizados correctamente!"; clearFields(); activateFields(false, true); btnSave.Enabled = false; getIntrusionEventsData(); } else lblMessage.Text = "Error al guardar los datos!"; break; } } }
public int intrusioneventsAdd(intrusionevents intrusionevents) { try { return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "intrusioneventsAdd", intrusionevents.IntrusionEventDetail, intrusionevents.CVEId, intrusionevents.CWEId, intrusionevents.CAPECId, intrusionevents.OWASPId); } catch(Exception ex) { throw ex; } }
protected void gvAlarms_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = gvAlarms.SelectedRow; eventsalarm auxEventsAlarm = new eventsalarm(); eventsalarmBus oEventsAlarm = new eventsalarmBus(); intrusionevents auxIntrusionEvent = new intrusionevents(); List<intrusionevents> lstIntrusionEventsAssigned = new List<intrusionevents>(); intrusioneventsBus oIntrusionEvents = new intrusioneventsBus(); List<eventsalarm_intrusionevents_mapping> lstEventsMapping = new List<eventsalarm_intrusionevents_mapping>(); eventsalarm_intrusionevents_mappingBus oEventsMapping = new eventsalarm_intrusionevents_mappingBus(); try { ddlSeverity.SelectedValue = ((Label)row.FindControl("severity")).Text; } catch { } if ((Label)row.FindControl("eventsAlarmId") != null) { txtEventAlarmId.Text = ((Label)row.FindControl("eventsAlarmId")).Text; } else { txtEventAlarmId.Text = ""; } if ((Label)row.FindControl("eventsAlarmTittle") != null) { txtEventsAlarmTittle.Text = ((Label)row.FindControl("eventsAlarmTittle")).Text; } else { txtEventsAlarmTittle.Text = ""; } if ((Label)row.FindControl("checkFrecuency") != null) { txtCheckFrequency.Text = ((Label)row.FindControl("checkFrecuency")).Text; } else { txtCheckFrequency.Text = ""; } if ((CheckBox)row.FindControl("active") != null) { chkActive.Checked = ((CheckBox)row.FindControl("active")).Checked; } else { chkActive.Checked = false; } auxEventsAlarm = oEventsAlarm.eventsalarmGetById(Convert.ToInt32(txtEventAlarmId.Text)); lstEventsMapping = oEventsMapping.eventsalarm_intrusionevents_mappingGetByEventsAlarmId(Convert.ToInt32(txtEventAlarmId.Text)); if (lstEventsMapping.Count > 0) { foreach (eventsalarm_intrusionevents_mapping rowMapping in lstEventsMapping) { auxIntrusionEvent = oIntrusionEvents.intrusioneventsGetById(rowMapping.IntrusionEventId); lstIntrusionEventsAssigned.Add(auxIntrusionEvent); } gvIntrusionEventsAssigned.DataSource = lstIntrusionEventsAssigned; gvIntrusionEventsAssigned.DataBind(); } ddlIDPS.SelectedValue = auxEventsAlarm.IdsId.ToString(); chkBIA.Items[0].Selected = Convert.ToBoolean(auxEventsAlarm.AffectConfidence); chkBIA.Items[1].Selected = Convert.ToBoolean(auxEventsAlarm.AffectIntegrity); chkBIA.Items[2].Selected = Convert.ToBoolean(auxEventsAlarm.AffectAvailability); getSignatureData(auxEventsAlarm.IdsId); ddlIDPSSignatures.SelectedValue = auxEventsAlarm.IdsSignatureCategoryId.ToString(); activateFields(true, false); btnSave.Enabled = true; }
protected void getEventsAlarmData() { DataTable dttEventsAlarm = new DataTable(); dttEventsAlarm.Columns.Add(new DataColumn("eventsAlarmId", System.Type.GetType("System.Int32"))); dttEventsAlarm.Columns.Add(new DataColumn("eventsAlarmTittle", System.Type.GetType("System.String"))); dttEventsAlarm.Columns.Add(new DataColumn("checkFrecuency", System.Type.GetType("System.Int32"))); dttEventsAlarm.Columns.Add(new DataColumn("serverity", System.Type.GetType("System.Int32"))); dttEventsAlarm.Columns.Add(new DataColumn("severityDescription", System.Type.GetType("System.String"))); dttEventsAlarm.Columns.Add(new DataColumn("SLATimeToResponse", System.Type.GetType("System.Int32"))); dttEventsAlarm.Columns.Add(new DataColumn("active", System.Type.GetType("System.Boolean"))); List<eventsalarm> lstEventsAlarm = new List<eventsalarm>(); eventsalarmBus oEventsAlarm = new eventsalarmBus(); intrusioneventsBus oIntrusionEvents = new intrusioneventsBus(); severityBus oSeverity = new severityBus(); lstEventsAlarm = oEventsAlarm.eventsalarmGetAll(); if (lstEventsAlarm.Count > 0) { foreach (eventsalarm row in lstEventsAlarm) { intrusionevents auxIntrusionEvent = new intrusionevents(); severity auxSeverity = new severity(); auxSeverity = oSeverity.severityGetById(row.Severity); dttEventsAlarm.Rows.Add(row.EventsAlarmId, row.EventsAlarmTittle, row.CheckFrecuency, row.Severity, auxSeverity.SeverityDescription, auxSeverity.SLATimeToResponse, row.Active); } gvAlarms.DataSource = dttEventsAlarm; gvAlarms.DataBind(); } }
public bool intrusioneventsUpdate(intrusionevents intrusionevents) { intrusioneventsImpl ointrusioneventsImpl = new intrusioneventsImpl(); return ointrusioneventsImpl.intrusioneventsUpdate(intrusionevents); }
public int intrusioneventsAdd(intrusionevents intrusionevents) { intrusioneventsImpl ointrusioneventsImpl = new intrusioneventsImpl(); return ointrusioneventsImpl.intrusioneventsAdd(intrusionevents); }
protected void gvEvents_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = gvEvents.SelectedRow; intrusionevents auxIntrusionEvents = new intrusionevents(); intrusioneventsBus oIntrusionEvent = new intrusioneventsBus(); if ((Label)row.FindControl("intrusionEventId") != null) { txtIntrusionEventId.Text = ((Label)row.FindControl("intrusionEventId")).Text; } else { txtIntrusionEventId.Text = ""; } if ((Label)row.FindControl("intrusionEventDetail") != null) { txtIntrusionDetail.Text = ((Label)row.FindControl("intrusionEventDetail")).Text; } else { txtIntrusionDetail.Text = ""; } if ((Label)row.FindControl("CVEId") != null) { txtCVEId.Text = ((Label)row.FindControl("CVEId")).Text; } else { txtCVEId.Text = ""; } if ((Label)row.FindControl("CWEId") != null) { txtCWEId.Text = ((Label)row.FindControl("CWEId")).Text; } else { txtCWEId.Text = ""; } if ((Label)row.FindControl("CAPECId") != null) { txtCAPECId.Text = ((Label)row.FindControl("CAPECId")).Text; } else { txtCAPECId.Text = ""; } if ((Label)row.FindControl("OWASPId") != null) { txtOWASPId.Text = ((Label)row.FindControl("OWASPId")).Text; } else { txtOWASPId.Text = ""; } activateFields(true, false); btnSave.Enabled = true; }
public bool intrusioneventsUpdate(intrusionevents intrusionevents) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "intrusioneventsUpdate", intrusionevents.IntrusionEventsId, intrusionevents.IntrusionEventDetail, intrusionevents.CVEId, intrusionevents.CWEId, intrusionevents.CAPECId, intrusionevents.OWASPId); if (update > 0) { return true; } else { return false; } } catch(Exception ex) { throw ex; } }
public intrusionevents intrusioneventsGetById(int IntrusionEventsId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "intrusioneventsGetById", IntrusionEventsId).Tables[0]; intrusionevents NewEnt = new intrusionevents(); if(dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.IntrusionEventsId = Int32.Parse(dr["IntrusionEventsId"].ToString()); NewEnt.IntrusionEventDetail = dr["IntrusionEventDetail"].ToString(); NewEnt.CVEId = dr["CVEId"].ToString(); NewEnt.CWEId = dr["CWEId"].ToString(); NewEnt.CWEId = dr["CAPECId"].ToString(); NewEnt.CWEId = dr["OWASPId"].ToString(); } return NewEnt; } catch(Exception ex) { throw ex; } }