Show all Date Time Formats in Sql Server

SQL Query

 DECLARE @i int=0  
 L1:  
 IF @i<200  
 BEGIN  
      BEGIN TRY  
           print convert(nvarchar(max),@i+0) +'. ' + convert(nvarchar(max),getdate(),@i)  
      END TRY  
      BEGIN CATCH  
      END CATCH  
      SET @i = @i + 1  
      GOTO L1  
 END  

Output

 0. Oct 19 2017 10:30AM  
 1. 10/19/17  
 2. 17.10.19  
 3. 19/10/17  
 4. 19.10.17  
 5. 19-10-17  
 6. 19 Oct 17  
 7. Oct 19, 17  
 8. 10:30:56  
 9. Oct 19 2017 10:30:56:513AM  
 10. 10-19-17  
 11. 17/10/19  
 12. 171019  
 13. 19 Oct 2017 10:30:56:513  
 14. 10:30:56:513  
 20. 2017-10-19 10:30:56  
 21. 2017-10-19 10:30:56.513  
 22. 10/19/17 10:30:56 AM  
 23. 2017-10-19  
 24. 10:30:56  
 25. 2017-10-19 10:30:56.513  
 100. Oct 19 2017 10:30AM  
 101. 10/19/2017  
 102. 2017.10.19  
 103. 19/10/2017  
 104. 19.10.2017  
 105. 19-10-2017  
 106. 19 Oct 2017  
 107. Oct 19, 2017  
 108. 10:30:56  
 109. Oct 19 2017 10:30:56:517AM  
 110. 10-19-2017  
 111. 2017/10/19  
 112. 20171019  
 113. 19 Oct 2017 10:30:56:517  
 114. 10:30:56:517  
 120. 2017-10-19 10:30:56  
 121. 2017-10-19 10:30:56.517  
 126. 2017-10-19T10:30:56.517  
 127. 2017-10-19T10:30:56.517  
 130. 29 محرم 1439 10:30:56:517AM  
 131. 29/01/1439 10:30:56:517AM  

Prevent default form action and do another one

Some time we need to perform an action rather than default form action. For this use the script given below.

 $('#YourformID').on('keyup keypress', function (e) {  
     var keyCode = e.keyCode || e.which;  
     if (keyCode === 13) {  
       e.preventDefault();  
       $(this).find('#YourActionButtonID').click();  
     }  
   });  

How to check a temporary table exists in SQL Server

Use this sql query

 IF OBJECT_ID('[Your_DB_Name..#[Temp_Table_Name]') IS NOT NULL   
 BEGIN  
      --Action--
 END  

Example

 IF OBJECT_ID('tempdb..#tempDoc') IS NOT NULL   
 BEGIN  
      Drop Table #tempDoc  
 END  

Modal popup over modal popup

Use the given jQuery code in document_ready block.

  var modal_lv = 10000;  
     $('.modal').on('shown.bs.modal', function (e) {  
       $('.modal-backdrop:last').css('zIndex', 1051 + modal_lv);  
       $(e.currentTarget).css('zIndex', 1052 + modal_lv);  
       modal_lv++  
     });  
     $('.modal').on('hidden.bs.modal', function (e) {  
       modal_lv--  
     });  

Sample

Function for validating email format using jQuery

 function ValidateEmail(emaliID) {  
     var r = new RegExp("[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?");  
     return (emaliID.match(r) == null) ? false : true;  
   }  

Function for validate dd/MM/yyyy date using jQuery

 function VaidateDate(dateValue)  
   {  
     var dateRegex = new RegExp(/^(?=\d)(?:(?:31(?!.(?:0?[2469]|11))|(?:30|29)(?!.0?2)|29(?=.0?2.(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00)))(?:\x20|$))|(?:2[0-8]|1\d|0?[1-9]))([-.\/])(?:1[012]|0?[1-9])\1(?:1[6-9]|[2-9]\d)?\d\d(?:(?=\x20\d)\x20|$))?(((0?[1-9]|1[012])(:[0-5]\d){0,2}(\x20[AP]M))|([01]\d|2[0-3])(:[0-5]\d){1,2})?$/);  
     return dateRegex.test(dateValue);  
   }  

