CIS 365 Movie Database Project PostgreSQL C# Project
The project for this course is designed to reinforce the material we have covered in the course as well as expose you to new technologies you are likely to encounter when working out in industry.
To complete your project, you will be required to connect to a database and display/modify its data. You will be using ADO.Net to work with the database.
The database you will be working with is a PostGres database I have distributed to the class. To access the database, you will need to download and install the PostGres software. It can be found here http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.6%2Fwin32%2Fpostgresql-8.2.6-2.zip, or you can download it from the project folder on Blackboard. To view the database schema and table contents directly, you will need to run the pgAdmin III administrator’s tool installed with the PostGres database (Start->All Programs->PostgreSQLx.x->pgAdmin III).
I would recommend browsing the database and familiarizing yourself with the media table and its associated columns/data.
The following are the project requirements:
1) The user interface must be GUI based and written using Windows Presentation Foundation (WPF).
2) The user must be able to do the following: View the database records, Insert new database records, Modify database records and Delete database records.
3) Error trapping must be performed by the application.
4) Combo boxes must be used to provide user input options (i.e. rating, ranking fields) and to avoid input validation.
5) The application must have a menu bar. I would suggest duplicating any actions such as insert/delete which are performed via command buttons within the menu bar.
6) You should use the following controls in your project: ComboBox, TextBox, Label, Command Buttons, at least one image and radio button/check boxes. ListView and GridView controls are encouraged.
Valid choices for rating are G, PG, PG-13 and R. Valid choices for ranking are Poor, Fair, Average, Good, Excellent.
You will also find a project evaluation sheet in the project folder on Blackboard. I would suggest using it as a checklist when working on your project.
I have also placed an example project in Blackboard to demonstrate connecting to the database and pulling records from it.
I have left the actual design of the GUI and user-interaction open to your interpretation. I look forward to seeing your projects.