public IActionResult GetRelations([FromBody] TReportsRelationRequest request) { Log.Information("***Executando método 'GetRelations'***"); Log.Information("-----Leitura dos parâmetros -----" + System.Environment.NewLine); Log.Information(JsonConvert.SerializeObject(request)); Log.Information(System.Environment.NewLine); Log.Information("-----Fim da leitura dos parâmetros -----" + System.Environment.NewLine); try { TReportsRelationResponse response = new TReportsRelationResponse(); response = GetRelationsDto(request); return(Ok(response)); } catch (Exception ex) { Log.Error(ex.Message); Response.StatusCode = 500; return(Accepted(new TReportsCustomError() { code = "500", detailedMessage = ex.StackTrace, message = ex.Message })); } }
internal static void GetRelationshipTableInfo(TReportsRelationRequest request, TReportsRelationResponse response) { List <Relation> relations = new List <Relation>(); string childTable = "FILIAL"; string parentTable = "EMPRESA"; Relation relation = new Relation(); relation.ChildColumns = new List <ChildColumnElement>(); relation.ParentColumns = new List <ChildColumnElement>(); relation.RelationName = $"{parentTable}_{childTable}"; relation.ParentTableName = parentTable; relation.ChildTableName = childTable; relation.ParentColumns.Add(new ChildColumnElement() { ColumnName = "CODIGO" }); relation.ChildColumns.Add(new ChildColumnElement() { ColumnName = "CODIGO_EMPRESA" }); relations.Add(relation); relation = new Relation(); relation.ChildColumns = new List <ChildColumnElement>(); relation.ParentColumns = new List <ChildColumnElement>(); relation.RelationName = $"{parentTable}_{childTable}_2"; relation.ParentTableName = parentTable; relation.ChildTableName = childTable; relation.ParentColumns.Add(new ChildColumnElement() { ColumnName = "CODIGO" }); relation.ParentColumns.Add(new ChildColumnElement() { ColumnName = "PAIS" }); relation.ChildColumns.Add(new ChildColumnElement() { ColumnName = "CODIGO_EMPRESA" }); relation.ChildColumns.Add(new ChildColumnElement() { ColumnName = "PAIS" }); relations.Add(relation); Relation relation2 = new Relation(); relation2.ChildColumns = new List <ChildColumnElement>(); relation2.ParentColumns = new List <ChildColumnElement>(); relation2.RelationName = $"{parentTable}_{childTable}_xxx"; relation2.ParentTableName = parentTable; relation2.ChildTableName = childTable; relations.Add(relation2); relation2.ParentColumns.Add(new ChildColumnElement() { ColumnName = "CODIGO" }); relation2.ChildColumns.Add(new ChildColumnElement() { ColumnName = "CODIGO_EMPRESA" }); response.Relations = relations.ToArray(); }