public ActionResult V2([FromUri] DALGetRefsInputParams inputParams)
{
inputParams.TryLoadFromCookies(System.Web.HttpContext.Current.Request);
DALGetRefsInputParams.ThrowIfWrong(inputParams);
return(View(inputParams));
}
public Graph GetRefs([FromUri] DALGetRefsInputParams inputParams)
{
try
{
inputParams.TryLoadFromCookies(HttpContext.Current.Request);
DALGetRefsInputParams.ThrowIfWrong(inputParams);
#region [.check exists root-tables.]
if (inputParams.RootTableNamesSet.Any())
{
var tableCollection = GetTablesInternal(inputParams);
foreach (var rootTableName in inputParams.RootTableNamesSet)
{
if (!tableCollection.Contains(rootTableName))
{
throw (new TableNotExistsException(rootTableName));
}
}
}
#endregion
#if USE_CACHE
var refs = HttpContext.Current.Cache.Get(
inputParams.ConnectionString + '-' + inputParams.RootTableNames
, () => DAL.GetRefs(inputParams));
#else
var refs = DAL.GetRefs(inputParams);
#endif
if (!refs.Any())
{
if (inputParams.RootTableNamesSet.Any())
{
throw (new RefsNotFoundException(inputParams.RootTableNamesSet));
}
foreach (var rootTableName in inputParams.RootTableNamesSet)
{
refs.Add(RefItem.CreateForSingleTable(rootTableName));
}
}
var nodes = new Dictionary <string, Node>();
var links = new HashSet <Link>(new LinkEqualityComparer());
#region [.create-graph-nodes-&-links.]
var node_id = 0;
var link_id = 0;
if (inputParams.RootTableNamesSet.Any())
{
foreach (var rootTableName in inputParams.RootTableNamesSet)
{
//var linksTotal = refs.Count( it => it.Level <= 2 && it.TableName == rootTableName );
var centerNode = new Node(node_id, rootTableName, true);
nodes.Add(centerNode.Name, centerNode);
node_id++;
}
}
else
{
var rootTableName = refs.FirstOrDefault().ForeignTableName;
if (rootTableName.IsNullOrWhiteSpace())
{
throw (new RefsNotFoundException(inputParams.RootTableNamesSet));
}
//var linksTotal = refs.Count( it => it.Level <= 2 && it.TableName == rootTableName );
var centerNode = new Node(node_id, rootTableName, true);
nodes.Add(centerNode.Name, centerNode);
node_id++;
}
var tables = (from it in refs
select it.TableName
).Concat
(from it in refs
select it.ForeignTableName
);
foreach (var table in tables)
{
if (!nodes.ContainsKey(table))
{
var node = new Node(node_id, table);
nodes.Add(node.Name, node);
node_id++;
}
}
var grouped_refs = from it in refs
group it by it.FKName into g
select g;
foreach (var g in grouped_refs)
{
var it = g.First();
var node_1 = nodes[it.ForeignTableName];
var node_2 = nodes[it.TableName];
link_id++;
var link = new Link(link_id)
{
SourceNode = node_1.Id,
TargetNode = node_2.Id,
SourceFields = from _it in g select _it.ForeignColumn,
TargetFields = from _it in g select _it.Column,
};
links.Add(link);
/*var success = links.Add( link );
* if ( !success )
* System.Diagnostics.Debugger.Break();*/
}
#endregion
var graph = new Graph()
{
links = links,
nodes = nodes.Values,
documents = new string[0], //model.Documents.Select( fi => fi.Name ),
linksTotalCount = 0, //model.AllMTSTermLinksCount,
nodesTotalCount = 0, //model.AllMTSTermsCount,
};
CalcGraphCoords(graph, inputParams.GraphWidth, inputParams.GraphHeight);
return(graph);
}
catch (TableNotExistsException ex)
{
return(Graph.CreateError("Table with name '" + ex.TableName + "' not exists"));
}
catch (RefsNotFoundException ex)
{
var error = ex.RootTableNames.Any()
? ("Reference from table " + ex.RootTableNames.Join('\'', '\'', "','") + " not found")
: "Any tables not found";
return(Graph.CreateError(error));
}
catch (Exception ex)
{
return(Graph.CreateError(ex));
}
}