OBJECTIVE OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

Are you looking for Online gas booking management system for your final year project? We are here to help you. You can contact us

The objective of this project is to create the system where the customer can easily book their LPG gas cylinder through online system and agency can track the record of its customer and the delivery of the cylinder.

The system will help the customers by providing a simple user interactive interface for booking the gas through online which will save their time and money. It also gives the agencies ease by helping them make the booking process faster and easier to maintain.

There are various steps to book a gas like issuing an entry book, to travel agency from that to go to the delivery centre, our system makes this whole process at one place. Basically, there are two types of users for the cylinders domestic and other is commercial.

It gives every user a simple and secure system by authorizing the user before entering the system.This is helpful to the agency to get all the desired data through so many simple steps without going through manual records.

The system will display the user the number of the gas they booked through online with detail description as there should be limited time after which new gas can be booked. We in our system focused on following keywords:

Consumer Record is maintained

Edit, update and deletion of the record

Online booking of the gas through internet from any point

Check consumer is valid to book a gas

Valid booking followed by the payments process

Booking record should be maintain

ABSTRACT OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

To ensure a simple and secure environment for the consumer and the agencies we are making the ‘Online Gas Booking System’. Through this system, we are solving the customers’ problems in a lot of way like to book their gas cylinder from home without travelling to the agency and stand in a queue to just book the gas.

On the other hand, it also makes easier for the agency to check the number as a person has booked in a specific amount of time and the person who is booking the gas is authenticated or not whether he/she has brought the bottle within the time period, to get his gas booked.

It also prevents any error while registering the gas as if it’s done manually there is always a chance of omission and oversight. It also helps the agency to move from a manual system of registering the data to storing it online which digitized the agency and reduces their overall carbon footprint.

It will avoid the agency from spending a huge amount of their budget in maintaining the manual records and updating them from time to time.As the customer moves from another city its records can be easily transferred or deleted from the record.

All the operation will become easier as all information that is provided from the system is very reliable and high amount data space is used.

It also influences the user registration for the booking and the transaction process as it has the simple interface for booking the system through which customer can easily book the gas cylinder after that a payment process is also secured.

The determination of system is to provide the user with a simple and secure software which is understandable, easier to store and search the information.

EXISTING SYSTEM OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

Talking about the current system which presently used in the institutes is basically manually working or even if it is computerized restricted to a place or building thus all work of maintenance is also done in the same building.

So, we can say that Existing system of Gas Booking System works computerized in a building or manually with pen-paper.

This creates a very hectic procedure to manage as everything is on spreadsheets, file and binders, the same situation will occur in offline computerize method though everything is on the one system which is not globally present.

Whenever a customer requires the gas he/she have to travel to the agency and make a demand for gas which is recorded in a separately in a registration file, then the previous delivery made to the customer is searched and the number of days from that date till now is calculated.

If the number of days is expired only then the order is accepted, if not the order placed will be rejected. Then the valid order request is taken in and a billing is done manually.

The order is for two purposes as domestic and commercial. The billing is done based on the above two categories and the rate is charged.Then the stock of cylinders is also maintained in manual records.

So, while billing this also has to be taken into account and billed. This involves a great processing and the time is also wasted. Following this kind of system does not only require a lot of human resources but also budget for maintaining them and stationery required.

Whereas in our system whenever a customer makes a demand or places an order through a phone call or by travelling personal to that place, it is received and immediately checked by billing.

The customer’s name, address, last date of delivery is all maintained in the database. So, when the customer order is received and billed, the system automatically calculates the number of days from the previous delivery, if valid the billing can be done, if not the billing cannot be done and the customer can be informed about it.

So, the manual process of recording and billing is done easily without any paper work.The stock of gas that is recorded and maintained manually is made computerized.

So, while billing, based on the stock the billing charge and capacity is made. When the stock goes below the limit, it can be easily identified.

So, by this project, the process of ordering, billing and stock maintenance for a gas agency can be processed easily. In the manual system if a customer leaves the town then the staff has to find the record in the binders or spreadsheet which will consume a lot of time and resources.

It also makes the compulsory to do mundane work of daily update the stock register.This shows us various drawback in this system which are:

All the process is time-consuming.

Every process requires proper arrangements which will need a human resource.

Managing the staff entails to spending the money increasing the budget.

