profiiqus

using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;

namespace Main;

/// <summary>
/// Service builder class.
/// </summary>
public static class ServiceBuilder

profiiqus

namespace DependencyInjectionTest;

public interface IDatabaseService
{
    public void DoStuff();
}

profiiqus

CREATE FUNCTION WORKING_DAY_OF_MONTH
(
    @DayIndex INT,      -- Searched day index
    @Month INT,         -- Month
    @Year INT           -- Year
)
RETURNS INT AS 
BEGIN
    DECLARE @Index INT = 1
    DECLARE @DaysFound INT = 0

profiiqus

STUFF(
  (
    SELECT ', ' +  mt.[TextValue]
    FROM dbo.[MultiSelect] AS ms
      LEFT JOIN usr.[MonthType] AS mt ON mt.[Ident] = ms.[Value] AND mt.[LanguageID] = @UserLanguageID
    WHERE
      ms.[TableID] = at.[ID]
      AND ms.[FormIdent] = @FormIdent
      AND ms.[ControlIdent] = @ControlIdent
    FOR xml path('')

profiiqus

CREATE FUNCTION [dbo].[StringSplit] (
	@stringToSplit NVARCHAR(MAX),
	@splitCharacter NVARCHAR(1)
)
RETURNS
 @returnList TABLE ([Name] [nvarchar] (500))
AS
BEGIN

 DECLARE @name NVARCHAR(255)

profiiqus

// ICommand interface to extend the commands from
interface ICommand
    {
        void ExecuteCommand();
    }

// First command
class HelloCommand : ICommand
    {
        public void ExecuteCommand()