Follow this open issue: https://github.com/aspnetzero/aspnet-zero-core/issues/442
Can you check the error log?
Oh, an AppService should not inherit RepositoryBase.
Create a new class DbmtabKWANPRepository:
public class DbmtabKWANPRepository : KWANPRepositoryBase<Dbmtab00>
{
private readonly IActiveTransactionProvider _transactionProvider;
public DbmtabStorePAppService(IDbContextProvider<KWANPDbContext> dbContextProvider, IActiveTransactionProvider transactionProvider) : base(dbContextProvider)
{
_transactionProvider = transactionProvider;
}
public async Task<string> GetUserNames()
{
EnsureConnectionOpen();
using (var command = CreateCommand("SELECT dbo.GetUsernameById(@tabtb1)", CommandType.Text, new SqlParameter("@tabtb1", "BUDGETTYPE")))
{
var username = (await command.ExecuteScalarAsync()).ToString();
return username;
}
}
private DbCommand CreateCommand(string commandText, CommandType commandType, params SqlParameter[] parameters)
{
// ...
}
private void EnsureConnectionOpen()
{
// ...
}
private DbTransaction GetActiveTransaction()
{
// ...
}
}
Inject DbmtabKWANPRepository in DbmtabStorePAppService:
public class DbmtabStorePAppService : IDbmtabStorePAppService
{
private readonly DbmtabKWANPRepository _repository;
public DbmtabStorePAppService(DbmtabKWANPRepository repository)
{
_repository = repository;
}
public async Task<string> GetUserNames()
{
return _repository.GetUserNames();
}
}
Don't overload GetAllListAsync - you have 2 or more methods named that, but you can only have 1.
It says KWANP.Dbmtab.DbmtabStorePAppService.GetAllListAsync is overloaded - unrelated to GetUserNames.
Can you check the error log in *.Web.Mvc\App_Data\Logs?
How is _shopifyManager.ValidateAndInstallHook implemented?
You need to login with your GitHub account to access the private repo. You can invite yourself here: <a class="postlink" href="https://aspnetzero.com/LicenseManagement">https://aspnetzero.com/LicenseManagement</a>
Can you provide more information?
Can you show the full error?