Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Case Study For Event Management Application With Report Designer (LogiXML) Functionality
Gateway TechnoLabs Pvt. Ltd. 8th Floor, Corporate House, Judges Bungalow Road, Bodakdev, Ahmedabad - 380 054, India Tel: +91 79 2685 255/5/6 Fax: +91 79 26858591 E-mail:
[email protected] URL: www.gatewaytechnolabs.com
Copyright © 1997-2007 Gateway Technolabs Pvt Ltd
This document and any files with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please destroy all copies of the document. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this document or any action taken in reliance on this document is strictly prohibited and may be unlawful. Visit us at www.gatewaytechnolabs.com Confidential Document
Page 1 of 16
Gateway TechnoLabs Pvt Ltd. Event Management Application
June 2007
Case Study
Table of Contents 1.
THE CLIENT ........................................................................................................ 3
2.
THE PROJECT ..................................................................................................... 3
3.
THE CHALLENGES ............................................................................................... 4
4.
THE SOLUTION................................................................................................... 5
5.
FEATURES .......................................................................................................... 6
6.
BENEFITS ........................................................................................................... 6
7.
TEAM SIZE ......................................................................................................... 7
8.
PROJECT DURATION .......................................................................................... 7
9.
SCREEN SHOTS................................................................................................... 7
Confidential Document
Page 2 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
1. The Client The client is an NGO involved in children and youth related welfare activities, so they wish to manage their activities and programs. The client required a system which enables administrator to create different agencies and their administrator
using
web
admin
site.
Agency
administrator
can
create
user
logins
its
administrator. It also provides mechanism for data sharing across different agencies. The client also required a report designer functionality to allow the users to generate reports based on their requirements. As per the government rules and it highly influences on this domain, security is the prime concern of the application.
2. The Project CYSIS is a centralized web application to manage Agencies and their Clients, Family, Services and Events. Here Agency is an individual unit or an office providing welfare services to the clients. The system provides Agency wise isolated data store. The system is equipped with Form designer and Report designer functionalities to meet Agency specific custom needs. The system provides consolidated information over distributed databases. There are two modules in the system: •
Web administration: The system enables main administrator to create different agencies and their administrator using web admin site. Agency administrator creates user logins and sub agencies and its administrator.
•
Web site related to core business activities: The application used by the agencies. It provides core functionalities to deal with clients and services.
The main objective of the system includes: •
Management of information system from a centralized location via Web Application.
•
Allow creating Agency databases, to work under single roof of agencies.
•
Intake and Client profiles and Service records.
•
Data sharing mechanism across different agencies. Client service profile can be shared from one agency to another.
•
Maintain Record Update History of key activities.
Confidential Document
Page 3 of 16
Gateway TechnoLabs Pvt Ltd. Event Management Application
June 2007
Case Study
•
Encryption of secret data like SIN, username and password.
•
Automates the function of Service Funding.
•
Message broadcasting.
•
Rich set of statistical and analytical reports.
•
Physically separate three layered security architecture design.
•
Provides a form designer to create simple entry forms based on agency specific requirements.
•
Integrated with our own security mail system which allows CYSIS3 users to communicate internally with users across agencies.
•
Integrates LogiXML - wizard based report designer to design & generate reports, even by the novice user, as per agency requirements.
3. The Challenges •
Microsoft .Net Remote Enterprise Business Solution security architecture.
•
Usage of data serialization and reflection.
•
Maintain agency wise separate database and provide data sharing.
•
Data encryption using inbuilt feature of SQL 2005.
Confidential Document
Page 4 of 16
Gateway TechnoLabs Pvt Ltd. Event Management Application
June 2007
Case Study
4. The Solution •
Microsoft .NET Framework 2.0 (Visual Studio 2005), VB.
•
Microsoft SQL Server 2005.
•
Microsoft .Net Remote Enterprise Business Solution:
Confidential Document
Page 5 of 16
Gateway TechnoLabs Pvt Ltd. Event Management Application
June 2007
Case Study
5. Features •
Microsoft .Net Remote Enterprise Business Solution: Physically Separate Application, Business Logic and Database layers. Application and Business layers are communicating through the authenticated web service call.
•
Separate database for each agency.
•
Security token verification for each BO layer call.
•
Usage of MS-SQL 2005 built in data encryption feature.
•
Data sharing between agencies.
•
Custom form which allows user creating pages run time as per the need.
•
Integrated security mail system.
•
LogiXML ad hoc reporting tool integration.
6. Benefits •
Effective and efficient client and service management.
•
Self intuitive User Interface.
•
Ready statistics having complex business conditions at finger tips.
•
Secure data processing and storage.
•
Custom Forms - allows creating need based entry forms with rich set of controls.
•
Allows designing need based reports through LogiXML ad hoc report designer.
•
Secure mail communication restricted for agency users internally.
Confidential Document
Page 6 of 16
Gateway TechnoLabs Pvt Ltd. Event Management Application
June 2007
Case Study
7. Team Size Team Size: 1 Project Manager + 10 Software Professionals
8. Project Duration Project Duration: Approx. 6000 Man Hours
9. Screen Shots Following are some of the screen shots which are taken from the application. These screen shots includes the customized report designer and its various options.
Confidential Document
Page 7 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Application Home Page
Confidential Document
Page 8 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Report Designer Screen: using this screen, various kinds of reports will be designed.This includes the option to add various kinds of graphs/charts, custom header/footer, font colors. Confidential Document
Page 9 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Various kinds of report style settings. Confidential Document
Page 10 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Selected table/View from the database from the report will be generated Confidential Document
Page 11 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Displays available columns for generating report Confidential Document
Page 12 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Various Input parameters for report Confidential Document
Page 13 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Various Columns for display Confidential Document
Page 14 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Generated PIE chart showing the gender ratio
Confidential Document
Page 15 of 16
Gateway TechnoLabs Pvt Ltd. June 2007
Event Management Application Case Study
Actual report in tabular format
Confidential Document
Page 16 of 16