Work in Gantt component
3 Jan 202424 minutes to read
Work
The work is the total hours required to complete a task. Work can be mapped from the data source field using the property taskFields.work. Work can be measured in Hour, Day, Minute. By default, work is measured in Hour and it can be changed, by using the property workUnit.
NOTE
When the work field is mapped from the data source, the default task type will be
FixedWork.
<ejs-gantt id='Resources' dataSource="ViewBag.dataSource"
treeColumnIndex="1" height="450px" allowSelection="true" highlightWeekends="true"
resources="ViewBag.projectResources" workUnit="Hour"
projectStartDate="03/28/2019" projectEndDate="07/28/2019"
toolbar="@(new List<string>() { "Add", "Edit", "Update", "Delete", "Cancel", "ExpandAll", "CollapseAll" })">
<e-gantt-resourcefields id="ResourceId" name="ResourceName" unit="ResourceUnit">
</e-gantt-resourcefields>
<e-gantt-taskfields id="TaskId" name="TaskName" startDate="StartDate"
duration="Duration" progress="Progress" resourceInfo="Resources"
work="Work" child="SubTasks" >
</e-gantt-taskfields>
<e-gantt-columns>
<e-gantt-column field="TaskId" visible="false"></e-gantt-column>
<e-gantt-column field="TaskName" headerText="Task Name" width="180"></e-gantt-column>
<e-gantt-column field="Resources" headerText="Resources" width="160"></e-gantt-column>
<e-gantt-column field="Work" width="110"></e-gantt-column>
<e-gantt-column field="Duration" width="100"></e-gantt-column>
</e-gantt-columns>
<e-gantt-editsettings allowAdding="true" allowEditing="true" allowDeleting="true"
allowTaskbarEditing="true" showDeleteConfirmDialog="true"></e-gantt-editsettings>
</ejs-gantt>using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using WebApplication8Core.Models;
using Syncfusion.EJ2.Gantt;
namespace WebApplication8Core.Controllers
{
public class HomeController : Controller
{
public IActionResult Index()
{
ViewBag.DataSource = ResourceData();
ViewBag.projectResources = GetResources();
return View();
}
public static List<GanttResources> GetResources()
{
List<GanttResources> GanttResourcesCollection = new List<GanttResources>();
GanttResources Record1 = new GanttResources()
{
ResourceId = 1,
ResourceName = "Martin Tamer"
};
GanttResources Record2 = new GanttResources()
{
ResourceId = 2,
ResourceName = "Rose Fuller"
};
GanttResources Record3 = new GanttResources()
{
ResourceId = 3,
ResourceName = "Margaret Buchanan"
};
GanttResources Record4 = new GanttResources()
{
ResourceId = 4,
ResourceName = "Fuller King"
};
GanttResources Record5 = new GanttResources()
{
ResourceId = 5,
ResourceName = "Davolio Fuller"
};
GanttResources Record6 = new GanttResources()
{
ResourceId = 6,
ResourceName = "Van Jack"
};
GanttResources Record7 = new GanttResources()
{
ResourceId = 7,
ResourceName = "Fuller Buchanan"
};
GanttResources Record8 = new GanttResources()
{
ResourceId = 8,
ResourceName = "Jack Davolio"
};
GanttResources Record9 = new GanttResources()
{
ResourceId = 9,
ResourceName = "Tamer Vinet"
};
GanttResources Record10 = new GanttResources()
{
ResourceId = 10,
ResourceName = "Vinet Fuller"
};
GanttResources Record11 = new GanttResources()
{
ResourceId = 11,
ResourceName = "Bergs Anton"
};
GanttResources Record12 = new GanttResources()
{
ResourceId = 12,
ResourceName = "Construction Supervisor"
};
GanttResourcesCollection.Add(Record1);
GanttResourcesCollection.Add(Record2);
GanttResourcesCollection.Add(Record3);
GanttResourcesCollection.Add(Record4);
GanttResourcesCollection.Add(Record5);
GanttResourcesCollection.Add(Record6);
GanttResourcesCollection.Add(Record7);
GanttResourcesCollection.Add(Record8);
GanttResourcesCollection.Add(Record9);
GanttResourcesCollection.Add(Record10);
GanttResourcesCollection.Add(Record11);
GanttResourcesCollection.Add(Record12);
return GanttResourcesCollection;
}
public static List<GanttDataSource> ResourceData()
{
List<GanttDataSource> GanttResourceSampleCollection = new List<GanttDataSource>();
GanttDataSource Record1 = new GanttDataSource()
{
TaskId = 1,
TaskName = "Project initiation",
StartDate = new DateTime(2019, 03, 29),
EndDate = new DateTime(2019, 04, 21),
SubTasks = new List<GanttDataSource>(),
};
GanttDataSource Record1Child1 = new GanttDataSource()
{
TaskId = 2,
TaskName = "Identify Site location",
StartDate = new DateTime(2019, 03, 29),
Duration = 2,
Progress = 30,
Work = 16,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 1, ResourceUnit = 70 },
new ResourceModel { ResourceId = 6 }
}
};
GanttDataSource Record1Child2 = new GanttDataSource()
{
TaskId = 3,
TaskName = "Perform soil test",
StartDate = new DateTime(2019, 03, 29),
Duration = 4,
Work = 96,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 2 },
new ResourceModel{ ResourceId = 3 },
new ResourceModel{ ResourceId = 5 }
}
};
GanttDataSource Record1Child3 = new GanttDataSource()
{
TaskId = 4,
TaskName = "Soil test approval",
StartDate = new DateTime(2019, 03, 29),
Duration = 1,
Progress = 30,
Work = 16,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 8 },
new ResourceModel { ResourceId = 9, ResourceUnit = 50 }
}
};
Record1.SubTasks.Add(Record1Child1);
Record1.SubTasks.Add(Record1Child2);
Record1.SubTasks.Add(Record1Child3);
GanttDataSource Record2 = new GanttDataSource()
{
TaskId = 5,
TaskName = "Project estimation",
StartDate = new DateTime(2019, 03, 29),
EndDate = new DateTime(2019, 04, 21),
SubTasks = new List<GanttDataSource>(),
};
GanttDataSource Record2Child1 = new GanttDataSource()
{
TaskId = 6,
TaskName = "Develop floor plan for estimation",
StartDate = new DateTime(2019, 03, 29),
Duration = 3,
Progress = 30,
Work = 30,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 4, ResourceUnit = 60 }
}
};
GanttDataSource Record2Child2 = new GanttDataSource()
{
TaskId = 7,
TaskName = "List materials",
StartDate = new DateTime(2019, 04, 01),
Duration = 3,
Work = 48,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 8 },
new ResourceModel{ ResourceId = 4 }
}
};
GanttDataSource Record2Child3 = new GanttDataSource()
{
TaskId = 8,
TaskName = "Estimation approval",
StartDate = new DateTime(2019, 04, 01),
Duration = 2,
Work = 60,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 12 },
new ResourceModel{ ResourceId = 5, ResourceUnit = 70 }
}
};
Record2.SubTasks.Add(Record2Child1);
Record2.SubTasks.Add(Record2Child2);
Record2.SubTasks.Add(Record2Child3);
GanttDataSource Record3 = new GanttDataSource()
{
TaskId = 9,
TaskName = "Sign contract",
StartDate = new DateTime(2019, 04, 01),
Duration = 1,
Predecessor = "8",
Progress = 30,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 12 }
}
};
GanttResourceSampleCollection.Add(Record1);
GanttResourceSampleCollection.Add(Record2);
GanttResourceSampleCollection.Add(Record3);
return GanttResourceSampleCollection;
}
public class GanttResources
{
public int ResourceId { get; set; }
public string ResourceName { get; set; }
public Nullable<int> Unit { get; set; }
}
public class GanttDataSource
{
public int TaskId { get; set; }
public string TaskName { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public int? Duration { get; set; }
public int Progress { get; set; }
public string Predecessor { get; set; }
public List<GanttDataSource> SubTasks { get; set; }
public int[] ResourceId { get; set; }
public List<ResourceModel> Resources { get; set; }
public int Work { get; set; }
}
public class ResourceModel
{
public int ResourceId { get; set; }
public Nullable<int> ResourceUnit { get; set; }
}
}
}
Task type
The work, duration and resource unit fields of a task depends upon each other and will change automatically on editing any one of these fields. But we can also set these field’s values as constant using the taskType property. FixedUnit is the default taskType. The following values can be set to the taskType property,
-
FixedDuration- Duration task field will remain constant while updating resource unit or work field. -
FixedWork- Work field will remain constant while updating resource unit or duration fields. -
FixedUnit- Resource units will remain constant while updating duration or work field.
<ejs-gantt id='Resources' dataSource="ViewBag.dataSource"
treeColumnIndex="1" height="450px" allowSelection="true" highlightWeekends="true"
resources="ViewBag.projectResources" workUnit="Hour" taskType="FixedWork"
projectStartDate="03/28/2019" projectEndDate="07/28/2019"
toolbar="@(new List<string>() { "Add", "Edit", "Update", "Delete", "Cancel", "ExpandAll", "CollapseAll" })">
<e-gantt-resourcefields id="ResourceId" name="ResourceName" unit="ResourceUnit">
</e-gantt-resourcefields>
<e-gantt-taskfields id="TaskId" name="TaskName" startDate="StartDate"
duration="Duration" progress="Progress" resourceInfo="Resources"
work="Work" child="SubTasks" >
</e-gantt-taskfields>
<e-gantt-columns>
<e-gantt-column field="TaskId" visible="false"></e-gantt-column>
<e-gantt-column field="TaskName" headerText="Task Name" width="180"></e-gantt-column>
<e-gantt-column field="Resources" headerText="Resources" width="160"></e-gantt-column>
<e-gantt-column field="Work" width="110"></e-gantt-column>
<e-gantt-column field="Duration" width="100"></e-gantt-column>
<e-gantt-column field="taskType" headerText="Task Type" width="110"></e-gantt-column>
</e-gantt-columns>
<e-gantt-editsettings allowAdding="true" allowEditing="true" allowDeleting="true"
allowTaskbarEditing="true" showDeleteConfirmDialog="true"></e-gantt-editsettings>
</ejs-gantt>using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using WebApplication8Core.Models;
using Syncfusion.EJ2.Gantt;
namespace WebApplication8Core.Controllers
{
public class HomeController : Controller
{
public IActionResult Index()
{
ViewBag.DataSource = ResourceData();
ViewBag.projectResources = GetResources();
return View();
}
public static List<GanttResources> GetResources()
{
List<GanttResources> GanttResourcesCollection = new List<GanttResources>();
GanttResources Record1 = new GanttResources()
{
ResourceId = 1,
ResourceName = "Martin Tamer"
};
GanttResources Record2 = new GanttResources()
{
ResourceId = 2,
ResourceName = "Rose Fuller"
};
GanttResources Record3 = new GanttResources()
{
ResourceId = 3,
ResourceName = "Margaret Buchanan"
};
GanttResources Record4 = new GanttResources()
{
ResourceId = 4,
ResourceName = "Fuller King"
};
GanttResources Record5 = new GanttResources()
{
ResourceId = 5,
ResourceName = "Davolio Fuller"
};
GanttResources Record6 = new GanttResources()
{
ResourceId = 6,
ResourceName = "Van Jack"
};
GanttResources Record7 = new GanttResources()
{
ResourceId = 7,
ResourceName = "Fuller Buchanan"
};
GanttResources Record8 = new GanttResources()
{
ResourceId = 8,
ResourceName = "Jack Davolio"
};
GanttResources Record9 = new GanttResources()
{
ResourceId = 9,
ResourceName = "Tamer Vinet"
};
GanttResources Record10 = new GanttResources()
{
ResourceId = 10,
ResourceName = "Vinet Fuller"
};
GanttResources Record11 = new GanttResources()
{
ResourceId = 11,
ResourceName = "Bergs Anton"
};
GanttResources Record12 = new GanttResources()
{
ResourceId = 12,
ResourceName = "Construction Supervisor"
};
GanttResourcesCollection.Add(Record1);
GanttResourcesCollection.Add(Record2);
GanttResourcesCollection.Add(Record3);
GanttResourcesCollection.Add(Record4);
GanttResourcesCollection.Add(Record5);
GanttResourcesCollection.Add(Record6);
GanttResourcesCollection.Add(Record7);
GanttResourcesCollection.Add(Record8);
GanttResourcesCollection.Add(Record9);
GanttResourcesCollection.Add(Record10);
GanttResourcesCollection.Add(Record11);
GanttResourcesCollection.Add(Record12);
return GanttResourcesCollection;
}
public static List<GanttDataSource> ResourceData()
{
List<GanttDataSource> GanttResourceSampleCollection = new List<GanttDataSource>();
GanttDataSource Record1 = new GanttDataSource()
{
TaskId = 1,
TaskName = "Project initiation",
StartDate = new DateTime(2019, 03, 29),
EndDate = new DateTime(2019, 04, 21),
SubTasks = new List<GanttDataSource>(),
};
GanttDataSource Record1Child1 = new GanttDataSource()
{
TaskId = 2,
TaskName = "Identify Site location",
StartDate = new DateTime(2019, 03, 29),
Duration = 2,
Progress = 30,
Work = 16,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 1, ResourceUnit = 70 },
new ResourceModel { ResourceId = 6 }
}
};
GanttDataSource Record1Child2 = new GanttDataSource()
{
TaskId = 3,
TaskName = "Perform soil test",
StartDate = new DateTime(2019, 03, 29),
Duration = 4,
Work = 96,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 2 },
new ResourceModel{ ResourceId = 3 },
new ResourceModel{ ResourceId = 5 }
}
};
GanttDataSource Record1Child3 = new GanttDataSource()
{
TaskId = 4,
TaskName = "Soil test approval",
StartDate = new DateTime(2019, 03, 29),
Duration = 1,
Progress = 30,
Work = 16,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 8 },
new ResourceModel { ResourceId = 9, ResourceUnit = 50 }
}
};
Record1.SubTasks.Add(Record1Child1);
Record1.SubTasks.Add(Record1Child2);
Record1.SubTasks.Add(Record1Child3);
GanttDataSource Record2 = new GanttDataSource()
{
TaskId = 5,
TaskName = "Project estimation",
StartDate = new DateTime(2019, 03, 29),
EndDate = new DateTime(2019, 04, 21),
SubTasks = new List<GanttDataSource>(),
};
GanttDataSource Record2Child1 = new GanttDataSource()
{
TaskId = 6,
TaskName = "Develop floor plan for estimation",
StartDate = new DateTime(2019, 03, 29),
Duration = 3,
Progress = 30,
Work = 30,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 4, ResourceUnit = 60 }
}
};
GanttDataSource Record2Child2 = new GanttDataSource()
{
TaskId = 7,
TaskName = "List materials",
StartDate = new DateTime(2019, 04, 01),
Duration = 3,
Work = 48,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 8 },
new ResourceModel{ ResourceId = 4 }
}
};
GanttDataSource Record2Child3 = new GanttDataSource()
{
TaskId = 8,
TaskName = "Estimation approval",
StartDate = new DateTime(2019, 04, 01),
Duration = 2,
Work = 60,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 12 },
new ResourceModel{ ResourceId = 5, ResourceUnit = 70 }
}
};
Record2.SubTasks.Add(Record2Child1);
Record2.SubTasks.Add(Record2Child2);
Record2.SubTasks.Add(Record2Child3);
GanttDataSource Record3 = new GanttDataSource()
{
TaskId = 9,
TaskName = "Sign contract",
StartDate = new DateTime(2019, 04, 01),
Duration = 1,
Predecessor = "8",
Progress = 30,
Resources = new List<ResourceModel>
{
new ResourceModel { ResourceId = 12 }
}
};
GanttResourceSampleCollection.Add(Record1);
GanttResourceSampleCollection.Add(Record2);
GanttResourceSampleCollection.Add(Record3);
return GanttResourceSampleCollection;
}
public class GanttResources
{
public int ResourceId { get; set; }
public string ResourceName { get; set; }
public Nullable<int> Unit { get; set; }
}
public class GanttDataSource
{
public int TaskId { get; set; }
public string TaskName { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public int? Duration { get; set; }
public int Progress { get; set; }
public string Predecessor { get; set; }
public List<GanttDataSource> SubTasks { get; set; }
public int[] ResourceId { get; set; }
public List<ResourceModel> Resources { get; set; }
public int Work { get; set; }
}
public class ResourceModel
{
public int ResourceId { get; set; }
public Nullable<int> ResourceUnit { get; set; }
}
}
}
Following table explains how the work, duration and resource unit fields will gets updated on changing any of the fields
| Task Type | Changes in Duration | Changes in work | Changes in Resource Units |
|---|---|---|---|
| Fixed Duration | Work field updates | Resource unit updates | Work field updates |
| Fixed Work | Resource unit updates. For manually scheduled task work will update. | Duration field updates. For manually scheduled task resource unit updates. | Duration will update. For manually scheduled task work field updates. |
| Fixed Unit | Work field updates | Duration field updates. For manually scheduled task resource unit updates. | Duration will update. For manually scheduled task work field updates. |
NOTE
- Fixed Unit is the default taskType in Gantt.
2. The above calculations are not applicable for Milestones.