ITAP3010 Developing Data Access Solutions Project

Learning Outcomes

Marking guide:

Note: This Marking Scheme is used as a guide only to the final grade, and rubric will be created upon.

Resources:

Create a Windows Forms app in Visual Studio with C#

Developing Data Access Solutions Project

1. This project is developed to check the coding skills of the students. Use Dafesty script to create the database required for this project. Explain the key features of the Dafesty database design.

2. Create forms as listed below. Use “tabbed form” (see Figure 1) or “Menu” to develop all the forms.

1. Customer registration (Figure 1)
2. Issue Transaction (Figure 3)

• Find by customer ID (Figure 5)

1. Update country (Figure 6)
2. Movies (Figure 7)

Figure 1 Customer registration form using tabbed form.

3. Modify the Customer Registration form that allows the admin to add, update, delete and search customer records from the database. Also provide the first, last, next and previous buttons to see all the data that is already present in the database as shown in Figure 1.

4. Create a form as shown in Figure 2 which allows the admin to find customer details by Customer ID. Note the output below is a sample output.

Figure 2 Find a record.

5. Create the form for Issue Transaction like the form shown below. The form should display Issue Transaction details in a grid view. The admin should be able to sort the data by Transaction ID. The admin should be able to order the data in ascending or descending order.

Figure 3 Issue transaction form.

6. Modify Country form to include have a combo box for Country (see Figure 8). The combo box should have a list of countries. The admin should be able to select a country from the combo box and click on the update button to update the country of that particular Customer. Also provide a next and previous button to go through the data.
7. Your “On Load” program should look like the form below (see Figure 4).

Figure 4 On load program.

Figure 5 Find details by customer ID form.

Figure 6 Update country form.

Figure 7 Movies form.

Figure 8 Updated country form with a combo box.