An LPG distributor agency books hundreds of cylinder refills every day and many agencies still use paper registers for bookings, delivery, stock and cash memos. This causes refills before the allowed gap, two open bookings for one consumer, stock that does not match the godown and slow reports.
GasLink – LPG Gas Booking System Java project is a Java desktop application with a MySQL database that computerises the complete cycle of an agency: consumer register, refill booking with automatic rule checks, area-wise dispatch to delivery persons with run sheet, delivery confirmation with GST cash memo, a stock register of filled and empty cylinders, and date-wise reports. Every booking is checked for one open booking per connection, the domestic refill gap (15 days, configurable), quantity limits (domestic 1, commercial 1-10) and the yearly quota. Dispatch, delivery, cancellation and truck inward update the stock inside database transactions, so the stock of each cylinder type always equals its register entries. The Admin manages prices, areas, delivery persons, users, agency details, rules and backup, while the Staff handle daily counter work.
How it works
- Login > find consumer > rule check (open booking, gap days, quota) > booking BOOKED > dispatch to delivery person (filled stock reduced, run sheet) > delivery entry (payment, empties, cash memo) or not-delivered return > stock register and reports updated > dashboard
Users
- Admin – Dashboard, Masters & Prices (cylinder types, areas, delivery persons), Users (block / reset password), Settings (agency details, gap days, yearly quota), Backup & Restore, Stock adjustment, plus all Staff modules
- Staff – Dashboard, Consumers, New Booking, Booking Register, Dispatch + Run sheet, Delivery Entry + Cash memo, Stock Register + Truck inward, Reports, My Profile
Highlights
- A working desktop application that reduces counter time per booking, removes booking-rule disputes, keeps the godown stock correct and gives the owner daily and monthly reports in PDF.
- Booking rules checked in less than a second; no double or early refills
- Stock always matches the register; low-stock alert on the dashboard
- Delivery person-wise cash and cylinders are clear every evening
- Printed GST cash memo with amount in words; fast PDF reports
- Sample data and demo logins so every screen has data on the first run
What you get
- Complete Java source code (Eclipse project, runs in NetBeans / IntelliJ too)
- MySQL database SQL file with sample data
- Project report (56 pages) with all diagrams, abstract, project explanation with viva questions
- Setup guide and README with a 10-minute demo script
- Setup help from Ananda Technologies
Who can use this project
BCA and BSc (CS / IT) final year students who want a Java Swing MySQL project with source code that is easy to explain in viva and has enough content for 3 students and 3 college demos.
Frequently asked questions
- Does it need internet? No, it is a desktop application and works fully offline.
- Which IDE do I need? Eclipse is used in the setup guide; NetBeans and IntelliJ also open it because the screens are plain Swing code.
- Can 3 students share this project? Yes, the README gives a 3-student split and a 3-demo plan.
- Is the report editable? Yes, the report is given in Word and PDF.