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);