Skip to content

Instantly share code, notes, and snippets.

View aramkoukia's full-sized avatar
🏠
Working from home

Aram Koukia aramkoukia

🏠
Working from home
View GitHub Profile
@aramkoukia
aramkoukia / StringBuilderVsStringInterpolation.cs
Created May 22, 2017 20:12
StringBuilderVsStringInterpolation
public class StringBuilderVsStringInterpolation
{
private string data1;
private string data2;
private string data3;
public StringBuilderVsStringInterpolation()
{
data1 = Guid.NewGuid().ToString();
data2 = Guid.NewGuid().ToString();
@aramkoukia
aramkoukia / .net core controller.cs
Created May 6, 2017 19:43
.net core controller
[Route("api/[controller]/[action]")]
public class ValuesApiController : ApiController
{
[HttpGet]
[ActionName("GetArray")]
public IEnumerable GetArray()
{
return new string[] { "value2", "value3" };
}
@aramkoukia
aramkoukia / configure .net core routes.cs
Created May 6, 2017 19:40
configure .net core routes
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
app.UseMvc(routes =>
{
routes.MapWebApiRoute("DefaultApi", "api/{controller}/{id?}");
});
}
@aramkoukia
aramkoukia / .net core configure web api.cs
Created May 6, 2017 19:39
.net core configure web api
public void ConfigureServices(IServiceCollection services)
{
// Add framework services.
services.AddMvc().AddWebApiConventions(); //Add WebApi
}
@aramkoukia
aramkoukia / angular-4-what's new.html
Created April 10, 2017 16:50
Angular 4 what's new
<div *ngIf="userList | async as users; else loading">
<user-profile *ngFor="let user of users; count as count" [user]="user">
</user-profile>
<div>{{count}} total users</div>
</div>
<ng-template #loading>Loading...</ng-template>
@aramkoukia
aramkoukia / upgrade-to-anfular-4.0.cmd
Created April 10, 2017 16:45
Upgrade angular app to latest version (4.0.0)
npm install 
@angular/common@latest 
@angular/compiler@latest 
@angular/compiler-cli@latest 
@angular/core@latest 
@angular/forms@latest 
@angular/http@latest 
@angular/platform-browser@latest 
@angular/platform-browser-dynamic@latest 
@angular/platform-server@latest 
@aramkoukia
aramkoukia / STUFF-XPATH-comma-separate-rows.sql
Created March 2, 2017 20:00
STUFF-XPATH comma separate rows
SELECT STUFF((
SELECT ','+ cast(Color AS nvarchar(255))
FROM NameColorTable b
WHERE a.Name = b.Name
FOR XML PATH('')),1,1,'') AS COLUMN2
FROM NameColorTable a
GROUP BY a.Name
@aramkoukia
aramkoukia / TSQL-COALESCE-comma-separate-rows.sql
Created March 2, 2017 19:57
TSQL COALESCE comma separate rows
DECLARE @List VARCHAR(8000)
SELECT @List = COALESCE(@List + ',', '') + CAST(Color AS VARCHAR)
FROM NameColorTable
SELECT @List
@aramkoukia
aramkoukia / deduplicatin-data-tsql.sql
Created March 2, 2017 19:51
TSQL Deduplicating data
;WITH myCTE (RowNumber, ProductId, ProductName)
AS (
SELECT ROW_NUMBER() OVER (
PARTITION BY ProductName ORDER BY ProductName
) AS RowNumber ,
ProductId ,ProductName FROM #Products
)
SELECT * FROM myCTE
@aramkoukia
aramkoukia / dom-parser.js
Created February 27, 2017 21:54
DOMParser sample
let doc = new DOMParser().parseFromString('<div>first div content</div><div>second div content</div>', 'text/html');
let firstDiv = doc.body.firstChild;
let secondDiv = firstDiv.nextSibling;