1online courier management

INTRODUCTION

The project “Online Courier Management 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 having booked some cargo or couriers or both for delivery

can view the status online about where there 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 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:-

1

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.

1

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 C# .net. 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.

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.

1

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.

1

PROJECT CATEGORY

The software which is being developed comes under both OOPS and RDBMS category. The proposed project based on C Sharp .NET as a front end and SQL Server as a back end. While taking C#.Net it gives the strong support of Object Oriented Programming System technology. On the other hand SQL Server gives the database consistency, reliability and strong RDBMS supports.

Object Oriented Programming is a programming paradigm in its own right and on the other hand, it is a set of software engineering tools which can be used to build more reliable and reusable systems. At present, Object Oriented Programming is emerging from research laboratories and invading the field of industrial applications.

Object Oriented Programming is at the core of C# .NET. In fact, all .NET programs are to at least some extent object oriented. Object Oriented Programming is so integral to .NET that it is best to understand its basic principles before we begin writing even simple .NET Program. Just about everything we do in .NET involves objects in some way-even simple variables are base on the C Sharp object class. And all our code hast to appear in a class of some sort, even if we are using a module or structure, which are also types of classes now, All object oriented programming languages provide mechanisms that help us to implement the object-oriented model. It consists following supports:

Abstraction- The ability to create an abstract representation of a concept in code. The technique of creating new data types that are well suited to an application to be programmed is known as data abstraction. It provides ability to create user-defined data types, for modeling a real world object, having the properties of built in data types and a set of permitted operators.

Encapsulation- Encapsulation is all about the separation between implementation and interface. In other words, when you encapsulate and object, you make its code and data internal and no longer accessible to the outside except through a well-defined interface. This is also called data hiding.

Polymorphism- This is all about creating procedure that can operate on object of different types. C Sharp .NET handles polymorphism with both late binding and multiple interfaces.

Inheritance- Inheritance allows us to derive new classes from other classes. The idea here is that if we were to create, for example, a class for a specific c sharp form and then derive a new type of form from that class, thee derived class will inherit all the base class’s functionality, even before we start adding code or customizing the new form.

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:

1

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 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 your application constantly available to handle requests.

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.

C#

1

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.

Similar to Java, C# does not support multiple inheritance; instead it provides Java's solution: interfaces. Interfaces implemented by a class specify certain functions that 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. The using statement, which makes unmanaged resource disposal simple. 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

1

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 provides a suite of tools for managing all aspects of SQL Server development, querying, tuning, and administration. While designing a database, the database administrator creates database objects such as tables, columns, keys, indices, relationships, constraints, and views. To help create these objects, the SQL Server Management Studio provides access to visual database tools. These tools provide three mechanisms to aid in database design: the Database Designer, the Table Designer, and the view designer

The integrated Query Editor provides a simple graphical user interface for running SQL queries and viewing the results. The Query Editor also provides a graphical representation of show plan, the steps chosen by the optimizer for query execution.

SQL Server supports the hosting of the .NET Common Language Runtime (CLR) inside the SQL Server process to enable database programmers to write business logic as functions, stored procedures, triggers, data types, and aggregates. The ability to run

Application code inside the database adds flexibility to the design of application architectures that requires business logic to execute close to the data and cannot afford the cost of shipping data to middle-tier process to perform computation outside the database. Application code is deployed inside the database by using assemblies, which are the units of packaging, deployment, and versioning of application code in .NET. Deployment of application code inside the database provides uniform way to administer, Back up, and restore complete database applications.

1

TOOLS/PLATFORM

For the undergoing project, following tools are used:

Platform Windows

Operating System Windows XP professional with Service

Pack 3

Framework .Net FRAMEWORK 3.5

Front-End Tool Visual Studio 2008

Scripting Language C#, HTML

Interface HTML, Visual Studio

Server Internet Information Server

Back-End Tool SQL Server 2005

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)

1

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 :

WINDOW XP with SP2, WINDOW 2000

1

SYSTEM DESIGN

System design phase starts after the software requirements have been analyzed and specified.

System design is the first of the three technical activities: Design, code and test that is

required to build and verify the software.

A design methodology is a systematic approach to create a design by application of a set

techniques and guidelines. Some desirable properties for a software system design are as

follows:

Verifiability

Completeness

Consistency

Efficiency

Traceability

Simplicity/Understandability

The system design considerations are:

The design objective that include practicality, efficiency, security etc.

The constraints, which include the hardware, software, budget, time, scale and

the interface with all other systems.

The processing techniques, which include batch processing, real time

processing and on-line processing.

There are three methodologies for designing which are as follows:

