feat: Initial after clean slate

10 files changed, 247 insertions, 0 deletions

diff --git a/server/src/Data/Database/ApiAccessToken.cs b/server/src/Data/Database/ApiAccessToken.cs
new file mode 100644
index 0000000..3eff5f3
--- /dev/null
+++ b/server/src/Data/Database/ApiAccessToken.cs
@@ -0,0 +1,31 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class ApiAccessToken : Base
+{
+	public User User { get; set; }
+	public DateTime ExpiryDate { get; set; }
+	public bool AllowRead { get; set; }
+	public bool AllowCreate { get; set; }
+	public bool AllowUpdate { get; set; }
+	public bool AllowDelete { get; set; }
+	public bool HasExpired => ExpiryDate < DateTime.UtcNow;
+	public ApiAccessTokenDto AsDto => new(this);
+
+	public class ApiAccessTokenDto
+	{
+		public ApiAccessTokenDto(ApiAccessToken source) {
+			ExpiryDate = source.ExpiryDate;
+			AllowRead = source.AllowRead;
+			AllowCreate = source.AllowCreate;
+			AllowUpdate = source.AllowUpdate;
+			AllowDelete = source.AllowDelete;
+		}
+
+		public DateTime ExpiryDate { get; set; }
+		public bool AllowRead { get; set; }
+		public bool AllowCreate { get; set; }
+		public bool AllowUpdate { get; set; }
+		public bool AllowDelete { get; set; }
+		public bool HasExpired => ExpiryDate < DateTime.UtcNow;
+	}
+}
diff --git a/server/src/Data/Database/Base.cs b/server/src/Data/Database/Base.cs
new file mode 100644
index 0000000..2439668
--- /dev/null
+++ b/server/src/Data/Database/Base.cs
@@ -0,0 +1,14 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class Base
+{
+	protected Base() {
+		Id = Guid.NewGuid();
+		CreatedAt = DateTime.UtcNow;
+	}
+
+	public Guid Id { get; init; }
+	public DateTime CreatedAt { get; init; }
+	public DateTime? ModifiedAt { get; private set; }
+	public void Modified() => ModifiedAt = DateTime.UtcNow;
+}
diff --git a/server/src/Data/Database/BaseWithOwner.cs b/server/src/Data/Database/BaseWithOwner.cs
new file mode 100644
index 0000000..eb4438d
--- /dev/null
+++ b/server/src/Data/Database/BaseWithOwner.cs
@@ -0,0 +1,24 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+/// <summary>
+/// Base class for all entities.
+/// </summary>
+public class BaseWithOwner : Base
+{
+	protected BaseWithOwner() { }
+
+	protected BaseWithOwner(Guid userId) {
+		UserId = userId;
+	}
+
+	public Guid UserId { get; init; }
+	public User User { get; init; }
+	public Guid TenantId { get; set; }
+	public Tenant Tenant { get; init; }
+	public Guid ModifiedById { get; init; }
+	public User ModifiedBy { get; set; }
+	public Guid CreatedById { get; init; }
+	public User CreatedBy { get; set; }
+	public Guid DeletedById { get; init; }
+	public User DeletedBy { get; set; }
+}
diff --git a/server/src/Data/Database/ForgotPasswordRequest.cs b/server/src/Data/Database/ForgotPasswordRequest.cs
new file mode 100644
index 0000000..164f09d
--- /dev/null
+++ b/server/src/Data/Database/ForgotPasswordRequest.cs
@@ -0,0 +1,23 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class ForgotPasswordRequest
+{
+	public ForgotPasswordRequest() { }
+
+	public ForgotPasswordRequest(User user) {
+		CreatedAt = DateTime.UtcNow;
+		Id = Guid.NewGuid();
+		User = user;
+	}
+
+	public Guid Id { get; set; }
+	public Guid UserId { get; set; }
+	public User User { get; set; }
+	public DateTime CreatedAt { get; set; }
+
+	[NotMapped]
+	public DateTime ExpirationDate => CreatedAt.AddMinutes(15);
+
+	[NotMapped]
+	public bool IsExpired => DateTime.Compare(ExpirationDate, DateTime.UtcNow) < 0;
+}
diff --git a/server/src/Data/Database/GithubUserMapping.cs b/server/src/Data/Database/GithubUserMapping.cs
new file mode 100644
index 0000000..dbdb2b7
--- /dev/null
+++ b/server/src/Data/Database/GithubUserMapping.cs
@@ -0,0 +1,9 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class GithubUserMapping
+{
+	public User User { get; set; }
+	public string GithubId { get; set; }
+	public string Email { get; set; }
+	public string RefreshToken { get; set; }
+}
diff --git a/server/src/Data/Database/Tenant.cs b/server/src/Data/Database/Tenant.cs
new file mode 100644
index 0000000..3028d13
--- /dev/null
+++ b/server/src/Data/Database/Tenant.cs
@@ -0,0 +1,10 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class Tenant : BaseWithOwner
+{
+	public string Name { get; set; }
+	public string Description { get; set; }
+	public string ContactEmail { get; set; }
+	public Guid MasterUserId { get; set; }
+	public string MasterUserPassword { get; set; }
+}
diff --git a/server/src/Data/Database/TimeCategory.cs b/server/src/Data/Database/TimeCategory.cs
new file mode 100644
index 0000000..69c6957
--- /dev/null
+++ b/server/src/Data/Database/TimeCategory.cs
@@ -0,0 +1,31 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class TimeCategory : BaseWithOwner
+{
+	public TimeCategory() { }
+	public TimeCategory(Guid userId) : base(userId) { }
+	public string Name { get; set; }
+	public string Color { get; set; }
+	public TimeCategoryDto AsDto => new(this);
+
+	public class TimeCategoryDto
+	{
+		public TimeCategoryDto() { }
+
+		public TimeCategoryDto(TimeCategory sourceEntry = default) {
+			if (sourceEntry == default) {
+				return;
+			}
+
+			Id = sourceEntry.Id;
+			ModifiedAt = sourceEntry.ModifiedAt;
+			Name = sourceEntry.Name;
+			Color = sourceEntry.Color;
+		}
+
+		public Guid Id { get; set; }
+		public DateTime? ModifiedAt { get; set; }
+		public string Name { get; set; }
+		public string Color { get; set; }
+	}
+}
diff --git a/server/src/Data/Database/TimeEntry.cs b/server/src/Data/Database/TimeEntry.cs
new file mode 100644
index 0000000..46c62e1
--- /dev/null
+++ b/server/src/Data/Database/TimeEntry.cs
@@ -0,0 +1,45 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class TimeEntry : BaseWithOwner
+{
+	public TimeEntry() { }
+	public TimeEntry(Guid userId) : base(userId) { }
+	public DateTime Start { get; set; }
+	public DateTime Stop { get; set; }
+	public string Description { get; set; }
+	public ICollection<TimeLabel> Labels { get; set; }
+	public TimeCategory Category { get; set; }
+	public TimeEntryDto AsDto => new(this);
+
+	public class TimeEntryDto
+	{
+		public TimeEntryDto() { }
+
+		public TimeEntryDto(TimeEntry sourceEntry = default) {
+			if (sourceEntry == default) {
+				return;
+			}
+
+			Id = sourceEntry.Id;
+			ModifiedAt = sourceEntry.ModifiedAt;
+			Stop = sourceEntry.Stop;
+			Start = sourceEntry.Start;
+			Description = sourceEntry.Description;
+			if (sourceEntry.Labels != default) {
+				Labels = sourceEntry.Labels
+									.Select(t => t.AsDto)
+									.ToList();
+			}
+
+			Category = sourceEntry.Category.AsDto;
+		}
+
+		public Guid? Id { get; set; }
+		public DateTime? ModifiedAt { get; set; }
+		public DateTime Start { get; set; }
+		public DateTime Stop { get; set; }
+		public string Description { get; set; }
+		public List<TimeLabel.TimeLabelDto> Labels { get; set; }
+		public TimeCategory.TimeCategoryDto Category { get; set; }
+	}
+}
diff --git a/server/src/Data/Database/TimeLabel.cs b/server/src/Data/Database/TimeLabel.cs
new file mode 100644
index 0000000..55e20b0
--- /dev/null
+++ b/server/src/Data/Database/TimeLabel.cs
@@ -0,0 +1,31 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class TimeLabel : BaseWithOwner
+{
+	public TimeLabel() { }
+	public TimeLabel(Guid userId) : base(userId) { }
+	public string Name { get; set; }
+	public string Color { get; set; }
+
+	[NotMapped]
+	public TimeLabelDto AsDto => new(this);
+
+	public class TimeLabelDto
+	{
+		public TimeLabelDto() { }
+
+		public TimeLabelDto(TimeLabel sourceEntry) {
+			Id = sourceEntry.Id;
+			CreatedAt = sourceEntry.CreatedAt;
+			ModifiedAt = sourceEntry.ModifiedAt;
+			Name = sourceEntry.Name;
+			Color = sourceEntry.Color;
+		}
+
+		public Guid Id { get; set; }
+		public DateTime CreatedAt { get; set; }
+		public DateTime? ModifiedAt { get; set; }
+		public string Name { get; set; }
+		public string Color { get; set; }
+	}
+}
diff --git a/server/src/Data/Database/User.cs b/server/src/Data/Database/User.cs
new file mode 100644
index 0000000..c5063f6
--- /dev/null
+++ b/server/src/Data/Database/User.cs
@@ -0,0 +1,29 @@
+namespace IOL.GreatOffice.Api.Data.Database;
+
+public class User : Base
+{
+	public User() { }
+
+	public User(string username) {
+		Username = username;
+	}
+
+	public string Username { get; set; }
+	public string Password { get; set; }
+
+
+	public void HashAndSetPassword(string password) {
+		Password = PasswordHelper.HashPassword(password);
+	}
+
+	public bool VerifyPassword(string password) {
+		return PasswordHelper.Verify(password, Password);
+	}
+
+	public IEnumerable<Claim> DefaultClaims() {
+		return new Claim[] {
+				new(AppClaims.USER_ID, Id.ToString()),
+				new(AppClaims.NAME, Username),
+		};
+	}
+}