Booking process increments the level of complexity as the number of customer coming to book gas increases.

Information is not available globally to both customer and agencies.

Staff manually evaluating the validity of customer is susceptible to faults and mistakes.

PROPOSED SYSTEM OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

INTRODUCTION OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

Once the planning and analysis of the project are completed, the design phase begins. The goal of system design is to transform the information collected about the project into the blueprint structure which will serve as a base while constructing the system.

It is considered to be an unwieldy process as most of the errors are introduced in this phase. However, if an error gets unnoticed in the later process it may become difficult to track them down.

In our system, we are developing a system which helps in customer book a gas. The new system will maintain and store all the record without any overhead cost.All the process of booking will be web based online which makes it robust and globally available.

It will have transaction details which will store all the information regarding the payment of the booking as well as the total transaction record will be maintained which holds the record of a number of commercial and domestic cylinders have been sold on a particular day.

The billing record is stored separately so the agency can check the last bill of the customer just by matching his/her id without any hectic work of looking in the file manually. It will minimize the problems faces by both customers and the agency in the duration. Let’s discuss the system in detail:

HARDWARE REQUIREMENTS OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

The hardware required for the development of the project is:

PROCESSOR: Intel P-IV system

PROCESSOR SPEED: 250MHz to 833MHz

RAM: 512MB RAM

HARD DISK: 40GB

SOFTWARE REQUIREMENTS OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

The software required for the development of the project is:

OPERATING SYSTEM: Windows 2000 Professional

ENVIRONMENT: Visual Studio .NET 2002

.NET FRAMEWORK: Version 1.0

LANGUAGE: Visual Basic

.NETBACKEND: SQL SERVER 2000

TABLE DESIGN OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

Price Details 

Column Name Data Type Remark
Cylntype Varchar (10) Cylinder Type
price float (4,2) Price

 

Billing Details

Column Name Data Type Remark
Blid Integer Billing  Id
Consno Integer Customer Number
Cylintype Varchar (10) Cylinder Type
bkdate Datetime Booked Date
deldate Datetime Delivery Date
amt Float (4,2) Amount

 

Customer Details

Column Name Data Type Remark
Consno Integer Customer Number
Pass Varchar (8) Password
Cylintype Varchar (10) Cylinder Type
dtofconn Datetime  Connection Date
Cname Varchar (25) Customer Name
Caddr Varchar (50) Customer address
City Varchar(15) Customer city
Phone Number (10) Phone number
Pincode Number (6) Pin code

 

Stock Details

Column Name Data Type Remark
Sdt Datetime  Date
Storeccom Integer Stock received Commercial
Storecdom Integer Stock received Domestic
Defcomm Integer Defective in Commercial
Defdom Integer Defective in Domestic
Cstocom Integer Current stock commercial
Cstodom Integer Current stock domestic

 

Transaction Details

Column Name Data Type Remark
TId Integer Transaction Id
Consno Integer Customer Id
Cylntype Varchar(10) Cylinder Type
Bkdt Datetime Customer Name
Deldt Datetime Customer address
Status Varchar(10) Status of transaction

 

E-R MODEL ONLINE GAS BOOKING MANAGEMENT SYSTEM

E-R MODEL ONLINE GAS BOOKING MANAGEMENT SYSTEM

DESCRIPTION OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

Above figure shows the E-R diagram of the proposed system.The ER model defines the conceptual view of a database. It works around real-world entities and the associations among them.

At view level, the ER model is considered a good option for designing databases. So, let’s see each entity in Details-:

Customers:

This entity will store the information about the customers present in the agency as each consumer is unique connection it is given an identity number.

It is essential for the system to store the record of all the customers at separate entity without mixing with the booking he/she does so that any time agency want to check their customer data they can fetch from this entity without disturbing the booking details or stock information.

To provide a security layer for customer performing the transaction we have created a login system and customer had to register a password which acts like unique keyword through which user can enter the system and book the gas.

It has following attributes:

Conso:

Customer id is a unique attribute. It holds the distinct number given to him while getting the new connection by the agency. It will help in identifying each customer as an individual unit during the process of gas booking.

Cname:

Customer name is a required as a personal information about the user who has the agency gas connection.

Pass:

The password is an alphanumeric field which helps customer to login in the system.

Dtofconn:

Date of connection has the record when was the connection taken by the customer initially.

Cyanotype:

