The point of this project was to implement SQL databases into a .NET project using HTML and C#. I decided to make a 10-way rock paper scissors version with extra options such as attacking or fleeing.
The information from the menu is passed to the game page through the url using redirect functions.
The whole game including the cards and playing area are made of HTML tables to ensure correct positioning on the screen. The information of the cards are stored in card classes.
The database I had to incorporate into the project is designed to hold each cards ID, name, and the ID of cards it can attack. This information is essential as each round, one player choses a card out of 3 possible options. Once they choose the other player gets to choose. Once the 2 players picked a card wach, they are both revealed. In most cases, one card will have the option to attack the other card. This player can decide whether to attack or retreat. If retreat, a new round begins, no points are awarded. If the player decides to attack, an outcome is randomly calculated based on the attack and defence values presented on the card. The higher the attack, the more likely it will succeed. The higher the opponents defence, the higher the canche the attack will not be successful. Based on the outcome of the attack, 1 point is awarded to the winning player.
If both players choose the same type of card, the encounter will be decided by the cards' luck factor. The larger the luck factor, the higher the chance that player will win (no option to retreat in this scenario).
Once the selection happened, the program retrieves the necessary information from the databases.
If the current player decides to attack, the attempt is evaluated using this alorithm:
If debuggin start from Home.aspx or Home.aspx.cs