run js file

 run js or html file  from vscode

npm install -g live-server

live-server --port=8000

vscode html tips

 html vscode tips

create snippets

 snippet tool

paste the code inbody and tabtrigger is shortcut

in vscode goto preference go to generatesnippet.

sample file in git

date formate angular

 'short': equivalent to 'M/d/yy, h:mm a' (6/15/15, 9:03 AM).

'medium': equivalent to 'MMM d, y, h:mm:ss a' (Jun 15, 2015, 9:03:01 AM).

'long': equivalent to 'MMMM d, y, h:mm:ss a z' (June 15, 2015 at 9:03:01 AM GMT+1).

'full': equivalent to 'EEEE, MMMM d, y, h:mm:ss a zzzz' (Monday, June 15, 2015 at 9:03:01 AM GMT+01:00).

'shortDate': equivalent to 'M/d/yy' (6/15/15).

'mediumDate': equivalent to 'MMM d, y' (Jun 15, 2015).

'longDate': equivalent to 'MMMM d, y' (June 15, 2015).

'fullDate': equivalent to 'EEEE, MMMM d, y' (Monday, June 15, 2015).

'shortTime': equivalent to 'h:mm a' (9:03 AM).

'mediumTime': equivalent to 'h:mm:ss a' (9:03:01 AM).

'longTime': equivalent to 'h:mm:ss a z' (9:03:01 AM GMT+1).

'fullTime': equivalent to 'h:mm:ss a zzzz' (9:03:01 AM GMT+01:00).

 template: `<div>

   <p>Today is {{today | date}}</p>

   <p>Or if you prefer, {{today | date:'fullDate'}}</p>

   <p>The time is {{today | date:'h:mm a z'}}</p>

 </div>`

kendo grid date formate

 <kendo-grid-column field="dateField" width="220" title="Open Date">

    <ng-template kendoGridCellTemplate let-dataItem>
        {{dataItem.dateField | date: 'MM/dd/yyyy'}}
    </ng-template>
</kendo-grid-column>

sql group by

 

add sql total staff and sub and percentage it with round values.

 SELECT BRANCH, SUM(TotalStaff)AS TotalStaff ,

  SUM (SCRESSubscription)as SCRESSubscription,

CAST( ROUND(sum(SCRESSubscription) * 100.0 / sum( TotalStaff),2)as decimal(5,2)) as Percentage

  FROM BranchWiseDataBZANew21062021

  GROUP BY BRANCH 

Sql Query Mail

 send queries to mail daily schedule to on time

https://www.brentozar.com/archive/2014/10/send-query-results-sql-server-agent-job/

query

Angular production 404 error

 import {HushLocationStrategy,LocationStrategy}

providers:[{provdie:LocationStrategy,useClass:HashLocationStrategy}]

hide and show angular

 hide and show alternatly

decode jwt token

 

1. var handler = new JwtSecurityTokenHandler();
2. var decodedValue = handler.ReadJwtToken(token);

Use using System.IdentityModel.Tokens.Jwt;

filter only values from object list

 

// ES5
	var arrayObjects = [
	{
	name: "A",
	surname: "1"
	},
	{
	name: "B",
	surname: "2"
	},
	{
	name: "C",
	surname: "3"
	}
	];
	Array.prototype.map.call(arrayObjects, function(item) { return item.name; }).join(","); // "A,B,C"
	// ES6 / TypeScript
	const arrayObjects = [
	{
	name: "A",
	surname: "1"
	},
	{
	name: "B",
	surname: "2"
	},
	{
	name: "C",
	surname: "3"
	}
	];
	Array.prototype.map.call(arrayObjects, s => s.name).toString(); // "A,B,C" refer this site