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