public List<severity> severityGetAll() { List<severity> lstseverity = new List<severity>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "severityGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colSeverityId = dt.Columns["SeverityId"].Ordinal; int colSeverityDescription = dt.Columns["SeverityDescription"].Ordinal; int colSLATimeToResponse = dt.Columns["SLATimeToResponse"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { severity NewEnt = new severity(); NewEnt.SeverityId = Int32.Parse(dt.Rows[i].ItemArray[colSeverityId].ToString()); NewEnt.SeverityDescription = dt.Rows[i].ItemArray[colSeverityDescription].ToString(); NewEnt.SLATimeToResponse = Int32.Parse(dt.Rows[i].ItemArray[colSLATimeToResponse].ToString()); lstseverity.Add(NewEnt); } } return lstseverity; } catch(Exception ex) { throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { severity auxNewSeverity = new severity(); severityBus oSeverity = new severityBus(); bool needRequiredFields = false; int saveType = 0; if (btnNew.Enabled) saveType = 2; if (!btnNew.Enabled) saveType = 1; if (String.IsNullOrEmpty(txtSeverityDescription.Text)) needRequiredFields = true; if (String.IsNullOrEmpty(txtSLATTR.Text)) needRequiredFields = true; if (!needRequiredFields) { auxNewSeverity.SeverityDescription = txtSeverityDescription.Text; auxNewSeverity.SLATimeToResponse = Convert.ToInt32(txtSLATTR.Text); switch (saveType) { case 1: //save if (oSeverity.severityAdd(auxNewSeverity) > 0) { lblMessage.Text = "Datos guardados correctamente!"; clearFields(); activateFields(false, true); btnNew.Enabled = true; gvGetData(); } else lblMessage.Text = "Error al guardar los datos!"; break; case 2: //update auxNewSeverity.SeverityId = Convert.ToInt32(txtSeverityId.Text); if (oSeverity.severityUpdate(auxNewSeverity)) { lblMessage.Text = "Datos actualizados correctamente!"; clearFields(); activateFields(false, true); btnSave.Enabled = false; btnNew.Enabled = true; gvGetData(); } else lblMessage.Text = "Error al guardar los datos!"; break; } } else { lblMessage.Text = "Error, existen campos sin completar!"; } }
public int severityAdd( severity severity) { try { return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "severityAdd", severity.SeverityDescription, severity.SLATimeToResponse); } catch(Exception ex) { throw ex; } }
public severity severityGetById(int SeverityId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "severityGetById", SeverityId).Tables[0]; severity NewEnt = new severity(); if(dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.SeverityId = Int32.Parse(dr["SeverityId"].ToString()); NewEnt.SeverityDescription = dr["SeverityDescription"].ToString(); NewEnt.SLATimeToResponse = Int32.Parse(dr["SLATimeToResponse"].ToString()); } return NewEnt; } catch(Exception ex) { throw ex; } }
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(); } }
protected void btnSearch_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtSearch.Text)) { DataTable dttTasks = new DataTable(); dttTasks.Columns.Add(new DataColumn("taskId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("datetime", System.Type.GetType("System.DateTime"))); dttTasks.Columns.Add(new DataColumn("taskTittle", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("eventsDetectionId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("taskStatusId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("statusDescription", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("userId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("userName", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("serverityId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("sererityDescription", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("SLAStatus", System.Type.GetType("System.String"))); tasks auxtTasks = new tasks(); tasksBus oTasks = new tasksBus(); eventsdetectionBus oEventsDetection = new eventsdetectionBus(); idsBus oIDPS = new idsBus(); eventsalarmBus oEventsAlarm = new eventsalarmBus(); severityBus oSeverity = new severityBus(); taskstatusBus oTaskStatus = new taskstatusBus(); usersBus oUsers = new usersBus(); auxtTasks = oTasks.tasksGetById(Convert.ToInt32(txtSearch.Text)); if (auxtTasks != null) { taskstatus auxStatus = new taskstatus(); users auxUser = new users(); eventsdetection auxEventDetection = new eventsdetection(); eventsalarm auxEventAlarm = new eventsalarm(); severity auxSeverity = new severity(); auxStatus = oTaskStatus.taskstatusGetById(auxtTasks.TaskStatudId); auxUser = oUsers.usersGetById(auxtTasks.UserId); auxEventDetection = oEventsDetection.eventsdetectionGetById(auxtTasks.EventsDetectionId); auxEventAlarm = oEventsAlarm.eventsalarmGetById(auxEventDetection.EventsAlarmId); auxSeverity = oSeverity.severityGetById(auxEventAlarm.Severity); //resolver SLAStatus dttTasks.Rows.Add(auxtTasks.TaskId, auxtTasks.DateTime, auxtTasks.TaskTittle, auxtTasks.EventsDetectionId, auxtTasks.TaskStatudId, auxStatus.TaskStatusDescription, auxtTasks.UserId, auxUser.UserName, auxEventAlarm.Severity, auxSeverity.SeverityDescription, ""); gvTasks.DataSource = dttTasks; gvTasks.DataBind(); } else { lblMessage.Text = "Busqueda sin resultados..."; } } }
private void getTasksData() { DataTable dttTasks = new DataTable(); dttTasks.Columns.Add(new DataColumn("taskId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("datetime", System.Type.GetType("System.DateTime"))); dttTasks.Columns.Add(new DataColumn("taskTittle", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("eventsDetectionId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("taskStatusId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("statusDescription", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("userId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("userName", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("serverityId", System.Type.GetType("System.Int32"))); dttTasks.Columns.Add(new DataColumn("sererityDescription", System.Type.GetType("System.String"))); dttTasks.Columns.Add(new DataColumn("SLAStatus", System.Type.GetType("System.String"))); List<tasks> lstTasks = new List<tasks>(); tasksBus oTasks = new tasksBus(); eventsdetectionBus oEventsDetection = new eventsdetectionBus(); idsBus oIDPS = new idsBus(); eventsalarmBus oEventsAlarm = new eventsalarmBus(); severityBus oSeverity = new severityBus(); taskstatusBus oTaskStatus = new taskstatusBus(); usersBus oUsers = new usersBus(); lstTasks = oTasks.tasksGetAll(); if (lstTasks.Count > 0) { foreach (tasks row in lstTasks) { if (row.TaskStatudId == 2 || row.TaskStatudId == 5) //Closed, Rejected continue; taskstatus auxStatus = new taskstatus(); users auxUser = new users(); eventsdetection auxEventDetection = new eventsdetection(); eventsalarm auxEventAlarm = new eventsalarm(); severity auxSeverity = new severity(); string SLASatus = ""; auxStatus = oTaskStatus.taskstatusGetById(row.TaskStatudId); auxUser = oUsers.usersGetById(row.UserId); auxEventDetection = oEventsDetection.eventsdetectionGetById(row.EventsDetectionId); auxEventAlarm = oEventsAlarm.eventsalarmGetById(auxEventDetection.EventsAlarmId); auxSeverity = oSeverity.severityGetById(auxEventAlarm.Severity); DateTime deadTime = row.DateTime; deadTime.AddMinutes(auxSeverity.SLATimeToResponse); if (DateTime.Now > deadTime) { SLASatus = "Vencido"; } if (DateTime.Now < deadTime) { SLASatus = "En término"; } dttTasks.Rows.Add(row.TaskId, row.DateTime, row.TaskTittle, row.EventsDetectionId, row.TaskStatudId, auxStatus.TaskStatusDescription, row.UserId, auxUser.UserName, auxEventAlarm.Severity, auxSeverity.SeverityDescription, SLASatus); } gvTasks.DataSource = dttTasks; gvTasks.DataBind(); } }
public bool severityUpdate( severity severity) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "severityUpdate", severity.SeverityId, severity.SeverityDescription, severity.SLATimeToResponse); if (update > 0) { return true; } else { return false; } } catch(Exception ex) { throw ex; } }
protected void getEventsDetectionData() { DataTable dttEventsDetection = new DataTable(); dttEventsDetection.Columns.Add(new DataColumn("eventsDetectionId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("datetime", System.Type.GetType("System.DateTime"))); dttEventsDetection.Columns.Add(new DataColumn("eventStauts", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("eventStatusDescription", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("IDSId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("IDPS", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("idsName", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("eventsAlarmId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("severityId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("severityDescription", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("SLATimeToResponse", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("TaskId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("IDPSEventId", System.Type.GetType("System.Int32"))); List<eventsdetection> lstEvetnsDetection = new List<eventsdetection>(); eventsdetectionBus oEventsDetection = new eventsdetectionBus(); idsBus oIDPS = new idsBus(); eventsalarmBus oEventsAlarm = new eventsalarmBus(); severityBus oSeverity = new severityBus(); tasksBus oTask = new tasksBus(); taskstatusBus oTaskStatus = new taskstatusBus(); lstEvetnsDetection = oEventsDetection.eventsdetectionGetAll(); if (lstEvetnsDetection.Count > 0) { foreach (eventsdetection row in lstEvetnsDetection) { if (row.EventStatus == 2 || row.EventStatus == 5) //Closed, Rejected continue; ids auxIDPS = new ids(); eventsalarm auxEventAlarm = new eventsalarm(); severity auxSeverity = new severity(); tasks auxTask = new tasks(); taskstatus auxTaskStatus = new taskstatus(); auxIDPS = oIDPS.idsGetById(row.IdsId); auxEventAlarm = oEventsAlarm.eventsalarmGetById(row.EventsAlarmId); auxSeverity = oSeverity.severityGetById(auxEventAlarm.Severity); auxTask = oTask.tasksGetByEventsDetectionId(row.EventsDetectionId); auxTaskStatus = oTaskStatus.taskstatusGetById(row.EventStatus); dttEventsDetection.Rows.Add(row.EventsDetectionId, row.DateTime, row.EventStatus, auxTaskStatus.TaskStatusDescription, row.IdsId, auxIDPS.IdsIP, auxIDPS.idsName, row.EventsAlarmId, auxSeverity.SeverityId, auxSeverity.SeverityDescription, auxSeverity.SLATimeToResponse, auxTask.TaskId, row.IDPSEventId); } gvEventsDetection.DataSource = dttEventsDetection; gvEventsDetection.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtSearch.Text)) { DataTable dttEventsDetection = new DataTable(); dttEventsDetection.Columns.Add(new DataColumn("eventsDetectionId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("datetime", System.Type.GetType("System.DateTime"))); dttEventsDetection.Columns.Add(new DataColumn("eventStauts", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("eventStatusDescription", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("IDSId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("IDPS", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("idsName", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("eventsAlarmId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("severityId", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("severityDescription", System.Type.GetType("System.String"))); dttEventsDetection.Columns.Add(new DataColumn("SLATimeToResponse", System.Type.GetType("System.Int32"))); dttEventsDetection.Columns.Add(new DataColumn("TaskId", System.Type.GetType("System.Int32"))); eventsdetection auxEvetnsDetection = new eventsdetection(); eventsdetectionBus oEventsDetection = new eventsdetectionBus(); idsBus oIDPS = new idsBus(); eventsalarmBus oEventsAlarm = new eventsalarmBus(); severityBus oSeverity = new severityBus(); tasksBus oTask = new tasksBus(); auxEvetnsDetection = oEventsDetection.eventsdetectionGetById(Convert.ToInt32(txtSearch.Text)); if (auxEvetnsDetection != null) { string strStatus = ""; ids auxIDPS = new ids(); eventsalarm auxEventAlarm = new eventsalarm(); severity auxSeverity = new severity(); tasks auxTask = new tasks(); switch (auxEvetnsDetection.EventStatus) { case 1: strStatus = "Pendiente"; break; case 2: strStatus = "En tratamiento"; break; case 3: strStatus = "Cerrado"; break; } auxIDPS = oIDPS.idsGetById(auxEvetnsDetection.IdsId); auxEventAlarm = oEventsAlarm.eventsalarmGetById(auxEvetnsDetection.EventsAlarmId); auxSeverity = oSeverity.severityGetById(auxEventAlarm.Severity); auxTask = oTask.tasksGetByEventsDetectionId(auxEvetnsDetection.EventsDetectionId); dttEventsDetection.Rows.Add(auxEvetnsDetection.EventsDetectionId, auxEvetnsDetection.DateTime, auxEvetnsDetection.EventStatus, strStatus, auxEvetnsDetection.IdsId, auxIDPS.IdsIP, auxIDPS.idsName, auxEvetnsDetection.EventsAlarmId, auxSeverity.SeverityId, auxSeverity.SeverityDescription, auxSeverity.SLATimeToResponse, auxTask.TaskId); gvEventsDetection.DataSource = dttEventsDetection; gvEventsDetection.DataBind(); } else { lblMessage.Text = "Busqueda sin resultados..."; } } }
public bool severityUpdate(severity severity) { severityImpl oseverityImpl = new severityImpl(); return oseverityImpl.severityUpdate( severity); }
public int severityAdd(severity severity) { severityImpl oseverityImpl = new severityImpl(); return oseverityImpl.severityAdd( severity); }
protected void getTaskData(int taskId) { DataTable dttTask = new DataTable(); dttTask.Columns.Add(new DataColumn("taskId", System.Type.GetType("System.Int32"))); dttTask.Columns.Add(new DataColumn("datetime", System.Type.GetType("System.DateTime"))); dttTask.Columns.Add(new DataColumn("taskTittle", System.Type.GetType("System.String"))); dttTask.Columns.Add(new DataColumn("eventsDetectionId", System.Type.GetType("System.Int32"))); dttTask.Columns.Add(new DataColumn("taskStatusId", System.Type.GetType("System.Int32"))); dttTask.Columns.Add(new DataColumn("statusDescription", System.Type.GetType("System.String"))); dttTask.Columns.Add(new DataColumn("userId", System.Type.GetType("System.Int32"))); dttTask.Columns.Add(new DataColumn("userName", System.Type.GetType("System.String"))); dttTask.Columns.Add(new DataColumn("serverityId", System.Type.GetType("System.Int32"))); dttTask.Columns.Add(new DataColumn("sererityDescription", System.Type.GetType("System.String"))); dttTask.Columns.Add(new DataColumn("SLAStatus", System.Type.GetType("System.String"))); tasks auxtTasks = new tasks(); tasksBus oTasks = new tasksBus(); eventsdetectionBus oEventsDetection = new eventsdetectionBus(); idsBus oIDPS = new idsBus(); eventsalarmBus oEventsAlarm = new eventsalarmBus(); severityBus oSeverity = new severityBus(); taskstatusBus oTaskStatus = new taskstatusBus(); usersBus oUsers = new usersBus(); auxtTasks = oTasks.tasksGetById(taskId); if (auxtTasks != null) { taskstatus auxStatus = new taskstatus(); users auxUser = new users(); eventsdetection auxEventDetection = new eventsdetection(); eventsalarm auxEventAlarm = new eventsalarm(); severity auxSeverity = new severity(); string SLASatus = ""; auxStatus = oTaskStatus.taskstatusGetById(auxtTasks.TaskStatudId); auxUser = oUsers.usersGetById(auxtTasks.UserId); auxEventDetection = oEventsDetection.eventsdetectionGetById(auxtTasks.EventsDetectionId); auxEventAlarm = oEventsAlarm.eventsalarmGetById(auxEventDetection.EventsAlarmId); auxSeverity = oSeverity.severityGetById(auxEventAlarm.Severity); DateTime deadTime = auxtTasks.DateTime; deadTime.AddMinutes(auxSeverity.SLATimeToResponse); if (DateTime.Now > deadTime) { SLASatus = "Vencido"; } if (DateTime.Now < deadTime) { SLASatus = "En término"; } dttTask.Rows.Add(auxtTasks.TaskId, auxtTasks.DateTime, auxtTasks.TaskTittle, auxtTasks.EventsDetectionId, auxtTasks.TaskStatudId, auxStatus.TaskStatusDescription, auxtTasks.UserId, auxUser.UserName, auxEventAlarm.Severity, auxSeverity.SeverityDescription, SLASatus); gvTask.DataSource = dttTask; gvTask.DataBind(); } }