(I) Top – down:

The top – down approach starts from the highest-level component of the hierarchy and

proceeds through to lower levels. It starts by identifying the major components of the

system, decomposing them into lower level components and iterating until desired level of

details is achieved.

1

This approach of designing the system might be best if the designer has detail idea

about the whole “Courier Management System” project to be developed. In this

methodology designer start with a front or top form, often called MAIN PAGE, for the

project and work branching off from there.

The advantage of the top-down approach is that form can be changed to affect the look and

feel of the whole project because all forms are designed according to the top form look and

feel.

(II) Bottom-up:

A bottom-up approach starts from the lowest level of component hierarchy and proceeds

through progressively higher levels to top levels components. This design approach starts

with designing the most basic or primitive components and proceed to higher-level

components that use this lower level components.

This approach is adopted when the designer hasn’t a good idea about the layout of final

project, but know how specific forms look and work. It might be that working from these

specific forms to the top forms is the way to proceed. This is particularly true if there are,

already, existing forms as a result of development of some other project made by some one

having the same concept.

If there are no forms from which the designer has to start, then he can begin by designing

leave forms that accomplish specific objectives and then linking them together through

intermediate forms to the top forms. The advantage of this design is that the designer is not

constrained by the style of top forms in the leaf form.

(III) Incremental/In times:

Similar in ways to both the top-down and bottom-up approaches, the Incremental/ In

time approach develops forms "just in time" when they are needed. It may be the case

that an initial top form is needed and specific leaf forms that implement particular objectives.

These are created and linked together with understanding that later, intermediate forms

may be needed. This works well if the client wants very quickly have a working

project that will grow incrementally, rather than being developed all at once.

The “Courier Management System” Project has been designed by following the down

approach as well as Incremental/In time approach. Design step produces a data design, an

architectural design and a procedural design. In the data design phase information

1

domain model created during analysis phase is transformed into the data structure. In

the architectural design the relationship among major structural components of the

“Courier Management System” Project are defined. In the procedural design major

structural components transformed into a procedural description of the software.

1

ANALYSIS

DFD of the Project

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.

1st 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.

1

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

Process Response

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

1

The Company Database

Web Panel

Updating

Web panel displayOffice Reg.

Process Office Reg.

Reg. DisplayCheck Candidate

Staff Login

Process user id & pwdStatus 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

UpdateCheck administor

User id and pwd

Input Booking Id

Route Data

Updating

UpdatingQuery Update

Response

Response

Response update

Distance & Date

Delay reasons

Status Data

Data

Check Office status

Valid id msg.

1

LEVEL 1 D.F.D

E-R Diagram

Administrator

Admin_id Password

User

User_idPassword

Creates

Office Container Routes

Name Address

Office_id

City_id

Office_bearer

Container_id

Container_at

Distance

Delivery_status

Base_city_idty_id

Destination_city_id

Booked

Courier Cargo

Details_of_courier

Detailes_of_cargo

1

Flow Diagram

Courier Booking

User

Admin

Office Reg.

Courier booking lot link

Lot

Suggestion

Loading/unloading truck

Route MapRoute Detail

Truck Route 2

City

State

Country

Container Lot

Truck

Status Information

Other Network

Network Transfer

Truck Route

Source/Destination

Loading/unloadingContainer

1

COMPLETE STRUCTURE OF THE PROGRAM

Project Modules

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

dependent and partially independent modules as-

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. 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

These modules with their sub modules are describe below-

1

1. LOGIN MASTER:

Login master is the specific module, which only has to deal with the updating of the

database. Two types of user can login administrator and the employee. It checks for a

valid candidate when the user enters his user id password and link to the correct page

and link to the registration page. It is divided into following functions.

(a)USER ID CHECKER:

As user id rules the system for updating (control panel). So his uniqueness and type of

his user id know a person whether he is master or one of the employee. As it is to

provide the viable candidate system, so the user id is being validated with password in

different cases to validate the genuinely of the candidate.

(b)THE LOGIN STATUS MASTER:

This module keeps the status of who and when logged in and for which purpose and

for how much time.

2. REGISTRATION MASTER:

As this module is only accessible through administrator password. So this has not

much to do directly.

This modules deal with the different state of registration as-

a. Registration form display

b. Client’s does validation being handles by validation master

c. Unique user id checker (checks that the user id being entered by the

candidate is unique or no)

d. Auto user id generator (user id field by taking the email id of the user if it is

unique or suggest by combining it will some number).

1

3. COURIER AND CARGO DIFFERENTIATION MASTER:

This module checks the booking id as of courier and cargo, and act according with

