Step 1.Create a mySQL database under the name "Client Schedule", with username being "sqlUser" and password as "Passw0rd!".
- Create a login form that has the ability to do the following:
a. Determine a user’s location.
b. Translate login and error control messages (e.g., “The username and password do not match.”) into English and one additional language.
c. Verify the correct username and password.
- Provide the ability to add, update, and delete customer records.
a. Validate each of the following requirements for customer records:
• that a customer record includes name, address, and phone number fields
• that fields are trimmed and non-empty
• that the phone number field allows only digits and dashes
b. Add exception handling that can be used when performing each of the following operations for customer records:
• “add” operations
• “update” operations
• “delete database” operations
- Provide the ability to add, update, and delete appointments, capture the type of appointment, and link to a specific customer record in the database.
a. Validate each of the following requirements for appointments:
• Require appointments to be scheduled during the business hours of 9:00 a.m. to 5:00 p.m., Monday–Friday, eastern standard time.
• Prevent the scheduling of overlapping appointments.
b. Add exception handling that can be used when performing each of the following operations for appointments:
• “add” operations
• “update” operations
• “delete database” operations
-
Create a calendar view feature, including the ability to view appointments on a specific day by selecting a day of the month from a calendar of the months of the year.
-
Provide the ability to automatically adjust appointment times based on user time zones and daylight saving time.
-
Create a function that generates an alert whenever a user who has an appointment within 15 minutes logs in to their account.
-
Create a function that allows users to generate the three reports listed using collection classes, incorporating a lambda expression into the code for each of the following reports:
• the number of appointment types by month
• the schedule for each user
• one additional report of your choice
- Record the timestamp and the username of each login in a text file named “Login_History.txt,” ensuring that each new record is appended to the log file.