// YD:
// get polygon openings from database by sql
private static List <clsPolygonOpening> GetPolygonOpeningsBySql(string sql)
{
try
{
List <clsPolygonOpening> polygonOpenings = new List <clsPolygonOpening>();
using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection))
using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, connection))
{
DataSet dsPol = new DataSet();
DataTable dtPol = new DataTable();
dsPol.Reset();
da.Fill(dsPol);
dtPol = dsPol.Tables[0];
if (dtPol == null || dtPol.Rows == null || dtPol.Rows.Count == 0)
{
return(null);
}
foreach (DataRow rowPol in dtPol.Rows)
{
clsPolygonOpening polygonOpening = new clsPolygonOpening();
polygonOpening.PolygonGUID = rowPol["polygon_guid"].ToString();
polygonOpening.PolygonEdgeNum = (int)rowPol["polygon_edge_num"];
polygonOpening.x = Convert.ToDouble(rowPol["position_x"]);
polygonOpening.y = Convert.ToDouble(rowPol["position_y"]);
polygonOpening.openingSize = Convert.ToDouble(rowPol["opening_size_meters"]);
polygonOpenings.Add(polygonOpening);
}
}
return(polygonOpenings);
}
catch (Exception ex)
{
}
return(null);
}
// YD:
// get polygon openings from database by sql
private static List<clsPolygonOpening> GetPolygonOpeningsBySql(string sql)
{
try
{
List<clsPolygonOpening> polygonOpenings = new List<clsPolygonOpening>();
using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection))
using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, connection))
{
DataSet dsPol = new DataSet();
DataTable dtPol = new DataTable();
dsPol.Reset();
da.Fill(dsPol);
dtPol = dsPol.Tables[0];
if (dtPol == null || dtPol.Rows == null || dtPol.Rows.Count == 0)
{
return null;
}
foreach (DataRow rowPol in dtPol.Rows)
{
clsPolygonOpening polygonOpening = new clsPolygonOpening();
polygonOpening.PolygonGUID = rowPol["polygon_guid"].ToString();
polygonOpening.PolygonEdgeNum = (int)rowPol["polygon_edge_num"];
polygonOpening.x = Convert.ToDouble(rowPol["position_x"]);
polygonOpening.y = Convert.ToDouble(rowPol["position_y"]);
polygonOpening.openingSize = Convert.ToDouble(rowPol["opening_size_meters"]);
polygonOpenings.Add(polygonOpening);
}
}
return polygonOpenings;
}
catch (Exception ex)
{
}
return null;
}
