IIS Configuration :: Calculate Number Of Leaves Taken By Employee In A Month In SQL Server
Mar 18, 2013
i wrote a stored procedure to display the number of days in the particular month.if the person is taking a leave from 26jan to 03feb,using this stored procedure i will split the days as per the months..now i want to pass the employee id in the stored procedure and retrive the total days of the january month this is my code
this is my stored procedure
ALTER PROCEDURE datecheck
@EmpId int,@startdate datetime,@enddate datetime
as
begin
[Code]....
i am having dropdownlist in my webpage,if i select the employee id and month january it will retrive the january days for the particular employee.....
I want to calculate the number of days an employee has taken leave in the month of january.For that I have two date fields Leave_Start_Date and Leave_End_Date in the database as follows:
How to display the number of days in textbox when the month is selected in the dropdown list,,,for example if i select the month december ,after selection i want to display 31days in the textbox how ?
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.
i have a website which has 3 modules admin part,employee part and customer part . so when the admin login he has to see the number of customers logged in and the duration etc excluding employee and admin
I was wondering if there is any way to always run some server side code when a user leaves a page in ASP.NET. The page Unload event is no good because that doesn't get called if someone clicks on a link. Ideally I'd also like the code to run even if the user closes the browser.
I have 2 textboxes and a label on my page. The 2 textboxes will contain numeric values. The label text will be the product of the 2 textbox values. Is there a way to do this using JQuery so that the value can get updated when I edit the textboxes without having to do a postback?Also the textboxes may contain values with commas in it: e.g. 10,000. Is there a way I can extract the number from this so that it can be used to calculate the label value.
I need idea of new implementation. I have a client application which will interact with my application. My application needs to count how many slides are available in the powerpoint presentation file and it needs to provide it to the end user. And also user can ask this application to provide only first two slides or 3 and 4th slides to retrieve from the PPT file. How do I approach this. If any one has answer and source code please provide it.
I am selecting multiple dates from a calendar control and inserting them into DB. The question: how can i make calculate number of dates selected and show the number in a textbox , using a button click event?
One other thing, in another case, i am selecting (fromdate) from Calendar1 and (todate) from Calendar2 ,, i want to calculate number of days including both dates and show the number in a textbox?
I am using a drop down lists for selecting the month and year in .aspx page. I have to get last date of the selected month of particular selected year in .aspx.cs page. (some months have 30 days and some have 31 days)
We have a web part on which we display some data in a grid. We are exporting grid's underlying datatable to Excel and displaying Open - Save - Cancel dialouge box on click of a server side button.Following is the code we are executing on click of server side button.
this.Page.Response.Clear(); this.Page.Response.AppendHeader("Content-Disposition", "attachment; filename=MyTasks.xls"); this.Page.Response.ContentType = "application/ms-excel"; this.Page.Response.Write("...here goes my well formated html...."); this.Page.Response.End();
Problem is that when i click on Cancel in the diaglouge box then dialogue box to Open/Save excel disappears but all the server side buttons placed on my web part becomes non responsive, on click of any of those buttons their server side click event does not get fired
We have a web part on which we display some data in a grid. We are exporting grid's underlying datatable to Excel and displaying Open - Save - Cancel dialouge box on click of a server side button.Following is the code we are executing on click of server side button.
[Code]....
Problem is that when i click on Cancel in the diaglouge box then dialogue box to Open/Save excel disappears but all the server side buttons placed on my web part becomes non responsive, on click of any of those buttons their server side click event does not get fired !!!
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.
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)
