create following store procedure and call it in your method,
CREATE PROCEDURE [dbo].[GetEmployeeStatus] @EmpId INT,@StartDate datetime
,@endDate datetimeASBEGIN SET NOCOUNT ON; SELECT attendance_record.empid,
attendance_record.rec_date ,leave_record.leave_purpose
,(CASE WHEN attendance_record.rec_date BETWEEN leave_record.startdate AND leave_record.endDate THEN'absent' ELSE 'present'END) AS result
FROM attendance_record
INNER JOIN leave_record ON attendance_record.empid = leave_record.empid
WHERE attendance_record.rec_date BETWEEN @startDate AND @endDateEND