Activities of "alfar_re"

Hi,

Am new to Zero. I am trying to play around with the RAD tool and based on my tests it seems there is a problem.

Either I'm missing something in config or just a bug. I found this error on the log 'Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Amenities'.

I was creating an entity named 'Amenities'. See below audit log. ---------------------------------------------------------

User information <label class="col-lg-3 col-form-label">User name:</label><label class="col-form-label" id="AuditLogDetailModal_UserName">admin</label><label class="col-lg-3 col-form-label">IP address:</label><label class="col-form-label" id="AuditLogDetailModal_ClientIpAddress">::1</label><label class="col-lg-3 col-form-label">Client:</label><label class="col-form-label" id="AuditLogDetailModal_ClientName"></label><label class="col-lg-3 col-form-label">Browser:</label><label class="col-form-label" id="AuditLogDetailModal_BrowserInfo">Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.117 Safari/537.36</label>

Action information

<label class="col-lg-3 col-form-label">Service:</label><label class="col-form-label" id="AuditLogDetailModal_ServiceName">AmenitiesAppService</label><label class="col-lg-3 col-form-label">Action:</label><label class="col-form-label" id="AuditLogDetailModal_MethodName">CreateOrEdit</label><label class="col-lg-3 col-form-label">Time:</label><label class="col-form-label" id="AuditLogDetailModal_ExecutionTime">a minute ago (2020-01-11 07:13:19)</label><label class="col-lg-3 col-form-label">Duration:</label><label class="col-form-label" id="AuditLogDetailModal_Duration">7 ms</label><label class="col-lg-3 col-form-label">Parameters:</label>

{
    "input": {
        "description": "Parking",
        "id": null
    }
}

Custom data

None

Error state

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Amenities'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__164_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
ClientConnectionId:71a87cdb-5d9f-4a13-8b21-d290240c74a3
Error Number:208,State:1,Class:16
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Update.Internal.Batch...

Hi,

How can I add links to a table column such that when it is clicked it opens a details page or profile. E.g. if I click on a user inside the user list it opens the user profile.

Hi,

I'd like to get some insight on how to go around developing subsystems with their own separate menus.

For instance, looking at the attached screenshot, how would you set the system in a way where if the user clicked 'Accounting' they'd be served a sub-system with different menu and if they clicked 'Projects' they'd be served another and so forth.

This will be very helpful in guiding our development plan.

Thanks.

Hi,

I made changes to the AppNavigationProvider class and the resulting menu has [menu] surrounding the menus. How can these be removed?

Hi,

I'm wondering how to do this. I have an entity called MyTenant, and another called NextOfKin. NextOfKin has MyTenant as a navigation property which means the Id on MyTenant is a foreign key on NextOfKin. Inside the MyTenant grid, I have added a link inside Actions and I'd like that if a user clicks on the link it opens a modal containing a list of NextOfKins associated with the MyTenant. Is there an easy way to do this?

Hi,

I created entities using the RAD Tool. Under base class, I selected 'Entity'. How can I change this to 'FullyAuditedEntity' on existing entities?

Hi,

When you allow tenants to access audit logs through the Administrator menu, do they view their own audits only?

Previous title: INDEX NOT WORKING

Hi,

Am using ASP.NET CORE + JQUERY

Somehow, some index pages are not displaying data and there's no error. I've checked all possible reasons including regenerating the entities. What could be the possible cause?

Previous title: LOOK UP TABLE ISSUE

Hi,

Am getting this error on the filter on look up tables.

System.InvalidOperationException: The LINQ expression 'DbSet<RentalInvoice> .Where(r => __ef_filter__p_0 || !(((ISoftDelete)r).IsDeleted) && __ef_filter__p_1 || (Nullable<int>)((IMustHaveTenant)r).TenantId == __ef_filter__CurrentTenantId_2) .Where(r => r.InvoiceNumber.ToString().Contains(__input_Filter_0))' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to either AsEnumerable(), AsAsyncEnumerable(), ToList(), or ToListAsync(). See https://go.microsoft.com/fwlink/?linkid=2101038 for more information. at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.<VisitMethodCall>g__CheckTranslated|8_0(ShapedQueryExpression translated, <>c__DisplayClass8_0& ) at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression) at Microsoft.EntityFrameworkCore.Query.RelationalQueryableMethodTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression) at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression) at Microsoft.EntityFrameworkCore.Query.RelationalQueryableMethodTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression) at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query) at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass12_0`1.

Hi,

Each time I make changes to the entity structure, all changes, including the code added to the services gets lost. How can I prevent this?