public async Task <IActionResult> GetAllOvertimeListFilter() { string userId = _httpContextAccessor.HttpContext.Request.Cookies["UserId"]; string durum = HttpContext.Request.Query["durum"].ToString(); GetAllOvertimeListResponse response = _iPP_OTService.GetAllOvertimeListFilter(Convert.ToInt32(userId), durum); return(Ok(response)); }
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 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 GetAllOvertimeListResponse GetAllOvertimeListFilter(int UserId, string Durum) { GetAllOvertimeListResponse response = new GetAllOvertimeListResponse(); DateTime now = DateTime.Now; //List<sp_SSH_GetSkuBySerial> machineDetail = _dbContext.sp_SSH_GetSkuBySerial.FromSqlInterpolated($"EXECUTE dbo.sp_SSH_GetSkuBySerial {serialNo}").ToList(); var UserData = context.TblUsersRepository.Get().SingleOrDefault(q => q.UserId == 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.Confirmation == Durum).OrderByDescending(q => q.CreatedDate).ToList(); response.AllOvertimeList = OvertimeListFillter; if (OvertimeListFillter != null && OvertimeListFillter.Count > 0) { response.isSuccess = true; response.ErrorMessage = ""; } else { response.isSuccess = false; response.ErrorMessage = "Hata oluştu tekrar deneyiniz!"; } } else { var OvertimeList = _dbContext.vFMList.Where(q => q.CreatedDate.Value.Year == now.Year && q.Confirmation == Durum).OrderByDescending(q => q.CreatedDate).ToList(); response.AllOvertimeList = OvertimeList; if (OvertimeList != null && OvertimeList.Count > 0) { response.isSuccess = true; response.ErrorMessage = ""; } else { response.isSuccess = false; response.ErrorMessage = "Hata oluştu tekrar deneyiniz!"; } } return(response); }