calulate indiviual time of user and display in datalist footer

saifali

SOLVED CLOSED ACTIVE ANSWERED
User: saifali
Posted: on Jan 28, 2014 03:27 AM
Forum: Data Controls
Answer: 1
Views: 2925

Thankyou another similar question how do i give the indiviual total time?

Means if i have a person name asim which is working on project and on same project he start n stop time (2 time) so how can i calculate the total time of only that person on that particular project ?

This is my asp.net code

<ItemTemplate>
             
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <strong>Name:</strong>
            <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
            <br />
            <br />
            <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JobNumber:</strong>
            <asp:Label ID="JobNumberLabel" runat="server" Text='<%# Eval("JobNumber") %>' />
            <br />
            <br />
            <strong>&nbsp;&nbsp; ProjectName:</strong>
            <asp:Label ID="ProjectNameLabel" runat="server" Text='<%# Eval("ProjectName") %>' />
            <br />
            <br />
            <strong>&nbsp;&nbsp;&nbsp;&nbsp; Description:</strong>
            <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>' />
            <br />
            <br />
            <strong>StartDateTime:</strong>
            <asp:Label ID="StartDateTimeLabel" runat="server" Text='<%# Eval("StartDateTime") %>' />
            <br />
            <br />
            <strong>&nbsp;&nbsp; EndDateTime:</strong>
            <asp:Label ID="EndDateTimeLabel" runat="server" Text='<%# Eval("EndDateTime") %>' />
            <br />
            <br />
            <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TimeTaken:</strong>
            <asp:Label ID="TimerLabel" runat="server" Text='<%# Eval("Timer") %>' />
            <br />
 <br />
                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="false"
                     Text="Back" ForeColor="black" Font-Bold="true" OnClick="LinkButton1_Click1"></asp:LinkButton>
                    
        </ItemTemplate>

Output display :

Name: Ali JobNumber: PI_001 ProjectName: United Description: Make Banners StartDateTime: 1/13/2014 4:11:56 AM EndDateTime: 1/23/2014 4:30:45 AM TimeTaken: 00:20:00 Back	Name: Aslam JobNumber: PI_001 ProjectName: Pathfinder Description: Logos StartDateTime: 1/23/2014 5:10:40 PM EndDateTime: 1/23/2014 5:11:00 PM TimeTaken: 00:00:20 Back	Name: a JobNumber: PI_001 ProjectName: sss Description: aaaa StartDateTime: 1/25/2014 3:25:32 PM EndDateTime: 1/25/2014 3:25:41 PM TimeTaken: 00:00:09 Back	Name: Ali JobNumber: PI_001 ProjectName: United Description: Logos StartDateTime: 1/28/2014 10:45:00 AM EndDateTime: 1/28/2014 10:45:14 AM TimeTaken: 00:00:14 Back
Total Time Of Job Is: Hours: 0 minutes: 20 seconds: 43

Download FREE API for Word, Excel and PDF in ASP.Net

kalpesh

0 6

Reply
ANSWER
User: kalpesh
Replied: on Jan 28, 2014 05:27 AM
Report

In your design you have binded Timer value to datalist for TimeTaken . need to calculate all Sum of time for a person respect to project and need to bind in template fileld .

You need to have check all start and end date recods of perticular person with respect to same project.

Apart form using Link button for NAME where you want to show total time of that person with respect to project.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

calulate indiviual time of user and display in datalist footer

Company

Explore

Follow us

Contact Us