public async Task <ActionResult> Post([FromForm] RequestModel requestModel) { if (requestModel.formFile == null) { ModelState.AddModelError("formFile", "Please upload the file."); return(BadRequest(ModelState)); } var result = await _fileParser.Read(requestModel.formFile.OpenReadStream()); var entities = result .Where(y => y.TotalSalesAmount > requestModel.minimumSalesAmount && y.Timestamp < DateTimeOffset.UtcNow) .Select(x => new CustomerSales() { CustomerId = x.CustomerId, CustomerName = x.CustomerName, CustomerType = x.CustomerType, TotalSalesAmount = x.TotalSalesAmount, Timestamp = x.Timestamp, CreatedOn = DateTimeOffset.UtcNow, UpdatedOn = DateTimeOffset.UtcNow }).ToList(); await _dbContext.AddRangeAsync(entities); _dbContext.SaveChanges(); return(Ok()); }