ImplementationDetails

Write the first paragraph of your page here.

Implementation Details
Just in case you were wondering how this app was developed.

I wrote this system to learn how to write C# code and how to use it with mysql. I use Microsoft Visual Sstudio Expres 2013 which is a pretty good IDE.

All code is written in C# with mysql queries.

Tools Used
Mysql workbench for sql query design and database creation / direct manipulation. I recommend downloading this.

IDE - Visual Studio Express for windows 7 desktop. This download can currently be found herebut note that the page url seems to change from year to year.

MYSQL is supplied via XAMPP. This seems the easiest way to get up and running with mysql.

The UI
This is also in dreadful condition. At the best of times I struggle with UI design, however this us is just slapped up to gain access to functionality - sorry.

The Database
SAT requires a Myssql database to operate. This initial version of SAT requires;
 * an active version of mysql running on the same host as the one that will run the SAT application.
 * a database called productionDB to be created
 * 3 tables created as per schema listed below.
 * a user root with no password

Currently I don't use any security, I access the DB as root and no password - clearly this is an area that needs to be looked at.

I also have no way to back or edit the database up via software (that is where mysql workbench comes in).

The SAT application can create its own new database and set of tables.

The Schema is documented here

State of the code:
Not really good. I am not trying to write obfusacted code, at the same time I am not trying to write pretty code, I am just trying to learn the best way to do things. I slap things up very quickly and really just about everything should be rewritten and it would woudl be much cleaner.

Also, the code is very buggy, I havent put much time into catching error conditions so no doubt the program can / will fall over at some point.

Section heading
Write the second section of your page here.