Numeric Validation Using Jquery

                             Numeric Validation Using Jquery


$(".numeric").keypress(function () {
            debugger;
            // Allow only backspace and delete
            if (event.keyCode == 46 || event.keyCode == 8) {
                // let it happen, don't do anything
            }
            else {
             
                // Ensure that it is a number and stop the keypress
                if (event.keyCode < 48 || event.keyCode > 57) {
                    event.preventDefault();
                    alert('Enter only numeric value.');
                }
            }
        });
     
    });

DateTime Convert

                                    DateTime Convert

IN C#--

DateTime fdate = DateTime.Parse(txtFromDate.ToString());
                string FromDateD = fdate.ToString("dd-MM-yyyy");
                DateTime tdate = DateTime.Parse(txtFromDate.ToString());
                string ToDateD = tdate.ToString("dd-MM-yyyy");
            //DateTime FromDateD = new DateTime(Convert.ToInt32(txtFromDate.ToString().Split('/')[2]), Convert.ToInt32(txtFromDate.ToString().Split('/')[1]), Convert.ToInt32(txtFromDate.ToString().Split('/')[0]));
            //DateTime ToDateD = new DateTime(Convert.ToInt32(txtToDate.ToString().Split('/')[2]), Convert.ToInt32(txtToDate.ToString().Split('/')[1]), Convert.ToInt32(txtToDate.ToString().Split('/')[0]));

IN JQuery--

  var parts = mdyDate.split('/');

  var dmyDate = parts[1] + '/' + parts[0] + '/' + parts[2];

-----

   var FromDate = new Date(parseInt(data.FromDate.substr(6)));
  var FinalFromDate = $.datepicker.formatDate('dd/mm/yy', FromDate);

Paging in Stored procedure

                                    Paging in Stored procedure 


ALTER PROCEDURE [dbo].[GetStoreList]
    @PageSize int ,
    @PageNumber int,
@StoreName varchar(200)=null,
@PartType int=null,
@Status int=null

AS
BEGIN
IF(@PartType =4)
BEGIN
SET @PartType = Null
END

DECLARE @upperBound INT

IF @PageNumber  < 1 SET @PageNumber = 0                                
 SET @PageNumber  = @PageNumber  + 1                                
 IF @pageSize < 1 SET @pageSize = 1                                  
 SET @upperBound = @PageNumber + @pageSize

IF(@StoreName is not null)
BEGIN
SET @StoreName = '%' +  @StoreName + '%';
END

IF @PageNumber > 0
BEGIN
SET NOCOUNT ON;

    SELECT * FROM
(  
  SELECT
  [StoreId]
      ,[LoginId]
      ,[EmailId]
      ,[StoreName]
      ,[Address]
      ,[City]
      ,[State]
      ,[Country]
      ,[ZipCode]
      ,[ContactName]
      ,[ContactNo]
      ,[PartType]
      ,[Status]
      ,[PayType]
      ,[EnquiryCount]
 ,AP.Text AS PartTypeTxt
 ,ROW_NUMBER() OVER (order by CreatedDate Desc) as RowNumber
 , COUNT([StoreId]) OVER() AS TotalRecords
FROM Store S INNER JOIN ApplicationMaster AP ON S.PartType = AP.Value
WHERE StoreName LIKE ISNULL(@StoreName,StoreName)
AND PartType = ISNULL(@PartType, PartType)
AND [Status] = ISNULL(@Status, [Status])
) AS DT
Where DT.RowNumber >= @PageNumber and DT.RowNumber <= @upperBound

END
END

Datepicker validation

                          Datepicker validation

http://www.jquerybyexample.net/2012/01/end-date-should-not-be-greater-than.html