Big VB project, help!!

Apr 1 2010 10:07 AM
Hi all!

I'm new here so I don't know if this thread is in the right place, so feel free to move it if needed. But anyway, here we go!

I'm currently working on a project in school where we're developing a booking system for different kinds of services, such as installing technology or picking up stuff that's broken. But since I'm not the most skilled in Visual Basic, I am in great need of some help, and that's why I'm here.

The booking system is a web-based application, a website in other words, and it's supposed to be connected to a database. The database is made in SQL Server, and this far it seems to be working, but that's not the problem so let's ignore that for now. My problem is that I need some help in writing the Visual Basic code. So here's the thing;

The booking system is divided in five parts, or steps you could say. I'll try to explain it as good as I can. I'm swedish so please bare with me! =)

Step 1: Here the client is supposed to type in it's name, adress etc. But before the client does that, it must select if it's a private or a business customer. If private customer is selected, TextBoxes for first name and last name become active. If business customer is selected, business name becomes active instead of first name and last name. Get it? The client must also type in it's postal code/zip code, which brings me to Step 2.

Step 2: Here the client must pick the workshop from which it will get the service. The workshop is controlled by the postal code/zip code from Step 1. So if you type in a specific postal code in Step 1, Step 2 will automatically locate the workshop closest to that adress. Each workshop offer services to a larger area, which means several postal codes. Once a workshop is located, the adress to that workshop shall be displayed, as well as telephone number and such contact information.

Step 3: In this step the client must select what type of service it wants. There are six different types of services available; Home delivery, Installation, Home service/Pick-up service, Mounting, Update and "Problemfixer". Depending on what you choose, different options will be displayed. For example, if you select Home delivery, a bunch of text boxes are revealed where you must type in where you bought the device, how much it did cost, insurance number etc. But if you select, for example, "Problemfixer", only a text field is revealed where you must type in a description of the problem.

Step 4: In this step the client must pick a date and time for the service, with the help of a calendar. First, the closest times available for the selected workshop will be displayed. So it all starts at Step 1 where you type in a postal code, which in Step 2 automatically locates the closest workshop, which in Step 4 automatically displays the closest time available for the service selected in Step 3.

Step 5: Once all the above steps are complete, the client must click on "Confirm booking", and is then sent to an overview page where he/she can view all the information he/she typed in before. Once done here, the client must click on "Finish booking", and the information is sent to the database.

Does this sound completely impossible, or is there any chance that it might work?

As mentioned, I am not the most skilled in VB, so if there is any kind soul out there willing to help me I would be forever grateful! =)

The database is not the problem as mentioned, it's the VB coding.

So again, please help!

Cheers