tienlx91/tedu_35

Introduction

KnowledgeSpace is a open source project for everyone. Every member can create new knowledge base record (KB) and share to community. For each KB, user can vote it and comment to below KB.

Migration

• Add-Migration Initial -OutputDir Data/Migrations

#Technology Stack

1. ASP.NET Core 3.1
2. Angular 8
3. Identity Server 4
4. SQL Server 2019

How to run this Project

1. Clone this source code from Repository
2. Build solution to restore all Nuget Packages
3. Set startup project is KnowledgeSpace.BackendServer
4. Run Update-Database to generate database
5. Set startup project to multiple projects include: KnowledgeSpace.BackendServer and KnowledgeSpace.WebPortal

References

• ASP.NET Core

• Visual Studio

• IdentityServer4

• https://medium.com/@matthew.bajorek/configuring-serilog-in-asp-net-core-2-2-web-api-5e0f4d89749c

• https://docs.microsoft.com/en-us/aspnet/core/performance/caching/distributed?view=aspnetcore-3.1

Angular Installation

• NPM (https://nodejs.org/en/)
• https://git-scm.com/downloads
• npm install -g @angular/cli
• Visual Studio Code (https://code.visualstudio.com/)
• Run command: git clone https://github.com/start-angular/SB-Admin-BS4-Angular-8.git admin-app

Cachce table SQL

    CREATE TABLE [dbo].[CacheTable](
        [Id] [nvarchar](449) NOT NULL,
        [Value] [varbinary](max) NOT NULL,
        [ExpiresAtTime] [datetimeoffset](7) NOT NULL,
        [SlidingExpirationInSeconds] [bigint] NULL,
        [AbsoluteExpiration] [datetimeoffset](7) NULL,
     CONSTRAINT [pk_Id] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
           IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
           ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 
    CREATE NONCLUSTERED INDEX [Index_ExpiresAtTime] ON [dbo].[CacheTable]
    (
        [ExpiresAtTime] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
           SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, 
           ONLINE = OFF, ALLOW_ROW_LOCKS = ON, 
           ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

Deployment

1. Publish source code to package (BackendServer, WebPortal, Admin App)
2. Install server environment (SQL Server, .NET Core Runtime, ASP.NET Core Runtime)
3. Copy artifacts to Server
4. Install IIS (Internet information service)
5. Create IIS Web App (Configure Pool IIS No managed)
6. Config connection string appsettings.Production.json
7. Install Certificate for IIS (friendly name)
8. Setup security IIS_IUSR permission for web app, enable 32 bit in pool, enable stdout log in webconfig.
9. Instal rewrite URL Module for IIS (https://www.iis.net/downloads/microsoft/url-rewrite)
10. Create webconfig

<configuration>
      <system.webServer>
        <rewrite>
          <rules>
            <rule name="AngularJS Routes" stopProcessing="true">
              <match url=".*" />
              <conditions logicalGrouping="MatchAll">
                <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
                <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />   
              </conditions>
              <action type="Rewrite" url="/" />
            </rule>
          </rules>
        </rewrite>
      </system.webServer>
</configuration>

11. Check url in setting

Reference

1. https://jakeydocs.readthedocs.io/en/latest/client-side/using-gulp.html

Fix issue

• The Angular Compiler requires TypeScript >=3.6.4 and <3.8.0 but 3.8.2 was found instead --> Open admin-app and run command prompt: npm install typescript@3.7.5