ASP.Net %done problem

[Dev_Coppelis]

Hi,

In the ASP.Net advanced view , there is a problem with the total %done of a parent task, where all child re at 100% , the parent is 99%. (supposed to be 100%).
see attached

[Terence]

Hi, can you provide your source code, steps to reproduce and/or your mpp file in case you imported it?

[Dev_Coppelis]

Hi,
Kindly find attached file for database, MPP file and the below URL for source code.
https://www.cyandh.com/bryntum/msproject_import_net2.rar

Note: i have another problem when update any task the duration value become a decimal like 5.38

[Terence]

I have your solution up and running. But please guide me through and make the problem tangible for us.

The data files are large, where is the problem and how to reproduce?

Screen Shot 2018-01-15 at 12.35.51.png (81.28 KiB) Viewed 5267 times

loaded provided mpp

Screen Shot 2018-01-15 at 12.33.56.png (78.03 KiB) Viewed 5267 times

loaded from database

All Percentage done are 0%. You set them to such in your data?

[Dev_Coppelis]

* Select any task and update the end date, the duration became a decimal value.
* Select any main task and update the progress of sub tasks to 100% and save, you will found the main task progress is 99% not 100%.

[Terence]

Somehow the calendar is not configured correctly. Tasks are scheduled with defaultAvailability : ["00:00-24:00"]. On duration update + 1 day it will set the endtime on 24 hours while your tasks are snapped (start/end) between 9:00 and 18:00 hours.

This will cause most likely for both duration and percentagedone the rounding problems. I haven't found the cause yet, why the defaultAvailability in your code is not set accordingly.

[Terence]

Screen Shot 2018-01-16 at 11.16.12.png (61.88 KiB) Viewed 5265 times

The project calendar is wrongly set in the options table, then it will not be properly set in the metaData which sets the projectcalendar.

Screen Shot 2018-01-16 at 11.17.01.png (10.69 KiB) Viewed 5265 times

There is no calendar with id 1 in your calendar table

[Dev_Coppelis]

I had set the right calendar Id but still i have the same issues.
I'm using your demo code as it's.

[Terence]

I can not reproduce it anymore when the right project calendar is set. Have you checked that the correct projectCalendar id is returned in the calendar meta data? Please show with a picture like I provided above. Set a breakpoint on the crudmanagers `load` event, and check its value.

Only adjusting the id in the table seems not enough. In the GanttCrudController you will see this line, id 1 seems hardcoded as the second argument. Have you adjusted the code that it will return the right value? (21 in the provided data)

 if (loadRequest.calendars != null) loadResponse.setCalendars(gantt.getCalendars(), 1);

[Dev_Coppelis]

Hello Terence,

Kindly find below URl for Bryntum .net advanced demo, data base script and my MPP file
Note: The bryntum .net advanced demo and database script is without any modification from my side it's default as you provided to me, so build and run you will found this issues.
https://www.cyandh.com/bryntum/msproject_import_net2.rar