shammelburg

On the server locate folder 
  a. C:\Windows\Microsoft.NET\Framework64\v4.0.30319 
  b. Check "aspnet_regiis.exe" exists
  
Run cmd
  a. cd C:\Windows\Microsoft.NET\Framework64\v4.0.30319
  
To Encrypt:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319>aspnet_regiis –pef "connectionStrings" "path" 
C:\Windows\Microsoft.NET\Framework64\v4.0.30319>aspnet_regiis –pef "appSettings" "path"

shammelburg

public void Convert(string Base64String)
{
    string fileName = "test.jpg";
    string rootpath = Server.MapPath(Path.Combine("~", "Image", fileName));
    ConvertBase64ToFile.ConvertToFile(rootpath, Base64String.Split(',')[1]);
}

public class ConvertBase64ToFile
{
    public static void ConvertToFile(string location, string file)

shammelburg

/*
npm install serve-static
npm install connect
http://localhost:5000/
*/

var connect = require("connect"), serveStatic = require("serve-static");
var server = connect();

server.use(serveStatic("."));

shammelburg

/* Add data-title to the <td> element like this <td data-title="column header here"></td> */

media only screen and (max-width: 900px) {

    /* Force table to not be like tables anymore */
    #no-more-tables table,
    #no-more-tables thead,
    #no-more-tables tbody,
    #no-more-tables th,
    #no-more-tables td,

shammelburg

// Add to Global.asax.cs
protected void Application_BeginRequest()
{
    if (Request.Headers.AllKeys.Contains("Origin") && Request.HttpMethod == "OPTIONS")
    {
        Response.Flush();
    }
}

shammelburg

<system.net>
  <mailSettings>
    <smtp deliveryMethod="Network">
      <network host="smtp.sendgrid.net" port="587" defaultCredentials="false" userName="azure_{{guid}}@azure.com" password="*********" />
    </smtp>
  </mailSettings>
</system.net>

shammelburg

-- return matching param or everything if null
where (Product = @myParam or @myParam is null)

shammelburg

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Web;

shammelburg

<system.webServer>
  <staticContent>
    <remove fileExtension=".woff" />
    <!-- In case IIS already has this mime type -->
    <mimeMap fileExtension=".woff" mimeType="application/x-font-woff" />
    <remove fileExtension=".woff2" />
    <!-- In case IIS already has this mime type -->
    <mimeMap fileExtension=".woff2" mimeType="application/x-font-woff2" />
  </staticContent>
</system.webServer>

shammelburg

select  ListPrice
	, Name
	, row_number() over (order by ListPrice desc) as 'row_number'
	, rank() over (order by ListPrice desc) as 'rank'
	, dense_rank() over (order by ListPrice desc) as 'dense_rank'
	, ntile(5) over (order by ListPrice desc) as 'ntile'
from Production.Product
where ProductSubcategoryID = 1
order by ListPrice desc