Count No of hores

Question

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 { 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; }

Ankit Sharma · Answer

you already have AddWorkDays method just pass start day and 1 to it. you will get correct output.

Sanjana Khalasi · Answer

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...

Ankit Sharma · Answer

put your source code and start a new thread.... people will help you i a bit busy now

Sanjana Khalasi · Answer

steel not working...

Sanjana Khalasi · Answer

but how can i implement plz help me...

Ankit Sharma · Answer

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.

Sanjana Khalasi · Answer

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 ..soi want 19/09/2017

Ankit Sharma · Answer

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?

Sanjana Khalasi · Answer

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

Ankit Sharma · Answer

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

Sanjana Khalasi · Answer

But how can i implement my code is .. con = new SqlConnection(str); con.Open(); string sql = insert into tbl_Job_Entry (Studio_NameCouple_NameNo_Of_HrJob_Start_DateJob_End_DateJob_Type_IdEmp_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();

Ankit Sharma · Answer

set job start date for second entry=job end date to first entry +1

Sanjana Khalasi · Answer

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

Sanjana Khalasi · Answer

Thank u so much..it works Correctly..

Ankit Sharma · Answer

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

Sanjana Khalasi · Answer

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....

Ankit Sharma · Answer

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

Amit Gupta · Answer

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?