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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

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

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :ASP.Net
 

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
(
 EMPCODE VARCHAR2(5),
 CARDNO VARCHAR2(5),
 EMP_CODE_NAME VARCHAR2(25),
 INOUTTIME TIMESTAMP(6),               
 IOGATENO VARCHAR2(10),               
 DOOR VARCHAR2(20),               
 IN_OUT VARCHAR2(10)               
 CARDDATE DTE
);      


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

  

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....



Extreme ASP.NET: The Life And Times of an ASP.NET MVC Controller

  

Here the author dissects the ASP.NET MVC framework and looks at how controllers work. He then explains how the framework interacts with your controllers and how you can influence those interactions.

Scott Allen

MSDN Magazine May 2009


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



Name:abc

Identity card :123

Designation:xyz

Qualification one


Name:abc

Identity card :123

Designation:xyz

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


Times series behavior ( predict and predict only)

  
hi all, This is my question: I forecast the number of ticket and our revenue for our 20 point of sales .First,  We put all this time series in the same strucutre and we mark revenue and number of ticket as predict. So MTS will try to forecast this value and the correlation between this time series will be considered  . This time we think that's the MTS must evaluate each time series separly so we put the measures predict only ( We think that there is no relationship between revenue on Tunis and revenue in Sfax ,Two tunisian region ). We fund that the first structure with Revenue and ticket marked as predict . Is more accruate than the other murked as predict only. Can any one help us to understand this behaviour ?

DataGrid ValidationRule or IDataErrorInfo validation code called multiple times for each data change

  
Following my enquiry regarding a problem in Datagrid validation, for which managing exceptions is apparently a problem, I tested the two other methods: using validation rules, or implementing the IDataErrorInfo interface. I ran into other problems there, more insidious this time. This has been done on Windows7 (32-bit), .NET 4.0.30319. 1) IDataErrorInfo When this interface is implemented, the this[string columnName] property is called four times for each modification: two times before the cell enters edit mode (with the old value in the corresponding property) two times when the new value has to be validated (with the new value) It strikes me as not really efficient, is there something wrong with my code? Here's the C# part: using System; using System.Windows; using System.Collections.ObjectModel; using System.ComponentModel; namespace DataGridTest2 { public partial class MainWindow : Window { ObservableCollection<User> users; public MainWindow() { InitializeComponent(); users = new ObservableCollection<User>() { new User { Name = "Teddy", Age = "2" }, new User { Name = "Avi", Age = "19" } }; datagrid.ItemsSource = users; datagrid.Focus(); } } public class User : INotifyPropertyChanged, IDataErrorInfo { string name; public string Name

Insert Same Record Multiple Times.

  
I have a simple form that inserts a record into a SQL table. The fields are: SerialNumTagNumPONumLocationAddressDescription   This works great. However, I have now been asked to have the form insert x number of records at one time. They want to be able to fill out the following fields: PONumLocationAddressDescription and then have texbox where they can add a number and have that number of the same record inserted.    I hope this makes sense.

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.

why only one file is grew two times by 10 % after all files are filld

  
hi, i have one data file group DATA,With 8 files associated with this.... two files in each four disk drive. i am setting the initial size of each file 1mb and auto grow by 10 % unrestricted. till 75 gb it works fine data in all the files are evenly distributed but once it reaches to 75 GB only one of those files is increasing two times rest of the files remains same... like (75*1.1)*1.1 others are 75 GB.. i expect it should increase first file by 10 % fill it and then pick second file expand by 10 % and fill and so on..  what could be the reason?? can any one help me on this??/

Invoke Delay Activity multiple times

  
HI! I am using Workflow Foundation workflows with sharepoint lists. I have a state machine workflow. One state of workflow has 2 event driven activities, one is waiting for task change and other is waiting for delay of 1 day. What i need is to send email if delay of 1 day is elapsed and send this email every day. But Delay activity is invoked only once. How can i change it so that it can be invoked multiple times. Shabih

Data Binding a DataGrid to a list fetch the same data multiple times

  
Hi, I'm using DataGrid to show data through data binding. My data are provided in a list. The setup I have is the following: DataGrid "binded" to the default view of my list that implement IList<T> and IList interfaces (MyList<T> : IList<T>, IList, INotifyCollectionChanged)             CollectionViewSource.GetDefaultView(_myList);             // Set the data context             DataContext = view; T: is here my 'business object' that hold the data, called 'MyRow'. Then the columns of the DataGrid are bound to public properties of 'MyRow' object. MyRow class has a public property of type 'object' (public object data[int index]) and first column of datagrid is bound to myRow.data[0], second column is bound to myRow.data[1] and so on.   When the datagrid is displayed, databinding kick in and my data are showed in the control. The issue I'm having is that data fetching is very repetitive even for the same rows. For example for a datagrid with 20 visible rows, the first row is fetched multiple times even if the datagrid is not resized or moved. I put break point inside my list (MyList<T> into This[T] property (public T this[int index]) and i got multiple hits into the property for the same index. Fetc

Long execution times for Search pages even after 4th or 5th user has accessed the same page.

  
Hi Guys We have a Sharepoint 2010 farm with two NLB web fronts ends, a Index server and a two box SQL cluster. The same problem also occurs on a dev box which has Sharepoint 2010 and SQl server running on the same single box. When a user access the search or advanced search page we get long execution times of between 15 and 30 seconds.  The strange thing is that the user will have a slow response the first time, then they are fine for a period of an hour or two and then they hit the slow response again.  Below i have copied info from the developer dashboard.  Does anyone have a suggestion of where to start tackiling this issue. Thanks 1st Run.  (Note this site was accessed by 3 other users first) BeginRequestHandler (0.05 ms) PostAuthenticateRequestHandler (0.06 ms) PostResolveRequestCacheHandler (18.48 ms) GetWebPartPageContent (16.87 ms) GetFileAndMetaInfo (15.57 ms) GetWebPartPageContent (35.25 ms) GetFileAndMetaInfo (34.99 ms) GetWebPartPageContent#1 (89.27 ms) GetFileAndMetaInfo (89.06 ms) Add WebParts (3975.17 ms) Search Box (3974.54 ms) SearchBoxEx.OnLoad (15426.56 ms) SearchBoxEx.HandleContextualScoping (0.01 ms) UserPreference.GetUserPreference (15418.52 ms) UserPreference.GetFromCache (0.04 ms) SearchServiceApplicationProxy.GetUse

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%     &
Categories: 
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