public DefinitionFilterItem(MapMember mapMember, DefinitionQuery definitionQuery)
{
//if (definitionFilter == null) return;
_mapMember = mapMember;
_queryExpression = definitionQuery?.WhereClause;
_expressionName = definitionQuery?.Name;
_definitionFilter = definitionQuery;
var queryBuilderControlProps = new QueryBuilderControlProperties
{
Expression = CurrentDefinitionQuery?.WhereClause,
EditClauseMode = true,
MapMember = ItemMapMember,
AutoValidate = true
};
ControlProperties = queryBuilderControlProps;
_isActiveFilter = IsDefinitionFilterActive();
}
/// <summary>
/// Boundingbox of dataset
/// </summary>
/// <returns>boundingbox</returns>
public BoundingBox GetExtents()
{
using (SqlConnection conn = new SqlConnection(_ConnectionString))
{
string strSQL = string.Format("SELECT ST.AsBinary(ST.EnvelopeQueryWhere('{0}', '{1}', '{2}'))", Table,
GeometryColumn, DefinitionQuery.Replace("'", "''"));
using (SqlCommand command = new SqlCommand(strSQL, conn))
{
conn.Open();
object result = command.ExecuteScalar();
conn.Close();
if (result == DBNull.Value)
{
return(null);
}
BoundingBox bbox = GeometryFromWKB.Parse((byte[])result).GetBoundingBox();
return(bbox);
}
}
}
