Customer Contacts Consolidation

Prototype Script

Costumer Contract Consolidation Scripting Document p. 1

CCC Prototype
October, 12th, 2008

Table of Contents
1 CCC Application.......................................................................................................................................5
Log In.......................................................................................................................................................5
To log into the system please use one of the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman...................................................................................................................................5
Manage Pending Contacts........................................................................................................................6
Manage Customers...................................................................................................................................7
2 GNO Application......................................................................................................................................7
Log In.......................................................................................................................................................7
When the application first starts up you will be taken to a Log In screen. To log into the system please
use one of the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman...................................................................................................................................7
Manage Customers...................................................................................................................................8
Manage Users...........................................................................................................................................8
3 IFO Application........................................................................................................................................8
Log In.......................................................................................................................................................8
When the application first starts up you will be taken to a Log In screen. To log into the system please
use one of the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman...................................................................................................................................8

Costumer Contract Consolidation Scripting Document p. 2

 Manage Customers...................................................................................................................................8
4 UCommand Application...........................................................................................................................9
Log In.......................................................................................................................................................9
When the application first starts up you will be taken to a Log In screen. To log into the system please
use one of the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman.................................................................................................................................10
Manage Customers.................................................................................................................................10
Manage Users.........................................................................................................................................10
5 Data Flow Diagrams...............................................................................................................................11
Data Flow Diagram for Ucommand, IFO, GNO...................................................................................11
Context Diagram................................................................................................................................11
Diagram 1...........................................................................................................................................12
Diagram 1.1 Login.............................................................................................................................13
Diagram 1.2 Manage Customers........................................................................................................14
Diagram 1.2.1 Customer Select and View.........................................................................................15
Diagram 1.2.2 Insert Customer..........................................................................................................16
Diagram 1.2.3 Delete Customer.........................................................................................................17
Diagram 1.2.4 Update Customer.......................................................................................................18
Diagram 1.3 Manage Users................................................................................................................19
Diagram 1.3.1 View and Select Users................................................................................................20
Diagram 1.3.2 Insert User..................................................................................................................21
Diagram 1.3.3 Delete Users...............................................................................................................22
Diagram 1.3.4 Update Users..............................................................................................................23
Data Flow Diagram for Customer Contacts Consolidation ..................................................................24
Context Diagram................................................................................................................................24
Diagram 0...........................................................................................................................................25
Diagram 0.1 Login.............................................................................................................................26
Diagram 0.2 Manage Customer.........................................................................................................27
Diagram 0.2.1 View Customer Information......................................................................................28
Diagram 0.2.2 Insert Customers........................................................................................................29
Diagram .0.2.3 Delete Customers......................................................................................................30
Diagram 0.2.4 Update Customers......................................................................................................31
Diagram 0.2.5 Search Customers.......................................................................................................32
Diagram 0.3 Manage Users................................................................................................................33
Diagram 0.3.1 View Users.................................................................................................................34
Diagram 0.3.2 Add Users...................................................................................................................35
Diagram 0.3.3 Delete Users...............................................................................................................36
Diagram 0.3.4 Update Users..............................................................................................................37

Costumer Contract Consolidation Scripting Document p. 3

 Diagram 0.3.5 Search Users...............................................................................................................38
