This was a project done for NHS Digital in the United Kingdom. The initial work was a website where suppliers of software to the NHS could:

• register a product/s with an NHS framework
• select which capabilities the product provides
• select which standards the product meets
• submit evidence to support its claimed capabilities
• submit evidence to support its claimed standards
• have the evidence reviewed against its claimed capabilities
• have the evidence reviewed against its claimed standards
• engage in dialogue with an NHSD capabilities review team
• engage in dialogue with an NHSD standards compliance team
• create an information page about the product
• be approved for sale

The overall architecture is a classic 3-tier application ie:

• presentation
  • web app in NodeJS
• business logic
  • C# .NET core
• data storage
  • relational database eg Microsoft SQL Server
  • Microsoft Dynamics CRM
  • Microsoft SharePoint

• RESTful APIs for data

• Swagger UI for testing

• pluggable datastores for supplier data (SQL database or MS Dynamics CRM)

• pluggable blobstore for supplier evidence aka binary data (MS SharePoint or MongoDB)

• pluggable OAuth provider (currently Auth0)

• Swagger UI : https://localhost:5000/swagger/index.html

• .NET Core 2.1
• Optional:
  • Docker
  • Microsoft SQL Server

  git clone https://github.com/TrevorDArcyEvans/NHSBuyingCatalogue.git
  cd NHSBuyingCatalogue/beta-private/api/NHSD.GPITF.BuyingCatalog
  dotnet build
  dotnet test

• Various settings are output to the console log on startup
• Settings are obtained from:
  • appsettings.json
  • hosting.json
  • autofac.json
  • nLog.config
  • user secrets file
  • environment variables

{
 "urls": "http://*:5100",

 "wwwroot": "wwwroot",

 "UseCRM": false,

 "GIF":
 {
   "Authority_Uri": "http://crm:5001"
 },

 "Log":
 {
   "ConnectionString": "Data Source=|DataDirectory|Data/NHSD.GPITF.BuyingCatalog.sqlite3;",
   "CRM": true,
   "SharePoint": true,
   "BearerAuth": true
 },

 "Cache":
 {
   "Host": "localhost"
 },

 "RepositoryDatabase":
 {
   "Connection": "SqLite",

   "SqLite":
   {
     "Type": "SqLite",
     "ConnectionString": "Data Source=|DataDirectory|Data/NHSD.GPITF.BuyingCatalog.sqlite3;"
   },

   "SqlServer":
   {
     "Type": "SqlServer",
     "ConnectionString": "Data Source=localhost;Initial Catalog=BuyingCatalog;Integrated Security=True;MultipleActiveResultSets=True"
   },

   "MySql":
   {
     "Type": "MySql",
     "ConnectionString": "server=127.0.0.1;uid=NHSD;pwd=DisruptTheMarket;database=BuyingCatalog;SslMode=none"
   }
 },

 "Jwt":
 {
   "Authority": "https://buying-catalogue-beta-prototype.eu.auth0.com/",
   "Audience": "api.buying-catalogue-beta-prototype",
   "UserInfo": "https://buying-catalogue-beta-prototype.eu.auth0.com/userinfo",
 },

 "Logging":
 {
   "PathFormat": "Logs/NHSD-GPITF-BuyingCatalog-{Date}.txt",
   "IncludeScopes": false,
   "Debug":
   {
     "LogLevel":
     {
       "Default": "Warning"
     }
   },
   "Console":
   {
     "LogLevel":
     {
       "Default": "Warning"
     }
   }
 }
}

https://docs.microsoft.com/en-gb/aspnet/core/fundamentals/configuration/index?tabs=basicconfiguration&view=aspnetcore-3.0#conventions

Logging is provided by nLog its settings are in nLog.config

-- MS SQL Server
CREATE TABLE Log 
(
  Timestamp DATETIME2,
  Loglevel TEXT,
  Callsite TEXT,
  Message TEXT
);
CREATE INDEX IDX_Timestamp ON Log(Timestamp);

-- MySQL aka MariaDB
CREATE TABLE Log 
(
  Timestamp DATETIME,
  Loglevel TEXT,
  Callsite TEXT,
  Message TEXT
);
CREATE INDEX IDX_Timestamp ON Log(Timestamp);

-- PostgreSQL
CREATE TABLE Log 
(
  "Timestamp" TIMESTAMP,
  "Loglevel" TEXT,
  "Callsite" TEXT,
  "Message" TEXT
);
CREATE INDEX IDX_Timestamp ON Log("Timestamp");

-- SQLite
CREATE TABLE Log 
(
  Timestamp TEXT,
  Loglevel TEXT,
  Callsite TEXT,
  Message TEXT
);
CREATE INDEX IDX_Timestamp ON Log(Timestamp);