rajinder singh
Top achievements
Rank 1
Rank 1
rajinder singh
asked on 07 Nov 2009, 12:06 AM
hi i have already sent so many mails to telerik client service..but still havent got any satisfied answer..now i think this is not a best tool for my application. please take a look over my problem once again and suggest me a solution.
i am preparing a employee management system for a cleaning company. but the schedule of employees are so much complicated and irragular. they need to work every day on diffrent sites. i used telerik schedular to prepare the roster for employees. now
1. i need to calculate total hours they worked every day and from that calculate total hours they worked every week and month so that i can calculate their total salaries..
2. if i calculate their time span for a job and save it into another table then there is a problem with reoccurence...
i dnt know how to do that. in my last forum they just suggest me to show in tooltip. but from tooltip how can i calculate the salaries..i concerned with so many developers but all were confused.
please help me..there is no existing system for that..and my client used to do all these things mannualy.
i am preparing a employee management system for a cleaning company. but the schedule of employees are so much complicated and irragular. they need to work every day on diffrent sites. i used telerik schedular to prepare the roster for employees. now
1. i need to calculate total hours they worked every day and from that calculate total hours they worked every week and month so that i can calculate their total salaries..
2. if i calculate their time span for a job and save it into another table then there is a problem with reoccurence...
i dnt know how to do that. in my last forum they just suggest me to show in tooltip. but from tooltip how can i calculate the salaries..i concerned with so many developers but all were confused.
please help me..there is no existing system for that..and my client used to do all these things mannualy.
1 Answer, 1 is accepted
0
Hello,
Doing these calculations is not directly related to the controls, but we'll try to help as much as possible.
Your idea with using separate table to store the summarized results seems very good. You can then update this table independently based on the stored appointments.
One option is to do this in a separate application/service by reading the appointments directly from the database. You can parse recurrence rules using the RecurrenceRule class as described here:
http://www.telerik.com/help/aspnet-ajax/schedule_serversideworkingwithrecurringappointments.html
You can even do all of the processing in the SQL Server if you're using SQL Server 2005 or later. This blog post contains more details:
http://www.telerik.com/help/aspnet-ajax/schedule_serversideworkingwithrecurringappointments.html
I hope this helps.
Greetings,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Doing these calculations is not directly related to the controls, but we'll try to help as much as possible.
Your idea with using separate table to store the summarized results seems very good. You can then update this table independently based on the stored appointments.
One option is to do this in a separate application/service by reading the appointments directly from the database. You can parse recurrence rules using the RecurrenceRule class as described here:
http://www.telerik.com/help/aspnet-ajax/schedule_serversideworkingwithrecurringappointments.html
You can even do all of the processing in the SQL Server if you're using SQL Server 2005 or later. This blog post contains more details:
http://www.telerik.com/help/aspnet-ajax/schedule_serversideworkingwithrecurringappointments.html
I hope this helps.
Greetings,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.