CSC207 FSPB1 Hanth Group

ERD Diagram

2008-03-18T02:53:00.001+08:00

Date: 17th March 2008

Final Sequence Diagrams

2008-03-18T02:49:00.003+08:00

Date: 17th March 2008

Final Class Diagram

2008-03-18T02:48:00.001+08:00

Date: 17th March 2008

Final Use Case Diagram

2008-03-18T02:45:00.002+08:00

Date: 17th March 2008

Further Refined User Specifications

2008-03-18T02:41:00.002+08:00

We are to design an Enterprise Resources Planning (ERP) that links two standalone systems, Sales and Invoicing System and Warehouse Management System for biomedical equipment company called Buy-O-Medical. Both systems are linked through a common database.

Both the Sales and Invoicing System (SIS) and the Warehouse Management System (WMS) require all users to log in. If the logged in user is an existing client, the SIS must be able to generate Sales Quotation (SQ) by the client’s request. It provides the option for the client to download the SQ in PDF file format. The system allows the client to view existing SQ that has already been created by that particular client. Following that, the system allows the client to place or submit Purchase Order (PO) based on the SQ created. However, if the logged in user is the Sales Admin, he/she can approve the submitted PO through the system. The SIS then automatically generate the Sales Order (SO) and the Delivery Order (DO). Once the client is confirmed to have received the goods, the Sales Admin can generate the invoice and the system will e-mail the invoice to the client. Payment can be updated by the Sales Admin through the system after the client has made the payment (assuming the payment is not handled by the system). The system allows the Sales Admin to cancel the PO/SO when requested by the client (with exception only when the DO has not been issued). If the log-in user is the Logistic Staff, he/she can maintain the inventory and insert new item information through the WMS. If the stock is out or low, the Logistic Staff can request to restock the item. If the Delivery Man logs in, he/she can retrieve the DO, request the item location and update the delivery status in the WMS. The System Admin is able to access and maintain both systems as well as the user information. Both systems provide user help and system information to all users except for the System Admin. Both systems provide account settings where all users can update their particulars and password.

*During the process of generating the SQ, the client can view the stock status namely: in-stock, low-stock and out-of-stock. When the stock status is in-stock or low-stock, the delivery would be made within 14 days and approximately 44 days (inclusive of shipping) respectively. However when the stock status is out-of-stock, the delivery date will be notified to the client upon stock availability.

Software Specifications

This project is to be completed within 3 to 4 months. Due to time limitation and since developers understood the requirements well we have decided to use the Rapid Application Development (RAD) Model. We are able to use similar product in market for reference. Customer would prefer us to use ASP.NET 2.0, however, is open to options as long as it is web-based and stress on user-friendliness. Therefore, we have decided to use ASP.NET 2.0 and MSSQL 2005 database. Customer does not want us to compile the source code as there would be an IT team from their company which would manage and maintain the system.

Hardware Specifications

Distributed Database Server

Core 2 Duo Processor
4GB 667Mhz Memory
1.5 TB Internal Storage
Web Hosting (IIS)
Windows Server 2003 SP3

For end user, use Internet Explorer (IE) 5.5 or above.

Date: 17 March 2008

Updated Client, Sales Admin, Deliveryman Sequence Diagrams

2008-03-05T23:04:00.008+08:00

Date: 3rd March 2008

Refined Class Diagram

2008-03-05T21:48:00.007+08:00

Date: 3rd March 2008

Refined Use Case Diagram

2008-03-05T21:47:00.000+08:00

Date: 3rd March 2008

Refined User Specifications

2008-03-03T21:34:00.001+08:00

Software Specifications

Hardware Specifications

Distributed Database Server

Core 2 Duo Processor
4GB 667Mhz Memory
1.5 TB Internal Storage
Web Hosting (IIS)
Windows Server 2003 SP3

For end user, use Internet Explorer (IE) 5.5 or above.

Date: 3rd March 2008

CIDP: Work Distribution & Progress Day 3 (27/02/08)

2008-02-27T00:17:00.000+08:00

