/// <summary>
/// Gets the spatial analysis string.
/// </summary>
/// <param name="geometry">The geometry.</param>
/// <param name="analysis">The analysis.</param>
/// <param name="extraArgument">The extra argument.</param>
/// <returns></returns>
public virtual SqlString GetSpatialAnalysisString(object geometry, SpatialAnalysis analysis, object extraArgument)
{
switch (analysis)
{
case SpatialAnalysis.ConvexHull:
return(new SqlStringBuilder()
.AddObject(geometry)
.Add(".STConvexHull()")
.ToSqlString());
case SpatialAnalysis.Distance:
case SpatialAnalysis.Buffer:
case SpatialAnalysis.Difference:
case SpatialAnalysis.Intersection:
case SpatialAnalysis.SymDifference:
case SpatialAnalysis.Union:
if (analysis == SpatialAnalysis.Buffer && !(extraArgument is Parameter || new SqlString(Parameter.Placeholder).Equals(extraArgument)))
{
extraArgument = Convert.ToString(extraArgument, NumberFormatInfo.InvariantInfo);
}
return(new SqlStringBuilder()
.AddObject(geometry)
.Add(".ST")
.Add(analysis.ToString())
.Add("(")
.AddObject(extraArgument)
.Add(")")
.ToSqlString());
default:
throw new ArgumentException("Invalid spatial analysis argument");
}
}
/// <summary>
/// Gets the spatial analysis string.
/// </summary>
/// <param name="geometry">The geometry.</param>
/// <param name="analysis">The analysis.</param>
/// <param name="extraArgument">The extra argument.</param>
/// <returns></returns>
public SqlString GetSpatialAnalysisString(object geometry, SpatialAnalysis analysis, object extraArgument)
{
switch (analysis)
{
case SpatialAnalysis.Buffer:
if (!(extraArgument is Parameter || SqlString.Parameter.Equals(extraArgument)))
{
extraArgument = Convert.ToString(extraArgument, System.Globalization.NumberFormatInfo.InvariantInfo);
}
return(new SqlStringBuilder()
.Add(DialectPrefix)
.Add("Buffer(")
.AddObject(geometry)
.Add(", ")
.AddObject(extraArgument)
.Add(")")
.ToSqlString());
case SpatialAnalysis.ConvexHull:
return(new SqlStringBuilder()
.Add(DialectPrefix)
.Add("ConvexHull(")
.AddObject(geometry)
.Add(")")
.ToSqlString());
case SpatialAnalysis.Difference:
case SpatialAnalysis.Distance:
case SpatialAnalysis.Intersection:
case SpatialAnalysis.SymDifference:
return(new SqlStringBuilder()
.Add(DialectPrefix)
.Add(analysis.ToString())
.Add("(")
.AddObject(geometry)
.Add(",")
.AddObject(extraArgument)
.Add(")")
.ToSqlString());
case SpatialAnalysis.Union:
return(new SqlStringBuilder()
.Add(DialectPrefix)
.Add("GeomUnion(")
.AddObject(geometry)
.Add(",")
.AddObject(extraArgument)
.Add(")")
.ToSqlString());
default:
throw new ArgumentException("Invalid spatial analysis argument");
}
}
/// <summary>
/// Initializes a new instance of the <see cref="SpatialAnalysisFunction"/> class.
/// </summary>
/// <param name="spatialDialect">The spatial dialect.</param>
/// <param name="analysis">The analysis.</param>
public SpatialAnalysisFunction(ISpatialDialect spatialDialect, SpatialAnalysis analysis)
: base(analysis.ToString(),
(analysis == SpatialAnalysis.Distance ?
NHibernateUtil.Double :
spatialDialect.GeometryType))
{
this.spatialDialect = spatialDialect;
this.analysis = analysis;
if (this.analysis == SpatialAnalysis.ConvexHull)
{
this.allowedArgsCount = 1;
}
else
{
this.allowedArgsCount = 2;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="SpatialAnalysisFunction"/> class.
/// </summary>
/// <param name="spatialDialect">The spatial dialect.</param>
/// <param name="analysis">The analysis.</param>
public SpatialAnalysisFunction(ISpatialDialect spatialDialect, SpatialAnalysis analysis)
: base(analysis.ToString(),
(analysis == SpatialAnalysis.Distance ?
NHibernateUtil.Double :
spatialDialect.GeometryType)
)
{
this.spatialDialect = spatialDialect;
this.analysis = analysis;
if (this.analysis == SpatialAnalysis.ConvexHull)
{
this.allowedArgsCount = 1;
}
else
{
this.allowedArgsCount = 2;
}
}
private void RegisterSpatialFunction(SpatialAnalysis analysis)
{
RegisterFunction(SpatialDialect.HqlPrefix + analysis.ToString(), new SpatialAnalysisFunction(this, analysis));
}
/// <summary>
/// Gets the spatial analysis string.
/// </summary>
/// <param name="geometry">The geometry.</param>
/// <param name="analysis">The analysis.</param>
/// <param name="extraArgument">The extra argument.</param>
/// <returns></returns>
public SqlString GetSpatialAnalysisString(object geometry, SpatialAnalysis analysis, object extraArgument)
{
switch (analysis)
{
case SpatialAnalysis.Buffer:
if (!(extraArgument is Parameter || SqlString.Parameter.Equals(extraArgument)))
{
extraArgument = Convert.ToString(extraArgument, System.Globalization.NumberFormatInfo.InvariantInfo);
}
return new SqlStringBuilder()
.Add(DialectPrefix)
.Add("Buffer(")
.AddObject(geometry)
.Add(", ")
.AddObject(extraArgument)
.Add(")")
.ToSqlString();
case SpatialAnalysis.ConvexHull:
return new SqlStringBuilder()
.Add(DialectPrefix)
.Add("ConvexHull(")
.AddObject(geometry)
.Add(")")
.ToSqlString();
case SpatialAnalysis.Difference:
case SpatialAnalysis.Distance:
case SpatialAnalysis.Intersection:
case SpatialAnalysis.SymDifference:
return new SqlStringBuilder()
.Add(DialectPrefix)
.Add(analysis.ToString())
.Add("(")
.AddObject(geometry)
.Add(",")
.AddObject(extraArgument)
.Add(")")
.ToSqlString();
case SpatialAnalysis.Union:
return new SqlStringBuilder()
.Add(DialectPrefix)
.Add("GeomUnion(")
.AddObject(geometry)
.Add(",")
.AddObject(extraArgument)
.Add(")")
.ToSqlString();
default:
throw new ArgumentException("Invalid spatial analysis argument");
}
}
private void RegisterSpatialFunction(SpatialAnalysis analysis)
{
RegisterFunction(SpatialDialect.HqlPrefix + analysis.ToString(), new SpatialAnalysisFunction(this, analysis));
}
public void RegisterSpatialFunction(SpatialAnalysis analysis)
{
adaptor.RegisterFunction(SpatialDialect.HqlPrefix + analysis.ToString(), new SpatialAnalysisFunction(this, analysis));
}
/// <summary>
/// Gets the spatial analysis string.
/// </summary>
/// <param name="geometry">The geometry.</param>
/// <param name="analysis">The analysis.</param>
/// <param name="extraArgument">The extra argument.</param>
/// <returns></returns>
public SqlString GetSpatialAnalysisString(object geometry, SpatialAnalysis analysis, object extraArgument)
{
switch (analysis)
{
case SpatialAnalysis.ConvexHull:
return new SqlStringBuilder()
.AddObject(geometry)
.Add(".STConvexHull()")
.ToSqlString();
case SpatialAnalysis.Buffer:
case SpatialAnalysis.Difference:
case SpatialAnalysis.Distance:
case SpatialAnalysis.Intersection:
case SpatialAnalysis.SymDifference:
case SpatialAnalysis.Union:
if (analysis == SpatialAnalysis.Buffer &&
!(extraArgument is Parameter || new SqlString(Parameter.Placeholder).Equals(extraArgument)))
{
extraArgument = Convert.ToString(extraArgument, NumberFormatInfo.InvariantInfo);
}
return new SqlStringBuilder()
.AddObject(geometry)
.Add(".ST")
.Add(analysis.ToString())
.Add("(")
.AddObject(extraArgument)
.Add(")")
.ToSqlString();
default:
throw new ArgumentException("Invalid spatial analysis argument");
}
}
public void RegisterSpatialFunction(SpatialAnalysis analysis)
{
adaptor.RegisterFunction(SpatialDialect.HqlPrefix + analysis.ToString(), new SpatialAnalysisFunction(this, analysis));
}