The Expert's number of “Accepted Answers” is a good indication of how many satisfied customers he or she has helped.
Ingo U's MASTER OF SCIENCE in ELECTRICAL AND COMPUTER ENGINEERING was verified on or about July 2010 by a leading third-party verification service.View the Terms of Service section on verifications
C# ***** [Due by Wed. 7/23 4:00 PM – Extra Money & $40 BONUS INCLUDED] ---[PART 1 – Separate file called carRentalDatabase1]--- You are writing a program for a car rental company. This company rents more than one type of vehicle to customers and the employees use programs written in C# ***** keep track of the cars for rental. This is a prototype program to demonstrate storing information for just the cars, showing selected views, and making changes (1) Create a small Access database with 5 sample records (The first time you connect your application to a local database file, you can choose between creating a copy of the database in your project or connecting to the existing database file in its current location. Create a copy of the database file in the project and include the database file in a separate folder zipped with the program) The Access database file has a table to hold Car information. It should have a VIN, Make, Model, and Price. Add at least 5 sample records of cars you like. Include some with prices above 10000 and some below 10000. (2) Connect to the access database and show all of the data in the Car table for the user. (3) Add controls for the user to be able to add a car to your database, if you have not automatically created tools to do it. (with the way you are showing all the data in the Car table) (4) Add the ability for the user to display only the cars that have a Price below 10000 dollars. Add a second ability for the user to see only one make of cars (how you handle this is up to you. You can hard code a value or get it from the user. Whichever you wish to do.) ________________________________________ ---[PART 2 – Separate file building upon Part 1, called carRentalFDirect2A]--- In working with the car rental company you find out that the sales manager would like to have a simple listing of the car rentals for the day made by the sales persons and would like a simple data file stored that another program can read. (A string representing a car rental is being used instead of a class can be used) (1) Create a program that has an array of strings in it. Each string should have the details for one car rental. The program should have a textbox for the user to enter these details and a button to add the text in the textbox to the next place in your array of cars. Also have a Save button that makes a fileStream and StreamWriter to write the contents of the array of strings to a datafile. (2) Create a second program --- [In a separate file called carRentalFDirect2B - *copy code used in the 2A and just add the following*] --- Used by the Sales Manager, this program should allow the user to open the datafile created in the first program and display the contents in controls on the screen. (A listbox would be the easiest way, but if you want to add a browse operation on an array with the save and load functions that is an option.) _____________________________________________________________ --- [PART 3 – Separate file called carRentalWebsiteVal]--- (1) C# ***** program that would get the contact information from a Customer who wishes to rent a car (2) Have fields for Name, Car Type Preferred, and number of occupants. Also include a submit button to send an e-mail message to the rental desk. (Set the properties for the To, From, Subject, and Message…as well as Attachments and then use a method on it that “sends” a Microsoft mail type e-mail from the computer you are on.) [If you are comfortable adding step (2), the e-mail message, go ahead, an extra $5.00 will be added to the $40 Bonus if included, but okay to leave this step out] (3) Include validation to make sure the user enters in all three fields needed and that the number of occupants is above zero and less than 6 (as each car cannot hold more than 6 people) and shows appropriate error messages when the Send button is pressed.