Diagram 0.3.6 Sort Users...................................................................................................................39
Diagram 0.3.7 Set User Role.............................................................................................................40
Diagram 0.4 Manage Role.................................................................................................................41
Diagram 0.4.1 View Role...................................................................................................................42
Diagram 0.4.2 Add Role....................................................................................................................43
Diagram 0.4.3 Delete Role.................................................................................................................44
Diagram 0.4.4 Update Role...............................................................................................................45
Diagram 0.4.5 Search Role................................................................................................................46
Diagram 0.4.6 Sort Role....................................................................................................................47
6 Entity Relationship Diagram...................................................................................................................48
Entity Relation Diagram for Ucommand, IFO, GNO ...........................................................................48
Entity Relation Diagram for Customer Contacts Consolidation............................................................49
7 Class Diagram ........................................................................................................................................50
Customer Contacts consolidation..........................................................................................................50
Entity Classes.....................................................................................................................................50
............................................................................................................................................................50
GUI Classes.......................................................................................................................................50
Data Access Classes...........................................................................................................................52
Modules..............................................................................................................................................52
U Command ..........................................................................................................................................53
Entity Classes.....................................................................................................................................53
GUI Classes.......................................................................................................................................54
Data Access Classes...........................................................................................................................55
Modules..............................................................................................................................................55
C3Data Set.........................................................................................................................................56
IFO.............................................................................................................................................................57
Entity Classes.....................................................................................................................................57
GUI Classes.......................................................................................................................................58
Data Access Classes...........................................................................................................................59
Modules..............................................................................................................................................59
Data Sets............................................................................................................................................60
GNO.......................................................................................................................................................61
Entity Classes.....................................................................................................................................61
GUI Classes.......................................................................................................................................62
Data Access Classes...........................................................................................................................63
Modules..............................................................................................................................................63
Data Sets............................................................................................................................................64

Costumer Contract Consolidation Scripting Document p. 4

1 CCC Application
Log In

To log into the system please use one of the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman

Username: Tim
Password: Hallowell

When the application first starts up you will be taken to a Log In screen. Type one of the given Usernames listed
above into the Username text field and type in the matching Password into the Password text field. After typing in
your Username and Password, it will either pass you, or fail you. Passing will send you to the switchboard
consisting of three forms (Listed below); failing will give you a message box telling you that there is an invalid
username/password.

Costumer Contract Consolidation Scripting Document p. 5

The switchboard allows you to navigate to various forms, including: Manage Pending Contacts, Manage
Customer Contacts, and Manage C3 Users.

Manage Pending Contacts

Managing Pending Contacts will provide you to access Pending data that needs to be added to the database. The
various functions on this form allow you to Approve the selected pending contact, Update the selected existing
contact, and Overwrite the pending contact with an existing one.

Approve Selected Pending Contact:

This provides the user to allow contact to be added into the CCC database, and be updated in other system
database(s) based on the users role.

Update Selected Existing Contact:

TBD

Overwrite Pending Contact With Existing:

TBD

Costumer Contract Consolidation Scripting Document p. 6

Manage Customers
Managing Customers will provide you to access Customer data. You will be able to do various functions such as:
View a Customer, Add a Customer, Update a Customer (Save), Delete a Customer, and Search a Customer (Not
functioning yet).

Adding a Customer:
To add a customer click either the New button on the toolbar, the add button on the form or go to Options >Add.
This will clear the entire form for you to enter data. Once you have filled out the form, press the save button to
add the user. If you decide you don't want to add a user, click cancel. When the user is added, you will see them
appear in the data grid view.

Updating a Customer:
To update a customer either navigate or select the customer from the data grid and change any of the information
in the input boxes. When you are finished press the save icon, the save button on the form, or go to Options
>Save.

Deleting a Customer:
To delete a customer select the customer you would like to delete by clicking them on the data grid or navigating
there with the record navigation. Next, press the delete icon on the toolbar, the delete button on the form, or go to
Options>Delete.

2 GNO Application
Log In

When the application first starts up you will be taken to a Log In screen. To log into the system please use one of
the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman

Costumer Contract Consolidation Scripting Document p. 7

Username: Tim
Password: Hallowell

Manage Customers

Manage Users

3 IFO Application
Log In

When the application first starts up you will be taken to a Log In screen. To log into the system please use one of
the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman

Username: Tim
Password: Hallowell

Manage Customers
After logging in, you will be taken to the Manage Customers screen. Here you can view information about the
customers. The record navigation (|<, <, >, >|) will navigate through the records displayed in the fields. Clicking
on any of the records in the data grid view will also display the information in the fields.

Costumer Contract Consolidation Scripting Document p. 8

