Tuesday, May 6, 2014

Button with in Anchor tag works in IE8 and 7 for MVC

Button with in Anchor tag works in IE8 and 7 for MVC. Just add the below highlighted onclick="javascript:window.location=this.href"     as shown below in the "a" tag.

 <a href="@Url.Action("EventReg", "Events", new {Pgm_ID = ViewBag.PgmID})" onclick="javascript:window.location=this.href">
        <button>Register</button>
       </a>    

USEFUL MS SQL STATEMENT for Triggers and Constraints

------------
-- Disable all triggers and constraints in a database
------------

USE CopyOfAdventureWorks;

-- SQL disable all triggers
EXEC sp_MSforeachtable @command1="ALTER TABLE ? DISABLE TRIGGER ALL"
GO

-- SQL disable all constraints
EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO

-- Enable all triggers on a table
ALTER TABLE Production.Product ENABLE TRIGGER ALL

-- Enable all check contraints on a table
ALTER TABLE Production.Product CHECK CONSTRAINT ALL
GO
------------
-- Single constraint disable and enable
------------
USE CopyOfAdventureWorks;
-- SQL disable constraint
ALTER TABLE Production.Product NOCHECK CONSTRAINT CK_Product_DaysToManufacture
GO

-- SQL enable constraint
ALTER TABLE Production.Product CHECK CONSTRAINT CK_Product_DaysToManufacture

GO

-- SQL enable constraint with check of current data
ALTER TABLE Production.Product WITH CHECK
CHECK CONSTRAINT CK_Product_DaysToManufacture
GO

-- SQL enable constraint with no check of current data
ALTER TABLE Production.Product WITH NOCHECK
CHECK CONSTRAINT CK_Product_DaysToManufacture

-- Check integrity of all constraints on a table
DBCC CHECKCONSTRAINTS('Production.Product');
GO
/* DBCC execution completed. If DBCC printed error messages,
contact your system administrator.
*/

------------

------------
-- Single trigger disable and enable
------------
-- SQL disable trigger
ALTER TABLE Sales.SalesOrderHeader DISABLE TRIGGER uSalesOrderHeader
GO

-- SQL enable trigger
ALTER TABLE Sales.SalesOrderHeader ENABLE TRIGGER uSalesOrderHeader
GO
------------
------------
-- Create a check constraint for a table and enable it
------------
-- SQL create check constraint
-- Range constraint - column value must be between 0 and 100
USE AdventureWorks;
ALTER TABLE [Production].[ProductInventory] WITH CHECK
ADD CONSTRAINT [CK_ProductInventory_Bin]
CHECK (([Bin]>=(0) AND [Bin]<=(100)))
GO

-- SQL enable check constraint
ALTER TABLE [Production].[ProductInventory]
CHECK CONSTRAINT [CK_ProductInventory_Bin]
GO

To Make IE 8 or lower version to support HTML5 Elements

To Make IE 8 or lower version to support HTML5 Elements. Add the below code snippet in the start page or master page.

@*----------- DONT Remove the bolow codes until endif]--> which is not really commented ---------- *@
    <!--[if lt IE 9]>
<script>
  var e = ("abbr,article,aside,audio,canvas,datalist,details," +
    "figure,footer,header,hgroup,mark,menu,meter,nav,output," +
    "progress,section,time,video").split(',');
  for (var i = 0; i < e.length; i++) {
    document.createElement(e[i]);
  }
</script>
<![endif]-->

---------------------------OR-------------------------
Create the html5.js and call that in your page as shown below. The html5.js code snippet has been highlighted below.

<script src="@Url.Content("~/Scripts/html5.js")" type="text/javascript" ></script>

html5.js

