Online Courier & Cargo System PROJECT REPORT.doc

(1)

dContents

Original Copy of the Approved Proforma………....3

Project Synopsis………..4-40 Guide’s Bio-data………..41-42 Certificate of Originality……….43

Letter from Project Manager……….44

Project Report………..45

Preface………..46

Acknowledgement...47

Candidate’s Declaration………..48

Company Profile………..49-50 Introduction to the Projects About Project………..51

Module Description………52

Project Objective Introduction………...54-56 Project Category………..57-58 Tools & Platform Used………59-60 System Analysis Introduction………..62

Working Process of System ……….……...62-63 Software Requirement Specification………...64

Feasibility Study……….….65-67 H/W & S/W Requirement………....68

Time Schedule……….…69

Reasons for using these tools……….….70-75 System Design Introduction……….….77-79 DFD of the Project………81-83 ER Diagram………..84 Flow Diagram………...85 Database Design………...86-94 Project modules Introduction………...96-104 My module………....105

(2)

Screen shots...106-120 Program Code………....121-147 System Testing Testing Methodology………..149 Black-Box Testing………..…150

White Box Testing………..151

Control Structure Testing………152

Testing

Strategy………...152-153 System

Implementation………...154-157 Limitations of the project………...158

Future Scope of the Project...160

(3)

(4)

(5)

(6)

2. Introduction.

3. Objectives of the Project. 4. Input to the Project.

5. Output of the project. 6. Process logic.

7. Project modules. 8. Table structure.

9. Limitations of the project.

10. Tools/Platforms, Languages to be used. 11. Minimum system requirements.

12. Are you doing this project for any Industry/Client? 13. Security.

(7)

Introduction

About project:

The project “Online Courier & Cargo System” delivery status and notification system is being developed for the need of company running simultaneously courier & cargo service this is specially meant for their frontline user service information. This is one of the best efforts by us to prove that how Internet can be helpful in tire service industry. Where inquiries are always in queue. This system however is a snap shot of the whole scenario for the booming service industry.

(8)

How much more time it will take to reach the place, and whether received it in original state. And many other queries such as the reason of blockage, queries with the user care officers regarding handling etc. there is a user satisfaction guest book where user should put some notes about our service user complaint register.

As the domain in of the system is to a bigger area so the best and convenient way is internet as this is the best way to satisfy the user queries. A website can prove the best interface between the user and the company.

With the advent of the Internet technologies wavered. Every year millions more people around are using internet interact in more ways than ever before to date the find old classmates check of medical elements and cures to react and express and interactive view of the news also gives live sales, HELP Online and maximum hit mostly in the service industries. This is an instance to show that how internet can be the best deal with the fast growing network of optical fiber making micro broadband and economical to access the Internet. Whether in the modern or Information retrieval term. The extract of all these whether the data access retrieval and our goal is placed in a well ordered by using it’s technologies on net. We will not loose our data whether it is user or service provider. So comp is now helpful in many other cases

too:-• Fast retrieval of information around the globe by browsing the net. • Easy access by sitting home to most of the work places.

• Easy database access with the invaluable functions of online entertainment and jobs and placements.

Through this portal we have tried to automate the process of an instance of user care industry service a web based support for a cargo and courier to provide automates service regarding their courier (packets and parcels) delivery status.

(9)

Objectives of the Project

The objective of the project “Online courier delivery status Information & notification system” Is to deal with the queries of manger. How much more time it will take to reach the place, and whether received in original state. Queries among the officers regarding handling etc. User satisfaction guest book where user should put some notes about service and other suggestions. User complaint registers to help us get a better feedback for our failures as a hospitable interface.

The major objectives of this project are as follows:

 Providing an interactive interface for the user query for online status of the packets booked. (Current Status) using the net technology under the framework A.S.P.NET with vb.net. After all interface has a lot to do when proper interaction and attraction is necessary.

(10)

 Helping the user to search his specific booked packet & parcel as where it is? Which intermediate office, when it will move from here, reasons for delay, when it will reach the destination?

 Online updating of packet & parcel status through intermediate and end office regarding truck no, status, reloading of cargo from one truck to another truck etc.

 Providing Secured Environment for secured data access whatever necessary.  Retrieval of data from database using easy buttons links and interfaces in a

very fast and efficient manner.

 On-line updating of all type of data. Updating data using web based interfaces and with the help of buttons & links in an easy & convenient way.

Developing a viable candidate system that fulfills the following requirements  Faster and accurate information retrieval.

 Easy registration.

 Login dependent information updating.

 Correct and consistent maintenance of data and its quick retrieval.  Minimizing the page download time hence less investment.

 Improving the switches button and hyperlink so that the candidate could find all the queries they need at the first sight.

 Maintaining the fast download of the page by using the flavors of cookies.

 Smooth transition and easy access to the pages not requiring much training to the end user.

The overall objective:

System helps to bring the company and its user round the globe more closely to each other so that one should have the perfect services.

(11)

Input to the project

User Information:

 Booking details of Courier & Cargo.  Suggestions and Queries to administrator.

Administrator Information:

 Creation information of all Offices, trucks, Users, routes, route map.  Creation of Network (create country, state, & cities).

(12)

Output of the project

User:

 Status of Courier & Cargo.  Status of Lot.

 Status of Trucks.

Administrator:

 Search the status of Courier & Cargo.

(13)

Process Logic

Online Courier & Cargo System Processes in the following manner:

This website contains information about user function such as Booking the couriers and cargo, Loading the collection of lots in the selected truck or container (in case of cargo), Loading the container(s) in the truck (in case of cargo) etc. as well as administrator function such as Office Registration, Creating User, Viewing suggestions and complaints of user, Adding new Cities, State and Countries, View the Status of Container and Truck etc.

The project Online Courier & Cargo System delivery status and notification system is being developed for the need of company running simultaneously courier & cargo service this is specially meant for their frontline customer service information. This is one of the best efforts by us to prove that how Internet can be helpful in tire service industry.

(14)

