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