If function return true then it is valid else it is invalid.

Validating date format using java script

 // Validates that the input string is a valid date formatted as "mm/dd/yyyy"  
 function isValidDate(dateString)  
 {  
   // First check for the pattern  
   if(!/^\d{1,2}\/\d{1,2}\/\d{4}$/.test(dateString))  
     return false;  
   // Parse the date parts to integers  
   var parts = dateString.split("/");  
   var day = parseInt(parts[1], 10);  
   var month = parseInt(parts[0], 10);  
   var year = parseInt(parts[2], 10);  
   // Check the ranges of month and year  
   if(year < 1000 || year > 3000 || month == 0 || month > 12)  
     return false;  
   var monthLength = [ 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 ];  
   // Adjust for leap years  
   if(year % 400 == 0 || (year % 100 != 0 && year % 4 == 0))  
     monthLength[1] = 29;  
   // Check the range of the day  
   return day > 0 && day <= monthLength[month - 1];  
 };  

Simple encryption and decryption using key value in C#

Encryption

 public string Encrypt(string plainText)  
     {  
       try  
       {  
         string key = "abcd123xyz" + DateTime.Now.Year.ToString() + "#";  
         byte[] EncryptKey = { };  
         byte[] IV = { 55, 34, 87, 64, 87, 195, 54, 21 };  
         EncryptKey = System.Text.Encoding.UTF8.GetBytes(key.Substring(0, 8));  
         DESCryptoServiceProvider des = new DESCryptoServiceProvider();  
         byte[] inputByte = Encoding.UTF8.GetBytes(plainText);  
         MemoryStream mStream = new MemoryStream();  
         CryptoStream cStream = new CryptoStream(mStream, des.CreateEncryptor(EncryptKey, IV), CryptoStreamMode.Write);  
         cStream.Write(inputByte, 0, inputByte.Length);  
         cStream.FlushFinalBlock();  
         return Convert.ToBase64String(mStream.ToArray());  
       }  
       catch (Exception)  
       {  
         return "0";  
       }  
     }  

Decryption

 public string Decrypt(string encryptedText)  
     {  
       try  
       {  
         string key = "abcd123xyz" + DateTime.Now.Year.ToString() + "#";           byte[] DecryptKey = { };  
         byte[] IV = { 55, 34, 87, 64, 87, 195, 54, 21 };  
         byte[] inputByte = new byte[encryptedText.Length];  
         DecryptKey = System.Text.Encoding.UTF8.GetBytes(key.Substring(0, 8));  
         DESCryptoServiceProvider des = new DESCryptoServiceProvider();  
         inputByte = Convert.FromBase64String(encryptedText);  
         MemoryStream ms = new MemoryStream();  
         CryptoStream cs = new CryptoStream(ms, des.CreateDecryptor(DecryptKey, IV), CryptoStreamMode.Write);  
         cs.Write(inputByte, 0, inputByte.Length);  
         cs.FlushFinalBlock();  
         System.Text.Encoding encoding = System.Text.Encoding.UTF8;  
         return encoding.GetString(ms.ToArray());  
       }  
       catch (Exception)  
       {  
         return "0";  
       }  
     }  

Area registration OR Area routing in MVC C#

Sample

 public override void RegisterArea(AreaRegistrationContext context)   
     {  
       context.MapRoute(  
         "Cpanel_default",  
         "Cpanel/{controller}/{action}/{id}",  
         new { controller="Home", action = "Index", id = UrlParameter.Optional },  
         new [] {"NT.Areas.Cpanel.Controllers"}  
       );  
     }  

Manage css dynamically in razor view based on condition - MVC

Sample

  <div class="col-lg-4 col-md-3 @(app.AppPath=="#"?"disableDiv":"")">  
 Your data  
 </div>  

Redirect to an action in another area in MVC

Sample

 <a href="@Url.Action("Index", "Home",new {area="Cpanel"})">