Danny Lloyd dannylloyd

dannylloyd / Read from Excel.cs

Last active December 8, 2020 20:29

Read data from Excel file using EPPLUS

	var path = @"C:\Temp\Path-To-File.xlsx";
	using (var pck = new OfficeOpenXml.ExcelPackage())
	{
	using (var stream = File.OpenRead(path))
	{
	pck.Load(stream);
	}
	var ws = pck.Workbook.Worksheets.First();

	for (int rowNum = 1; rowNum <= ws.Dimension.End.Row; rowNum++)

dannylloyd / Box starter missing things.ps1

Last active April 12, 2019 15:05

dannylloyd / ParseEnum.cs

Created September 18, 2018 13:19

How to parse an enum


	//From String
	var result = (EnumNameHere)Enum.Parse(typeof(EnumNameHere), stringValue);
	//From Integer
	var result = (EnumNameHere)integerValue;
	//To Integer
	var result = (int)enumValue;
	//To String
	var result = enumValue.ToString();

dannylloyd / Regex.txt

Created July 30, 2018 15:59

Regex Helpers

	Find word inside quotes
	"(.?\b(followup)\b.?)"
	Example text: var followup = "this is a followup ";

dannylloyd / mencoder.bat

Last active May 14, 2018 14:34

Mencoder timelapse

	#Run this in the directory where the images are located. Either add mencoder to path or use the full path to mencoder
	"C:\DevOps\Utils\VideoUtils\mencoder.exe" -nosound -ovc lavc -lavcopts vcodec=mpeg4:aspect=4/3:vbitrate=8000000 -vf scale=640:512 -o "timelapse-%DATE:/=-%@%TIME::=-%.avi" -mf type=jpeg:fps=24 mf://*.jpg

dannylloyd / CustomRazorDisplayAndEditorTemplates.cshtml

Created October 12, 2017 18:19

	See this link
	http://www.growingwiththeweb.com/2012/12/aspnet-mvc-display-and-editor-templates.html

	need to add examples here

dannylloyd / GetTableRowCounts.sql

Created September 27, 2017 14:59

Gets row counts for all tables in database

	CREATE TABLE #counts
	(
	table_name varchar(255),
	row_count int
	)

	EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
	SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC
	DROP TABLE #counts

dannylloyd / BoxStarter Home.ps1

Last active December 13, 2016 16:12

	#http://boxstarter.org/package/nr/url?
	Set-ExplorerOptions -showHiddenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
	Set-TaskbarOptions -Size Large -Lock -Dock Bottom -Combine Never
	Enable-RemoteDesktop

	choco install dotnet4.5
	choco install dotnet4.5.1
	choco install dotnet4.5.2
	choco install dotnet4.6
	choco install DotNet3.5

dannylloyd / Boxstarter.ps1

Last active June 14, 2019 17:29

	#http://boxstarter.org/package/nr/url?
	Set-ExplorerOptions -showHiddenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
	Set-TaskbarOptions -Size Large -Lock -Dock Bottom -Combine Never
	Enable-RemoteDesktop

	choco install googlechrome
	choco install dotnet4.5
	choco install dotnet4.5.1
	choco install dotnet4.5.2
	choco install dotnet4.6

dannylloyd / BoxstarterWork.ps1

Last active April 9, 2019 13:27

	#http://boxstarter.org/package/nr/url?
	Set-ExplorerOptions -showHiddenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
	Set-TaskbarOptions -Size Large -Lock -Dock Bottom -Combine Never
	Enable-RemoteDesktop

	choco install googlechrome
	choco install dotnetfx
	choco install dotnet4.5
	choco install dotnet4.5.1
	choco install dotnet4.5.2