Adding a Customer
To add a customer click either the New button on the toolbar, the add button on the form or go to Options >Add.
This will clear the entire form for you to enter data. Once you have filled out the form, press the save button to
add the user. If you decide you don’t want to add a user, click cancel. When the user is added, you will see them
appear in the data grid view.

Updating a Customer
To update a customer either navigate or select the customer from the data grid and change any of the information
in the input boxes. When you are finished press the save icon, the save button on the form, or go to Options
>Save.

Deleting a Customer
To delete a customer select the customer you would like to delete by clicking them on the data grid or navigating
there with the record navigation. Next, press the delete icon on the toolbar, the delete button on the form, or go to
Options>Delete.

4 UCommand Application
Log In

Costumer Contract Consolidation Scripting Document p. 9

When the application first starts up you will be taken to a Log In screen. To log into the system please use one of
the following username/password combinations:

Username: Michael
Password: Vannest

Username: Mike
Password: Fugua

Username: Jay
Password: Herman

Username: Tim
Password: Hallowell

Manage Customers
After logging in, you will be taken to the Manage Customers screen. Here you can view information about the
customers. The record navigation (|<, <, >, >|) will navigate through the records displayed in the fields. Clicking
on any of the records in the data grid view will also display the information in the fields.

Adding a Customer
To add a customer click either the New button on the toolbar or the add button on the form. This will clear the
entire form for you to enter data. Once you have filled out the form, press the save button or icon to add the user.
If you decide you don’t want to add a user, click cancel. When the user is added, you will see them appear in the
data grid view.

Updating a Customer
To update a customer either navigate or select the customer from the data grid and change any of the information
in the input boxes. When you are finished updating the customer press the save icon or the save button on the
form.

Deleting a Customer
To delete a customer select the customer you would like to delete by clicking them on the data grid or navigating
there with the record navigation. Next, press the delete icon on the toolbar or the delete button on the form.

Manage Users

Costumer Contract Consolidation Scripting Document p. 10

5 Data Flow Diagrams
Data Flow Diagram for Ucommand, IFO, GNO
Context Diagram
0
________

User System CCC

User Data

User Data

Error Message

Appropiate GUI
Customer Data

Manage Customer

Login Request

1
________

Alpha
System

Costumer Contract Consolidation Scripting Document p. 11

Diagram 1
Appropiate GUI
1
0
________
Login Request
________
Login
Error Message System CCC

2
Customer Data
__________
Customer Data
Manage
Customer

Customer Data
Return Data
Customer Data

Return Customer Data 3

User Return User Data _________
User Data User Data
Manage
User

User Data D 1 | Alpha

Costumer Contract Consolidation Scripting Document p. 12

Diagram 1.1 Login
0.1.1
________

Login
Request

0.1.2
_________

Verify
UserName/
Password
D0.1 | tblLogin

0.1.3
_________

User Error
Message
D 0 | tblUserRoles

0.1.4
__________

Check Users
Roles

0.1.5
__________

Issue
Appropriate
GUI

Costumer Contract Consolidation Scripting Document p. 13

Diagram 1.2 Manage Customers

1.2.1
__________

View
Customer
Information

1.2.2
_________

Add
Customer
Information

0
1.2.3 ________
_________
System CCC
User Delete
Customer
Information

1.2.4
__________

Update
Customer
Information

D 1 | tblCustomer

Costumer Contract Consolidation Scripting Document p. 14

Diagram 1.2.1 Customer Select and View

User
[Link]
Customer Object Open DBCommand
________
Return Connection
Open
Database

Customer Object

[Link]
___________
Select SQL String
Retrieve
Select Statement D 1.2.1 | tblSQL
Select
SQL
0 String
________
Alpha DB
System CCC

[Link]
___________ Select Data
D 1.2.2 | tblCustomer
Return Result
Execute
Select
Dataset SQL String

[Link]
___________
Dataset
Close Close DBCommand
Database

