public static TimeClockObject GetLatestPunchTime(int EmpID)
{
TimeClockObject timeclock = new TimeClockObject();
string cmdtext = "Select TimeIn,Timeout from tblTimeCard" +
" where TimeCardID = (Select Max(TimeCardID) from tblTimeCard where" +
" EmployeeID = @EmployeeID)";
SqlConnection Dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings[TimeClockConnectionString].ToString());
SqlCommand cmd = new SqlCommand(cmdtext, Dbconn);
cmd.Parameters.Add(new SqlParameter("@EmployeeID", EmpID));
Dbconn.Open();
SqlDataReader dr = cmd.ExecuteReader();
try
{
if (dr.HasRows)
{
dr.Read();
if (dr[0].ToString() != "")
{
timeclock.Timein = dr.GetTimeSpan(dr.GetOrdinal("TimeIn"));
}
if (dr[1].ToString() != "")
{
timeclock.Timeout = dr.GetTimeSpan(dr.GetOrdinal("Timeout"));
}
}
}
catch (Exception ex)
{
string exception = ex.Message;
}
finally
{
Dbconn.Close();
Dbconn.Dispose();
}
return(timeclock);
}
public static void InsertTimeCard(String Type, TimeClockObject timeclock)
{
string cmdtext = "";
int punchtype = 0;
SqlConnection Dbconn = new SqlConnection(ConfigurationManager.ConnectionStrings["SSITimeClockMgrConnectionString"].ToString());
SqlCommand cmd = new SqlCommand(cmdtext, Dbconn);
if (Type == "I")
{
punchtype = 1;
}
else if (Type == "O")
{
punchtype = 2;
}
cmdtext = "sp_ClockInOut @employeeId,@PunchType,@DateIn,@Timein,@Dateout,@Timeout";
cmd.CommandText = cmdtext;
cmd.Parameters.Add(new SqlParameter("@employeeId", timeclock.EmployeeID));
cmd.Parameters.Add(new SqlParameter("@PunchType", punchtype));
if (timeclock.Datein != null)
{
cmd.Parameters.Add(new SqlParameter("@DateIn", timeclock.Datein));
cmd.Parameters.Add(new SqlParameter("@Timein", timeclock.Timein));
}
else
{
cmd.Parameters.Add(new SqlParameter("@DateIn", DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Timein", DBNull.Value));
}
if (timeclock.Dateout != null)
{
cmd.Parameters.Add(new SqlParameter("@DateOut", timeclock.Dateout));
cmd.Parameters.Add(new SqlParameter("@Timeout", timeclock.Timeout));
}
else
{
cmd.Parameters.Add(new SqlParameter("@DateOut", DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Timeout", DBNull.Value));
}
Dbconn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
string exception = ex.Message;
}
finally
{
Dbconn.Close();
Dbconn.Dispose();
}
}
