public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>() .AddDbContext<AppDbContext>(o => o.UseNpgsql(cfg.Conn("Default"))); public sealed class IssueService : IIssueService{ private readonly AppDbContext _db; private readonly ILogger _log; public async Task<Result<Issue>> Create( CreateIssue cmd, CancellationToken ct) { var project = await _db.Projects .FindAsync([cmd.ProjectId], ct); if (project is null) return Result.NotFound("project"); var issue = new Issue { Title = cmd.Title.Trim(), Status = Status.Backlog, CreatedAt = DateTimeOffset.UtcNow, }; project.Issues.Add(issue); await _db.SaveChangesAsync(ct); _log.LogInformation("issue {Id}", issue.Id); return Result.Ok(issue); }} app.MapGet("/issues/{id}", async ( Guid id, IIssueService svc) => await svc.GetAsync(id) is { } i ? Results.Ok(i) : Results.NotFound()); builder.Services .AddScoped<IIssueService, IssueService>()

Web App / Lead System · Grant Boilers (ECO4)

Grant Boilers: Eligibility Funnel & Lead Routing

A boiler-grant web funnel with eligibility-filtered dynamic forms that route only qualifying leads into the CRM.

// outcome

Qualified-only intake · CPL cut 72%

The challenge

Leads were arriving unqualified for ECO4 grants and being manually sorted, wasting both staff time and ad budget on people who could never convert.

What I built

I built dynamic, eligibility-filtered forms so only qualifying applicants can submit, backed by server-side validation and a CRM-integrated capture layer that routes each lead by region and criteria (and to the client's chosen destinations via webhooks). Regional landing pages, A/B-testable components, and full-funnel event analytics rounded it out.

The result

Only pre-qualified leads reach the CRM, cutting cost-per-lead 72% and removing manual triage. 4× qualified leads, with mobile PageSpeed lifted from 49 to 97.

"They engineered a funnel that filters leads before they ever hit our CRM. We only spend time on people who actually qualify."

Kai Adams, CEO, Grant Boilers

£ cat stack.json

ASP.NET Core
Dynamic Forms
CRM Webhooks
Server-side Validation
A/B Testing
GA4 Events

Want something similar built?

let's talk