private async Task <GenericServiceResponse> InsertAuditRecordAsync(LogCommand logCommand, PayloadParent payload, string objectFullName, string lastModifiedBy) { var response = new GenericServiceResponse(); var cdcAuditEnity = new CdcAuditEntity { AuditLogGuid = Guid.NewGuid(), CreatedById = payload.CreatedById, CreatedDate = payload.CreatedDate, EventType = payload.EventTypeC, ObjectType = objectFullName, LastModifiedById = lastModifiedBy, LastModifiedDate = DateTime.Now, RecordId = payload.RecordIdC, }; var auditResponse = await _cdcRepository.InsertAuditRecord(cdcAuditEnity, logCommand); if (auditResponse == 1) { response.Success = true; } return(response); }
public async Task <int> InsertAuditRecord(CdcAuditEntity auditEntity, LogCommand logCommand) { //Logging Helper for Method var method_name = "InsertAuditRecord"; var query = " insert into [CDCQueue].[AuditLog] " + " ([AuditLogGuid] " + ", [ObjectType] " + ", [RecordID] " + ", [EventType] " + ", [CreatedDate] " + ", [CreatedById] " + ", [LastModifiedDate] " + ", [LastModifiedById]) " + " Values " + " (@AuditLogGuid, @ObjectType, @RecordID, @EventType, @CreatedDate, @CreatedById, @LastModifiedDate, @LastModifiedById); "; //Log the input logCommand.LogMessage = $"{Repository}.{method_name} Starting input parameters _Lead = {JsonConvert.SerializeObject(auditEntity)}" + Environment.NewLine + $"Query: {query}"; _logHandler.HandleLog(logCommand); using (var connection = _connectionFactory.GetConnection) { //Await the response var returnValue = await connection.ExecuteAsync(query, auditEntity); connection.Close(); //Log the output logCommand.LogMessage = $"{Repository}.{method_name} completed"; _logHandler.HandleLog(logCommand); return(returnValue); } }