employee hours calculation in c#.

Amit

11y10.8kVisual Basic .NET

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 < dt1.Rows.Count; 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 { }

}

10 Replies

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

Piyush Pansuriya11y ago
first you have to check in database employee and datewise IN entry.
if It is not exist than you have to give message.
0
Amit11y ago
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_code,emp_name,InOut,ToDate)values("");
con.Open();
cmd = new OleDbCommand(qur, con);
0
Pradeep11y ago
Try This....

if (dt1.Rows.Count > 0)
{
int InCount=0;
int OutCount=0;
for (int j = 0; j < dt1.Rows.Count; 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 < arrInTime.Length; i++){
duration += (DateTime.Parse(arrInTime[i]).Subtract(DateTime.Parse(arrOutTime[i])).Duration());
}
}
}
0
Amit11y ago
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;

}
0
Amit11y ago
Piyush Pansuriya

Thanku sir...
0
Piyush Pansuriya11y ago
Try it once :

if (dt1.Rows.Count > 0)
{
for (int j = 0; j < dt1.Rows.Count; 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 { }
}
0
Amit11y ago
hello Piyush Pansuriya

when 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.
0
Piyush Pansuriya11y ago
And what my code is give you?
0
Amit11y ago
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.
0
Piyush Pansuriya11y ago
Hello, Try this :

if (dt1.Rows.Count > 0)
{
for (int j = 0; j < dt1.Rows.Count; 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 { }
}
0