06 March, 2014

How To Check Javascript Fuction Available OR Not

Problem:
Some time we need to call javascript function which is based on some condition or may pass as parameter and then call that function. In this case we need to check whether this javascript function available or not if available then we call it otherwise not.

 HTML:
<input id="test" value="Available" onclick="ISfuctionAvailable();" type="button"/>
 
<input id="test1" value="Not available" onclick="fuctionNotAvailable();" type="button"/>

Javascript:
function ISfuctionAvailable() {
    if (typeof fuctionNotAvailable == 'function') {
        alert('Function available');
        //You can call function like  fuctionNotAvailable();
    }
    else {
        alert('Function Not available');
    }
}
 
function fuctionNotAvailable() {
    if (typeof test5 == 'function') {
        alert('Function available');
    }
    else {
        alert('Function Not available');
    }
}

Demo:
http://jsfiddle.net/patelriki13/drwdG/




















02 March, 2014

How to pass an event object to a function in Javascript?

HTML:
<input type="button" value="click me" onclick="ButtonClick(event);" /> 
 
Javascript:
function ButtonClick(e, button) {
    alert(e.type);
    alert("Button Click...!");
}

Pass "event" keyword in onclick function and also you pass extra argument after that like


HTML:
<input type="button" value="click me" onclick="ButtonClick(event, this);" /> 
 
Javascript:
function ButtonClick(e, button) {
    alert(e.type);
    alert("Button Click...!");
}

Demo:
http://jsfiddle.net/patelriki13/2zuef/








27 February, 2014

Kendo Grid

Following Links are for Kendo Grid Solution


25 February, 2014

Generate class from database table in C#


Using SQL Query:
DECLARE @TableName VARCHAR(MAX) = 'Users'
DECLARE @TableSchema VARCHAR(MAX) = 'dbo'
DECLARE @result varchar(max) = ''
 
SET @result = @result + 'using System;' + CHAR(13) + CHAR(13) 
 
IF (@TableSchema IS NOT NULL) 
BEGIN
    SET @result = @result + 'namespace ' + @TableSchema  + CHAR(13) + '{' + CHAR(13) 
END
 
SET @result = @result + '    public class ' + @TableName + CHAR(13) + '    {' + CHAR(13) 
 
SET @result = @result + '        #region Instance Properties' + CHAR(13)  
 
SELECT @result = @result + CHAR(13) 
    + '        public ' + ColumnType + ' ' + ColumnName + ' { get; set; } ' + CHAR(13) 
FROM
(
    SELECT  c.COLUMN_NAME   AS ColumnName 
        , CASE c.DATA_TYPE   
            WHEN 'bigint' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Int64?' ELSE 'Int64' END
            WHEN 'binary' THEN 'Byte[]'
            WHEN 'bit' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Boolean?' ELSE 'Boolean' END            
            WHEN 'char' THEN 'String'
            WHEN 'date' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                        
            WHEN 'datetime' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                        
            WHEN 'datetime2' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                        
            WHEN 'datetimeoffset' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTimeOffset?' ELSE 'DateTimeOffset' END                                    
            WHEN 'decimal' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                    
            WHEN 'float' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Single?' ELSE 'Single' END                                    
            WHEN 'image' THEN 'Byte[]'
            WHEN 'int' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Int32?' ELSE 'Int32' END
            WHEN 'money' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                                
            WHEN 'nchar' THEN 'String'
            WHEN 'ntext' THEN 'String'
            WHEN 'numeric' THEN
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                                            
            WHEN 'nvarchar' THEN 'String'
            WHEN 'real' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Double?' ELSE 'Double' END                                                                        
            WHEN 'smalldatetime' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                                    
            WHEN 'smallint' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Int16?' ELSE 'Int16'END            
            WHEN 'smallmoney' THEN  
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Decimal?' ELSE 'Decimal' END                                                                        
            WHEN 'text' THEN 'String'
            WHEN 'time' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'TimeSpan?' ELSE 'TimeSpan' END                                                                                    
            WHEN 'timestamp' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'DateTime?' ELSE 'DateTime' END                                    
            WHEN 'tinyint' THEN 
                CASE C.IS_NULLABLE
                    WHEN 'YES' THEN 'Byte?' ELSE 'Byte' END                                                
            WHEN 'uniqueidentifier' THEN 'Guid'
            WHEN 'varbinary' THEN 'Byte[]'
            WHEN 'varchar' THEN 'String'
            ELSE 'Object'
        END AS ColumnType
        , c.ORDINAL_POSITION 
FROM    INFORMATION_SCHEMA.COLUMNS c
WHERE   c.TABLE_NAME = @TableName and ISNULL(@TableSchema, c.TABLE_SCHEMA) = c.TABLE_SCHEMA  
) t
ORDER BY t.ORDINAL_POSITION
 
SET @result = @result + CHAR(13) + '        #endregion Instance Properties' + CHAR(13)  
 
SET @result = @result  + '    }' + CHAR(13)
 
IF (@TableSchema IS NOT NULL) 
BEGIN
    SET @result = @result + '}' 
END
 
PRINT @result


Output:
using System;

namespace dbo
{
    public class Users
    {
        #region Instance Properties

        public Int32 SysID { getset; } 

        public String UserID { getset; } 

        public String UserName { getset; } 

        public String Password { getset; } 

        public String emailID { getset; } 

        public Boolean IsActive { getset; } 

        public DateTime CreatedWhenDtm { getset; } 

        public String CreatedBy { getset; } 

        public DateTime UpdatedWhenDtm { getset; } 

        public String UpdatedBy { getset; } 

        #endregion Instance Properties
    }
}

21 February, 2014

Pass Javascript Array to Controller via AJAX in MVC


Create JavaScript Array: 
var stringArray = new Array();
stringArray .push("1");
stringArray .push("2");
stringArray .push("3");
Ajax Call:
    $.ajax({
        type: 'POST',
        url: '/Controller/View',
        traditional: true,
        dataType: "json",
        data: { methodParam: stringArray },
        success: function (data) {
            alert("success");
        },
        error: function (args) {
            alert("Error on ajax post");
        }
    })
Controller: 
[HttpPost]
public ActionResult TutorAvailability(string[] methodParam)

15 February, 2014

MSMQ cannot delete or purge a queue


I think there is rights issue.
You are not able to give rights then do following step for forcefully delete queue.
  1. Stop following services
Message Queuing Triggers,
Net.Msmq Listener Adapter
Message Queuing.
  1. Go to C:\Windows\System32\msmq\storage\lqs
  2. Now open file in notepad or notepad++ and
    see the name of queue at QueueName=\private$\YourQueueName
  3. Before delete file backup the file. Now delete that file.
  4. Don't delete other file which does not have your queue name.
  5. Do these things as your own risk.
  6. Now start following services
Message Queuing Triggers,
Net.Msmq Listener Adapter
Message Queuing.
This trick work for me...