A cylinder is of two types Commercial and domestic it tells which type of cylinder has been registered for consumer connection

Caddy:

Customer address is a composite attribute with Customer city and pin code number, this helps while delivering the cylinder at door service.

Phone:

Phone number of the customer is essential as if a delivery person wants to contact the customers.

Transactions:

This entity will store the data regarding the transaction for the booking of the gas cylinder. It will check the last booking of customer and difference in time span after that checks if there is enough stock for that cylinder type if both are positive then status go completed and the bill is generated.

It has following attributes:

Tid:

Transaction id attribute is the distinct number given to each transaction that takes place in the system.

Conso:

Customer Id is referenced from a customer who is making the transaction.

Cyanotype:

Cylinder Type gives information about for what type of cylinder this booking is ordered based on customer id.

but:

Booking Date attribute stores the date of the transaction is done.

delete:

If the status is pass then Delivery date attribute will store the delivery of the gas.

Status:

It is a remark for the transaction whether it feasible or not

Bills:

Billing entity will generate an invoice after the transaction is completed with stating all the information regarding the booking of the cylinder gas and its delivery date with the payable amount.

The price entity will assign the amount to the bill based on the cylinder type of the customer order. It has following attributes:

Conso:

The id of the customer who has booked the cylinder.

Cyanotype:

Type of the cylinder according to customer id

but:

Booking Date attribute stores the date of booking is done.

delete:

If status is pass then Delivery date attribute will store the delivery of the gas

Amt:

Amount to be paid by the customer based on the type of cylinder connection he/she has.

Prices:

This entity will store the price of a cylinder of each type as if the price of cylinder changes agency can alter this entity and rest of system will not be affected.

If this entity will be merged with the others it can create hassle as for changing the prices whole data has to be changed. It has following attributes:

Cyanotype:

Cylinder Type gives information about for what type of cylinder as there are two types domestic and commercial.

Price:

It stores the amount for the each type of the cylinder.

Stocks:

The entity is essential as it stores the information regarding the stocks of the cylinder coming to the warehouse of the agency. It also helps the system while booking the gas cylinder with verifying that the customer asking for a cylinder type is present in the agency or not.

It has following attributes:

Set:

Stock date attribute will store the date of which stock is maintained.

Starcom:

Stock received commercial, this attribute will store the quantity of the commercial cylinder is registered in the agency on a date.

Stardom:

Stock received domestic, this attribute will store the quantity of the commercial cylinder is registered in the agency on a date.

Defcomm:

The defective Commercial attribute will store the quantity which received but was faulty in commercial stock.

Defdom:

The defective Domestic attribute will store the quantity which received but was faulty in domestic stock.

Custom:

Current Stock Commercial this attribute will have information about total commercial cylinder agency have till the stock date.

Custom:

Current Stock Domestic this attribute will have information about total domestic cylinder agency have till the stock date.

USER INTERFACE OF ONLINE GAS BOOKING MANAGEMENT SYSTEM

The Online Gas Booking System hassles out all the complication of conventional method which is a combination of the folders, spreadsheets, the emails and for the customer travelling, queues.

It has a unified system in which all the process from registration, booking process and payment in one system. Here’s how the system manages to keep it simple for customers and the agencies:

Consumer Interface of online gas booking management system:

The consumer has to login to the system to book a gas which acts as a security blanket to the system and avoids any anonymous person to enter the system.

It can book the gas through booking interface and if verified by the backend system which will check whether he/she is booking gas after a specific period or not.

If verification is approved user can go for the payment option. The consumer can also check its personal details stored by the agency and edit if they wanted to like changing their address or mobile number.

Agency Interface of online gas booking management system :

The agency will assign a member of its staff who has to operate the system, those employees will be given access to the system. It will provide the stock details to the system which help in getting the booking possible or not.

Agency can also check on daily purpose how many cylinders are booked and details of customers who have booked them.

Booking Interface of online gas booking management system:

In this customer can book a gas and first it will get verified if he/she is eligible based on its last booking then the stock is checked for the type of cylinder needed which will be based on the customer is commercial user or domestic user.

If all the process is done, the bill will be generated in the name of the customer and there is an update in the record of the agency to alter the stock details.

This system will provide relief to the customer and the gas agencies which earlier use to hassle with the customer to go the location and stand in the queue instead they can book the gas sitting in their home.