|
I think you should use NVARCHAR data type to store this data into SQL.
|
|
|
|
|
Experts,
Can someone please help me resolve this problem?
When a user selects start time and end time, if the difference in hours is not at least 4 hours, an alert should be raised.
This works beautifully with asp.net web form.
However, I had to switch to Gridview because I wanted not just the ability to dynamically add more dates as needed, but also be able to submit user's choices to the database.
So, since switching to gridview, the validation is no longer working.
Can someone please give me a helping hand?
Thanks a lot in advance.
<script type="text/javascript">
$(function () {
$("[id$=txtdate]").datepicker({
showOn: 'button',
buttonImageOnly: true,
buttonImage: 'images/20/calendar200.gif'
});
});
</script>
<script type='text/javascript'>
$(window).load(function () {
$('#btnSave').on('click', function () {
var sHour = $('#startHour').val();
var sMinutes = $('#startMinutes').val();
var sAmPm = $('#startAmPm').val();
var eHour = $('#endHour').val();
var eMinutes = $('#endMinutes').val();
var eAmPm = $('#endAmPm').val();
var theDate = $('#txtdate').val()
var timeStart = new Date(theDate + ' ' + sHour + ':' + sMinutes + ' ' + sAmPm).getHours();
var timeEnd = new Date(theDate + ' ' + eHour + ':' + eMinutes + ' ' + eAmPm).getHours();
var hourDiff = timeEnd - timeStart;
if (hourDiff < 4) {
alert("A mininum of 4 hours is required!");
}
});
});
</script>
Then markup
<asp:gridview ID="Gridview1" runat="server" OnRowDeleting="Gridview1_RowDeleting" ShowFooter="true" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="RowNumber" HeaderText="Row Number" />
<asp:TemplateField HeaderText="Event Date(s)">
<ItemTemplate>
<asp:TextBox ID="txtdate" runat="server" class = "Calender"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtdate"
ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Start Time">
<ItemTemplate>
<asp:DropDownList id="startHour" runat="server">
<asp:ListItem Value="07">07</asp:ListItem>
<asp:ListItem Value="08">08</asp:ListItem>
<asp:ListItem Value="09">09</asp:ListItem>
<asp:ListItem Value="10">10</asp:ListItem>
<asp:ListItem Value="11">11</asp:ListItem>
<asp:ListItem Selected="True" Value="12">12</asp:ListItem>
<asp:ListItem Value="01">01</asp:ListItem>
<asp:ListItem Value="02">02</asp:ListItem>
<asp:ListItem Value="03">03</asp:ListItem>
<asp:ListItem Value="04">04</asp:ListItem>
<asp:ListItem Value="05">05</asp:ListItem>
<asp:ListItem Value="06">06</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="startHour"
ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Minutes">
<ItemTemplate>
<asp:DropDownList id="startMinutes" runat="server">
<asp:ListItem Value="00">00</asp:ListItem>
<asp:ListItem Value="15">15</asp:ListItem>
<asp:ListItem Value="30">30</asp:ListItem>
<asp:ListItem Value="45">45</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="startMinutes"
ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="AM/PM">
<ItemTemplate>
<asp:DropDownList id="startAmPm" runat="server">
<asp:ListItem Value="AM">AM</asp:ListItem>
<asp:ListItem Value="PM">PM</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="startAmPm"
ErrorMessage="*"></asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="End Time">
<ItemTemplate>
<asp:DropDownList id="endHour" runat="server">
<asp:ListItem Value="07">07</asp:ListItem>
<asp:ListItem Value="08">08</asp:ListItem>
<asp:ListItem Value="09">09</asp:ListItem>
<asp:ListItem Value="10">10</asp:ListItem>
<asp:ListItem Value="11">11</asp:ListItem>
<asp:ListItem Selected="True" Value="12">12</asp:ListItem>
<asp:ListItem Value="01">01</asp:ListItem>
<asp:ListItem Value="02">02</asp:ListItem>
<asp:ListItem Value="03">03</asp:ListItem>
<asp:ListItem Value="04">04</asp:ListItem>
<asp:ListItem Value="05">05</asp:ListItem>
<asp:ListItem Value="06">06</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="endHour"
ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Minutes">
<ItemTemplate>
<asp:DropDownList id="endMinutes" runat="server" CSClass="fptextbox12">
<asp:ListItem Value="00">00</asp:ListItem>
<asp:ListItem Value="15">15</asp:ListItem>
<asp:ListItem Value="30">30</asp:ListItem>
<asp:ListItem Value="45">45</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="startMinutes"
ErrorMessage="*" InitialValue="Select"></asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="AM/PM">
<ItemTemplate>
<asp:DropDownList id="endAmPm" runat="server">
<asp:ListItem Value="AM">AM</asp:ListItem>
<asp:ListItem Value="PM">PM</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="endAmPm"
ErrorMessage="*" SetFocusOnError="True"></asp:RequiredFieldValidator>
</ItemTemplate>
<FooterStyle HorizontalAlign="Right" />
<FooterTemplate>
<asp:Button ID="ButtonAdd" runat="server" Text="Add Another Event" OnClick="ButtonAdd_Click" />
</FooterTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" />
</Columns>
<FooterStyle BackColor="#AC54AA" Font-Bold="True" ForeColor="white" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#AC54AA" Font-Bold="True" ForeColor="white" />
<AlternatingRowStyle BackColor="White" />
</asp:gridview>
<br />
</div>
<asp:Button ID="btnSave" runat="server" Text="Send Request" OnClick="btnSave_Click" alt="Send Request" /><br />
<asp:Label ID="lblResult" style ="font-weight:bold; font-size:large" runat="server"></asp:Label>
<asp:Button ID="btnSave" runat="server" Text="Send Reservation Request" OnClick="btnSave_Click" alt="Send Request" /><br />
modified 7-Jul-14 12:14pm.
|
|
|
|
|
Since you now have multiple rows, you won't have an element with the ID startHour / startMinutes / etc. - they'll all have a row prefix to ensure that they get a unique ID.
Your current validation method won't actually do any validation. It will display an alert, but then allow the post to continue anyway.
Also, you probably don't want an alert for every row with an error. It would be better to keep the UI consistent by using a proper validator control. In this case, the CustomValidator control[^] is probably the best choice.
<asp:TemplateField HeaderText="End Time">
<ItemTemplate>
<asp:DropDownList id="endHour" runat="server">
...
</asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
ControlToValidate="endHour"
ErrorMessage="*"
SetFocusOnError="True"
/>
<asp:CustomValidator ID="CustomValidator1" runat="server"
ControlToValidate="endHour"
ErrorMessage="A minimum of four hours is required."
Text="*"
SetFocusOnError="True"
OnServerValidate="ValidateDuration"
ClientValidationFunction="validateDuration"
/>
</ItemTemplate>
</asp:TemplateField>
protected void ValidateDuration(object sender, ServerValidateEventArgs args)
{
Control validator = (Control)sender;
Control row = validator.NamingContainer;
int startHour = int.Parse(((DropDownList)row.FindControl("startHour")).SelectedValue);
int startMinutes = int.Parse(((DropDownList)row.FindControl("startMinutes")).SelectedValue);
string startAmPm = ((DropDownList)row.FindControl("startAmPm")).SelectedValue;
switch (startAmPm)
{
case "AM":
{
if (startHour == 12)
{
startHour = 0;
}
break;
}
case "PM":
{
if (startHour != 12)
{
startHour += 12;
}
break;
}
default:
{
args.IsValid = true;
return;
}
}
int endHour = int.Parse(((DropDownList)row.FindControl("endHour")).SelectedValue);
int endMinutes = int.Parse(((DropDownList)row.FindControl("endMinutes")).SelectedValue);
string endAmPm = ((DropDownList)row.FindControl("endAmPm")).SelectedValue;
switch (endAmPm)
{
case "AM":
{
if (endHour == 12)
{
endHour = 0;
}
break;
}
case "PM":
{
if (endHour != 12)
{
endHour += 12;
}
break;
}
default:
{
args.IsValid = true;
return;
}
}
int hourDiff = endHour - startHour;
if (endMinutes < startMinutes)
{
hourDiff--;
}
args.IsValid = hourDiff >= 4;
}
function validateDuration(sender, args){
var row = $(sender).closest("tr");
var startHour = parseInt(row.find("select[name$=startHour]").val(), 10);
var startMinutes = parseInt(row.find("select[name$=startMinutes]").val(), 10);
var startAmPm = row.find("select[name$=startAmPm]").val();
switch (startAmPm) {
case "AM": {
if (startHour === 12) {
startHour = 0;
}
break;
}
case "PM": {
if (startHour !== 12) {
startHour += 12;
}
break;
}
default: {
args.IsValid = true;
return;
}
}
var endHour = parseInt(row.find("select[name$=endHour]").val(), 10);
var endMinutes = parseInt(row.find("select[name$=endMinutes]").val(), 10);
var endAmPm = row.find("select[name$=endAmPm]").val();
switch (endAmPm) {
case "AM": {
if (endHour === 12) {
endHour = 0;
}
break;
}
case "PM": {
if (endHour !== 12) {
endHour += 12;
}
break;
}
default: {
args.IsValid = true;
return;
}
}
int hourDiff = endHour - startHour;
if (endMinutes < startMinutes) {
hourDiff--;
}
args.IsValid = hourDiff >= 4;
}
NB: Your original validation function would consider 1:45 PM to 2:00 PM as one hour. This version will take the minutes into account as well. If that's not what you want, then you can remove the entire if (endMinutes < startMinutes) { ... } block, and the code which retrieves the startMinutes and endMinutes values.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
WOW, Thank you so much Richard!
You gave me so much and I am truly grateful for your generosity.
I have a couple of questions I am afraid to ask but have no choice anyway.
The js that checks for minimum hours needed is giving me the following error:
Error: Object doesn't support property or method 'parseInt'
I believe that is a Javascript.
Thank you, thank again.
|
|
|
|
|
Whoops! Looks like Number.parseInt[^] only works in Firefox. Try using just parseInt[^] instead, without the Number. prefix.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
The error is gone but the validation is not working. I tried both IE and FF.
When I say not working, it just doesn't do anything.
Rather, bypasses the validation and submits to the db anyway.
|
|
|
|
|
Do you have both the server and client-side validation in place?
Are you getting any script errors from the client-side validation?
And how are you posting to the database?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Yes, I have both server and client scripts in place.
I had to convert the server code to vb.net since that's what the rest of code is written in.
No errors from the Javascript.
I have a btnSave_Click sub. My thinking ( and I could be wrong) is that when user clicks the btnSave_Click to submit to the database but if minimum hour is not up to 4 hours, then the error is raised from your code.
Hope that's the way it should be done.
Thanks sir for your continued assistance and patience.
UPDATE: Now that I think about it, I *THINK* I know what the problem is.
Before your code, the validation included date:
var theDate = $("table[id*=Gridview1] input[id*=txtdate]").val();
var timeStart = new Date(theDate + ' ' + sHour + ':' + sMinutes + ' ' + sAmPm).getHours();
var timeEnd = new Date(theDate + ' ' + eHour + ':' + eMinutes + ' ' + eAmPm).getHours();
And also based on button click:
$('#btnSave').on('click', function () {
I am not sure how to reconcile these with your nice code Richard.
modified 7-Jul-14 11:12am.
|
|
|
|
|
OK, there were a few typos in my post, which should now be corrected:
- Missing "f" from
hourDiff within the if (endMinutes < startMinutes) block; - Missing
break statements from the switch clauses; - jQuery selectors should be
select[name$=...] instead of select[id$=...] due to changes in ASP.NET 4.0 ID generation;
I've updated my post with the Javascript code which should now work. The VB.NET code should look something like this:
Protected Sub ValidateDuration(ByVal sender As Object, ByVal args As ServerValidateEventArgs)
Dim validator As Control = DirectCast(sender, Control)
Dim row As Control = validator.NamingContainer
Dim startHour As Integer = Integer.Parse(DirectCast(row.FindControl("startHour"), DropDownList).SelectedValue)
Dim startMinutes As Integer = Integer.Parse(DirectCast(row.FindControl("startMinutes"), DropDownList).SelectedValue)
Dim startAmPm As String = DirectCast(row.FindControl("startAmPm"), DropDownList).SelectedValue
Select Case startAmPm
Case "AM"
If startHour = 12 Then
startHour = 0
End If
Case "PM"
If startHour <> 12 Then
startHour += 12
End If
Case Else
args.IsValid = True
Return
End Select
Dim endHour As Integer = Integer.Parse(DirectCast(row.FindControl("endHour"), DropDownList).SelectedValue)
Dim endMinutes As Integer = Integer.Parse(DirectCast(row.FindControl("endMinutes"), DropDownList).SelectedValue)
Dim endAmPm As String = DirectCast(row.FindControl("endAmPm"), DropDownList).SelectedValue
Select Case endAmPm
Case "AM"
If endHour = 12 Then
endHour = 0
End If
Case "PM"
If endHour <> 12 Then
endHour += 12
End If
Case Else
args.IsValid = True
Return
End Select
Dim hourDiff As Integer = endHour - startHour
If endMinutes < startMinutes Then
hourDiff -= 1
End If
args.IsValid = hourDiff >= 4
End Sub
The validator won't raise an error. Instead, as with any other validator control, the Page.IsValid property will return False. So your update method should look something like:
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnSave.Click
If Page.IsValid Then
End If
End Sub
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Simply elegant Richard!
I now completely understand exactly what you did.
If minimum hour is less than 4, then the red asterick (*) is displayed.
It is working beautiful!
You have bailed me out again. Thank you soooo much, Richard.
I have got to figure out again, once more how to give you credit for the great work and then treat this thread as solved.
|
|
|
|
|
Read here to understand how element id created inside an ASP.NET template...
Understanding ASP.NET Templates[^]
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
does anyone know how to check whether someone is a fan of a facebook page.
|
|
|
|
|
|
you can do like this after having the user permission
var user_id = 'USERID'
var page_id = 'YOUR PAGE ID';
var fql_query = 'SELECT uid FROM page_fan WHERE page_id = ' + page_id + ' and uid='+ user_id;
var query = FB.Data.query(fql_query);
query.wait(function (rows) {
if (rows.length == 1 && rows[0].uid == user_id) {
//IS A FAN OF THE PAGE
} else {
//NOT A FAN OF THE PAGE
}
});
|
|
|
|
|
<!DOCTYPE html>
<html>
<head>
<script src="//maps.googleapis.com/maps/api/js?sensor=false"type="text/javascript"></script>
<script type="text/javascript" src="jquery-1.9.1.min.js"></script>
<script src="http://code.jquery.com/mobile/1.2.0/jquery.mobile-1.2.0.min.js"></script>
<style type="text/css">
html, body, #map-canvas {
height: 100%;
margin: 0;
}
</style>
<script type="text/javascript">
= "select * from gps ORDER BY id DESC LIMIT 1"= mysql_query($sqlgps)= mysql_fetch_array($result);
?
var map; // add map make
function initialize() {
var mapOptions = {
center: new google.maps.LatLng(, ),
zoom: 17,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
map = new google.maps.Map(document.getElementById("map-canvas"),
mapOptions);
//load();
}
function make(){
var marker = new google.maps.Marker({
position: new google.maps.LatLng(, ), // auto refresh marker fram database mysql
//position: map.getCenter(),
draggable:true, // make move click
animation:google.maps.Animation.DROP,
map: map,
title: "Welcome to Thailand",
//icon: "http://maps.google.com/mapfiles/ms/micons/blue.png"
});
//
}
google.maps.event.addDomListener(window, 'load', initialize);
window.onload = make;
</script>
</head>
<body ">
<div id="map-canvas"></div>
</body>
</html>
|
|
|
|
|
I want to know what is the main purpose of the angular js can u axplain with any live example in asp.net
thanx
|
|
|
|
|
Ever considered to visit here: https://angularjs.org/[^]?
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
AngularJS is a MVC framework for client-side. You can use it for building an Single Page Application easily.
|
|
|
|
|
I have the below code, I want to display Temprature -> Metric value ?
[
{
LocalObservationDateTime: "2014-06-30T11:40:00+05:30",
EpochTime: 1404108600,
WeatherText: "Mostly cloudy",
WeatherIcon: 6,
IsDayTime: true,
Temperature: {
Metric: {
Value: 18.6,
Unit: "C",
UnitType: 17
},
Imperial: {
Value: 66,
Unit: "F",
UnitType: 18
}
},
MobileLink: "http://m.accuweather.com/en/in/kodaikanal/195980/current-weather/195980",
Link: "http://www.accuweather.com/en/in/kodaikanal/195980/current-weather/195980"
}
]
|
|
|
|
|
If you have that in a variable called "data", then this is how you could access it:
var value = data[0]['Temperature']['Metric']['Value'];
Or this way:
var value = data[0].Temperature.Metric.Value;
If you're not certain that these elements exist you should check before trying to access them, otherwise you will get a type error: Cannot read property '...' of undefined.
|
|
|
|
|
Hi,
I have a strange behavior:
I have a collection of shapes that each one of them has a mouseover and mouseout event handlers.
When the user moves across a shape, its color changes and then when he moves out of it, its color returns to the original color.
The thing that I don't understand is sometimes, the mouseout event isn't trigering at all and the color of the shape remains with the hovered state.
Here's a fiddle I created just to demonstrate the problem. The mouseout sometimes doesn't run and so the color doesn't return to its normal red.
jsfiddle.net/aK5Cz
I even tried adding a global variable as the last element hovered and checking it but no luck...
Any ideas?
modified 29-Jun-14 7:44am.
|
|
|
|
|
I think the problem that I can see is that even though addEventListener is called and executed, the handler doesn't execute.
You can see from the console log that it reaches the end of the mouseOver function but never the less the handler doesn't execute.
|
|
|
|
|
You code looks extremely complicated for a simple mouseOver test... I can't see what the logic behind detach/attach the event handler every time. It also possible that because of the complexity of your code it takes too much time to handle one event so the second is wasted (JavaScript is single threaded!!!)...
First check your 'frame' code without complication, than add functionality bit-by-bit to check when problems start to show...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Thanks for your response Peter.
The code that you see is what needs to be there in order for the code to run.
I removed some of the stuff and changed some things but it doesn't matter.
I know that JS is single threaded. Maybe that could be the reason.
I will check it.
|
|
|
|
|
I checked the code - it's the bare minimum I need for the mouse over\out so I don't have a lot to remove - although I removed parts.
http://jsfiddle.net/aK5Cz/3/[^]
What do you mean "I can't see what the logic behind detach/attach the event handler every time". There's no logic behind it - I just remove it. It's a built-in function.
The code sometimes reaches the end of mouseover and doesn't execute the mouseout when the cursor is out.
In case you are right about the thread issue: what are my alternatives?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