Date: 27th February 2008
Venue: Database Tech Lab

WORK DISTRIBUTION

Matric No.	Members	Roles
075038G06	Abdul Muttalib Mohammed Rahman	Edit Database with more fields
		Familiarize with ASP.net and VS
		Research on Pop-up windows
075059D06	Ahmad Hafiz Bin Ismail	Research, Development & Testing
075028D06	Albert Chua	Create new classes
		Handle Stored Procedure
		Resolve DB problems
		Debug Login Module
074958J06	Muhammad Hariz Bin Bakri	Implementing GUI design
075129K06	Siti Nadiah Binte Zainal (Leader)	Create Work Distribution & Progress
		Create Form Template (SQ,PO,SO)
		Obtain Information for the Forms
		Research on VB

WORK PROGRESS

ABDUL MUTALLIB MOHAMMED RAHMAN		CAT	PROGRESS	COMMENTS
1	Added phone field (bigint) in tblClient	DB	Completed
2	Added field itmMore{varchar(1000)} to tblItm to store more details for item	DB	Completed
3	Added field itmFeat{varchar(1000)} to tblItm to store features of item	DB	Completed
4	Familiarise with asp.net and visual studio	MISC	Completed
5	Research on customisable pop-up window using javascript and asp .net	RES	Completed
6	Code on pop-up window to be used for 'more details' for the items	RES	Completed

AHMAD HAFIZ BIN ISMAIL

CAT

PROGRESS

COMMENTS

Assist Members with any problems occurs

Help to research
Develop the codes
Testing

RES

Completed

ALBERT CHUA		CAT	PROGRESS	COMMENTS
1	Stp “stpGetAllItms” added	DB	Completed
2	Class added ClsSIS - SIS Class to manage top level functions of sales and invoicing ClsBLL_User.vb - Class contains business logic functions of user module ClsDSL_User.vb - Class contains data structure functions of user module ClsBLL_SQ.vb - Class contains business logic functions of SQ module ClsDSL_SQ.vb - Class contains data structure functions of SQ module ClsBssForm.vb - Parent class for all form types(SQ,SO,PO and DO) ClsBLL_Itm.vb - Class contains business logic functions of item module ClsDSL_Itm.vb - Class contains data structure functions of item module ClsBLL_Cust.vb - Class contains business logic functions of customer module ClsDSL_Cust.vb - Class contains data structure functions of customer module	CLS	Completed
3	ClsCommon.vb merges with ClsConfig.vb	CLS	Completed
4	ClsCommon.vb removed	CLS	Completed
5	Items Image display problem resolved. By adding virtual dir link to the image folder, use the virtual dir as image URL Alias name of its virtual dir as “erp_images”	DB	Completed
6	Stored Procedure Added stpGetCustInfo stpGetItmInfo stpGetLastSQID	DB	Completed
7	Stored Procedure Amended stpLogin	DB	Completed
8	Remove input param @UserType	DB	Completed
9	Amend Login module to remove the customer checkbox from the login module.	LOG	Completed
10	frmCustSQCfm.aspx To generate and display the SQ form after customer has selected the products (items) they want.	SQ	Completed

MUHAMMAD HARIZ BIN BAKRI		CAT	PROGRESS	COMMENTS
1	Implementing GUI design	GUI	In Progress

SITI NADIAH BINTE ZAINAL		CAT	PROGRESS	COMMENTS
1	Create Work Distribution & Progress	MISC	Completed
2	Create Sales Quotation Form Template	GUI	Completed
3	Create Purchase Order Form Template	GUI	Completed
4	Create Sales Order Form Template	GUI	Completed
5	Add SQ,PO,SO information to the Forms	GUI	Completed
6	Analyze VB codes for understanding	RES	Completed
7	Coding on Dataview and Datasource	RES	Completed

Legend:
DB - Database
MISC - Miscellaneous
GUI - Graphical User Interface
LOG - Login
CFG - Config
PL - Product List
RES - Research
TEST - Testing
SQ - Sales Quotation
CLS - Class

