1 / 17

ClientER Progress Presentation

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.

bell
Download Presentation

ClientER Progress Presentation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ClientER Progress Presentation Omar Jamal Stéphane Lee Marcel Sauvé

  2. 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/

  3. 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

  4. 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

  5. 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

  6. Let’s begin on what we’ve accomplished…

  7. Login Page GUI • Contains hashing for password security • Only one main account, as requested by FrenchSolutions • Logo design

  8. Menu GUI • Includes quick access options • Adds to database memory, which is already loaded into Vector of Vectors from main file

  9. Database GUI

  10. 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

  11. 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)

  12. 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.

  13. 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.

  14. 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

  15. 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

  16. 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

  17. Demos • We will now demo the program ClientER. • 1. The login and menu pages • 2. The database functions • 3. The network abilities

More Related