that. This module differentiates the data as well as process the credential regarding to

that, this module handles to and from data from the intermediate process.

4. COURIER STATUS NOTIFICATION MASTER:

This module handles the query of customer and displays the result according to that

customer is asked to enter the booked id in the specified input area.

On the basis of input the detail regarding where material exactly is shown.

This module contains the following sub modules-

(a)QUERY HANDLER:

This module handles to and from the courier and cargo differentiation master searches

the data in the database, which through different conversion through numbers of

tables shows the result regarding where exactly the cargo is.

The booking id is first searched into the courier booked table. Each booking id has a

unique number associated with the different offices and also with the courier.

On the basis of that booking id, matched with the lot id, and then with the medium and after

that medium halted at which station. These statuses are shown.

5. THE PAGE DESIGN MASTER:

This module is specially meant for auto style sheet generator by using XML. The

document object modeling basically deals with the development of a common model

for display to have a better interface and look. DTD (the document type declaration)

helps the generated page to be validated with tile DTD object and file inserted into, so

that tile generated should follow the rules and regulation defined in the document type

declaration.

Simply one is validating the page so that strict entry should be made to avoid any

failure and redundancy in the database.

The style sheet generation through XSL has lot to do and much work is their when

you defined and generalize an instances of the tag defined to display in a common

attractive and impulsive format.

1

Here in some pages CSS is being used and for some common XSL will be used for

the generation of fully formatted and fully validated web pages.

6. DELIVERY STATUS NOTIFICATION SYSTEM FOR COURIER:

This module deals with the delivery status whether the following courier has been

delivered to the destination or not, how much time it will take to reach the destination.

It has following sub modules-

(a)DISTANCE CALCULATOR:

It takes the data from the route table that specifies distance between the current city

(the city through which tile courier is passing and the destination).

(b)TIME CALCULATOR:

An average time is calculated on the basis of the average time taken to reach the two

adjoining city subsequently to the destination.

(c) DELEVERED STATUS:

It checks the current status if the current status of the courier gives the destination

address and after taking the received detail. It display whether the courier is on its

way or delivered successfully.

7. THE SITE MASTER:

The site maintenance master is the main and the biggest module handling the

updating of all type of information regarding the courier & cargo system. It can only

be accessed through user id and password, as it deals with the work related the date

necessary to keep the site working.

A menu is displayed asking for to update the instance of the site a user wants, as the

size of the module directly depend upon the table design and updating. A special

control panel is design to use for uploading of data in different table. This is done

through a site master account and the employee account.

It includes the following sub modules-

(a)COUNTRY SERVICE ENTRY:

i) Country in which true courier & cargo service is

available(only administrator)

1

ii) Other network collaboration for cargo

iii) Other network collaboration for courier

iv) Other network services country

(b)STATE ENTRY:

The state in which the courier service is available (only administrator)

(c) CITY ENTRY:

The city in which the service is available (only administrator).

(d)OFFICE ENTRY:

Offices, their address and other credentials (only administrator).

(e) ROUTE MASTER:

Distance and time taken between each city, shortest route between two destinations

(only administrator) and other entries to keep the site working.

8. BOOKING DETAILS FOR COURIER :

Courier booked, source office, destination office, lot, container, truck details, date

dispatched etc regarding booking of new courier with a unique id.


(a)COURIER STATUS :

This specially deals with the updating at intermediate office about the truck number

that passed through office.

(b)LOADING UNLOADING DETAILE :

This deals with the loading and unloading courier from one truck to another truck or

one container to another container and other entries to keep the site working.

9. BOOKING DETAILS FOR CARGO :

Cargo booked, source office, destination office, container, truck detail, date

dispatched etc regarding booking of new courier with a unique id.

1


(a)CARGO STATUS :

This specially deals with the updating at intermediate office about the truck number

that passed through office.

(b)LOADING UNLOADING DETAILE :

This deals with the loading and unloading cargo from one truck to another truck or

one container to another container and other entries to keep the site working.

10. CUSTOMER QUERY HANDLER MASTER :

This module specially deals with the handling of query of the customer. This module

has following sub modules –

(a)CUSTOMER QUERY HANDLING :

This module generates a input form through which customer can directly interact with

tile intermediate office where there courier & cargo is! Through different function and

tables.

(b)CUSTOMER COMPLAINT REGISTER :

Customer can directly enter the complaint regarding end office, and the response is

sending through the head office. This complaint is only viewable through

administrator account.

11. THE VALIDATION MASTER :

This basically deals with the validation of different entries done during form building

process. This module specially uses the client side validation scripting from java

script and server side scripting from vb.net to make the system robust reliable and