/*
 HTML5 
*/
(function(l,f){function m(){var a=e.elements;return"string"==typeof a?a.split(" "):a}function i(a){var b=n[a[o]];b||(b={},h++,a[o]=h,n[h]=b);return b}function p(a,b,c){b||(b=f);if(g)return b.createElement(a);c||(c=i(b));b=c.cache[a]?c.cache[a].cloneNode():r.test(a)?(c.cache[a]=c.createElem(a)).cloneNode():c.createElem(a);return b.canHaveChildren&&!s.test(a)?c.frag.appendChild(b):b}function t(a,b){if(!b.cache)b.cache={},b.createElem=a.createElement,b.createFrag=a.createDocumentFragment,b.frag=b.createFrag();
a.createElement=function(c){return!e.shivMethods?b.createElem(c):p(c,a,b)};a.createDocumentFragment=Function("h,f","return function(){var n=f.cloneNode(),c=n.createElement;h.shivMethods&&("+m().join().replace(/[\w\-]+/g,function(a){b.createElem(a);b.frag.createElement(a);return'c("'+a+'")'})+");return n}")(e,b.frag)}function q(a){a||(a=f);var b=i(a);if(e.shivCSS&&!j&&!b.hasCSS){var c,d=a;c=d.createElement("p");d=d.getElementsByTagName("head")[0]||d.documentElement;c.innerHTML="x<style>article,aside,dialog,figcaption,figure,footer,header,hgroup,main,nav,section{display:block}mark{background:#FF0;color:#000}template{display:none}</style>";
c=d.insertBefore(c.lastChild,d.firstChild);b.hasCSS=!!c}g||t(a,b);return a}var k=l.html5||{},s=/^<|^(?:button|map|select|textarea|object|iframe|option|optgroup)$/i,r=/^(?:a|b|code|div|fieldset|h1|h2|h3|h4|h5|h6|i|label|li|ol|p|q|span|strong|style|table|tbody|td|th|tr|ul)$/i,j,o="_html5shiv",h=0,n={},g;(function(){try{var a=f.createElement("a");a.innerHTML="<xyz></xyz>";j="hidden"in a;var b;if(!(b=1==a.childNodes.length)){f.createElement("a");var c=f.createDocumentFragment();b="undefined"==typeof c.cloneNode||
"undefined"==typeof c.createDocumentFragment||"undefined"==typeof c.createElement}g=b}catch(d){g=j=!0}})();var e={elements:k.elements||"abbr article aside audio bdi canvas data datalist details dialog figcaption figure footer header hgroup main mark meter nav output progress section summary template time video",version:"3.7.0",shivCSS:!1!==k.shivCSS,supportsUnknownElements:g,shivMethods:!1!==k.shivMethods,type:"default",shivDocument:q,createElement:p,createDocumentFragment:function(a,b){a||(a=f);
if(g)return a.createDocumentFragment();for(var b=b||i(a),c=b.frag.cloneNode(),d=0,e=m(),h=e.length;d<h;d++)c.createElement(e[d]);return c}};l.html5=e;q(f)})(this,document);

Tuesday, April 15, 2014

jquery-simple-datetimepicker appendDtpicker to get current date from textbox

jquery-simple-datetimepicker appendDtpicker to get current date from textbox      

   $(function () {            
             $('#img_strdate').click(function () {   
//get the date from text box txtStrDate and save the date in YYYY-MM-DD HH:MM format              
                 var str2 = new Date();;
                 if ($("#<%=txtStrDate.ClientID %>").val() != null && $("#<%=txtStrDate.ClientID %>").val() != "") {
                     str2 = $("#<%=txtStrDate.ClientID %>").val();
                 }
                 var re = /^(\d{1,2})[-/](\d{1,2})[-/](\d{2,4}) (\d{1,2}):(\d{1,2})$/;
                 var m = re.exec(str2);
                 var currentDate = m[3]+'-'+m[2]+'-'+m[1] + ' ' + m[4]+':'+m[5];
                 $("#<%=txtStrDate.ClientID %>").val('');
                 $("#<%=txtStrDate.ClientID %>").appendDtpicker({
                     "dateFormat": "DD/MM/YYYY hh:mm",                
                     //"dateOnly": true,                       
                     //"current": '2012-01-01 00:00',
              //get the current date of calender will be updated from text box. And it will not go to today's date
                     "current": currentDate,
                     "onInit": function (handler) {                        
                         handler.show();                         
                     },                   
                     "onHide": function (handler) {
                         var str1 = $("#<%=txtStrDate.ClientID %>").val();
                         var d = Date.parseExact(str1, 'dd/MM/yyyy H:mm');
                         var no_days = parseInt($("#<%=txt_dur.ClientID %>").val());
                         // window.alert(d);              
                         if ($("#<%=rd_yes.ClientID %>").is(':checked')) {
                             $("#<%=txtEndDate.ClientID %>").val(d.add({ days: no_days }).toString('dd/MM/yyyy 23:59'));
                         }
                         else {
                             $("#<%=txtEndDate.ClientID %>").val(d.add({ minutes: no_days }).toString('dd/MM/yyyy HH:mm'));
                         }
                         handler.destroy();
                     }
                 });
             });

The Datetimepicker source location: https://github.com/mugifly/jquery-simple-datetimepicker