protected AreaAnalysisController()
{
tdmEntities = new TDManagementEntities();
tdaEntities = new TDASSETEntities();
tdmEntities.Configuration.ProxyCreationEnabled = false;
tdaEntities.Configuration.ProxyCreationEnabled = false;
}
protected AddressController()
{
tdmEntities = new TDManagementEntities();
tdaEntities = new TDASSETEntities();
cmEntities = new commonEntities();
tdmEntities.Configuration.ProxyCreationEnabled = false;
tdaEntities.Configuration.ProxyCreationEnabled = false;
cmEntities.Configuration.ProxyCreationEnabled = false;
}
protected MapController()
{
tdmEntities = new TDManagementEntities();
tdaEntities = new TDASSETEntities();
cmEntities = new commonEntities();
repos = new TDAssetRespository();
tdmEntities.Configuration.ProxyCreationEnabled = false;
tdaEntities.Configuration.ProxyCreationEnabled = false;
cmEntities.Configuration.ProxyCreationEnabled = false;
}
//* string point, string prov_id, string amph_id, string tumb_id
public IHttpActionResult GetParcelSummary(string point, string prov_id, string amph_id, string tumb_id)
{
TDASSETEntities db = new TDASSETEntities();
//point = "POINT(671764.338096 1516509.4789)";
//point = "POINT(11195621.807372887 1543041.14262334)";
if (!string.IsNullOrEmpty(amph_id))
{
amph_id = amph_id.Substring(amph_id.Length - 2);
}
if (!string.IsNullOrEmpty(tumb_id))
{
tumb_id = tumb_id.Substring(tumb_id.Length - 2);
}
string bufferQuery = $@"DECLARE @g geometry;
SET @g = geometry::STGeomFromText('{point}', 32647).STBuffer(100);
SELECT @g;";
DbGeometry buffer = db.Database.SqlQuery <DbGeometry>(bufferQuery).First();
List <PARCEL_Model> resultParcel = new List <PARCEL_Model>();
bufferQuery = $@"SELECT TOP (50)
[OBJECTID],[OGR_FID],[PARCEL_TYPE],[UTMMAP1],[UTMMAP2],[UTMMAP3],[UTMMAP4],[UTMSCALE],[LAND_NO],[LAND_TH],[LAND_NAME],[ACTION_STATUS],[LAND_AREA],[BRANCH_CODE],[BRANCH_NAME],[CHANGWAT_CODE],[CHANGWAT_NAME],[AMPHUR_CODE],[AMPHUR_NAME],[TUMBON_CODE],[TUMBON_NAME],[CHANOD_NO],[SURVEY_NO],[TABLE_3_SEQ],[ACCOUNTING_PERIOD],[PARCEL_SHAPE],[PARCEL_RN],[STREET_RN],[BLOCK_ZONE_RN],[BLOCK_PRICE_RN],[BLOCK_FIX_RN],[BLOCK_BLUE_RN],[PREV_EVAPRICE],[CURR_EVAPRICE],[DATE_CREATED],[USER_CREATED],[DATE_UPDATED],[USER_UPDATED],[SHAPE],[GDB_GEOMATTR_DATA],[EDIT_FLAG]
FROM [TDASSET].[tdadmin].[PARCEL_47_{prov_id}]
WHERE [AMPHUR_CODE]={amph_id} AND [TUMBON_CODE]={tumb_id}";
bufferQuery = $@"IF (EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'tdadmin'
AND TABLE_NAME = 'PARCEL_47_{prov_id}'))
BEGIN
{bufferQuery}
END";
resultParcel.AddRange(db.Database.SqlQuery <PARCEL_Model>(bufferQuery).ToList());
bufferQuery = $@"SELECT TOP (50)
[OBJECTID],[OGR_FID],[PARCEL_TYPE],[UTMMAP1],[UTMMAP2],[UTMMAP3],[UTMMAP4],[UTMSCALE],[LAND_NO],[LAND_TH],[LAND_NAME],[ACTION_STATUS],[LAND_AREA],[BRANCH_CODE],[BRANCH_NAME],[CHANGWAT_CODE],[CHANGWAT_NAME],[AMPHUR_CODE],[AMPHUR_NAME],[TUMBON_CODE],[TUMBON_NAME],[CHANOD_NO],[SURVEY_NO],[TABLE_3_SEQ],[ACCOUNTING_PERIOD],[PARCEL_SHAPE],[PARCEL_RN],[STREET_RN],[BLOCK_ZONE_RN],[BLOCK_PRICE_RN],[BLOCK_FIX_RN],[BLOCK_BLUE_RN],[PREV_EVAPRICE],[CURR_EVAPRICE],[DATE_CREATED],[USER_CREATED],[DATE_UPDATED],[USER_UPDATED],[SHAPE],[GDB_GEOMATTR_DATA],[EDIT_FLAG]
FROM [TDASSET].[tdadmin].[PARCEL_48_{prov_id}]
WHERE [AMPHUR_CODE]={amph_id} AND [TUMBON_CODE]={tumb_id}";
bufferQuery = $@"IF (EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'tdadmin'
AND TABLE_NAME = 'PARCEL_48_{prov_id}'))
BEGIN
{bufferQuery}
END";
resultParcel.AddRange(db.Database.SqlQuery <PARCEL_Model>(bufferQuery).ToList());
List <PARCEL_Model> result = resultParcel.Where(x => x.SHAPE.Intersects(buffer)).ToList();
return(Json(result));
}
public IHttpActionResult sql(DevParam prms)
{
try
{
TDASSETEntities db = new TDASSETEntities();
List <string> result = db.Database.SqlQuery <string>(prms.query).ToList();
return(Json(result));
}
catch (Exception ex) {
return(Json(ex));
}
}
public IHttpActionResult GetPOI(string prov_id, string amph_id, string tumb_id)
{
TDASSETEntities db = new TDASSETEntities();
db.Configuration.ProxyCreationEnabled = false;
return(Json(db.POIs.Where(p => p.PROV_CODE == prov_id && p.AMPH_CODE == amph_id && (string.IsNullOrEmpty(tumb_id) || p.TUMB_CODE == tumb_id)).OrderBy(o => o.NAME_T).Select(p => new {
NAME_T = p.NAME_T,
X = p.X,
Y = p.Y,
p.PROV_NAME_T,
p.TUMB_NAME_T,
p.AMPH_NAME_T,
p.TUMB_CODE
})));
}
