protected void generateBarChartTasks() { DataTable dttTaskByStatus = new DataTable(); dttTaskByStatus.Columns.Add(new DataColumn("statusId", System.Type.GetType("System.Int32"))); dttTaskByStatus.Columns.Add(new DataColumn("StatusName", System.Type.GetType("System.String"))); dttTaskByStatus.Columns.Add(new DataColumn("Quantity", System.Type.GetType("System.Int32"))); List<taskstatus> lstTaskStatus = new List<taskstatus>(); taskstatusBus oTaskStatus = new taskstatusBus(); List<tasks> lstTasks = new List<tasks>(); tasksBus oTask = new tasksBus(); lstTaskStatus = oTaskStatus.taskstatusGetAll(); if (lstTaskStatus.Count > 0) { foreach (taskstatus rowTaskStatus in lstTaskStatus) { int qtyTask = 0; lstTasks = oTask.tasksGetAll(); foreach (tasks rowTask in lstTasks) { if (rowTask.TaskStatudId == rowTaskStatus.TaskStatusId) if (rowTask.TaskStatudId != 2) //Closed if (rowTask.TaskStatudId != 5) //Rejected qtyTask++; } dttTaskByStatus.Rows.Add(rowTaskStatus.TaskStatusId, rowTaskStatus.TaskStatusDescription, qtyTask); } } barChartTasks.Series[0].XValueMember = "StatusName"; barChartTasks.Series[0].YValueMembers = "Quantity"; barChartTasks.DataSource = dttTaskByStatus; barChartTasks.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 generateBarChartUsers() { DataTable dttTaskByUser = new DataTable(); dttTaskByUser.Columns.Add(new DataColumn("userId", System.Type.GetType("System.Int32"))); dttTaskByUser.Columns.Add(new DataColumn("userName", System.Type.GetType("System.String"))); dttTaskByUser.Columns.Add(new DataColumn("Quantity", System.Type.GetType("System.Int32"))); List<users> lstUsers = new List<users>(); usersBus oUsers = new usersBus(); List<tasks> lstTasks = new List<tasks>(); tasksBus oTask = new tasksBus(); lstUsers = oUsers.usersGetAll(); if (lstUsers.Count > 0) { foreach (users rowUser in lstUsers) { int qtyTask = 0; if (Convert.ToBoolean(rowUser.UserActive)) { lstTasks = oTask.tasksGetAll(); foreach (tasks rowTask in lstTasks) { if (rowTask.UserId == rowUser.UserId) if (rowTask.TaskStatudId != 2) //Closed if (rowTask.TaskStatudId != 5) //Rejected qtyTask++; } dttTaskByUser.Rows.Add(rowUser.UserId, rowUser.UserName, qtyTask); } } } //Task without User int qtyWithoutUser = 0; lstTasks = oTask.tasksGetAll(); if (lstTasks.Count > 0) { foreach (tasks row in lstTasks) if (row.UserId < 1) qtyWithoutUser++; if (qtyWithoutUser > 0) dttTaskByUser.Rows.Add(0, "No asignado", qtyWithoutUser); } barChartUsers.Series[0].XValueMember = "userName"; barChartUsers.Series[0].YValueMembers = "Quantity"; barChartUsers.DataSource = dttTaskByUser; barChartUsers.DataBind(); }