IMDB-Tech-Module

IMDB Movie Database (in C#, Java, JS and PHP) - Exam Preparation for the Tech Module @ SoftUni (December 2017)

You are assigned to create a Simple Movie Database App. The application should hold movies, which are the main app entities. The functionality of the app should support creating, listing, editing and deleting movies. The application should persist the data into a database. Data validation and error handling is a plus but is not mandatory.

Overview

Your application should be built on each one of the following technologies:

PHP

• Symfony framework
• Twig view engine
• Doctrine ORM framework
• MySQL database

JavaScript

• NodeJS + ExpressJS frameworks
• Handlebars.js view engine
• Mongoose data access framework
• MongoDB database

Java

• Spring framework (Spring MVC + Spring Boot + Spring Data)
• Thymeleaf view engine
• JPA / Hibernate ORM + Spring Data data access frameworks
• MySQL database

C#

• ASP.NET framework (ASP.NET MVC + Entity Framework)
• Razor view engine
• Entity Framework ORM framework
• MSSQL Server database

Data Model

The Film entity holds 3 properties:

• id - technology-dependent identifier (ObjectID for JavaScript, int for all other technologies)
• name - nonempty text
• genre - nonempty text
• director - nonempty text
• year - integer (1900-2100)

User Interface

This is the user interface should consists of the following pages (under the designated routes):

Index Page

Route: / (GET)

List all movies.

Create Page

Route: /create (GET and POST)

GET shows a form to create a film. POST saves the form data into the database as new film.

Delete Page

Route: /delete/{id} (GET and POST)

GET shows a form to delete a certain film. POST confirms deleting a film and removes the film from the database.

Edit Page

Route: /edit/{id} (GET and POST)

GET shows a form to edit a certain film. POST confirms editing a film and modifies the film in the database.

Languages and Technologies

Implement the IMDB App on all mentioned 4 technology stacks.

Setup

Before you start working, make sure you download all the dependencies (packages) required for each technology and set up the databases! Below are instructions on how to do this:

PHP and Symfony

1. Go into the root directory of the project (where the bin folder resides)
2. Make sure you’ve started your MySQL server (either from XAMPP or standalone)
3. Open a shell / command prompt / PowerShell window in that directory (shift + right click --> open command window here)
4. Enter the php composer.phar install command to restore its Composer dependencies (described in composer.json)
5. Enter the php bin/console doctrine:database:create command
6. Enter the php bin/console doctrine:schema:update ---force command
7. Done!

JavaScript and Node.js

1. Go into the root directory of the project (where the bin folder resides)
2. Make sure you’ve started your MongoDB server: mongod.exe --dbpath path/to/db/directory
3. Open a shell / command prompt / PowerShell window in the root directory (shift + right click --> open command window here)
4. Enter the npm install command to restore its Node.js dependencies (described in package.json)
5. Done!

C# and ASP.NET MVC

The C# project will automatically resolve its NuGet dependencies (described in packages.config) using the NuGet package restore when the project is built.

Java and Spring MVC

The Java project will automatically resolve its Maven dependencies (described in pom.xml) when the project is built.