ISTM 415 - Capstone Project

For our capstone project in ISTM 415, we were tasked with creating a web application for a restaurant using the following technologies we had learned over the course of the semester:

• ASP.NET Core MVC
• SQL Server
• EntityFramework Core
• HTML5

The web application did not necessarily have to be aesthetically pleasing or include a fully developed front-end, as the primary exercise of the project was for groups to demonstrate their ability to create a functional web application that can handle and manage database tables. The requirements for the project were as follows:

1. Create a database and at least five (5) tables to store information.
2. Create Razor Views to view each table, with at least two (2) being editable.
3. Create any models, views, and controllers necessary to support your Key Business Process.
4. Prepare a final report detailing the Key Business Process, code documentation, and a team reflection.

Our group, consisting of myself (Tanner Croom) alongside classmates Eric Franks and Calum Furgal, created a web application for the fictional restaurant Aggieland Tex-Mex, located in Bryan, Texas and serving customers across the Bryan-College Station area. Aggieland Tex-Mex is known for their fantastic tex-mex food and low prices to entice the significant population of college students that reside in the area.

Our web application for employees of Aggieland Tex-Mex contains a fully-functioning SQL Server back-end with support for adding, editing, and removing customers, employees, and inventory items, as well as support for initiating new sales, complete with proper inventory decrementing, price calculation, and referential integrity through cascading deletion of Orders and Order Details.

---

How to Run This Application

First, download the latest release of this project, then extract all files to a single location. In the Team4 folder, open the file Team4_Project.sln in a recent version of Microsoft Visual Studio.

This web application was created in Microsoft Visual Studio 2019. Any recent version of Microsoft Visual Studio can be used to open and run this application. However, in order for the application to successfully build and have the shopping cart and ordering systems function properly, the following packages must be installed through the NuGet Package Manager (found in the menu bar under Tools > NuGet Package Manager > Manage NuGet Packages for Solution...):

• Microsoft.AspNetCore.Diagnostics.EntityFrameworkCore v3.1.22
• Microsoft.AspNetCore.Identity.EntityFrameworkCore v3.1.22
• Microsoft.AspNetCore.Identity.UI v3.1.22
• Microsoft.EntityFrameworkCore.SqlServer v3.1.22
• Microsoft.EntityFrameworkCore.Tools v3.1.22

Once installed, run the following in the Package Manager Console (found in the menu bar under Tools > NuGet Package Manager > Package Manager Console):

Update-Database ATMDB -context ATMContext

Once this is completed, the user can run the application by clicking the dropdown arrow next to "Start" then selecting "Team4_Project". The application will run in a separate window of the user's default web browser.