v0.1.0 Initial Release

Initial Release:

• Initial creation of program and basic ATM functionality
• MySQL database will need to be setup by the end user and locally hosted according to README.md
• Broadly implemented interfaces to prep for later projects, i.e. unit testing
• First attempt to implement SOLID principles

ATM C# Project

This is a console-based application simulating an ATM's' menu options. With this project, I had 3 main goals:

• Create my first C# program and familiarize myself with the syntax
• Introduce myself to MySQL and the interactions between a program and an external database (locally hosted)
• Attempt to properly implement and familiarize myself with the SOLID principles

Dependencies

This project utilizes some additional projects and librarys:

• Autofac
• Dapper
• MySQL.data
• Database Access Library

MySQL Setup

This project will utilize a locally hosted MySQL database.

To setup the MySQL database:

• Intsall MySQL
• Run installer and install by selection using developers install option
• Reference Video

My Default Credentials for this project

• MySQL root
• pass: SQLpass

My Default MySQL Account:

MySQL user account:

• user: DBAdmin
• pass: admin

Continuing Installation:

hit next/accept defaults everywhere else

Initialization:

GUI: Database -> Connect to database ->
Select stored connection -> Local instance MySQL router
password -> store in vault -> MySQL root pass

Table Setup

We will create the following table: tbluseraccount

And initialize some user data:

We are now ready to use the ATM!