Systems & Integration2025Project demo

Newspaper Advertising Platform

A newspaper advertising workflow connecting a self-service website, subscriber API, and desktop administration tool.

GitHub (opens in a new tab)

Platforms: Web · Desktop · API
Focus: Self-service intake · Subscriber pricing · Single source of subscriber data

A walkthrough of the connected advertising and subscriber-management workflows.

The story

The problem

The advertising application needs subscriber details without maintaining a second, potentially conflicting copy of the subscriber database.

What it delivers

I separated subscriber management from the advertising website. Subscribers can retrieve their details with a subscription number and place an advert at no charge, while businesses are charged the configured 40 SEK fee.

At a glance

Self-service intake
One guided web flow adapts to subscribers and business advertisers.
Subscriber pricing
A subscription number retrieves customer details and applies the subscriber price.
Single source of subscriber data
Subscriber records are maintained by one service and retrieved through its API.

Built with

ASP.NET Core MVC
Bootstrap
Web API
EF Core
SQL Server
WinForms

Separate services and databases
The advertising and subscriber services have separate responsibilities, data models, and databases.
Shared subscriber API
The advertising website reads subscriber details through an HTTP API; a Windows Forms client uses the same API to manage those records.