Count No of hores

Sanjana Khalasi

Hello sir i want to calculate no oh houres like per day 4 houre and implement on calculattor like i will entre total no of houre is 44 and i will chose date 01/01/2017 then calculate end date is 11/01/2014 on calender how can do that plz help me....

protected void txt_startDate_TextChanged(object sender, EventArgs e)

{

String dateInString = txtnohr.Text;

DateTime r, r1;

string s = "", s1 = "";

DateTime startDate = DateTime.Parse(txt_startDate.Text);

int totalnoofhr, oneday = 4;

totalnoofhr = Convert.ToInt32(dateInString);

int count = 0;

for (int j = 0; j <= totalnoofhr; j++)

{

if (totalnoofhr != 0)

{

if (count == j)

{

s = startDate.AddDays(j).ToShortDateString();

totalnoofhr = totalnoofhr - oneday;

count = count + 1;

}

s1 = s;

lbl_show.Text = s1;

r1 = Convert.ToDateTime(s1);

s1 = r1.AddDays(1).ToShortDateString();

String myString = s1; // get value from text field

r = Convert.ToDateTime(myString);

String myString_new = r.ToString("yyyy-MM-dd"); // add myString_new to oracle

lbl_show.Text = myString_new;

}

18 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Sharma9y ago
Accepted answer
you already have AddWorkDays method

just pass start day and 1 to it. you will get correct output.
0
Sanjana Khalasi9y ago
Hello,
i have three job entry,
1.BusyBee to start date 09/10/2017 to end date 10/10/2017
2.50mm to start date 11/10/2017 to end date 13/10/2017
3.Taj to start date 14/10/2017 to end date 18/10/2017

but if work are not completed in disided time like first work BusyBee start date 09/10/2017 to end date 10/10/2017 but work are completed 11/10/2017 then second entrry automatic generated in reapeator 12/10/2017 as a second job work how can do plz help me...
0
Ankit Sharma9y ago
put your source code and start a new thread....
people will help you
i a bit busy now
0
Sanjana Khalasi9y ago
steel not working...
0
Sanjana Khalasi9y ago
but how can i implement plz help me...
0
Ankit Sharma9y ago
while calculating second entry start date , put the condition to check for sundays, if it is sunday then add 1 day to it to get Monday.
0
Sanjana Khalasi9y ago
i dont want to count sunday but in first entry, i will entr no of hours 12 and start date will be 15/09/2017 then end date is 17/09/2017 it count correct but then i will entr second entry start date is 18/09/2017 automatic generated in these code but date 18/09/2017 is sunday ..so,i want 19/09/2017
0
Ankit Sharma9y ago
why are you giving sunday as start date???

If you dont want to count sundays then your start date must be weekdays.
your input is wrong then how u expect correct output?
0
Sanjana Khalasi9y ago
Hello Sir,

protected void ddle_name_SelectedIndexChanged(object sender, EventArgs e)
{
con = new SqlConnection(str);
con.Open();
string sql = "select Job_End_Date from tbl_Job_Entry where JobEntry_Id IN(select MAX(JobEntry_Id) from tbl_Job_Entry where Emp_Id='" + ddle_name.SelectedValue + "')";
cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
String d = dt.Rows[0]["Job_End_Date"].ToString();
if (d == " ")
{
DateTime startDate_new = DateTime.Now;
txtend_date.Text = startDate_new.ToShortDateString();
}
else
{
String s1;
DateTime startDate_new = DateTime.Parse(d);
s1 = startDate_new.AddDays(1).ToShortDateString();
DateTime startDate_new1 = DateTime.Parse(s1);
String myString_new = startDate_new1.ToString("yyyy-MM-dd");
txtstart_date.Text = myString_new;
String dateInString = txt_hr.Text;
DateTime r, r1;
DateTime startDate = DateTime.Parse(myString_new);
int totalnoofhr, oneday = 4;
totalnoofhr = Convert.ToInt32(dateInString);
double numofdays = Math.Ceiling((double)totalnoofhr / oneday);
r = AddWorkdays(startDate, numofdays - 1);
myString_new = r.ToString("yyyy-MM-dd");
txtend_date.Text = myString_new;
}
}
con.Close();
}
public static DateTime AddWorkdays(DateTime originalDate, double workDays)
{
DateTime tmpDate = originalDate;
while (workDays > 0)
{
tmpDate = tmpDate.AddDays(1);
if (tmpDate.DayOfWeek > DayOfWeek.Sunday)
workDays--;
}
return tmpDate;
}

these code will be work but start date also automatic in start day sunday will be count
0
Ankit Sharma9y ago
you are inserting values for each row manully.so while inserting first row ,store start date in seperate variable and then while inserting second row set startdate=varibalevalue+1;

e.g
date temp=start date;
start loop
insert values startdate=temp into table
temp =enddate.AddDays(1);
end loop
0
Sanjana Khalasi9y ago
But how can i implement my code is ..

con = new SqlConnection(str);
con.Open();
string sql = "insert into tbl_Job_Entry (Studio_Name,Couple_Name,No_Of_Hr,Job_Start_Date,Job_End_Date,Job_Type_Id,Emp_Id) values('" + txt_std_name.Text + "','" + txt_couple_name.Text + "','" + txt_hr.Text + "','" + txtstart_date.Text + "','" + txtend_date.Text + "','" + ddl_type.SelectedValue + "','" + ddle_name.SelectedValue + "'')";
cmd = new SqlCommand(sql, con);

cmd.ExecuteNonQuery();
Response.Redirect("View_Job_Entry.aspx");
con.Close();
0
Ankit Sharma9y ago
set job start date for second entry=job end date to first entry +1
0
Sanjana Khalasi9y ago
Hello,
Suppose in first entry Start date is 01/09/2017 and end date is 12/09/2017 then how to change second entry is automatic after 12/09/2017
0
Sanjana Khalasi9y ago
Thank u so much..it works Correctly..
0
Ankit Sharma9y ago
Hi Sanjana,

use below code
public static void test()
       {
           String dateInString = "33";

           DateTime startDate = DateTime.Parse("03/09/2017");
           int totalnoofhr, oneday = 4;
           totalnoofhr = Convert.ToInt32(dateInString);
           double numofdays = Math.Ceiling((double)totalnoofhr / oneday);
           DateTime r = AddWorkdays(startDate, numofdays - 1);

           String myString_new = r.ToString("yyyy-MM-dd");

           lbl_show.Text = myString_new;
       }
       public static DateTime AddWorkdays(DateTime originalDate, double workDays)
       {
           DateTime tmpDate = originalDate;
           while (workDays > 0)
           {
               tmpDate = tmpDate.AddDays(1);
               if (tmpDate.DayOfWeek > DayOfWeek.Sunday)
                   workDays--;
           }
           return tmpDate;
       }
Hope this helps
0
Sanjana Khalasi9y ago
String dateInString = txtnohr.Text;
DateTime r, r1;

DateTime startDate = DateTime.Parse(txt_startDate.Text);

int totalnoofhr, oneday = 4;

totalnoofhr = Convert.ToInt32(dateInString);

int numofdays = totalnoofhr / oneday;

r = startDate.AddDays(numofdays - 1);

String myString_new = r.ToString("yyyy-MM-dd");

lbl_show.Text = myString_new;

These code will be working but not exact maner it means i will enter hours 8 then it will coumt 2 days correctly but i will enter 9 or 10 then it will steel count 2 days and i dont want to count sunday plz help me....
0
Ankit Sharma9y ago
Hi Sanjana,
As per my understanding of your question, you want to add hours in input date and find the output date, where total number of hours in one day is 4.
You can use following code
          String dateInString = txtnohr.Text;

          DateTime startDate = DateTime.Parse("01/01/2017");
          int totalnoofhr, oneday = 4;
          totalnoofhr = Convert.ToInt32(dateInString);
          int numofdays = totalnoofhr / oneday;

          DateTime r = startDate.AddDays(numofdays - 1);

          String myString_new = r.ToString("yyyy-MM-dd")

          lbl_show.Text = myString_new;
Hope this helps
0
Amit Gupta9y ago
If I understood your question correctly, are you asking to calculate the total no of hours between 2 dates where no of hours in a day is 4

Is it like that?
0