Databases :: Employee Attendance With In/out Times ?
Sep 26, 2010
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)I am enclosing data defination in txt file along with the data in the MS Excel file.The Table Like this
Create table emptime
(
EMPCODE VARCHAR2(5),[code]....
Note: INOUTTIME this will only time like 03:45Am, 15:30PM
CARDDATE this will only Dae like 25-09-2010
View 3 Replies
Similar Messages:
Mar 12, 2012
How can generate employee attendance Reports in table bu sql server database 2005 and vb.net 2005 i'm not using crystal reports
View 1 Replies
Sep 2, 2010
I want to bind data(For ex: Employee name, Employee ID from Employee) to a dropdownlist and the data should be displayed in dropdownlist as two columns. I don't want to separate this columns by using any special characters like | or '-'. I want to display them as different columns in a dropdownlist.
How can i achieve this using .net and the data i need to retrieve using SQL server 2008.
View 2 Replies
Mar 31, 2010
I have some code that reads records from an excel file and then imports that data into an sql database. The issue only happens when the excel file has more then 350 rows in it. In the middle of the import it just stops executing and I get directed to the 'Internet Explorer cannot display the webpage' page or just a blank page when using firefox.
I dont get any time out errors or any error at all but still I tried messing around with the script timeout settings but still does the same thing at about the 2 min 30 sec mark.
[Code]....
View 2 Replies
May 26, 2013
I have attendance system in asp.net which takes employeeid, timein, timeout and date. It is working fine.
Problem arise dealing with night shift. In that case employee will timein on 1-jan-2013 at 9:00 pm and timeout at 2-Jan-2013 3:00 am.
How to deal with that.
View 1 Replies
Jan 7, 2011
http://www.eggheadcafe.com/community/aspnet/7/10057105/attendance-sheet.aspx
View 11 Replies
Jul 18, 2010
I have tried using asp.net createuserwizard and login control.But i m not able to customized them according to my liking.so i created my own user registration webform and login control with the records getting stored in sql database.I dont know whether its a correct way of using asp.net..but its working.Now I am creating a online attendace system which lets user to enter username, logged in and logged out time of each day in thedatabase .The problem is that my user logins in the morning and closes the website and again logins in the evening and exitsthe website.So how to perform this task since i am using a same login form to enter both login time and logout time?Is this possible?my table has colums id,username,logintime,logout timeThe thing is I am using a login from created earlier to enter the username,logindateandtime,logoutdateandtime fields in the databasein which logintime and logouttime gets values from system.
View 33 Replies
Sep 28, 2010
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. there will be a gridview with 3 columns (ID, Name & Current date). The current date will have checkbox to mark presence or absence.
View 4 Replies
Jan 13, 2010
designing a tbale for employees attendance which will have empname & the no of days
View 3 Replies
Apr 27, 2016
how can I generate weekly and monthly attendance report calculating total attendance for each student that I have in mu database table?
View 1 Replies
Jun 3, 2010
I'am developing a attendance software of employees with visual studio 2005 and sql server 2005, in which i have to display the attendance in a gridview withname and date as follows,
NAME (Date)1 2 3 4 5 6 7 8 9 10 .... ... 31
RAM P A P P P A
P- Present
A- Absent
View 5 Replies
Mar 5, 2010
I have developed an online HRM package ...
I need to maintain daily attendance of every employee ...
Salary is given on 1st of every month , minimum CL for an employee is 12 days in a year. After 12 days , if he or she absent more than 12 days of CL , then deduct from his or her salary amount to be paid next times.
View 1 Replies
Dec 10, 2010
I have forms authentication for my application which uses aspnet_membership database. I want to further expand this to include recording the time in and time out fro keeping an attendence record of the users.
View 5 Replies
Jan 26, 2010
I am currently trying to implement a small class attendance system, where the student names are taken from a database, stored in a List<Student>, and bound to a Repeater control. Each row of the Repeater contains two columns: The first is the student's name, and the remaining column contains a RadioButtonList with three ListItems (Present, Absent, Sick).Now, once the user presses "Submit", I want to be able to store their attendance status based on the user selection. However, after submission, the SelectedIndex is always 0, no matter what option is selected.
View 8 Replies
Mar 18, 2013
In my website there is 1 module in which i m fetching data(Student name, Roll no.) of students from the student master table into gridview... and in that gridview there is 1 checkbox column...
I want that when i will check the checkbox of those students who are present...dat checked students and name should be get entered into another table in database where there wil be present written in front of checked students and absent written in front of unchecked students.....
I tried a lot but I am not getting it.....
From the above table(student info) i wil fetch data in gridview and will mark attendance in the gridview
In the above sample gridview in the student name column the name of the students is fetched from student info table, when I will check the checkbox and select the date and click on the button the students who are checked will be stored with a status present and those who are unchecked are stored as absent in another table
The following is the table(example) is where the data is to be stored in the same manner. It means that total two tables are there in the database.
From 1 table i fetch data of students info in gridview and in another table i wil save the attendance marked in gridview....
View 1 Replies
Sep 9, 2010
I am uploading excel file to database.In the excel file EmpFirstName,EmpLastName,Dates but i dont have EmpNo.can i use FirstName and LastName as primary key.
If not what is the other choice for selecting primarykey.
Excel File Data
FirstName Lastname Date
View 2 Replies
Sep 6, 2010
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.
View 6 Replies
Apr 27, 2010
I have Creating Employee Module through Wcf. i want To upload image of employee. But Image is not Uploaded how we can Solve This Problem.
View 2 Replies
Feb 4, 2011
login 3 users for a apllication at a same time from different id's & appllied a leave from different id the leave is apllying for same id
View 13 Replies
Jan 27, 2010
I'm looking for a control I can use in an ASP.NET app for scheduling work shifts. My primary requirement is to have locations on a y-axis, dates on the x-axis, and then at each intersection, have a block divided into shifts, and each shift containing a short (1-3) list of employees working that shift.
View 2 Replies
Sep 2, 2010
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 this
Consistency Days of assignment Across 4 weeks 3 weeks 2weeks
0 2% 0% 0%
1 98% 100% 100%
2 0% 0% 0%
Here 0,1,2 are macthing days off.Across 98% of employees getting 1 days matching in off i.e 98% of employee might off in sunday.For this we need calculate matching days off for all the days from sunday to saturday across 4,3 2 weeks Here 98% of employees getting off in same day.0 indicates 0 days,1 is 1days and 2 is 2 days(for example 50 percentage of people will get off in saturday and sunday)
View 27 Replies
Sep 28, 2010
I am looking to create an employee hierarchy in a trace tree 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.
View 4 Replies
Sep 28, 2010
can u tell me what datatype i should use for TimeIn and TimeOut of the employee in database.
In frontend i am storing TimeIn and TimeOut as object.
View 1 Replies
May 10, 2010
I am trying to configure NHibernate on my console application in which I am trying to map an Employee class to a table Employee.I am getting below exception which I have no clue:
Class:
class Employee
{
public int id;
public string name;
[code]...
View 3 Replies
Jul 23, 2013
I want to make a new row inserted for the qualification of employee. the add button will add new button qualification for the employee. How can I do that....
View 1 Replies
