aspit-cv / aspit.studentreg Goto Github PK

#8

We need another database for testing (Right now testing and running the program accesses the same database) (this isnt a big problem right now, but will be in the future)

Right now there are 3-4 issues shown in the error list. They should be fixed.

Users

• Id
• Name
• Username
• AttendanceRegistrationsKey

AttendanceRegistrations

• Id
• UsersKey
• MeetingTime
• LeaveTime
• Date

Pretty sure the connection.config files arent used by any project right now and can be removed

connections.config is not being ignored by github.

Default leave time is 01-01-000112:00:00

SQL require it to be later than 01-01-1753 12:00:00

SqlTypeException: Overløb i SqlDateTime. Værdien skal være mellem 01-01-1753 12:00:00 og 31-12-9999 23:59:59.

Make the UI for the the controller application using xaml

A few small featuers to add to the controller app:

1. Make a button to refresh students
2. Make a search text box so you can find a student
3. Sort the list in attendance registrations viewer

Bigger featuers:

1. Change datagrids into list box and color code things where it fits
2. Make a way to easily see who has forgotten to check in/out

The connection string we are using right now has a flaw:

1. The connection string only works from our computer

Problem with fixing this:
If we make the connection string work for other users then everyone on the internet has free access to the database (because the app.config is visible here on github which means they can easily find/get the connection string)