Guest User

Untitled

a guest
Aug 18th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.36 KB | None | 0 0
  1. javascript countdown timer new date from database
  2. <script type="text/javascript">
  3. $(function() {
  4. var newYear = new Date();
  5. newYear = new Date(newYear.getFullYear() + 1, 1 - 1, 1);
  6. $('#countdown').countdown({ until: newYear, format: 'DHMS', layout:
  7. '<div id="timer">' + '<hr />'+
  8. '<div id="timer_days" class="timer_numbers">{dnn}</div>'+
  9. '<div id="timer_hours" class="timer_numbers">{hnn}</div>'+
  10. '<div id="timer_mins" class="timer_numbers">{mnn}</div>'+
  11. '<div id="timer_seconds" class="timer_numbers">{snn}</div>'+
  12. '<div id="timer_labels">'+
  13. '<div id="timer_days_label" class="timer_labels">days</div>'+
  14. '<div id="timer_hours_label" class="timer_labels">hours</div>'+
  15. '<div id="timer_mins_label" class="timer_labels">mins</div>'+
  16. '<div id="timer_seconds_label" class="timer_labels">secs</div>'+
  17. '</div>'+
  18. '</div>'
  19. });
  20. });
  21. </script>
  22.  
  23. If defaultJob = False Then
  24. sql.SelectCommand.CommandText = "SELECT OfferHeader, OfferDesc, MarketPrice, OfferPrice, Discount, PayInAdv, PayLater, ImageURL, AdTags,EndTime FROM " & offerTable & " WHERE CustID = '" & custID & "' AND BusiID=" & busiID & " AND OfferID=" & offerID
  25. Else
  26. sql.SelectCommand.CommandText = "SELECT OfferHeader, OfferDesc, MarketPrice, OfferPrice, Discount, PayInAdv, PayLater, ImageURL, AdTags,EndTime FROM " & offerTable & " WHERE CustID = '" & custID & "' AND BusiID=" & busiID & " AND OfferID=" & offerID
  27. End If
  28.  
  29. Try
  30. con.Open()
  31. sql.Fill(table)
  32. con.Close()
  33.  
  34. With table.Rows(0)
  35. LblOfferHeader.Text = Convert.ToString(.Item(0))
  36. LblOfferDesc.Text = Convert.ToString(.Item(1))
  37. LblMarketPrice.Text = Convert.ToString(.Item(2))
  38. LblOfferPrice.Text = Convert.ToString(.Item(3))
  39. LblDiscount.Text = Convert.ToString(.Item(4))
  40. LblPayInAdv.Text = Convert.ToString(.Item(5))
  41. LblPayLater.Text = Convert.ToString(.Item(6))
  42. ImgOfferImage.ImageUrl = Convert.ToString(.Item(7))
  43. HF.Value = Convert.ToString(.Item(9))
  44. End With
  45. Catch ex As Exception
  46. 'MsgBox(ex.Message)
  47. Finally
  48. sql.Dispose()
  49. con.Close()
  50. con.Dispose()
  51. End Try`
  52.  
  53. <input type="hidden" runat="server" id="hiddenDate" />
  54.  
  55. Page_Load()
  56. {
  57. hiddenDate.value = datereadfromDatabase;
  58.  
  59. }
  60.  
  61. <script type="text/javascript">
  62. $(function() {
  63. var newYear = $('#<%=hiddenDate.ClientID%>').val();
  64. $('#countdown').countdown({ until: newYear, format: 'DHMS', layout:
  65. '<div id="timer">' + '<hr />'+
  66. '<div id="timer_days" class="timer_numbers">{dnn}</div>'+
  67. '<div id="timer_hours" class="timer_numbers">{hnn}</div>'+
  68. '<div id="timer_mins" class="timer_numbers">{mnn}</div>'+
  69. '<div id="timer_seconds" class="timer_numbers">{snn}</div>'+
  70. '<div id="timer_labels">'+
  71. '<div id="timer_days_label" class="timer_labels">days</div>'+
  72. '<div id="timer_hours_label" class="timer_labels">hours</div>'+
  73. '<div id="timer_mins_label" class="timer_labels">mins</div>'+
  74. '<div id="timer_seconds_label" class="timer_labels">secs</div>'+
  75. '</div>'+
  76. '</div>'
  77. });
  78. });
  79. </script>
  80.  
  81. <asp:HiddenField runat="server" ID="hdf_Date" />
  82.  
  83. $('[id$=hdf_Date]').val() // Get Date
  84.  
  85. hdf_Date.Value = ValueFromDb;
Add Comment
Please, Sign In to add comment