Fat Pig Invest - Stock Wallet

This is a self-study solution developed for stock portfolio management for the Brazilian stock market.

Esta é uma solução de autoestudo desenvolvida para o gerenciamento de carteira de ações para o mercado de ações brasileiro.

Esta es una solución de autoaprendizaje desarrollada para la gestión de cartera de acciones para la bolsa de valores brasileña.

Screenshots

Technologies

• .Net Core 6
• C#
• MVC
• Entity Framework
• Linq
• Lambda Expressions
• RegEx: Regular Expressions
• Pomelo.EntityFrameworkCore.MySql
• HTML 5
• CSS 3 (not fully responsive sample)
• Bootstrap
• Javascript / JQuery
• MySQL / MariaDB Database
• MySQL Connector
• Google Charts

Installation

Please, follow the instructions below in order to install and run this project:

1. Clone the repository

git clone https://github.com/sergio-lacerda/Fat-Pig-Invest-Stock-Wallet.git

2. Database creation

For this project, a MySQL Database Server is required. If you don't have it, you can use a XAMPP distribution containing MariaDB.

Since the solutions was developed by using a Code First Approach, the database is created by the Migrations commands and there's no need to execute any external database scripts.

3. Settings

• appsettings.json: Edit the key "DatabaseConnStr" and configure the connection string to the solution database (dbStockWallet).

"ConnectionStrings": {
        "DatabaseConnStr": "Server=localhost;port=3306;database=dbStockWallet;uid=root;password=''"
    }

• Program.cs: At line 11, the database server version is setted as MariaDB 10.4.24, since it's the version used for development. If you are running a diferent version or database, you can edit this line before running the solution. For further information, please refer to the Pomelo project documentation.

var serverVersion = new MariaDbServerVersion(new Version(10, 4, 24));

4. Migrations

Run the Migrations commands bellow in order to create the database based on the project classes (It´s recommended to delete the "Migrations" Folder before running these commands).

add-migration FirstMigration

Update-database