ritacse

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

ritacse

Getting Started with Cacher

Use snippets to quickly recall commands

Snippets are the most useful when you want to re-use a shell command or a specific code pattern. Here are a few we have in our library:

ritacse

DateTime firstDate = orderDt.AsEnumerable().Select(cols => cols.Field<DateTime>("Ship Date")).OrderBy(p => p.Ticks).FirstOrDefault();
DateTime LastDate = orderDt.AsEnumerable().Select(cols => cols.Field<DateTime>("Ship Date")).OrderByDescending(p => p.Ticks).FirstOrDefault();
                   
    DateTime maxDate = firstDate.AddMonths(1);

    if (maxDate < LastDate)
    {
      // Do something.
    }

ritacse

/*Removes all elements from the plan cache, removes a specific plan from 
the plan cache by specifying a plan handle or SQL handle, 
or removes all cache entries associated with a specified resource pool.*/

EXEC DBCC FREEPROCCACHE

ritacse

TransferDt.Columns.Add("Receive Qty");  // Add column
TransferDt.Columns["Receive Qty"].SetOrdinal(24); // set column position
TransferDt.Columns["buyer_po_number"].ColumnName = "PO Number";
TransSpecDt.AcceptChanges();

grdProductTransfar.Columns["Code"].Visible = false;
grdProductTransfar.Columns["Receive Qty"].DefaultCellStyle.BackColor = Color.LightGoldenrodYellow;


int index = grdProductTransfar.SelectedCells[0].ColumnIndex;

ritacse

 // send parameter 
 var url = '../ApprovalReportViewer.aspx?docBaseId=' + aData.Doc_Type + "&docCode=" + aData.Code + "&docVersion=" + aData.Version;
     window.open(url, '_blank');   // <- This is what makes it open in a new window.     
     
     
     //Get parameter 
    var docBaseId = $.url().param('docBaseId');
    var docCode = $.url().param('docCode');
    var docVersion = $.url().param('docVersion');
    

ritacse

 IF EXISTS(SELECT * FROM [dbo].[PRoll_Company_Monthly_Salary_T_X] WHERE CompSalaryMonth =@month AND [CompSalaryYear] =@Year )
			BEGIN
			---DO something here
			END

ritacse

$(".txtNumber").alphanum({ allowLatin: false, maxLength: 7 });

$(".txtDesimal").numeric({
    allowMinus: false,
    allowThouSep: false,
    maxDigits: 11,
    maxDecimalPlaces: 2
});

$(".txtPhone").alphanum({ allow: '-+,', allowLatin: false });

ritacse

//tab wise excel export from dataset with multiple table

    if (yarnDS != null && yarnDS.Tables.Count > 0)
    {
        var wb = new XLWorkbook();
        var wsCom = wb.Worksheets.Add("Company Job");
        wsCom.Cell(1, 1).InsertTable(yarnDS.Tables[0].AsEnumerable());
        var wsB = wb.Worksheets.Add("Buyer Company Job");
        wsB.Cell(1, 1).InsertTable(yarnDS.Tables[1].AsEnumerable());
        var wsR = wb.Worksheets.Add("Rejected Yarns");

ritacse

<style>
       .blink {
                  animation: blink-animation 1s steps(5, start) infinite;
                  -webkit-animation: blink-animation 1s steps(5, start) infinite;
                }
                @keyframes blink-animation {
                  to {
                    visibility: hidden;
                  }
                }