The Objective of the Online Gas Booking Management System
Are you looking for an 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 records should be maintaining.
You can also check these posts:
- Online Agency Management System
- Banking Management System
- Stock Management System Project
- Insurance Agency Management System Project
- Stationary Shop Management System
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 spending the money increasing the budget.
- The booking process increments the level of complexity as the number of customers coming to book gas increases.
- Information is not available globally to both customers and agencies.
- Staff manually evaluating the validity of customers 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: 250 MHz to 833 MHz
- Ram: 512 Mb Ram
- Hard Disk: 40 Gb
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
- .NET Backend: 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
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 the 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.