Community Vote Tracker API

Completed

Details Activity Architecture

May 2024 - Feb 2025 (10 months)

Community Vote Tracker API is the backend system that powers PMAC administration and end-user voting workflows.

It provides authentication, community and user management, issue voting lifecycle endpoints, invitation/password flows, and supporting push/email integrations while maintaining SQL-backed consistency through migration-driven evolution.

Built with: ASP.NET Core 8, C#, Dapper, FluentMigrator, SQL Server stored procedures, JWT auth middleware, AutoMapper, MailKit/MimeKit, OneSignal API, and Azure Application Insights.

Related Projects

February 2025

Feb 27

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates; SQL migration + stored-procedure contract updates (Dapper-backed services).

Feb 25

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Release/deployment readiness updates (version checks + environment config); Validation/error-handling hardening and backend manager/service refactors.

Feb 24

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; SQL migration + stored-procedure contract updates (Dapper-backed services).

Feb 13

Validation/error-handling hardening and backend manager/service refactors.

Feb 12

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Feb 11

PMAC admin/user-management contract and role/access logic updates; Validation/error-handling hardening and backend manager/service refactors.

Feb 10

PMAC admin/user-management contract and role/access logic updates; Invitation/password-recovery pipelines and email-delivery refinements.

Feb 06

SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Feb 04

Backend API/service contract updates across PMAC, community, and voting modules.

Feb 03

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; PMAC admin/user-management contract and role/access logic updates; Invitation/password-recovery pipelines and email-delivery refinements.

January 2025

Jan 31

PMAC admin/user-management contract and role/access logic updates; Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Jan 30

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Jan 29

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates.

Jan 28

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; PMAC admin/user-management contract and role/access logic updates; Invitation/password-recovery pipelines and email-delivery refinements.

Jan 27

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates; Invitation/password-recovery pipelines and email-delivery refinements.

Jan 24

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates.

Jan 23

Validation/error-handling hardening and backend manager/service refactors.

Jan 22

PMAC admin/user-management contract and role/access logic updates; SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Jan 21

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; PMAC admin/user-management contract and role/access logic updates.

Jan 20

Backend API/service contract updates across PMAC, community, and voting modules.

Jan 16

SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Jan 15

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; PMAC admin/user-management contract and role/access logic updates; Invitation/password-recovery pipelines and email-delivery refinements.

Jan 14

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Jan 13

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Jan 10

PMAC admin/user-management contract and role/access logic updates.

Jan 09

Validation/error-handling hardening and backend manager/service refactors.

Jan 08

Backend API/service contract updates across PMAC, community, and voting modules.

Jan 03

PMAC admin/user-management contract and role/access logic updates.

Jan 02

Backend API/service contract updates across PMAC, community, and voting modules.

December 2024

Dec 31

Backend API/service contract updates across PMAC, community, and voting modules.

Dec 24

Validation/error-handling hardening and backend manager/service refactors.

Dec 23

Backend API/service contract updates across PMAC, community, and voting modules.

Dec 20

PMAC admin/user-management contract and role/access logic updates; SQL migration + stored-procedure contract updates (Dapper-backed services); Push-notification dispatch and issue-event signaling adjustments.

Dec 19

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Release/deployment readiness updates (version checks + environment config).

Dec 18

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates.

Dec 17

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; PMAC admin/user-management contract and role/access logic updates; Push-notification dispatch and issue-event signaling adjustments.

Dec 12

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates.

Dec 11

Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services).

Dec 10

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates.

Dec 09

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; PMAC admin/user-management contract and role/access logic updates.

Dec 06

Invitation/password-recovery pipelines and email-delivery refinements.

Dec 05

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries.

Dec 03

SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Dec 02

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries.

November 2024

Nov 30

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; SQL migration + stored-procedure contract updates (Dapper-backed services).

Nov 29

Validation/error-handling hardening and backend manager/service refactors.

Nov 25

Validation/error-handling hardening and backend manager/service refactors.

Nov 22

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Validation/error-handling hardening and backend manager/service refactors.

Nov 21

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries.

Nov 11

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries.

Nov 08

Backend API/service contract updates across PMAC, community, and voting modules.

Nov 07

Backend API/service contract updates across PMAC, community, and voting modules.

Nov 01

Backend API/service contract updates across PMAC, community, and voting modules.

October 2024

Oct 31

Backend API/service contract updates across PMAC, community, and voting modules.

Oct 25

Invitation/password-recovery pipelines and email-delivery refinements.

Oct 17

Backend API/service contract updates across PMAC, community, and voting modules.

Oct 11

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; SQL migration + stored-procedure contract updates (Dapper-backed services).

Oct 10

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Oct 07

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Oct 04

