/// <summary>
        /// Get overtime in date
        /// </summary>
        /// <param name="date"></param>
        /// <returns></returns>
        /// CALL URL:  _vti_bin/Services/Overtime/OvertimeService.svc/GetOvertimeDetailByDate/4/3-24-2017
        public OvertimeEmployeeInDateModel GetOvertimeDetailByDate(string employeeLookupId, string date)
        {
            OvertimeEmployeeInDateModel overtimeData = new OvertimeEmployeeInDateModel {
                IsHasValue = false
            };

            try
            {
                int employeeLookupIdValue;
                var fromDateValue = date.ToMMDDYYYYDate(false); // mm-dd-yyyy
                var toDateValue   = date.ToMMDDYYYYDate(true);

                if (fromDateValue != DateTime.MinValue && int.TryParse(employeeLookupId, out employeeLookupIdValue))
                {
                    var overtimeDetail = _overTimeManagementDetailDAL.GetForEmployeeByDateRange(employeeLookupIdValue, fromDateValue, toDateValue);
                    var firstOvertime  = overtimeDetail.FirstOrDefault(x => (x.ApprovalStatus != null && Convert.ToString(x.ApprovalStatus.LookupValue).ToLower().Equals("true")));
                    if (firstOvertime != null)
                    {
                        overtimeData.FromHour   = firstOvertime.OvertimeFrom.Hour;
                        overtimeData.FromMinute = firstOvertime.OvertimeFrom.Minute;

                        overtimeData.ToHour     = firstOvertime.OvertimeTo.Hour;
                        overtimeData.ToMinute   = firstOvertime.OvertimeTo.Minute;
                        overtimeData.HourPerDay = firstOvertime.WorkingHours;

                        overtimeData.IsHasValue = true;
                    }
                }
                return(overtimeData);
            }
            catch (Exception ex)
            {
                ULSLogging.Log(new SPDiagnosticsCategory("STADA - Overtime Service - GetOvertimeDetailByDate fn",
                                                         TraceSeverity.Unexpected, EventSeverity.Error), TraceSeverity.Unexpected,
                               string.Format(CultureInfo.InvariantCulture, "{0}:{1}", ex.Message, ex.StackTrace));
                return(null);
            }
        }