error free. This module as specially integrated with the different page and forms

checks all the discrepancies such as incorrect email, date of birth, address, etc to

finally deal with the any wrong entries being done by the user . it validates as well Is

suggests for correct input.

1

This module has the different sub modules depending upon the above modules find

forms.

i. CARGO UPDATE VALIDATION MASTER :

Deal with the validation regarding the updating of product.

ii. REGISTRATION VALIDATION MASTER :

Deals with the discrepancies in registration process etc.

iii. COURIER UPDATE VALIDATION MASTER :

Deals with the validation regarding the updating of courier and its status.

12. THE OTHER NETWORK COURIER HANDLING MASTER :

This module deals specifically with the handling of packet to other network for future

delivery and their status mapping with their server to our server.

This part of module simply tries to correct to their server automatically to retrieve the

details with the no being mapped with the original booking id, this helps the customer

to remember only one booking id but track the status of the courier while it travels

through other network to.

13. CARGO STATUS NOTIFICATION MARKER :

This module handles the query of customer and display the result according to that

customer is asked to enter the booked id in the specified input area. On the basis of

input the detail regarding where there material exactly is shown.

This modules contains the following sub modules-

(a)QUERY HANDLER :

This module handles the query of the customer searches the data in the database,

through number of tables shows the result regarding where exactly the cargo is.

The booking id is first searched in to the cargo booked table. Each booking id has

unique number associated with the different offices and also with the cargo. On

1

the basis that booking id, matched with the container, and then with the truck, and

after that true halted at which station. The status is shown.

14. DELIVERY STATUS NOTIFICATION SYSTEM FOR CARGO:

This system deals with the delivery status whether the following cargo has been

delivered to the destination or not or how much time it will take to reach the

destination.

It has following sub modules-

(a)DISTANCE CALCULATOR:

It takes the data from the route table that specifies distance between the

places then calculates the distance between the current cargo (the city through

which the cargo is passing and the destination).

(b)TIME CALCULATOR:

An average time is calculated on the basis of the average time taken to

reach the two adjoining city subsequently to the destination average truck halt

time and a time in day returned.

(c) DELEVERED STATUS:

It checks the current status if the current status of the cargo gives the

destination address and after taking the received detail. It displays whether the

cargo is delivered successfully or not.

15. THE OTHER NETWORK CARGO HANDLING MASTER :

This modules deal specifically with the handling of cargo or container to other

network for future delivery and their status mapping with their server to our server.

This part of module simply tries to connect to their server automatically to retrieve the

details with the number being mapped with the original booking id. This helps the

customer to remember only one booking id, but track the status of the courier while it

travels through other network to.

1

DATA STRUCTUREThe 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

Password Varchar Password -

Table 2: Administration login


User_id Varchar Userid(unique) Primary key



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

1

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

Whether Varchar Courier/cargo -

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. -

1

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 -

Reason_route_change Varchar reason -

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 -

1

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

Country_id Numeric - Foreign key

City_id Integer - Primary key

city Varchar - -

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 - -

1

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 Collaboration


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 - -

Whether_handles Varchar Courier/cargo -

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

1

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 -

Table 22: Loading Unloading Container


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

1


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 - -

1

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.

1

REPORTS

User:

Status of Courier & Cargo.

Status of Lot.

Status of Trucks.

Administrator:

Search the status of Courier & Cargo.

View complaints and suggestions of User and Offices.

1

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 sys login 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 applications are secure.

1

SCREENSHOTS

Home Page

1

Administrator Login Form

1

Administrator Page After Login

1

Create New Office

1

Create Container

1

Create Truck

1

Create Network

1

Create Route Form

1

Create Route Map Form

1

Create City Form

1

Search Booking Status Form

1

User Login Form

1

User Page After Login

1

Booking Form

1

FUTURE SCOPE

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.

1

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

We do not have online transactions.

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

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

1

BIBLIOGRAPHY

We referred some books which had provided us with much of guidance to develop the

code for the website. There are a few good books and websites that we referred to develop

ASP, CSS, JavaScript and HTML codes.

Apart from codes these books and websites had provides us with few good techniques

and methodologies to develop the website. There are a list of few books and websites that we

referred are:

BOOKS:

C# Professional By Wrox Publication

ASP.Net By Wrox Publication

SQL SERVER 2005 In Techmedia, 21 Days

SITES FOR REFERENCE

http://www.google.com

http://www.aspcode.net

http://msdn2.microsoft.com/en-us/asp.net/default.aspx

1

1online courier management

Documents

queries of user

user queries

courier cargo service

user query

user care officers

service industries

service provider

user complaint registers