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 int eventsdetectionAdd(eventsdetection eventsdetection)
{
try
{
return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "eventsdetectionAdd",
eventsdetection.IdsId,
eventsdetection.DateTime,
eventsdetection.EventStatus,
eventsdetection.EventsAlarmId,
eventsdetection.IDPSEventId);
}
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 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 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;
}
}
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 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);
}
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...";
}
}
}
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();
}
}
