A new movie theater has opened in your town and the owner needs a system that facilitates the Reservation of seats in the cinema’s auditorium. Design a windows application Form that Facilitates the reservation of tickets for this Movie Theater. Design and connect the following database using LINQ or Entity Framework for the given scenario. Database: Movie (id (PK), name, description ) ScheduleMovie (id (PK), movieID (FK), time, price) Seat (id (PK), number, rownumber, columnnumber) Reservation (id (PK), scheduledMovie(FK), seatnum(FK), customerId(FK), haspaidTicket) Customer (id (PK), email, name) The user of this application is a cinema staff, for example the admin and the Cashier. The Admin Panel  The admin registers the cashiers and also, add new movies when released.  The panel has various menus named Add, Remove, and detail  Add menu has sub menu named AddMovie, and AddCashier. Remove menu has sub menu named removeMovie and removeCashier.  Click event raised on the click of AddMovie which displays a new form for the movie entry that includes name, ticket price, timing, and total seats.  Make session gets out after every 10 minutes. (Timer component) The Cashier Panel  First screen shows the Movie Image that is available in Movie Theater. (Use Picture Box)  Click event raised on the click of Movie Image that display new form for customer registration.  The Cashier registers the customer for the seat. The program assigns the first vacant seat number counted from the seat at the most rear part of the auditorium i.e. the last chair. Requirements  The GUI must include textboxes for input, labels for read only information such as headings and also output. In addition a listbox must also be used.  The values entered by the user in the textboxes must be validated when the user clicks the Reserve/Cancel button.  The value entered in the name textbox should at least contain one character that is not a blank, otherwise a message box is to be shown to the user with appropriate error (use regex).  The value entered in the price textbox most be a valid double value greater or equal to 0 (0 for free tickets) (use regex).  Test the application with a total number of seats = 240. The program should keep track of the number of vacant seats.  Every time the user clicks the Reserve/Cancel button, and if the radio button Reserve is checked, increase the number of vacant seats by one. Also accumulate the price of each reserved seat to show in the revenue output label, i.e. revenue = Sum of prices.  When the user selects the Cancel Reservation option, the TextBoxes are to be disabled. Even the Reserve/Cancel button is to be disabled as cancel function will not be implemented in this version.  Use Error provider to show errors to the user.  Use the Customer and the Movie class to maintain the records.  Design database and perform the crud operations where necessary.  Generate day to day Crystal Report for the on-screen shows your report should also contain number of sold tickets.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

A new movie theater has opened in your town and the owner needs a system that facilitates the
Reservation of seats in the cinema’s auditorium. Design a windows application Form that
Facilitates the reservation of tickets for this Movie Theater.
Design and connect the following database using LINQ or Entity Framework for the given
scenario.
Database:
Movie (id (PK), name, description )
ScheduleMovie (id (PK), movieID (FK), time, price)
Seat (id (PK), number, rownumber, columnnumber)
Reservation (id (PK), scheduledMovie(FK), seatnum(FK), customerId(FK), haspaidTicket)
Customer (id (PK), email, name)
The user of this application is a cinema staff, for example the admin and the Cashier.
The Admin Panel
 The admin registers the cashiers and also, add new movies when released.
 The panel has various menus named Add, Remove, and detail
 Add menu has sub menu named AddMovie, and AddCashier. Remove menu has sub menu
named removeMovie and removeCashier.
 Click event raised on the click of AddMovie which displays a new form for the movie entry
that includes name, ticket price, timing, and total seats.
 Make session gets out after every 10 minutes. (Timer component)
The Cashier Panel
 First screen shows the Movie Image that is available in Movie Theater. (Use Picture Box)
 Click event raised on the click of Movie Image that display new form for customer
registration.
 The Cashier registers the customer for the seat. The program assigns the first vacant seat
number counted from the seat at the most rear part of the auditorium i.e. the last chair.
Requirements
 The GUI must include textboxes for input, labels for read only information such as
headings and also output. In addition a listbox must also be used.
 The values entered by the user in the textboxes must be validated when the user clicks the
Reserve/Cancel button.
 The value entered in the name textbox should at least contain one character that is not a
blank, otherwise a message box is to be shown to the user with appropriate error (use
regex).
 The value entered in the price textbox most be a valid double value greater or equal to 0 (0
for free tickets) (use regex).
 Test the application with a total number of seats = 240. The program should keep track of
the number of vacant seats.
 Every time the user clicks the Reserve/Cancel button, and if the radio button Reserve is
checked, increase the number of vacant seats by one. Also accumulate the price of each
reserved seat to show in the revenue output label, i.e. revenue = Sum of prices.
 When the user selects the Cancel Reservation option, the TextBoxes are to be disabled.
Even the Reserve/Cancel button is to be disabled as cancel function will not be
implemented in this version.
 Use Error provider to show errors to the user.
 Use the Customer and the Movie class to maintain the records.
 Design database and perform the crud operations where necessary.
 Generate day to day Crystal Report for the on-screen shows your report should also contain
number of sold tickets.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education