Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

A WEB BASED STOCK CONTROL SYSTEM by cgsgunasekara

VIEWS: 582 PAGES: 131

This Project report provides a practicle solution to an existing problem to material management in organization located dispersed geographically in a large area. This report scrutinizes all aspects of stock controlling system in order to design , implementation and to improve the efficiency to ensure the smooth flow of materials. During problem analysis to implementation phases Prototyping technique and Object oriented methodology has been used integrating with Rational Rose 2000 as a tool. Visual Basic 6 and ASP has been used as implementation language and , for programming the web based components of the system. XML was used to transmit the data from server to client and XSL to transform XML format to HTML and display as required. All the scripts (VB, ASP, XML, XLS, javascripts) used to implement the system are included here.

More Info
									 A WEB BASED STOCK CONTROL
                        SYSTEM
FOR CEYLON ELECTRICITY BOARD




                              By
                      CGS GUNASEKARA.
                    ( INDEX NO : 0039365)
                     ( REG NO : R003936 )
                         SUPERVISORS
                       M L M Maqshood
              Date of submission : 30th September 2003




 This dissertation is submitted in partial fulfillment of the requirement
        Of the Degree of Bachelor of Information Technology(External)
                                  of the
           University of the Colombo School of Computing.




                                1
Declaration

I certify that this dissertation does not incorporate, without acknowledgement , any
material previously submitted for a Degree or diploma in any University and to the
best of my knowledge and belief, it does not contain any material previously
published or written by another person or myself except where due reference is made
in the text. I also hereby give consent for my dissertation, if accepted, to be made
available for photocopying and to inter-library loans, and for the title and summary to
be made available to outside organizations.



Signature of Candidate                        Date:……/…../…..
………………………….
Name of Candidate


Countersigned by:



Signature of supervisor(s)                Date:……./…../……
……………………….
Name of supervisor(s)



Signature of supervisor(s)                Date:……./…../……
……………………….
Name of supervisor(s)




                                          2
Abstract
This Project provides a solution to an existing problem at the CEB Sabaragamuwa
province. At present the stock controlling activities related to main provincial stores
situated at Eheliyagoda and the sub areas located at geographically dispersed areas
are carried out by manually. This project provides a stock control system to manage
all aspects of stock controlling in order to improve the efficiency and to ensure the
smooth flow of materials. The system developed by this project, also provides
facilities to the users who are located at different physical locations (areas) to interact
with the system, over the internet, which makes the system more efficient and cost
effective.


During problem analysis to implementation phases Prototyping technique and Object
oriented methodology has been used integrating with Rational Rose 2000 as a tool..
Visual Basic 6 has been used for implementation as it is an easy to learn user friendly
language with lot of sources and , ASP for programming the web based components
of the system. XML was used to transmit the data from server to client and XSL to
transform XML format to HTML and display as required.




                                            3
Acknowledgements

First of all , I would like to thank Mr. MLM Maqshood for supervising my project
and advising me on related subject matters and also for encouraging and the given
guidance and support through out the BIT course since from the beginning, to
understand difficult subject areas and to make my project a success.


Secondly, I thank Mr. Samaraweera Banda who allowed me to access to the
information from CEB and to gather requirements.


Next, my sincere thanks should go to my BIT colleagues whose comments helped me
a lot to improve my work.
Finally, I would like to thank my wife Wathsala for her encouragement and
invaluable support given to me through out the BIT course.




                                          4
CONTENTS


Chapter 1
      1.1 Introduction                                                 1
      1.2 Problem domain                                               1
      1.3 Motivation of the Project                                    2
      1.4 Aims of the Project                                          3
      1.5 Objectives of the project                                    4
      1.6 Structure of the of the Dissertation in remaining chapters   4
Chapter 2
       2.1 Literature Survey                                           7
Chapter 3 Analysis
        3.1 Introduction                                               11
        3.2 Context Diagram                                            12
        3.3 Data flow Diagram                                          13
        3.4 Identified Actors                                          14
        3.5 Functions carry out by actors                              14
        3.6 Use case diagram                                           15
        3.7 Functional requirements                                    17
        3.8 Non functional requirements                                18
Chapter 4 Design
      4.1 Design methodology                                           20




                                            5
       4.2 Classes identified                     21
       4.3 Class diagram                          22
       4.4 Sequence Diagrams                      23
       4.5 Data base structure                    26


Chapter 5 - User Interfaces
       5.1 User interface design                  29
       5.2 User Interfaces                        30
Chapter 6 - Implementation
       6.1 Implementation Language                40
       6.2 Architecture of the system             41
       6.3 Coding (major modules)                 41
            6.3.1 Visual basic codes         41
            6.3.2 ASP and XML codes               45
Chapter 7- Testing                                49
Chapter 8 Evaluation                              55


Chapter 9 Conclusion                              59
       9.1 Usesability test feed back             59
       9.2 General reflection                     5
								
To top