J Street Movie Reviews: ASP.NET & SQL Server Web App

Client

J Street Movie Reviews

Industry

Technologies

ASP.NET, SQL Server, IMDB API, Microsoft AI Services

Overview

Project highlights

Public scoresAnyone can browse and sort the team's movie scores.
IMDB integrationMovie data is pulled in automatically through the IMDB API.
Machine learningAffinity scores between reviewers, based on their star ratings.
Any browserRuns in any modern browser, including smartphones.

Before

The challenge

The J Street team watches and reviews hundreds of movies. We wanted to track those reviews, make the scores publicly accessible, and showcase our web application development expertise.

The reviews lived in an existing Access movie-review application.

After

What we built

J Street re-designed our Access movie-review application as an ASP.NET and SQL Server web app that runs in any modern browser, including smartphones.

Anyone can browse and sort the team's individual movie scores on the public Reviews home page. The Titles page lists every movie the team has reviewed, sortable by any column and searchable by title or release year, and each title page shows details and prior reviews, with movie data pulled in automatically through the IMDB API.

Using Microsoft AI services and machine learning, the system calculates affinity scores between reviewers based on their star ratings. Logged-in users get more features, including a Reviews page with the most recent reviews and one-click adding of a new review.

Inside the system

A closer look

Public Reviews home page

The public Reviews home page, where anyone can browse and sort individual movie scores from the J Street team.

Every title, searchable

The Titles page lists every movie the team has reviewed, sortable by any column and searchable by title or release year.

Title details from IMDB

Clicking into a title shows details and prior reviews, with movie data pulled in automatically through the IMDB API.

Reviewer affinity scores

Using machine learning, the system calculates affinity scores between reviewers based on their star ratings.

More for logged-in users

Logged-in users get more features, including the Reviews page showing the most recent reviews and one-click adding of a new review.

“

The outcome

How it turned out

Reviews that lived in an Access application are now a public web app.
The team's movie scores are publicly accessible.
A working example of the web applications we build, which you can try at jstreetreviews.com.