public List <eventsdetection> eventsdetectionGetAll() { List <eventsdetection> lsteventsdetection = new List <eventsdetection>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsdetectionGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colEventsDetectionId = dt.Columns["EventsDetectionId"].Ordinal; int colIdsId = dt.Columns["IdsId"].Ordinal; int colDateTime = dt.Columns["DateTime"].Ordinal; int colEventStatus = dt.Columns["EventStatus"].Ordinal; int colEventsAlarmId = dt.Columns["EventsAlarmId"].Ordinal; int colEventsIDPSEventId = dt.Columns["IDPSEventId"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { eventsdetection NewEnt = new eventsdetection(); NewEnt.EventsDetectionId = Int32.Parse(dt.Rows[i].ItemArray[colEventsDetectionId].ToString()); NewEnt.IdsId = Int32.Parse(dt.Rows[i].ItemArray[colIdsId].ToString()); NewEnt.DateTime = DateTime.Parse(dt.Rows[i].ItemArray[colDateTime].ToString()); NewEnt.EventStatus = Int32.Parse(dt.Rows[i].ItemArray[colEventStatus].ToString()); NewEnt.EventsAlarmId = Int32.Parse(dt.Rows[i].ItemArray[colEventsAlarmId].ToString()); NewEnt.IDPSEventId = Int32.Parse(dt.Rows[i].ItemArray[colEventsIDPSEventId].ToString()); lsteventsdetection.Add(NewEnt); } } return(lsteventsdetection); } catch (Exception ex) { throw ex; } }
public eventsdetection eventsdetectionGetById(int eventsdetectionId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsdetectionGetById", eventsdetectionId).Tables[0]; eventsdetection NewEnt = new eventsdetection(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.EventsDetectionId = Int32.Parse(dr["EventsDetectionId"].ToString()); NewEnt.IdsId = Int32.Parse(dr["IdsId"].ToString()); NewEnt.DateTime = DateTime.Parse(dr["DateTime"].ToString()); NewEnt.EventStatus = Int32.Parse(dr["EventStatus"].ToString()); NewEnt.EventsAlarmId = Int32.Parse(dr["EventsAlarmId"].ToString()); NewEnt.IDPSEventId = Int32.Parse(dr["IDPSEventId"].ToString()); } return(NewEnt); } catch (Exception ex) { throw ex; } }
public bool eventsdetectionUpdate(eventsdetection eventsdetection) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "eventsdetectionUpdate", eventsdetection.EventsDetectionId, eventsdetection.IdsId, eventsdetection.DateTime, eventsdetection.EventStatus, eventsdetection.EventsAlarmId, eventsdetection.IDPSEventId); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public List<eventsdetection> eventsdetectionGetAll() { List<eventsdetection> lsteventsdetection = new List<eventsdetection>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsdetectionGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colEventsDetectionId = dt.Columns["EventsDetectionId"].Ordinal; int colIdsId = dt.Columns["IdsId"].Ordinal; int colDateTime = dt.Columns["DateTime"].Ordinal; int colEventStatus = dt.Columns["EventStatus"].Ordinal; int colEventsAlarmId = dt.Columns["EventsAlarmId"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { eventsdetection NewEnt = new eventsdetection(); NewEnt.EventsDetectionId = Int32.Parse(dt.Rows[i].ItemArray[colEventsDetectionId].ToString()); NewEnt.IdsId = Int32.Parse(dt.Rows[i].ItemArray[colIdsId].ToString()); NewEnt.DateTime = DateTime.Parse(dt.Rows[i].ItemArray[colDateTime].ToString()); NewEnt.EventStatus = Int32.Parse(dt.Rows[i].ItemArray[colEventStatus].ToString()); NewEnt.EventsAlarmId = Int32.Parse(dt.Rows[i].ItemArray[colEventsAlarmId].ToString()); lsteventsdetection.Add(NewEnt); } } return lsteventsdetection; } catch(Exception ex) { throw ex; } }
public int eventsdetectionAdd(eventsdetection eventsdetection) { try { return((int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "eventsdetectionAdd", eventsdetection.IdsId, eventsdetection.DateTime, eventsdetection.EventStatus, eventsdetection.EventsAlarmId)); } catch (Exception ex) { throw ex; } }
public int eventsdetectionAdd(eventsdetection eventsdetection) { try { return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "eventsdetectionAdd", eventsdetection.IdsId, eventsdetection.DateTime, eventsdetection.EventStatus, eventsdetection.EventsAlarmId); } catch(Exception ex) { throw ex; } }
public bool eventsdetectionDelete(eventsdetection eventsdetection) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "eventsdetectionDelete", eventsdetection.EventsDetectionId); if (update > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
public bool eventsdetectionDelete(eventsdetection eventsdetection) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "eventsdetectionDelete", eventsdetection.EventsDetectionId); if (update > 0) { return true; } else { return false; } } catch(Exception ex) { throw ex; } }
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(); } }
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(); } }
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..."; } } }
void tmrChecks_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone(); culture.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd"; culture.DateTimeFormat.LongTimePattern = ""; Thread.CurrentThread.CurrentCulture = culture; DataTable dttResult = new DataTable(); libIDPSWatcherImpl libIDPS = new libIDPSWatcherImpl(); eventsdetectionBus oEventsDetection = new eventsdetectionBus(); tasksBus oTask = new tasksBus(); int newEventDetectionId; int counter; dttResult = libIDPS.getIDPSData(); if (dttResult.Rows.Count > 0) { counter = 0; foreach (DataRow row in dttResult.Rows) { DateTime dateTime = new DateTime(); if (String.IsNullOrEmpty(row[3].ToString())) { dateTime = DateTime.Now; } else { dateTime = DateTime.Parse(row[3].ToString()); } //DateTime.ParseExact(row[3].ToString(), "yyyy/MM/dd", CultureInfo.InvariantCulture); newEventDetectionId = 0; eventsdetection newEventDetection = new eventsdetection(); newEventDetection.IdsId = Convert.ToInt32(row[0].ToString()); newEventDetection.EventsAlarmId = Convert.ToInt32(row[1].ToString()); newEventDetection.IDPSEventId = Convert.ToInt32(row[2].ToString()); newEventDetection.DateTime = dateTime; newEventDetection.EventStatus = 1; newEventDetectionId = oEventsDetection.eventsdetectionAdd(newEventDetection); if (newEventDetectionId > 0) { tasks newTask = new tasks(); newTask.TaskStatudId = 1; newTask.DateTime = dateTime; newTask.UserId = 0; if (row[4].ToString().Length > 49) { newTask.TaskTittle = row[4].ToString().Substring(0, 49); } else { newTask.TaskTittle = row[4].ToString(); } newTask.EventsDetectionId = newEventDetectionId; if (oTask.tasksAdd(newTask) > 0) { counter++; lblCount.Text = counter.ToString(); } } } lblTimeStamp.Text = DateTime.Now.ToString(); } }
public eventsdetection eventsdetectionGetById(int eventsdetectionId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "eventsdetectionGetById", eventsdetectionId).Tables[0]; eventsdetection NewEnt = new eventsdetection(); if(dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.EventsDetectionId = Int32.Parse(dr["EventsDetectionId"].ToString()); NewEnt.IdsId = Int32.Parse(dr["IdsId"].ToString()); NewEnt.DateTime = DateTime.Parse(dr["DateTime"].ToString()); NewEnt.EventStatus = Int32.Parse(dr["EventStatus"].ToString()); NewEnt.EventsAlarmId = Int32.Parse(dr["EventsAlarmId"].ToString()); } return NewEnt; } catch(Exception ex) { throw ex; } }
public bool eventsdetectionUpdate(eventsdetection eventsdetection) { eventsdetectionImpl oeventsdetectionImpl = new eventsdetectionImpl(); return oeventsdetectionImpl.eventsdetectionUpdate( eventsdetection); }
public int eventsdetectionAdd(eventsdetection eventsdetection) { eventsdetectionImpl oeventsdetectionImpl = new eventsdetectionImpl(); return oeventsdetectionImpl.eventsdetectionAdd( eventsdetection); }
public int eventsdetectionAdd(eventsdetection eventsdetection) { eventsdetectionImpl oeventsdetectionImpl = new eventsdetectionImpl(); return(oeventsdetectionImpl.eventsdetectionAdd(eventsdetection)); }
public bool eventsdetectionUpdate(eventsdetection eventsdetection) { eventsdetectionImpl oeventsdetectionImpl = new eventsdetectionImpl(); return(oeventsdetectionImpl.eventsdetectionUpdate(eventsdetection)); }
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..."; } } }