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.
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 RepliesA web application works with the database. Once a day, the database should be scanned and alerts should be sent to users. From what I've seen out there, additional project has to be created which will be installed on the server and will work with the same database. Executable created by this project has to be installed in Windows scheduler to be activated once a day.This seems complicated and inefficient: starting additional executable and working on the same database.
View 1 RepliesI i want to schedule an asp.net page on my hosting, how to achieve it?
for instance, i have a page named myservice.aspx runing on my website.com/myservice.aspx
i want to run this page on every 24 hours.
I have an employee salary table with fields empId, month, year, salary. I need query for the following - Total salary drown each employee last year - Id of the employee who got highest salary last year. i am getting wrong o/p for these queries.
View 3 RepliesI 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.
query to find the 5th highest salary from an employee table?
View 2 Replieshttp://www.eggheadcafe.com/community/aspnet/7/10057105/attendance-sheet.aspx
View 11 RepliesI have started this small project but somehow feeling blank all of a sudden. anybody with pieces of code and structure . Project Specifications
 Use an SQL Server Database
 Show an entry form after the user presses "Add Event"
 Save appointment data to the database after the user presses "Submit"
Developing online car booking application.. I have a scenario for restricting only 10 bookings daily.
View 1 RepliesI want to write the query for finding second highest salary in my employee table how to find it??
View 3 RepliesI have been tasked with producing a web application for a new client. What they're looking for requires a Gridview with slave Detailsview within an Update Panel.
I produced this, including the Gridview in markup, as follows:[Code]....
[Code]....
However, although it works, it's been requested that I move most of this to code behind (for easier maintenance), which is causing me a few headaches.
What is the correct option here, since I see many potential methods?
Should I create an instance of the Gridview and Update Panel in markup, then define all events and columns in code behind? Create a new Gridview entirely in code behind and place it within the Update Panel? Create both in code behind?
I want to create a thread function in which once a day is completed a folder inside my website project has to be deleted.
View 1 RepliesI want to generate a CSV file everyday at 12:00 noon. How to write this code and how to generate CSV file using databse table fields.
Where shall I write this code so that it should run everyday at 12:00 ...
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
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 RepliesI'm working on a project where i'm suppose to show the employees about their daily work on time based & This is wot i need exactly.,
i dont want to EDIT or UPDATE further in the TIMELINE
The values will be in SQL Database 2000,i want to get those values from database & display in this time sheet based on their work timing
(eg.) if employee has to meet a person by 10 A.M to 3 P.M,I have to block the cells which falls in that timeline (like GREEN colored box in the figure above)
[URL]
[URL]
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 RepliesI have an application that I am working on. It tracks employee's time. I have a gridview on a page that shows the time a user clock-in and out for the day. The gridview shows data for a 2 week time span (a pay period). Occasionally an employee may have to leave and come back to work. That would require them to clock-in/out at least twice in one day. I need to add a column to my gridview that shows a daily total. I have 5 columns already. They are: date, time in, time out, hours worked, and difference. The hours worked is just using datediff to get the hours worked between the times that the employee clocked-in/out. The difference column takes the hours worked and subtracts if from 8.5hrs to get the difference in hours worked and the acutal scheduled time.
Im not exactly sure how to get the daily total. I am using MSSQL Server 2005 and VB.
in my form i m supposed to calculate the dob as soon as the user enters 14/06/98 it should get 12 yrs automatically there & then only .
how can this be done
I have an ASP.NET site that I'm going to have to take down to make some major structural updates to, and I was wondering how I should go about it from the client-side perspective. I have heard of an App_Offline.htm file or something like that, but I've never really gotten that to successfully work. Does anyone know how to do this?
EDIT
My app is running ASP.NET 4.0, for what it is worth.
What I'm looking to do is lock the application so the admin can do maintenance for however long. All i want to do is be able to click a button on a "maintenance" page and it makes it so anyone who attempts to use the system and anyone who is already in the system is redirected to a page, if they try to do anything, that says the site is down for maintenance.
on postback, on redirect, etc. No Access until that button is clicked again to unlock.
I am using asp.net 3-tier architecture, language c# for creating a web application. In presentation layer, I want to populate a textbox when I select an option from a drop down list. Under the code sample from .aspx page is given:
<asp:TableRow ID="TableRow4" runat="server">
<asp:TableCell ID="TableCell5" runat="server">
<asp:Label ID="lblCat" runat="server" Text="Product "></asp:Label>
[code]...
How does one put up a server maintenance page or reference..
Do you build a whole separate asp.net project with you basic page and logo and use that on the domain, until your main project is back up and running..
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