public ActionResult <ObjectResult> Audit([FromBody] AuditDTO auditDTO) { try { OrderService orderService = new OrderService(Startup.BeePlaceDataBaseConnectionString); OrderItemAudit orderItemAudit = new OrderItemAudit(); orderItemAudit.IdOrderItem = auditDTO.IdOrderItem; orderItemAudit.Name = auditDTO.Name; orderItemAudit.Type = auditDTO.Type; orderItemAudit.FilePath = auditDTO.FilePath; orderItemAudit.DateCreated = DateTime.Now; orderItemAudit.DateUpdated = DateTime.Now; orderService.CreateAudit(orderItemAudit); return(StatusCode((int)HttpStatusCode.OK)); } catch (Exception e) { return(StatusCode((int)HttpStatusCode.InternalServerError)); } }
/// <summary> /// Cria um registro de auditoria com fotos de antes e depois de cada serviço no pedido. /// </summary> /// <param name="order"></param> public void CreateAudit(OrderItemAudit orderItemAudit) { string connection = "DefaultEndpointsProtocol=https;AccountName=genesissalesstorage;AccountKey=9n93XTGDxNLDzsX0FKyChCQsVFFrgmbWYDBjj7o4Hv0lAoAhEBTEOlQQzSnN2IFCw8yq2Mf8P/OZT7TNYBHP9w=="; string container = "bplace"; using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew)) { try { StandartPersistence standartPersistence = new StandartPersistence(this.Connection); var blob = AzureBlobStorage.Upload(orderItemAudit.FilePath, orderItemAudit.Name, connection, container); if (blob != null) { orderItemAudit.URL = blob.StorageUri.PrimaryUri.AbsoluteUri; orderItemAudit.DateCreated = DateTime.Now; orderItemAudit.DateUpdated = DateTime.Now; standartPersistence.Insert <OrderItemAudit>(orderItemAudit); } else { throw new System.Exception("Falha no processo de Upload de arquivos no AzureBlobStorage."); } transactionScope.Complete(); } catch (SqlException e) { throw e; } catch (TransactionException e) { throw e; } } }