Context Menu in Jquery

 contextMenu.js
contextMenu.css


$.contextMenu({
    selector: '#tblAmendGrid tr:gt(0)',
    callback: function (key, options) {
        switch (key) {
            case 'Delete':
                deleteAmendmentInfo($(this).children('td:eq(0)').text());
                break;
        }
    },
    items: {
        "Delete": { name: "Delete", icon: "edit" }
    }

});

design pattern

http://www.oodesign.com/
https://sourcemaking.com/design_patterns

Datediff in sql in hour minute second

insert into [DBL_Group].[dbo].[tblGmMachineZeroHour]( fldDate,                  fldOrderNo,     fldUnit,   [fldLine], fldMachineName, fldMachineQty,fldReasonKey,fldFrom,   [fldTo],   fldTotalTime,[fldReason])
SELECT
     Cast( fldDate  as Date),  [fldOrderNo],   [fldUnit],    [fldLine],[fldMachineName],[fldMachineQty],[fldReasonKey], [StartProblem],[Confirmation],
     CAST(DATEADD(MINUTE,DATEDIFF(MINUTE,[StartProblem],[Confirmation]),'1900-01-01 00:00:00.000') AS Datetime)   ,
    
     [fldReason]   
    
  FROM [DBL_Group].[dbo].[tblGmMachineZeroHourTest]   where [StartProblem] is not null and  [Confirmation] is not null
  and  DATEDIFF(Day,[StartProblem],[Confirmation])<1 and fldReasonKey is not null

Uploading Image to Server using jquery c#

    $("#avatarUpload").on('change', function () {

        previewFile();
    });

    var imgBase64;
    function previewFile(evt) {
        // var preview = document.querySelector('#<%=Avatar.ClientID %>');
       // var files = evt.target.file;
        var preview = document.getElementById('avatarImg');
        //$('#avatarImg');
      //  var file = document.querySelector('#avatarUpload').files[0];
        var input = document.getElementById('avatarUpload');
        var dv = document.getElementById('showImg');
        var file = input.files[0];
        console.log(file);
        var reader = new FileReader();

        reader.onloadend = function () {
            preview.src = reader.result;
            dv.value = reader.result;
            imgBase64 = reader.result;
            imgBase64 = imgBase64.replace('data:image/png;base64,', '');
            imgBase64 = imgBase64.replace('data:image/gif;base64,', '');
           // console.log(btoa(reader.result))
        }

        if (file) {
           // alert('file found');
             reader.readAsDataURL(file);
           // reader.readAsArrayBuffer(file)

           // reader.readAsBinaryString(file);
        } else {
            preview.src = "";
        }
    }



       // var image = document.getElementById("avatarImg").toDataURL("image/png");
     var   image = imgBase64.replace('data:image/jpeg;base64,', '');

        $.ajax({
            type: "POST",
            url: base + "TPWL/InsertImage",
            dataType: "JSON",
            data: JSON.stringify({ "obj": image }),
            contentType: "application/json;charset=utf-8",
            success: function (data) {
                console.log(data);
                if (data.ResultID != '-1') {
                    $("#spInfo").html('<strong style="color:green">' + data.Message + '</strong>');
                    $("#tblDetails tr:gt(0)").remove();
                    if (data.obj != null) {
                        AppenHeadData(data.obj.OrderHead);
                        AppendDetailsTable(data.obj.OrderDetailsDetails)
                    }
                }
                else {
                    $("#spInfo").html('<strong style="color:red">' + data.Message + '</strong>');
                }


            },
            error: function (a, b, c) {
                alert(a + '..' + c.statusCode);
                // alert(a.statusText);
            }

        });


    });


<div style=" text-align:center;">
    <input id="avatarUpload" type="file" name="files[]" accept="image/*" />
    <img width="60" height="60" src="123.jpg" id="avatarImg" />

    <input type="button"  value="Image Upload" id="tbnImgUpload"/>

    <textarea id="showImg"></textarea>
</div>

Get index List of A Table

exec sp_helpindex tblKnittingQAOfflineInspaction

Adding Genymotion in Android Studio

