Programming
Phone Number RegEx
For this I just wanted a basic regex for phone numbers, it’s all numeric with an optionaly starting “+”.
Azure
Hosting Multiple Sites in One Azure WebApp
Sometimes it’s necessary to host multiple sites under the same parent address, in Azure this can be done by deploying multiple projects to seperate folders within a single WebApp. To begin with you need to create a WebApp, once this has been created use the Console blade under Development Tools Read more…
Programming
Posting Data to an MVC Controller With jQuery
The easiest way to post data from a view to a controller action is by adding a form and submit button and letting most of the hard stuff happen automatically. Unfortunately this doesn’t really work in cases where data needs to be submitted by a javascript function, in these situations Read more…
Programming
Building URIs in .NET Core
Creating URIs with parameters in .NET Core is more complicated than I’d initially expected. As a result I ended up creating my own methods based upon this Stack Overflow answer. To begin with I needed a version to return relative paths I’ve also created a version to return a fully Read more…
Programming
Select List Enum Tag Helper
If you want to have a select list in a web page which is based on all the values in an enum then you can use the built in function “Html.GetEnumSelectList” with a tag helper.
Programming
Enum JSON Converter
In addition to the SingleOrArrayEnumConverter mentioned previously I’ve also created a version to translate enums to/from JSON using the name of the enum rather than it’s value as is the default. This can then be used to decorate your enum class like so.
Programming
SQL Stored Procedure in .NET Core
I call SQL stored procedures slightly differently in .NET Core to the way I did in .NET framework as I now pass the connection string through as an argument and I need to remember to add the System.Data.SqlClient NuGet package.
Programming
Downloading SFTP Files in Console Applications
I use the WinSCP dll to download files from SFTP sites in SSDT, as shown here, but this approach doesn’t work in .NET Core applications as the WinSCP dll isn’t available as a NuGet package. An alternative to WinSCP is SSH.NET, which amoung other things, has the ability to download Read more…
Programming
Downloading SFTP Files in SSDT
I often need to download files from an SFTP site in SQL Server Data Tools (SSDT), the best way I’ve found of doing this is a script task that hooks into WinSCP. WinSCP and it’s dlls can be downloaded here. Once installed, the dll should also be added to the Read more…
Uncategorised
Splitting Lists Into Chunks
Whilst writing a process to upload instore purchases to Facebook using their offline conversion API I discovered that their API only accepts a maximum of 2,100 events in any one API call. As I already ahd a nice list of events I had a look around and managed to find Read more…