Web Forms :: Implementing A Time Based Event Time Zones?
Apr 18, 2010
I'm having an issue working out how to implement this time based event. Basically, my program needs to send out an email at 12AM monday morning. But the email needs to go based on the user's local time not 12AM server time.
the problem i have discovered is Daylight savings. I used current server time as 12:00AM (my local time) and my actual offset is -7:00 UTC but after the calculation i get -6:00 utc because of daylight savings. If a user was in -7:00UTC then he/she will not get the email at 12am localtime but an hour late.
I need to send emails based on users input time and day (based on their time zone)? Kind of a reminder.
For Example: User input 2:00pm Eastern Time on my server I have different time zone, how to calculate the time and send the email at users time-zone. Its a web application. What is the best way to accomplish it using asp.net c#? If somebody already done it in the past I will be glad to take a look at source code.
I got this answer from Kjensen and read the answers, but this is a different webapp
I'm running scheduled events that process incoming orders, set Picking material, manage Track & Trace numbers, etc ... and I do this at a specific time of the day (set in Administration Panel)
My server is in UK (DiscountAsp.net) but I'm 2 hours ahead.
What I really wanted is, every time I call DateTime.Now that would be automatically changed to my time instead of Local Server Time. This should handle Daylight savings as well.
I thought about making a Extension to simply call DateTime.MyLocalTime and there use TimeInfo to add / subtract the correct hours.
In good old days I did this in Global.asa (ASP) ... I just wanted to know if there is a better way to handle this.
Find if the current time falls within hourly ranges and display the start hour and end hour of that range in labels.
Examples:
If the current time is 8:46am, label startTime would return "8am" and label endTime would return "9am" If the current time is 10:01pm, label startTime returns "10pm" and label endTime returns "11pm" If the current time is 12:59am, label startTime returns "12am" and label endTime returns "1am"
I have been working with the C# TimeRange class but not getting what I need.
I am adding a custom header to a SharePoint master page and I would like to display the current time in four different time zones. However, I don't want to use the client's time as there is no way to know what time zone the client will be in, or if they have the correct time on their computer.
My problem is that I really don't know anything about ASP.NET, as I'm a PHP guy myself. So I need a way to pass the serverTime as a variable that JavaScript can use to perform calculations on to display the correct time zone.
UPDATE:
I need the clock to update as each second changes. So it is a live time instead of a static time.
UPDATE 2:
This is the code I'm using.
<script runat="server"> Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs) End Sub Public Function dtBase() As Double Dim d1 As Date = New Date(1970, 1, 1)
[Code]....
UPDATE 3:
Still don't know if the code worked. My SharePoint server rejected the page for the code blocks. I have absolutely zero idea how to do code-behind. The JS works, but if the client's time is off, the site displays incorrect times. Really wish I could just code this in PHP. I'd be done a week ago. ;)
UPDATE 4:
This update is for anyone that stumbles across this in the future looking for the answer to the problem. The code above has been updated to work correctly. The only catch is that SharePoint disallows code by default, so to enable it, you have to modify the web.config file. The web.config file is usually in the root directory of the site. Inside that file (which is XML), you'll find a tag. Somehwere inside of that, you should find , and inside of that, you should find . Inside of that tag, you want to add this:
select distinct tbl.emp_code, b.EmplName, convert(varchar, tbl.punched_date,101) as Punched_date, (select convert(varchar(8),itbl.PUNCHED_TIME, 114)+', ' from Trn_Capture_Data_New itbl where itbl.EMP_CODE=tbl.emp_code and itbl.PUNCHED_DATE=tbl.punched_date and itbl.EMP_CODE='4' and tbl.punched_date >= '03/27/2013' and tbl.punched_date <= '03/28/2013' for xml path('')) Punched_Time
Now i need to Bind it to gridview, the gridview columns should be
Date,IN,OUT,IN,OUT
In punched time the first one should be IN and second OUT. A employee would have punched several time a day. Based on that I should take maximum punches and bring that of columns as IN and OUT in gridvew dynamically. How to achieve this?
I wanted to display the relative time difference in my razor view page.
In my model, which I am passing to the view, in which I have a dateTime datatype variable. Now, I want to implement a funtion
like this
[Code]....
I am unsure how should I define my funtion and call it inside my razor view. In the funtion, I will only pass the Datetime variable. It should only return the time in string format.
My web application has hosted on the canada server but my all clients are indians.So, as I am using System.datetime.Now to store all the dates in application.Obviously, it is displaying the canadian time instead of india time.How can i do it?Is there not any gloabl settings that we can do in our web.config file so that it indicates to the server at run time which time zone to execute..?Or any other suitable alternate?
i have to listen my mail server for every 30 min. i have a distribution list and i want to count number of email comes for that distribution list and no of replies goes from the outlook for every 30 minutes. also i need to get the time difference between the replied time with arrived time of the mail. so show me some sample code
how to suppress the "AM" in the gridview (template Bind("RideTimeMin", "{0:t}")? Don't tell me to use military time because the function is not "time on a clock"; it's how much time is allowed for a task (in this case the min/max hours & minutes that horses have to complete a 20 mile trail; e.g. 05:00, 05:27, etc). I'm currently accomplishing this in the "ondatabound" function by "..RTmin.Replace("AM","")". I have looked and looked at all the websites that talk about datetime formatting but have yet to find a way to do it upfront in the gridview bind statement.
I'm using Telerik's RadScheduler Control with WebService Binding.
I've used RadScheduler with Server Side Binding which has an event called "OnTimeSlotCreated" which fires every time when a particular time slot creates so that i can access the time slot and get the control (HtmlTableCell Control) to modify it according to the requirement.
But now i'm binding it from client side through WebService which has no such "onClientTimeSlotCreated" event, also these time slots are not having any identity at client side to access.
I have a fuctioning webform where users can sign-up for a monthly reoccurring meeting. However I want to change the payment amount based on the date the individual signs up.
For instance the meeting is the 2nd wednesday of the month, if user signs up 7 days or greater they pay $10. If they sign up less than 7 days till the meeting they by $20 dollars. If user signs up 2 days before meeting they receive a message informing them registration is closed.
Is this possible with aspnet? If so how is it done, if not what options do I have?
in my application i need to generate/open a popup window automatically at some interval of time, when the user is working at some page in the application, like a alert message
the popup window contains some information which should take from the database,
and the information should be updated automatically when the popup window opens,
I have a date/time stored in a smalldatetime field (ms sql 2005) that i want to compare with the current time and receive a difference. If the difference is less than 30 minutes, do this....if more do that....
My problem is that I have a grid view that show the data from database.In my gridview i add a column name date .like eg You knw that when we send a scrap to anyone then show time how much time to send a scrap.
This is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.
Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)
If IsDate(pasDate) Then Try If pasDate <= System.DateTime.MinValue Then Return Nothing Else Return CType(pasDate, DateTime) End If Catch ex As NullReferenceException Return Nothing End Try Else Return Nothing End If End Function
So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".
I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.
IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.
I have a gridview on my page. I have a checkbox in each row of this gridview. For each checkbox in the gridview, I'd like to update my table accordingly, but I don't want them to have to hit a submit button every time they check the checkbox. I want them to check all the boxes they need to and at the end, they should hit one submit button.
I have 2 fields being displayed in a Gridview, StartTime, EndTime. I want to create a 'Time" column which shows the elapsed time in HH:MM format. (StartTime - EndTime) This was all generated with VS2008, table is pulled from an SQL Query.
I am working on a ASP.NET 2.0 application. It is hosted on IIS 6 on Windows 2003 server.
Few pages have jpeg images (around 50 images and 50 KB each). It takes long time to load the page for the first time. But when i open the same page for the second or third time it is faster.
why does a web page take long time to load for the first time?
Is it cached somewhere when it loads for the first time? Do we have any control over it?
In my app, I convert all the times to UTC. In user profiles, I save all users' time zone IDs so that I can convert all the date and time data to user's local time. However, I've noticed that recently, everything was off by an hour due to the time change we just went through.How do I make sure that times account for daylight savings time changes?
