Jainul Khan

Comparing Two Dates formatted (mm/dd/yyyy) using jQuery

Just convert to a Date object and compare your date value to Date.now - for example: var endDate = Date.parse( '4/25/2015' );  var currentDate = Date.now(); if (endDate >= currentDate) { return true ;             }

Find today’s date formatted (mm/dd/yyyy) using jQuery

var getDateToday = new Date(); var dateFormat = getDateToday.toISOString().split( "T" )[0].split( "-" ); var dateFormatted = dateFormat[1] + "/" + dateFormat[2] + "/" + dateFormat[0]; alert( 'Date Today mm/dd/yyy Format : ' + dateFormatted);

Inserting a string inside string using SQL Server

STUFF() The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position. Syntax: STUFF ( character_expression , start , length , replaceWith_expression ) SELECT STUFF ( 'JAINUL KHAN' , 7 , 0 , ' ABDEEN' ); Returns: --------------------- JAINUL ABDEEN KHAN ---------------------

Calling a function inside a function asynchronously using JQuery

var Test; $( function () { var ServicePath = rootPath + "Services/TestService.asmx/" ; var ajxcalls = function (methodname, param, success, error) {         $.ajax({             type: "POST" ,             contentType: "application/json; charset=utf-8" ,             cache: false ,             async: false ,             url: ServicePath + methodname,             data: param,             dataType: 'json' ,             success: success,             error: error         });     };     Test = {         Init: function () {             Test.TestCheck();         },         TestCheck: function () {

SQL Server 2012 FORMAT Function vs. CONVERT Function

One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format. Here's a summary of the different date formats that come standard in SQL Server as part of the  CONVERT  function and the corresponding syntax using the new SQL Server 2012 FORMAT string function. Following the standard date formats are some extended date formats that are often asked by SQL Server developers, together with the corresponding syntax as well using the new SQL Server 2012 FORMAT string function. It is worth to note that the outputs of these date formats are of VARCHAR data types already and not of  DATETIME  data type. With this in mind, any date comparisons performed after the datetime value has been formatted are using the VARCHAR value of the date and time and not its original  DATETIME  value. The SQL statements used below to return the different date formats use the SYSDATETIME() date function. The SYSDATETIME() function returns a datet…

Execute a Stored Procedure Continuously For a Specific Number of Times

I have an Insert Stored Procedure an I want to execute it to 10,00,000 times to put some dummy data in my table, for this I used this…. DECLARE @Counter INT SET @Counter = 1 WHILE ( @Counter <= 1000000 ) BEGIN EXEC [dbo] . [usp_Aspx_SaveValues] 1 , 8 , 1 , 0 SET @Counter = @Counter + 1 END

Bulk SMS Provider's List in Nepal

1. Telirivet 2. Weblink Nepal 3. Hamro SMS 4. Bulk SMS

Using J-Query as a Code Behind in AspxCommerce (Open Source E-Commerce)

If you want to make your own module in AspxCommerce this technique will be helpful to you. 1. add control to your module 2. add Test.js in your module 3. in Test.js copy and paste the code as under. 4. Do all operations here as a code behind in your Asp.Net page.  var TestPage = '';     $(function () {             var ModuleServicePath = modulePath + "Services/WebService.asmx/";         var aspxCommonObj = {             StoreID: 1,             PortalID: 1,             UserName: "username",             CultureName: "en_US",             CustomerID: 25         };         TestPage = {             config: {                 isPostBack: false,                 async: false,                 cache: false,                 type: 'POST',                 contentType: "application/json; charset=utf-8",                 data: '{}',                 dataType: 'json',                 baseURL: AspxCommerce.utils.GetAspxServicePath()…

A/B Testing Slide

Active Directory Services Step by Step

Implementing Active Directory Service in Asp.net is described in three steps     1. Web.Config Settings.     2. Source Files for Logic.     3. Asp.net Pages to Implement.     1. Web.Config : < configSections >                < section name = " ldapConfiguration " type = " Application.Security.ActiveDirectoryConfiguration " allowLocation = " true " allowDefinition = " Everywhere " /> </ configSections > < ldapConfiguration enabled = " true " pageLevelSecurityCheck = " false