.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

Employee Attendance

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :ASP.Net

Hi Experts,

I'm developing a Employee Attendance System. One of my tables have details of Employee and another one have Leaves taken by those employees like,


EmpId | StartDate  |    EndDate    | NoOfDays


1          10/1/2010   10/3/2010      3

I need to show an attendance report for given month & year.

I have another one table to have company holidays and want to highlight these days. Which control I need to go for this? Please help me to achieve this....

View Complete Post

More Related Resource Links

employee attendance with in/out times (was "Query Help Needed...")


Dear Friends,

I am in problem & have to solve one query.
I have a one table with the empno, employee time in & time out, data, employee can go out & come in fequently in a day.

I want to know that how much time every emp have attend in the company per day.

I want to know that how much time every emp have not attend in the company per day(once he enter at morning and he come out in the end of the day)

Kindly, do reply as soon as possible.

I am enclosing data defination in txt file along with the data in the MS Excel file.

Thanx in Advance...

SuraReddy, Emani

employee attendance with in/out times (was "Query Help Needed...")


Dear Friends,

I am in problem & have to solve one query.
I have a one table with the empno, employee time in & time out, data, employee can go out & come in fequently in a day.

I want to know that how much time every emp have attend in the company per day.

I want to know that how much time every emp have not attend in the company per day(once he enter at morning and he come out in the end of the day)

Kindly, do reply as soon as possible.

I am enclosing data defination in txt file along with the data in the MS Excel file.

Thanx in Advance...

SuraReddy, Emani



The Table Like this

Create table emptime
 INOUTTIME TIMESTAMP(6),               
 IOGATENO VARCHAR2(10),               
 DOOR VARCHAR2(20),               
 IN_OUT VARCHAR2(10)               

Display Employee Record


I have employee table and qualification table

Each employee has multiple qualifications

Now what i want to display is employees basic information like name, identity card, designation etc..

With all the qualification he/she has

please let me know how can i do that

Following is situation which i dnt want


Identity card :123


Qualification one


Identity card :123


Qualification two

Error in / Application after adding employee search in webpart


Hello everyone,

I am working on sharepoint 2007 and I was editing the webpart of the software and after adding the predefined employee search table, the server has crashed while trying to access the server remotely with the following error message:

Error in / Application

However, while trying to login locally I have no problem and can easily login.

What will be the course of action in fixing this error.

Also the site is complaining of an invalid certificate even after adding an exception.

Any help would be greatly appreciated.

Thank You,

Chris Stanko

How Does one Create an Employee Directory with WSS

Hi,I am trying to build an employee directory (or a who is who list)page for our organisation's intranet. We are using WSS 3.0, not moss, is there any way to accomplish this task.  I have searched on the net for solutions but just cant seem to find any except maybe for moss. We already have AD. Any suggestions or help would be appreciated as I have been trying to find a solution in the last couple of weeks, thanks.

How to get in which shift the maximum of time the employee falls?

DECLARE @CheckInTime AS TABLE(EmpID INT, InTime DATETIME, OutTime DATETIME) INSERT INTO @CheckInTime SELECT 1, '1900-01-01 00:50:00.000', '1900-01-01 08:50:00.000' UNION ALL SELECT 2, '1900-01-01 09:45:00.000', '1900-01-01 14:45:00.000' UNION ALL SELECT 3, '1900-01-01 14:20:00.000', '1900-01-01 22:45:00.000' UNION ALL SELECT 4, '1900-01-01 08:30:00.000', '1900-01-01 06:45:00.000' --SELECT * FROM @CheckInTime DECLARE @ShiftMaster AS TABLE([ShiftID] [int], [Name] [varchar](50) NOT NULL, [StartTime] [datetime] NOT NULL, [EndTime] [datetime] NOT NULL) INSERT INTO @ShiftMaster SELECT 1, 'G', '1900-01-01 09:30:00.000', '1900-01-01 22:00:00.000' UNION ALL SELECT 7, 'F', '1900-01-01 00:00:00.000', '1900-01-01 08:00:00.000' UNION ALL SELECT 8, 'S', '1900-01-01 08:00:00.000', '1900-01-01 16:00:00.000' UNION ALL SELECT 9, 'T', '1900-01-01 16:00:00.000', '1900-01-01 23:59:00.000' There is no relationship between @ShiftMaster and @CheckInTime. Here emp 1 should comes in F shift. He also falls in S shift. But he works more than F shift when compared to S shift Here emp 2 should comes in G shift Here emp 3 should comes in T shift (because he works more time in T shift) Here emp 4 should comes in S shift I wants to get (ShiftID) in which shift he works for more time. Thanks, Babu Kumarasamy.

ASP.NET employee holiday/vacation tracker application

Hi guys,I am creating an application in ASP.NET that automates the process of booking/authorising employeee holiday/vacation requests. Essentially I would like it to:allow employees to login as themselves to view their current holiday entitlement, as well as their remaining balanceallow employees to make holiday/vacation requests and have these submitted to line managersallow management to have enhanced privileges to view outstanding requests and authorise/deny them electronicallyallow management to create reports regarding employees and their requested time offSo far, I have used the various tutorials on the site to create the database tables in SQL Server and code the login process successfully. As well as this I also have an administration function, used by management, to control access to the system as well as assigning specific job roles to new employees. Based on these job roles, employees have access to different parts of the system.My next task is get the logic and code correct for the creation, submission and authorisation of time off requests. I was wondering if anyone knew of or has built any similar types of applications or code that I could look at as a guide and use as a basis to build on and extend my application? I have been looking, but nothing I've found quite matches what I am after.Any help or guidance is appreciated.Thank you

