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()); }