Assignment 6: Desktop Campus Travel

Due November 11th.

In this assignment you will create a self-contained Campus Travel Windows desktop application complete with database. You will use Visual Studio.

  1. Open Visual Studio and create a new project.
  2. Create the database and load with the Excel Spreadsheet.
  3. Create the Opening Screen Form with buttons to the other form screens.
    1. Buttons that when clicked, launches the respective form (listed below)
    2. Textbox to update connection string up to the main project directory.
    3. Global variable to store path to project.
    4. Form load event handler to load existing directory path.
  4. Create the Agent Bookings screen that displays the total bookings of each agent.
    1. Create Agent class for storing an agent object.
    2. Create Database Class to store database methods.
    3. Add connect to database method.
    4. Add reading Agent Bookings that includes SQL SELECT statement and returns a list of agents
    5. Add ListView control that displays the same fields as previous Agent Bookings screens.
    6. Add Form load even handler to load the Agent Bookings ListView.
    7. Add a close button
  5. Create an Add Agent Form to add an agent at an office location.
    1. Add controls: textbox for agent name, combobox for office, listview to display agents.
    2. Bind the office table to the office combobox.
    3. Add an AddAgent method to the Database class for inserting a new agent into the agent table.
    4. Also add a GetAgents method to the Database class.
    5. Re-load the Add Agent form to update the agent list.
    6. Add a close button
  6. Create an Add Sale Form to add a sale by an agent to a destination on a date for an amount.
    1. Use MonthCalendar control for the SaleDate. (Interpret as Departure Date)
    2. Use a combobox bound to the agent table for selecting the agent.
    3. Use a textbox for specifying the amount.
    4. Use another combobox bound to the destination table for selecting the destination.
    5. Add an AddSale method to the Database class.
    6. Add a submit button to invoke the AddSale method, passing the date, agent key, amount and destination key as parameters. Include a simple confirmation alert.
    7. Add a close button
  7. Create a Search Sales Form to search for a list of sales.
    1. Use comboboxes for specifying the agent and/or the destination with a blank or null selection at the top of each. Do not bind the controls to database tables like you did previously.
    2. Use the Agent class and GetAgents method for the select Agent combobox.
    3. Create a new Destination class and GetDestinations method (in the Database class) for the select Destination combobox.
    4. Add a search submit button that passes all 4 parameters to the Search Results page.
    5. Add a close button
  8. Create the Search Results Form for the search results.
    1. Use a ListView to display the search results.
    2. Create a new Sale class for storing search results records.
    3. Add a SearchSales method to the Database Class.
    4. Add the Form load method for performing the search and displaying the results.
    5. Add functionality so when the date is clicked, it goes to a correctly loaded Update Sale Form. You can include the SalesId as a ListView column to make it easier.
    6. Add a close button.
  9. Create an Update Sale Form to update or delete a sale record.
    1. Add a button to Delete the record.
    2. Add the appropriate controls for updating the record.
    3. Add an Update Sale method to the Database class.
    4. Add a submit button for invoking the update sale method.
    5. Refresh the form after the update.
    6. Add a close button to the form.
  10. Once your project works, copy it onto your desktop and confirm you can set the new path on the opening form and it still functions correctly.
  11. Zip the desktop copy and submit in dropbox on Laulima.