// support for listing and indexing a/the selected package
private List <T> list <T>(TSF_EA.Package package, GlossaryItemSearchCriteria criteria) where T : GlossaryItem, new()
{
if (package == null)
{
return(new List <T>());
}
return(this.factory.getGlossaryItemsFromPackage <T>(package, criteria));
}
private void showDataItems(Domain domain, GlossaryItemSearchCriteria searchCriteria)
{
var package = (TSF_EA.Package)domain?.dataItemsPackage;
if (package == null)
{
package = (TSF_EA.Package) this.settings.dataItemsPackage;
}
this.mainControl.setDataItems(this.list <DataItem>(package, searchCriteria), domain);
}
private void showBusinessItems(TSF_EA.Package package, Domain domain, GlossaryItemSearchCriteria searchCriteria)
{
if (domain == null)
{
domain = Domain.getDomain(package);
}
if (domain?.businessItemsPackage != null)
{
package = (TSF_EA.Package)domain.businessItemsPackage;
}
this.mainControl.setBusinessItems(this.list <BusinessItem>(package, searchCriteria), domain);
}
private void showItemsForDomain(Domain domain, GlossaryItemSearchCriteria criteria)
{
switch (this.mainControl.selectedTab)
{
case GlossaryTab.BusinessItems:
var package = domain != null
? (TSF_EA.Package)domain.businessItemsPackage
: (TSF_EA.Package) this.settings.businessItemsPackage;
this.showBusinessItems(package, domain, criteria);
break;
case GlossaryTab.DataItems:
this.showDataItems(domain, criteria);
break;
}
}
public List <T> getGlossaryItemsFromPackage <T>(TSF_EA.Package package, GlossaryItemSearchCriteria criteria) where T : GlossaryItem, new()
{
T dummy = new T(); // needed to get the stereotype
//build a search string
var sqlTop = criteria.showAll ? string.Empty : "top 50";
string sqlGetGlossaryItems = string.Format(@"select " + sqlTop + @" o.[Object_ID] from t_object o
where ( o.[Name] like '%{0}%' or o.[Name] is null )
and ( o.[Note] like '%{1}%' or o.[Note] is null )
and o.[Stereotype] = '{2}'
and o.[Package_ID] in ({3})",
criteria.nameSearchTerm,
criteria.descriptionSearchTerm,
dummy.Stereotype,
package.getPackageTreeIDString());
return(this.getGlossaryItemsFromQuery <T>(sqlGetGlossaryItems));
}
public List <T> getGlossaryItemsFromPackage <T>(TSF_EA.Package package, GlossaryItemSearchCriteria criteria) where T : GlossaryItem, new()
{
T dummy = new T(); // needed to get the stereotype
//build a search string
var sqlTop = criteria.showAll ? string.Empty : "top 50";
var nameClause = string.IsNullOrEmpty(criteria.nameSearchTerm) ?
$"(o.[Name] like '%{criteria.nameSearchTerm}%' or o.[Name] is null )"
: $"o.[Name] like '%{criteria.nameSearchTerm}%'";
var descriptionClause = string.IsNullOrEmpty(criteria.descriptionSearchTerm) ?
$"(o.[Note] like '%{criteria.descriptionSearchTerm}%' or o.[Note] is null )"
: $"o.[Note] like '%{criteria.descriptionSearchTerm}%'";
string sqlGetGlossaryItems = $"select {sqlTop} o.[Object_ID] from t_object o"
+ $" where {nameClause} "
+ $" and {descriptionClause} "
+ $" and o.[Stereotype] = '{dummy.Stereotype}' "
+ $" and o.[Package_ID] in ({ package.packageTreeIDString})";
return(this.getGlossaryItemsFromQuery <T>(sqlGetGlossaryItems));
}
