Damnazon

01/25/2021

By Cory Nordernbrock, Joseph Giunta, Constantine Yakubovski, and Callie Stump

About

🚩 Description

This application is for Damnazon; a spoof of Amazon where the public is free to buy Jeff Bezo's assets, properties, vehicles, etc. - using a MySql database to store listings.

🐛 Known Bugs

There are no known bugs at this time.

Getting Started

☑️ Requirements

C# .Net Core v2.2.4 installed on your local machine.
Console/Terminal access.
Code Editor Ex.) Visual Studio Code
MySQL Community Server & Workbench

🔧 Setup/Installation

Project Editor Setup

Copy this download link: https://github.com/cordenbrock/Damnazon.Solutions.git
Open bash and go to the directory where you would like to store your cloned project.
Clone the repo.

git clone https://github.com/cordenbrock/Damnazon.Solutions.git

Navigate to the cloned project folder and open VS code.

$ cd Desktop
$ cd [known directory]
$ code .

Navigate to the testing project folder in your VS terminal initalizes dotnet.

dotnet restore

If you wish to see if everything is compiling correctly go to the Office directory and run the following:

dotnet build

To see if the program is functioning properly you can use:

dotnet watch run

This will show you if everything is compiling correctly; otherwise you be will prompt with error messages.

Dont forget that in order to push any changes you need to add your own GitHub repo. to your project.

git remote add origin [personal Github repo. link]

Import Database with Entity Framework Core

Navigate to the "SillyStringzFactory.Solution/Factory" directory using your terminal.
Run the command 'dotnet ef database update to generate the database through Entity Framework Core.
(Optional) To update the database with any changes to the code, run the command 'dotnet ef migrations add [MigrationsName] which will use Entity Framework Core's code-first principle to generate a database update. After, run the previous command 'dotnet ef database update' to update the database.

AppSettings

Create a new file in the "SillyStringzFactory.Solution/Factory" directory named appsettings.json
Add in the followint code snippet to the new appsettings.json file:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Port=3306;database=damnazon;uid=root;pwd=epicodus;",
    "DamnazonContextConnection": "Server=(localdb)\\mssqllocaldb;Database=firstname_lastname_damnazon;Trusted_Connection=True;MultipleActiveResultSets=true"
  }
}

Import Database with MySQL Workbench

Note: If you have yet to install MySql Workbench follow this link.

Open MySql Workbench and enter your password.
Go to the nav bar at the top, click on Server > Data Import.
Use the option 'Import from Self-Contained File'.
Set the 'Default Target Schema' or create a new schema.
Select all Schema Objects you wish to import.
At the bottom, ensure the option 'Dump Structure and Data' is selected.
Click 'Start Import'

Note: Do this is your main parent directory. You do not want to have git initialized in any other places.

SQL Schema

Technologies Used

Visual Studio Code 1.52.1
C# V:7.3
.NET Core V: 2.2.0
ASP.NET Core MVC
ASP.NET Core Razor Pages
MySQL WorkBench V: 8.0
Entity Framework Core V: 2.2.6
dotnet script, REPL
Stripe API

👥 Contributors

Author	Email
Cory Nordernbrock	cordenbrock@gmail.com
Joseph Giunta	jgnohack@gmail.com
Constantine Yakubovski	faustlarsen@gmail.com
Callie Stump	callie@stu.mp

📝 Legal

MIT License

Copyright (c) 2021 Cory Nordernbrock, Joseph Giunta, Constantine Yakubovski, and Callie Stump

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Return to Top

calliestump/Damnazon.Solutions