public GetAttendanceStatus CheckAttendanceDetailes(string SessionId, string SessionValue, string Date)
{
var attendanceStatus = new GetAttendanceStatus { Status = false };
if ((string.IsNullOrEmpty(SessionId)) && (string.IsNullOrEmpty(SessionValue))) return attendanceStatus;
var sessionId = LeaveRegisterUtils.DecryptPassword(SessionId);
var sessionValue = LeaveRegisterUtils.DecryptPassword(SessionValue);
if (!DataBaseUtils.IsEmployeeLoggedIn(ConnectionString, sessionId, sessionValue))
{
return attendanceStatus;
}
var employeeId = DataBaseUtils.GetEmployeeId(ConnectionString, sessionId);
return DataBaseUtils.GetAttendanceStatus(ConnectionString, employeeId, Date);
}
/// <summary>
/// Get Attendance Status by selecting date
/// </summary>
public static GetAttendanceStatus GetAttendanceStatus(string ConnectionString, string EmployeeId, string Date)
{
var attendanceStatus = new GetAttendanceStatus();
var con = new SqlConnection(ConnectionString);
try
{
using (var cmd = new SqlCommand(StoreProcedureGetAtteendaceStatus, con))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployeeID", SqlDbType.VarChar).Value = EmployeeId;
cmd.Parameters.Add("@SelecteDDate", SqlDbType.Date).Value = LeaveRegisterUtils.FoamteDate(Date);
con.Open();
var dr = cmd.ExecuteReader();
if (dr.Read())
{
attendanceStatus.AttendanceStatus = dr["AttendanceStatus"].ToString();
attendanceStatus.TotalWorked = Convert.ToInt32(dr["TotalWorked"].ToString());
attendanceStatus.Status = true;
}
con.Close();
}
return attendanceStatus;
}
}
catch (Exception)
{
return attendanceStatus;
}
}
