Additional Notes: USING C# You cannot add two flights with the same flight number When you select “View Flights”, a list containing the Flight number, origin and destination for each flight must be shown. When you select “View a particular flight”, a list of all flights should be displayed and the user must be allowed to enter a particular flight number. All the information on that selected flight must be displayed. All the customers who are booked on that flight must SPECIAL NOTE: A customer can only be deleted if there are no bookings for that customer. A flight can only be deleted if there are no customers booked on the flight.   You must extend the core design and add the functionality to add customers and booking features to the system. The information that must be recorded on a customer is as follows: A customer ID must be assigned to each customer by the system. (NOT entered by the user) The customer’s first name The customer’s last name. The customer’s phone (a string type is fine for this) The number of bookings the customer has made Your main menu should have the new options: Make booking View bookings   ADD CUSTOMER When the “Add Customer” option is selected, all information necessary to make the customer object must be asked for. A customer can only be added if there is no other customer with the same first name, last name and phone number (all three cannot be the same). An appropriate message as to whether the customer addition was successful or not should be displayed. VIEW CUSTOMERS When “View Customers” is selected, the first name, last name and phone number must be displayed for each customer.     The information that must be recorded on a booking is as follows: The date of the booking ( a string) A booking number must be assigned by the system. (NOT entered by the user) The flight object the booking is being made for. The customer object the booking is being made for Note : you can use the following code to get the date and time from your system as a string… string date = DateTime.Now.ToString(@"MM\/dd\/yyyy h\:mm tt"); Your main menu should have the new options: Make booking View bookings   MAKE BOOKINGS When the “Add booking” option is selected, a list of all customers and all flights should be displayed first. The user must then be asked for the Customer id and flight id to make the booking for. A booking can only be made if there is free space on the plane, the customer id exists and the flight id exists. All associated objects should be updated. An appropriate message as to whether the booking was successful or not should be displayed. VIEW BOOKINGS When “View bookings” is selected, the date, booking number, customer name and flight number must be displayed for each booking.

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter12: Database Queries With Sql
Section: Chapter Questions
Problem 8RQ: What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box...
icon
Related questions
icon
Concept explainers
Question
100%

Additional Notes:

USING C#

  • You cannot add two flights with the same flight number
  • When you select “View Flights”, a list containing the Flight number, origin and destination for each flight must be shown.
  • When you select “View a particular flight”, a list of all flights should be displayed and the user must be allowed to enter a particular flight number. All the information on that selected flight must be displayed. All the customers who are booked on that flight must

SPECIAL NOTE:

A customer can only be deleted if there are no bookings for that customer.

A flight can only be deleted if there are no customers booked on the flight.

 

You must extend the core design and add the functionality to add customers and booking features to the system.

The information that must be recorded on a customer is as follows:

  • A customer ID must be assigned to each customer by the system. (NOT entered by the user)
  • The customer’s first name
  • The customer’s last name.
  • The customer’s phone (a string type is fine for this)
  • The number of bookings the customer has made

Your main menu should have the new options:

  • Make booking
  • View bookings

 

ADD CUSTOMER

When the “Add Customer” option is selected, all information necessary to make the customer object must be asked for.

A customer can only be added if there is no other customer with the same first name, last name and phone number (all three cannot be the same). An appropriate message as to whether the customer addition was successful or not should be displayed.

VIEW CUSTOMERS

When “View Customers” is selected, the first name, last name and phone number must be displayed for each customer.

 

 

The information that must be recorded on a booking is as follows:

  • The date of the booking ( a string)
  • A booking number must be assigned by the system. (NOT entered by the user)
  • The flight object the booking is being made for.
  • The customer object the booking is being made for

Note : you can use the following code to get the date and time from your system as a string…

string date = DateTime.Now.ToString(@"MM\/dd\/yyyy h\:mm tt");

Your main menu should have the new options:

  • Make booking
  • View bookings

 

MAKE BOOKINGS

When the “Add booking” option is selected, a list of all customers and all flights should be displayed first. The user must then be asked for the Customer id and flight id to make the booking for.

A booking can only be made if there is free space on the plane, the customer id exists and the flight id exists. All associated objects should be updated. An appropriate message as to whether the booking was successful or not should be displayed.

VIEW BOOKINGS

When “View bookings” is selected, the date, booking number, customer name and flight number must be displayed for each booking.

1: Add Flight
2: View Flights
XYZ AirLines Limited.
Customer Menu
Please select a choice from the menu below:
XYZ AirLines Limited.
Flight Menu
Please select a choice from the menu below:
3: View a particular Flight
4: Delete Flight
5: Back to main menu
1: Add Customer
2: View Customers
3: Delete Customer
4 Back to main menu
XYZ AirLines Limited.
Booking Menu
Please select a choice from the menu below:
1: Make Booking
2: View Bookings
3: Back to main menu
XYZ AirLines Limited.
Please select a choice from the menu below:
1: Customers
2: Flights
3: Bookings
4:Exit
Transcribed Image Text:1: Add Flight 2: View Flights XYZ AirLines Limited. Customer Menu Please select a choice from the menu below: XYZ AirLines Limited. Flight Menu Please select a choice from the menu below: 3: View a particular Flight 4: Delete Flight 5: Back to main menu 1: Add Customer 2: View Customers 3: Delete Customer 4 Back to main menu XYZ AirLines Limited. Booking Menu Please select a choice from the menu below: 1: Make Booking 2: View Bookings 3: Back to main menu XYZ AirLines Limited. Please select a choice from the menu below: 1: Customers 2: Flights 3: Bookings 4:Exit
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Control Structure
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
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L