public async Task <ActionResult> UpdateDraftAsync(int id, [FromBody] PurchaseRequestDTO purchaseRequestDto, CancellationToken cancellationToken = default) { InitUserInfo(); if (!AllowCreate && !AllowUpdate) { return(ValidationProblem()); } var specFilter = new PurchaseRequestFilterSpecification(int.Parse(purchaseRequestDto.Id), true); var rowCount = await _purchaseRequestService.CountAsync(specFilter, cancellationToken); if (rowCount == 0) { throw new EntityNotFoundException(nameof(PurchaseRequest), purchaseRequestDto.Id); } var purchaseRequest = _mapper.Map <PurchaseRequest>(purchaseRequestDto); var result = await _purchaseRequestService.PatchDraft(purchaseRequest, cancellationToken); if (!result) { AssignToModelState(_purchaseRequestService.Errors); return(ValidationProblem()); } return(CreatedAtAction(nameof(GetIdAsync), new { id = id }, null)); }
private async Task <PurchaseRequest> GetByIdAsync(int id, bool includeChilds = false, CancellationToken cancellationToken = default) { var specFilter = new PurchaseRequestFilterSpecification(id, true); var purchaseRequest = await _unitOfWork.PurchaseRequestRepository.FirstOrDefaultAsync(specFilter, cancellationToken); if (purchaseRequest == null || includeChilds == false) { return(purchaseRequest); } var purchaseRequestDetailsFilter = new PurchaseRequestDetailFilterSpecification() { PurchaseRequestIds = new List <int>() { id }, ShowDraftList = BaseEntity.DraftStatus.All }.BuildSpecification(); var purchaseRequestDetailss = await _unitOfWork.PurchaseRequestDetailRepository.ListAsync(purchaseRequestDetailsFilter, null, cancellationToken); purchaseRequest.AddRangePurchaseRequestDetails(purchaseRequestDetailss.ToList()); return(purchaseRequest); }
public async Task <string> GenerateExcel(string excelFilename, int?refId = null, int?id = null, DateTime?prDateFrom = null, DateTime?prDateTo = null, List <string> prNos = null, List <string> remarkss = null, Dictionary <string, int> exact = null, CancellationToken cancellationToken = default) { try { PurchaseRequestFilterSpecification filterSpec = null; if (id.HasValue) { filterSpec = new PurchaseRequestFilterSpecification(id.Value); } else { filterSpec = new PurchaseRequestFilterSpecification(exact) { Id = id, PrDateFrom = prDateFrom, PrDateTo = prDateTo, PrNos = prNos, Remarkss = remarkss } }.BuildSpecification(); var results = await this.ListAsync(filterSpec, null, true, cancellationToken); cancellationToken.ThrowIfCancellationRequested(); if (ExcelMapper.WriteToExcel <PurchaseRequest>(excelFilename, "purchaseRequest.json", results) == false) { if (refId.HasValue) { await _downloadProcessService.FailedToGenerate(refId.Value, "Failed to generate excel file"); } return(""); } // update database information (if needed) if (refId.HasValue) { excelFilename = Path.GetFileName(excelFilename); await _downloadProcessService.SuccessfullyGenerated(refId.Value, excelFilename); } return(excelFilename); }
public async Task <ActionResult> UpdateAsync([FromBody] PurchaseRequestDTO purchaseRequest, CancellationToken cancellationToken) { InitUserInfo(); if (!AllowUpdate) { return(ValidationProblem()); } var specFilter = new PurchaseRequestFilterSpecification(int.Parse(purchaseRequest.Id), true); var rowCount = await _purchaseRequestService.CountAsync(specFilter, cancellationToken); if (rowCount == 0) { throw new EntityNotFoundException(nameof(PurchaseRequest), purchaseRequest.Id); } // bind to old item foreach (var item in purchaseRequest.PurchaseRequestDetails) { if (!int.TryParse(item.Id, out _)) { item.Id = "0"; } if (!int.TryParse(item.PurchaseRequestId, out _)) { item.PurchaseRequestId = "0"; } } var objItem = _mapper.Map <PurchaseRequest>(purchaseRequest); // untuk data yang mereference object, perlu di set null agar tidak insert sebagai data baru CleanReferenceObject(objItem); var result = await _purchaseRequestService.UpdateAsync(objItem, cancellationToken); if (!result) { AssignToModelState(_purchaseRequestService.Errors); return(ValidationProblem()); } return(CreatedAtAction(nameof(GetIdAsync), new { id = objItem.Id }, null)); }