refactor: Password reset service

- Use FulfillPasswordResetRequestResult to indicate fulfillment result
- Rename db names forgot_password_requests > password_reset_requests

1 files changed, 7 insertions, 282 deletions

diff --git a/code/api/src/Migrations/AppDbContextModelSnapshot.cs b/code/api/src/Migrations/AppDbContextModelSnapshot.cs
index f2031c1..a266339 100644
--- a/code/api/src/Migrations/AppDbContextModelSnapshot.cs
+++ b/code/api/src/Migrations/AppDbContextModelSnapshot.cs
@@ -17,7 +17,7 @@ namespace IOL.GreatOffice.Api.Migrations
         {
 #pragma warning disable 612, 618
             modelBuilder
-                .HasAnnotation("ProductVersion", "6.0.10")
+                .HasAnnotation("ProductVersion", "7.0.0")
                 .HasAnnotation("Relational:MaxIdentifierLength", 63);
 
             NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
@@ -453,7 +453,7 @@ namespace IOL.GreatOffice.Api.Migrations
                     b.ToTable("customer_groups", (string)null);
                 });
 
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
+            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.PasswordResetRequest", b =>
                 {
                     b.Property<Guid>("Id")
                         .ValueGeneratedOnAdd()
@@ -469,12 +469,12 @@ namespace IOL.GreatOffice.Api.Migrations
                         .HasColumnName("user_id");
 
                     b.HasKey("Id")
-                        .HasName("pk_forgot_password_requests");
+                        .HasName("pk_password_reset_requests");
 
                     b.HasIndex("UserId")
-                        .HasDatabaseName("ix_forgot_password_requests_user_id");
+                        .HasDatabaseName("ix_password_reset_requests_user_id");
 
-                    b.ToTable("forgot_password_requests", (string)null);
+                    b.ToTable("password_reset_requests", (string)null);
                 });
 
             modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Project", b =>
