internal static List <FeatureModel> GetRelatedFeatures(TableDropdownDataContext selectedItem, object[] objarray)
{
List <FeatureModel> results = new List <FeatureModel>();
int idx = selectedItem.Fields.IndexOf(selectedItem.Fields.Find(x => x.ToUpper().Equals("OBJECTID", StringComparison.InvariantCultureIgnoreCase)));
ITable table = selectedItem.Value as ITable;
if (table != null)
{
IRow aRow = table.GetRow(Convert.ToInt32(objarray[idx]));
TableHelper th = TableHelper.Instance;
th.RelationLookup[selectedItem.Value.Name].ForEach(x => {
IObject aRowObj = aRow as IObject;
if (aRowObj != null)
{
ISet aSet = x.GetObjectsRelatedToObject(aRowObj);
object obj = null;
if (aSet.Count > 0)
{
while ((obj = aSet.Next()) != null)
{
IFeature aFeat = obj as IFeature;
if (!results.Any(z => z.Feature.Class.ObjectClassID == aFeat.Class.ObjectClassID && z.ObjectID == aFeat.OID))
{
results.Add(new FeatureModel {
ObjectID = aFeat.OID, TableName = aFeat.Class.AliasName, Feature = aFeat
});
}
}
}
}
});
}
return(results);
}
private void ResetColumns(TableDropdownDataContext context)
{
if (context != null)
{
context.Fields.ForEach(x => topTable.Columns.Add(x));
dataGrid.ItemsSource = null; //reset the binding - TODO get the xaml going
dataGrid.ItemsSource = topTable.DefaultView;
}
}
internal static List <object[]> Search(string searchText, TableDropdownDataContext item, string field)
{
LogLog.Instance.Logger[LogLogEnum.Debug]("Search");
LogLog.Instance.Logger[LogLogEnum.Debug]($"{searchText},{field}");
// get the fields back from the dataset item and check the type
try {
List <object[]> results = new List <object[]>();
IQueryFilter queryFilter = new QueryFilterClass();
// handle ints etc where they will need a =
esriFieldType aType = Utility.ReturnFieldType(item.Value, field);
queryFilter.WhereClause = QueryMap[aType](field, searchText);
LogLog.Instance.Logger[LogLogEnum.Debug](queryFilter.WhereClause);
// Use the PostfixClause to alphabetically order the set by name.
IQueryFilterDefinition queryFilterDef = (IQueryFilterDefinition)queryFilter;
queryFilterDef.PostfixClause = $"ORDER BY {field}";
// Output the returned names and addresses.
if (item.Value.Type == esriDatasetType.esriDTTable)
{
ITable table = item.Value as ITable;
if (table != null)
{
using (ComReleaser comReleaser = new ComReleaser()) {
ICursor cursor = table.Search(queryFilter, true);
comReleaser.ManageLifetime(cursor);
IRow row = null;
while ((row = cursor.NextRow()) != null)
{
var oa = new object[item.Fields.Count];
foreach (string fdName in item.Fields)
{
int fdIndex = table.FindField(fdName);
String fdValue = Convert.ToString(row.get_Value(fdIndex));
Debug.WriteLine(fdValue);
oa[fdIndex] = fdValue;
}
results.Add(oa);
}
}
}
}
return(results);
} catch (Exception e) {
LogLog.Instance.Logger[LogLogEnum.Error](e.Message);
throw;
}
}