https://accio.cards

Accio is an opensource card browsing website built on ASP.NET Core.

perezdev, Tressley, nicolaspfernandes

ASP.NET Core/Web API, SQL Server, HTML/JS/AJAX, Entity Framework

.NET 5, SQL Server

The Accio solution consists of 4 projects:

• Business - Contains all of the "business logic" for the app and API.
• Data - The database layer, strictly a container for EF classes.
• SetUpload - Not to be used on it's own. It's a console app that is used to periodically upload data from https://github.com/Tressley/hpjson.
• Web - Main app.
• Web.API - API

Once you have the code downloaded and the database server running, you need to make the following changes to run the website:

Add one or both application JSON settings files to the root of Accio.Web:

Note: Only appsettings.Development.json is required. appsettings.json is for prod, but the development name is the default variable value in the debug environment setting.

appsettings.json:

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "AccioConnection": "Server=<SERVER_NAME>;Initial Catalog=Accio;Persist Security Info=False;User ID=<SQL_USER_NAME>;Password=<SQL_USER_PASSWORD>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
  },
  "AccioEmailAccounts": {
    "AccountsEmail": {
      "Address": "<yourEmail>",
      "SendGridApiKey": "<yourSendGridApiKey>"
    }
  }
}

appsettings.Development.json:

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "ConnectionStrings": {
    "AccioConnection": "Server=<SERVER_NAME>;Initial Catalog=Accio;Persist Security Info=False;User ID=<SQL_USER_NAME>;Password=<SQL_USER_PASSWORD>;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
  },
  "AccioEmailAccounts": {
    "AccountsEmail": {
      "Address": "<yourEmail>",
      "SendGridApiKey": "<yourSendGridApiKey>"
    }
  }
}

You will need to replace <SERVER_NAME>, <SQL_USER_NAME>, and <SQL_USER_PASSWORD> in each file. You will also need to replace and with the appropriate values if you want to test the email sending functionality. You don't need to change anything here if you aren't testing login/registration.

After the config changes are in place, you can run the data scripts to create the database, create the schema, and upload the data. The scripts are located in the Scripts folder under the Accio.Data project:

• Accio_CreateDatabase.sql
• Accio_CreateSchema.sql
• Accio_ImportData.sql