CIDP: Work Distribution & Progress Day 2 (26/02/08)

2008-02-26T23:51:00.002+08:00

Date: 26th February 2008
Venue: Database Tech Lab

WORK DISTRIBUTION

Matric No.	Members	Roles
075038G06	Abdul Muttalib Mohammed Rahman	Database Refinement
075059D06	Ahmad Hafiz Bin Ismail	Research and Test on Pop-ups
075028D06	Albert Chua	Debug Login Module
		Refine Login Module
		SQ Module
074958J06	Muhammad Hariz Bin Bakri	Design GUI layout
075129K06	Siti Nadiah Binte Zainal (Leader)	Create Work Distribution & Progress
		Research on White & Black Box Testing
		Test Cases for Login Users
		Update Database with Sample Data

WORK PROGRESS

ABDUL MUTALLIB MOHAMMED RAHMAN		CAT	PROGRESS	COMMENTS
1	Added login sql under stored procedure	DB	Completed	Developers logging in to the database can just use TALIBLAPTOP\SQLEXPRESS for the server name instead of using Talib’s IP address.
2	Rename SOItem and SQItem tables to tblSOItem and tblSQItem respectively	DB	Completed
3	Added xLoc and yLoc fields in bigint in table tblItm for x and y coordinates of the location of the item	DB	Completed
4	Added itmName field (varchar(100))to tblItm	DB	Completed
5	Added item name to itmName in tblItm	DB	Completed
6	Research on mouseover using javascript	RES	Completed

AHMAD HAFIZ BIN ISMAIL		CAT	PROGRESS	COMMENTS
1	Testing on Pop-up - Fadebox	RES	Completed
2	Testing on Pop-up - Popbox	RES	Completed
3	Testing on Pop-up - Slide	RES	Completed
4	Wrapping up <div> element for different user	GUI	In Progress

ALBERT CHUA		CAT	PROGRESS	COMMENTS
1	Bugs for customer login	LOG	Completed
2	Parameter btw codes and STP not tallied.	LOG,DB	Completed
3	Stp ‘sttpLogin’ amended	DB	Completed
4	Add checking for scenario that, customer login without identify as customer	DB	Completed	@resultCode of 2 will be returned in this case.
5	Develop 'Generate SQ’ Module	SQ	Developing	Problems with displaying image file

MUHAMMAD HARIZ BIN BAKRI		CAT	PROGRESS	COMMENTS
1	Design GUI layout	GUI	Completed	To start developing the GUI ASAP

SITI NADIAH BINTE ZAINAL		CAT	PROGRESS	COMMENTS
1	Create Work Distribution & Progress Collate members job scope.	MISC	Completed	For 25th and 26th February 2008
2	Research on White & Black Box Testing	RES	Completed
3	Create Test Cases for Login Module	TEST	Completed
4	Update tblUser with sample data	DB	Completed
5	Update tblClient with sample data	DB	Completed

Legend:
DB - Database
MISC - Miscellaneous
GUI - Graphical User Interface
LOG - Login
CFG - Config
PL - Product List
RES - Research
TEST - Testing
SQ - Sales Quotation

CIDP: Work Distribution & Progress Day 1 (25/02/08)

2008-02-26T12:30:00.005+08:00

Date: 25th February 2008
Venue: Database Tech Lab

WORK DISTRIBUTION

Matric No.	Members	Roles
075038G06	Abdul Muttalib Mohammed Rahman	Create Database
075059D06	Ahmad Hafiz Bin Ismail	Familiarising with ASP.NET 2.0
075059D06	Ahmad Hafiz Bin Ismail	Create Master Page (Assist Hariz)
075028D06	Albert Chua	Login Module
074958J06	Muhammad Hariz Bin Bakri	Familiarising with ASP.NET 2.0
074958J06	Muhammad Hariz Bin Bakri	Create Master Page
075129K06	Siti Nadiah Binte Zainal (Leader)	Familiarising with ASP.NET 2.0
075129K06	Siti Nadiah Binte Zainal (Leader)	Create Product List

WORK PROGRESS

