if time is less than 60min make charge of 10rs. and if the time is more than 60min increase the amt according to the time

Question

1.00/5 (1 vote)

See more:

I have mentioned my problem below

C#

st = "UPDATE tbl_time set time_out='" + dt1.ToString("hh:mm:ss") + "' WHERE ID=(SELECT MAX(ID) FROM tbl_time)";
db.ExeQuery(st);
st = "Select * from tbl_time where ID=(Select MAX(ID) from tbl_time)";
dr = db.readall(st);
if (dr.Read() == true)
{
   txt1.Text = dr["time_in"].ToString();
   txt2.Text = dr["time_out"].ToString();
}
TimeSpan t1 = TimeSpan.Parse(txt1.Text);
TimeSpan t2 = TimeSpan.Parse(txt2.Text);
TimeSpan ts = t2 - t1;
dr.Close();
st = "UPDATE tbl_time set tot='" + ts + "' WHERE ID=(SELECT MAX(ID) FROM tbl_time)";
db.ExeQuery(st);
st = "Select * from tbl_time where ID=(Select MAX(ID) from tbl_time)";
dr = db.readall(st);
if (dr.Read() == true)
{
   txt3.Text = dr["tot"].ToString();
}
dr.Close();
TimeSpan t3 = TimeSpan.Parse(txt3.Text);
double fee = 0;
  
// In ts variable i'm storing the start and end time i.e total time
if (ts.TotalMinutes < 60)   // Here is my doubt If the user spend time less than 60 min i want make charge of  10Rs i.e i have done 
{                                        //but if the user spend 120 min i want make charge of 20Rs, but in the database it saving like 60rs.
   // I'm not getting where my calculation is wrong   
   st = "UPDATE tbl_time set amt='" + fee + "' WHERE ID=(SELECT MAX(ID) FROM tbl_time)";
   db.ExeQuery(st);
}
if (ts.TotalMilliseconds > 60)
{
   fee = (ts.TotalMinutes / 10) * 10;
   st = "UPDATE tbl_time set amt='" + fee + "' WHERE ID=(SELECT MAX(ID) FROM tbl_time)";
   db.ExeQuery(st);
}

Posted 18-Feb-15 2:44am

Member 10637123

Updated 18-Feb-15 3:05am

phil.o

v2

Add a Solution

Comments

phil.o 18-Feb-15 9:03am

Not a question. This is called a requirement.
Where are you stuck.

Member 10637123 18-Feb-15 9:09am

bro if the user spend less than 60min make charge of 10rs or if the user spend more than 60 min increase the charge of Rs according to time

CHill60 18-Feb-15 9:19am

phil.o will not be notified of your response if you don't use the Reply link next to his post.
Don't put your question in comments - put it in plain text... it is easier for us to read and therefore easier for us to help you

CHill60 18-Feb-15 9:21am

By the way, in some cultures "bro" can imply "obnoxious" or "idiot" - best to avoid the use of that slang where you don't know the cultural impact

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2015-02-18T04:03:00

I've read your question slightly differently to the other poster, in that I think you need to pr-rata[^] the charge subject to a minimum charge of 10rs.

If it was just based on the number of hours then you could use

double feePerHours = Math.Max(minFee, hourlyFee * (timeInMinutes / 60));

where I've initialised both minFee and hourlyFee to 10rs. Note the use of Math.Max to ensure I never charge less than 10rs.

To get the pro-rata fee (i.e. the bit to add on for every minute over the hour) you can use

double proRataFee = Math.Max(0, ((timeInMinutes - 60) % 60) * (hourlyFee / 60.0));

Note that I've used the modulo operator[^] to get the number-of-minutes-over-an-hour i.e. the remainder when divided by 60. I've also used Max again to ensure that the first hour doesn't start giving me negative numbers.

The total fee is just the two added together. I tested this with this code

C#

int minFee = 10;
double hourlyFee = 10.0;

for (var timeInMinutes = 40; timeInMinutes <= 160; timeInMinutes += 20)
{
    double feePerHours = Math.Max(minFee, hourlyFee * (timeInMinutes / 60));

    double proRataFee = Math.Max(0, ((timeInMinutes - 60) % 60) * (hourlyFee / 60.0));

    double totalFee = feePerHours + proRataFee;

    Console.WriteLine("Time : {0} minutes; Fee for hours {1}, Pro-rata bit {2:0.00} Total Fee R{3:0.00}", timeInMinutes, feePerHours, proRataFee, totalFee);

}

which gave me these results:

Time : 40 minutes; Fee for hours 10, Pro-rata bit 0.00 Total Fee R10.00
Time : 60 minutes; Fee for hours 10, Pro-rata bit 0.00 Total Fee R10.00
Time : 80 minutes; Fee for hours 10, Pro-rata bit 3.33 Total Fee R13.33
Time : 100 minutes; Fee for hours 10, Pro-rata bit 6.67 Total Fee R16.67
Time : 120 minutes; Fee for hours 20, Pro-rata bit 0.00 Total Fee R20.00
Time : 140 minutes; Fee for hours 20, Pro-rata bit 3.33 Total Fee R23.33
Time : 160 minutes; Fee for hours 20, Pro-rata bit 6.67 Total Fee R26.67

TheRealSteveJudge · Answer 2 · 2015-02-18T03:29:00

Here is a simple method to achieve what you want.

C#

int CalculateParkingFee(DateTime entryTime, DateTime leaveTime)
{
    DateTime effectiveLeaveTime;

    TimeSpan ellapsedTime = leaveTime.Subtract(entryTime);

    if (ellapsedTime.TotalMinutes % 60 == 0)
    {
        effectiveLeaveTime = leaveTime;
    }
    else
    {
        effectiveLeaveTime = new DateTime(leaveTime.Year, leaveTime.Month, leaveTime.Day, leaveTime.Hour, 0, 0).AddHours(1);
    }

    double accountableHours = effectiveLeaveTime.Subtract(entryTime).TotalHours;

    return (int)accountableHours;
}

You can test it like this:

C#

MessageBox.Show(CalculateParkingFee(new DateTime(2015,2,18,15,0,0), new DateTime(2015,2,18,15,20,0)).ToString());
MessageBox.Show(CalculateParkingFee(new DateTime(2015, 2, 18, 15, 0, 0), new DateTime(2015, 2, 18, 16, 0, 0)).ToString());
MessageBox.Show(CalculateParkingFee(new DateTime(2015, 2, 18, 15, 0, 0), new DateTime(2015, 2, 18, 16, 20, 0)).ToString());

The results are:
1
1
2

if time is less than 60min make charge of 10rs. and if the time is more than 60min increase the amt according to the time

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0