At zero and one level the border scenario of the whole portal is considered and at second level an instance of this project is shown. Each break-up has been numbered as per the rule of DFD. Here we attempted to incorporate all the details of the system.

0 Level DFD:

This is the context level DFD of the proposed system. The whole system has been depicted in the way so that the information flow continuity should not be lost in the next level. The purposed system is shown as a whole process and the inputs and outputs are shown with incoming and outgoing arrow from the system.

1

st

_{Level DFD:}

This DFD shows all the processes together with all the data stores (tables). It shows the true data flow i.e. how data is actually flowing in the system. Data is coming from which table and going into which table is clearly shown by this understanding the whole system. The application developer will fall back upon this DFD during the development phase.

(15)

0 Level DFD

Online courier & cargo booking delivery status information &

notification system

Web panel display

Registration display Login Display Status display Delay Office Registration Response display Action display Web Panel Customer query Delay Status Search Staff Login Customer Complaints Process action ProcessResponse Display Success/failure Reg. Information Login Success/failure Display Status Show delay Site Data Upload

Reg. Data User id & pwd Process status search Calculate distance &time

Process query Process Complaint

(16)

(17)

The Company Database Web Panel

Updating

Web panel display Office Reg. Process Office Reg. Reg. Display Check Candidate Staff Login Process user id & pwd Status search Process Search id Process current office Status Delay Process Route Process Distance & time Update reasons Delay Customer query Update new query Response Handler Response display Customer Complaints Update new query Response handler Action Display Data upload Update Check administor User id and pwd Input Booking Id Route Data Updating Updating Query Update Response Response Response update Distance & Date

Delay reasons Status Data Data Check Office status Valid id msg.

LEVEL 1 D.F.D

(18)

E-R Diagram

Administrator Admin_id Password Provide s User User_id passwor_d Creat es

Office Container Routes

Name Addres s Office_i d City_id Office_ bearer Container_i d Container_at Distance Deliver y_statu s Base_c ity_id ty_id Destination _city_id Book ed Courier Cargo Detailes_of _courier Detailes_of_carg o

(19)

Flow Diagram

Project Modules

The proposed website will have its main page and will be mainly divided into partially dependent and partially independent modules

as-Courier Booking User Admin Office Reg. Courier booking lot link Lot Suggestion Loading/unloading truck Route Map Route Detail Truck Route 2 City State Country Container Lot Truck Status Information Other Network Network Transfer Truck Route Source/Destination Loading/unloading container

(20)

2. Registration master

3. Courier & cargo differentiation master 4. Courier status notification marker 5. The page design maker

6. Delivery status notification system for courier 7. Courier booking detail master

8. The site master (control panel) 9. Customer query handler master 10. The validations master

11. The other network courier – handling master 12. Cargo status notification marker

13. Delivery status notification system for cargo 14. Cargo booking detail master

15. The other network cargo- handling master

Table Structure

The normalized form of the table with their structure is describe as

under-Table 1: Login

Field Name Data Type Description Key Constraint

User_id Varchar Userid(unique) Primary key

Office_id Integer Officeid Foreign Key

(21)

-Table 2: Administration login

User_id Varchar Userid(unique) Primary key

Password Varchar Password

-Password Varchar Password

-Table 3: Office registration

Office_id Integer Office id Primary key

Name Varchar Candidate name

-Address1 Varchar Permanent address

-Address2 Varchar Temporary address

-Phone1 Varchar Phone(residence)

-Phone2 Varchar Phone(office)

-Cell Varchar Mobile

-e-mail Varchar e-mail id

-Country_id Integer country to which

belong

Foreign key

State_id Integer State Foreign key

City_id Numeric - Foreign key

Registration date Date Registration date

-Handles Varchar Courier, cargo

-Table 4: courier booked detail

Booked_by_user_id Varchar Office Foreign key

Booking_no Nvarchar Booking no.

unique

Primary key

Booked_item Varchar Item name

-Booked_weight Integer Weight

-Handling_description Varchar About handling the cargo

-Lot_id Integer Container id Foreign key

Booking_date Date

-Receive_date Date Receiving date

-Receive_at Varchar Userid of receiving

office

Foreign key

(22)

-Table 5: lot status

Office_id Integer Booking office id Foreign key

Lot_id Numeric Booking no. unique Primary key

Lot_status Varchar Office_if of office

-Reason_of_stay Varchar Through which

passing

-When_moved Varchar -

-Table 6 Lot detail

Lot_id Numeric Container_id Foreign key

Booking_id Numeric Booking id booked

for special lot

Foreign key

Office_id Varchar Office lot made

-Dispatch_date Date Date of dispatch

Table 7: Route detail

Base_city_id Numeric - Foreign key

Distintion_city_id Numeric - Foreign key

Current_delivery_status Integer Time take

-Average_speed Integer Speed

-Distance Numeric Distance in k.m.

-Table 8: Route map

Base_city_id Numeric City_id Foreign key

Distintion_city_id Numeric City_id Foreign key

Original_ via Integer Cities

-Currently_via Integer Cities

(23)

-Table 9: Loading unloading packet

Office_id Numeric Booking id of lot

unloaded

Foreign key Booking_id_unloaded Numeric New lot made with

that booked packet

Foreign key

Lotid_loaded Numeric From unloaded Foreign key

Lotid_unloaded Numeric - Foreign key

Office_id Numeric - Foreign key

Reason Varchar Unloading reason

-Table 10: Login status master

Login_id Varchar User id Foreign key

Login_time Date/time Login time Foreign key

Logout_time Date/time Logout time Primary key

Table 11: Country services

Country_id Numeric Country_id Foreign key

country Varchar Country

-Table 12: State services

State_id Numeric **Country id Foreign key

Country_id Numeric -

-State Varchar -

-Table 13: City services

State_id Numeric Country id Foreign key

(24)

Table 14: Lot loading unloading

Lot_id Integer - Foreign key

Destroyed_at Integer Office

-New_lot_id Integer Track load Foreign key

reason Varchar -

