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