GobangGame (MSSA Project SD9)

ASP.NET web application for Gobang online game. Gobang is a two-player abstract strategy game generally played with Go pieces(either in black or white color) on a 15*15 Go board. Also know by the name Five in a Row. It is a traditional oriental game, originally from China. Black plays first, and players alternate in placing the Go piece of their color on an empty intersection. The winner is the first player to get an unbroken row of five Go pieces horizontally, vertically, or diagonally.

Table of contents

• Step 1 Concept Investigation
• Step 2 Project Selection
• Step 3 Concept Presentation
• Step 4 Database Conceptual Design
• Step 5 Database Entity (ERD) Design
• Step 6 Interface Elements
• Step 7 Requirements & Use Case
• Step 8 Test Planning & RTM
• Step 9 Application Prototype
• Step 10 In-Process Review (IPR)
• Step 11 Model Classes
• Step 12 Data Integration
• Step 13 Sprint Planning
• Step 14 Sprint Review
• Step 15 Sprint Execution

Step11

Working from the design, and implement the data model components of the project using Entity Framework to map the classes to the database table entities and the tables to the classes.

Deliverable requirements:

• Project folders for Models,Views, and Controllers.

• Within Models folder-C# class files which describe and map to database table entities
• Develop the interface.
• The primary data model, which the data model implements.
• Create a "Fake" or "TestDouble"class which also implements the data interface.
• Auto-generate a databse diagram.

Step12

The project database tables and model classes are connected. Using code, connect to the database and create a controller and simple view which displays data read from tables and enables data taken from a simple user interface and storing the new or modified data back to the databse.

Deliverable requirements:

• Screenshot of SSMS showing data stored in tables

• Screenshot of application view showing data retrieved from the database and displayed on the page.

• Screenshot of the application demonstrating how the data is collected from the application(a form?).

• Screenshot of the view showing how the data has changed.

Step13

Accordingly,plan the remaining work and the upcoming sprint starting with creating the formal prioritized product backlog items(PBIs) in the project repository.

Deliverable requirements:

• From the issues tab in GitHub, add new issues. A well-constructed issue contain: A user story/Acceptance criteria/Additional supporting information such as diagrams, descriptions, screen captures, error messages, etc.
• Create a project board from the repository and add prioritized issues from the backlog. ToDo/InProcess/Done.

Step14

Sprint plan(Backlog updated)

Use the EF Database First with ASP.NET MVC approach to create the Gobang Game web application.

Add record detail page.

Confirm that new record added to the page.

Task 6 Enhance data validation.

Add data annotations.

Add metadata classes.

Task 7 Deploy Gobang Game app to Azure with Azure SQL Database.

Within Visual Studio solution Explorer-publish to Azure as target.

Sign in and add an app.

Configure the web app name.

Create a resource group.

Create an App service plan.

Create a server and database.

Configure database connection.

Deploy Gobang Game app.

Task 8 Access the database locally.

Create a database connection.

Configure the database connection.

Create a new firewall to allow client connection.

Task 9 Update app with Code First Migration.

Update data model.

Run Code First Migrations locally.

Use the new property.

Enable Code First Migrations in Azure.

Publish changes.

Task 10 Stream application logs.

Enable log streaming.

Change trace levels.

Stop log streaming.

Task 11 Manage Azure app. ## Step15

Sprint Review:

The Web Views are ready for next task: Task 7 Deploy Gobang Game app to Azure with Azure SQL Database.

The same time, continue working on the Game Board implement and tests

## Contact Created by [@yanxu2021](https://www.linkedin.com/in/yanxu2021/) - feel free to contact me!