ABDUL MUTALLIB MOHAMMED RAHMAN		CAT	PROGRESS	COMMENTS
1	Added relationship between user and usertype	DB	Completed
2	Added relationship between user and client	DB	Completed
3	Added tables POItem, SOItem, SQItem	DB	Completed
4	Changed unitPrice of tblItm from float to monetary value	DB	Completed
5	Created a user defined varchar(500)	DB	Completed
6	Added the user defined varchar(500) to field itmDesc from varchar(200) in table tblItm	DB	Completed
7	Added data obtain from the product list into tblItm table	DB	Completed
8	Changed image names to shorter variables	MISC	Completed
9	Added image pathname to tblItm	DB	Completed

AHMAD HAFIZ BIN ISMAIL		CAT	PROGRESS	COMMENTS
1	Exploring features on Master page	GUI	Completed
2	Exploring features on Login module	RES	Completed
3	Exploring features on WebPart	RES	Completed
4	Discuss on details on Forms	MISC	Completed
5	Brainstorming on company name and logo	MISC	Completed

ALBERT CHUA		CAT	PROGRESS	COMMENTS
1	Login Module	LOG	Debugging	Bugs for customer login
2	Stp ‘stpLogin’ added	DB	Completed
3	Class file ‘ClsCommon’ added. For commonly shared variables and functions.	CFG	Completed
4	Class file ‘ClsConfig’ added. For the configuration value or functions of the application.	CFG	Completed
5	Class file ‘ClsBLL_Login’ added. Functions for logging. Including the data access layer to the database.	LOG, DB	Completed

MUHAMMAD HARIZ BIN BAKRI		CAT	PROGRESS	COMMENTS
1	Create Master page	GUI	Completed
2	Exploring features on Login module	RES	Completed
3	Discuss on details on Forms	MISC	Completed
4	Brainstorming on company name and logo	MISC	Completed

SITI NADIAH BINTE ZAINAL		CAT	PROGRESS	COMMENTS
1	Exploring features on Login module	RES	Completed
2	Brainstorming on company name and logo	MISC	Completed
3	Research images for data entry	RES	Completed
4	Create a product list consisting of - Images - Descriptions - Prices - Links	PL	Completed	Descriptions to be created as a jpg due to char and format constraints. Easily stored in DB. (To be done after web layout is completed.)
5	Summarizes product descriptions	PL	Completed	Short descriptions (Consists of 100 words.)
6	Assist Talib with data entry	DB	Completed	Talib done overall.

Legend:
DB - Database
MISC - Miscellaneous
GUI - Graphical User Interface
LOG - Login
CFG - Config
PL - Product List
RES - Research

Sequence Diagrams

2008-02-24T10:13:00.002+08:00

Client & Account Admin Activities

Sales Admin Activities

Logistic Staff & Logistic Manager Activities

Deliveryman Activities

Class Diagram

2008-02-10T13:00:00.001+08:00

Potential Classes List

2008-01-28T11:29:00.000+08:00

Refined Use-Case Model

2008-01-22T15:04:00.000+08:00

ERP System

Refined User/System Specifications

2008-01-22T11:40:00.000+08:00

Refined User Specification

We are to design an Enterprise Resources Planning (ERP) that links two standalone systems, Sales and Invoicing System and Warehouse Management System for biomedical equipment company called Nameless Private Limited. Both systems are linked through a common database.

Both the Sales and Invoicing System (SIS) and the Warehouse Management System (WMS) require all users to log in. If the logged in user is an existing client, the SIS must be able to generate Sales Quotation (SQ) by the client’s request. It also provides the option for the client to download the SQ in PDF file format. However, if the logged in user is the Sales Admin, he/she can monitor the submitted Purchase Order (PO) through the system. By the Sales Admin’s request the SIS can convert the PO to Sales Order (SO). Once a new invoice is generated, the SIS will update the new invoice detail. If the log-in user is the Logistic Staff, he/she can monitor the submitted Sales Order (SO) through the system. By the Sales Admin’s request the SIS can convert the SO to Delivery Order (DO). The WMS allows the Logistic Staff (LS) to maintain the stock. If the stock is out or low, the LS can request to restock the item. However, if the logged in user is the Logistic Manager, he/she can monitor the stock level. If the Delivery Man logs in, he/she can monitor the invoice status and request the item location. Updating the Delivery status could also be done in the WMS. System Admin is able to access and maintain both systems as well as the user information. Both systems provide user help and system information to all users except for the System Admin.

