I developed this project in the database course.
Project description: shahid is streaming platform, a desktop application that gives user the ability to register and watch latest movies using C# and oracle Db
- Login to his account.
- see reports that summarize the system like (how many users have accounts , how much money system earn as subscribtions).
- create an account (premium / free).
- update / delete his profile.
- premium account can see exclusive movies.
- watch movies.
- Select one or more rows from DB without where condition
- Select one or more rows from DB using bind variables and command parameters
- Insert , Update and Delete rows (without using procedures)
- Select ONE row from DB using stored Procedures (without using sysRefCursor [use out parameters of number data type only])
- Select multiple rows from DB using stored procedures.
- Insert, Update and Delete rows using stored procedures
- Select certain rows for a given value entered by the user on the form
- Select All rows from certain table
- Insert, update, delete using oracle command builder
- Grouped columns / Summarized columns/ Formulas / Labels to enhance design and readability
- Parameters with different data types
- Calling reports from C#