-Table 15: Country Services

Booking_no Nvarchar Booking Number Foreign key

Customer_name Varchar - -Address Varchar - -Complaint_against Varchar - -Complaint_regarding Varchar - -Complaint_detail Varchar - -Date Datetime - -Action_taken Varchar -

-By Varchar Administrator id Foreign key

Against Varchar Office id Foreign key

Action_details Varchar -

-Date_action Datetime -

-Table 16: Suggestion Register

Booking_id Integer Booking id Foreign key

Suggestion Varchar Suggestion

-To_office_id Integer - Foreign key

Responce Varchar Suggestion

-Date_suggest Datetime -

-Date_responded Datetime -

-Table 17: Other Network Colaboration

Network_id Integer Booking id Foreign key

Company_name Varchar Suggestion

-Company_office Integer - Foreign key

Website Varchar Suggestion

-Customer_care_no Datetime -

-Whether_collaborated Datetime -

-Date_collaboration Date -

(25)

-Table 18: Other Network Courier Transfer

Network_id Integer Boking id Foreign key

Office_id Numeric Suggestion

-Lot_id Numeric Lot

-New_network_lot_id Varchar Courier company transfer

-Date_transfer Date Date booked

-Office_id_received Numeric -

-Date_received Date -

-Table 19 Truck Details

Office_id Integer User id of office Foreign key

Truck_id Numeric - Primary key

Truck_no Varchar -

-Drivers Varchar -

-Truck_status Varchar Office id of office at which staying

-Reason_of_stay Varchar -

-When_moved Datetime -

-Table 20: Container

Container_id Numeric Container id Primary key

Office_bearer Integer Offince id Foreign key

Container_at Integer Office id Foreign key

Table 21: Truck Container Mapping

Truck_id Numeric - Foreign key

Container_id Numeric - Foreign key

Booking_date Date -

-Booked_base_office Varchar Office id Foreign key

Whether_unload_truck Char Yes/No

-Unloading_date Date -

-Whether_unloaded_container Char Yes/No

-Cdate Date Unloaded

container date

(26)

-Field Name Data Type Description Key Constraint

Office_id Varchar - Foreign key

Container_id_unloaded Integer Container id from which cargo

unloaded

Foreign key

Container_id_loaded Integer Container id from which cargo

loaded

-Reason Varchar Unloading reason

-Table 23: Truck Loading Unloading

Truck_id Integer - Foreign key

Unloaded_at Integer Office

-Loaded_to Integer Truck loaded Foreign key

reason varchar -

-Table 24: Other Network Cargo Transfer

Network_id Integer Bookingid Foreign key

Office_id Numeric Suggestion

-Lot_id Numeric Lot

-Net_network_lot_id Varchar Courier company Transferred

-Date_transfer Date Date booked

-Office_id_received Numeric -

-Date_received Date -

-Limitations of the Project

Though this project is very useful and has several advantages over a manual system. Use of this no doubt will result in faster processing and a better service but has some limitations also. These limitations include

(27)

 This application can run on the Web server and SQL server.

 End user cannot directly interact with the dynamic performance of this project.

Tools/Platforms, Languages to be used:

For the undergoing project, following tools are used:

Platform Windows

(28)

Front-End Tool Visual Studio 2005

Scripting Language C#, HTML

Interface HTML, Photoshop, Visual Studio

Server Internet Information Server

Back-End Tool SQL Server 2000

Technology ASP.NET

HARDWARE:

Processor Intel Pentium 2.4 GHZ

Memory 256 M.B., D.D.R. RAM

Network Adapter Ethernet Adapter

Modem 56kpbs Voice Fax Data

Secondary Storage Samsung/Seagate Hard disk (40 G.B)

Reasons for using these tools:

What is ASP.NET

ASP.NET is a programming framework built on the common language runtime that can be used on a server to build powerful Web applications. ASP.NET offers several important advantages over previous Web development models:

•

Enhanced Performance: ASP.NET is compiled common language

runtime code running on the server. Unlike its interpreted predecessors, ASP.NET can take advantage of early binding, just-in-time compilation, native optimization, and caching services right out of the box. This amounts to dramatically better performance before you ever write a line of code.

•

World-Class Tool Support: The ASP.NET framework is complemented

by a rich toolbox and designer in the Visual Studio integrated development environment. WYSIWYG editing, drag-and-drop server controls, and

(29)

automatic deployment are just a few of the features this powerful tool provides.

•

Power and Flexibility: Because ASP.NET is based on the common

language runtime, the power and flexibility of that entire platform is available to Web application developers. The .NET Framework class library, Messaging, and Data Access solutions are all seamlessly accessible from the Web. ASP.NET is also language-independent, so you can choose the language that best applies to your application or partition your application across many languages. Further, common language runtime interoperability guarantees that your existing investment in COM-based development is preserved when migrating to ASP.NET.

•

Simplicity: ASP.NET makes it easy to perform common tasks, from simple

form submission and client authentication to deployment and site configuration. For example, the ASP.NET page framework allows you to build user interfaces that cleanly separate application logic from presentation code and to handle events in a simple, Visual Basic - like forms processing model. Additionally, the common language runtime simplifies development, with managed code services such as automatic reference counting and garbage collection.

•

Manageability: ASP.NET employs a text-based, hierarchical configuration

system, which simplifies applying settings to your server environment and Web applications. Because configuration information is stored as plain text, new settings may be applied without the aid of local administration tools. This "zero local administration" philosophy extends to deploying ASP.NET Framework applications as well. An ASP.NET Framework application is deployed to a server simply by copying the necessary files to the server. No server restart is required, even to deploy or replace running compiled code.

•

Scalability and Availability: ASP.NET has been designed with

scalability in mind, with features specifically tailored to improve performance in clustered and multiprocessor environments. Further, processes are closely monitored and managed by the ASP.NET runtime, so that if one misbehaves (leaks, deadlocks), a new process can be created in its place, which helps keep

(30)

•

Customizability and Extensibility: ASP.NET delivers a well-factored