*A common form would be needed for Purchase Order, Sales Order and Delivery Order. System should be able to keep track of the payment.

Software Specifications

This project is to be completed within 3 to 4 months. Due to time limitation and since developers understood the requirements well we have decided to use the Rapid Application Development (RAD) Model. We are able to use similar product in market for reference. Customer would prefer us to use ASP.NET 2.0, however, is open to options as long as it is web-based and stress on user-friendliness. Therefore, we have decided to use ASP.NET 2.0 and MSSQL 2005 database. Customer does not want us to compile the source code as there would be an IT team from their company which would manage and maintain the system.

Hardware Specifications

Distributed Database Server

Core 2 Duo Processor
4GB 667Mhz Memory
1.5 TB Internal Storage
Web Hosting (IIS)
Windows Server 2003 SP3

For end user, use Internet Explorer (IE) 5.5 or above.

Use-Case Model

2008-01-17T12:33:00.000+08:00

ERP System

Preliminary User/System Specifications

2008-01-15T13:59:00.000+08:00

User Requirement

We are to design an Enterprise Resources Planning (ERP) that links two standalone systems, Sales and Invoicing System and Warehouse Management System for biomedical equipment company called Nameless Private Limited. Both systems are linked through a common database.

The Sales and Invoicing System must be able to generate Sales Quotation which would be converted into a PDF file thus enabling the user to print or email it to the client. The system must also convert the Sales Quotation to Sales Order upon receiving the Purchase Order from the client. Delivery Order and Invoice could be generated and printed out for softcopy.

The Warehouse Management System is able to provide the location of the item stored. It also provides status and updates on incoming and outgoing warehouse items thus checking for the stocks availability.

Software Specifications

This project is to be completed within 3 to 4 months. Due to time limitation and since developers understood the requirements well we have decided to use the Rapid Application Development (RAD) Model. We are able to use similar product in market for reference. Customer would prefer us to use ASP.NET 2.0, however, is open to options as long as it is web-based and stress on user-friendliness. Therefore, we have decided to use ASP.NET 2.0 and MSSQL 2005 database. Customer does not want us to compile the source code as there would be an IT team from their company which would manage and maintain the system.

Hardware Specifications

Distributed Database Server

Core 2 Duo Processor
4GB 667Mhz Memory
1.5 TB Internal Storage
Web Hosting (IIS)
Windows Server 2003 SP3

For end user, use Internet Explorer (IE) 5.5 or above.

Proposed Schedule

2008-01-15T10:45:00.000+08:00

Team Members & Assigned Roles

2008-01-15T09:44:00.000+08:00

From left: Hafiz, Talib, Nadiah, Albert & Hariz.

Task Allocation

Members	Matric No.	Role(s)
Abdul Muttalib Mohammed Rahman	075038G06	Database Developer and PDF file
Ahmad Hafiz Bin Ismail	075059D06	Sales and Invoicing System
Albert Chua	075028D06	Sales and Invoicing System
Muhammad Hariz Bin Bakri	074958J06	Warehouse Management System
Siti Nadiah Binte Zainal (Leader)	075129K06	Warehouse Management System

Distributed on 15th January 2008

Members	Matric No.	Role(s)
Abdul Muttalib Mohammed Rahman	075038G06	Use-Case Model
Ahmad Hafiz Bin Ismail	075059D06	Gantt Chart
Albert Chua	075028D06	Identify Technical Issues
Muhammad Hariz Bin Bakri	074958J06	Website Administrator
Siti Nadiah Binte Zainal (Leader)	075129K06	User Specification and Task Allocation

Distributed on 22nd January 2008