water billing system

pts.
Tags:
ActiveX
Programming Languages
SQL
VB.NET
Visual Basic
does anyone know how to make a water billing system? im currently working on it for a project for my school and im stumped. i cant seem to make my prog run properly. please help me out, just a student here.. also, can you please send me a code on how to make my program run everytime i start my computer.. thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

I suggest adding more info – What language are you coding it in? VB?, SQL?, C++?, JAVA? Is it a self contained database or just a front end for use with existing backend dB – SQL Server, Oracle, etc? Do you need just billing (invoicing) or will it need to maintain receivables as well? Does it tie into an available ERP / CRM system?

I strongly suggest starting with a data model. What data do you / the end users need? Obviously, to start, you’d have customer data (what fields?), Water Usages, Rates, etc. Map it all out. Then construct your tables, keeping data as Normalized as possible (This will allow for easier expansion, linking, etc).

For starting everytime you start your PC – Could it just be added to your Start-up folder (assuming Windows machine – you didn’t say).

Give us some more background…
Good luck.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DKForrer
    First of all, the reason students are given assignments is to get them think in a structured manner suitable for programming. There's no better teacher than trial and error. However, I also know that beginners sometimes don't know how to start, so I'll help some without providing a specific answer. Question #2: Assuming you're using Windows, open the help documentation and look for "Starting Programs". You'll find instructions on how to start a program automatically when starting Windows. Question #1: This is a wide open question. The options are endless. You didn't state the operating system and programming language you're working with. No need to supply it now, because odds are I use something else. I'll give you a simple, high-level outline, but you'll need to fill in the details specific to your language, such as opening and closing files, reading records and printing the bill. You'll also need to decide where to place logical statements (such as "if" statements) to control overall procoess flow. The real work ( and fun) is in these details. Your language reference manual and a few examples should provide everything else you need. Some issues to decide: 1) How to receive the input. This could be from a file or through an input screen. I'll assume it's a file. 2) Will there be a single billing rate, or multiple (ex: residential vs. commercial) and where are the rates stored, I'll assume multiple rates stored in a file. 3) How will the bills be issued. I'll assume they're printed. Here's an outline: Define your input billing record layout. It should contain at least the customer name, billing address, rate class and gallons water usage Define your input rate record layout. Define an internal table to hold the rates. Define a field to hold the results of the billing calculation. Define other work fields you will need to control overall program flow. Read the rates from the rate file into the internal rate table Perform Process_Records until All_Records_Processed. Process_Records Read a record from the input billing file Get the rate that applies to the current record Compute the billed amount (usage x rate) Print the bill for the current customer For future assignments, first think through the logic as I did above. Then go back and fill in the details to make it work in your programming language. Have fun and good luck.
    0 pointsBadges:
    report
  • astradyne
    For a school project it would only need to be a simple application, you just need to show that you've thought about what would need to be included in the application. Take a look at your parents water bill (or even an electric or gas bill, the concept's the same) and think about what is needed to produce the bill. To produce a bill you would need to hold (as a minimum): a) Customer Information Name, address, phone numbers, account number, type of charge (standard charge or metered) b) Meter readings (if applicable) Customer account number, reading date, reading type (Estimate, Customer Read, Agent Read), Reading c) Transaction Information Transaction Type (Invoice, Credit or Payment), Transaction Number, Amount, Metered Rate, Metered Units Used a), b) and c) will be separate tables (although c) will actually be two or more tables - header and detail). You will also need various status codes on each of the files to help in the selection and processing of records. You would need to have some method of entering these details into your application. So entry screens/windows for: Customer Details, Readings and Payments would be required as well as a routine to produce invoices. To make the program start when you turn on your computer it will depend on the type of operating system you are using. If it's Windows then move your application to the Startup folder. Hope it helps Jonathan
    370 pointsBadges:
    report
  • Uruviwas
    I suggest adding more info - What language are you coding it in? VB?, SQL?, C++?, JAVA? Is it a self contained database or just a front end for use with existing backend dB - SQL Server, Oracle, etc? Do you need just billing (invoicing) or will it need to maintain receivables as well? Does it tie into an available ERP / CRM system? I strongly suggest starting with a data model. What data do you / the end users need? Obviously, to start, you'd have customer data (what fields?), Water Usages, Rates, etc. Map it all out. Then construct your tables, keeping data as Normalized as possible (This will allow for easier expansion, linking, etc). For starting everytime you start your PC - Could it just be added to your Start-up folder (assuming Windows machine - you didn't say). Give us some more background... Good luck.
    20 pointsBadges:
    report
  • Abhenbhatt
    jhjhhjvhjvhj
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following