Percentage of matching days off among employee's

Hi All,i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday). I want result in percentage.result like thisConsistency Days of assignment            Across 4 weeks            3 weeks                2weeks                0                                                             2%                                   0%     &

Validating Employee ID With SQL Server

Hello everybody.I am designing a validation form which has a textfiled for inserting Employee ID and a submit button for parsing inserted value. On clicking that button the SubmitButton_Click() validate the inserted value against SQL Server database. The database has a table name EMPLOYEE containing ID and Name of employees. Now I have designed the .aspx page but stuck in the rest of the job. If any one please tell me how can I do it, it will be very helpful to me.Thank you.

Attendance column not showing up as field when creating new calendar item

I have a SharePoint calendar, with a little over a dozen columns (I have also added a couple extra columns). When adding/editing calendar events, I notice that the Attendance column is not showing up as a field. If I look in SP Designer, I see the column, Attendance, but it shows a blank Content Type (whereas most all the other columns have a Content Type of Event). Can someone please talk me through this? Not only do I need the Attendance column to be a field for a calendar event, but I have the same calendar on many other sites, so hopefully I can update the Content Type for the Attendance column to Event and solve my problem. Please advise.

How to create a daily attendance register.


i'm trying to design an attendance register for pupils in a class for a term (3 months). I wanted to create columns for each day throughout the 3 months in the students table of the database but i feel this is too ambigous.  The register will be marked either 'presence' or 'absence' everyday by the class teacher. Going by my own idea, there will be a gridview with 3 columns (ID, Name & Current date). The current date will have checkbox to mark presence or absence.

The end result is to get the total days a pupil was present in school for the term, i think there is a better way to do this. I'll be pleased if anyone can help me out, i'm using this as my final year project.....THANKS

employee hierarchy using trace tree



I am looking to create an employee hierarchy in a trace tree ( any other suggestions most welcome ) and have 2 specific fields in my table ( employee , reports to )

Now a sample data looks like follows

Employee     Reports to

User A           Manager A

Manager A     Senior manager A

User B           Senior Manager A

User C          Manager A

so on and so forth 

Now how do I get a trace tree so that when i click on Senior manager A  I get Manager A and User B , and then expand manager A to get user A and User C. 

I have been looking around a lot but cannot find a solution. 

Help appreciated. 

Can sharepoint 2010 user CAL for resigned employee be re-allocated to new employee?


For the SharePoint 2010 CAL, it is for concurrent user licensing or unique user licensing?

For example, if we totally have 300 employees, but maybe only 100 employees concurrently access SharePoint portal, is that means we just need 100 CALs or we still need 300 unique CALs for all employees? If it’s unique, can licenses be re-allocated once one employee resign/leave and another new employee come?


Thank you so much....

Employee portal & MOSS 2010



Have MOSS 2010 Ent

Need to install Navision Employee portal, but it's need wss 3.0

And so have 2 questions:

1) MOSS 2010 and WSS 3.0 can live one one server?

2) May be someone install NEP on MOSS 2010 ?

Employee name change causing weird issue...


Recently, one of our female employees got married and changed her last name.

old login:


new login:



The problem is that even with her new login name (domain\nnew), when she goes to a web page whoes sole job is to display the current logged in user logon name [HttpContext.Current.User.Identity.Name], it shows... domain\mold.

Also, the PC she is using is brand-new. In other words, the PC was build after her name change. So, there isn't any conflict on the PC itself. I am puzzled at this point.

Thanks for any help


Hierarchy Employee Listing

I am trying create a SQL extract file that has the following layout below.

User  UserBoss Level1 Level2 Level3 Level4 Level5
John               John
Bob    John      John    Bob
Tom    Bob       John    Bob   Tom
Doug   Tom      John    Bob   Tom    Doug
Brad   Doug      John    Bob   Tom    Doug   Brad
Lee    John       John    Lee
Sue    Lee        John    Lee   Sue

This listing doesn't have to be sorted in this order and anyone in the listing could have multiple people reporting to them. Any ideas?

Currently, I have a sql recursive query (plus case statements) working that ranks employees and then puts them in the levels hierarchy as described above. However, I c

Employee Search wildcard- Help with this code


As the default sharepoint search doesn't support wildcard, I used content editor webpart, and insert a code in the source

the code is available at http://www.ramonscott.com/wordpress/ 

It added a text field for First Name, last name and a drop down menu for Dept.

I added an extra text field for telephone ext. The problem that i'm facing is it is searching for exactly what i'm entering in the text field (not the wildcard)

e.g if my ext = 298 --> I should enter 298 to get my name in the result, otherwise the result will return nothing.

How can I change the code to return any record that contain 298 (whether it begins with 298, end with 298, or in the middle)

below is the code from Ramon Scott

<script language="javascript">
//function to handle enter on keyboard
function txtWildPeopleFinder_KeyDown(e)
if (e.keyCode == 13 || e.keyCode==10)
return false;
return true;
//escape apostrophes in search strings
function escapestr(str)
return str.replace("'","%22");

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