1)Go to Setting in android studion, then go to Plugin ,serach for Genymotion,Choose Download and Instal
2) Restatrt Android Studio, You will see Android ICON

Dynamic Column in PIVOT in SQL 2

 
  DECLARE @buyerName AS VARCHAR(MAX),
  @buyerName1 AS VARCHAR(MAX),
    @query AS VARCHAR(MAX)
   
    SET @buyerName1=STUFF((SELECT  Distinct ',Isnull('+ QUOTENAME(  Rtrim( Ltrim(O. fldBuyer)) )+',0)'+QUOTENAME(  Rtrim( Ltrim(O. fldBuyer))) from tblGreyFabricDelivery D inner join tblGreyFabricOrderDetails O
    on D.fldID=O.fldID where  O. fldBuyer !='0' and  (Cast(D.fldDeliveryDAte as Date ) between '01-jan-2015' and  '20-jan-2015') 
    FOR XML PATH(''),TYPE).value('.','VARCHAR(MAX)'),1,1,'')
   
    SET @buyerName=STUFF((SELECT  Distinct ','+ QUOTENAME(  Rtrim( Ltrim(O. fldBuyer)) ) from tblGreyFabricDelivery D inner join tblGreyFabricOrderDetails O
    on D.fldID=O.fldID where  O. fldBuyer !='0' and  (Cast(D.fldDeliveryDAte as Date ) between '01-jan-2015' and  '20-jan-2015') 
   
    FOR XML PATH(''),TYPE).value('.','VARCHAR(MAX)'),1,1,'')
 
  SET @query='Select fldDeliveryDAte,'+@buyerName1+' FROM

(
select Cast(fldDeliveryDAte as Date) fldDeliveryDAte , Rtrim( Ltrim(O. fldBuyer))fldBuyer, Sum(fldDeliveryQuantity) Qty  from tblGreyFabricDelivery D inner join tblGreyFabricOrderDetails O
  on D.fldID=O.fldID where  O.fldBuyer !=''0''
   and ( cast(  D.fldDeliveryDAte as Date) between ''01-jan-2015'' and  ''20-jan-2015'')

  Group by Cast(fldDeliveryDAte as Date) , O.fldBuyer
 
 
)
A
PIVOT(Sum(Qty) FOR fldBuyer IN ('+@buyerName+'))P order by fldDeliveryDAte';
exec (@query);
 

Dynamic Column in Pivot in SQL

DECLARE @processID AS VARCHAR(MAX),
@query AS VARCHAR(MAX)
SET @processID=STUFF((SELECT ','+QUOTENAME( ParameterCaption+'//'+CAST(ProcessParameterID AS VARCHAR)+'//'+ProcessName) FROM dbo._TBL_RnDProcessParameter  R INNER JOIN dbo._TBL_RnDProcess P ON P.RnDProcessID=R.ProcessID
WHERE R.IsActive=1 FOR XML PATH(''),TYPE).value('.','VARCHAR(MAX)'),1,1,'')
SET @query=' SELECT RnDNo,BuyerName,OrderNo,SampleType,Color,Note,RequiredWidth,RequiredGSM,'+@processID+' FROM
(SELECT * FROM
(SELECT ProcessDataHeadID,ParameterCaption+''//''+CAST(A.ProcessParameterID AS VARCHAR)+''//''+ProcessName AS FabricHead, COALESCE(Value,'''')Value FROM
(SELECT ParameterCaption,ProcessParameterID,ProcessID FROM dbo._TBL_RnDProcessParameter
WHERE IsActive=1)A
LEFT OUTER JOIN
(SELECT ProcessParameterID,Value,ProcessDataHeadID FROM dbo._TBL_RnDProcessData)B
ON B.ProcessParameterID=A.ProcessParameterID
INNER JOIN
dbo._TBL_RnDProcess P ON P.RnDProcessID=A.ProcessID
)A
PIVOT(MAX(Value) FOR FabricHead IN ('+@processID+'))P
WHERE ProcessDataHeadID IS NOT NULL
)A
LEFT OUTER JOIN
dbo._TBL_RnDProcessDataHead H
ON H.ProcessDataHeadID=A.ProcessDataHeadID
';
EXEC(@query);