Half day calculation

Question

1.00/5 (1 vote)

See more:

I need to save date details into table with half day working as 0.5 days between two given dates.
I'm using checkbox for both from date and to date.
I want to save 0.5 day in table if checkbox checked for start or end date.
For example:
From date 10/02/2018 AN
To date 12/02/2018

i want to save in table like
date days
10/02/2018 0.5
11/02/2018 1
12/02/2018 1

What I have tried:

Im using while loop to get individual date details from given two dates.

Posted 12-Feb-18 1:41am

Ashokk88

Updated 12-Feb-18 9:14am

Add a Solution

Comments

Ziee-M 12-Feb-18 7:50am

Post your code.

Ashokk88 13-Feb-18 0:22am

DateTime t1 = Convert.ToDateTime(txt_from_date.Text);
DateTime t2 = Convert.ToDateTime(txt_to_date.Text);
double comp_days;
while (t1 <= t2)
{
...insert into table code....
t1 = t1.AddDays(1);
}

I want to add half day details if user select the respective check box.

OriginalGriff 12-Feb-18 8:05am

And?
What have you tried?
Where are you stuck?
What help do you need?

Ashokk88 13-Feb-18 0:24am

DateTime t1 = Convert.ToDateTime(txt_from_date.Text);
DateTime t2 = Convert.ToDateTime(txt_to_date.Text);
double comp_days;
while (t1 <= t2)
{
...insert into table code....
t1 = t1.AddDays(1);
}

I want to add half day details if user select the respective check box.

Ashokk88 13-Feb-18 1:33am

I want to save day as 0.5 if from date or to date is half day only.
For example-
From date 13/02/2018 (half day selected)
To date 15/02/2018
In my table i want to save like for date 13/02/2018 as 0.5 and
(14/02/2018, 15/02/2018) as 1

Laxmidhar tatwa technologies 13-Feb-18 1:52am

Data should save in date time data type

Ashokk88 13-Feb-18 2:37am

yes, Im saving the date in datetime format and in another field saving value as 0.5 for half day and 1 for full day.

Laxmidhar tatwa technologies 13-Feb-18 5:24am

In if condition check both checkbox with or operator for pass 0.5 in else statement pass 1

Ashokk88 14-Feb-18 1:19am

If I use if condition inside while loop it consider as half day for all the days(Between from date and to date). I want like if check box for start date selected, for the start date one it should consider 0.5 and for remaining day it should be 1.

Ashokk88 14-Feb-18 1:20am

DateTime t1 = Convert.ToDateTime(txt_from_date.Text);
DateTime t2 = Convert.ToDateTime(txt_to_date.Text);
double comp_days;
while (t1 <= t2)
{
if(chk_from.Checked == true || chk_to.Checked == true)
{
comp_days = 0.5;
}
else
{
comp_days = 1;
}

....Insert codings....

t1 = t1.AddDays(1);
}

1 solution

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)

Maciej Los · Answer 1 · 2018-02-12T09:13:00

Please check my answer to similar question: How to fill a series of date using start date and end date in C#[^]

All you need to do is to change

SQL

CREATE PROCEDURE uspInsertDateRange
--input variables
    @startDate DATE,
    @isStartDateHalfDay BIT,
    @endDate DATE,
    @isEndDateHalfDay BIT
AS
--a content of SP here
...

How to pass parameters into stored procedure in ASP.NET?
SqlDataSource StoredProcedure example: Pass parameters to StoredProcedure using SqlDataSource in ASP.Net[^]
How to: Set and Get Parameters for Command Objects[^]
How to call SQL Server stored procedures in ASP.NET by using Visual Basic .NET[^]

Good luck!