@@ -744,213 +744,6 @@ namespace IOL.GreatOffice.Api.Migrations
                     b.ToTable("tenants", (string)null);
                 });
 
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
-                {
-                    b.Property<Guid>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("uuid")
-                        .HasColumnName("id");
-
-                    b.Property<string>("Color")
-                        .HasColumnType("text")
-                        .HasColumnName("color");
-
-                    b.Property<DateTime>("CreatedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("created_at");
-
-                    b.Property<Guid?>("CreatedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("created_by");
-
-                    b.Property<bool>("Deleted")
-                        .HasColumnType("boolean")
-                        .HasColumnName("deleted");
-
-                    b.Property<DateTime?>("DeletedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("deleted_at");
-
-                    b.Property<Guid?>("DeletedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("deleted_by");
-
-                    b.Property<DateTime?>("ModifiedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("modified_at");
-
-                    b.Property<Guid?>("ModifiedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("modified_by");
-
-                    b.Property<string>("Name")
-                        .HasColumnType("text")
-                        .HasColumnName("name");
-
-                    b.Property<Guid?>("TenantId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("tenant_id");
-
-                    b.Property<Guid?>("UserId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("user_id");
-
-                    b.HasKey("Id")
-                        .HasName("pk_time_categories");
-
-                    b.HasIndex("TenantId")
-                        .HasDatabaseName("ix_time_categories_tenant_id");
-
-                    b.HasIndex("UserId")
-                        .HasDatabaseName("ix_time_categories_user_id");
-
-                    b.ToTable("time_categories", (string)null);
-                });
-
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
-                {
-                    b.Property<Guid>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("uuid")
-                        .HasColumnName("id");
-
-                    b.Property<Guid?>("CategoryId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("category_id");
-
-                    b.Property<DateTime>("CreatedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("created_at");
-
-                    b.Property<Guid?>("CreatedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("created_by");
-
-                    b.Property<bool>("Deleted")
-                        .HasColumnType("boolean")
-                        .HasColumnName("deleted");
-
-                    b.Property<DateTime?>("DeletedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("deleted_at");
-
-                    b.Property<Guid?>("DeletedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("deleted_by");
-
-                    b.Property<string>("Description")
-                        .HasColumnType("text")
-                        .HasColumnName("description");
-
-                    b.Property<DateTime?>("ModifiedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("modified_at");
-
-                    b.Property<Guid?>("ModifiedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("modified_by");
-
-                    b.Property<DateTime>("Start")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("start");
-
-                    b.Property<DateTime>("Stop")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("stop");
-
-                    b.Property<Guid?>("TenantId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("tenant_id");
-
-                    b.Property<Guid?>("UserId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("user_id");
-
-                    b.HasKey("Id")
-                        .HasName("pk_time_entries");
-
-                    b.HasIndex("CategoryId")
-                        .HasDatabaseName("ix_time_entries_category_id");
-
-                    b.HasIndex("TenantId")
-                        .HasDatabaseName("ix_time_entries_tenant_id");
-
-                    b.HasIndex("UserId")
-                        .HasDatabaseName("ix_time_entries_user_id");
-
-                    b.ToTable("time_entries", (string)null);
-                });
-
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
-                {
-                    b.Property<Guid>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("uuid")
-                        .HasColumnName("id");
-
-                    b.Property<string>("Color")
-                        .HasColumnType("text")
-                        .HasColumnName("color");
-
-                    b.Property<DateTime>("CreatedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("created_at");
-
-                    b.Property<Guid?>("CreatedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("created_by");
-
-                    b.Property<bool>("Deleted")
-                        .HasColumnType("boolean")
-                        .HasColumnName("deleted");
-
-                    b.Property<DateTime?>("DeletedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("deleted_at");
-
-                    b.Property<Guid?>("DeletedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("deleted_by");
-
-                    b.Property<DateTime?>("ModifiedAt")
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("modified_at");
-
-                    b.Property<Guid?>("ModifiedBy")
-                        .HasColumnType("uuid")
-                        .HasColumnName("modified_by");
-
-                    b.Property<string>("Name")
-                        .HasColumnType("text")
-                        .HasColumnName("name");
-
-                    b.Property<Guid?>("TenantId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("tenant_id");
-
-                    b.Property<Guid?>("TimeEntryId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("time_entry_id");
-
-                    b.Property<Guid?>("UserId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("user_id");
-
-                    b.HasKey("Id")
-                        .HasName("pk_time_labels");
-
-                    b.HasIndex("TenantId")
-                        .HasDatabaseName("ix_time_labels_tenant_id");
-
-                    b.HasIndex("TimeEntryId")
-                        .HasDatabaseName("ix_time_labels_time_entry_id");
-
-                    b.HasIndex("UserId")
-                        .HasDatabaseName("ix_time_labels_user_id");
-
-                    b.ToTable("time_labels", (string)null);
-                });
-
             modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Todo", b =>
                 {
                     b.Property<Guid>("Id")
@@ -1528,14 +1321,14 @@ namespace IOL.GreatOffice.Api.Migrations
                     b.Navigation("OwningUser");
                 });
 
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.ForgotPasswordRequest", b =>
+            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.PasswordResetRequest", b =>
                 {
                     b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "User")
                         .WithMany()
                         .HasForeignKey("UserId")
                         .OnDelete(DeleteBehavior.Cascade)
                         .IsRequired()
-                        .HasConstraintName("fk_forgot_password_requests_users_user_id");
+                        .HasConstraintName("fk_password_reset_requests_users_user_id");
 
                     b.Navigation("User");
                 });
@@ -1615,69 +1408,6 @@ namespace IOL.GreatOffice.Api.Migrations
                     b.Navigation("OwningUser");
                 });
 
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeCategory", b =>
-                {
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "OwningTenant")
-                        .WithMany()
-                        .HasForeignKey("TenantId")
-                        .HasConstraintName("fk_time_categories_tenants_tenant_id");
-
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "OwningUser")
-                        .WithMany()
-                        .HasForeignKey("UserId")
-                        .HasConstraintName("fk_time_categories_users_user_id");
-
-                    b.Navigation("OwningTenant");
-
-                    b.Navigation("OwningUser");
-                });
-
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
-                {
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeCategory", "Category")
-                        .WithMany()
-                        .HasForeignKey("CategoryId")
-                        .HasConstraintName("fk_time_entries_time_categories_category_id");
-
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "OwningTenant")
-                        .WithMany()
-                        .HasForeignKey("TenantId")
-                        .HasConstraintName("fk_time_entries_tenants_tenant_id");
-
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "OwningUser")
-                        .WithMany()
-                        .HasForeignKey("UserId")
-                        .HasConstraintName("fk_time_entries_users_user_id");
-
-                    b.Navigation("Category");
-
-                    b.Navigation("OwningTenant");
-
-                    b.Navigation("OwningUser");
-                });
-
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeLabel", b =>
-                {
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.Tenant", "OwningTenant")
-                        .WithMany()
-                        .HasForeignKey("TenantId")
-                        .HasConstraintName("fk_time_labels_tenants_tenant_id");
-
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.TimeEntry", null)
-                        .WithMany("Labels")
-                        .HasForeignKey("TimeEntryId")
-                        .HasConstraintName("fk_time_labels_time_entries_time_entry_id");
-
-                    b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "OwningUser")
-                        .WithMany()
-                        .HasForeignKey("UserId")
-                        .HasConstraintName("fk_time_labels_users_user_id");
-
-                    b.Navigation("OwningTenant");
-
-                    b.Navigation("OwningUser");
-                });
-
             modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Todo", b =>
                 {
                     b.HasOne("IOL.GreatOffice.Api.Data.Database.User", "AssignedTo")
@@ -1834,11 +1564,6 @@ namespace IOL.GreatOffice.Api.Migrations
                     b.Navigation("Users");
                 });
 
-            modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.TimeEntry", b =>
-                {
-                    b.Navigation("Labels");
-                });
-
             modelBuilder.Entity("IOL.GreatOffice.Api.Data.Database.Todo", b =>
                 {
                     b.Navigation("Comments");