• November 25th, 2012, 09:10 AM
Crispan varro
I have this VB project to do in my first year at college,with everything else i can't seem to figure out this bit of code.. Here's some information about it.

Its based on a fictional car hire firm where i have to design a car rental form that an operator fills out while talking to the client on the phone.

There are a number of vehicles involved,but i will use one as an example here.

VW Polo- Daily rate... 37.50 weekly rate... 236.25...Fortnightly Rate... 448.90

Extras.. Child Seat... 22.00 Sat-Nav... 5.00 Roof Rack... 45.00.(client has a choice of one or all)

If the customer requires the car for 16 days(this number is just an example,it could be any number of days depending on the overall rental period) the cost is calculated by applying the fortnightly rate and adding two extra days at the daily rate.The prices are quoted excluding VAT(20%).

I have figured out the code that calculates the total number of rental days using the datetimepicker in Visual basic express.

I have declared the rental rates and cost of extras as constants in the public class
and vehicle choices are made by clicking on a radiobutton allocated for each vehicle,checkboxes for extras.

With this information i need to calculate the TOTAL COST of the rental using the MOD operator.
• November 26th, 2012, 01:51 AM
GremlinSA
This is a tricky one, however the simplest solution is to take the Total days.. then going though your rental periods list from longest to shortest, calculate how many periods of each will fulfill the customers requirement.

EG: given you above example..

fortnightly (14 days) : 16/14 == 1 so we have 1 fortnightly value..
remaining days is easy .. 16 mod 14 = 2 much easier than 16 - (14*1)
Now we have 2 days left..
weekly (7 days) : 2/7 == 0 so we have 0 weekly value..
Daily (1) : well we have 2...

obviously you will have to watch the maths, as the division will sometimes round up.. but this should give you a good starting point..
• November 30th, 2012, 06:46 AM
Crispan varro
Thanks for this dude,the thing is,i'm a complete novice,our lecturer gave us this project to do ater only five lectures with the other modules i'm taking i just can't seem to focus on the this,could you kinda simplify your answer for me,my backs against the wall here and until i finally have the time to focus on this (xmas break)i'm in trouble,the project is due on the 14th of dec... I really don't know what i'm goin to do here
• November 30th, 2012, 08:52 AM
DataMiser
Looks like what you need is there already.

Code:

```FN=TotalPeriod/14 RD=TotalPeriod Mod 14 WK=RD/7 DY=RD Mod 7```
The total cost would be FN*fortnightly rate + WK*weeklyrate + dy*dailyrate
• November 30th, 2012, 10:35 AM
Crispan varro
Quote:

Originally Posted by DataMiser
Looks like what you need is there already.

Code:

```FN=TotalPeriod/14 RD=TotalPeriod Mod 14 WK=RD/7 DY=RD Mod 7```
The total cost would be FN*fortnightly rate + WK*weeklyrate + dy*dailyrate

This is the procedure i have for calculating the amount of forthnights,weeks and days.I just seem to have a problem seeing how i would apply this to calculating the total rental charge to the customer from the information i posted earlier regarding the project outline.

NOD = Number of Days
NOW = Number of weeks
NOF = Number of Forthnights
TAD = Total amount of days.

Code:

``` Dim NOD,NOW,NOF,TAD as Integer TAD = Integer.Parse(txtTAD.text) If TAD>= 14 Then NOF = (TAD - (TAD Mod 14)) / 14 Else if  TAD  <14  Then   NOF = 0 End if If TAD <7 Then NOW = 0 Else if TAD Mod 14 >6 Then NOW = 1 Else If TAD Mod 14<7 Then NOW = 0 End If If TAD <7 Then NOW = TAD Else NOD = TAD Mod 7 End If```

I can't seem to come up with the correct code (using the information that is returned useing the above procedure) to calculate the correct total cost to the customer
• November 30th, 2012, 12:50 PM
DataMiser
That is a lot more code than you need. You have already been shown twice how to do it.

Based on what you posted you are using VB.Net rather than VB6 so this is the wrong section of the forum.

Still the method you have been shown will work in VB.Net as well.

As for the calculation it is just basic math

TotalRentalCharge=(NumberOfFortNights * FortNightRate) + (NumberOfWeeks*WeeklyRate) + (NumberOfDays*DailyRate)
• November 30th, 2012, 08:38 PM
Crispan varro
Thanks for all the help guys,i got that nailed.
regards Crispan
• December 10th, 2012, 01:41 PM
cemmac
Hi Cristian...

Already have this project finished, had the same one from the same lect....

am in cork...

get back to me :-)
• December 10th, 2012, 10:15 PM
dglienna