public async Task <IActionResult> GetAllOvertimeList(OvertimeFilter OvertimeFilterRequest)
{
OvertimeFilterRequest.searchStartDate = OvertimeFilterRequest.searchStartDate == DateTime.MinValue ? DateTime.MinValue : OvertimeFilterRequest.searchStartDate;
OvertimeFilterRequest.searchEndDate = OvertimeFilterRequest.searchEndDate == DateTime.MinValue ? DateTime.MaxValue : OvertimeFilterRequest.searchEndDate;
OvertimeFilterRequest.UserId = _httpContextAccessor.HttpContext.Request.Cookies["UserId"];
GetAllOvertimeListResponse response = _iPP_OTService.GetAllOvertimeList(OvertimeFilterRequest);
return(Ok(response));
}
public GetAllOvertimeListResponse GetAllOvertimeList(OvertimeFilter OvertimeFilterRequest)
{
var request = new RestRequest("api/PP_OT/GetAllOvertimeList", Method.POST, DataFormat.Json)
.AddJsonBody(OvertimeFilterRequest);
var resp = Globals.ApiClient.Execute <GetAllOvertimeListResponse>(request);
return(resp.Data);
}
public IActionResult GetAllOvertimeList(OvertimeFilter request)
{
var response = _pp_otService.GetAllOvertimeList(request);
if (response.isSuccess == false)
{
return(null);
}
return(Ok(response));
}
public GetAllOvertimeListResponse GetAllOvertimeList(OvertimeFilter request)
{
request.searchStartDate = request.searchStartDate == DateTime.MinValue ? DateTime.MinValue : request.searchStartDate;
request.searchEndDate = request.searchEndDate == DateTime.MinValue ? DateTime.MaxValue : request.searchEndDate;
GetAllOvertimeListResponse response = new GetAllOvertimeListResponse();
DateTime now = DateTime.Now;
var UserData = context.TblUsersRepository.Get().SingleOrDefault(q => q.UserId == Convert.ToInt32(request.UserId));
if (UserData.UserAccount != "03316" && UserData.UserAccount != "03850")
{
var OvertimeListFillter = _dbContext.vFMList.Where(
q => q.CreatedDate.Value.Year == now.Year && q.CreatedBy == UserData.UserAccount &&
q.DepartmentName.Contains(request.searchDepartmentName == null ? "" : request.searchDepartmentName) &&
q.UsersEmployeeCode.Contains(request.searchUsersEmployeeCodeNo == null ? "" : request.searchUsersEmployeeCodeNo) &&
q.FULLNAME.Contains(request.searchFullname == null ? "" : request.searchFullname) &&
q.shiftName.Contains(request.searchShiftName == null ? "" : request.searchShiftName) &&
q.OvertimeTypeName.Contains(request.searchOvertimeTypeName == null ? "" : request.searchOvertimeTypeName) &&
q.Confirmation.Contains(request.searchConfirmation == null ? "" : request.searchConfirmation) &&
(q.OvertimeDateTime >= request.searchStartDate && q.OvertimeDateTime <= request.searchEndDate)
).OrderByDescending(q => q.CreatedDate).ToList();
var OvertimeListFillterSum = OvertimeListFillter.Sum(q => q.ShiftTime);
response.OvertimeSum = Convert.ToInt32(OvertimeListFillterSum);
response.AllOvertimeList = OvertimeListFillter;
response.isSuccess = true;
response.ErrorMessage = "";
}
else
{
var OvertimeList = _dbContext.vFMList.Where(
q => q.CreatedDate.Value.Year == now.Year &&
q.DepartmentName.Contains(request.searchDepartmentName == null ? "" : request.searchDepartmentName) &&
q.UsersEmployeeCode.Contains(request.searchUsersEmployeeCodeNo == null ? "" : request.searchUsersEmployeeCodeNo) &&
q.FULLNAME.Contains(request.searchFullname == null ? "" : request.searchFullname) &&
q.shiftName.Contains(request.searchShiftName == null ? "" : request.searchShiftName) &&
q.OvertimeTypeName.Contains(request.searchOvertimeTypeName == null ? "" : request.searchOvertimeTypeName) &&
q.Confirmation.Contains(request.searchConfirmation == null ? "" : request.searchConfirmation) &&
(q.CreatedDate >= request.searchStartDate && q.CreatedDate <= request.searchEndDate)
).OrderByDescending(q => q.CreatedDate).ToList();
response.AllOvertimeList = OvertimeList;
var OvertimeListSum = OvertimeList.Sum(q => q.ShiftTime);
response.OvertimeSum = Convert.ToInt32(OvertimeListSum);
response.isSuccess = true;
response.ErrorMessage = "";
}
return(response);
}
public ActionResult List(OvertimeFilter overtimeFilter, Paging paging, List <OrderBy> orderBy)
{
try
{
return(this.JsonNet(HRBusinessService.RetrieveOvertimes(UserOrganisationId, overtimeFilter, orderBy, paging)));
}
catch (Exception ex)
{
return(Json(ex));
}
}
