public static DataTable GetDataTable(IGTDataContext oDC, string sSQL, GTDiagnostics _diag) { DataTable dt = null; try { //IGTDataContext oDC = GTClassFactory.Create<IGTApplication>().DataContext; Recordset oRS = oDC.OpenRecordset(sSQL, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockReadOnly, (int)CommandTypeEnum.adCmdText); OleDbDataAdapter oDA = new System.Data.OleDb.OleDbDataAdapter(); dt = new DataTable(); oDA.Fill(dt, oRS); oDA.Dispose(); oRS.Close(); } catch (Exception ex) { if (_diag.IsEnabled(GTDiagCat.EE)) { _diag.LogException("CommandUtilities.GetDataTable", ex); } throw ex; } return(dt); }
public void Activate(IGTCustomCommandHelper CustomCommandHelper) { try { this.oCustomCmdHelper = CustomCommandHelper; oDiag = new GTDiagnostics(GTDiagSS.IDotNetCustomCmd, GTDiagMaskWord.IDotNetCustomCmd, "StreetLightHistory.cs"); InitializeAppResources(); SetupLocationCriteria(); DoActiveMapWindowByStreetlight(); DoActiveMapWindowByStructure(); DoAssetHistory(); DoEvaluation(); DoTempGeometries(); DoExit(); } catch (Exception ex) { CommandUtilities.LogException(oDiag, "Activate", ex); DoExit(); } }
public static List <AssetHistory> GetAllAssetHistory(IGTDataContext _odc, GTDiagnostics _odiag) { List <AssetHistory> assetlist = null; try { string sSQL = string.Empty; sSQL = "SELECT G3E_IDENTIFIER, G3E_FNO, G3E_FID, G3E_ANO, G3E_CNO, G3E_CID, CHANGE_OPERATION, STRUCTURE_ID_1, OGG_X_1, OGG_Y_1, OGG_Z_1, CHANGE_DATE, VALUE_OLD, VALUE_NEW FROM ASSET_HISTORY WHERE G3E_FNO = 56 OR G3E_FNO = 107 OR G3E_FNO = 110 OR G3E_FNO = 114 ORDER BY G3E_FID, CHANGE_DATE ASC"; ADODB.Recordset oRS = null; oRS = ExecuteQuery(_odc, sSQL, _odiag); if (oRS == null) { return(null); } if (oRS.RecordCount == 0) { return(null); } if ((oRS.EOF) && (oRS.BOF)) { return(null); } oRS.MoveFirst(); assetlist = ProcessAssetHistoryRS(oRS, _odiag); if (assetlist == null) { return(null); } if (assetlist.Count == 0) { return(null); } } catch (Exception ex) { LogException(_odiag, "GetAllAssetHistory", ex); throw ex; } return(assetlist); }
public static void LogException(GTDiagnostics oDiag, string sMethod, Exception logExc) { try { if (oDiag.IsEnabled(GTDiagCat.EE)) { oDiag.LogException(sMethod, logExc); } } catch (Exception ex) { throw ex; } }
public static void LogMessage(GTDiagnostics oDiag, string sMethod, string sCategory, string sMessage) { try { if (oDiag.IsEnabled(GTDiagCat.EE)) { oDiag.LogMessage(sMethod, sCategory, sMessage); } } catch (Exception ex) { throw ex; } }
public static void LogMethodEntry(GTDiagnostics oDiag, string sMethod) { try { if (oDiag.IsEnabled(GTDiagCat.EE)) { oDiag.LogEnter(sMethod); } } catch (Exception ex) { throw ex; } }
public static string GetCommonNStructureID(IGTKeyObject _ko, GTDiagnostics _odiag) { string osid = string.Empty; try { IGTComponent commonN = _ko.Components["COMMON_N"]; ADODB.Recordset oRS = commonN.Recordset; if (oRS == null) { return(osid); } if (oRS.RecordCount == 0) { return(osid); } oRS.MoveFirst(); if ((!oRS.EOF) && (!oRS.BOF)) { osid = oRS.Fields["STRUCTURE_ID"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(osid)) { return(osid); } else { LogMessage(_odiag, "GetCommonN", "COMMON_N", "FID = " + _ko.FID.ToString() + " has no structure_id."); return(osid); } } } catch (Exception ex) { LogException(_odiag, "GetCommonN", ex); throw ex; } return(osid); }
public static Recordset ExecuteQuery(IGTDataContext _dc, String sSql, GTDiagnostics _diag) { Recordset _rs = null; try { int rEffected = -1; _rs = _dc.Execute(sSql, out rEffected, (int)CommandTypeEnum.adCmdText, null); } catch (Exception ex) { if (_diag.IsEnabled(GTDiagCat.EE)) { _diag.LogException("CommandUtilities.ExecuteQuery", ex); } } return(_rs); }
public static void LogStreetLightPoints(GTDiagnostics oDiag, IGTDDCKeyObjects ddc56List) { try { LogMessage(oDiag, "StreetLightLogTestPoints", "TestPoints", "All located streetlights."); foreach (IGTDDCKeyObject ddc in ddc56List) { if ((ddc.Geometry.Type == GTGeometryTypeConstants.gtgtOrientedPointGeometry) || (ddc.Geometry.Type == GTGeometryTypeConstants.gtgtPointGeometry)) { LogMessage(oDiag, "StreetLightLogTestPoints", "TestPoints", "FID =" + ddc.FID.ToString() + " FNO = " + ddc.FNO.ToString() + " Geometry = " + ddc.Geometry.Type.ToString()); LogMessage(oDiag, "StreetLightLogTestPoints", "TestPoints", "Location = " + ddc.Geometry.FirstPoint.ToString()); } } } catch (Exception ex) { throw ex; } }
private static void GetCommonNStructure(IGTKeyObject _ko, ref GTActiveStreetLight _obj, GTDiagnostics _odiag) { GTActiveStreetLight oCommonN = null; try { IGTComponent commonN = _ko.Components["COMMON_N"]; if (commonN == null) { return; } ADODB.Recordset oRS = commonN.Recordset; if (oRS == null) { return; } if (oRS.RecordCount == 0) { return; } oRS.MoveFirst(); oCommonN = new GTActiveStreetLight(); if ((!oRS.EOF) && (!oRS.BOF)) { string sid = oRS.Fields["STRUCTURE_ID"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sid)) { oCommonN.StructureID = sid; _obj.StructureID = sid; } else { oCommonN = null; LogMessage(_odiag, "GetCommonN", "COMMON_N", "FID = " + _ko.FID.ToString() + " has no structure_id."); return; } string sx = oRS.Fields["OGGX_H"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sx)) { oCommonN.StructureOGG_X1 = Convert.ToDouble(sx); _obj.StructureOGG_X1 = Convert.ToDouble(sx); } string sy = oRS.Fields["OGGY_H"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sy)) { _obj.StructureOGG_Y1 = Convert.ToDouble(sy); } string sz = oRS.Fields["OGGZ_H"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sz)) { oCommonN.StructureOGG_Z1 = Convert.ToDouble(sz); _obj.StructureOGG_Z1 = Convert.ToDouble(sx); } } } catch (Exception ex) { LogException(_odiag, "GetCommonN", ex); throw ex; } }
public static void LogLocationCriteria(IGTGeometry _locCritera, AssetHistory _obj, GTDiagnostics _odiag) { try { } catch (Exception ex) { LogException(_odiag, "LogLocationCrietria", ex); throw ex; } }
public static bool GetSysGeneralParameters(IGTDataContext _odc, GTDiagnostics _odiag, ref GTSysGenParam _gp) { bool bSuccess = false; try { string sSqlSysGP = "SELECT ID, SUBSYSTEM_NAME, SUBSYSTEM_COMPONENT, PARAM_NAME, PARAM_VALUE, PARAM_DESC FROM SYS_GENERALPARAMETER WHERE SUBSYSTEM_NAME = 'ASSET_HISTORY_TRACKING'"; Recordset rsGeneralParam = CommandUtilities.ExecuteQuery(_odc, sSqlSysGP, _odiag); if (rsGeneralParam == null) { CommandUtilities.LogMessage(_odiag, "GetGeneralParameters", "GeneralParameter", "Nothing returned from SYS_GENERALPARAMETER."); return(bSuccess); } string sThreshold = CommandUtilities.Get_Recordset_Value(rsGeneralParam, "PARAM_VALUE", "PARAM_NAME", "StreetLightMovementThreshold", _odiag); string sHistoricalSymbol = CommandUtilities.Get_Recordset_Value(rsGeneralParam, "PARAM_VALUE", "PARAM_NAME", "StreetLightHistoricalSymbol", _odiag); string sHistoricalLine = CommandUtilities.Get_Recordset_Value(rsGeneralParam, "PARAM_VALUE", "PARAM_NAME", "StreetLightHistoricalLine", _odiag); string sHistoricalStacking = CommandUtilities.Get_Recordset_Value(rsGeneralParam, "PARAM_VALUE", "PARAM_NAME", "StreetLightHistoricalStacking", _odiag); string sANOx = Get_Recordset_Value(rsGeneralParam, "PARAM_VALUE", "PARAM_NAME", "ANO_OGGX", _odiag); string sANOy = Get_Recordset_Value(rsGeneralParam, "PARAM_VALUE", "PARAM_NAME", "ANO_OGGY", _odiag); string sANOz = Get_Recordset_Value(rsGeneralParam, "PARAM_VALUE", "PARAM_NAME", "ANO_OGGZ", _odiag); if (!string.IsNullOrEmpty(sThreshold)) { _gp.MovementThreshold = Convert.ToInt32(sThreshold); } if (!string.IsNullOrEmpty(sHistoricalSymbol)) { _gp.HistoricalSymbol = Convert.ToInt32(sHistoricalSymbol); } if (!string.IsNullOrEmpty(sHistoricalSymbol)) { _gp.HistoricalLine = Convert.ToInt32(sHistoricalLine); } if (!string.IsNullOrEmpty(sHistoricalStacking)) { _gp.HistoricalStacking = Convert.ToInt32(sHistoricalStacking); } if (!string.IsNullOrEmpty(sANOx)) { _gp.ANO_X = Convert.ToInt32(sANOx); } else { _gp.ANO_X = 108; } if (!string.IsNullOrEmpty(sANOy)) { _gp.ANO_Y = Convert.ToInt32(sANOy); } else { _gp.ANO_Y = 109; } if (!string.IsNullOrEmpty(sANOz)) { _gp.ANO_Z = Convert.ToInt32(sANOz); } else { _gp.ANO_Z = 110; } rsGeneralParam.Close(); rsGeneralParam = null; bSuccess = true; } catch (Exception ex) { CommandUtilities.LogException(_odiag, "GTAssetTracker.GetSysGeneralParameters", ex); throw ex; } return(bSuccess); }
public static ADODB.Recordset OpenCommonRecordset(IGTDataContext _odc, int _fid, short _fno, GTDiagnostics _odiag) { ADODB.Recordset oRS = null; try { string sSQL = "SELECT G3E_FID, G3E_FNO, STRUCTURE_ID FROM COMMON_N WHERE G3E_FNO = '" + _fno + "'" + " AND G3E_FID = '" + _fid + "'"; oRS = ExecuteQuery(_odc, sSQL, _odiag); if (oRS.RecordCount == 0) { return(null); } if ((oRS.EOF) && (oRS.BOF)) { return(null); } oRS.MoveFirst(); while ((!oRS.EOF) && (!oRS.BOF)) { //obj.G3E_FNO = Convert.ToInt16(oRS.Fields["G3E_FNO"].Value.ToString().Trim()); //obj.G3E_FID = Convert.ToInt32(oRS.Fields["G3E_FID"].Value.ToString().Trim()); } } catch (Exception ex) { LogException(_odiag, "OpencommonRecordset", ex); throw ex; } return(oRS); }
public static String Get_Recordset_Value(Recordset oRS, String sColumn, String sFilterColumn, String sFilter, GTDiagnostics _diag) { string returnString = string.Empty; try { if ((!oRS.EOF) && (!oRS.BOF)) { oRS.MoveFirst(); } while ((!oRS.EOF) || (!oRS.BOF)) { if (!string.IsNullOrEmpty(sFilter)) { if (sFilter == oRS.Fields[sFilterColumn].Value.ToString().Trim()) { returnString = oRS.Fields[sColumn].Value.ToString().Trim(); break; } } else { returnString = oRS.Fields[sColumn].Value.ToString().Trim(); } oRS.MoveNext(); } } catch (Exception ex) { if (_diag.IsEnabled(GTDiagCat.EE)) { _diag.LogException("CommandUtilities.Get_Recordset_Value", ex); } throw ex; } return(returnString); }
private static List <AssetHistory> ProcessAssetHistoryRS(ADODB.Recordset _ors, GTDiagnostics _odiag) { List <AssetHistory> histList = null; int g3eFid; try { AssetHistory obj = null; histList = new List <AssetHistory>(); while ((!_ors.EOF) && (!_ors.BOF)) { obj = new AssetHistory(); obj.G3E_FID = Convert.ToInt32(_ors.Fields["G3E_FID"].Value.ToString().Trim()); g3eFid = obj.G3E_FID; obj.G3E_FNO = Convert.ToInt16(_ors.Fields["G3E_FNO"].Value.ToString().Trim()); string sCNO = _ors.Fields["G3E_CNO"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sCNO)) { obj.G3E_CNO = Convert.ToInt16(sCNO); } else { obj.G3E_CNO = 0; } string sANO = _ors.Fields["G3E_ANO"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sANO)) { obj.G3E_ANO = Convert.ToInt32(sANO); } else { obj.G3E_ANO = 0; } string sCID = _ors.Fields["G3E_CID"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sCID)) { obj.G3E_CID = Convert.ToInt32(sCID); } else { obj.G3E_CID = 0; } obj.StructureID_1 = _ors.Fields["STRUCTURE_ID_1"].Value.ToString().Trim(); string sx = _ors.Fields["OGG_X_1"].Value.ToString().Trim(); if (string.IsNullOrEmpty(sx)) { LogMessage(_odiag, "ProcessAssetHistoryRS", "LocationXYZ", "No location for x value for fid = " + obj.G3E_FID.ToString()); obj = null; } string sy = _ors.Fields["OGG_Y_1"].Value.ToString().Trim(); if (string.IsNullOrEmpty(sy)) { LogMessage(_odiag, "ProcessAssetHistoryRS", "LocationXYZ", "No location for y value for fid = " + g3eFid); obj = null; } if (obj != null) { obj.OGG_X1 = Convert.ToDouble(sx); obj.OGG_Y1 = Convert.ToDouble(sy); string sz = _ors.Fields["OGG_Z_1"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sz)) { obj.OGG_Z1 = Convert.ToDouble(sz); } else { obj.OGG_Z1 = 0; } string oldValue = _ors.Fields["VALUE_OLD"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(oldValue)) { obj.OLD_VALUE = oldValue; } string newValue = _ors.Fields["VALUE_NEW"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(newValue)) { obj.NEW_VALUE = newValue; } obj.ChangeOperation = _ors.Fields["CHANGE_OPERATION"].Value.ToString().Trim(); string sChangeDate = _ors.Fields["CHANGE_DATE"].Value.ToString().Trim(); DateTime changedate; DateTime.TryParse(sChangeDate, out changedate); obj.ChangeDate = changedate; histList.Add(obj); } _ors.MoveNext(); } if (histList.Count == 0) { return(null); } } catch (Exception ex) { LogException(_odiag, "ProcessAssetHistoryRS", ex); throw ex; } return(histList); }
public static int GetDistance(double xPt1, double yPt1, double zPt1, double xPt2, double yPt2, double zPt2, GTDiagnostics _diag) { int iDistance = 0; try { //Distance in meters double _dist = Math.Sqrt(Math.Pow((xPt1 - xPt2), 2) + Math.Pow((yPt1 - yPt2), 2)) / 1.6093; //Convert to feet _dist = _dist / 0.3048; iDistance = (int)_dist; } catch (Exception ex) { LogException(_diag, "CommandUtilities.GetDistance", ex); throw ex; } return(iDistance); }
public static GTActiveStreetLight GetCommonNActiveFeature(IGTKeyObject _koStreetLight, IGTKeyObject _koStructure, GTDiagnostics _odiag) { GTActiveStreetLight _oSL = null; try { _oSL = GetCommonNStreetLight(_koStreetLight, _odiag); if (_oSL == null) { return(null); } GetCommonNStructure(_koStructure, ref _oSL, _odiag); } catch (Exception ex) { LogException(_odiag, "GetCommonN", ex); throw ex; } return(_oSL); }
private static GTActiveStreetLight GetCommonNStreetLight(IGTKeyObject _ko, GTDiagnostics _odiag) { GTActiveStreetLight oCommonN = null; try { IGTComponent commonN = _ko.Components["COMMON_N"]; if (commonN == null) { return(null); } ADODB.Recordset oRS = commonN.Recordset; if (oRS == null) { return(null); } if (oRS.RecordCount == 0) { return(null); } oRS.MoveFirst(); oCommonN = new GTActiveStreetLight(); if ((!oRS.EOF) && (!oRS.BOF)) { string sid = oRS.Fields["STRUCTURE_ID"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sid)) { //Picking up structure id from structure common_n } else { oCommonN = null; LogMessage(_odiag, "GetCommonN", "COMMON_N", "FID = " + _ko.FID.ToString() + " has no structure_id."); return(null); } string sx = oRS.Fields["OGGX_H"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sx)) { oCommonN.OGG_X1 = Convert.ToDouble(sx); } string sy = oRS.Fields["OGGY_H"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sy)) { oCommonN.OGG_Y1 = Convert.ToDouble(sy); } string sz = oRS.Fields["OGGZ_H"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sz)) { oCommonN.OGG_Z1 = Convert.ToDouble(sz); } string sRepFID = oRS.Fields["REPLACED_FID"].Value.ToString().Trim(); if (!string.IsNullOrEmpty(sRepFID)) { oCommonN.REPLACED_FID = Convert.ToInt32(oRS.Fields["REPLACED_FID"].Value.ToString().Trim()); } } } catch (Exception ex) { LogException(_odiag, "GetCommonN", ex); throw ex; } return(oCommonN); }
public static void LogDistanceCalculationPoints(int _counter, GTActiveStreetLight _sl, GTDiagnostics _odiag) { try { if (_counter == 0) { LogMessage(_odiag, "LogDistanceCalculationPoints", "TEST", "Starting distance calculation for fid = " + _sl.G3E_FID.ToString()); } LogMessage(_odiag, "LogDistanceCalculationPoints", "TEST", "Counter = " + _counter.ToString() + " OGGX = " + _sl.GeometrySource[_counter].OGG_X1.ToString()); LogMessage(_odiag, "LogDistanceCalculationPoints", "TEST", "Counter = " + _counter.ToString() + " OGGY = " + _sl.GeometrySource[_counter].OGG_Y1.ToString()); LogMessage(_odiag, "LogDistanceCalculationPoints", "TEST", "Counter = " + _counter + 1.ToString() + " OGGX+1 = " + _sl.GeometrySource[_counter + 1].OGG_X1.ToString()); LogMessage(_odiag, "LogDistanceCalculationPoints", "TEST", "Counter = " + _counter + 1.ToString() + " OGGY+1 = " + _sl.GeometrySource[_counter + 1].OGG_Y1.ToString()); } catch (Exception ex) { LogException(_odiag, "LogDistanceCalculationPoints", ex); throw ex; } }