Activities of "Spospisil"

Did you receive it? Have access now? I can't loose another day of this not being addressed.

Email sent

how about now?

access added

I created another ticket regarding this sample project. You need to address that one first.

Run the dbmigrator to create the db and then run the project and you’ll see the error with the blazor iui

I have given you access to a repository for another issue I'm having while creating this sample project for you.

• ABP Framework version: v8.3.3
• UI Type: Blazor WASM
• Database System: EF Core (SQL Server)
• Tiered (for MVC) or Auth Server Separated (for Angular): yes

Hi,

While creating a new solution to demonstrate to support an issue I'm having with implementing a custom data filter I am getting a Connection Refused error on the sample project. I created this project using ABP Studio and then using ABP Suite to add the MaintenanceModule's project to my solution. I've create a github repo for this sample project and have given maliming access to it.

Please let me know what the issue is so I can continue working on it to demonstrate the other issue I already have a ticket open for.

Steve

Hi,

Do you have a place where I can share some sample code with you so you can help me determine what the issue is that I'm getting with this?

I am asking you specific questions and you’re not answering them at all.

I’ve asked you to detail where the changes such as the interface class goes representing the data filter so that it can be added to domain classes in other tiered modules I’m referencing.

This is what the current DBContext class is for my blazor app. I have not implemented the suggested changes from your post the details them out, but I don't want to have to make this change to all my other ABP generated modules in my solution. I asked previously if those other DB contexts ( ILanguageManagementDbContext, ISystemMaintenanceDbContext, IReportQuickDesignerDbContext and ISecurityDbContext) also need these changes or if just having the [ReplaceDBContext] negates that and you have not responded directly to that question.

