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();
}
