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