public async Task <IActionResult> UploadRequisition(Guid projectId)
{
if (Request.Form.Files.Count == 0)
{
return(new UnsupportedMediaTypeResult());
}
var file = Request.Form.Files[0];
if (!file.ContentType.Contains("text/csv") && !file.ContentType.Contains("ms-excel"))
{
return(new UnsupportedMediaTypeResult());
}
if (file.Length == 0)
{
return(new UnsupportedMediaTypeResult());
}
CoupaImporterJobDefinitionDTO jobDefinitionDTO;
using (var memoryStream = new MemoryStream())
{
await file.CopyToAsync(memoryStream);
jobDefinitionDTO = _service.CreateRequisitionImportJobDefinition(projectId, memoryStream, file.FileName);
if (jobDefinitionDTO == null)
{
return(BadRequest(
"An error occurred while uploading the file, please try again or contact the system administrator."));
}
}
await _unitOfWork.SaveChangesAsync();
// Enqueue background job to import all data in Requisition table
_backgroundJobClient.Enqueue(() => _service.ProcessRequisitionImportJob(jobDefinitionDTO.Id));
return(Ok(jobDefinitionDTO));
}
public void ProcessRequisitionImportJob_JobId_ProcessEachLineOfPurchaseOrderJobDetailsAndChangesItsStatusToProcessed()
{
//Arrange
var jobDefinitionId = new Guid("45744a2e-3dc1-472f-9bb5-378a0a9eeda4");
var jobDefinition = new CoupaImporterJobDefinition
{
Id = jobDefinitionId,
FileName = "Test.csv",
Status = (int)CoupaImporterStatus.Pending,
CoupaImporterJobDefinitionDetails = new List <CoupaImporterJobDefinitionDetail>
{
new CoupaImporterJobDefinitionDetail
{
Id = new Guid("90d18a32-5090-4091-9c16-91dcb7983c38"),
IsProcessed = false,
IsSuccessful = null,
ErrorDescription = null,
LineNumber = 1,
RawContent = "{\"Id\":\"54a85421-ab58-4fef-ae4c-ab5651501291\",\"ProjectId\":\"00000000-0000-0000-0000-000000000000\",\"PurchaseOrderNumber\":7116,\"OrderTotal\":7630.0,\"AccountingTotal\":5608.64,\"Account\":\"6063-521-5412424-203050-SN-00000-000-000\",\"Supplier\":\"MEDIALINK PRINTING SERVICES PTE LTD\",\"OrderDate\":\"2019-05-05T00:00:00\",\"Item\":\"Q2 printing of brochures and placemats for SG Banks\",\"AccountingTotalCurrency\":\"USD\",\"Currency\":\"SGD\",\"ShippingAddress\":\"Twenty Anson, 20 Anson Road\n#18-01 Singapore 079912 Singapore\", \"ProjectDescription\":null, \"Commodity\":\"Mktg Print & Fulfillment (5412424 Print - Marketing Collateral)\", \"CostCode\":null, \"FixedAsset_CIPCategory\":null, \"TargetLocationCode\":null, \"ShipTo\":\"Andy Lim\", \"RequestedBy\":\"Andy Lim\", \"CreatedBy\":\"Doris Ma\", \"LastUpdatedBy\":\"Doris Ma\"}"
},
new CoupaImporterJobDefinitionDetail
{
Id = new Guid("35246731-7870-400d-a646-456e5f824df7"),
IsProcessed = false,
IsSuccessful = null,
ErrorDescription = null,
LineNumber = 2,
RawContent = "{\"Id\":\"97647256-c8f1-4065-babb-670e7943a04b\",\"ProjectId\":\"00000000-0000-0000-0000-000000000000\",\"PurchaseOrderNumber\":7117,\"OrderTotal\":16100.0,\"AccountingTotal\":2052.22,\"Account\":\"6063-521-5412424-203050-SN-00000-000-000\",\"Supplier\":\"HETERMEDIA SERVICES LIMITED\",\"OrderDate\":\"2019-05-05T00:00:00\",\"Item\":\"Quarterly Update of Marketing Collaterals - Q2\",\"AccountingTotalCurrency\":\"USD\",\"Currency\":\"HKD\",\"ShippingAddress\":\"Twenty Anson, 20 Anson Road\\n#18-01\nSingapore 079912\nSingapore\",\"ProjectDescription\":null,\"Commodity\":\"Mktg Print & Fulfillment (5412424 Print - Marketing Collateral)\",\"CostCode\":null,\"FixedAsset_CIPCategory\":null,\"TargetLocationCode\":null,\"ShipTo\":\"Andy Lim\",\"RequestedBy\":\"Andy Lim\",\"CreatedBy\":\"Karen Leung\",\"LastUpdatedBy\":\"Karen Leung\"}"
}
}
};
_coupaImporterRepository.Get(jobDefinitionId)
.Returns(jobDefinition);
//Act
var response = _service.ProcessRequisitionImportJob(jobDefinitionId);
//Assert
Assert.AreEqual(CoupaImporterStatus.Processed, response.Status);
Assert.IsEmpty(response.CoupaImporterJobDefinitionDetails.Where(d => d.IsProcessed == false));
_coupaImporterRepository.Received(1)
.UpdateAllJobDefinitionDetail(
jobDefinition.Id,
Arg.Is <List <CoupaImporterJobDefinitionDetail> >(d =>
d.First().Id == jobDefinition.CoupaImporterJobDefinitionDetails.First().Id&&
d.First().IsSuccessful == true && d.First().IsProcessed == true));
_coupaImporterRepository.Received(1)
.UpdateAllJobDefinitionDetail(
jobDefinition.Id,
Arg.Is <List <CoupaImporterJobDefinitionDetail> >(d =>
d.First().Id == jobDefinition.CoupaImporterJobDefinitionDetails.First().Id&&
d.Last().IsSuccessful == true && d.Last().IsProcessed == true));
_coupaImporterRepository.Received(1)
.Update(jobDefinitionId,
Arg.Is <CoupaImporterJobDefinition>(j =>
j.Id == jobDefinitionId && j.Status == (int)CoupaImporterStatus.Processed));
}