Papa Bob's Mega Solution Part 1 - Setting up the Solution

Tutorial Series: Free C# Fundamentals via ASP.NET Web Apps

Previous Article  |  Next Article

This is the first part of the solution to the final challenge of this course, Papa Bob's Mega Challenge. Because this challenge is the longest and most detailed, the solution will be broken up into multiple documents that each deal with an appropriate portion of the solution. This challenge requires the use of almost every concept covered throughout this course, so if in trying to solve it, you reached a point that you couldn't get past, this solution is here to guide you. As always, find the section pertaining to the issue you need help with and only use as much of it as you need.

Step 1: Create a New Solution and Add Projects

The purpose of this challenge is to create a new website for Papa Bob's, a fictitious company used in a previous challenge. One of the main requirements is to use a maintenance-driven approach to the website. This entails breaking the solution into layers of projects: Presentation, Domain and Persistence, as well as using Data Transfer Objects to pass data through the layers.

To begin creating this structure, create a new Solution in Visual Studio by selecting: New Project > Other Project Types > Visual Studio Solution. Select 'Blank Solution' and name it PapaBobs:


Once the Solution has loaded, right-click on the Solution in the Solution Explorer and add a new ASP.NET Web Project. Call this project 'PapaBobs.Web.' This will act as our Presentation layer:


Next, we need to add our Domain and Persistence layers to the Solution. To do this, add two more Projects, this time selecting 'Class Library' as their type. Name them 'PapaBobs.Domain' and 'PapaBobs.Persistence':


Finally, create a Class Library for the Data Transfer Object following the same steps described for the Domain and Persistence layers. Call it 'PapaBobs.DTO'.

Step 2: Create Project Dependencies

Now that all our initial Projects are in place, let's begin by creating our dependencies. While not ideal, we'll use the same method as described in the lessons covering this maintenance-driven approach, where all dependencies point 'downward'. This means that the Presentation will have a reference for the Domain and the Domain for the Persistence. All three layers will depend on the DTO.

To add these references, right click on the 'References' section under each project, select 'Add Reference' and select the appropriate references.







Note: The DTO class does not contain any references, as it never makes a call into the other projects.

Next, we'll rename the classes from the different layers according to their purpose. Because the Domain layer orchestrates method calls and manages the interaction between the other two layers, rename its Class1 to 'OrderManager'. The Persistence layer will be named 'OrderRepository' as it holds the data, and the DTO's class should be called 'OrderDTO':


Step 3: Creating the Database

Now that our classes are in place, we can create the database that will store the information for the order, including the customer's information. To do this, right-click on 'PapaBobs.Web' and select: Add > New Item From the resulting dialog, select a SQL Server Database from the Data category and name it 'PapaBobsDb.mdf':


You may receive a prompt at this point asking if you'd like to place the Database in the App_Data folder of your project. Confirm that you would, and your database should be visible in your Project:


Navigate from the Solution Explorer to the Server Explorer to select the database from the Data Connections category:


Right-click on the Tables folder and add a new table to the database. This table will store the information of each pizza order that comes in. Fill in the following information in the table to capture that data:


Note that the bit data type is employed for the different topping options because it is equivalent to a boolean value; either 0 or 1 for true or false. Because all the toppings need to have a value, regardless of if they are chosen or not, a boolean representative is ideal for the situation. In this case, they are defaulted to false.

In the 'T-SQL' section underneath the Design view of the table, change the name of the table to 'dbo.Orders':


Finally, click on the 'Update' button on the top left-hand side of the table to commit these changes. In the resulting dialog, confirm that you'd like to update the table.

Step 4: Create the Entity Data Model

For the final step in this part of the solution, we'll create an Entity Model for PapaBobsDb within the Persistence layer. Right-click on PapaBobs.Persistence and add a new item. Located under the Data category, select 'ADO.NET Entity Data Model' and call it 'PapaBobsEntities':


From the Wizard that displays at this point, choose the 'EF Designer from database' option and click Next. In the next section, confirm that the data connection for the Model is PapaBobsDb.mdf. Leave the name as the default and click Next:


After you click next, a popup dialog should appear asking if you'd like to copy the file into your project. Make sure to select 'No' to this step:


In the next window, you'll be asked which version of the Entity Framework you'd like to use. Select 6.x and click Next:


Finally, you'll be asked which databases to include in your model. Check 'Tables' and make sure that the Orders table is selected, then confirm your selection:


At this point, you'll be redirected to a diagram of your Order Entity, automatically populated with the properties of your Orders table:



This concludes this part of the solution for Papa Bob's Mega Challenge. In the next part, we'll create an Order button for the Default page, and add a sample order to the database.

Related Articles in this Tutorial:

Lesson 1 - Series Introduction

Lesson 2 - Installing Visual Studio 2015

Lesson 3 - Building Your First Web App

Lesson 4 - Understanding What You Just Did

Lesson 5 - Working with Projects in Visual Studio

Lesson 6 - Simple Web Page Formatting in Visual Studio

Challenge 1

Solution 1

Lesson 7 - Variables and Data Types

Lesson 8 - Data Type Conversion

Lesson 9 - Arithmetic Operators

Lesson 10 - C# Syntax Basics

Challenge 2 - ChallengeSimpleCalculator

Solution - ChallengeSimpleCalculator

Lesson 11 - Conditional If Statements

