csharpforevermore

Frontend Development

Looking for something else? Take a look at the awesome collection of other awesome lists.

• Guides
  • Bento: a collection of guides for web development.
  • Hack Design: An easy to follow design course for people who do amazing things.
  • Designer School: A group of passionate professionals teaching web development
  • Web Style Guide - 3^rd Edition covers all the elements from CSS and typography to HTML and the structure of prose.
• Talks To Help You Become A Better Front-End Engineer In 2013

csharpforevermore

<#
Rename-Files.ps1
#>


# Find all wmv-files with a string "oldstring" and replace "oldstring" with "newstring" in the filename
Get-ChildItem *.wmv -Filter "*oldstring*" | ForEach { Rename-Item $_ -NewName $_.Name.Replace("oldstring","newstring") }


# Change the file extension of all .jpeg files to .jpg

csharpforevermore

-- Umbraco Clear Old Document Versions To Decrease Database Size And Improve Performance
-- http://borism.net/2008/12/16/fixing-a-large-cmspropertydata-table-in-umbraco/
DECLARE @createdDate Datetime = DATEADD(m, -1, getdate())

-- dump logs
-- TRUNCATE TABLE umbracolog -- faster if log table is very big and you don't need anything
DELETE FROM umbracolog WHERE Datestamp < @createdDate

-- clean up old versions
DELETE FROM cmsPropertyData WHERE

csharpforevermore

DB

SQL Cheatsheet

• https://github.com/enochtangg/quick-SQL-cheatsheet - A quick reminder of all relevant SQL queries and examples on how to use them.

DB Diagrams

• https://dbdiagram.io/ - A free and simple tool to draw ER diagrams by just writing code.

Misc

csharpforevermore

SELECT STRAIGHT_JOIN categories.id, categories.title, categories.game_count, categories.display_order FROM `categories` INNER JOIN `category_namespaces` ON `category_namespaces`.`category_id` = `categories`.`id` WHERE `categories`.`type` IN ('ClickJogos::GameCategory') AND `categories`.`published` = 1 AND (category_namespaces.namespace = 'jgo') ORDER BY 
CASE
WHEN categories.id LIKE '447%' THEN 1
WHEN categories.id LIKE '448%' THEN 2
ELSE 3
END, categories.game_count DESC;

csharpforevermore

import numpy
import pandas

numpy.random.seed(0)
index1 = pandas.MultiIndex.from_product(
    [['A'], ['b'], ['one', 'two']],
    names=['City', 'Street', 'House']
)

index2 = pandas.MultiIndex.from_product(

csharpforevermore

import glob
import sys
import pandas


def read_filenames(names):
    for arg in names:
        if "*" in arg:
            for file in glob.glob(arg):
                yield file

csharpforevermore

csharpforevermore

if (fuImage.HasFile)
{
  PostedMediaFile postedMediaFile = new PostedMediaFile
  {
      ContentLength = fuImage.PostedFile.ContentLength,
      ContentType = fuImage.PostedFile.ContentType,
      FileName = fuImage.PostedFile.FileName,
      InputStream = fuImage.PostedFile.InputStream
  };
  Media media = MediaFactory.GetMediaFactory(-1, postedMediaFile, new umbraco.BusinessLogic.User(0)).HandleMedia(-1, postedMediaFile, new umbraco.BusinessLogic.User(0), true);

csharpforevermore

public static bool UploadToServer(string pathToFile)
{
        bool failure = false;
 
        if (!FileUpload1.FileName.ToLowerInvariant().EndsWith(".xml")) {
        failure = true;
        }
        StreamReader reader = new StreamReader(FileUpload1.FileContent);
        string xmlContent = reader.ReadToEnd();
        if (!xmlContent.TrimStart().StartsWith("<?xml")) {