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...";
}
}
}
protected void gvTaskDetails_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = gvTaskDetails.SelectedRow;
tasks auxTask = new tasks();
tasksBus oTask = new tasksBus();
if ((Label)row.FindControl("taskDetailsId") != null) { txtTaskDetailId.Text = ((Label)row.FindControl("taskDetailsId")).Text; } else { txtTaskDetailId.Text = ""; }
if ((Label)row.FindControl("datetime") != null) { txtDateTime.Text = ((Label)row.FindControl("datetime")).Text; } else { txtDateTime.Text = ""; }
if ((Label)row.FindControl("effortHours") != null) { txtEffortHours.Text = ((Label)row.FindControl("effortHours")).Text; } else { txtEffortHours.Text = ""; }
if ((Label)row.FindControl("taskDetails") != null) { txtDetail.Text = ((Label)row.FindControl("taskDetails")).Text; } else { txtDetail.Text = ""; }
if ((Label)row.FindControl("taskId") != null) { txtTaskId.Text = ((Label)row.FindControl("taskId")).Text; } else { txtTaskId.Text = ""; }
try
{
auxTask = oTask.tasksGetById(Convert.ToInt32(txtTaskId.Text));
ddlTaskStatus.SelectedValue = auxTask.TaskStatudId.ToString();
ddlUsers.SelectedValue = auxTask.UserId.ToString();
hfTaskStatusOrigin.Value = auxTask.TaskStatudId.ToString();
hfUserOrigin.Value = auxTask.UserId.ToString();
}
catch
{
}
activateFields(true, false);
btnSave.Enabled = true;
}
protected void btnSave_Click(object sender, EventArgs e)
{
CultureInfo culture = (CultureInfo)CultureInfo.CurrentCulture.Clone();
culture.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd";
culture.DateTimeFormat.LongTimePattern = "";
Thread.CurrentThread.CurrentCulture = culture;
taskdetails auxNewTaskDetail = new taskdetails();
taskdetailsBus oTaskDetail = new taskdetailsBus();
tasks auxTasks = new tasks();
tasksBus oTasks = new tasksBus();
users auxUser = new users();
usersBus oUser = new usersBus();
eventsdetectionBus oEventsDetection = new eventsdetectionBus();
bool needRequiredFields = false;
int saveType = 0;
if (btnNew.Enabled) saveType = 2;
if (!btnNew.Enabled) saveType = 1;
if (String.IsNullOrEmpty(txtDateTime.Text)) needRequiredFields = true;
if (String.IsNullOrEmpty(txtEffortHours.Text)) needRequiredFields = true;
if (String.IsNullOrEmpty(txtDetail.Text)) needRequiredFields = true;
if (String.IsNullOrEmpty(txtTaskId.Text)) needRequiredFields = true;
if (!needRequiredFields)
{
auxUser = oUser.usersGetByUserName(HttpContext.Current.User.Identity.Name);
DateTime dateTime = DateTime.ParseExact(txtDateTime.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
auxNewTaskDetail.DateTime = dateTime;
auxNewTaskDetail.EffortHours = Convert.ToDecimal(txtEffortHours.Text);
auxNewTaskDetail.Details = txtDetail.Text;
auxNewTaskDetail.TaskId = Convert.ToInt32(txtTaskId.Text);
auxNewTaskDetail.UserId = Convert.ToInt32(ddlUsers.SelectedValue);
int auxTaskStatus = Convert.ToInt32(ddlTaskStatus.SelectedValue);
int auxUserAssigned = Convert.ToInt32(ddlUsers.SelectedValue);
switch (saveType)
{
case 1: //save
if (oTaskDetail.taskdetailsAdd(auxNewTaskDetail) > 0)
{
if (!oTasks.tasksUpdateStatus(Convert.ToInt32(txtTaskId.Text), auxTaskStatus ))
{
lblMessage.Text = "Imposible actualizar nuevo Estado de Tarea...\n";
}
auxTasks = oTasks.tasksGetById(Convert.ToInt32(txtTaskId.Text));
if (!oEventsDetection.eventsdetectionUpdateStatus(auxTasks.EventsDetectionId, auxTaskStatus))
{
lblMessage.Text = "Imposible actualizar nuevo Estado del Evento de Intrusión...\n";
}
if (!oTasks.tasksUpdateUser(Convert.ToInt32(txtTaskId.Text), auxUserAssigned))
{
lblMessage.Text = "Imposible actualizar nuevo Usuario asignado a la Tarea...\n";
}
clearFields();
activateFields(false, true);
btnNew.Enabled = true;
getTaskDetailsData(TaskId);
lblMessage.Text = "Datos guardados correctamente!";
}
else
lblMessage.Text = "Error al guardar los datos!";
break;
case 2: //update
if (Convert.ToInt32(hfTaskStatusOrigin.Value) != auxTaskStatus)
{
if (!oTasks.tasksUpdateStatus(Convert.ToInt32(txtTaskId.Text), auxTaskStatus ))
{
lblMessage.Text = "Imposible actualizar nuevo Estado de Tarea...\n";
}
if (!oEventsDetection.eventsdetectionUpdateStatus(auxTasks.EventsDetectionId, auxTaskStatus))
{
lblMessage.Text = "Imposible actualizar nuevo Estado del Evento de Intrusión...\n";
}
}
if (Convert.ToInt32(hfUserOrigin.Value) != auxUserAssigned)
{
if (!oTasks.tasksUpdateUser(Convert.ToInt32(txtTaskId.Text), auxUserAssigned))
{
lblMessage.Text = "Imposible actualizar nuevo Usuario asignado a la Tarea...\n";
}
}
auxNewTaskDetail.TaskDetailsId = Convert.ToInt32(txtTaskDetailId.Text);
if (oTaskDetail.taskdetailsUpdate(auxNewTaskDetail))
{
lblMessage.Text = "Datos actualizados correctamente!";
clearFields();
activateFields(false, true);
btnSave.Enabled = false;
getTaskDetailsData(TaskId);
lblMessage.Text = "Datos actualizados correctamente!";
}
else
lblMessage.Text = "Error al guardar los datos!";
break;
}
}
else
{
lblMessage.Text = "Datos requeridos no cargados...";
}
}
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();
}
}