Lesson 12 - The Conditional Ternary Operator

Challenge 3 - ChallengeConditionalRadioButton

Solution - Challenge Conditional RadioButton

Lesson 13 - Comparison and Logical Operators

Lesson 13 Challenge - First Papa Bob's Website

Solution - Challenge First Papa Bob's Website

Lesson 14 - Working with Dates and Times

Lesson 15 - Working With Spans of Time

Lesson 16 - Working with the Calendar Server Control

Challenge 4 - Challenge Days Between Dates

Solution - Challenge Days Between Dates

Lesson 17 - Page_Load and Page.IsPostBack

Lesson 18 - Setting a Break Point and Debugging

Lesson 19 - Formatting Strings

Challenge 5 - Challenge Epic Spies Assignment

Solution - Challenge Epic Spies Assignment

Lesson 20 - Maintaining State with ViewState

Lesson 21 - Storing Values in Arrays

Lesson 22 - Understanding Multidimensional Arrays

Lesson 23 - Changing the Length of an Array

Challenge 6 - Challenge Epic Spies Asset Tracker

Solution - Challenge Epic Spies Asset Tracker

Lesson 24 - Understanding Variable Scope

Lesson 25 - Code Blocks and Nested If Statements

Lesson 26 - Looping with the For Iteration Statement

Challenge 7 - Challenge For Xmen Battle Count

Solution - Challenge For Xmen Battle Count

Lesson 27 - Looping with the while() & do...while() Iteration Statements

Lesson 28 - Creating and Calling Simple Helper Methods

Lesson 29 - Creating Methods with Input Parameters

Lesson 30 - Returning Values from Methods

Lesson 31 - Creating Overloaded Methods

Lesson 32 - Creating Optional Parameters

Lesson 33 - Creating Names Parameters

Lesson 34 - Creating Methods with Output Parameters

Challenge 8 - Challenge Postal Calculator Helper Methods

Solution - Challenge Postal Calculator Helper Methods

Mega Challenge Casino

Solution - Mega Challenge Casino

Lesson 35 - Manipulating Strings

Challenge 9 - Phun With Strings

Solution - Challenge Phun With Strings

Lesson 36 - Introduction to Classes and Objects

Challenge - Hero Monster Classes Part 1

Solution - Hero Monster Classes Part 1

Challenge - Hero Monster Classes Part 2

Solution - Challenge Hero Monster Classes Part 2

Lesson 37 - Creating Class Files Creating Cohesive Classes and Code Navigation

Lesson 38 - Understanding Object References and Object Lifetime

Lesson 39 - Understanding the .NET Framework and Compilation

Lesson 40 - Namespaces and Using Directives

Lesson 41 - Creating Class Libraries and Adding References to Assemblies

Lesson 42 - Accessibility Modifiers, Fields and Properties

Lesson 43 - Creating Constructor Methods

Lesson 44 - Naming Conventions for Identifiers

Lesson 45 - Static vs Instance Members

Challenge 10 - Challenge Simple Darts

Solution - Challenge Simple Darts

Lesson 46 - Working with the List Collection

Lesson 47 - Object Initializers

Lesson 48 - Collection Initializers

Lesson 49 - Working with the Dictionary Collection

Lesson 50 - Looping with the foreach Iteration Statement

Lesson 51 - Implicitly-Typed Variables with the var Keyword

Challenge 11 - Challenge Student Courses

Solution - Challenge Student Courses

Mega Challenge War

Solution - Mega Challenge War

Lesson 52 - Creating GUIDs

Lesson 53 - Working with Enumerations

Lesson 54 - Understanding the switch() Statement

Lesson 55 - First Pass at the Separation of Concerns Principle

Lesson 56 - Understanding Exception Handling

Lesson 57 - Understanding Global Exception Handling

Lesson 58 - Understanding Custom Exceptions

Lesson 59 - Creating a Database in Visual Studio

Lesson 60 - Creating an Entity Data Model

Lesson 61 - Displaying the DbSet Result in an ASP.NET GridView

Lesson 62 - Implementing a Button Command in a GridView

Lesson 63 - Using a Tools-Centric Approach to Building a Database Application

Lesson 64 - Using a Maintenance-Driven Approach to Building a Database Application

Lesson 65 - Creating a New Instance of an Entity and Persisting it to the Database

Lesson 66 - Package Management with NuGet

Lesson 67 - NuGet No-Commit Workflow

Lesson 68 - Introduction the Twitter Bootstrap CSS Framework

Lesson 69 - Mapping Enum Types to Entity Properties in the Framework Designer

Lesson 70 - Deploying the App to Microsoft Azure Web Services Web Apps

Papa Bob's Mega Challenge

Papa Bob's Mega Solution Part 1 - Setting up the Solution

Papa Bob's Mega Solution Part 2 - Adding an Order to the Database

Papa Bob's Mega Solution Part 3 - Passing an Order from the Presentation Layer

Papa Bob's Mega Solution Part 4 - Creating the Order Form

Papa Bob's Mega Solution Part 5 - Adding Enums

Papa Bob's Mega Solution Part 6 - Creating an Order with Validation

Papa Bob's Mega Solution Part 7 - Calculating the Order Price

Papa Bob's Mega Solution Part 8 - Displaying the Price to the User

Papa Bob's Mega Solution Part 9 - Creating the Order Management Page


Please login or register to add a comment