From 0de65b89c406169bd9972887b1d62a4cc3fdf000 Mon Sep 17 00:00:00 2001
From: Syndamia <kamen.d.mladenov@protonmail.com>
Date: Thu, 6 May 2021 20:13:21 +0300
Subject: Added simple User and Role DB classes, added a simple DBContext and
 configured it for PostgreSQL

---
 ExamTemplate/Data/Class1.cs                   |  8 --------
 ExamTemplate/Data/Data.csproj                 |  7 ++++++-
 ExamTemplate/Data/Models/Role.cs              | 13 +++++++++++++
 ExamTemplate/Data/Models/User.cs              | 15 +++++++++++++++
 ExamTemplate/Data/TemplateContext.cs          | 20 ++++++++++++++++++++
 ExamTemplate/Web/Startup.cs                   |  6 ++++++
 ExamTemplate/Web/appsettings.Development.json |  9 ---------
 ExamTemplate/Web/appsettings.json             |  3 +++
 8 files changed, 63 insertions(+), 18 deletions(-)
 delete mode 100644 ExamTemplate/Data/Class1.cs
 create mode 100644 ExamTemplate/Data/Models/Role.cs
 create mode 100644 ExamTemplate/Data/Models/User.cs
 create mode 100644 ExamTemplate/Data/TemplateContext.cs
 delete mode 100644 ExamTemplate/Web/appsettings.Development.json

(limited to 'ExamTemplate')

diff --git a/ExamTemplate/Data/Class1.cs b/ExamTemplate/Data/Class1.cs
deleted file mode 100644
index 78d17f8..0000000
--- a/ExamTemplate/Data/Class1.cs
+++ /dev/null
@@ -1,8 +0,0 @@
-using System;
-
-namespace Data
-{
-    public class Class1
-    {
-    }
-}
diff --git a/ExamTemplate/Data/Data.csproj b/ExamTemplate/Data/Data.csproj
index 7be2d32..909eb58 100644
--- a/ExamTemplate/Data/Data.csproj
+++ b/ExamTemplate/Data/Data.csproj
@@ -4,8 +4,13 @@
     <ProjectReference Include="..\Common\Common.csproj" />
   </ItemGroup>
 
+  <ItemGroup>
+    <PackageReference Include="Microsoft.AspNetCore.Identity.EntityFrameworkCore" Version="5.0.5" />
+    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="5.0.5" />
+  </ItemGroup>
+
   <PropertyGroup>
-    <TargetFramework>netstandard2.0</TargetFramework>
+    <TargetFramework>net5.0</TargetFramework>
   </PropertyGroup>
 
 </Project>
diff --git a/ExamTemplate/Data/Models/Role.cs b/ExamTemplate/Data/Models/Role.cs
new file mode 100644
index 0000000..94e5c48
--- /dev/null
+++ b/ExamTemplate/Data/Models/Role.cs
@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using Microsoft.AspNetCore.Identity;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace ExamTemplate.Data.Models
+{
+	[Table("Roles")]
+	public class Role : IdentityRole<Guid>
+	{
+		public List<User> Users { get; set; } = new List<User>();
+	}
+}
diff --git a/ExamTemplate/Data/Models/User.cs b/ExamTemplate/Data/Models/User.cs
new file mode 100644
index 0000000..0c3f4c7
--- /dev/null
+++ b/ExamTemplate/Data/Models/User.cs
@@ -0,0 +1,15 @@
+using System;
+using System.Collections.Generic;
+using Microsoft.AspNetCore.Identity;
+using System.ComponentModel.DataAnnotations.Schema;
+
+namespace ExamTemplate.Data.Models
+{
+	[Table("Users")]
+	public class User : IdentityUser<Guid>
+	{
+		public string FirstName { get; set; }
+		public string LastName { get; set; }
+		public List<Role> Roles { get; set; }
+	}
+}
diff --git a/ExamTemplate/Data/TemplateContext.cs b/ExamTemplate/Data/TemplateContext.cs
new file mode 100644
index 0000000..3a682b0
--- /dev/null
+++ b/ExamTemplate/Data/TemplateContext.cs
@@ -0,0 +1,20 @@
+using System;
+using ExamTemplate.Data.Models;
+using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore;
+
+namespace ExamTemplate.Data
+{
+	public class TemplateContext : IdentityDbContext<User, Role, Guid>
+	{
+		public TemplateContext(DbContextOptions<TemplateContext> options)
+			: base(options) { }
+
+		protected override void OnModelCreating(ModelBuilder builder)
+		{
+			/* Custom logic here! */
+
+			base.OnModelCreating(builder);
+		}
+	}
+}
diff --git a/ExamTemplate/Web/Startup.cs b/ExamTemplate/Web/Startup.cs
index 007f311..d6635b8 100644
--- a/ExamTemplate/Web/Startup.cs
+++ b/ExamTemplate/Web/Startup.cs
@@ -1,5 +1,7 @@
+using ExamTemplate.Data;
 using Microsoft.AspNetCore.Builder;
 using Microsoft.AspNetCore.Hosting;
+using Microsoft.EntityFrameworkCore;
 using Microsoft.Extensions.Configuration;
 using Microsoft.Extensions.DependencyInjection;
 using Microsoft.Extensions.Hosting;
@@ -19,6 +21,10 @@ namespace Web
 		public void ConfigureServices(IServiceCollection services)
 		{
 			services.AddControllersWithViews();
+
+			// Database configuration
+			services.AddDbContext<TemplateContext>(options =>
+					options.UseNpgsql(this.Configuration.GetConnectionString("LocalDBConnection")));
 		}
 
 		// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
diff --git a/ExamTemplate/Web/appsettings.Development.json b/ExamTemplate/Web/appsettings.Development.json
deleted file mode 100644
index dba68eb..0000000
--- a/ExamTemplate/Web/appsettings.Development.json
+++ /dev/null
@@ -1,9 +0,0 @@
-{
-  "Logging": {
-    "LogLevel": {
-      "Default": "Information",
-      "Microsoft": "Warning",
-      "Microsoft.Hosting.Lifetime": "Information"
-    }
-  }
-}
diff --git a/ExamTemplate/Web/appsettings.json b/ExamTemplate/Web/appsettings.json
index 81ff877..f49d9ab 100644
--- a/ExamTemplate/Web/appsettings.json
+++ b/ExamTemplate/Web/appsettings.json
@@ -1,4 +1,7 @@
 {
+  "ConnectionStrings": {
+    "LocalDBConnection": "Server=localhost;Port=5432;Database=TemplateContext;User Id=;Password=;"
+  },
   "Logging": {
     "LogLevel": {
       "Default": "Information",
-- 
cgit v1.2.3