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
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.
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.
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 question about YUI. I am using YUI calendar component in my website project. I insert the codes inside ASP as javascript. (like that [URL]) Now, i am about to hearing your questions, i am answering them immediately. Yes, this link explains how lo localize YUI calendar, but, it does not work for me. Because, it is static. I want to localize it dynamically. It should depend on user's browser language. For example, if the user's browser language is Deutsch, it is supposed to display 'samstag', if it is English, it is supposed to display 'saturday'.
View 2 RepliesI was wondering if there's anybody that can give me an idea how the component Calendar (even button) is implemented. Do you know a place where I could see it?
View 1 RepliesAjax enable the classic ASP:Calender server component?
View 1 RepliesAnyone know if it is possible to change Calendar component's header & dayheader texts in code?
I know it is possible with pages LCID setting but can it be done manually?
Reason i need to do this is that i have translation functionality in page and i'd like the calendar to be able translate headers same way. I dont want to change the pages LCID with evry language as i want to keep number and day formats same with all languages.
I am trying to stop the data flow when certain conditions happen in the script component. Like if a row in the data set has an invalid date, I dont want that dataset to be inserted in the tables or go through OLEDB Destination, rather I want the entire data flow for that dataset to stop and go back to the control flow page.
I have tried mulitple solutions but nothing worked. Conditional Split ends up inserting the correct rows, but I just dont want anyting to be inserted when one row is bad, where as I do want the entire dataset to be inserted if all rows are good.
How can I fail the component when certain conditions happen int eh script component.
I would like to know how can I list for every page (child page) selected the number and id of localize component in the current page. I need this to update resources files, a button will be on the master page and when they click on it, they will go to a page which show up every data in the resource file.
View 1 Repliesi got a problem.. how i can declare template textbox in a datagrid at code behind? i already make a stored procedure and put the update query inside it.. if i declare the textbox inside code behind(.aspx.vb).. there will be an error.. " there is already a component named "txtitem1"component must have a unique name.."
Dim con As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString1"))
Dim cmd As New SqlCommand
Dim sda As New SqlDataAdapter
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "ETendering3"
cmd.Parameters.Add("@item", SqlDbType.NVarChar).Value = txtitem1.Text
cmd.Parameters.Add("@price", SqlDbType.Decimal).Value = txtprice1.Text
cmd.Parameters.Add("@remark", SqlDbType.NVarChar).Value = txtremark1.Text
cmd.Parameters.Add("@consump", SqlDbType.Decimal).Value = txtconsump1.Text
cmd.Parameters.Add("@value", SqlDbType.Decimal).Value = txtvalue1.Text
cmd.Connection = con
Try
con.Open()
DataGrid12.DataSource = cmd.ExecuteReader()
DataGrid12.DataBind()
Finally
con.Close()
End Try
con.Dispose()
cmd.Dispose()
con = Nothing
cmd = Nothing
_______________________________________________________
.aspx
<Columns>
<asp:BoundColumn DataField="Listing_Id" HeaderText="Listing"></asp:BoundColumn>
<asp:BoundColumn DataField="No" HeaderText="No"></asp:BoundColumn>
<asp:BoundColumn DataField="Item_Category" HeaderText="Category"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="Description">
<ItemTemplate>
<asp:TextBox id=TextBox1 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Item_Description") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtitem1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Price" FooterText=" 10/50">
<ItemTemplate>
<asp:TextBox id=TextBox3 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Price") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtprice1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Remarks">
<ItemTemplate>
<asp:TextBox id=TextBox2 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Remark") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtremark1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Consumption">
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Consumption") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtconsump1"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Value">
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Value") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtvalue1"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
I've got two websites. One is a copy of the other, I even went ahead and remade a copy of the original a second time hoping it would alleviate the issue I'm having but it didn't.
On both pages I have a calendar so the route is
Csharp Code:
[code]....
The issue is on the original site /Calendar works. It shows the Calendar page with the current month. On the copy site /Calendar gives a 404 but /Calendar/Index shows the Calendar page with the current month.
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
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?
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]....
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?
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 RepliesMay 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 Repliesi 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\
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.
Can i upload multiple files using ctrl or shift keys in asp.net?As it happened in windows folder.
View 3 RepliesI 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.
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 RepliesI 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.
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
