dampee

-- 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

dampee

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

dampee

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

dampee

using System.Web.Http;
using System.Collections.Generic;
using Umbraco.Core.Models;
using Umbraco.Web.WebApi;

namespace Our.Umbraco
{
    public class UpgradeHelperController : UmbracoAuthorizedApiController
    {
        [HttpGet()]

dampee

    /// <summary>
    /// Lorem Ipsum Generator
    /// </summary>
    /// <remarks>
    /// Based on Javascript Version of Marcus Campbell - Version 2.0 (Copyright 2003 - 2005) 
    /// Open-source code under the GNU GPL: http://www.gnu.org/licenses/gpl.txt 
    /// </remarks>
    /// <example>
    /// LoremIpsumBuilder _lib = new LoremIpsumBuilder();
    /// string test = _lib.GetLetters();

dampee

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>

dampee

using System;
using System.Configuration;
using System.Linq;
using System.Reflection;
using System.Threading;
using System.Threading.Tasks;
using log4net;

namespace Utils
{

dampee

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

[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

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