private static void GenerateXY(
ConnectorBase conn,
PointWrapper point,
out string x, out string y)
{
if (point.PointColumnName != null)
{
string pt;
if (point.LatitudeTableName != null)
{
pt = conn.WrapFieldName(point.LatitudeTableName) + @"." + conn.WrapFieldName(point.PointColumnName);
}
else
{
pt = conn.WrapFieldName(point.PointColumnName);
}
if (conn.TYPE == ConnectorBase.SqlServiceType.MSSQL)
{
x = pt + @".STX";
y = pt + @".STY";
}
else
{
if (conn.TYPE == ConnectorBase.SqlServiceType.POSTGRESQL)
{
x = @"ST_X(" + pt + @")";
y = @"ST_Y(" + pt + @")";
}
else // MYSQL
{
x = @"X(" + pt + @")";
y = @"Y(" + pt + @")";
}
}
}
else
{
if (point.LatitudeColumnName != null)
{
x = (point.LatitudeTableName != null ? conn.WrapFieldName(point.LatitudeTableName) + "." : "")
+ conn.WrapFieldName(point.LatitudeColumnName);
}
else
{
x = (point.Latitude ?? 0m).ToString(CultureInfo.InvariantCulture);
}
if (point.LongitudeColumnName != null)
{
y = (point.LongitudeTableName != null ? conn.WrapFieldName(point.LongitudeTableName) + "." : "")
+ conn.WrapFieldName(point.LongitudeColumnName);
}
else
{
y = (point.Longitude ?? 0m).ToString(CultureInfo.InvariantCulture);
}
}
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
var w = new PointWrapper();
w.PropertyChanged += (s, s1) => ReAddPoints();
Points.Add(w);
}
protected override void RemovePoint(PointWrapper wrapper, bool removeDelegate, bool generateLater = false)
{
base.RemovePoint(wrapper, removeDelegate, generateLater);
if (!generateLater)
{
GenerateBerensteinPoints();
}
}
protected virtual void RemovePoint(PointWrapper wrapper, bool removeDelegate, bool generateLater = false)
{
if (removeDelegate)
{
wrapper.Point.OnDeleted -= OnPointDeleted;
}
wrapper.Point.OnChanged -= OnPointChanged;
wrapper.Point.OnReplace -= OnPointReplacement;
points.Remove(wrapper);
}
public void AddPoint()
{
if (sRec is SelPoly)
{
PointWrapper p = ((SelPoly)sRec).GetNewPoint();
int i = ((SelPoly)this.sRec).GetIndex();
if (i > 0)
{
((PointSet)this.selEle).points.Insert(i - 1, p);
sRec = new SelPoly(selEle); // vytvori uchopovy obdelnik
}
}
}
public GeographyDistance(PointWrapper from, PointWrapper to)
{
this.From = from;
this.To = to;
}
protected override void RemovePoint(PointWrapper wrapper, bool removeDelegate, bool generateLater = false)
{
base.RemovePoint(wrapper, removeDelegate, generateLater);
changed = true;
}
private void RemovePoint(PointWrapper point, bool removeDelegate)
{
base.RemovePoint(point, removeDelegate);
changed = true;
}
public EnemyAttributes BonusSetter(PointWrapper b)
{
bonus = b;
return(this);
}
