.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Time tracking management

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :SharePoint

I have added the time tracking feature to my sharepoint site so that team members can track their hours per project.

I use this info for billing clients and for paying staff.

I would like to find a way to zero out projects at the end of the month so that I can easily calculate what a client and employee is owed for that month.

I believe that each user can export his/her calendar to an excel spreadsheet.  Is there some way for an administrator to export this info for all users.  As well, is there some way to delete all entries en masse?


thanks for your help.



View Complete Post

More Related Resource Links

Time Tracking app

I've been asked to develop an app for time tracking purposes.I was given this layoutProject    Activity     Sun   Mon   Tues   Wed   Thur   Fri   Sat   project1  design          2        2         3         1      4     2       0project2  code             2        2         3         1      4     2       0project3  test              2        2         3         1      4     2       0I was using the TimeTracker starter kit and changed the calendar to where they can only select a row and it uses the weekending date for weeky project

Time card management template issue


We installed Time card management template in share point 2007. But punch in, punch out time log is not working

how to solve this issue

Time card management template workflow issue


If we installed Time card management template in share point 2007 By default it will be working (work flow) right?

Otherwise we have to configure anything?

If i try this workflow message is failed to start

Timecard Management Appl Template - Time stamp is incorrect

I have installed the TimecardManagement.stp on MOSS 2007 UK with Danish languagepack. Everything works fine except for the time stamp when I punch in which is 3 hours ahead of our local time. Regional settings on the Moss Server is ok. Time zone on the webapllikation hosting the web is ok. Further it starts with elapsed time for 9 hours and counting from there.

Time card management template is not track the time


we have installed Time card management template in share point 2007 . But Punch in, Punch out is not track the time.

we have to configure anything?

SQL Server 2008 query execution time is different if i execute it in management studio or from code

When I execute query from software which i wrote in c# it required lots of time to complete but if I execute exactly the same query from management studio it will be done in seconds. In both cases execution plan is the same. 

first time use and got error when trying to attach database from management sudio


I am trying to attach a database from Management sudio.  I just installed SQL Express and this is the first time trying to attach a database.  Thanks  David

And get the error immediately after right clicking to attach database:


Cannot show requested dialog.


Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)

Program Location:

   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternal(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternalForPublic(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidth(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SetGridColumnWidth(SqlManagerUIDlgGrid grid, Double[] columnWidthRatio, Int32 columnIndex)
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SetDatabasesGridColumnWidths()
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.OnScale()

Round off time to the nearest minute

How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.

Date and Time Functions in SQLSERVER

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

How to programmatically add controls to Windows forms at run time by using Visual C#

Create a Windows Forms Application
Start Visual Studio .NET or Visual Studio 2005 or a later version, and create a new Visual C# Windows Application project named WinControls. Form1 is added to the project by default.
Double-click Form1 to create and view the Form1_Load event procedure.
Add private instance variables to the Form1 class to work with common Windows controls. The Form1 class starts as follows:

.NET 4 Web Application Startup Time

I was chatting with Jonathan Hawkins and some of the folks on the ASP.NET team about performance and Jonathan mentioned the startup time for large ASP.NET applications is improved on .NET 4. There are some improvements in the CLR and in ASP.NET itself that helped. If you have a giant app, you should do some tests.

Built-in Functions - Date and Time Functions

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

Essential SQL Server Date, Time and DateTime Functions

The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.

Date/Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.

Date and Time Data Types and Functions

The following sections in this topic provide an overview of all Transact-SQL date and time data types and functions. For information and examples that are common to date and time data types and functions
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend