ClientER Progress PresentationOmar JamalStéphane LeeMarcel 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 services2. Tax return print table3. Encryption for security4. Compression for storage5. Network updating for easy access6. All basic database table options

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

Task DivisionOur 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