employee hours calculation in c#.

Question

hello sir i want to calculate total working hours of employee in c#. like IN=10:00 OUT=12:00 IN:1:00 OUT:5:00 duration=2+5=7; below code calculate only last in and out duration i want all in and out dueation time. if (dt1.Rows.Count > 0) { for (int j = 0; j { DateDay = Convert.ToDateTime(dt1.Rows[j][emp_ToDate]); string st = dt1.Rows[j][emp_InOut].ToString(); string time1 = (dt1.Rows[j][emp_Time]).ToString(); if (st == (IN)) { Input = Convert.ToString((time1)); }else if (st == OUT) { Output = Convert.ToString((time1)); } try { duration2 = duration + (DateTime.Parse(Input).Subtract(DateTime.Parse(Output)).Duration()); } catch { } }

Piyush Pansuriya · Answer

first you have to check in database employee and datewise IN entry. if It is not exist than you have to give message.

amol · Answer

hello Piyush Pansuriya i want to add message when employee click on OUT radio button and display message your input entry is not present first in then out .how to check in in database and display message.. i have following code. string Input= ; if (radioButton1.Checked == true) { Input = IN; } else { string qur1 = update Record set Out where Out=' + radioButton2.Checked + ' ; Input= OUT; } con.Close(); string qur = insert into Record(emp_codeemp_nameInOutToDate)values(); con.Open(); cmd = new OleDbCommand(qur con);

Pradeep · Answer

Try This.... if (dt1.Rows.Count > 0) { int InCount=0; int OutCount=0; for (int j = 0; j { DateDay = Convert.ToDateTime(dt1.Rows[j][emp_ToDate]); string st = dt1.Rows[j][emp_InOut].ToString(); string time1 = (dt1.Rows[j][emp_Time]).ToString(); string[] arrInTime= new string[(dt1.Rows.Count)/2]; string[] arrOutTime= new string[(dt1.Rows.Count)/2]; if (st == (IN)) { arrInTime[InCount]=time1; } else if (st == OUT) { arrOutTime[OutCount]=time1; } for (int i = 0; i duration += (DateTime.Parse(arrInTime[i]).Subtract(DateTime.Parse(arrOutTime[i])).Duration()); } } }

amol · Answer

hello hello Piyush Pansuriya i have multiple IN and OUT in my same row column .i want to fetch first In and compare with my maintime=10:00 .If IN is grater than my maintime save late mark in database . i have this code . i want first in from column. when i use this code he get last In from table and compare. My IN time is in 10:30 PM format i have split this in following format. string[] PT = Input.Split(Convert.ToChar( )); string T=PT[0]; string w = T.Split(Convert.ToChar(:)); string IT =Convert.ToInt32( w[0]); if(IT>10) { status=LATE; }

amol · Answer

Piyush Pansuriya T hanku sir...

Piyush Pansuriya · Answer

Try it once : if (dt1.Rows.Count > 0) { for (int j = 0; j { DateDay = Convert.ToDateTime(dt1.Rows[j][emp_ToDate]); string st = dt1.Rows[j][emp_InOut].ToString(); string time1 = (dt1.Rows[j][emp_Time]).ToString(); if (st == (IN)) { Input = Convert.ToString((time1)); }else if (st == OUT) { Output = Convert.ToString((time1)); } try { duration += (DateTime.Parse(Input).Subtract(DateTime.Parse(Output)).Duration()); Input = Output = null; } catch { } }

amol · Answer

hello Piyush Pansuriya w hen my second loop get second IN that time add previous out time also i dont want this .i want only first in and out + second in and out + third In and Out.when i get second in then first out get clear.

Piyush Pansuriya · Answer

And what my code is give you?

amol · Answer

hello Piyush Pansuriya i want to calculate duration of number of in and out time . when employee in and out in company many times and calculate total duration he work in company from in and out time . if IN=10 out=12 duration is 2 IN=1 out=5 duration 5 total duration is 5+2 in one variable .if number of time in and out in database i want to calculate the total duration. my code code ony give me a last in and out time.

Piyush Pansuriya · Answer

Hello Try this : if (dt1.Rows.Count > 0) { for (int j = 0; j { DateDay = Convert.ToDateTime(dt1.Rows[j][emp_ToDate]); string st = dt1.Rows[j][emp_InOut].ToString(); string time1 = (dt1.Rows[j][emp_Time]).ToString(); if (st == (IN)) { Input = Convert.ToString((time1)); }else if (st == OUT) { Output = Convert.ToString((time1)); } try { duration += (DateTime.Parse(Input).Subtract(DateTime.Parse(Output)).Duration()); } catch { } }