architecture that allows developers to "plug-in" their code at the appropriate level. In fact, it is possible to extend or replace any subcomponent of the ASP.NET runtime with your own custom-written component. Implementing custom authentication or state services has never been easier.

•

Security: With built in Windows authentication and per-application

configuration, you can be assured that your applications are secure.

What is ASP.NET?

ASP 3.0 is the latest version of ASP, but there will never be an ASP 4.0 version. ASP.NET is the next generation ASP, but it's not an upgraded version of ASP. ASP.NET is an entirely new paradigm for server-side ASP scripting.

ASP.NET is a part of the .NET Framework. Microsoft spent three years rewriting ASP.NET from the ground up, and ASP.NET is not fully backward compatible with ASP 3.0.

.NET Framework

The .NET Framework is the infrastructure for the Microsoft .NET platform.

The .NET Framework is an environment for building, deploying, and running Web applications and Web Services.

The .NET Framework contains a common language runtime and common class libraries - like ADO.NET, ASP.NET and Windows Forms - to provide advanced standard services that can be integrated into a variety of computer systems.

The .NET Framework provides a feature-rich application environment, simplified development and easy integration between a number of different development languages.

The .NET Framework is language neutral. Currently it supports C++, C#, Visual Basic, and JScript (Microsoft's version of JavaScript).

(31)

Microsoft's Visual Studio.NET is a common development environment for the .NET Framework.

New in ASP .NET

 Better language support  Programmable controls  Event-driven programming  XML-based components

 User authentication, with accounts and roles  Higher scalability

 Increased performance - Compiled code  Easier configuration and deployment  Not fully ASP compatible

Microsoft Introduces C#

C# is Microsoft's new programming language for the .NET platform. It combines some of the best features of modern programming languages such as Java, C++ or Visual Basic. C# is an object-oriented language with single inheritance but multiple interfaces per class. It supports component-based programming by properties (smart fields), events and delegates (enhanced function pointers). C# is fully interoperable with other .NET languages such as VB.NET, Eiffel.NET or Oberon.NET.

C# is designed to be a platform-independent language in the tradition of Java. It's syntax is similar to C and C++ syntax, and C# is designed to be an object-oriented language. There are, for the most part, minor variations in syntax between C++ and C#. Main has no return type, there are no semicolons after class names, there are some (to C++ programmers) strange decisions regarding capitalization - such as the capitalisation of Main. Other a few differences, the syntax is often the same. This decision is reasonable, in light of the fact that C syntax has been used with several other languages - notably Java.

(32)

the class is guaranteed to implement. Interfaces avoid the messy dangers of multiple inheritance while maintaining the ability to let several classes implement the same set of methods.

Another helpful feature of C# is garbage collection. Therefore, it is unnecessary to include a destructor for each class unless a class handles unmanaged resources; if so, it's necessary to release control those resources from within the class (The Finalize function is used to clear up these unmanaged resources; it can even be abbreviated with the same syntax as a C++ destructor). Of course, C# also provides direct access to memory through C++ style pointers, but these pointers are not garbage collected until specificially released by the programmer.

C#, as part of the .NET framework, is compiled to Microsoft Intermediate Language (MSIL), which is a language similar to Java's bytecode. MSIL allows C# to be platform independent and runs using just in time compiling. Therefore programs running under .NET gain speed with repeated use.

Furthermore, because the other languages that make up the .NET platform (including VB and COBOL) compile to MSIL, it is possible for classes to be inherited across languages. The MSIL, like bytecode, is what allows C# to be platform independent.

C# Advantages:

• XML documentation generated from source code comments. (This is coming in VB.NET with Whidbey (the code name for the next version of Visual Studio and .NET), and there are tools which will do it with existing VB.NET code already.)

• Operator overloading - again, coming to VB.NET in Whidbey.

