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();
}
protected void getTaskStatus()
{
List<taskstatus> lstTaskStatus = new List<taskstatus>();
taskstatusBus oTaskStatus = new taskstatusBus();
lstTaskStatus = oTaskStatus.taskstatusGetAll();
if (lstTaskStatus.Count > 0)
{
ddlTaskStatus.DataSource = lstTaskStatus;
ddlTaskStatus.DataValueField = "taskStatusId";
ddlTaskStatus.DataTextField = "taskStatusDescription";
ddlTaskStatus.DataBind();
}
}
