public async Task <List <UserRoleEntity> > GetUserRolesByUserId(GetUserRolesByUserIdRequest request)
{
var sqlStoredProc = "sp_user_roles_get_by_user_id";
var response = await DapperAdapter.GetFromStoredProcAsync <UserRoleEntity>
(
storedProcedureName : sqlStoredProc,
parameters : request,
dbconnectionString : DefaultConnectionString,
sqltimeout : DefaultTimeOut,
dbconnection : _connection,
dbtransaction : _transaction);
return(response.ToList());
}
public IList <UserRole> Handle(GetUserRolesByUserIdRequest query)
{
return(repository.Query <Entities.AssociateUserRole>().Where(m => m.Associate.Code == query.UserId && m.Associate.Active)
.ProjectTo <UserRole>().ToList());
}