Backend API/service contract updates across PMAC, community, and voting modules.

Oct 03

Backend API/service contract updates across PMAC, community, and voting modules.

Oct 02

Backend API/service contract updates across PMAC, community, and voting modules.

September 2024

Sep 30

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries.

Sep 27

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; SQL migration + stored-procedure contract updates (Dapper-backed services).

Sep 25

Invitation/password-recovery pipelines and email-delivery refinements.

Sep 20

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Sep 19

Backend API/service contract updates across PMAC, community, and voting modules.

Sep 18

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements.

Sep 17

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; SQL migration + stored-procedure contract updates (Dapper-backed services).

Sep 16

Backend API/service contract updates across PMAC, community, and voting modules.

Sep 13

Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Sep 12

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes.

Sep 09

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services).

Sep 06

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries.

Sep 05

Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Sep 04

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services).

Sep 02

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; PMAC admin/user-management contract and role/access logic updates; Validation/error-handling hardening and backend manager/service refactors.

Sep 01

Backend API/service contract updates across PMAC, community, and voting modules.

August 2024

Aug 31

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes.

Aug 30

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; SQL migration + stored-procedure contract updates (Dapper-backed services).

Aug 29

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Validation/error-handling hardening and backend manager/service refactors.

Aug 28

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Validation/error-handling hardening and backend manager/service refactors.

Aug 27

Validation/error-handling hardening and backend manager/service refactors.

Aug 23

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Aug 22

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services).

Aug 21

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services).

Aug 20

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Release/deployment readiness updates (version checks + environment config).

Aug 19

Invitation/password-recovery pipelines and email-delivery refinements.

Aug 16

SQL migration + stored-procedure contract updates (Dapper-backed services).

Aug 15

Issue lifecycle APIs (`/CreateIssue`, `/Issues`, `/SearchIssues`, `/CastVoteOnIssue`) and vote-detail routes; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Release/deployment readiness updates (version checks + environment config).

Aug 13

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Aug 12

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements.

Aug 09

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates.

Aug 08

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements.

Aug 07

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements.

Aug 06

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Aug 05

SQL migration + stored-procedure contract updates (Dapper-backed services).

Aug 02

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements; Validation/error-handling hardening and backend manager/service refactors.

Aug 01

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements.

July 2024

Jul 31

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; Invitation/password-recovery pipelines and email-delivery refinements.

Jul 30

Community flow changes (`/MyCommunities`, `/SwitchCommunity`, `/EditCommunity`) and member/board queries; SQL migration + stored-procedure contract updates (Dapper-backed services); Release/deployment readiness updates (version checks + environment config).

Jul 29

Invitation/password-recovery pipelines and email-delivery refinements.

Jul 26

Backend API/service contract updates across PMAC, community, and voting modules.

Jul 25

Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services); Release/deployment readiness updates (version checks + environment config).

Jul 24

Invitation/password-recovery pipelines and email-delivery refinements; SQL migration + stored-procedure contract updates (Dapper-backed services).

Jul 22

Validation/error-handling hardening and backend manager/service refactors.

Jul 18

Backend API/service contract updates across PMAC, community, and voting modules.

Jul 03

Auth/session endpoints (`/Login`, `/Auth`, `/refresh-token`, `/MyProfile`) + JWT guard updates; SQL migration + stored-procedure contract updates (Dapper-backed services).

May 2024

May 30

SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

May 29

SQL migration + stored-procedure contract updates (Dapper-backed services); Validation/error-handling hardening and backend manager/service refactors.

Objective Link to heading

Build and evolve the production backend for Community Vote Tracker and PMAC operations, covering authentication, community administration, issue voting lifecycle, and supporting notification/invite flows.
Keep service boundaries stable while adapting SQL contracts, validation rules, and deployment/runtime observability for release-grade behavior.

Implementation path Link to heading

Bootstrapped ASP.NET Core API foundations and moved persistence strategy to Dapper + SQL stored-procedure driven migrations.
Implemented core auth/session flow (login/auth, refresh-token, JWT middleware), then expanded PMAC and community management endpoints.
Added issue APIs for create/search/list/detail/cast-vote and voting visibility endpoints, including role/access validation.
Expanded invitation, password recovery, email delivery, and OneSignal push-notification pipelines.
Iterated heavily on refactors, response consistency, migration compatibility, and production deployment/version handling.

Real-world challenges addressed Link to heading

Keeping stored-procedure contracts and API request/response models aligned during rapid PMAC and issue-feature expansion.
Enforcing role/access-level authorization correctly across cross-community and admin-sensitive operations.
Managing migration compatibility and environment drift while API behavior changed across releases.
Improving operational reliability with global exception handling, request timing, and Application Insights telemetry.