117 changed files with 1464 additions and 1720 deletions
--- a/src/WorkFlow.API/Attributes/APIKeyAuthAttribute.cs
+++ b/src/WorkFlow.API/Attributes/APIKeyAuthAttribute.cs
--- a/WorkFlow.API/Controllers/ConfigController.cs
+++ b/WorkFlow.API/Controllers/ConfigController.cs
@ -0,0 +1,20 @@
+using DigitalData.Core.API;
+using Microsoft.AspNetCore.Authorization;
+using Microsoft.AspNetCore.Mvc;
+using WorkFlow.API.Attributes;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.Config;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.API.Controllers;
+
+[APIKeyAuth]
+[Route("api/[controller]")]
+[ApiController]
+[Authorize]
+public class ConfigController : CRUDControllerBaseWithErrorHandling<IConfigService, ConfigCreateDto, ConfigDto, ConfigUpdateDto, Config, int>
+{
+    public ConfigController(ILogger<ConfigController> logger, IConfigService service) : base(logger, service)
+    {
+    }
+}
--- a/WorkFlow.API/Controllers/ControllerExtensions.cs
+++ b/WorkFlow.API/Controllers/ControllerExtensions.cs
@ -0,0 +1,96 @@
+using Microsoft.AspNetCore.Mvc;
+using System.Security.Claims;
+using WorkFlow.API.Attributes;
+
+namespace WorkFlow.API.Controllers
+{
+    [APIKeyAuth]
+    public static class ControllerExtensions
+    {
+        public static bool TryGetUserId(this ControllerBase controller, out int? id)
+        {
+            var value = controller.User.FindFirstValue(ClaimTypes.NameIdentifier);
+
+            if (value is null)
+            {
+                id = default;
+                return false;
+            }
+
+            if(int.TryParse(value, out int id_int))
+            {
+                id = id_int;
+                return true;
+            }
+            else
+            {
+                id = null;
+                return false;
+            }
+        }
+
+        public static bool TryGetUsername(this ControllerBase controller, out string username)
+        {
+            var value = controller.User.FindFirstValue(ClaimTypes.Name);
+
+            if (value is null)
+            {
+                username = string.Empty;
+                return false;
+            }
+            else
+            {
+                username = value;
+                return true;
+            }
+        }
+
+        public static bool TryGetName(this ControllerBase controller, out string name)
+        {
+            var value = controller.User.FindFirstValue(ClaimTypes.Surname);
+
+            if (value is null)
+            {
+                name = string.Empty;
+                return false;
+            }
+            else
+            {
+                name = value;
+                return true;
+            }
+        }
+
+        public static bool TryGetPrename(this ControllerBase controller, out string prename)
+        {
+            var value = controller.User.FindFirstValue(ClaimTypes.GivenName);
+
+            if (value is null)
+            {
+                prename = string.Empty;
+                return false;
+            }
+            else
+            {
+                prename = value;
+                return true;
+            }
+        }
+
+        public static bool TryGetEmail(this ControllerBase controller, out string email)
+        {
+            var value = controller.User.FindFirstValue(ClaimTypes.Email);
+
+            if (value is null)
+            {
+                email = string.Empty;
+                return false;
+            }
+            else
+            {
+                email = value;
+                return true;
+            }
+        }
+    }
+}
--- a/src/WorkFlow.API/Controllers/PlaceholderAuthController.cs
+++ b/src/WorkFlow.API/Controllers/PlaceholderAuthController.cs
@ -13,7 +13,7 @@ namespace WorkFlow.API.Controllers;
 public class PlaceholderAuthController : ControllerBase
 {
    [HttpPost]
-    public IActionResult CreateToken([FromBody] Login login)
+    public IActionResult CreateTokenViaBody([FromBody] Login login)
    {
        throw new NotImplementedException();
    }
--- a/WorkFlow.API/Controllers/ProfileController.cs
+++ b/WorkFlow.API/Controllers/ProfileController.cs
@ -0,0 +1,20 @@
+using DigitalData.Core.API;
+using Microsoft.AspNetCore.Authorization;
+using Microsoft.AspNetCore.Mvc;
+using WorkFlow.API.Attributes;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.Profile;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.API.Controllers;
+
+[APIKeyAuth]
+[Route("api/[controller]")]
+[ApiController]
+[Authorize]
+public class ProfileController : CRUDControllerBaseWithErrorHandling<IProfileService, ProfileCreateDto, ProfileDto, ProfileUpdateDto, Profile, int>
+{
+    public ProfileController(ILogger<ProfileController> logger, IProfileService service) : base(logger, service)
+    {
+    }
+}
--- a/WorkFlow.API/Controllers/ProfileControlsTFController.cs
+++ b/WorkFlow.API/Controllers/ProfileControlsTFController.cs
@ -0,0 +1,126 @@
+using DigitalData.Core.API;
+using DigitalData.Core.DTO;
+using Microsoft.AspNetCore.Authorization;
+using Microsoft.AspNetCore.Mvc;
+using WorkFlow.API.Attributes;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.ProfileControlsTF;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.API.Controllers;
+
+[APIKeyAuth]
+[Route("api/[controller]")]
+[ApiController]
+[Authorize]
+public class ProfileControlsTFController : CRUDControllerBase<IProfileControlsTFService, ProfileControlsTFCreateDto, ProfileControlsTFDto, ProfileControlsTFUpdateDto, ProfileControlsTF, int>
+{
+    private readonly ILogger<ProfileControlsTFController> logger;
+
+    public ProfileControlsTFController(ILogger<ProfileControlsTFController> logger, IProfileControlsTFService service) : base(logger, service)
+    {
+        this.logger = logger;
+    }
+
+    [NonAction]
+    public override Task<IActionResult> GetAll() => base.GetAll();
+
+    [NonAction]
+    public override Task<IActionResult> Update(ProfileControlsTFUpdateDto updateDto) => base.Update(updateDto);
+
+    [HttpGet]
+    public async Task<IActionResult> GetAsync(
+        bool withProfile = true, bool withUser = false,
+        int? profileId = null, int? objId = null, bool? profileActive = null)
+    {
+        try
+        {
+            if (!this.TryGetUserId(out int? id))
+            {
+                logger.LogError("Authorization failed: User ID claim not found.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Failed to retrieve user identity.");
+            }
+            else if (id is null)
+            {
+                logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Invalid user ID.");
+            }
+
+            return await _service.ReadAsync(
+                withProfile: withProfile, withUser: withUser,
+                userId: id,
+                profileId: profileId, objId: objId, profileActive: profileActive)
+                .ThenAsync(
+                    Success: pctf => pctf.Any() ? Ok(pctf) : NotFound(),
+                    Fail: IActionResult (msg, ntc) =>
+                    {
+                        logger.LogNotice(ntc);
+                        return NotFound();
+                    });
+        }
+        catch (Exception ex)
+        {
+            logger.LogError(ex, "An unexpected error occurred while processing the request: {Message}", ex.Message);
+            return StatusCode(StatusCodes.Status500InternalServerError, "An internal server error occurred.");
+        }
+    }
+
+    [HttpPost]
+    public override async Task<IActionResult> Create([FromBody] ProfileControlsTFCreateDto createDto)
+    {
+        try
+        {
+            if (!this.TryGetUserId(out int? id))
+            {
+                logger.LogError("Authorization failed: User ID claim not found.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Failed to retrieve user identity.");
+            }
+            else if (id is null)
+            {
+                logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Invalid user ID.");
+            }
+
+            if (createDto.UserId != id)
+                return Unauthorized();
+
+            return await base.Create(createDto);
+        }
+        catch (Exception ex)
+        {
+            logger.LogError(ex, "An unexpected error occurred while processing the request: {Message}", ex.Message);
+            return StatusCode(StatusCodes.Status500InternalServerError, "An internal server error occurred.");
+        } 
+    }
+
+    [HttpDelete]
+    public override async Task<IActionResult> Delete([FromRoute] int id)
+    {
+        try
+        {
+            if (!this.TryGetUserId(out int? userId))
+            {
+                logger.LogError("Authorization failed: User ID claim not found.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Failed to retrieve user identity.");
+            }
+            else if (userId is null)
+            {
+                logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Invalid user ID.");
+            }
+
+            return await _service.ReadByIdAsync(id).ThenAsync(
+                SuccessAsync: async pctf => pctf.UserId == userId ? await base.Delete(id) : Unauthorized(),
+                Fail: IActionResult (msg, ntc) =>
+                {
+                    _logger.LogNotice(ntc);
+                    return ntc.HasFlag(Flag.NotFound) ? NotFound() : StatusCode(StatusCodes.Status500InternalServerError);
+                });
+        }
+        catch (Exception ex)
+        {
+            logger.LogError(ex, "An unexpected error occurred while processing the request: {Message}", ex.Message);
+            return StatusCode(StatusCodes.Status500InternalServerError, "An internal server error occurred.");
+        }
+    }
+}
--- a/WorkFlow.API/Controllers/ProfileObjStateController.cs
+++ b/WorkFlow.API/Controllers/ProfileObjStateController.cs
@ -0,0 +1,127 @@
+using DigitalData.Core.API;
+using DigitalData.Core.DTO;
+using Microsoft.AspNetCore.Authorization;
+using Microsoft.AspNetCore.Mvc;
+using WorkFlow.API.Attributes;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.ProfileObjState;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.API.Controllers
+{
+    [APIKeyAuth]
+    [Route("api/[controller]")]
+    [ApiController]
+    [Authorize]
+    public class ProfileObjStateController : CRUDControllerBaseWithErrorHandling<IProfileObjStateService, ProfileObjStateCreateDto, ProfileObjStateDto, ProfileObjStateUpdateDto, ProfileObjState, int>
+    {
+        private readonly ILogger<ProfileObjStateController> logger;
+
+        public ProfileObjStateController(ILogger<ProfileObjStateController> logger, IProfileObjStateService service) : base(logger, service)
+        {
+            this.logger = logger;
+        }
+
+        [NonAction]
+        public override Task<IActionResult> GetAll() => base.GetAll();
+
+        [NonAction]
+        public override Task<IActionResult> Update(ProfileObjStateUpdateDto updateDto) => base.Update(updateDto);
+
+        [HttpGet]
+        public async Task<IActionResult> GetAsync(
+            bool withProfile = true, bool withUser = true, bool withState = true,
+            int? profileId = null, int? objId = null, bool? profileActive = null)
+        {
+            try
+            {
+                if (!this.TryGetUserId(out int? id))
+                {
+                    logger.LogError("Authorization failed: User ID claim not found.");
+                    return StatusCode(StatusCodes.Status500InternalServerError, "Failed to retrieve user identity.");
+                }
+                else if (id is null)
+                {
+                    logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
+                    return StatusCode(StatusCodes.Status500InternalServerError, "Invalid user ID.");
+                }
+
+                return await _service.ReadAsync(
+                    withProfile: withProfile, withUser: withUser, withState,
+                    userId: id,
+                    profileId: profileId, objId: objId, profileActive: profileActive)
+                    .ThenAsync(
+                        Success: pctf => pctf.Any() ? Ok(pctf) : NotFound(),
+                        Fail: IActionResult (msg, ntc) =>
+                        {
+                            logger.LogNotice(ntc);
+                            return NotFound();
+                        });
+            }
+            catch (Exception ex)
+            {
+                logger.LogError(ex, "An unexpected error occurred while processing the request: {Message}", ex.Message);
+                return StatusCode(StatusCodes.Status500InternalServerError, "An internal server error occurred.");
+            }
+        }
+
+        [HttpPost]
+        public override async Task<IActionResult> Create([FromBody] ProfileObjStateCreateDto createDto)
+        {
+            try
+            {
+                if (!this.TryGetUserId(out int? id))
+                {
+                    logger.LogError("Authorization failed: User ID claim not found.");
+                    return StatusCode(StatusCodes.Status500InternalServerError, "Failed to retrieve user identity.");
+                }
+                else if (id is null)
+                {
+                    logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
+                    return StatusCode(StatusCodes.Status500InternalServerError, "Invalid user ID.");
+                }
+
+                if (createDto.UserId != id)
+                    return Unauthorized();
+
+                return await base.Create(createDto);
+            }
+            catch (Exception ex)
+            {
+                logger.LogError(ex, "An unexpected error occurred while processing the request: {Message}", ex.Message);
+                return StatusCode(StatusCodes.Status500InternalServerError, "An internal server error occurred.");
+            }
+        }
+
+        [HttpDelete]
+        public override async Task<IActionResult> Delete([FromRoute] int id)
+        {
+            try
+            {
+                if (!this.TryGetUserId(out int? userId))
+                {
+                    logger.LogError("Authorization failed: User ID claim not found.");
+                    return StatusCode(StatusCodes.Status500InternalServerError, "Failed to retrieve user identity.");
+                }
+                else if (userId is null)
+                {
+                    logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
+                    return StatusCode(StatusCodes.Status500InternalServerError, "Invalid user ID.");
+                }
+
+                return await _service.ReadByIdAsync(id).ThenAsync(
+                    SuccessAsync: async pctf => pctf.UserId == userId ? await base.Delete(id) : Unauthorized(),
+                    Fail: IActionResult (msg, ntc) =>
+                    {
+                        _logger.LogNotice(ntc);
+                        return ntc.HasFlag(Flag.NotFound) ? NotFound() : StatusCode(StatusCodes.Status500InternalServerError);
+                    });
+            }
+            catch (Exception ex)
+            {
+                logger.LogError(ex, "An unexpected error occurred while processing the request: {Message}", ex.Message);
+                return StatusCode(StatusCodes.Status500InternalServerError, "An internal server error occurred.");
+            }
+        }
+    }
+}
--- a/WorkFlow.API/Controllers/StateController.cs
+++ b/WorkFlow.API/Controllers/StateController.cs
@ -0,0 +1,20 @@
+using DigitalData.Core.API;
+using Microsoft.AspNetCore.Authorization;
+using Microsoft.AspNetCore.Mvc;
+using WorkFlow.API.Attributes;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.State;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.API.Controllers;
+
+[APIKeyAuth]
+[Route("api/[controller]")]
+[ApiController]
+[Authorize]
+public class StateController : CRUDControllerBaseWithErrorHandling<IStateService, StateCreateDto, StateDto, StateUpdateDto, State, int>
+{
+    public StateController(ILogger<StateController> logger, IStateService service) : base(logger, service)
+    {
+    }
+}
--- a/WorkFlow.API/Controllers/UserController.cs
+++ b/WorkFlow.API/Controllers/UserController.cs
@ -0,0 +1,54 @@
+using DigitalData.Core.DTO;
+using DigitalData.UserManager.Application.Contracts;
+using Microsoft.AspNetCore.Authorization;
+using Microsoft.AspNetCore.Mvc;
+using WorkFlow.API.Attributes;
+
+namespace WorkFlow.API.Controllers;
+
+[APIKeyAuth]
+[Route("api/[controller]")]
+[ApiController]
+[Authorize]
+public class UserController : ControllerBase
+{
+    private readonly ILogger<UserController> logger;
+    private readonly IUserService userService;
+
+    public UserController(ILogger<UserController> logger, IUserService userService)
+    {
+        this.logger = logger;
+        this.userService = userService;
+    }
+
+    [HttpGet]
+    public async Task<IActionResult> GetAsync()
+    {
+        try
+        {
+            if (!this.TryGetUserId(out int? id))
+            {
+                logger.LogError("Authorization failed: User ID claim not found.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Failed to retrieve user identity.");
+            }
+            else if(id is int id_int)
+                return await userService.ReadByIdAsync(id_int).ThenAsync(
+                    Success: Ok,
+                    Fail: IActionResult (msg, ntc) =>
+                    {
+                        logger.LogNotice(ntc);
+                        return NotFound();
+                    });
+            else
+            {
+                logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
+                return StatusCode(StatusCodes.Status500InternalServerError, "Invalid user ID.");
+            }
+        }
+        catch (Exception ex)
+        {
+            logger.LogError(ex, "An unexpected error occurred while processing the request: {Message}", ex.Message);
+            return StatusCode(StatusCodes.Status500InternalServerError, "An internal server error occurred.");
+        }
+    }
+}
--- a/src/WorkFlow.API/Extensions/DIExtensions.cs
+++ b/src/WorkFlow.API/Extensions/DIExtensions.cs
--- a/src/WorkFlow.API/Filters/APIKeyAuthHeaderOpFilter.cs
+++ b/src/WorkFlow.API/Filters/APIKeyAuthHeaderOpFilter.cs
--- a/src/WorkFlow.API/Filters/APIKeyAuthFilter.cs
+++ b/src/WorkFlow.API/Filters/APIKeyAuthFilter.cs
--- a/src/WorkFlow.API/Jenkinsfile
+++ b/src/WorkFlow.API/Jenkinsfile
--- a/src/WorkFlow.API/LazyServiceProvider.cs
+++ b/src/WorkFlow.API/LazyServiceProvider.cs
--- a/src/WorkFlow.API/Models/APIKeyAuthOptions.cs
+++ b/src/WorkFlow.API/Models/APIKeyAuthOptions.cs
--- a/src/WorkFlow.API/Models/AuthTokenKeys.cs
+++ b/src/WorkFlow.API/Models/AuthTokenKeys.cs
--- a/src/WorkFlow.API/Models/Login.cs
+++ b/src/WorkFlow.API/Models/Login.cs
--- a/src/WorkFlow.API/Models/ModelExtensions.cs
+++ b/src/WorkFlow.API/Models/ModelExtensions.cs
--- a/src/WorkFlow.API/Program.cs
+++ b/src/WorkFlow.API/Program.cs
@ -1,22 +1,22 @@
-using DigitalData.Auth.Client;
-using DigitalData.Core.Abstractions.Security.Extensions;
+using WorkFlow.Application;
+using DigitalData.UserManager.Application;
+using Microsoft.EntityFrameworkCore;
+using WorkFlow.Infrastructure;
+using DigitalData.Core.API;
 using DigitalData.Core.Application;
 using DigitalData.UserManager.Application.DTOs.User;
-using DigitalData.UserManager.DependencyInjection;
-using Microsoft.AspNetCore.Authentication.JwtBearer;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.Extensions.Options;
 using Microsoft.IdentityModel.Tokens;
-using Microsoft.OpenApi.Models;
+using WorkFlow.API.Models;
 using NLog;
 using NLog.Web;
-using WorkFlow.API;
 using WorkFlow.API.Extensions;
 using WorkFlow.API.Filters;
-using WorkFlow.API.Middleware;
-using WorkFlow.API.Models;
-using WorkFlow.Application;
-using WorkFlow.Infrastructure;
+using Microsoft.OpenApi.Models;
+using DigitalData.Auth.Client;
+using Microsoft.AspNetCore.Authentication.JwtBearer;
+using WorkFlow.API;
+using Microsoft.Extensions.Options;
+using DigitalData.Core.Abstractions.Security;

 var logger = LogManager.Setup().LoadConfigurationFromAppSettings().GetCurrentClassLogger();
 logger.Info("Logging initialized.");
@ -26,42 +26,22 @@ try
    var builder = WebApplication.CreateBuilder(args);
    var config = builder.Configuration;

-    Directory
-        .GetFiles(builder.Environment.ContentRootPath, "appsettings.*.json", SearchOption.TopDirectoryOnly)
-        .Where(file => Path.GetFileName(file) != $"appsettings.Development.json")
-        .ToList()
-        .ForEach(file => config.AddJsonFile(file, true, true));
-
    // Add NLogger
-    builder.Logging.SetMinimumLevel(Microsoft.Extensions.Logging.LogLevel.Trace);
-    if (!builder.Environment.IsDevelopment())
-    {
-        builder.Logging.ClearProviders();
-        builder.Host.UseNLog();
-    }
+    builder.Logging.ClearProviders();
+    builder.Host.UseNLog();

    // Add services to the container
    var cnn_str = config.GetConnectionString("Default") ?? throw new("Default connection string not found.");
    builder.Services.AddDbContext<WFDBContext>(options => options.UseSqlServer(cnn_str).EnableDetailedErrors());
-    var mediatRLicense = config["MediatRLicense"]
-        ?? throw new InvalidOperationException(
-            "The 'MediatRLicense' configuration value is missing or empty." +
-            "Please ensure it is properly set in the configuration source.");
-    builder.Services.AddWorkFlowServices(opt =>
-    {
-        opt.MediatRLicense = mediatRLicense;
-        opt.ConfigMapping(config.GetSection("MappingOptions"));
-    }).AddWorkFlowRepositories();
-        
-    builder.Services.AddUserManager<WFDBContext>();
-    
+    builder.Services.AddWorkFlow().AddUserManager<WFDBContext>();
+    builder.Services.AddCookieBasedLocalizer();
    builder.Services.AddDirectorySearchService(config.GetSection("DirectorySearchOptions"));
    builder.Services.AddJWTService<UserReadDto>(user => new SecurityTokenDescriptor()
    {
        Claims = user.ToClaimList().ToDictionary(claim => claim.Type, claim => claim.Value as object)
    });

-    bool disableAPIKeyAuth = config.GetValue<bool>("DisableAPIKeyAuth");
+    bool disableAPIKeyAuth = config.GetValue<bool>("DisableAPIKeyAuth") && builder.IsDevOrDiP();
    if (disableAPIKeyAuth)
        builder.Services.AddAPIKeyAuth(new APIKeyAuthOptions());
    else
@ -155,10 +135,8 @@ try

    lazyProvider.Factory = () => app.Services;

-    app.UseMiddleware<ExceptionHandlingMiddleware>();
-
    // Configure the HTTP request pipeline.
-    if (app.Configuration.GetValue<bool>("EnableSwagger"))
+    if (app.IsDevOrDiP() && app.Configuration.GetValue<bool>("EnableSwagger"))
    {
        app.UseSwagger();
        app.UseSwaggerUI();
@ -170,6 +148,8 @@ try

    app.UseAuthorization();

+    app.UseCookieBasedLocalizer("de-DE");
+
    app.MapControllers();

    app.Run();
--- a/WorkFlow.API/Properties/PublishProfiles/IISProfileNet7.pubxml
+++ b/WorkFlow.API/Properties/PublishProfiles/IISProfileNet7.pubxml
@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+https://go.microsoft.com/fwlink/?LinkID=208121.
+-->
+<Project>
+  <PropertyGroup>
+    <WebPublishMethod>Package</WebPublishMethod>
+    <LastUsedBuildConfiguration>Release</LastUsedBuildConfiguration>
+    <LastUsedPlatform>Any CPU</LastUsedPlatform>
+    <SiteUrlToLaunchAfterPublish />
+    <LaunchSiteAfterPublish>true</LaunchSiteAfterPublish>
+    <ExcludeApp_Data>false</ExcludeApp_Data>
+    <ProjectGuid>4fb33592-ef0d-47c3-9cde-03b2ef12be00</ProjectGuid>
+    <DesktopBuildPackageLocation>P:\Install .Net\0 DD - Smart UP\workFLOW\API\net7\$(Version)\workFLOW.API.zip</DesktopBuildPackageLocation>
+    <PackageAsSingleFile>true</PackageAsSingleFile>
+    <DeployIisAppPath>WorkFlow.API</DeployIisAppPath>
+    <_TargetId>IISWebDeployPackage</_TargetId>
+    <TargetFramework>net7.0</TargetFramework>
+    <RuntimeIdentifier>win-x64</RuntimeIdentifier>
+    <SelfContained>true</SelfContained>
+  </PropertyGroup>
+</Project>
--- a/WorkFlow.API/Properties/PublishProfiles/IISProfileNet8.pubxml
+++ b/WorkFlow.API/Properties/PublishProfiles/IISProfileNet8.pubxml
@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+https://go.microsoft.com/fwlink/?LinkID=208121.
+-->
+<Project>
+  <PropertyGroup>
+    <WebPublishMethod>Package</WebPublishMethod>
+    <LastUsedBuildConfiguration>Release</LastUsedBuildConfiguration>
+    <LastUsedPlatform>Any CPU</LastUsedPlatform>
+    <SiteUrlToLaunchAfterPublish />
+    <LaunchSiteAfterPublish>true</LaunchSiteAfterPublish>
+    <ExcludeApp_Data>false</ExcludeApp_Data>
+    <ProjectGuid>4fb33592-ef0d-47c3-9cde-03b2ef12be00</ProjectGuid>
+    <DesktopBuildPackageLocation>P:\Install .Net\0 DD - Smart UP\workFLOW\API\net8\$(Version)\workFLOW.API.zip</DesktopBuildPackageLocation>
+    <PackageAsSingleFile>true</PackageAsSingleFile>
+    <DeployIisAppPath>WorkFlow.API</DeployIisAppPath>
+    <_TargetId>IISWebDeployPackage</_TargetId>
+    <TargetFramework>net7.0</TargetFramework>
+    <RuntimeIdentifier>win-x64</RuntimeIdentifier>
+    <SelfContained>true</SelfContained>
+  </PropertyGroup>
+</Project>
--- a/src/WorkFlow.API/Properties/launchSettings.json
+++ b/src/WorkFlow.API/Properties/launchSettings.json
@ -22,7 +22,7 @@
    "https": {
      "commandName": "Project",
      "dotnetRunMessages": true,
-      "launchBrowser": true,
+      "launchBrowser": false,
      "launchUrl": "swagger",
      "applicationUrl": "https://localhost:7120;http://localhost:5130",
      "environmentVariables": {
--- a/src/WorkFlow.API/WFKey.cs
+++ b/src/WorkFlow.API/WFKey.cs
--- a/src/WorkFlow.API/WorkFlow.API.csproj
+++ b/src/WorkFlow.API/WorkFlow.API.csproj
@ -5,12 +5,12 @@
    <Nullable>enable</Nullable>
    <ImplicitUsings>enable</ImplicitUsings>
    <PackageId>WorkFlow.API</PackageId>
-    <Version>1.2.1</Version>
+    <Version>1.1.0</Version>
    <Company>Digital Data GmbH</Company>
    <Product>WorkFlow.API</Product>
    <Title>WorkFlow.API</Title>
-    <AssemblyVersion>1.2.1</AssemblyVersion>
-    <FileVersion>1.2.1</FileVersion>
+    <AssemblyVersion>1.1.0</AssemblyVersion>
+    <FileVersion>1.1.0</FileVersion>
  </PropertyGroup>

  <ItemGroup>
@ -20,19 +20,16 @@
  </ItemGroup>

  <ItemGroup>
-    <PackageReference Include="DigitalData.Auth.Client" Version="1.3.7" />
-    <PackageReference Include="DigitalData.Core.Abstraction.Application" Version="1.0.0" />
-    <PackageReference Include="DigitalData.Core.Exceptions" Version="1.0.1" />
+    <PackageReference Include="DigitalData.Auth.Client" Version="1.3.3" />
+    <PackageReference Include="DigitalData.Core.API" Version="2.1.1" />
    <PackageReference Include="Microsoft.AspNetCore.Authentication.JwtBearer" Version="7.0.20" />
    <PackageReference Include="NLog" Version="5.3.4" />
    <PackageReference Include="NLog.Web.AspNetCore" Version="5.3.14" />
    <PackageReference Include="Swashbuckle.AspNetCore" Version="6.4.0" />
-    <PackageReference Include="UserManager" Version="1.1.2" />
  </ItemGroup>

  <ItemGroup>
    <ProjectReference Include="..\WorkFlow.Application\WorkFlow.Application.csproj" />
-    <ProjectReference Include="..\WorkFlow.Infrastructure\WorkFlow.Infrastructure.csproj" />
  </ItemGroup>

 </Project>
--- a/src/WorkFlow.API/appsettings.Development.json
+++ b/src/WorkFlow.API/appsettings.Development.json
--- a/WorkFlow.API/appsettings.json
+++ b/WorkFlow.API/appsettings.json
@ -0,0 +1,91 @@
+{
+  "DiPMode": true,
+  "EnableSwagger": true,
+  "DisableAPIKeyAuth": false,
+  "Logging": {
+    "LogLevel": {
+      "Default": "Information",
+      "Microsoft.AspNetCore": "Warning"
+    }
+  },
+  "NLog": {
+    "throwConfigExceptions": true,
+    "variables": {
+      "logDirectory": "E:\\LogFiles\\Digital Data\\workFlow.API",
+      "logFileNamePrefix": "${shortdate}-workFlow.API"
+    },
+    "targets": {
+      "infoLogs": {
+        "type": "File",
+        "fileName": "${logDirectory}\\${logFileNamePrefix}-Info.log",
+        "maxArchiveDays": 30
+      },
+      "errorLogs": {
+        "type": "File",
+        "fileName": "${logDirectory}\\${logFileNamePrefix}-Error.log",
+        "maxArchiveDays": 30
+      },
+      "criticalLogs": {
+        "type": "File",
+        "fileName": "${logDirectory}\\${logFileNamePrefix}-Critical.log",
+        "maxArchiveDays": 30
+      }
+    },
+    // Trace, Debug, Info, Warn, Error and *Fatal*
+    "rules": [
+      {
+        "logger": "*",
+        "minLevel": "Info",
+        "maxLevel": "Warn",
+        "writeTo": "infoLogs"
+      },
+      {
+        "logger": "*",
+        "level": "Error",
+        "writeTo": "errorLogs"
+      },
+      {
+        "logger": "*",
+        "level": "Fatal",
+        "writeTo": "criticalLogs"
+      }
+    ]
+  },
+  "AllowedHosts": "*",
+  "ConnectionStrings": {
+    "Default": "Server=SDD-VMP04-SQL17\\DD_DEVELOP01;Database=DD_ECM;User Id=sa;Password=dd;Encrypt=false;TrustServerCertificate=True;"
+  },
+  "DirectorySearchOptions": {
+    "ServerName": "DD-VMP01-DC01",
+    "Root": "DC=dd-gan,DC=local,DC=digitaldata,DC=works",
+    "UserCacheExpirationDays": 1,
+    "CustomSearchFilters": {
+      "User": "(&(objectClass=user)(sAMAccountName=*))",
+      "Group": "(&(objectClass=group) (samAccountName=*))"
+    }
+  },
+  "APIKeyAuth": {
+    "Key": "ULbcOUiAXAoCXPviyCGtObZUGnrCHNgDmtNbQNpq5MOhB0EFQn18dObdQ93INNy8xIcnOPMJfEHqOotllELVrJ2R5AjqOfQszT2j00w215GanD3UiJGwFhwmdoNFsmNj",
+    "HeaderName": "X-API-Key",
+    "SwaggerDescription": "Required header for API key authentication. Enter a valid API key."
+  },
+  "OpenApiInfo": {
+    "Title": "WorkFlow API",
+    "Contact": {
+      "Email": "info-flow@digitaldata.works",
+      "Name": "Digital Data GmbH",
+      "Url": "https://digitaldata.works/"
+    }
+  },
+  "AuthClientParams": {
+    "Url": "https://localhost:7192/auth-hub",
+    "PublicKeys": [
+      {
+        "Issuer": "auth.digitaldata.works",
+        "Audience": "work-flow.digitaldata.works",
+        "Content": "-----BEGIN PUBLIC KEY-----MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA3QCd7dH/xOUITFZbitMa/xnh8a0LyL6ZBvSRAwkI9ceplTRSHJXoM1oB+xtjWE1kOuHVLe941Tm03szS4+/rHIm0Ejva/KKlv7sPFAHE/pWuoPS303vOHgI4HAFcuwywA8CghUWzaaK5LU/Hl8srWwxBHv5hKIUjJFJygeAIENvFOZ1gFbB3MPEC99PiPOwAmfl4tMQUmSsFyspl/RWVi7bTv26ZE+m3KPcWppmvmYjXlSitxRaySxnfFvpca/qWfd/uUUg2KWKtpAwWVkqr0qD9v3TyKSgHoGDsrFpwSx8qufUJSinmZ1u/0iKl6TXeHubYS4C4SUSVjOWXymI2ZQIDAQAB-----END PUBLIC KEY-----"
+      }
+    ],
+    "RetryDelay": "00:00:05"
+  }
+}
--- a/WorkFlow.Application/Contracts/IConfigService.cs
+++ b/WorkFlow.Application/Contracts/IConfigService.cs
@ -0,0 +1,10 @@
+using DigitalData.Core.Abstractions.Application;
+using WorkFlow.Application.DTO.Config;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Application.Contracts
+{
+    public interface IConfigService : ICRUDService<ConfigCreateDto, ConfigDto, Config, int>
+    {
+    }
+}
--- a/WorkFlow.Application/Contracts/IProfileControlsTFService.cs
+++ b/WorkFlow.Application/Contracts/IProfileControlsTFService.cs
@ -0,0 +1,15 @@
+using DigitalData.Core.Abstractions.Application;
+using DigitalData.Core.DTO;
+using WorkFlow.Application.DTO.ProfileControlsTF;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Application.Contracts
+{
+    public interface IProfileControlsTFService : ICRUDService<ProfileControlsTFCreateDto, ProfileControlsTFDto, ProfileControlsTF, int>
+    {
+        Task<DataResult<IEnumerable<ProfileControlsTFDto>>> ReadAsync(
+            bool withProfile = true, bool withUser = false,
+            int? userId = null, string? username = null,
+            int? profileId = null, int? objId = null, bool? profileActive = null);
+    }
+}
--- a/WorkFlow.Application/Contracts/IProfileObjStateService.cs
+++ b/WorkFlow.Application/Contracts/IProfileObjStateService.cs
@ -0,0 +1,15 @@
+using DigitalData.Core.Abstractions.Application;
+using DigitalData.Core.DTO;
+using WorkFlow.Application.DTO.ProfileObjState;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Application.Contracts
+{
+    public interface IProfileObjStateService : ICRUDService<ProfileObjStateCreateDto, ProfileObjStateDto, ProfileObjState, int>
+    {
+        Task<DataResult<IEnumerable<ProfileObjStateDto>>> ReadAsync(
+            bool withProfile = true, bool withUser = true, bool withState = true,
+            int? userId = null, string? username = null,
+            int? profileId = null, int? objId = null, bool? profileActive = null);
+    }
+}
--- a/WorkFlow.Application/Contracts/IProfileService.cs
+++ b/WorkFlow.Application/Contracts/IProfileService.cs
@ -0,0 +1,10 @@
+using DigitalData.Core.Abstractions.Application;
+using WorkFlow.Application.DTO.Profile;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Application.Contracts
+{
+    public interface IProfileService : ICRUDService<ProfileCreateDto, ProfileDto, Profile, int>
+    {
+    }
+}
--- a/WorkFlow.Application/Contracts/IStateService.cs
+++ b/WorkFlow.Application/Contracts/IStateService.cs
@ -0,0 +1,10 @@
+using DigitalData.Core.Abstractions.Application;
+using WorkFlow.Application.DTO.State;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Application.Contracts
+{
+    public interface IStateService : ICRUDService<StateCreateDto, StateDto, State, int>
+    {
+    }
+}
--- a/WorkFlow.Application/DIExtensions.cs
+++ b/WorkFlow.Application/DIExtensions.cs
@ -0,0 +1,25 @@
+using Microsoft.Extensions.DependencyInjection;
+using Microsoft.Extensions.DependencyInjection.Extensions;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.Services;
+using WorkFlow.Infrastructure;
+
+namespace WorkFlow.Application
+{
+    public static class DIExtensions
+    {
+        public static IServiceCollection AddWorkFlowServices(this IServiceCollection services)
+        {
+            services.AddAutoMapper(typeof(MappingProfile).Assembly);
+            services.TryAddScoped<IConfigService, ConfigService>();
+            services.TryAddScoped<IProfileControlsTFService, ProfileControlsTFService>();
+            services.TryAddScoped<IProfileObjStateService, ProfileObjStateService>();
+            services.TryAddScoped<IProfileService, ProfileService>();
+            services.TryAddScoped<IStateService, StateService>();
+
+            return services;
+        }
+
+        public static IServiceCollection AddWorkFlow(this IServiceCollection services) => services.AddWorkFlowRepositories().AddWorkFlowServices();
+    }
+}
--- a/src/WorkFlow.Application/DTO/BaseCreateDto.cs
+++ b/src/WorkFlow.Application/DTO/BaseCreateDto.cs
@ -1,6 +1,6 @@
 using System.Text.Json.Serialization;

-namespace WorkFlow.Application.Dto
+namespace WorkFlow.Application.DTO
 {
    public record BaseCreateDto
    {
--- a/src/WorkFlow.Application/DTO/BaseUpdateDto.cs
+++ b/src/WorkFlow.Application/DTO/BaseUpdateDto.cs
@ -1,8 +1,9 @@
-using System.Text.Json.Serialization;
+using DigitalData.Core.Abstractions;
+using System.Text.Json.Serialization;

-namespace WorkFlow.Application.Dto
+namespace WorkFlow.Application.DTO
 {
-    public record BaseUpdateDto
+    public record BaseUpdateDto : IUnique<int>
    {
        public required int Id { get; init; }

--- a/WorkFlow.Application/DTO/Config/ConfigCreateDto.cs
+++ b/WorkFlow.Application/DTO/Config/ConfigCreateDto.cs
@ -0,0 +1,4 @@
+namespace WorkFlow.Application.DTO.Config
+{
+    public record ConfigCreateDto(string Title, string String);
+}
--- a/WorkFlow.Application/DTO/Config/ConfigDto.cs
+++ b/WorkFlow.Application/DTO/Config/ConfigDto.cs
@ -1,4 +1,4 @@
-namespace WorkFlow.Application.Dto
+namespace WorkFlow.Application.DTO.Config
 {
    public record ConfigDto(int Id,
                            string Title,
--- a/WorkFlow.Application/DTO/Config/ConfigUpdateDto.cs
+++ b/WorkFlow.Application/DTO/Config/ConfigUpdateDto.cs
@ -0,0 +1,4 @@
+namespace WorkFlow.Application.DTO.Config
+{
+    public record ConfigUpdateDto(string Title, string String) : BaseUpdateDto;
+}
--- a/WorkFlow.Application/DTO/Profile/ProfileCreateDto.cs
+++ b/WorkFlow.Application/DTO/Profile/ProfileCreateDto.cs
@ -0,0 +1,4 @@
+namespace WorkFlow.Application.DTO.Profile
+{
+    public record ProfileCreateDto(string IntlName, int ExtId1, bool Active, byte TypeId) : BaseCreateDto;
+}
--- a/WorkFlow.Application/DTO/Profile/ProfileDto.cs
+++ b/WorkFlow.Application/DTO/Profile/ProfileDto.cs
@ -0,0 +1,12 @@
+namespace WorkFlow.Application.DTO.Profile
+{
+    public record ProfileDto(int Id,
+                             string IntlName,
+                             int ExtId1,
+                             bool Active,
+                             byte TypeId,
+                             string AddedWho,
+                             DateTime AddedWhen,                             
+                             string? ChangedWho = null,
+                             DateTime? ChangedWhen = null);
+}
--- a/WorkFlow.Application/DTO/Profile/ProfileUpdateDto.cs
+++ b/WorkFlow.Application/DTO/Profile/ProfileUpdateDto.cs
@ -0,0 +1,4 @@
+namespace WorkFlow.Application.DTO.Profile
+{
+    public record ProfileUpdateDto(string IntlName, int ExtId1, bool Active, byte TypeId) : BaseUpdateDto;
+}
--- a/WorkFlow.Application/DTO/ProfileControlsTF/ProfileControlsTFCreateDto.cs
+++ b/WorkFlow.Application/DTO/ProfileControlsTF/ProfileControlsTFCreateDto.cs
@ -0,0 +1,14 @@
+namespace WorkFlow.Application.DTO.ProfileControlsTF
+{
+    public record ProfileControlsTFCreateDto(
+                                        int ProfileId,
+                                        int UserId,
+                                        long ObjId,
+                                        string ObjType,
+                                        string AttrName,
+                                        string CtrlType,
+                                        string CtrlCaption,
+                                        bool Mandatory,                                        
+                                        bool ReadOnly,
+                                        string? ChoiceList = null) : BaseCreateDto;
+}
--- a/WorkFlow.Application/DTO/ProfileControlsTF/ProfileControlsTFDto.cs
+++ b/WorkFlow.Application/DTO/ProfileControlsTF/ProfileControlsTFDto.cs
@ -0,0 +1,21 @@
+using DigitalData.UserManager.Application.DTOs.User;
+using WorkFlow.Application.DTO.Profile;
+
+namespace WorkFlow.Application.DTO.ProfileControlsTF
+{
+    public record ProfileControlsTFDto(int Id,
+                                        int ProfileId,
+                                        int UserId,
+                                        long ObjId,
+                                        string ObjType,
+                                        string AttrName,
+                                        string CtrlType,
+                                        string CtrlCaption,
+                                        bool Mandatory,                                        
+                                        bool ReadOnly,
+                                        string AddedWho,
+                                        DateTime AddedWhen,
+                                        string? ChoiceList = null,
+                                        ProfileDto? Profile = null,
+                                        UserReadDto? User = null);
+}
--- a/WorkFlow.Application/DTO/ProfileControlsTF/ProfileControlsTFUpdateDto.cs
+++ b/WorkFlow.Application/DTO/ProfileControlsTF/ProfileControlsTFUpdateDto.cs
@ -0,0 +1,9 @@
+using DigitalData.Core.Abstractions;
+
+namespace WorkFlow.Application.DTO.ProfileControlsTF
+{
+    /// <summary>
+    /// This Data Transfer Object (DTO) serves as a placeholder and does not support updates.
+    /// </summary>
+    public record ProfileControlsTFUpdateDto(int Id) : IUnique<int>;
+}
--- a/WorkFlow.Application/DTO/ProfileObjState/ProfileObjStateCreateDto.cs
+++ b/WorkFlow.Application/DTO/ProfileObjState/ProfileObjStateCreateDto.cs
@ -0,0 +1,11 @@
+namespace WorkFlow.Application.DTO.ProfileObjState
+{
+    public record ProfileObjStateCreateDto(
+                                      int ProfileId,
+                                      int UserId,
+                                      long ObjId,
+                                      int StateId,
+                                      string? State2 = null,
+                                      string? State3 = null,
+                                      string? State4 = null) : BaseCreateDto;
+}
--- a/WorkFlow.Application/DTO/ProfileObjState/ProfileObjStateDto.cs
+++ b/WorkFlow.Application/DTO/ProfileObjState/ProfileObjStateDto.cs
@ -0,0 +1,20 @@
+using DigitalData.UserManager.Application.DTOs.User;
+using WorkFlow.Application.DTO.Profile;
+using WorkFlow.Application.DTO.State;
+
+namespace WorkFlow.Application.DTO.ProfileObjState
+{
+    public record ProfileObjStateDto(int Id,
+                                      int ProfileId,
+                                      int UserId,
+                                      long ObjId,
+                                      int StateId,
+                                      string AddedWho,
+                                      DateTime AddedWhen,
+                                      string? State2 = null,
+                                      string? State3 = null,
+                                      string? State4 = null,
+                                      ProfileDto? Profile = null,
+                                      UserReadDto? User = null,
+                                      StateDto? State = null);
+}
--- a/WorkFlow.Application/DTO/ProfileObjState/ProfileObjStateUpdateDto.cs
+++ b/WorkFlow.Application/DTO/ProfileObjState/ProfileObjStateUpdateDto.cs
@ -0,0 +1,9 @@
+using DigitalData.Core.Abstractions;
+
+namespace WorkFlow.Application.DTO.ProfileObjState
+{
+    /// <summary>
+    /// This Data Transfer Object (DTO) serves as a placeholder and does not support updates.
+    /// </summary>
+    public record ProfileObjStateUpdateDto(int Id) : IUnique<int>;
+}
--- a/WorkFlow.Application/DTO/State/StateCreateDto.cs
+++ b/WorkFlow.Application/DTO/State/StateCreateDto.cs
@ -0,0 +1,4 @@
+namespace WorkFlow.Application.DTO.State
+{
+    public record StateCreateDto(string IntlState) : BaseCreateDto;
+}
--- a/WorkFlow.Application/DTO/State/StateDto.cs
+++ b/WorkFlow.Application/DTO/State/StateDto.cs
@ -0,0 +1,4 @@
+namespace WorkFlow.Application.DTO.State
+{
+    public record StateDto(int Id, string IntlState, string AddedWho, DateTime AddedWhen);
+}
--- a/WorkFlow.Application/DTO/State/StateUpdateDto.cs
+++ b/WorkFlow.Application/DTO/State/StateUpdateDto.cs
@ -0,0 +1,9 @@
+using DigitalData.Core.Abstractions;
+
+namespace WorkFlow.Application.DTO.State
+{
+    /// <summary>
+    /// This Data Transfer Object (DTO) serves as a placeholder and does not support updates.
+    /// </summary>
+    public record StateUpdateDto(int Id) : IUnique<int>;
+}
--- a/WorkFlow.Application/MappingProfile.cs
+++ b/WorkFlow.Application/MappingProfile.cs
@ -0,0 +1,37 @@
+using AutoMapper;
+using WorkFlow.Application.DTO.Config;
+using WorkFlow.Application.DTO.Profile;
+using WorkFlow.Application.DTO.ProfileControlsTF;
+using WorkFlow.Application.DTO.ProfileObjState;
+using WorkFlow.Application.DTO.State;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Application
+{
+    public class MappingProfile : AutoMapper.Profile
+    {
+        public MappingProfile()
+        {
+            // Mapping entity to DTO
+            CreateMap<Config, ConfigDto>();
+            CreateMap<Domain.Entities.Profile, ProfileDto>();
+            CreateMap<ProfileControlsTF, ProfileControlsTFDto>();
+            CreateMap<ProfileObjState, ProfileObjStateDto>();
+            CreateMap<State, StateDto>();
+
+            // Mapping create-DTO to entity
+            CreateMap<ConfigCreateDto, Config>();
+            CreateMap<ProfileCreateDto, Domain.Entities.Profile>();
+            CreateMap<ProfileControlsTFCreateDto, ProfileControlsTF>();
+            CreateMap<ProfileObjStateCreateDto, ProfileObjState>();
+            CreateMap<StateCreateDto, State>();
+
+            // Mapping update-DTO to entity
+            CreateMap<ConfigUpdateDto, Config>();
+            CreateMap<ProfileUpdateDto, Domain.Entities.Profile>();
+            CreateMap<ProfileControlsTFUpdateDto, ProfileControlsTF>();
+            CreateMap<ProfileObjStateUpdateDto, ProfileObjState>();
+            CreateMap<StateUpdateDto, State>();
+        }
+    }
+}
--- a/WorkFlow.Application/Services/ConfigService.cs
+++ b/WorkFlow.Application/Services/ConfigService.cs
@ -0,0 +1,17 @@
+using AutoMapper;
+using DigitalData.Core.Abstractions.Application;
+using DigitalData.Core.Application;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.Config;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Application.Services;
+
+public class ConfigService : CRUDService<IConfigRepository, ConfigCreateDto, ConfigDto, Config, int>,
+    IConfigService, ICRUDService<ConfigCreateDto, ConfigDto, Config, int>
+{
+    public ConfigService(IConfigRepository repository, IMapper mapper) : base(repository, mapper)
+    {
+    }
+}
--- a/WorkFlow.Application/Services/ProfileControlsTFService.cs
+++ b/WorkFlow.Application/Services/ProfileControlsTFService.cs
@ -0,0 +1,35 @@
+using AutoMapper;
+using DigitalData.Core.Abstractions.Application;
+using DigitalData.Core.Application;
+using DigitalData.Core.DTO;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.ProfileControlsTF;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Application.Services
+{
+    public class ProfileControlsTFService : CRUDService<IProfileControlsTFRepository, ProfileControlsTFCreateDto, ProfileControlsTFDto, ProfileControlsTF, int>,
+        IProfileControlsTFService, ICRUDService<ProfileControlsTFCreateDto, ProfileControlsTFDto, ProfileControlsTF, int>
+    {
+        public ProfileControlsTFService(IProfileControlsTFRepository repository, IMapper mapper) : base(repository, mapper)
+        {
+        }
+
+        public async Task<DataResult<IEnumerable<ProfileControlsTFDto>>> ReadAsync(
+            bool withProfile = true, bool withUser = false,
+            int? userId = null, string? username = null,
+            int? profileId = null, int? objId = null, bool? profileActive = null)
+        {
+            var pctf_list = await _repository.ReadAsync(
+                isReadonly: true,
+                withProfile: withProfile, withUser: withUser,
+                userId: userId, username: username,
+                profileId: profileId, objId: objId, profileActive: profileActive);
+
+            var pctf_dto_list = _mapper.Map<IEnumerable<ProfileControlsTFDto>>(pctf_list);
+
+            return Result.Success(pctf_dto_list);
+        }
+    }
+}
--- a/WorkFlow.Application/Services/ProfileObjStateService.cs
+++ b/WorkFlow.Application/Services/ProfileObjStateService.cs
@ -0,0 +1,34 @@
+using AutoMapper;
+using DigitalData.Core.Abstractions.Application;
+using DigitalData.Core.Application;
+using DigitalData.Core.DTO;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.ProfileObjState;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Application.Services;
+
+public class ProfileObjStateService : CRUDService<IProfileObjStateRepository, ProfileObjStateCreateDto, ProfileObjStateDto, ProfileObjState, int>,
+    IProfileObjStateService, ICRUDService<ProfileObjStateCreateDto, ProfileObjStateDto, ProfileObjState, int>
+{
+    public ProfileObjStateService(IProfileObjStateRepository repository, IMapper mapper) : base(repository, mapper)
+    {
+    }
+
+    public async Task<DataResult<IEnumerable<ProfileObjStateDto>>> ReadAsync(
+        bool withProfile = true, bool withUser = true, bool withState = true,
+        int? userId = null, string? username = null,
+        int? profileId = null, int? objId = null, bool? profileActive = null)
+    {
+        var pos_list = await _repository.ReadAsync(
+            isReadonly: true,
+            withProfile: withProfile, withUser: withUser, withState: withState,
+            userId: userId, username: username,
+            profileId: profileId, objId: objId, profileActive: profileActive);
+
+        var post_dto_list = _mapper.Map<IEnumerable<ProfileObjStateDto>>(pos_list);
+
+        return Result.Success(post_dto_list);
+    }
+}
--- a/WorkFlow.Application/Services/ProfileService.cs
+++ b/WorkFlow.Application/Services/ProfileService.cs
@ -0,0 +1,16 @@
+using DigitalData.Core.Abstractions.Application;
+using DigitalData.Core.Application;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.Profile;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Application.Services;
+
+public class ProfileService : CRUDService<IProfileRepository, ProfileCreateDto, ProfileDto, Profile, int>,
+    IProfileService, ICRUDService<ProfileCreateDto, ProfileDto, Profile, int>
+{
+    public ProfileService(IProfileRepository repository, AutoMapper.IMapper mapper) : base(repository, mapper)
+    {
+    }
+}
--- a/WorkFlow.Application/Services/StateService.cs
+++ b/WorkFlow.Application/Services/StateService.cs
@ -0,0 +1,17 @@
+using AutoMapper;
+using DigitalData.Core.Abstractions.Application;
+using DigitalData.Core.Application;
+using WorkFlow.Application.Contracts;
+using WorkFlow.Application.DTO.State;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Application.Services;
+
+public class StateService : CRUDService<IStateRepository, StateCreateDto, StateDto, State, int>,
+    IStateService, ICRUDService<StateCreateDto, StateDto, State, int>
+{
+    public StateService(IStateRepository repository, IMapper mapper) : base(repository, mapper)
+    {
+    }
+}
--- a/src/WorkFlow.Application/WorkFlow.Application.csproj
+++ b/src/WorkFlow.Application/WorkFlow.Application.csproj
@ -7,16 +7,13 @@
  </PropertyGroup>

  <ItemGroup>
-    <PackageReference Include="DigitalData.Core.Abstraction.Application" Version="1.0.0" />
-    <PackageReference Include="DigitalData.Core.Application" Version="3.3.4" />
-    <PackageReference Include="DigitalData.Core.Exceptions" Version="1.0.1" />
-    <PackageReference Include="MediatR" Version="13.0.0" />
-    <PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="7.0.20" />
-    <PackageReference Include="UserManager" Version="1.1.2" />
+    <PackageReference Include="DigitalData.Core.Application" Version="3.2.0" />
+    <PackageReference Include="UserManager.Application" Version="3.1.2" />
  </ItemGroup>

  <ItemGroup>
    <ProjectReference Include="..\WorkFlow.Domain\WorkFlow.Domain.csproj" />
+    <ProjectReference Include="..\WorkFlow.Infrastructure\WorkFlow.Infrastructure.csproj" />
  </ItemGroup>

 </Project>
--- a/src/WorkFlow.Domain/Entities/Config.cs
+++ b/src/WorkFlow.Domain/Entities/Config.cs
@ -1,10 +1,11 @@
-using System.ComponentModel.DataAnnotations;
+using DigitalData.Core.Abstractions;
+using System.ComponentModel.DataAnnotations;
 using System.ComponentModel.DataAnnotations.Schema;

 namespace WorkFlow.Domain.Entities
 {
    [Table("TBMWF_CONFIG", Schema = "dbo")]
-    public class Config
+    public class Config : IUnique<int>
    {
        [Key]
        [Column("GUID")]
--- a/WorkFlow.Domain/Entities/Profile.cs
+++ b/WorkFlow.Domain/Entities/Profile.cs
@ -0,0 +1,44 @@
+using DigitalData.Core.Abstractions;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace WorkFlow.Domain.Entities
+{
+    [Table("TBMWF_PROFILE", Schema = "dbo")]
+    public class Profile : IUnique<int>
+    {
+        [Key]
+        [Column("GUID")]
+        public int Id { get; init; }
+
+        [Required]
+        [Column("INTL_NAME", TypeName = "varchar(200)")]
+        public required string IntlName { get; init; }
+
+        [Required]
+        [Column("EXT_ID1")]
+        public required int ExtId1 { get; init; }
+
+        [Required]
+        [Column("ACTIVE")]
+        public required bool Active { get; init; }
+
+        [Required]
+        [Column("ADDED_WHO", TypeName = "varchar(30)")]
+        public required string AddedWho { get; init; }
+
+        [Required]
+        [Column("ADDED_WHEN", TypeName = "datetime")]
+        public required DateTime AddedWhen { get; init; }
+
+        [Column("CHANGED_WHO", TypeName = "varchar(30)")]
+        public string? ChangedWho { get; init; }
+
+        [Column("CHANGED_WHEN", TypeName = "datetime")]
+        public DateTime? ChangedWhen { get; init; }
+
+        [Required]
+        [Column("TYPE_ID")]
+        public required byte TypeId { get; init; }
+    }
+}
--- a/WorkFlow.Domain/Entities/ProfileControlsTF.cs
+++ b/WorkFlow.Domain/Entities/ProfileControlsTF.cs
@ -0,0 +1,68 @@
+using DigitalData.Core.Abstractions;
+using DigitalData.UserManager.Domain.Entities;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace WorkFlow.Domain.Entities
+{
+    [Table("TBMWF_PROF_CONTROLS_TF", Schema = "dbo")]
+    public class ProfileControlsTF : IUnique<int>
+    {
+        [Key]
+        [Column("GUID")]
+        public int Id { get; init; }
+
+        [Required]
+        [Column("MWF_PROFILE_ID")]
+        public required int ProfileId { get; init; }
+
+        [Required]
+        [Column("USR_ID")]
+        public required int UserId { get; init; }
+
+        [Required]
+        [Column("OBJ_ID")]
+        public required long ObjId { get; init; }
+
+        [Required]
+        [Column("OBJ_TYPE", TypeName = "varchar(10)")]
+        public required string ObjType { get; init; }
+
+        [Required]
+        [Column("ATTR_NAME", TypeName = "varchar(100)")]
+        public required string AttrName { get; init; }
+
+        [Required]
+        [Column("CTRL_TYPE", TypeName = "varchar(10)")]
+        public required string CtrlType { get; init; }
+
+        [Required]
+        [Column("CTRL_CAPTION", TypeName = "varchar(100)")]
+        public required string CtrlCaption { get; init; }
+
+        [Required]
+        [Column("MANDATORY")]
+        public required bool Mandatory { get; init; }
+
+        [Column("CHOICE_LIST", TypeName = "nvarchar(max)")]
+        public string? ChoiceList { get; init; }
+
+        [Required]
+        [Column("READ_ONLY")]
+        public required bool ReadOnly { get; init; }
+
+        [Required]
+        [Column("ADDED_WHO", TypeName = "varchar(100)")]
+        public required string AddedWho { get; init; }
+
+        [Required]
+        [Column("ADDED_WHEN", TypeName = "datetime")]
+        public required DateTime AddedWhen { get; init; }
+
+        [ForeignKey("ProfileId")]
+        public Profile? Profile { get; init; } = default;
+
+        [ForeignKey("UserId")]
+        public User? User { get; set; } = default;
+    }
+}
--- a/WorkFlow.Domain/Entities/ProfileObjState.cs
+++ b/WorkFlow.Domain/Entities/ProfileObjState.cs
@ -0,0 +1,57 @@
+using DigitalData.Core.Abstractions;
+using DigitalData.UserManager.Domain.Entities;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace WorkFlow.Domain.Entities
+{
+    [Table("TBMWF_PROFILE_OBJ_STATE", Schema = "dbo")]
+    public class ProfileObjState : IUnique<int>
+    {
+        [Key]
+        [Column("GUID")]
+        public int Id { get; init; }
+
+        [Required]
+        [Column("MWF_PROFILE_ID")]
+        public required int ProfileId { get; init; }
+
+        [Required]
+        [Column("USR_ID")]
+        public required int UserId { get; init; }
+
+        [Required]
+        [Column("OBJ_ID")]
+        public required long ObjId { get; init; }
+
+        [Required]
+        [Column("STATE_ID")]
+        public required int StateId { get; init; }
+
+        [Column("STATE2", TypeName = "nvarchar(3000)")]
+        public string? State2 { get; init; }
+
+        [Column("STATE3", TypeName = "nvarchar(3000)")]
+        public string? State3 { get; init; }
+
+        [Column("STATE4", TypeName = "nvarchar(3000)")]
+        public string? State4 { get; init; }
+
+        [Required]
+        [Column("ADDED_WHO", TypeName = "varchar(30)")]
+        public required string AddedWho { get; init; }
+
+        [Required]
+        [Column("ADDED_WHEN", TypeName = "datetime")]
+        public required DateTime AddedWhen { get; init; }
+
+        [ForeignKey("ProfileId")]
+        public Profile? Profile { get; init; } = null;
+
+        [ForeignKey("UserId")]
+        public User? User { get; init; } = null;
+
+        [ForeignKey("StateId")]
+        public State? State { get; init; } = null;
+    }
+}
--- a/WorkFlow.Domain/Entities/State.cs
+++ b/WorkFlow.Domain/Entities/State.cs
@ -0,0 +1,26 @@
+using DigitalData.Core.Abstractions;
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace WorkFlow.Domain.Entities
+{
+    [Table("TBMWF_WF_STATE", Schema = "dbo")]
+    public class State : IUnique<int>
+    {
+        [Key]
+        [Column("GUID")]
+        public int Id { get; init; }
+
+        [Required]
+        [Column("INTL_STATE", TypeName = "varchar(100)")]
+        public required string IntlState { get; init; }
+
+        [Required]
+        [Column("ADDED_WHO", TypeName = "varchar(30)")]
+        public required string AddedWho { get; init; }
+
+        [Required]
+        [Column("ADDED_WHEN", TypeName = "datetime")]
+        public required DateTime AddedWhen { get; init; }
+    }
+}
--- a/src/WorkFlow.Domain/WorkFlow.Domain.csproj
+++ b/src/WorkFlow.Domain/WorkFlow.Domain.csproj
@ -7,7 +7,7 @@
  </PropertyGroup>

  <ItemGroup>
-    <PackageReference Include="UserManager" Version="1.1.2" />
+    <PackageReference Include="UserManager.Domain" Version="3.0.1" />
  </ItemGroup>

 </Project>
--- a/WorkFlow.Infrastructure/Contracts/IConfigRepository.cs
+++ b/WorkFlow.Infrastructure/Contracts/IConfigRepository.cs
@ -0,0 +1,9 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Infrastructure.Contracts
+{
+    public interface IConfigRepository : ICRUDRepository<Config, int>
+    {
+    }
+}
--- a/WorkFlow.Infrastructure/Contracts/IProfileControlsTFRepository.cs
+++ b/WorkFlow.Infrastructure/Contracts/IProfileControlsTFRepository.cs
@ -0,0 +1,14 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Infrastructure.Contracts
+{
+    public interface IProfileControlsTFRepository : ICRUDRepository<ProfileControlsTF, int>
+    {
+        Task<IEnumerable<ProfileControlsTF>> ReadAsync(
+            bool isReadonly = true,
+            bool withProfile = true, bool withUser = false,
+            int? userId = null, string? username = null,
+            int? profileId = null, int? objId = null, bool? profileActive = null);
+    }
+}
--- a/WorkFlow.Infrastructure/Contracts/IProfileObjStateRepository.cs
+++ b/WorkFlow.Infrastructure/Contracts/IProfileObjStateRepository.cs
@ -0,0 +1,14 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Infrastructure.Contracts
+{
+    public interface IProfileObjStateRepository : ICRUDRepository<ProfileObjState, int>
+    {
+        Task<IEnumerable<ProfileObjState>> ReadAsync(
+            bool isReadonly = true,
+            bool withProfile = true, bool withUser = true, bool withState = true,
+            int? userId = null, string? username = null,
+            int? profileId = null, int? objId = null, bool? profileActive = null);
+    }
+}
--- a/WorkFlow.Infrastructure/Contracts/IProfileRepository.cs
+++ b/WorkFlow.Infrastructure/Contracts/IProfileRepository.cs
@ -0,0 +1,9 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Infrastructure.Contracts
+{
+    public interface IProfileRepository : ICRUDRepository<Profile, int>
+    {
+    }
+}
--- a/WorkFlow.Infrastructure/Contracts/IStateRepository.cs
+++ b/WorkFlow.Infrastructure/Contracts/IStateRepository.cs
@ -0,0 +1,9 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using WorkFlow.Domain.Entities;
+
+namespace WorkFlow.Infrastructure.Contracts
+{
+    public interface IStateRepository : ICRUDRepository<State, int>
+    {
+    }
+}
--- a/WorkFlow.Infrastructure/DIExtensions.cs
+++ b/WorkFlow.Infrastructure/DIExtensions.cs
@ -0,0 +1,21 @@
+using Microsoft.Extensions.DependencyInjection;
+using Microsoft.Extensions.DependencyInjection.Extensions;
+using WorkFlow.Infrastructure.Contracts;
+using WorkFlow.Infrastructure.Repositories;
+
+namespace WorkFlow.Infrastructure
+{
+    public static class DIExtensions
+    {
+        public static IServiceCollection AddWorkFlowRepositories(this IServiceCollection services)
+        {
+            services.TryAddScoped<IConfigRepository, ConfigRepository>();
+            services.TryAddScoped<IProfileControlsTFRepository, ProfileControlsTFRepository>();
+            services.TryAddScoped<IProfileObjStateRepository, ProfileObjStateRepository>();
+            services.TryAddScoped<IProfileRepository, ProfileRepository>();
+            services.TryAddScoped<IStateRepository, StateRepository>();
+
+            return services;
+        }
+    }
+}
--- a/WorkFlow.Infrastructure/Repositories/ConfigRepository.cs
+++ b/WorkFlow.Infrastructure/Repositories/ConfigRepository.cs
@ -0,0 +1,15 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using DigitalData.Core.Infrastructure;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Infrastructure.Repositories
+{
+    //TODO: Make the db context type generic so that it can be used by other projects with different db contexts.
+    public class ConfigRepository : CRUDRepository<Config, int, WFDBContext>, IConfigRepository, ICRUDRepository<Config, int>
+    {
+        public ConfigRepository(WFDBContext dbContext) : base(dbContext, dbContext.Configs)
+        {
+        }
+    }
+}
--- a/WorkFlow.Infrastructure/Repositories/ProfileControlsTFRepository.cs
+++ b/WorkFlow.Infrastructure/Repositories/ProfileControlsTFRepository.cs
@ -0,0 +1,57 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using DigitalData.Core.Infrastructure;
+using Microsoft.EntityFrameworkCore;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Infrastructure.Repositories
+{
+    public class ProfileControlsTFRepository : CRUDRepository<ProfileControlsTF, int, WFDBContext>, IProfileControlsTFRepository, ICRUDRepository<ProfileControlsTF, int>
+    {
+        public ProfileControlsTFRepository(WFDBContext dbContext) : base(dbContext, dbContext.ProfileControlsTFs)
+        {
+        }
+
+        protected override IQueryable<ProfileControlsTF> ReadOnly() => base.ReadOnly().Include(pctf => pctf.Profile).Include(pctf => pctf.User);
+
+        protected IQueryable<ProfileControlsTF> Read(bool isReadonly = false, bool withProfile = true, bool withUser = true, int? profileId = null, int? userId = null, string? username = null, int? objId = null, bool? profileActive = null)
+        {
+            var query = isReadonly ? _dbSet.AsNoTracking() : _dbSet.AsQueryable();
+
+            if (withProfile)
+                query = query.Include(pctf => pctf.Profile);
+
+            if (withUser)
+                query = query.Include(pctf => pctf.User);
+
+            if (profileId is not null)
+                query = query.Where(pctf => pctf.ProfileId == profileId);
+
+            if (userId is not null)
+                query = query.Where(pctf => pctf.UserId == userId);
+
+            if (username is null)
+                query = query.Where(pctf => pctf.User!.Username == username);
+
+            if (objId is not null)
+                query = query.Where(pctf => pctf.ObjId == objId);
+
+            if (profileActive is not null)
+                query = query.Where(pctf => pctf.Profile!.Active == profileActive);
+
+            return query;
+        }
+
+        public async Task<IEnumerable<ProfileControlsTF>> ReadAsync(
+            bool isReadonly = true,
+            bool withProfile = true, bool withUser = true,
+            int? userId = null, string? username = null,
+            int? profileId = null, int? objId = null, bool? profileActive = null)
+            => await Read(
+                isReadonly: isReadonly,
+                withProfile: withProfile, withUser: withUser,
+                userId: userId, username: username,
+                profileId: profileId, objId: objId, profileActive: profileActive)
+            .ToListAsync();
+    }
+}
--- a/WorkFlow.Infrastructure/Repositories/ProfileObjStateRepository.cs
+++ b/WorkFlow.Infrastructure/Repositories/ProfileObjStateRepository.cs
@ -0,0 +1,62 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using DigitalData.Core.Infrastructure;
+using Microsoft.EntityFrameworkCore;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Infrastructure.Repositories;
+
+public class ProfileObjStateRepository : CRUDRepository<ProfileObjState, int, WFDBContext>, IProfileObjStateRepository, ICRUDRepository<ProfileObjState, int>
+{
+    public ProfileObjStateRepository(WFDBContext dbContext) : base(dbContext, dbContext.ProfileObjStates)
+    {
+    }
+
+    protected override IQueryable<ProfileObjState> ReadOnly() => base.ReadOnly().Include(pos => pos.Profile).Include(pos => pos.State);
+
+    protected IQueryable<ProfileObjState> Read(bool isReadonly = false, bool withProfile = true, bool withUser = true, bool withState = true, int? profileId = null, int? userId = null, string? username = null, int? stateId = null, int? objId = null, bool? profileActive = null)
+    {
+        var query = isReadonly ? _dbSet.AsNoTracking() : _dbSet.AsQueryable();
+
+        if (withProfile)
+            query = query.Include(pctf => pctf.Profile);
+
+        if (withUser)
+            query = query.Include(pctf => pctf.User);
+
+        if (withState)
+            query = query.Include(pctf => pctf.State);
+
+        if (profileId is not null)
+            query = query.Where(pctf => pctf.ProfileId == profileId);
+
+        if (userId is not null)
+            query = query.Where(pctf => pctf.UserId == userId);
+
+        if (username is null)
+            query = query.Where(pctf => pctf.User!.Username == username);
+
+        if (stateId is null)
+            query = query.Where(pctf => pctf.State!.Id == stateId);
+
+        if (objId is not null)
+            query = query.Where(pctf => pctf.ObjId == objId);
+
+        if (profileActive is not null)
+            query = query.Where(pctf => pctf.Profile!.Active == profileActive);
+
+        return query;
+    }
+
+    public async Task<IEnumerable<ProfileObjState>> ReadAsync(
+        bool isReadonly = true,
+        bool withProfile = true, bool withUser = true, bool withState = true,
+        int? userId = null, string? username = null,
+        int? profileId = null, int? objId = null, bool? profileActive = null)
+        => await Read(
+            isReadonly: isReadonly,
+            withProfile: withProfile, withUser: withUser, withState: withState,
+            userId: userId, username: username,
+            profileId: profileId, objId: objId, profileActive: profileActive)
+        .ToListAsync();
+}
--- a/WorkFlow.Infrastructure/Repositories/ProfileRepository.cs
+++ b/WorkFlow.Infrastructure/Repositories/ProfileRepository.cs
@ -0,0 +1,13 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using DigitalData.Core.Infrastructure;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Infrastructure.Repositories;
+
+public class ProfileRepository : CRUDRepository<Profile, int, WFDBContext>, IProfileRepository, ICRUDRepository<Profile, int>
+{
+    public ProfileRepository(WFDBContext dbContext) : base(dbContext, dbContext.Profiles)
+    {
+    }
+}
--- a/WorkFlow.Infrastructure/Repositories/StateRepository.cs
+++ b/WorkFlow.Infrastructure/Repositories/StateRepository.cs
@ -0,0 +1,13 @@
+using DigitalData.Core.Abstractions.Infrastructure;
+using DigitalData.Core.Infrastructure;
+using WorkFlow.Domain.Entities;
+using WorkFlow.Infrastructure.Contracts;
+
+namespace WorkFlow.Infrastructure.Repositories;
+
+public class StateRepository : CRUDRepository<State, int, WFDBContext>, IStateRepository, ICRUDRepository<State, int>
+{
+    public StateRepository(WFDBContext dbContext) : base(dbContext, dbContext.States)
+    {
+    }
+}
--- a/src/WorkFlow.Infrastructure/WFDBContext.cs
+++ b/src/WorkFlow.Infrastructure/WFDBContext.cs
@ -2,7 +2,6 @@
 using DigitalData.UserManager.Infrastructure;
 using DigitalData.UserManager.Infrastructure.Contracts;
 using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.SqlServer.Query.Internal;
 using WorkFlow.Domain.Entities;

 namespace WorkFlow.Infrastructure;
@ -11,13 +10,11 @@ public class WFDBContext : DbContext, IUserManagerDbContext
 {
    public DbSet<Config> Configs { get; set; }

-    public DbSet<PControlsTF> ProfileControlsTFs { get; set; }
+    public DbSet<ProfileControlsTF> ProfileControlsTFs { get; set; }

    public DbSet<Profile> Profiles { get; set; }
-    
-    public DbSet<PObject> Objects { get; set; }

-    public DbSet<PObjectState> ProfileObjStates { get; set; }
+    public DbSet<ProfileObjState> ProfileObjStates { get; set; }

    public DbSet<State> States { get; set; }

@ -35,38 +32,15 @@ public class WFDBContext : DbContext, IUserManagerDbContext

    public DbSet<ClientUser> ClientUsers { get; set; }

-    public DbSet<Button> Buttons { get; set; }
-
    public WFDBContext(DbContextOptions options) : base(options)
    {
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
+        //configure model builder for user manager tables
        modelBuilder.ConfigureUserManager();

-        modelBuilder.Entity<PObjectState>()
-            .HasMany(objState => objState.TFControls)
-            .WithOne()
-            .HasForeignKey(control => control.ObjStateId)
-            .OnDelete(DeleteBehavior.Cascade);
-
-        modelBuilder.Entity<PObjectState>()
-            .HasMany(objState => objState.TfFiles)
-            .WithOne()
-            .HasForeignKey(file => file.ObjStateId);
-
-        modelBuilder.Entity<PObject>()
-            .HasMany(p => p.StateHistories)
-            .WithOne()
-            .HasForeignKey(hist => hist.ObjectId);
-
-        modelBuilder.Entity<PObject>()
-            .HasMany(obj => obj.ControlsUpdates)
-            .WithOne()
-            .HasForeignKey(cu => cu.ObjId)
-            .OnDelete(DeleteBehavior.Cascade);
-
        base.OnModelCreating(modelBuilder);
    }
 }
--- a/src/WorkFlow.Infrastructure/WorkFlow.Infrastructure.csproj
+++ b/src/WorkFlow.Infrastructure/WorkFlow.Infrastructure.csproj
@ -7,15 +7,12 @@
  </PropertyGroup>

  <ItemGroup>
-    <PackageReference Include="DigitalData.Core.Abstraction.Application" Version="1.0.0" />
-    <PackageReference Include="DigitalData.Core.Infrastructure" Version="2.1.1" />
-    <PackageReference Include="DigitalData.Core.Infrastructure.AutoMapper" Version="1.0.3" />
-    <PackageReference Include="UserManager" Version="1.1.2" />
+    <PackageReference Include="DigitalData.Core.Infrastructure" Version="2.0.0" />
+    <PackageReference Include="UserManager.Infrastructure" Version="3.0.1" />
  </ItemGroup>

  <ItemGroup>
    <ProjectReference Include="..\WorkFlow.Domain\WorkFlow.Domain.csproj" />
-	<ProjectReference Include="..\WorkFlow.Application\WorkFlow.Application.csproj" />
  </ItemGroup>

 </Project>
--- a/WorkFlow.sln
+++ b/WorkFlow.sln
@ -3,21 +3,13 @@ Microsoft Visual Studio Solution File, Format Version 12.00
 # Visual Studio Version 17
 VisualStudioVersion = 17.9.34622.214
 MinimumVisualStudioVersion = 10.0.40219.1
-Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Solution Items", "Solution Items", "{8EC462FD-D22E-90A8-E5CE-7E832BA40C5D}"
-	ProjectSection(SolutionItems) = preProject
-		scripts\GetProfile.sql = scripts\GetProfile.sql
-		README.md = README.md
-	EndProjectSection
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "WorkFlow.Domain", "WorkFlow.Domain\WorkFlow.Domain.csproj", "{71E9264E-A2F0-4E5A-B010-8E4618C0C6AC}"
 EndProject
-Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "src", "src", "{02EA681E-C7D8-13C7-8484-4AC65E1B71E8}"
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "WorkFlow.Infrastructure", "WorkFlow.Infrastructure\WorkFlow.Infrastructure.csproj", "{62526D0D-3365-4113-854A-3656191D7C63}"
 EndProject
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "WorkFlow.API", "src\WorkFlow.API\WorkFlow.API.csproj", "{2B724243-4C79-F3A4-EE25-B9A53C81464C}"
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "WorkFlow.Application", "WorkFlow.Application\WorkFlow.Application.csproj", "{5700B5DD-D17E-4E17-ADE5-48C95A0CC364}"
 EndProject
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "WorkFlow.Application", "src\WorkFlow.Application\WorkFlow.Application.csproj", "{F1B4AC83-5137-C20B-641C-1699B46007A0}"
-EndProject
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "WorkFlow.Domain", "src\WorkFlow.Domain\WorkFlow.Domain.csproj", "{92A11048-6B9C-374E-87A0-BD6D8F864B77}"
-EndProject
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "WorkFlow.Infrastructure", "src\WorkFlow.Infrastructure\WorkFlow.Infrastructure.csproj", "{94F2D67D-649E-63D2-A3BF-0BEC98C2D7E6}"
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "WorkFlow.API", "WorkFlow.API\WorkFlow.API.csproj", "{4FB33592-EF0D-47C3-9CDE-03B2EF12BE00}"
 EndProject
 Global
 	GlobalSection(SolutionConfigurationPlatforms) = preSolution
@ -25,32 +17,26 @@ Global
 		Release|Any CPU = Release|Any CPU
 	EndGlobalSection
 	GlobalSection(ProjectConfigurationPlatforms) = postSolution
-		{2B724243-4C79-F3A4-EE25-B9A53C81464C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
-		{2B724243-4C79-F3A4-EE25-B9A53C81464C}.Debug|Any CPU.Build.0 = Debug|Any CPU
-		{2B724243-4C79-F3A4-EE25-B9A53C81464C}.Release|Any CPU.ActiveCfg = Release|Any CPU
-		{2B724243-4C79-F3A4-EE25-B9A53C81464C}.Release|Any CPU.Build.0 = Release|Any CPU
-		{F1B4AC83-5137-C20B-641C-1699B46007A0}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
-		{F1B4AC83-5137-C20B-641C-1699B46007A0}.Debug|Any CPU.Build.0 = Debug|Any CPU
-		{F1B4AC83-5137-C20B-641C-1699B46007A0}.Release|Any CPU.ActiveCfg = Release|Any CPU
-		{F1B4AC83-5137-C20B-641C-1699B46007A0}.Release|Any CPU.Build.0 = Release|Any CPU
-		{92A11048-6B9C-374E-87A0-BD6D8F864B77}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
-		{92A11048-6B9C-374E-87A0-BD6D8F864B77}.Debug|Any CPU.Build.0 = Debug|Any CPU
-		{92A11048-6B9C-374E-87A0-BD6D8F864B77}.Release|Any CPU.ActiveCfg = Release|Any CPU
-		{92A11048-6B9C-374E-87A0-BD6D8F864B77}.Release|Any CPU.Build.0 = Release|Any CPU
-		{94F2D67D-649E-63D2-A3BF-0BEC98C2D7E6}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
-		{94F2D67D-649E-63D2-A3BF-0BEC98C2D7E6}.Debug|Any CPU.Build.0 = Debug|Any CPU
-		{94F2D67D-649E-63D2-A3BF-0BEC98C2D7E6}.Release|Any CPU.ActiveCfg = Release|Any CPU
-		{94F2D67D-649E-63D2-A3BF-0BEC98C2D7E6}.Release|Any CPU.Build.0 = Release|Any CPU
+		{71E9264E-A2F0-4E5A-B010-8E4618C0C6AC}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{71E9264E-A2F0-4E5A-B010-8E4618C0C6AC}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{71E9264E-A2F0-4E5A-B010-8E4618C0C6AC}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{71E9264E-A2F0-4E5A-B010-8E4618C0C6AC}.Release|Any CPU.Build.0 = Release|Any CPU
+		{62526D0D-3365-4113-854A-3656191D7C63}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{62526D0D-3365-4113-854A-3656191D7C63}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{62526D0D-3365-4113-854A-3656191D7C63}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{62526D0D-3365-4113-854A-3656191D7C63}.Release|Any CPU.Build.0 = Release|Any CPU
+		{5700B5DD-D17E-4E17-ADE5-48C95A0CC364}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{5700B5DD-D17E-4E17-ADE5-48C95A0CC364}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{5700B5DD-D17E-4E17-ADE5-48C95A0CC364}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{5700B5DD-D17E-4E17-ADE5-48C95A0CC364}.Release|Any CPU.Build.0 = Release|Any CPU
+		{4FB33592-EF0D-47C3-9CDE-03B2EF12BE00}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{4FB33592-EF0D-47C3-9CDE-03B2EF12BE00}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{4FB33592-EF0D-47C3-9CDE-03B2EF12BE00}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{4FB33592-EF0D-47C3-9CDE-03B2EF12BE00}.Release|Any CPU.Build.0 = Release|Any CPU
 	EndGlobalSection
 	GlobalSection(SolutionProperties) = preSolution
 		HideSolutionNode = FALSE
 	EndGlobalSection
-	GlobalSection(NestedProjects) = preSolution
-		{2B724243-4C79-F3A4-EE25-B9A53C81464C} = {02EA681E-C7D8-13C7-8484-4AC65E1B71E8}
-		{F1B4AC83-5137-C20B-641C-1699B46007A0} = {02EA681E-C7D8-13C7-8484-4AC65E1B71E8}
-		{92A11048-6B9C-374E-87A0-BD6D8F864B77} = {02EA681E-C7D8-13C7-8484-4AC65E1B71E8}
-		{94F2D67D-649E-63D2-A3BF-0BEC98C2D7E6} = {02EA681E-C7D8-13C7-8484-4AC65E1B71E8}
-	EndGlobalSection
 	GlobalSection(ExtensibilityGlobals) = postSolution
 		SolutionGuid = {1ECB3995-5040-40BC-BC70-906E64BB4E01}
 	EndGlobalSection
--- a/scripts/GetProfile.sql
+++ b/scripts/GetProfile.sql
@ -1,4 +0,0 @@
--PROFILES
-select * from FNMWF_GET_PROFILES (1) --USER_ID
--PROFILE_OBJECTS
-SELECT * FROM [FNMWF_GET_PROFILE_OBJECTS] (1,1) --USERID, PROFILE_ID
--- a/src/WorkFlow.API/Base64File.cs
+++ b/src/WorkFlow.API/Base64File.cs
--- a/src/WorkFlow.API/Controllers/ControllerExtensions.cs
+++ b/src/WorkFlow.API/Controllers/ControllerExtensions.cs
@ -1,74 +0,0 @@
-using System.Security.Claims;
-using WorkFlow.API.Attributes;
-
-namespace WorkFlow.API.Controllers;
-
-[APIKeyAuth]
-public static class ControllerExtensions
-{
-    public static bool TryGetUserId(this ClaimsPrincipal user, out int id) => int.TryParse(user.FindFirstValue(ClaimTypes.NameIdentifier), out id);
-
-    public static bool TryGetUsername(this ClaimsPrincipal user, out string username)
-    {
-        var value = user.FindFirstValue(ClaimTypes.Name);
-
-        if (value is null)
-        {
-            username = string.Empty;
-            return false;
-        }
-        else
-        {
-            username = value;
-            return true;
-        }
-    }
-
-    public static bool TryGetName(this ClaimsPrincipal user, out string name)
-    {
-        var value = user.FindFirstValue(ClaimTypes.Surname);
-
-        if (value is null)
-        {
-            name = string.Empty;
-            return false;
-        }
-        else
-        {
-            name = value;
-            return true;
-        }
-    }
-
-    public static bool TryGetPrename(this ClaimsPrincipal user, out string prename)
-    {
-        var value = user.FindFirstValue(ClaimTypes.GivenName);
-
-        if (value is null)
-        {
-            prename = string.Empty;
-            return false;
-        }
-        else
-        {
-            prename = value;
-            return true;
-        }
-    }
-
-    public static bool TryGetEmail(this ClaimsPrincipal user, out string email)
-    {
-        var value = user.FindFirstValue(ClaimTypes.Email);
-
-        if (value is null)
-        {
-            email = string.Empty;
-            return false;
-        }
-        else
-        {
-            email = value;
-            return true;
-        }
-    }
-}
--- a/src/WorkFlow.API/Controllers/FileController.cs
+++ b/src/WorkFlow.API/Controllers/FileController.cs
@ -1,57 +0,0 @@
-using Microsoft.AspNetCore.Authorization;
-using Microsoft.AspNetCore.Mvc;
-using System.Web;
-
-namespace WorkFlow.API.Controllers;
-
-[Route("api/[controller]")]
-[ApiController]
-[Authorize]
-public class FileController : ControllerBase
-{
-    [HttpGet("{path}")]
-    public IActionResult GetFile([FromRoute] string path, [FromQuery] bool icon = false)
-    {
-        string dPath = HttpUtility.UrlDecode(path);
-
-        byte[]? fileBytes = null;
-        string? contentType = null;      
-
-        if (dPath == "docs/doc1.pdf" && !icon)
-        {
-            fileBytes = Convert.FromBase64String(Base64File.Doc1Base64);
-            contentType = "application/pdf";
-        }
-        else if (dPath == "icons/icon1.png" && icon)
-        {
-            fileBytes = Convert.FromBase64String(Base64File.Icon1Base64);
-            contentType = "image/png";
-        }
-        else
-        {
-            string fullPath = Path.Combine(AppContext.BaseDirectory, "files", dPath);
-            if (!System.IO.File.Exists(fullPath))
-                return NotFound();
-
-            fileBytes = System.IO.File.ReadAllBytes(fullPath);
-            contentType = GetContentType(fullPath);
-        }
-
-        return File(fileBytes, contentType ?? "application/octet-stream");
-    }
-
-    private string GetContentType(string path)
-    {
-        var ext = Path.GetExtension(path).ToLowerInvariant();
-        return ext switch
-        {
-            ".pdf" => "application/pdf",
-            ".png" => "image/png",
-            ".jpg" => "image/jpeg",
-            ".jpeg" => "image/jpeg",
-            ".txt" => "text/plain",
-            ".docx" => "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
-            _ => "application/octet-stream",
-        };
-    }
-}
--- a/src/WorkFlow.API/Controllers/ProfileController.cs
+++ b/src/WorkFlow.API/Controllers/ProfileController.cs
@ -1,37 +0,0 @@
-using MediatR;
-using Microsoft.AspNetCore.Authorization;
-using Microsoft.AspNetCore.Mvc;
-using WorkFlow.API.Attributes;
-using WorkFlow.Application.Profiles;
-
-namespace WorkFlow.API.Controllers;
-
-[APIKeyAuth]
-[Route("api/[controller]")]
-[ApiController]
-[Authorize]
-public class ProfileController : ControllerBase
-{
-    private readonly ILogger<ProfileController> _logger;
-
-    private readonly IMediator _mediator;
-
-    public ProfileController(ILogger<ProfileController> logger, IMediator mediator)
-    {
-        _logger = logger;
-        _mediator = mediator;
-    }
-
-    [HttpGet]
-    public async Task<IActionResult> GetAsync()
-    {
-        if (!User.TryGetUserId(out var userId))
-        {
-            _logger.LogError("Invalid user ID: Retrieved ID is null or not an integer.");
-            return Unauthorized("Failed to retrieve user identity.");
-        }
-
-        var profile = await _mediator.ReadProfileAsync(userId);
-        return Ok(profile);
-    }
-}
--- a/src/WorkFlow.API/Controllers/UserController.cs
+++ b/src/WorkFlow.API/Controllers/UserController.cs
@ -1,42 +0,0 @@
-using DigitalData.Core.Abstraction.Application.DTO;
-using DigitalData.UserManager.Application.Contracts;
-using Microsoft.AspNetCore.Authorization;
-using Microsoft.AspNetCore.Mvc;
-using WorkFlow.API.Attributes;
-
-namespace WorkFlow.API.Controllers;
-
-[APIKeyAuth]
-[Route("api/[controller]")]
-[ApiController]
-[Authorize]
-[Obsolete("Use MediatR")]
-public class UserController : ControllerBase
-{
-    private readonly ILogger<UserController> logger;
-    private readonly IUserService userService;
-
-    public UserController(ILogger<UserController> logger, IUserService userService)
-    {
-        this.logger = logger;
-        this.userService = userService;
-    }
-
-    [HttpGet]
-    public async Task<IActionResult> GetAsync()
-    {
-        if (!User.TryGetUserId(out var id))
-        {
-            logger.LogError("Authorization failed: User ID claim not found.");
-            return Unauthorized("Failed to retrieve user identity.");
-        }
-
-        return await userService.ReadByIdAsync(id).ThenAsync(
-            Success: Ok,
-            Fail: IActionResult (msg, ntc) =>
-            {
-                logger.LogNotice(ntc);
-                return NotFound();
-            });
-    }
-}
--- a/src/WorkFlow.API/Middleware/ExceptionHandlingMiddleware.cs
+++ b/src/WorkFlow.API/Middleware/ExceptionHandlingMiddleware.cs
@ -1,84 +0,0 @@
-using DigitalData.Core.Exceptions;
-using System.Net;
-using System.Text.Json;
-
-namespace WorkFlow.API.Middleware;
-
-//TODO: Fix and use DigitalData.Core.Exceptions.Middleware
-/// <summary>
-/// Middleware for handling exceptions globally in the application.
-/// Captures exceptions thrown during the request pipeline execution,
-/// logs them, and returns an appropriate HTTP response with a JSON error message.
-/// </summary>
-[Obsolete("Use DigitalData.Core.Exceptions.Middleware")]
-public class ExceptionHandlingMiddleware
-{
-    private readonly RequestDelegate _next;
-    private readonly ILogger<ExceptionHandlingMiddleware> _logger;
-
-    /// <summary>
-    /// Initializes a new instance of the <see cref="ExceptionHandlingMiddleware"/> class.
-    /// </summary>
-    /// <param name="next">The next middleware in the request pipeline.</param>
-    /// <param name="logger">The logger instance for logging exceptions.</param>
-    public ExceptionHandlingMiddleware(RequestDelegate next, ILogger<ExceptionHandlingMiddleware> logger)
-    {
-        _next = next;
-        _logger = logger;
-    }
-
-    /// <summary>
-    /// Invokes the middleware to handle the HTTP request.
-    /// </summary>
-    /// <param name="context">The HTTP context of the current request.</param>
-    /// <returns>A task that represents the asynchronous operation.</returns>
-    public async Task InvokeAsync(HttpContext context)
-    {
-        try
-        {
-            await _next(context); // Continue down the pipeline
-        }
-        catch (Exception ex)
-        {
-            await HandleExceptionAsync(context, ex, _logger);
-        }
-    }
-
-    /// <summary>
-    /// Handles exceptions by logging them and writing an appropriate JSON response.
-    /// </summary>
-    /// <param name="context">The HTTP context of the current request.</param>
-    /// <param name="exception">The exception that occurred.</param>
-    /// <param name="logger">The logger instance for logging the exception.</param>
-    /// <returns>A task that represents the asynchronous operation.</returns>
-    private static async Task HandleExceptionAsync(HttpContext context, Exception exception, ILogger logger)
-    {
-        context.Response.ContentType = "application/json";
-
-        string message;
-
-        switch (exception)
-        {
-            case BadRequestException badRequestEx:
-                context.Response.StatusCode = (int)HttpStatusCode.BadRequest;
-                message = badRequestEx.Message;
-                break;
-
-            case NotFoundException notFoundEx:
-                context.Response.StatusCode = (int)HttpStatusCode.NotFound;
-                message = notFoundEx.Message;
-                break;
-
-            default:
-                logger.LogError(exception, "Unhandled exception occurred.");
-                context.Response.StatusCode = (int)HttpStatusCode.InternalServerError;
-                message = "An unexpected error occurred.";
-                break;
-        }
-
-        await context.Response.WriteAsync(JsonSerializer.Serialize(new
-        {
-            message
-        }));
-    }
-}
--- a/src/WorkFlow.API/appsettings.Auth.json
+++ b/src/WorkFlow.API/appsettings.Auth.json
@ -1,18 +0,0 @@
-{
-  "DisableAPIKeyAuth": true,
-  "APIKeyAuth": {
-    "Key": "ULbcOUiAXAoCXPviyCGtObZUGnrCHNgDmtNbQNpq5MOhB0EFQn18dObdQ93INNy8xIcnOPMJfEHqOotllELVrJ2R5AjqOfQszT2j00w215GanD3UiJGwFhwmdoNFsmNj",
-    "HeaderName": "X-API-Key",
-    "SwaggerDescription": "Required header for API key authentication. Enter a valid API key."
-  },
-  "AuthClientParams": {
-    "Url": "http://172.24.12.39:9090/auth-hub",
-    "RetryDelay": "00:00:05",
-    "PublicKeys": [
-      {
-        "Issuer": "auth.digitaldata.works",
-        "Audience": "work-flow.digitaldata.works"
-      }
-    ]
-  }
-}
--- a/src/WorkFlow.API/appsettings.LDAP.json
+++ b/src/WorkFlow.API/appsettings.LDAP.json
@ -1,11 +0,0 @@
-{
-  "DirectorySearchOptions": {
-    "ServerName": "DD-VMP01-DC01",
-    "Root": "DC=dd-gan,DC=local,DC=digitaldata,DC=works",
-    "UserCacheExpirationDays": 1,
-    "CustomSearchFilters": {
-      "User": "(&(objectClass=user)(sAMAccountName=*))",
-      "Group": "(&(objectClass=group) (samAccountName=*))"
-    }
-  }
-}
--- a/src/WorkFlow.API/appsettings.Logging.json
+++ b/src/WorkFlow.API/appsettings.Logging.json
@ -1,51 +0,0 @@
-{
-  "Logging": {
-    "LogLevel": {
-      "Default": "Information",
-      "Microsoft.AspNetCore": "Warning"
-    }
-  },
-  "NLog": {
-    "throwConfigExceptions": true,
-    "variables": {
-      "logDirectory": "E:\\LogFiles\\Digital Data\\workFlow.API",
-      "logFileNamePrefix": "${shortdate}-workFlow.API"
-    },
-    "targets": {
-      "infoLogs": {
-        "type": "File",
-        "fileName": "${logDirectory}\\${logFileNamePrefix}-Info.log",
-        "maxArchiveDays": 30
-      },
-      "errorLogs": {
-        "type": "File",
-        "fileName": "${logDirectory}\\${logFileNamePrefix}-Error.log",
-        "maxArchiveDays": 30
-      },
-      "criticalLogs": {
-        "type": "File",
-        "fileName": "${logDirectory}\\${logFileNamePrefix}-Critical.log",
-        "maxArchiveDays": 30
-      }
-    },
-    // Trace, Debug, Info, Warn, Error and *Fatal*
-    "rules": [
-      {
-        "logger": "*",
-        "minLevel": "Info",
-        "maxLevel": "Warn",
-        "writeTo": "infoLogs"
-      },
-      {
-        "logger": "*",
-        "level": "Error",
-        "writeTo": "errorLogs"
-      },
-      {
-        "logger": "*",
-        "level": "Fatal",
-        "writeTo": "criticalLogs"
-      }
-    ]
-  }
-}
--- a/src/WorkFlow.API/appsettings.Mapping.json
+++ b/src/WorkFlow.API/appsettings.Mapping.json
@ -1,17 +0,0 @@
-{
-  "MappingOptions": {
-    "TfFileUri": {
-      "Scheme": "https",
-      "Host": "dd-gan.digitaldata.works",
-      "Port": 8443,
-      "Path": "api/file"
-    },
-    "TfFileIconUri": {
-      "Scheme": "https",
-      "Host": "dd-gan.digitaldata.works",
-      "Port": 8443,
-      "Path": "api/file",
-      "Query": "icon=true"
-    }
-  }
-}
--- a/src/WorkFlow.API/appsettings.json
+++ b/src/WorkFlow.API/appsettings.json
@ -1,17 +0,0 @@
-{
-  "DiPMode": true,
-  "EnableSwagger": true,
-  "AllowedHosts": "*",
-  "ConnectionStrings": {
-    "Default": "Server=SDD-VMP04-SQL17\\DD_DEVELOP01;Database=DD_ECM;User Id=sa;Password=dd;Encrypt=false;TrustServerCertificate=True;"
-  },
-  "OpenApiInfo": {
-    "Title": "WorkFlow API",
-    "Contact": {
-      "Email": "info-flow@digitaldata.works",
-      "Name": "Digital Data GmbH",
-      "Url": "https://digitaldata.works/"
-    }
-  },
-  "MediatRLicense": "eyJhbGciOiJSUzI1NiIsImtpZCI6Ikx1Y2t5UGVubnlTb2Z0d2FyZUxpY2Vuc2VLZXkvYmJiMTNhY2I1OTkwNGQ4OWI0Y2IxYzg1ZjA4OGNjZjkiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL2x1Y2t5cGVubnlzb2Z0d2FyZS5jb20iLCJhdWQiOiJMdWNreVBlbm55U29mdHdhcmUiLCJleHAiOiIxNzg0ODUxMjAwIiwiaWF0IjoiMTc1MzM2MjQ5MSIsImFjY291bnRfaWQiOiIwMTk4M2M1OWU0YjM3MjhlYmZkMzEwM2MyYTQ4NmU4NSIsImN1c3RvbWVyX2lkIjoiY3RtXzAxazB5NmV3MmQ4YTk4Mzg3aDJnbTRuOWswIiwic3ViX2lkIjoiLSIsImVkaXRpb24iOiIwIiwidHlwZSI6IjIifQ.ZqsFG7kv_-xGfxS6ACk3i0iuNiVUXX2AvPI8iAcZ6-z2170lGv__aO32tWpQccD9LCv5931lBNLWSblKS0MT3gOt-5he2TEftwiSQGFwoIBgtOHWsNRMinUrg2trceSp3IhyS3UaMwnxZDrCvx4-0O-kpOzVpizeHUAZNr5U7oSCWO34bpKdae6grtM5e3f93Z1vs7BW_iPgItd-aLvPwApbaG9VhmBTKlQ7b4Jh64y7UXJ9mKP7Qb_Oa97oEg0oY5DPHOWTZWeE1EzORgVr2qkK2DELSHuZ_EIUhODojkClPNAKtvEl_qEjpq0HZCIvGwfCCRlKlSkQqIeZdFkiXg"
-}
--- a/src/WorkFlow.Application/Buttons/ReadButton.cs
+++ b/src/WorkFlow.Application/Buttons/ReadButton.cs
@ -1,20 +0,0 @@
-namespace WorkFlow.Application.Buttons;
-
-public record ButtonDto
-{
-    public byte? DialogNo { get; init; }
-
-    public string? BtnType { get; init; }
-
-    public string? Icon { get; init; }
-
-    public string? ForeColor { get; init; }
-
-    public string? BackColor { get; init; }
-
-    public string? Command { get; init; }
-
-    public string? DialogCommand { get; init; }
-
-    public string? ConfirmationText { get; init; }
-}
--- a/src/WorkFlow.Application/Contracts/Repositories/IProfileObjRepository.cs
+++ b/src/WorkFlow.Application/Contracts/Repositories/IProfileObjRepository.cs
@ -1,23 +0,0 @@
-using WorkFlow.Domain.Entities;
-
-namespace WorkFlow.Application.Contracts.Repositories;
-
-/// <summary>
-/// Repository for retrieving <see cref="PObject"/> entities from the database.
-/// </summary>
-public interface IProfileObjRepository
-{
-    /// <summary>
-    /// Retrieves the list of <see cref="PObject"/> associated with a given user ID and profile ID by calling a database function.
-    /// </summary>
-    /// <param name="userId">The unique identifier of the user whose profile is to be retrieved.</param>
-    /// <param name="profileId">The unique identifier of the profile whose object is to be retrieved.</param>
-    /// <param name="cancel">Propagates notification that operations should be canceled.</param>
-    /// <returns>
-    /// A task that represents the asynchronous operation. The task result contains the <see cref="PObject"/> object if found; otherwise, <c>null</c>.
-    /// </returns>
-    /// <remarks>
-    /// Logs an error if no profile is found, or if multiple profiles are returned, indicating potential data issues.
-    /// </remarks>
-    public Task<IEnumerable<PObject>> ReadAsync(int userId, int profileId, CancellationToken cancel = default);
-}
--- a/src/WorkFlow.Application/Contracts/Repositories/IProfileRepository.cs
+++ b/src/WorkFlow.Application/Contracts/Repositories/IProfileRepository.cs
@ -1,22 +0,0 @@
-using WorkFlow.Domain.Entities;
-
-namespace WorkFlow.Application.Contracts.Repositories;
-
-/// <summary>
-/// Repository implementation for retrieving <see cref="Profile"/> entities from the database.
-/// </summary>
-public interface IProfileRepository
-{
-    /// <summary>
-    /// Retrieves the <see cref="Profile"/> associated with a given user ID by calling a database function.
-    /// </summary>
-    /// <param name="userId">The unique identifier of the user whose profile is to be retrieved.</param>
-    /// <param name="cancel">Propagates notification that operations should be canceled.</param>
-    /// <returns>
-    /// A task that represents the asynchronous operation. The task result contains the <see cref="Profile"/> object if found; otherwise, <c>null</c>.
-    /// </returns>
-    /// <remarks>
-    /// Logs an error if no profile is found, or if multiple profiles are returned, indicating potential data issues.
-    /// </remarks>
-    Task<Profile?> ReadAsync(int userId, CancellationToken cancel = default);
-}
--- a/src/WorkFlow.Application/DependencyInjection.cs
+++ b/src/WorkFlow.Application/DependencyInjection.cs
@ -1,52 +0,0 @@
-using Microsoft.Extensions.Configuration;
-using Microsoft.Extensions.DependencyInjection;
-using WorkFlow.Application.Mapping;
-
-namespace WorkFlow.Application;
-
-public static class DependencyInjection
-{
-    public static IServiceCollection AddWorkFlowServices(this IServiceCollection services, Action<WorkFlowServiceOptions>? options = null)
-    {
-        WorkFlowServiceOptions sOptions = new(services);
-        options?.Invoke(sOptions);
-
-        services.AddAutoMapper(typeof(MappingProfile).Assembly);
-        services.AddMediatR(cfg =>
-        {
-            cfg.RegisterServicesFromAssembly(typeof(DependencyInjection).Assembly);
-            cfg.LicenseKey = sOptions.MediatRLicense;
-        });
-
-        if(!sOptions.IsMappingConfigured)
-            services.Configure<MappingOptions>(_ => { });
-
-        services.AddTransient<TfFileUriResolver>();
-        services.AddTransient<TfFileIconUriResolver>();
-
-        return services;
-    }
-
-    public class WorkFlowServiceOptions
-    {
-        private readonly IServiceCollection _services;
-
-        internal bool IsMappingConfigured { get; private set; } = false;
-
-        public WorkFlowServiceOptions(IServiceCollection services) => _services = services;
-    
-        private void EnsureSingleMappingConfiguration(Action action)
-        {
-            if (IsMappingConfigured)
-                throw new InvalidOperationException("Mapping configuration has already been set.");
-            action();
-            IsMappingConfigured = true;
-        }
-
-        public void ConfigMapping(IConfiguration config) => EnsureSingleMappingConfiguration(() => _services.Configure<MappingOptions>(config));
-
-        public void ConfigMapping(Action<MappingOptions> options) => EnsureSingleMappingConfiguration(() => _services.Configure(options));
-
-        public string? MediatRLicense { get; set; }
-    }
-}
--- a/src/WorkFlow.Application/Dto/ObjectDto.cs
+++ b/src/WorkFlow.Application/Dto/ObjectDto.cs
@ -1,16 +0,0 @@
-namespace WorkFlow.Application.Dto;
-
-public class ObjectDto
-{
-    public IEnumerable<string> Headlines { get; set; } = Array.Empty<string>();
-
-    public IEnumerable<string> Sublines { get; set; } = Array.Empty<string>();
-
-    public string? CmdCheckIn { get; set; }
-
-    public ObjectStateDto? State { get; set; }
-
-    public IEnumerable<ObjectStateHistDto> StateHistories { get; set; } = Array.Empty<ObjectStateHistDto>();
-
-    public IEnumerable<PControlsUpdateDto>? ControlsUpdates { get; set; } = Array.Empty<PControlsUpdateDto>();
-}
--- a/src/WorkFlow.Application/Dto/ObjectStateDto.cs
+++ b/src/WorkFlow.Application/Dto/ObjectStateDto.cs
@ -1,15 +0,0 @@
-namespace WorkFlow.Application.Dto;
-
-public record ObjectStateDto
-{
-    public virtual string? Intl { get; set; }
-
-    /// <summary>
-    /// Holds state 2, 3 and 4 as a list of strings.
-    /// </summary>
-    public IEnumerable<string> Others { get; set; } = Array.Empty<string>();
-
-    public virtual IEnumerable<PControlsTFDto>? TFControls { get; set; }
-
-    public virtual IEnumerable<TfFileDto>? TfFiles { get; set; }
-}
--- a/src/WorkFlow.Application/Dto/ObjectStateHistDto.cs
+++ b/src/WorkFlow.Application/Dto/ObjectStateHistDto.cs
@ -1,15 +0,0 @@
-namespace WorkFlow.Application.Dto;
-
-public record ObjectStateHistDto
-{
-    public virtual string? Intl { get; set; }
-
-    /// <summary>
-    /// Holds state 2, 3 and 4 as a list of strings.
-    /// </summary>
-    public IEnumerable<string> Others { get; set; } = Array.Empty<string>();
-
-    public string? ChangedWho { get; set; }
-
-    public DateTime? ChangedWhen { get; set; }
-}
--- a/src/WorkFlow.Application/Dto/PControlsTFDto.cs
+++ b/src/WorkFlow.Application/Dto/PControlsTFDto.cs
@ -1,24 +0,0 @@
-namespace WorkFlow.Application.Dto;
-
-public record PControlsTFDto
-{
-    public byte? DialogNo { get; set; }
-
-    public string? AttrName { get; set; }
-
-    public string? CtrlType { get; set; }
-
-    public string? Caption { get; set; }
-
-    public string? Text { get; set; }
-
-    public string? Icon { get; set; }
-
-    public bool? Mandatory { get; set; }
-
-    public string? ChoiceList { get; set; }
-
-    public bool? ReadOnly { get; set; }
-
-    public byte? Sequ { get; set; }
-}
--- a/src/WorkFlow.Application/Dto/PControlsUpdateDto.cs
+++ b/src/WorkFlow.Application/Dto/PControlsUpdateDto.cs
@ -1,12 +0,0 @@
-namespace WorkFlow.Application.Dto;
-
-public record PControlsUpdateDto
-{
-    public string? AttrName { get; set; }
-
-    public string? AttrValue { get; set; }
-
-    public string? AddedWho { get; set; }
-
-    public DateTime? AddedWhen { get; set; }
-}
--- a/src/WorkFlow.Application/Dto/ProfileDto.cs
+++ b/src/WorkFlow.Application/Dto/ProfileDto.cs
@ -1,22 +0,0 @@
-using WorkFlow.Application.Buttons;
-
-namespace WorkFlow.Application.Dto;
-
-public class ProfileDto
-{
-    public byte? TypeId { get; init; }
-
-    public string? Caption { get; init; }
-
-    public string? Subtitle { get; init; }
-
-    public int? CountObj { get; init; }
-
-    public string? ForeColor { get; init; }
-
-    public string? BackColor { get; init; }
-
-    public IEnumerable<ObjectDto> Objects { get; init; } = Array.Empty<ObjectDto>();
-
-    public IEnumerable<ButtonDto>? Buttons { get; set; } = Array.Empty<ButtonDto>();
-}
--- a/src/WorkFlow.Application/Dto/TfFileDto.cs
+++ b/src/WorkFlow.Application/Dto/TfFileDto.cs
@ -1,14 +0,0 @@
-namespace WorkFlow.Application.Dto;
-
-public class TfFileDto
-{
-    public string? Url { get; set; }
-
-    public string? Headline { get; set; }
-
-    public string? Subline { get; set; }
-
-    public string? Comment { get; set; }
-
-    public string? IconUrl { get; set; }
-}
--- a/src/WorkFlow.Application/Mapping/MappingOptions.cs
+++ b/src/WorkFlow.Application/Mapping/MappingOptions.cs
@ -1,52 +0,0 @@
-namespace WorkFlow.Application.Mapping;
-
-public class MappingOptions
-{
-    public UriBuilderOptions TfFileUri { get; set; } = new();
-
-    public UriBuilderOptions TfFileIconUri { get; set; } = new();
-
-    public class UriBuilderOptions
-    {
-        public string? Scheme { get; set; }
-
-        public string? Host { get; set; }
-
-        public int? Port { get; set; }
-
-        private string _path = "/";
-
-        public string Path
-        { 
-            get => _path;
-            set => _path = value.Trim('/');
-        }
-
-        private string _query = string.Empty;
-
-        public string Query
-        {
-            get => _query;
-            set => _query = value.TrimStart('?');
-        }
-
-        public UriBuilder ToBuilder
-        {
-            get
-            {
-                var uriBuilder = new UriBuilder()
-                {
-                    Scheme = Scheme ?? "http",
-                    Host = Host ?? "localhost",
-                    Path = Path,
-                    Query = Query,
-                };
-
-                if (Port is int port)
-                    uriBuilder.Port = port;
-
-                return uriBuilder;
-            }
-        }
-    }
-}
--- a/Show More
+++ b/Show More