A simple asp.net core document managment api, backed by SQL Server, Azure storage and SMB shares, and secured by Azure Active Directory or Active Directory.

At it's core DocStoreAPI is a simple API designed to be easily intergratable with other projects that require an auditable document managment system.

The application stores documents within stors such as a file share or Azure Blob Storage, and then stores the document metadata within SQL Server. Buisness Metadata is stored as simple Key Value Pairs where as the document properties are stored in a flat structure.

• Implement Move on DocumentController.
• Implement a Security Controller(s) to Manage Groups, ACEs and BuisnessAreas.
• Add ACE state of Supervisor to manage permissions by Buisness Area.
• Inject Admin Groups via Config.
• Implement Admin or 'Supervisor' Check on Security Controller(s).
• Implement Metadata filtering on DocumentMetadataController.Put & DocumentMetadataController.Post to ensure generated values aren't being overwritten and document names are updated when necessary.
  • Add User Edit Metod to limit the properties that can be edited by Put.
  • Verify Post Data and strip Generated Data.
• Redifne the Gates on the group controller and remove the exception when the object is null.
• Update User Is authorised by Buisness Area to support Admins.
• Implement a search.
  • Use a class passed as the body to store the search Data with Queries for the Pagination etc.
• Update BuisnessArea and Group conrtollers to search by strings not ids.
• Go through and ensure that Auditing is being stored in the database.
• Change Gates to a Single Generic Method.
  • Access Controller
  • Buisness Area Controller
  • Group Controller
  • Document Controller
  • Document Metadata Controller
• Change Namespaces to >
  • WebApi to DocStore.API.
  • Split Shared Code to Class Library in DocStore.Shared.
  • Client Code in DocStore.Client.
• Update to .net core 3.
• Change Buisness Metadata to Dictionary<string, TValue> instead of a custom class so it would be easier to parse and add values to.
• Add Unit Tests.
• Add a Client library.
• Add an example WPF app.
• Implement a Background worker service as a different application
  • Queue service
    • Connects to RabbitMQ and recives messages from the API
    • Runs actions on the other Services depending on the message(s) recived.
  • Archival Service
    • Doesn't do much now but will be usefull when policies are used as archival policies will be required
  • Deletion Service
    • Deletes all versions of a document alongside the Data in the DB.
  • Document Moverment Service
    • Deals with movement of data between data stores

• Implement Background Worker and Queue to manage archival, deletion and movement of documents instead of at Runtime.
• Implement a Admin management interface.
  • Change the Stor Configs from a file to SQl and manage them through the Admin Portal.
• Implement simple polices based upon BuisnessArea to define automatic movement policies based on Stors and BuisnessAreas.
  • Use Rules Engine to implement polices.
  • Store the Policies in SQL and make them managaeable through the Admin interface.
• Add Support for MySql as an alternative database.
• Add Support for Comsmos DB as an alternative database.
• Look into Support for AWS storage.
• Add support for Generic Oauth and move Azure to that auth.

• Support for Metadata / Security caching possible using redis or something similar.
• Look into Supporting other Identity providers.

• ConnectionStrings.DefaultConnection is the Metadata storage database connection string.
• StorConfigFilePath is a Path so you can host the Stor Config on a shared drive

{
	"AzureAd": {
		"Instance": "https://login.microsoftonline.com/",
		"Domain": "YourAzureADInstance.onmicrosoft.com",
		"TenantId": "22222222-2222-2222-2222-222222222222",
		"ClientId": "11111111-1111-1111-11111111111111111"
	},
	"Logging": {
		"LogLevel": {
			"Default": "Warning"
		}
	},
	"AllowedHosts": "*",
	"ConnectionStrings": {
		"DefaultConnection": "Server=Server\\Instance;Database=DocStore;User Id=SQLUSer;Password=Password;"
	},
	"StorConfigFilePath": "D:\\DocStore\\Config\\StorConfig.json",
	"AdminGroups": {
		"ADAdminGroupNames": [ "Domain Admins", "DocStore Admins" ],
		"AZAdminGroupNames": [ "DocStore Admins" ]
	}
}

• Only use SMB share auth if needed otherwise just grant access via the run as account.
• Don't add a trailing slash to the end of the file paths in BasePath

{
	"Stors": [
		{
			"RequiresAuth": false,
			"UserName": null,
			"Password": null,
			"Domain": null,
			"BasePath": "\\\\Sevrer\\Share\\DocStore01",
			"StorType": "FileShareStor",
			"ShortName": "DocStore01"
		},
		{
			"RequiresAuth": false,
			"UserName": null,
			"Password": null,
			"Domain": null,
			"BasePath": "\\\\Sevrer\\Share\\DocStore02",
			"StorType": "FileShareStor",
			"ShortName": "DocStore02"
		},
		{
			"ContainerName": "DocStoreContainer",
			"AccessKey": "YourKeyHere",
			"AccountName": "yourAccountNameHere",
			"StorType": "AzureBlobStor",
			"ShortName":  "AZDefaultStor"
		}
	]
}

Copyright (c) 2019 Liam Townsend

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.