Skip to content

Instantly share code, notes, and snippets.

Avatar

Damiaan dampee

View GitHub Profile
@dampee
dampee / updatescript
Created May 29, 2020
Custom tables from OUR umbraco
View updatescript
GO
/****** Object: Schema [HangFire] Script Date: 19-May-20 16:26:21 ******/
CREATE SCHEMA [HangFire]
GO
/****** Object: Table [dbo].[cmsTagToTopic] Script Date: 19-May-20 16:26:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
View RetryHelperAsync.cs
using System;
using System.Configuration;
using System.Linq;
using System.Reflection;
using System.Threading;
using System.Threading.Tasks;
using log4net;
namespace Utils
{
@dampee
dampee / AzureStorageStorageHelper.cs
Created Jan 15, 2019
Clean azure blob storage container name
View AzureStorageStorageHelper.cs
public static bool IsValidContainer(string containerName)
{
// Container names must be valid DNS names, and must conform to these rules:
// * Container names must start with a letter or number, and can contain only letters, numbers, and the dash (-) character.
// * Every dash (-) character must be immediately preceded and followed by a letter or number; consecutive dashes are not permitted in container names.
// * All letters in a container name must be lowercase.
// * Container names must be from 3 through 63 characters long.
// $root is a special container that can exist at the root level and is always valid.
if (containerName.Equals("$root"))
@dampee
dampee / generate_dto.sql
Last active Feb 28, 2020 — forked from evgeny-myasishchev/generate_dto.sql
TSQL script to generate POCO/DTO from database table
View generate_dto.sql
DECLARE @tableName NVARCHAR(MAX), @schemaName NVARCHAR(MAX), @className NVARCHAR(MAX)
--------------- Input arguments ---------------
SET @tableName = 'MyTableName'
SET @schemaName = 'dbo'
SET @className = @tableName + 'Dto'
--------------- Input arguments end -----------
DECLARE tableColumns CURSOR LOCAL FOR
SELECT cols.name, cols.system_type_id, cols.is_nullable FROM sys.columns cols
View ChargebeeController.cs
[RoutePrefix("Chargebee")]
public class ChargebeeController : ApiController
{
private readonly ILoggingService _loggingService;
private readonly TicketCountRepository _ticketCountRepository;
private readonly IBusinessRepository _businessRepository;
private readonly IBus _bus;
public ChargebeeController(ILoggingService loggingService, TicketCountRepository ticketCountRepository, IBusinessRepository businessRepository,
IBus bus)
@dampee
dampee / MediaController.cs
Created Dec 28, 2018
Reproduction of U4-9904
View MediaController.cs
using System.IO;
using System.Linq;
using System.Net;
using System.Web.Http;
using Umbraco.Core.Models;
using Umbraco.Web.WebApi;
namespace U4_9904.Controllers
{
public class MediaTestController : UmbracoApiController
@dampee
dampee / MediaExportController.cs
Created Jan 27, 2017
export media library (umbraco v6 + umbraco v7)
View MediaExportController.cs
using System;
using System.IO;
using System.Web.Hosting;
using Umbraco.Core;
using Umbraco.Core.Logging;
using Umbraco.Core.Models;
using Umbraco.Web;
using Umbraco.Web.WebApi;
/// <summary>
View CustomVersionProvider.cs
public class CustomVersionProvider : IVersionProvider
{
private Lazy<string> _productVersion = new Lazy<string>(() =>
{
var assembly = Assembly.GetExecutingAssembly();
var assemblyVersion = assembly.GetName().Version;
var productVersion = string.Format("{0}.{1}.{2}", assemblyVersion.Major, assemblyVersion.Minor, assemblyVersion.Build);
// additional info
var dateFormat = "dd.MM.yyyyTHH:mm:ss";
productVersion += string.Format(" (built: {0}) (LastWriteTime: {1})",
@dampee
dampee / dunittest.snippet
Last active Dec 21, 2016
Unittest snippet for visual studio
View dunittest.snippet
<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
<CodeSnippet Format="1.0.0">
<Header>
<SnippetTypes>
<SnippetType>Expansion</SnippetType>
</SnippetTypes>
<Title>dunittest</Title>
<Author>
</Author>
@dampee
dampee / getmedia.cs
Last active May 18, 2017
Search media on nodename without descendants
View getmedia.cs
var internalSearchProvider = ExamineManager.Instance.SearchProviderCollection["InternalSearcher"];
var query = ExamineManager.Instance.CreateSearchCriteria()
.NodeTypeAlias("image")
.And().NodeName("Desert.jpg".ToLowerInvariant())
.Compile();
var results = Umbraco.TypedSearch(query, internalSearchProvider);
You can’t perform that action at this time.