ClientER Progress Presentation

cavalcadejewelΛογισμικό & κατασκευή λογ/κού

18 Νοε 2013 (πριν από 3 χρόνια και 11 μήνες)

83 εμφανίσεις

ClientER

Progress Presentation

Omar Jamal

Stéphane Lee

Marcel Sauvé

Client Description





Company CEO’s named Alexandra Russell and
France Landry


French tutoring and camp services


They need a way to manage their client data!


http://www.frenchsolutions.ca/


Program Description


Company needs a program, we need to program!



Therefore, we create an application named
ClientER





Client database for services and income




Designed specifically for
FrenchSolutions




Helps company convenience and efficiency


Program Features


The database will include several features:


1. Mass mailing services


2. Tax return print table


3. Encryption for security


4. Compression for storage


5. Network updating for easy access


6. All basic database table options





View, add, delete, edit, print, search, save

Task Division

Our company is formed of three individuals:





Marcel


Network, compression and encryption


Omar


GUI pages; login screen, registration,
and emergency data


Stéphane


Database GUI and functions, and
company relations

Let’s begin on what we’ve
accomplished…

Login Page GUI


Contains hashing for
password security


Only one main
account, as requested
by
FrenchSolutions


Logo design

Menu GUI


Includes quick
access options


Adds to database
memory, which is
already loaded into
Vector of Vectors
from main file

Database GUI

Database GUI (cont…)


Add and removes columns


Edits data and saves it to file


Filter for quick easy search


Sorting, which can be used for mass mailing


Column order does not affect data


Allows backup

Encryption and Network


Encryption used on database files


Server application manages database updates


Allows for communication between server
application and client (useful for multiple
registrations)

Past Problems and Solutions
-

Omar


Problem #1: The login name and password was
stored as regular strings, which is unsafe.


Solution #1: SHA method is used.




Problem #2: Adding a new client by taking from
JTextFields

directly is inefficient.


Solution #2: Made a new class ‘Client’ to hold all
information of each individual client.


Past Problems and Solutions
-

Stéphane


Problem #1: The database would not load
properly from file.


Solution #1: A program called XVII was used to
debug the file.
RandomAccessFile

class was used
to read and write.



Problem #2: The table was difficult to make by
using a series of
JTextFields
.


Solution #2: The
Jtable

class was used.

Past Problems and Solutions
-

Marcel


Problem #1: Custom encryption is easily
breakable.


Solution #1: Use Java Crypto classes.



Problem #2: Multi
-
Threading caused massive
computer breakdowns.


Solution #2: Do not use multi
-
threads

Current Problems



Network issues with server connection (Java
crashing)


Mass mailing is difficult to implement using
email server


Camp registrations based on date should be
implemented


To do’s


Connecting all
ClientER

work together


Emergency contact pane


Financial database linked to clients, and printing


Complete file updating on the network


Fixing all bugs


Client documentation/paperwork


Adding all of their clients to the database

Demos


We will now demo the program
ClientER
.



1. The login and menu pages


2. The database functions


3. The network abilities