TrivialGame_webform_asp.net

Trivial Game Application in ASP.NET WebForms

Description

This web application developed in VB.NET provides an interactive environment where users can participate in a trivia game. Players answer 10 random questions.

Development Environment

• Framework : .NET Framework 4.7.2
• Front-end : Bootstrap 5 for a responsive and aesthetically pleasing design.
• Back-end : VB.NET as a programming language.
• Design pattern : Use the Repository pattern to manage data operations related to game questions and answers.

Database Structure

The Trivial application database uses an entity-relationship design to organize how questions and answers are stored. Below is the entity-relationship diagram illustrating the structure of the database:

Characteristics

• Interactivity : Allows players to answer questions and instantly see if their answers are correct.
• Question Management : Administrators can add, edit and delete questions through an administration panel.
• Responsive design : Leverages Bootstrap to ensure the app works well on devices of different sizes.

File Structure

The file structure of the application is organized as follows to facilitate maintainability and scalability of the project:

• App_Code/ :

  • Models/ : Contains the data models used in the application.
    • Pregunta.vb : Defines the structure of the questions.
    • Respuesta.vb : Defines the structure of the responses.
  • Repositories/ : Implements the Repository pattern to abstract data access operations.
    • IPreguntaRepositorio.vb : Interface for question repository operations.
    • PreguntaRepositorio.vb : Concrete implementation of the questions repository.
  • ConexionBD.vb : Manages the connection to the TrivialBD.mdf database.

• App_Data/ :

  • TrivialBD.mdf : Project database that stores all information related to questions and answers.

• Content/ :

  • bootstrap/ : Folder containing the Bootstrap files necessary for the responsive and stylized design of the application.
  • custom.css : Custom style sheet to adapt visual styles beyond Bootstrap.

• Pages/ :

  • Default.aspx : Main page that shows the game questions and collects answers from users.
  • Default.aspx.vb – Codebehind of Default.aspx that contains UI logic to handle events such as answering questions.

This structure is designed to clearly separate presentation logic, business logic, and data access, following software development best practices.

Configuration and Deployment

1. Make sure you have the .NET Framework 4.8 installed.
2. Clone the repository to your local environment.
3. Open the project in Visual Studio.
4. Build and run the application to ensure that all dependencies are correctly configured and that the database is accessible.
5. Access Default.aspx to start playing.