• Language support for unsigned types (you can use them from VB.NET, but they aren't in the language itself). Again, support for these is coming to VB.NET in Whidbey.

(33)

• Explicit interface implementation, where an interface which is already implemented in a base class can be reimplemented separately in a derived class. Arguably this makes the class harder to understand, in the same way that member hiding normally does.

• Unsafe code. This allows pointer arithmetic etc, and can improve performance in some situations. However, it is not to be used lightly, as a lot of the normal safety of C# is lost (as the name implies). Note that unsafe code is still

managed code, i.e. it is compiled to IL, JITted, and run within the CLR.

SQL Server 2000

SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE.

In the case of SQL Server, authentication is handled by comparing credentials provided by a connecting user with set of entries stored in the sysxlogin table of the SQL server master database (to get familiar with its content, you might want to use sysloging view, presenting data in a more friendly format). The way these credentials are provided depends on the authentication mode, which can be set to one of the following:

(34)

Minimum System Requirements

Hardware requirement:

 Processor : Pentium IV 2.4 GHZ.  Memory : 256 MB RAM  Hard Disk : 10 GB  Keyboard  Monitor

Software requirement:

The minimum requirement for the application to run is given below:  Front End : ASP.NET C#  Back End : SQL Server 2000  Operating System :

(35)

Are you doing this project for any

Industry/Client?

Yes, this project is developed by Infowave IT Solution at Noida for the marketing courier companies.

My Role: I worked as a trainee cum programmer. My responsibilities included

development of web portal having “Login Master, Registration Master, Courier & Cargo differentiation Master, Courier status notification master” modules which handles the functionality of the web portal. I worked under one senior programmer.

Name & address of the industry

INFOWAVE IT SOLUTION

J 41/42, 1ST_{FLR, SEC-18, NOIDA.} NEAR RADISSON HOTEL. PH: - 9911517542

(36)

Security

Physical Security

The Divisional/Central Security Administrator shall be responsible for the physical security of the system

Their responsibilities shall include

 Maintenance of security of Database Servers by keeping it locked and prohibiting entry of any unauthorized person to prevent thefts and other untoward incidents

 Access to the database server shall be protected by password and only the System Administrator shall be aware of the same.

 Maintenance of multiple power supply connections for uninterrupted power supply.

Database Security

 SQL Server authentication: In this case, SQL Server requires that a user specifies a name and password at the time when connection is attempted. The login name and one-way hash of the password need to match one of entries in the sysxlogin table for the login attempt to be successful.

 Windows authentication: With built in Windows authentication and per-application configuration, you can be assured that your per-applications are secure.

(37)

Scope of Future Application

It is highly likely that the scope will change as the web application moves forward the web process model should be incremental. This allows development team to freeze the scope for one increment so that an operation web application of the preceding increment but once the second increment commence, scope is again frozen temporarily. This approach enables the web application team to work with having to accommodate continual stream of change be still recognized. The continuous evolutions characteristics of most web application. Beside that the following basic quality in the software always safeguards the future scope of the software.

(38)

(39)

(40)

(41)

(42)

Preface

This project “Online Courier & Cargo System” has been developed keeping in mind the heights “Information Technology has reached” and when everything is powered with computers does make a great difference. This website contains information about user function such as Booking the couriers and cargo, Loading the collection of lots in the selected truck or container (in case of cargo), Loading the container(s) in the truck (in case of cargo) etc. as well as administrator function such as Office Registration, Creating User, Viewing suggestions and complaints of user, Adding new Cities, State and Countries, View the Status of Container and Truck etc.

(43)

The project online courier & cargo System delivery status and notification system is being developed for the need of company running simultaneously courier & cargo service this is specially meant for their frontline customer service information. This is one of the best efforts by us to prove that how Internet can be helpful in tire service industry.

This report is written as a text for the partial fulfillment of the BCA program pursuing for INDIRA GANDHI NATIONAL OPEN UNIVERSITY (IGNOU).

Acknowledgement

I would like to take this opportunity to thanks everybody who guided me and

extended possible help for the successful completion of the project “Online Courier & Cargo System”. This work would not have been a reality without the permission of management of Infowave IT Solution, which gave me the opportunity to work in a professional environment.

I am indebted to Mr. Sunil Kumar Sharma, Team Leader, to whom I owe the success of this project, for his whole hearted corporation and guidance, which helped me in overcoming the teething problems of an industrial environment and carrying on the project work smoothly.

(44)

I am thankful to all the members of my team involved in the development of project. I am also indebted to my friends whose moral support always inspired me to come out with the best.

Last but not the least, my project would not have seen the light of the day without the blessings of my parents which was a constant help in the times of need.

ANIRBAN DUTTA BCA VI Semester I.G.N.O.U New Delhi

Candidate’s Declaration

I, Anirban Dutta declare that the work which is being presented by me in this project entitled “Online Courier & Cargo System” in partial fulfillment of the requirement for the Bachelor Of Computer Application by Indira Gandhi National Open university, Delhi is an authentic record of my own work carried out from November to March 2008 under the supervision of Mr. Sunil Kumar Sharma, Team Leader of Infowave IT Solution.

Anirban Dutta BCA VI Semester

(45)

I. G.N.O.U. New Delhi

Company Profile

INFOWAVE IT SOLUTION:

INFOWAVE IT SOLUTION is a company based in New Delhi. The Company’s motto is to develop software products for “Automating Business Operation” and market the same world wide.

It is a software company which focuses on delivering the best and most cost-effective solutions to our clients in areas such as e-shopping, healthcare, and payroll, Income Tax, etc. We provide offshore software development services (“off sourcing”) for companies.

(46)

understand the business of providing offshore and remote services. We have offices in the New Delhi and Pune.

The Company currently have customers in India, US, Hong Kong and Singapore but is looking to expand in other countries too.

Mr. Sandeep, CEO and CTO of the Company believes in “Trust and Quality”. He is Engineer in Electronics and communication from reputed Organization. Prior to starting and company, he was worked with the testing team of leading Software and Telecommunication companies.

WE HAVE BRANCHES AT

DELHI:

D 18, 2ND_{FLR, CENTRAL MARKET,} OPP. METRO SHOES. LAJPAT NAGAR 2. ND-24 PH: - 011-41722331 K2, 1ST_{FLR, CENTRAL MARKET,} LAJPAT NAGAR 2. ND-24 PH:-011-46573287

MOHALI:

S.C. F 26 2ND_{FLR, PHASE 3B-2.} PH: - 0172-3244106, 09356252524

NOIDA:

(47)

J 41/42, 1ST_{FLR, SEC-18, NOIDA.} NEAR RADISSON HOTEL. PH: - 9911517542

(48)

Introduction to the Project

About project:

The project “online courier & cargo System” delivery status and notification system is being developed for the need of company running simultaneously courier & cargo service this is specially meant for their frontline user service information. This is one of the best efforts by us to prove that how Internet can be helpful in tire service industry where inquiries are always in queue. This system however is a snap shot of the whole scenario for the booming service industry.

This basically deals with the queries of user for a company simultaneously running its courier & cargo service where the users have booked some cargo or couriers or both for delivery, can view the status online about where they booked courier or cargo. How much more time it will take to reach the place, and whether received it in original state. And many other queries such as the reason of blockage, queries with the user care officers regarding handling etc. There is a user satisfaction guest book where user should put some notes about our services in user complaint register.

As the domain in of the system is to a bigger area so the best and convenient way is internet as this is the best way to satisfy the user queries. A website can prove the best interface between the user and the company.

With the advent of the Internet technologies wavered. Every year millions more people around are using internet interact in more ways than ever before to date the find old classmates check of medical elements and cures to react and express and interactive view of the news also gives live sales, HELP Online and maximum hit

(49)

the best deal with the fast growing network of optical fiber making micro broadband and economical to access the Internet whether in the modern or Information retrieval term. The extract of all these, whether the data access retrieval and our goal is placed in a well ordered by using it’s technologies on net. We will not loose our data whether it is user or service provider. So comp is now helpful in many other cases

too:-• Fast retrieval of information around the globe by browsing the net. • Easy access by sitting home to most of the work places.

• Easy database access with the invaluable functions of online entertainment and jobs and placements.

Through this portal we have tried to automate the process of an instance of user care industry service a web based support for a cargo and courier to provide automates service regarding their courier (packets and parcels) delivery status.

Modules Description:

The project is based on the online courier & cargo delivery status and notification system. There are total 15 modules:

1. Login master 2. Registration master

3. Courier & cargo differentiation master 4. Courier status notification marker 5. The page design maker

6. Delivery status notification system for courier 7. Courier booking detail master

8. 8’ The site master (control panel) 9. User query handler master 10. The validations master

11. The other network courier – handling master 12. Cargo status notification marker

(50)

(51)

Project Objective

The objective of the project “Online courier delivery status Information & notification system” is to deal with the queries of manger.

• How much time will it take to reach the place, and whether received in original state.

• Queries among the officers regarding handling etc.

• User satisfaction guest book where user should put some notes about service and other suggestions.

• User complaint registers to help us get a better feedback for our failures as a hospitable interface

.

The major objectives of this project are as follows:

 Providing an interactive interface for the user query for online status of the packets booked. (Current Status) using the net technology under the framework A.S.P.NET with C#. After all interface has a lot to do when proper interaction and attraction is necessary.

 Helping the user to search his specific booked packet & parcel as where it is? Which intermediate office, when it will move from here, reasons for delay, when it will reach the destination?

 Online updating of packet & parcel status through intermediate and end office regarding truck no., status, reloading of cargo from one truck to another truck etc.

 Providing Secured Environment for secured data access whatever necessary.  Retrieval of data from database using easy buttons links and interfaces in a

very fast and efficient manner.

 On-line updating of all type of data. Updating data using web based interfaces and with the help of buttons & links in an easy & convenient way.

(52)

 Faster and accurate information retrieval.  Easy registration.

 Login dependent information updating.

 Correct and consistent maintenance of data and its quick retrieval.  Minimizing the page download time hence less investment.

 Improving the switches button and hyperlink so that the candidate could find all the queries they need at the first sight.

 Maintaining the fast download of the page by using the flavors of cookies.

 Smooth transition and easy access to the pages not requiring much training to the end user.

The overall objective:

System to bring the company and its users round the globe more closely to each other so that one should have the perfect services.

(53)

Project Category

The undergoing project falls under internet technologies and RDBMS (Relational Database Management System) category. Since the project is mainly responsible for the creation of the portal with the online database at backend. As we know that, the internet is huge client server architecture. The client is the web browser; it is requesting a web based data, a file, or whatever, from some computer somewhere – anywhere – in the world. The server is a computer that holds the information you want.

ASP.NET is the rich programming framework for building web based applications. It offers outstanding support for both developers and administrators providing improved ease-of-used, tools support, reliability scalability, administration and security how it works?

ASP.NET is a programming framework build on the common language run time that can be used on the sever to built powerful web applications. ASP.NET offers several important advantages over previous web development modules.

We know that database is a respiratory for stored operational data. Database environment and common data are available and used by several users. Instead of each program or user to manage it’s own data. The data across applications are shared by all authorized users with help of database software managing the data as an entity.

The general concept behind the database is to handle information as an integrated whole. A database is a collection of inter related data stored with the minimum redundancy to serve many users quickly and effectively. The general objective is to make information easy quick expressive and flexible for the user. In database design specific objectives are considered.

• Ease of learning and use • More information at low cost

(54)

• Performance

In this way SQL Server 2000 is one of the leading RDBMS in the world. It is characterized by the quick retrieval of information from huge tables. The quality allows it to cater to the ever changing business needs of the present age. It supports 4th_{generation language, SQL there by making it easier for the} user to grasp it, a development language where complicated procedures, functions etc can be used.

(55)

TOOLS / PLATFORM USED

(56)

Operating System Windows XP professional with SP-2

Framework ASP.Net FRAMEWORK 2.0

Front-End Tool Visual Studio 2005

Scripting Language C#, HTML

Interface HTML, Photoshop, Visual Studio

Server Internet Information Server

Back-End Tool SQL Server 2000

Technology ASP.NET

HARDWARE:

Processor Intel Pentium 2.4 GHZ

Memory 256 M.B., D.D.R. RAM

Network Adapter Ethernet Adapter

Modem 56kpbs Voice Fax Data

(57)

System Analysis

System analysis is the first step towards the software building process. The purpose of system analysis is to understand the system requirements, identify the data, functional and behavioral requirements and building the models of the system for better

understanding of the system.

(58)

current problems and desired information (input and output to the system). The analyst looks towards one or more solutions. To begin with the data objects,

processing, functions and behavior of the system are defined in details. After this, a module forms three different aspects of the system data, function and behavior. The module created during the system analysis process helps in better understanding of data and control flow, functional processing, operational behavioral and information content.

Working Process of the System:

The system contains the following main processes:

The system contains many simultaneous processes. We have optimized the processes to make the whole system working as a one. This system has developed in a way to provide a single dynamic interface for all the processes. User logins into the user page of the site and can book, search, make queries, submit complaints and suggestions. The status of the particular booking can be searched by entering the Booking No or Concern Lot No in which booking is sent. He can also search for the particular Cargo Carrier may it be container or truck by their corresponding unique numbers which are carrying the particular item with the enquired Booking no.

The system needs updating at different stages and from different offices including end offices of the company regarding couriers and cargo so a user dependent candidate validation and information updating system is necessary and is included in the user login area apart from the administration area who have all the right of users including additional rights of creating new entitles or users as per the requirement of the company.

The User Creation and Login:

User Login:

Each end office is provide with the User Id through which they can upload the information regarding the packet details, cargo details and status as the system is user dependent (only for updating) so proper user Id and password based user system is

(59)

provided to accomplish the fact whether and however the system is to maintain the user status and specific user enable service for security and privacy reasons.

• Based on the login , User is provided with a control panel

• Only administrator has right to create User Id and Password and distribute them to the concern managers.

• Administrator can any time change the User Id and Password of the User/Manager for security reasons as the User navigation area of the portal is strictly private for the company.

Office Registration:

Office registration is attached with the master mode of the service and can be done by the administrator only.

• Office registration form asks for Name, address and other information the branch office of the company.

• Office registration is important, as based on the registered existing office the users and other entities of the companies like Cargo Carrier etc are linked. Status Enquiry of Cargo and Courier:

User uploads the information of each booked courier and cargo before dispatching from his office which generates the unique booking no, by which courier or cargo can be traced by any user over the network through the portal. Couriers are sent in lots and Cargo through containers and containers through truck. The status of the dispatched Courier can be searched

by:-• Tuck No • Container No • Lot No • Booking No

Each search will provide the status along with the rest 3 corresponding entities information. This makes the search very convenient for the user. The results of the search are dynamic and changes as per adding lot, loading containers with lots and loading the truck with container or lots and finally unloading the truck.

(60)

Submitting the Complaints and Suggestions:

The user can submit the complaints and suggestions from his login. These suggestions and complaints can be viewed by administrator and thus acted upon.

Software Requirement Specification:

The SRS (Software Requirement Specification) is very important art of the software building process, which describes the actual user level requirement from technical point of view i.e. what the user exactly wants? The objective of preparing the SRS is to represent the requirements of the software in such a manner that

ultimately leads to successful software implementation. It is the result of the analysis process of the software development. It should contain all the data, the software is going to process, the function it will provide the behavior it will exhibit. SRS is defined in IEEE standard. IEEE recommended practice for SRS.

Feasibility study

Feasibility study is the determination whether or not a project is worth doing. The process followed in making this is called feasibility study. When the developer is building any system, he/she should make sure that the system he/she is going to build is feasible.

Since the feasibility study may lead to commitment of large resources, it becomes necessary that it should be conducted competently and that no fundamental errors of judgment are made.

Preliminary investigation examines project feasibility; the likelihood the system will be useful to the organization. Three important test of feasibility are described below.

(61)

• Technical feasibility • Operational feasibility • Economical feasibility

In feasibility study, we check the durability, reliability, operability, compatibility etc. of the system. A feasibility study is a preliminary study undertaken to determine and document a project's viability. The results of this study are used to make a decision whether to proceed with the project, or table it. If it indeed leads to a project being approved, it will - before the real work of the proposed project starts - be used to ascertain the likelihood of the project's success. It is an analysis of possible alternative solutions to a problem and a recommendation on the best alternative. It, for example, can decide whether an order processing be carried out by a new system more efficiently than the previous one.

Economical feasibility study:

This involves questions such as whether the firm can afford to build the system, whether its benefits should substantially exceed its costs, and whether the project has higher priority and profits than other projects that might use the same resources. This also includes whether the project is in the condition to fulfill all the eligibility criteria and the responsibility of both sides in case there are two parties involved in

performing any project.

In this study, we analysis the cost of different parts related with software. It may be either manpower cost or cost of hardware or software.

(62)

Here the manpower cost is reduced as the work can now be done by lesser number of powers. If work is done by greater number of manpower, the cost will increase, so manpower should be low.

In this project there are six peoples. And one is team leader.

 Hardware and Software cost:

Hardware and Software cost will be added in the total cost, because whole project is designed and developed at the administrator site.

 Justification:

Justification for any capital outlay is that it will increase profit, reduce expenditure, or improve quality of a service which in turn may be expected to provide profits proposed or developing system must be justified by cost and benefit criteria to ensure that effort is concentrated on projects which wil give the best return at the earliest opportunities.

The technique of cost benefit analysis is often used as a basis for assessing Economis Feasibility. The factors for evaluation are:

 Cost of operation of the existing and proposed system.  Cost of development of the proposed system.

 Value of the proposed system.

Economic Feasibility Study plays a very important role in a development of software.

(63)

This involves questions such as whether the technology needed for the system exists, how difficult it will be to build, and whether the firm has enough experience using that technology. The assessment is based on an outline design of system requirements in terms of Input, Output, Fields, Programs, and Procedures. This can be qualified in terms of volumes of data, trends, frequency of updating, etc. In order to give an introduction to the technical system.

Technical Feasibility is concerned with the availability and capability of hardware, software and people.In Technical Feasibility Study we studied on those facts that are covering the whole technological facts such as:

 Hardware requirement specification  Software requirement specification  Technology used

What software technology should be opted so as to develop the project efficiently.

Hardware requirement:

A computer should be available that is powerful enough to handle the proposed system. DBMS systems usually consume more computer power because of its data structure, security, rule and index pointers to the records. These take more machines processing time. Now almost any system is technically feasible.

The minimum requirement for the application to run is given below:  Processor : Pentium IV 2.4 GHZ.

 Memory : 256 MB RAM  Hard Disk : 10 GB

 Keyboard

(64)

According to convenience of the system, the system developer should decide which computer languages or software he/she is going to use for the proposed project. The developer should keep in mind that the software or languages he/she is going to use should be easily available, efficient, portable and the database languages which he uses, should be preferably Relational Database Language (RDBMS). In case of software the languages used to build the system are very popular languages namely ASP.Net with C#.

The minimum requirement for the application to run is given below:  Front End : ASP.NET C#  Back End : SQL Server 2000  Operating System : WINDOW XP, WINDOW 2000

Since, in the request clarification, it was found that the main need was for better response on the throughput from the system. The assessment of technical feasibility must be based on an out line design of system requirements in terms of inputs, outputs, files, programs, procedures and staff. This evaluation determines whether the technology needed for proposed system is available or not and how it can be integrated with the organization.

Time Schedule:

The cumulative distribution of time for the various phases of the lifecycle (inclusive of all the increments) was done by the Project Leader, as depicted in the table below:

Phase Time

(65)

Design 4 weeks

Coding 8 weeks

Testing 5 weeks

Table: Distribution of Time amongst Lifecycle Phases

Reasons for using these tools:

What is ASP.NET

ASP.NET is a programming framework built on the common language runtime that can be used on a server to build powerful Web applications. ASP.NET offers several important advantages over previous Web development models:

•

Enhanced Performance: ASP.NET is compiled common language

runtime code running on the server. Unlike its interpreted predecessors, ASP.NET can take advantage of early binding, just-in-time compilation, native optimization, and caching services right out of the box. This amounts to dramatically better performance before you ever write a line of code.

•

World-Class Tool Support: The ASP.NET framework is complemented

by a rich toolbox and designer in the Visual Studio integrated development environment. WYSIWYG editing, drag-and-drop server controls, and automatic deployment are just a few of the features this powerful tool

(66)

•

Power and Flexibility: Because ASP.NET is based on the common

language runtime, the power and flexibility of that entire platform is available to Web application developers. The .NET Framework class library, Messaging, and Data Access solutions are all seamlessly accessible from the Web. ASP.NET is also language-independent, so you can choose the language that best applies to your application or partition your application across many languages. Further, common language runtime interoperability guarantees that your existing investment in COM-based development is preserved when migrating to ASP.NET.

•

Simplicity: ASP.NET makes it easy to perform common tasks, from simple

form submission and client authentication to deployment and site configuration. For example, the ASP.NET page framework allows you to build user interfaces that cleanly separate application logic from presentation code and to handle events in a simple, Visual Basic - like forms processing model. Additionally, the common language runtime simplifies development, with managed code services such as automatic reference counting and garbage collection.

•

Manageability: ASP.NET employs a text-based, hierarchical configuration

system, which simplifies applying settings to your server environment and Web applications. Because configuration information is stored as plain text, new settings may be applied without the aid of local administration tools. This "zero local administration" philosophy extends to deploying ASP.NET Framework applications as well. An ASP.NET Framework application is deployed to a server simply by copying the necessary files to the server. No server restart is required, even to deploy or replace running compiled code.

•

Scalability and Availability: ASP.NET has been designed with

scalability in mind, with features specifically tailored to improve performance in clustered and multiprocessor environments. Further, processes are closely monitored and managed by the ASP.NET runtime, so that if one misbehaves (leaks, deadlocks), a new process can be created in its place, which helps keep your application constantly available to handle requests.

•

Customizability and Extensibility: ASP.NET delivers a well-factored

(67)

level. In fact, it is possible to extend or replace any subcomponent of the ASP.NET runtime with your own custom-written component. Implementing custom authentication or state services has never been easier.

•

Security: With built in Windows authentication and per-application

configuration, you can be assured that your applications are secure.

What is ASP.NET?

ASP 3.0 is the latest version of ASP, but there will never be an ASP 4.0 version. ASP.NET is the next generation ASP, but it's not an upgraded version of ASP. ASP.NET is an entirely new paradigm for server-side ASP scripting.

ASP.NET is a part of the .NET Framework. Microsoft spent three years rewriting ASP.NET from the ground up, and ASP.NET is not fully backward compatible with ASP 3.0.

.NET Framework

The .NET Framework is the infrastructure for the Microsoft .NET platform.

The .NET Framework is an environment for building, deploying, and running Web applications and Web Services.

The .NET Framework contains a common language runtime and common class libraries - like ADO.NET, ASP.NET and Windows Forms - to provide advanced standard services that can be integrated into a variety of computer systems.

The .NET Framework provides a feature-rich application environment, simplified development and easy integration between a numbers of different development languages.

(68)

Microsoft's Visual Studio.NET is a common development environment for the .NET Framework.

New in ASP .NET

 Better language support  Programmable controls  Event-driven programming  XML-based components

 User authentication, with accounts and roles  Higher scalability

 Increased performance - Compiled code  Easier configuration and deployment  Not fully ASP compatible

Microsoft Introduces C#

C# is Microsoft's new programming language for the .NET platform. It combines some of the best features of modern programming languages such as Java, C++ or Visual Basic. C# is an object-oriented language with single inheritance but multiple interfaces per class. It supports component-based programming by properties (smart fields), events and delegates (enhanced function pointers). C# is fully interoperable with other .NET languages such as VB.NET, Eiffel.NET or Oberon.NET.

C# is designed to be a platform-independent language in the tradition of Java. It's syntax is similar to C and C++ syntax, and C# is designed to be an object-oriented language. There are, for the most part, minor variations in syntax between C++ and C#. Main has no return type, there are no semicolons after class names, there are some (to C++ programmers) strange decisions regarding capitalization - such as the capitalization of Main. Other a few differences, the syntax is often the same. This decision is reasonable, in light of the fact that C syntax has been used with several other languages - notably Java.

(69)

the class is guaranteed to implement. Interfaces avoid the messy dangers of multiple inheritance while maintaining the ability to let several classes implement the same set of methods.

Another helpful feature of C# is garbage collection. Therefore, it is unnecessary to include a destructor for each class unless a class handles unmanaged resources; if so, it's necessary to release control those resources from within the class (The Finalize function is used to clear up these unmanaged resources; it can even be abbreviated with the same syntax as a C++ destructor). Of course, C# also provides direct access to memory through C++ style pointers, but these pointers are not garbage collected until specifically released by the programmer.

C#, as part of the .NET framework, is compiled to Microsoft Intermediate Language (MSIL), which is a language similar to Java's byte code. MSIL allows C# to be platform independent and runs using just in time compiling. Therefore programs running under .NET gain speed with repeated use.

Furthermore, because the other languages that make up the .NET platform (including VB and COBOL) compile to MSIL, it is possible for classes to be inherited across languages. The MSIL, like byte code, is what allows C# to be platform independent.

C# Advantages:

• XML documentation generated from source code comments. (This is coming in VB.NET with Whidbey (the code name for the next version of Visual Studio and .NET), and there are tools which will do it with existing VB.NET code already.)

• Operator overloading - again, coming to VB.NET in Whidbey.

• Language support for unsigned types (you can use them from VB.NET, but they aren't in the language itself). Again, support for these is coming to VB.NET in Whidbey.