public bool IsEmployeeAvailable(int empID, DateTime startTime, DateTime endTime) { string dayOfWeek = startTime.DayOfWeek.ToString(); var dayAvailability = UseDB.SelectDailyAvailabily(empID, dayOfWeek); if (startTime.TimeOfDay >= dayAvailability.StartTime && endTime.TimeOfDay <= dayAvailability.EndTime) { return(true); } else { return(false); } }