I also asked if you could detail what projects each of the proposed changes in your post (https://abp.io/community/articles/switching-between-organization-units-i5tokpzt) as it's not clear which projects they should go so the project compiles correctly.

Again seeing an actual example of a tiered blazor WASM solution referencing an ABP Generated Module (with it's own DBContext) being referenced by this blazor wasm project would be helpful.

namespace CFDataSystems.StructureCloud.EntityFrameworkCore;

[ConnectionStringName(StructureCloudDbProperties.HostConnectionStringName)]
[ReplaceDbContext(typeof(IIdentityProDbContext))]
[ReplaceDbContext(typeof(IIdentityDbContext))]
[ReplaceDbContext(typeof(ISaasDbContext))]
[ReplaceDbContext(typeof(ILanguageManagementDbContext))]
[ReplaceDbContext(typeof(ISystemMaintenanceDbContext))]
[ReplaceDbContext(typeof(IReportQuickDesignerDbContext))]
[ReplaceDbContext(typeof(ISecurityDbContext))]
public class StructureCloudDbContext : AbpDbContext<StructureCloudDbContext>,
    IStructureCloudDbContext,
    IIdentityProDbContext,
    IIdentityDbContext,
    ISaasDbContext,
    ILanguageManagementDbContext,
    ISystemMaintenanceDbContext,
    IReportQuickDesignerDbContext,
    ISecurityDbContext
{

    //Custom Tables
    public DbSet<TenantInformation> TenantInformation { get; set; }

    public DbSet<Screen> Screens { get; set; }

    public DbSet<UserDashboard> UserDashboards { get; set; }
    public DbSet<UserInformation> UserInformation { get; set; }
    public DbSet<UserLaunch> UserLaunch { get; set; }
    public DbSet<Template> Template { get; set; }

	//Saas Tables
	public DbSet<Tenant> Tenants { get; set; }
    public DbSet<Edition> Editions { get; set; }
    public DbSet<TenantConnectionString> TenantConnectionStrings { get; set; }

    //Itentity Tables
    public DbSet<IdentityUser> Users { get; set; }
    public DbSet<IdentityRole> Roles { get; set; }
    public DbSet<IdentityClaimType> ClaimTypes { get; set; }
    public DbSet<OrganizationUnit> OrganizationUnits { get; set; }
    public DbSet<IdentitySecurityLog> SecurityLogs { get; set; }
    public DbSet<IdentityLinkUser> LinkUsers { get; set; }
    public DbSet<IdentityUserDelegation> UserDelegations { get; }

    //Language tables
    public DbSet<Language> Languages { get; set; }
    public DbSet<LanguageText> LanguageTexts { get; set; }
    public DbSet<LocalizationResourceRecord> LocalizationResources { get; set; }
    public DbSet<LocalizationTextRecord> LocalizationTexts { get; set; }

    //System Maintenance Tables
    public DbSet<SystemMaintenance.Domain.Attributes.Attribute> Attribute { get; set; }
    public DbSet<DataView> Views { get; set; }
    public DbSet<ViewJoin> ViewJoins { get; set; }
    public DbSet<JoinField> JoinFields { get; set; }
    public DbSet<CalculatedField> CalculatedFields { get; set; }
    public DbSet<ReferencedField> ReferencedFields { get; set; }
    public DbSet<DataType> DataTypes { get; set; }
    public DbSet<DataSourceQuery> DataSourceQueries { get; set; }
    public DbSet<DataSourceHeader> DataSourceHeaders { get; set; }
    public DbSet<DataSourceDetail> DataSourceDetails { get; set; }
    public DbSet<DataSourceProcedure> DataSourceProcedures { get; set; }
    public DbSet<Application> Applications { get; set; }
    public DbSet<Procedure> Procedures { get; set; }
    public DbSet<MenuGroup> MenuGroups { get; set; }
    public DbSet<RaiqiHeader> RaiqiHeader { get; set; }
    public DbSet<RaiqiDetail> RaiqiDetails { get; set; }
    public DbSet<Parameter> Parameters { get; set; }
    public DbSet<SqlTables> SqlTables { get; set; }

    //Security Tables
    public DbSet<SecurityRole> SecurityRoles { get; set; }
    public DbSet<SecurityRoleProcedure> SecurityRoleProcedures { get; set; }
    public DbSet<UserSecurityRole> UserSecurityRoles { get; set; }
    public DbSet<SecurityRoleStructure> SecurityRolesStructure { get; set; }
    public DbSet<SecurityRoleStructureWithProcedures> SecurityRolesStructureWithProcedures { get; set; }
    public DbSet<UserPermissionView> UserPermissions { get; set; }


    public StructureCloudDbContext(DbContextOptions<StructureCloudDbContext> options)
        : base(options)
    {
    }
    protected override void OnModelCreating(ModelBuilder builder)
    {
        //base.OnModelCreating(builder);
        builder.SetMultiTenancySide(MultiTenancySides.Host);

        if (builder.IsHostDatabase())
        {
            ConfigurDatabaseSettings(builder);
        }

        builder.HasDefaultSchema("public");
        base.OnModelCreating(builder);
    }

    private void ConfigurDatabaseSettings(ModelBuilder builder)
    {
        AbpCommonDbProperties.DbTablePrefix = string.Empty;
        builder.ConfigurePermissionManagement();
        builder.ConfigureSettingManagement();
        builder.ConfigureBackgroundJobs();
        builder.ConfigureIdentityPro();
        builder.ConfigureFeatureManagement();
        builder.ConfigureLanguageManagement();
        builder.ConfigureAuditLogging();
        //PaymentDbProperties.DbTablePrefix = string.Empty;
        //builder.ConfigurePayment();
        builder.ConfigureOpenIddict();
        SaasDbProperties.DbTablePrefix = string.Empty;
        builder.ConfigureSaas();
        TextTemplateManagementDbProperties.DbTablePrefix = string.Empty;
        builder.ConfigureTextTemplateManagement();
        builder.ConfigureBlobStoring();
        builder.ConfigureGdpr();
        //builder.ConfigureCmsKit();
        //builder.ConfigureCmsKitPro();

        builder.ConfigureHostTables();
        StructureCloudDbProperties.DbSchema = "structurecloud_settings";
        builder.ConfigureSystemMaintenance();
        builder.ConfigureSecurity();

        AccountsPayableDbProperties.DbSchema = "vision";
        builder.ConfigureAccountsPayable();
        AccountsReceivableDbProperties.DbSchema = "vision";  
        builder.ConfigureAccountsReceivable();
        JobCostDbProperties.DbSchema = "vision";
        builder.ConfigureJobCost();
        WorkOrderDbProperties.DbSchema = "vision";
        builder.ConfigureWorkOrders();
        PurchaseOrderDbProperties.DbSchema = "vision";
        builder.ConfigurePurchaseOrders();

        builder.ConfigureReportQuickDesigner();

    }


}