[Link]
___________

Return
Dataset

Costumer Contract Consolidation Scripting Document p. 15

Diagram 1.2.2 Insert Customer

User

Customer Object [Link] Return Result

________ Open DBCommand

Customer Object Open

Database

[Link]
___________

Create
0 Insert
________ SQL
String
System CCC Alpha DB

[Link]
___________ Insert Data

Return Result D 1.2.2 | tblCustomer

Execute
Insert
Result SQL String

[Link]
___________
Result
Close Close DBCommand
Database

[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 16

Diagram 1.2.3 Delete Customer

User
Customer Object [Link]
Confirm Delete _________

Verify
Action

[Link]
________ Open DBCommand

Customer Object Return Result

Open
Database

[Link]
___________

Create
0 Delete
________ SQL
String
System CCC

[Link] Alpha DB
___________

Execute Delete Data D 1.2.2 | tblCustomer

Delete Return Result
SQL String
Result

[Link]
___________ Close DBCommand
Result
Close
Database

[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 17

Diagram 1.2.4 Update Customer

User

Customer Object [Link] Return Result

________ Open DBCommand

Customer Object Open

Database

[Link]
___________

Create
0 Update
________ SQL
String
System CCC Alpha DB

[Link]
___________ Update Data

Return Result D 1.2.2 | tblCustomer

Execute
Update
Result SQL String

[Link]
___________
Result
Close Close DBCommand
Database

[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 18

Diagram 1.3 Manage Users

1.3.1
User Data
__________
User Data Record Set

View
User View Query
Information

1.3.2
User Data _________
Add Query
User Data
Add
User Record Set
Information

1.3.3
User Data _________
Record Set
User Data
User Delete
User Delete Query
Information

1.3.4
__________
User Data
Record Set
Update
User Data User
Information

Update Query

D 1 | tblUser

Costumer Contract Consolidation Scripting Document p. 19

Diagram 1.3.1 View and Select Users

User
[Link]
Customer Object Open DBCommand
________
Return Connection
Open
Database

[Link]
___________
Select SQL String
Retrieve
Select Statement D 1.3.1 | tblSQL
Select
SQL
String

Alpha DB

[Link]
___________ Select Data
D 1.3.2 | tblUser
Return Result
Execute
Select
Dataset SQL String

[Link]
___________

Close Close DBCommand

Database

[Link]
___________

Return
Dataset

Costumer Contract Consolidation Scripting Document p. 20

Diagram 1.3.2 Insert User
[Link]
Return DB Connection
________
User Object
Open DBCommand
Open
Database

[Link]
___________

Create
Insert
SQL
String

User
[Link]
___________ Insert Data
D 1.3.2 | tblUser
Return Result
Execute
Insert
SQL String
Alpha DB

[Link]
___________
Close DBCommand
Close
Database

Result
[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 21

Diagram 1.3.3 Delete Users
[Link]
________
User Object Open DBCommand

Open Return DB Connection

Database

[Link]
___________

Create
Delete
SQL
String

User
[Link]
___________ Delete Data
Return Result
D 1.3.2 | tblUser
Execute
Delete Alpha DB
SQL String

[Link]
___________
Close DBCommand
Close
Database

Result
[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 22

Diagram 1.3.4 Update Users
[Link]
________
User Object Open DBCommand

Open Return Result

Database

[Link]
___________

Create
Update
SQL
String

User
[Link]
___________ Update Data
Return Result
D 1.3.2 | tblUser
Execute
Update Alpha DB
SQL String

[Link]
___________
Close DBCommand
Close
Database

Result
[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 23

Data Flow Diagram for Customer Contacts Consolidation
Context Diagram

User
1
User Data ________

User Data System Alpha

Error Message

Appropiate GUI
Manage Customer

Customer Data

Login Request

0
________

CCC
System

Costumer Contract Consolidation Scripting Document p. 24

Diagram 0
1
________

System Alpha

0.1
________

Login
Login Request
Appropiate GUI
Error Message
User 0.2 Customer Data
Customer Data
Customer Data __________
Return Customer Data Customer Data
Manage D 0 | Whisky
Customer Return Data

0.3
Return User Data _________ User Data
User Data
Manage
User Data
User

Role Data Role Data

0.4
_________

Manage
Role

Costumer Contract Consolidation Scripting Document p. 25

Diagram 0.1 Login
0.1.1
________
User Name
Login
Password
Request

Verification

0.1.2
_________

Verify
UserName/
Password
DB Check
D0.1 | tblLogin

0.1.3
_________
Error Message
Error Thrown Error
User
Message
D 0 | tblUserRoles

0.1.4
__________
Access
Check Users
Roles

Role ID 0.1.5
__________

Appropiate GUI
Issue
Appropriate
GUI

Costumer Contract Consolidation Scripting Document p. 26

Diagram 0.2 Manage Customer
0.2.1
Cust Data
__________ Cust Data
Cust Data
View
Record Set Cust Cust Data
View Query Information

0.2.2
Cust Data _________
Cust Data Cust Data
Add
Add Query Cust Cust Data
Record Set Information

1
Delete Query 0.2.3 Cust Data ________
_________
Cust Data Cust Data System Alpha
Cust Data
Delete
User
Record Set Cust
Information

D 0.2 |
tblCustomers Update Query 0.2.4
Record Set__________
Cust Data

Update
Cust Data Cust
Cust Data
Information Cust Data

Cust Data 0.2.5

___________ Cust Data
Cust Data
Record Set
Search Cust Data
Search Query Cust
Information

Record Set 0.2.6

Sort Query _________ Cust Data

Cust Data
Sort
Cust Data Cust
Cust Data Information

Costumer Contract Consolidation Scripting Document p. 27

Diagram 0.2.1 View Customer Information
D0|
Return DB Connection
Whisky DB

[Link]
________
Return Message Open DB Command
Open
Database

Cust Data [Link]

___________
Select Statement D 0.2.1 | tblSQL
Create Select SQL String
Select
SQL
String

[Link]
___________
Select Data D 0.2.2 | tblCustomer
Execute Return Result
User Return Flag
Select
SQL String DB Close Command

[Link]
___________

Close
Database

[Link]
___________
Flag
Return
Flag

Flag
[Link] 1
___________ ________
Object Cust
Flag System Alpha
Pass Object
to Alpha

Costumer Contract Consolidation Scripting Document p. 28

Diagram 0.2.2 Insert Customers

[Link]
Customer Object Generate
User
SQL
(Generic )
Customer Object

tblCustomers
[Link] Request
1 Connect to OLEDB Connection
System Database
Alpha

0.2.2.3a [Link] DataSet

Select DataSet Check for
SQL SELECT (tblSQL)
Customer Existing
No Match
Customer Object
0.2.2.3b
Execute Primary Key
0.2.2.3b SQL INSERT
INSERT
Execute tblCustomer
UPDATE s
tblCustomers

0.2.2.3b
Result Execute INSERT SQL INSERT tblCustomerRoles
tblCustomerRoles Result
Customer Object/ Result

[Link]
Generate
Message

Costumer Contract Consolidation Scripting Document p. 29

Diagram .0.2.3 Delete Customers
D 0.2.3 |
Return DB Connection
tblCustomers

[Link]
________
Open DB Command
Return Message Open
Database

Cust Data
[Link]
___________
Return Flag

Create
Delete SQL Delete Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object Cust
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 30

Diagram 0.2.4 Update Customers

D 0.2.4 |
Return DB Connection
tblCustomers

[Link]
________
Open DB Command
Open
Database
Return Message

Cust Data

[Link]
___________
Return Flag

Create
Update SQL Update Command
SQL
String

[Link]
Return Flag
___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object Cust
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 31

Diagram 0.2.5 Search Customers
D 0.2.5 |
Return DB Connection
tblCustomers

[Link]
________
Open DB Command
Return Message Open
Database

Cust Data
[Link]
___________
Return Flag

Create
Select SQL Select Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object Cust
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 32

Diagram 0.3 Manage Users
0.3.1
User Data
__________ Select Query
User Data
View Record Set
User
Information

0.3.2
User Data _________
Add Query
User Data
Add
User Record Set
Information

0.3.3
User Data _________ Delete Query
User Data
User Delete
Record Set
User
Information

User Data
0.3.4
__________ Update Query
User Data
Update
User Record Set
Information

User Data 0.3.5

User Data
___________
Select Query

Search
User Record Set
Information

User Data
0.3.6
_________ Record Set

Sort
User Data User Select Query
User Data Information

User Data

0.3.7
_________

Set
User
Role Role Set
Record Set D 0.3 |
tblUsers

Costumer Contract Consolidation Scripting Document p. 33

Diagram 0.3.1 View Users
[Link] Return DB Connection
________
User Object
Open DBCommand
Open
Database

[Link]
___________ Select Statement
D 0.3.1 | tblSQL
Retrieve Select SQL String
Select
SQL
String

User Whiskey DB
[Link]
___________ Select Data
Return Result
D 0.3.2 | tblUser
Execute
Select
SQL String

[Link]
___________ Close DBCommand

Close
Database

Result
[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 34

Diagram 0.3.2 Add Users
D 0.3.2 |
Return DB Connection
tblUsers

[Link]
________
DB Open Command
Return Message Open
Database

User Data
[Link]
___________
Return Flag

Create
Insert SQL Insert Command
SQL
String

[Link] DB Close Command

Return Flag
___________

Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object User
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 35

Diagram 0.3.3 Delete Users
D 0.3.3 |
Return DB Connection
tblUsers

[Link]
________
Open DB Command
Return Message
Open
Database

User Data [Link]

___________
Return Flag

Create
Delete SQL Delete Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object User
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 36

Diagram 0.3.4 Update Users
D 0.3.4 |
Return DB Connection
tblUsers

[Link]
________
Return Message Open DB Command
Open
Database

User Data [Link]

___________
Return Flag

Create
Update SQL Update Command
SQL
String

Return Flag
[Link]
___________
DB Close Command
Close
User Database

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object User
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 37

Diagram 0.3.5 Search Users
D 0.3.5 |
Return DB Connection
tblUsers

[Link]
________
Return Message Open DB Command
Open
Database

User Data [Link]

___________
Return Flag

Create
Select SQL Select Command
SQL
String

Return Flag
[Link]
___________
DB Close Command

Close
User Database

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object User
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 38

Diagram 0.3.6 Sort Users
D 0.3.6 |
Return DB Connection
tblUsers

[Link]
________
Open DB Command
Return Message Open
Database

User Data
[Link]
___________
Return Flag

Create
Select SQL Select Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object User
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 39

Diagram 0.3.7 Set User Role
D 0.3.6 |
Return DB Connection
tblUsers

[Link]
________
Open DB Command
Return Message Open
Database

User Data
[Link]
___________
Return Flag

Create
Select SQL Select Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object User
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 40

Diagram 0.4 Manage Role

0.4.1
Role Data
__________
Role Data Record Set
View
Role View Query
Information

0.4.2
Role Data _________
Add Query
Role Data
Add
Role Record Set
Information

0.4.3
Role Data _________
Record Set
Role Data
User Delete
Role Delete Query
Information

0.4.4
__________ Update Query

Update
Role Data Role Record Set
Information
Role Data

Role Data 0.4.5

Role Data
___________
Search Query

Search
Role Record Set
Information

0.4.6
_________
Sort Query
Sort
Role Data Role
Role Data Information

Record Set D 0.4 |

tblUserRoles

Costumer Contract Consolidation Scripting Document p. 41

Diagram 0.4.1 View Role
[Link] Return DB Connection
________
User Object Open DBCommand

Open
Database

[Link]
___________ Select Statement
D 0.4.1 | tblSQL
Retrieve Select SQL String
Select
SQL
String
Alpha DB
User
[Link]
___________ Select Data
Return Result
D 0.4.2 | tblUserRoles
Execute
Select
SQL String

[Link]
___________

Close Close DBCommand

Database

Result
[Link]
___________

Return
Result

Costumer Contract Consolidation Scripting Document p. 42

Diagram 0.4.2 Add Role
D 0.4.2 |
Return DB Connection
tblUserRoles

[Link]
________
Open DB Command
Return Message
Open
Database

Role Data [Link]

___________
Return Flag

Create
Insert SQL Insert Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object Role
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 43

Diagram 0.4.3 Delete Role
D 0.4.3 |
Return DB Connection
tblUserRoles

[Link]
________
Return Message Open DB Command
Open
Database

Role Data
[Link]
___________
Return Flag

Create
Delete SQL Delete Command
SQL
String

Return Flag
[Link]
___________ DB Close Command

User Close
Database

[Link]
___________
Flag
Return
Flag

[Link]
1
___________
Flag
________
Object Role
Pass Object Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 44

Diagram 0.4.4 Update Role
D 0.4.4 |
Return DB Connection
tblUserRoles

[Link]
________
Open DB Command
Return Message Open
Database

Role Data
[Link]
___________
Return Flag

Create
Update SQL Update Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
___________ 1
Flag ________
Object Role
Pass Object
Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 45

Diagram 0.4.5 Search Role
D 0.4.5 |
Return DB Connection
tblUserRoles

[Link]
________
Open DB Command
Return Message Open
Database

Role Data
[Link]
___________
Return Flag

Create
Select SQL Select Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
___________ 1
Flag ________
Object Role
Pass Object
Flag System Alpha
to Alpha

Costumer Contract Consolidation Scripting Document p. 46

Diagram 0.4.6 Sort Role
D 0.4.6 |
Return DB Connection
tblUserRoles

[Link]
________
Open DB Command
Return Message Open
Database

Role Data
[Link]
___________
Return Flag

Create
Select SQL Select Command
SQL
String

[Link] Return Flag

___________
DB Close Command
Close
Database
User

[Link]
___________
Flag
Return
Flag

[Link]
___________ 1
Flag ________
Object Role
Pass Object
to Alpha Flag
System Alpha

Costumer Contract Consolidation Scripting Document p. 47

6 Entity Relationship Diagram
Entity Relation Diagram for Ucommand, IFO, GNO

Costumer Contract Consolidation Scripting Document p. 48

Entity Relation Diagram for Customer Contacts Consolidation

Costumer Contract Consolidation Scripting Document p. 49

7 Class Diagram
Customer Contacts consolidation
Entity Classes

GUI Classes

Costumer Contract Consolidation Scripting Document p. 50

Costumer Contract Consolidation Scripting Document p. 51
Data Access Classes

Modules

Costumer Contract Consolidation Scripting Document p. 52

U Command
Entity Classes

Costumer Contract Consolidation Scripting Document p. 53

GUI Classes

Costumer Contract Consolidation Scripting Document p. 54

Data Access Classes

Modules

Costumer Contract Consolidation Scripting Document p. 55

C3Data Set

Costumer Contract Consolidation Scripting Document p. 56

IFO
Entity Classes

Costumer Contract Consolidation Scripting Document p. 57

GUI Classes

Costumer Contract Consolidation Scripting Document p. 58

Data Access Classes

Modules

Costumer Contract Consolidation Scripting Document p. 59

Data Sets

Costumer Contract Consolidation Scripting Document p. 60

GNO
Entity Classes

Costumer Contract Consolidation Scripting Document p. 61

GUI Classes

Costumer Contract Consolidation Scripting Document p. 62

Data Access Classes

Modules

Costumer Contract Consolidation Scripting Document p. 63

Data Sets

Costumer Contract Consolidation Scripting Document p. 64