private void GenerateConnectors(string connectionString)
{
var db = new Data1.CloudCoreDB(connectionString);
var connectors = (from f in db.Cloudcoremodel_FlowModel
join fa in db.Cloudcoremodel_ActivityModel on f.FromActivityModelId equals fa.ActivityModelId
join t in db.Cloudcoremodel_SubProcess on fa.SubProcessId equals t.SubProcessId
join p in db.Cloudcoremodel_ProcessRevision on t.ProcessRevisionId equals p.ProcessRevisionId
where RevisionId == p.ProcessRevisionId
select new
{
Title = f.Outcome == "-" ? String.Empty : f.Outcome,
FromId = f.FromActivityModelId,
ToId = f.ToActivityModelId,
OptimalFlow = f.OptimalFlow,
NegativeFlow = f.NegativeFlow,
HasTrigger = (bool)db.Cloudcore_FlowHasTrigger(f.FlowGuid)
}).Distinct();
foreach (var connector in connectors)
{
var con = new Connector()
{
Title = connector.Title,
FromActivityId = connector.FromId,
ToActivityId = connector.ToId
};
if (connector.OptimalFlow)
{
con.AddProperty(ConnectorProperties.Optimal);
}
if (connector.NegativeFlow)
{
con.AddProperty(ConnectorProperties.Negative);
}
if (connector.HasTrigger)
{
con.AddProperty(ConnectorProperties.Trigger);
}
Connectors.Add(con);
}
}
