Scheduler: Multiple Tasks Per Row Where ViewMode=Gantt

The problem #1 can be solved by generating the rows manually (it's really simple) as demonstrated in the Gantt tutorial at http://code.daypilot.org/68118/gantt-chart-tutorial-asp-net-sql-server-c-vb-net.

You need to switch to ViewType=Resources and call LoadResources() in Page_Load:

Example:

    private void LoadResources()
    {
        DataTable locations = new DataManager().GetTasks();
        DayPilotScheduler1.Resources.Clear();
        DayPilotScheduler1.Resources.Add("New Task", "NEW");
        foreach (DataRow dr in locations.Rows)
        {
            DayPilotScheduler1.Resources.Add((string)dr["TaskName"], Convert.ToString(dr["TaskId"]));
        }
    }

Problem #2: The way you check the isOverage in BeforeEventRender seems to be incorrect: You look up the status by searching the datasource but remember that you have created two items for each event that exceeds the estimate.

The original data item can be reached using e.DataItem in BeforeEventRender so you can just load that:
You can use something like this instead:

protected void DayPilotCalendar1_BeforeEventRender( object sender, BeforeEventRenderEventArgs e )
{
  int complete = (int) e.DataItem["ProjectPercentComplete"];
  bool isOverage = (bool) e.DataItem["isOverage"];

  e.PercentComplete = complete;

  if ( isOverage )
  {
    e.BackgroundColor = "red";
    e.CssClass = "status_red";
  }
  else
  {
    e.BackgroundColor = "lightgreen";
    e.CssClass = "status_green";
  }

  e.InnerHTML = Server.HtmlEncode( e.PercentComplete + "%" );
  e.EventMoveVerticalEnabled = false;
  e.StaticBubbleHTML = String.Format( "<b>{0}</b><br/>Start: {1}<br/>End: {2}<br/>Percent Complete: {3}%", e.Text, e.Start.ToShortDateString( ), e.End.ToShortDateString( ), e.PercentComplete );
}

Thanks for your reply Dan!

I was able to get Problem #2 resolved with your advice above.

Problem #1 is still outstanding.

My code was - essentailly - already doing what you suggested (I believe). When I switch ViewMode from Gantt to Resources, the display loses all rows. It's odd because BeforeEventRender() is firing and completes, the chart is simply row-less when it renders.

Apologies for the delay.

I've checked your code again and yes, it seems to be fine (it's adding the correct values to Resources collection).

It's strange that it doesn't display the rows.

Can you please do the following:

1. Let me know how you call loadGanttChart() method (in Page_Load?)
2. Let me know what DayPilot version you are using
3. Check how the resources collection is serialized in the output HTML page. In the main Scheduler demo page (http://www.daypilot.org/demo/Scheduler/) it looks like this:

v.resources = [{"id":"GroupLocations","innerHTML":"Locations","areas":null,"name":"Locations","loaded":true,"expanded":true,"children":[{"id":"A","innerHTML":"Room 1","areas":null,"name":"Room 1","loaded":true,"contextMenu":"cmSpecial"},{"name":"Room 2","innerHTML":"Room 2","areas":null,"id":"B","loaded":true},{"name":"Room 3","innerHTML":"Room 3","areas":null,"id":"C","loaded":true},{"name":"Room 4","innerHTML":"Room 4","areas":null,"id":"D","loaded":true}]},{"id":"GroupPeople","innerHTML":"People","areas":null,"name":"People","loaded":true,"expanded":true,"children":[{"name":"Person 1","innerHTML":"Person 1","areas":null,"id":"E","loaded":true},{"id":"F","innerHTML":"Person 2","areas":null,"name":"Person 2","loaded":true,"toolTip":"Test"},{"id":"G","innerHTML":"Person 3","areas":null,"name":"Person 3","loaded":true,"toolTip":"Test"},{"id":"H","innerHTML":"Person 4","areas":null,"name":"Person 4","loaded":true,"toolTip":"Test"}]},{"id":"GroupTools","innerHTML":"Tools","areas":null,"name":"Tools","loaded":true,"expanded":true,"children":[{"name":"Tool 1","innerHTML":"Tool 1","areas":null,"id":"I","loaded":true},{"id":"J","innerHTML":"Tool 2","areas":null,"name":"Tool 2","loaded":true,"toolTip":"Test"},{"id":"K","innerHTML":"Tool 3","areas":null,"name":"Tool 3","loaded":true,"toolTip":"Test"},{"id":"L","innerHTML":"Tool 4","areas":null,"name":"Tool 4","loaded":true,"toolTip":"Test"}]}];

4. You can also try to force full update by using

DayPilotScheduler1.Update(CallBackUpdateType.Full);

in loadGanttChart() method.

Got it!!

PICNIC (Problem In Chair, Not In Computer) ....

My call to getGanttChartDate( ) contained an unnecessary and as it turns out undesirable call to DayPilotScheduler1.Resources.Clear( ).

This function is called by getGanttChartStartDate( ) and getGanttChartEndDate( ) which are called in the load.

Odd, they are called before the Resources are loaded so I'm unclear why this would have any effect (perhaps Clear( ) is async?). None the less, commenting out the DayPilotScheduler1.Resources.Clear( ) call in getGanttChartDate( ) fixed the problem.

The key was looking at how v.resources was rendered. In this case it was v.resources = [ ];

I KNEW I was loading it so that told me that I had to be clearing it out again someplace.

Thanks!!

Thanks!!

Hi JP,
I am trying to do the same thing I believe you are trying to do. Each task can have multiple start and end dates and I want them to appear on the same row like you have it, without the added blank row below.

Were you able to achieve this?

Wow RB, that was a while ago.

It looks to me like the answer is in the notes above.

If that doesn't do it, or if it is just not working for you, I'd post some code in a new thread.

I'm by no means an expert with this product; there are a lot of very helpful people who know a lot more about this than I.

Good luck!

JP