SQL Server :: Scheduling System - Showing Data Using Relation Shift
Jul 26, 2010
How I will create the scheduling system. I have 3 tables related namely employees, schedule and shift. How will I show the data using the relation shift of the table on gridview by this: It will be filtered by datefrom and dateto: Select via calendar ex Datefrom: August 1 Dateto: August15
Then It will show:
EmployeeID Name
1 2 3 4 5 and up to 15
EP9112 Lastname, firstname, Middlename shift shift shift shift shift
with edit when I press EmployeeID their shift.
How can I also format the shift and date by: ex TimeIn: 7:00:00 AM TimeOut: 3:00:00 PM Date: 8/1/2010
When I add it, it will be TimeIn: 8/1/2010 7:00:00AM TimeOut: 8/1/2010 3:00:00 PM.
Do I need to edit my database.
View 5 Replies
Similar Messages:
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
Jul 22, 2010
May I ask for your idea regarding a scheduling system? I'm in a task of creating a scheduling system for my team and this will include the team leader will assign a shift on 1-15 cut-off schedule and 16-31 cut-off per month. How can I design my database? If you work with this before.
View 2 Replies
Nov 20, 2010
I have an sql table in which i have two columns enq_no and enq_serial.
for a particular enq_no, enq_serial should get incremented by one starting from 1.
What is the best approach to achieve this?
another issue is that after deletion enq_serial should get decremented by one.
How can i get this?
Is after delete trigger could be a good option?
If so? how can i get this with after delete trigger?
View 4 Replies
May 19, 2010
i want to create a registration form, which contain free and paid option if user registered through free then after3 days ne/she will get a msg regarding registration... So i follow the steps of this site...........but i culd not understand the code , where we define 3 days limitation ...
http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx\
View 5 Replies
Apr 9, 2010
I want to run the SQL server Job from the web page.
I have created the SP. Now i want to run this SP By run the Job.
The Job should not be scheduled automatically. I should run this job from front end web screen.
If user clicks the button i want to run the job and return the response back to the screen.
The SP (calculation process) will run for nearly 10 minutes, thats why we are going for this method instead of calling SP directly.
View 1 Replies
Jan 17, 2011
URL rewrting is not working when I shift the site from windows 2003 to 2008 server i.e from IIS6 to IIS7.I added the aspnet_isapi.dll to Handler Mapping. still it is not working.
showing me page not found 404 error.
View 3 Replies
Nov 12, 2010
I have a GridView with an extra checkbox column to select rows.
To select multiple rows, the user now has to click each separate checkbox, but I would like to offer the possibility to select multiple rows at once using Shift+click.
Thus the user would explicitly select the first row with a single click and the select the last row using Shift+click. And the checkboxes of the rows in between would then automatically be checked as well.
View 3 Replies
Aug 14, 2010
I would like bind grid view with 2 different tables that has no relation.
View 2 Replies
Aug 12, 2010
when i create my entity data model i have a situation in the DB like this :
TableFirst : [Id,IdTableSecond,IdTableSecondAgain];TableSecond[Id]
Created data model is: TableFirst.TableSecond and TableFirst.TableSecond1
Question is: Every time when i create my entity TableFirst.TableSecond will have same relation in behind (IdTableSecond) and TableFirst.TableSecond1 (IdTableSecondAgain)
or they may change?
View 1 Replies
Aug 20, 2010
I have an application which has rows of data in a relation database the table needs a status which will always be either Not Submitted, Awaiting Approval, Approved, Rejected Now since these will never change I was trying to decide the best way to implement them I can either think of a Status enum with the values and an int assigned where the int is placed into the status column on the table row.
Or a status table that linked to the table and the user select one of these as the current status.
I can't decide which is the better option as I currently have a enum in place with these values for the approval pages to populate the dropdown etc and setup the sql (as it currently using to Approved and submitted for approval but this is dirty for various reasons and needs changed).
Wondering what your thought on this were and whether I should go for one or the other.
If it makes any difference I am using Entity framework.
View 3 Replies
Feb 6, 2011
I have 3 tables: People, Fruits and a table named People_Fruit which connects People to Fruit tables. in table People_Fruit we enter records which determine who loves which fruit. People_Fruit is at "Many" side of both People and Fruits table. at this link you see this in a WinForms project: [URL]
I want to show people in a ASP grid. when the user click on a person's record he sees all record of fruits table regardless of whether the person loves it or not. there is a CheckBox column which its value determines if the person loves the fruit or not. user can check or uncheck the checkbox. If user checks the checlbox PersonId and FruitID must be entered to the People_Fruit table and if the user uncheck the checkbox the correspond record must be deleted.
View 2 Replies
Oct 14, 2010
I need to insert data into two relation tables, the parent table have an ind colum, which is an auto inser number , how can I get this auto number and insert it into the child table , in asp I see somthing like MyId = ExecuteIdentity(Mysql ), How Is in asp net 1.1 with Vb
View 9 Replies
Feb 12, 2011
I want to show xml which is load from sql server with the following code but I dont know for showing that in web which control is suitable?the code is as follow:
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["WebApplication1.Properties.Settings.mycon"].ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ajaxmovie FOR XML AUTO ", con);
XmlReader xr = cmd.ExecuteXmlReader();
xr.Read();
string data;
do{
data=xr.ReadOuterXml();
}
while(!string.IsNullOrEmpty(data));
View 2 Replies
Feb 12, 2011
I need to use a field of 64 bits (32 is not long enough). I used the following page to see the effects of bit shifting when using the Int64 data type:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ Page Language="VB" WarningLevel="1" Explicit="true" Strict="true" %>
<script language="VB" runat="server">
private sub do_test()
dim bit_no as Integer
dim info as Int64
' Show min value as binary ...
info = Int64.MinValue
response.write( String.Format( "Int64.MinValue = {0}<br>", info ) )
response.write( String.Format( "Int64.MinValue (binary) = {0}<br>", Convert.ToString( info, 2 ) ) )
response.write( "<br>" )
' Show max value as binary ...
info = Int64.MaxValue
response.write( String.Format( "Int64.MaxValue = {0}<br>", info ) )
response.write( String.Format( "Int64.MaxValue (binary) = {0}<br>", Convert.ToString( info, 2 ) ) )
response.write( "<br>" )
response.write( "Bit Shift Test" )
response.write( "<br>" )
for bit_no = 0 to 63
info = 1 << bit_no
response.write( String.Format( "1 << {0} = {1}<br>", bit_no, info ) )
next
end sub
</script>
<html>
<body>
<% do_test() %>
</body>
</html>
The output of the page is:
Int64.MinValue = -9223372036854775808
Int64.MinValue (binary) = 1000000000000000000000000000000000000000000000000000000000000000
Int64.MaxValue = 9223372036854775807
Int64.MaxValue (binary) = 111111111111111111111111111111111111111111111111111111111111111
Bit Shift Test
1 << 0 = 1
1 << 1 = 2
1 << 2 = 4
1 << 3 = 8
1 << 4 = 16
1 << 5 = 32
1 << 6 = 64
1 << 7 = 128
1 << 8 = 256
1 << 9 = 512
1 << 10 = 1024
1 << 11 = 2048
1 << 12 = 4096
1 << 13 = 8192
1 << 14 = 16384
1 << 15 = 32768
1 << 16 = 65536
1 << 17 = 131072
1 << 18 = 262144
1 << 19 = 524288
1 << 20 = 1048576
1 << 21 = 2097152
1 << 22 = 4194304
1 << 23 = 8388608
1 << 24 = 16777216
1 << 25 = 33554432
1 << 26 = 67108864
1 << 27 = 134217728
1 << 28 = 268435456
1 << 29 = 536870912
1 << 30 = 1073741824
1 << 31 = -2147483648
1 << 32 = 1
1 << 33 = 2
1 << 34 = 4
1 << 35 = 8
1 << 36 = 16
1 << 37 = 32
1 << 38 = 64
1 << 39 = 128
1 << 40 = 256
1 << 41 = 512
1 << 42 = 1024
1 << 43 = 2048
1 << 44 = 4096
1 << 45 = 8192
1 << 46 = 16384
1 << 47 = 32768
1 << 48 = 65536
1 << 49 = 131072
1 << 50 = 262144
1 << 51 = 524288
1 << 52 = 1048576
1 << 53 = 2097152
1 << 54 = 4194304
1 << 55 = 8388608
1 << 56 = 16777216
1 << 57 = 33554432
1 << 58 = 67108864
1 << 59 = 134217728
1 << 60 = 268435456
1 << 61 = 536870912
1 << 62 = 1073741824
1 << 63 = -2147483648
Obviously, the bit shift operator seems to be wrapping?? !! How can I obtain the result shown below using VB / ASP.Net -- is it even possible???
1 << 0 = 1
1 << 1 = 2
1 << 2 = 4
1 << 3 = 8
1 << 4 = 16
1 << 5 = 32
1 << 6 = 64
1 << 7 = 128
1 << 8 = 256
1 << 9 = 512
1 << 10 = 1024
1 << 11 = 2048
1 << 12 = 4096
1 << 13 = 8192
1 << 14 = 16384
1 << 15 = 32768
1 << 16 = 65536
1 << 17 = 131072
1 << 18 = 262144
1 << 19 = 524288
1 << 20 = 1048576
1 << 21 = 2097152
1 << 22 = 4194304
1 << 23 = 8388608
1 << 24 = 16777216
1 << 25 = 33554432
1 << 26 = 67108864
1 << 27 = 134217728
1 << 28 = 268435456
1 << 29 = 536870912
1 << 30 = 1073741824
1 << 31 = 2147483648
1 << 32 = 4294967296
1 << 33 = 8589934592
1 << 34 = 17179869184
1 << 35 = 34359738368
1 << 36 = 68719476736
1 << 37 = 137438953472
1 << 38 = 274877906944
1 << 39 = 549755813888
1 << 40 = 1099511627776
1 << 41 = 2199023255552
1 << 42 = 4398046511104
1 << 43 = 8796093022208
1 << 44 = 17592186044416
1 << 45 = 35184372088832
1 << 46 = 70368744177664
1 << 47 = 140737488355328
1 << 48 = 281474976710656
1 << 49 = 562949953421312
1 << 50 = 1125899906842620
1 << 51 = 2251799813685250
1 << 52 = 4503599627370500
1 << 53 = 9007199254740990
1 << 54 = 18014398509482000
1 << 55 = 36028797018964000
1 << 56 = 72057594037927900
1 << 57 = 144115188075856000
1 << 58 = 288230376151712000
1 << 59 = 576460752303423000
1 << 60 = 1152921504606850000
1 << 61 = 2305843009213690000
1 << 62 = 4611686018427390000
1 << 63 = 9223372036854780000
View 3 Replies
Mar 6, 2010
I,am trying to create a self association relation for an organization chart data tree in Entity Framework,after trying different ways for prevention of exceptions like 3007 and etc. I found that when I put my foreign key in my POCO near Parent and Items navigation properties its work.but I think this is not correct that we have both ParentID scalar property and Parent navigation property. review this and tell me is it correct or not.I'm using VS 2010 RC and ofcource .net framework 4.0 RC
[Code]....
View 2 Replies
Mar 20, 2010
VWD 2008 Express. Visual Basic.
I have the following script that captures keypresses in a text box in a gridview row. The portion in red captures the up arrow key press. But I do not know what code to assign (the?) to make it emulate a shift-tab.
[Code]....
[Code]....
View 4 Replies
Jan 12, 2010
I need to create a scheduling control in ASP.NET. Meeting slots are fixed to 30 minutes.
I am showing the slots in tabular format.
My main concern is to DateTime and slot timing like 4 to 4 4:30 to be read in code when user clicks particular cell in table, using HtmlTable control.
Table is created dynamically. Unfortunately the TableCell control don't have a click event.
In short, how can I detect the DateTime and timing from cell in the table by?
View 3 Replies
Mar 28, 2011
I have created a report (rdlc) in visual studio 2005 web form. However, the client now wants the report to be sent by email at scheduled times. How can i add a scheduler to the report?
View 1 Replies
Apr 12, 2010
I am working on the prototype for a scheduling application on an intranet system. The application is for scheduling and tracking promotional workers at various locations on various dates.
Currently, only for prototyping, I am generating a data table of location/date, and from this I iteratively build an HTML table (asp:Table control). On visiting each cell, I query for people working that location-date and populate the cell accordingly. This is very inefficient, and will at worst be improved by querying cached data for the whole location/date grid.
I'm looking around for established patterns and techniques for dealing with scenarios like this in HTML in general, maybe a visualization library for jQuery or something, and for ASP.NET in particular, maybe a library for implementation on a GridView etc.
View 4 Replies
Feb 6, 2010
As part of the web application I am working on there will be functionality to export data from the web application into a windows application copying the data between the database for the web application and the windows application. The databases for these two programs could have been combined but are being kept apart for simplicity.The utility to export the data can be triggered manually from the web application but it is also required that this task can be scheduled to run by the user (once a day, on web app shutdown etc)
I envisage this to be run as a service - I have created services for windows applications before but this is the first time I have needed to create this for a web application. Searching on goggle, I have found an msdn magazine article that suggests creating a web service and then creating a windows service which would call into this web service. So in my situation, I am thinking that I would create a web service which would contain the data transfer functionality between the web application and the windows application. Then I would create a windows service which would be installed as part of installing the web application, which would then call into the web service (at pre-defined intervals) using settings configured by the user within the web application (so that the data transfer functionality can be scheduled).Does this seem the correct solution? I would appreciate any advice on how I might achieve the above.
View 3 Replies
Aug 21, 2010
Can i upload multiple files using ctrl or shift keys in asp.net?As it happened in windows folder.
View 3 Replies
Mar 2, 2010
I have a table(ShiftCalendar) that lists a letter and a datetime:
Shift Date
A 3/2/2010 8:00:00 AM
B 3/2/2010 8:00:00 PM
I can run a select query that looks like this:
SELECT Shift
FROM ShiftCalendar
WHERE (Convert(nvarchar(10), GETDATE(), 101 = Convert(nvarchar(10), Date, 101))
This will return both values, but I need to to check the time of day to determine which Shift to return. I have been messing around with the IF ESLE and CASE but I can't find a way to tell the select statement what the time of day is.
View 3 Replies
Oct 6, 2010
Issue in UI form:1. when user press shift+tab key in numeric field then it's not working means cursor not moving.2. when user press shift+tab key in field wich is allowing any characters then it's working.
View 1 Replies
Aug 19, 2010
I'm looking at automating some reporting that I'm going to be generating. I want the reports to be generated and emailed at a particular time every day. These times will vary, and so will the types of reports.I was wondering if there were any better solution to creating a routine with a timer that executes at a set time every day? If I include this class and routine in the Application_Start of my Global.asax, will it always be running, or is there some awesome EventListener that I'm not aware of?
View 3 Replies