Online Gas Booking System
Online Gas Booking System

Objective of Online Gas Booking Management System

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

The objective of this project is to create a system where the customer can easily book their LPG gas cylinder through an online system and the 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 gas online which will save them 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 center, 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 gas they booked online with a detailed description as there should be a limited time after which new gas can be booked. We in our system focused on the 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 maintaining.

You can also check these posts:

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 ways like booking their gas cylinder from home without traveling to the agency and stand in a queue to just book the gas.

On the other hand, it also makes it 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 operations will become easier as all information that is provided from the system is very reliable and a high amount of data space is used.

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

The determination of the system is to provide the user with simple and secure software which is understandable, easier to store and search 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 the 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 the 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 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 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 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 traveling personal to that place, it is received and immediately checked by billing.

The customer’s name, address, last date of delivery are 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 paperwork. 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 are 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 customers 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 records without any overhead cost. All the process of the 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 that 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 NameData TypeRemark
CylntypeVarchar (10)Cylinder Type
pricefloat (4,2)Price

 Billing Details

Column NameData TypeRemark
BlidIntegerBilling Id
ConsnoIntegerCustomer Number
CylintypeVarchar (10)Cylinder Type
bkdateDatetimeBooked Date
deldateDatetimeDelivery Date
amtFloat (4,2)Amount

 Customer Details

Column NameData TypeRemark
ConsnoIntegerCustomer Number
PassVarchar (8)Password
CylintypeVarchar (10)Cylinder Type
dtofconnDatetime Connection Date
CnameVarchar (25)Customer Name
CaddrVarchar (50)Customer address
CityVarchar (15)Customer city
PhoneNumber (10)Phone number
PincodeNumber (6)Pin code

 Stock Details

Column NameData TypeRemark
SdtDatetime Date
StoreccomIntegerStock received Commercial
StorecdomIntegerStock received Domestic
DefcommIntegerDefective in Commercial
DefdomIntegerDefective in Domestic
CstocomIntegerCurrent stock commercial
CstodomIntegerCurrent stock domestic

 Transaction Details

Column NameData TypeRemark
TIdIntegerTransaction Id
ConsnoIntegerCustomer Id
CylntypeVarchar (10)Cylinder Type
BkdtDatetimeCustomer Name
DeldtDatetimeCustomer address
StatusVarchar (10)Status of transaction

E-R Model Online Gas Booking Management System

Description of Online Gas Booking Management System

The 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 the unique connection it is given an identity number.

It is essential for the system to store the record of all the customers at separate entities 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 customers performing the transaction we have created a login system and customers had to register a password that acts like a unique keyword through which users can enter the system and book the gas.

It has following attributes:

Conso:

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

C name:

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.

Dt of conn:

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:

A 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 the customer and the difference in time span after those checks if there is enough stock for that cylinder type if both are positive then the status goes completed and the bill is generated.

It has following attributes:

T id:

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:

The 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 the 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 the 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 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 by 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.

Def Comm:

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

Def Dom:

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 the total commercial cylinder agency have till the stock date.

Custom:

Current Stock Domestic this attribute will have information about the 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 complications of the conventional method which is a combination of folders, spreadsheets, emails, and for the customer traveling, queues.

It has a unified system in which all the processes 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 log in to the system to book a gas which acts as a security blanket to the system and avoids any anonymous person entering the system.

It can book the gas through the 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 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 a 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 the customer to go to the location and stand in the queue instead they can book the gas sitting in their home.