/// <summary> /// Get Geographic Street Light Accounts info touching boudaries /// </summary> /// <param name="g3eFid"></param> /// <returns></returns> private IList <StreetLightAccount> GetGeographicStreetLightAct(int g3eFid) { IList <StreetLightAccount> streetLightAccts = new List <StreetLightAccount>(); IList <StreetLightBoundary> stltBoundarys = new List <StreetLightBoundary>(); Recordset rs = null; string sqlStmt = "SELECT A.ESI_LOCATION, D.DESCRIPTION, A.RATE_SCHEDULE,A.LAMP_TYPE,A.WATTAGE,A.LUMINARE_STYLE FROM "+ " STLT_ACCOUNT A, STLT_BOUNDARY B,{0} C,STLT_DESC_VL D WHERE A.DESCRIPTION_ID=D.DESCRIPTION_ID AND A.BOUNDARY_CLASS = B.BND_CLASS " + " AND B.BND_FNO={1} AND A.BOUNDARY_ID =TO_CHAR(c.{2}) AND c.G3E_FID={3} " + " AND A.LAMP_TYPE = '{4}' AND A.WATTAGE ='{5}'" + " AND A.LUMINARE_STYLE ='{6}' "; //check role granted user otherwise add condinition restricted ='n' to query if (!_gtDataContext.IsRoleGranted(StreetLightRole)) { sqlStmt += "AND A.RESTRICTED = 'N'"; //(included only for non-SLAs) } //Get boundary info touching Street Light stltBoundarys = GetStreetLightBoundarys(); if (stltBoundarys != null && stltBoundarys.Count > 0) { short[] boundaryFnos = stltBoundarys.Select(a => a.BoundaryFno).ToArray(); var boundarys = GetBoundaryTouchStreetLight(boundaryFnos); if (boundarys.Count > 0) { var bndFids = (from a in stltBoundarys join b in boundarys on a.BoundaryFno equals b.Value select new { g3eFno = b.Value, g3eFid = b.Key, g3eTable = a.G3eTable, g3eField = a.G3eField }).ToList(); foreach (var boundary in bndFids) { //Get Street Light Account rs = Execute(string.Format(sqlStmt, boundary.g3eTable, boundary.g3eFno, boundary.g3eField, boundary.g3eFid, _lampType, _wattage, _lmStyle)); if (rs != null && rs.RecordCount > 0) { ConvertRsToEntity(rs).ToList().ForEach(a => streetLightAccts.Add(a)); } } } } return(streetLightAccts); }
private bool CheckPermissions(string authorizedRole, List <string> authorizedWrList) { try { //Prathyusha: Modified the condition from && to || as per document. if (m_iGtDataContext.IsRoleGranted(authorizedRole) || authorizedWrList.Contains(m_iGtDataContext.ActiveJob)) { return(true); } return(false); } catch (Exception) { throw; } }
public bool ValidateFI() { bool validate = false; Recordset jobRs = null; string strWRType = null; try { if (m_oGTDataContext.IsRoleGranted("PRIV_DESIGN_NET")) { DataAccessLayer dataAccessLayer = new DataAccessLayer(m_oGTDataContext); jobRs = dataAccessLayer.GetRecordset("SELECT WR_TYPE_C FROM G3E_JOB WHERE G3E_IDENTIFIER=:1", m_oGTDataContext.ActiveJob); if (jobRs != null && jobRs.RecordCount > 0) { jobRs.MoveFirst(); strWRType = Convert.ToString(jobRs.Fields["WR_TYPE_C"].Value); if (!string.IsNullOrEmpty(strWRType) && strWRType.ToUpper() == "NET") { validate = true; } } } } catch { throw; } finally { if (jobRs != null) { jobRs.Close(); jobRs = null; } } return(validate); }
public void Validate(out string[] ErrorPriorityArray, out string[] ErrorMessageArray) { ErrorPriorityArray = new string[1]; ErrorMessageArray = new string[1]; string networkManaged = null; string networkRestricted = null; string errorPriorityManaged = Convert.ToString(Arguments.GetArgument(0)); string errorPriorityUnmanaged = Convert.ToString(Arguments.GetArgument(1)); short m_ManholeCNO = 10601; GTValidationLogger gTValidationLogger = null; int activeFID = 0; int relatedFID = 0; string activeFieldValue = string.Empty; string relatedFieldValue = string.Empty; IGTComponent activeComponent = ActiveComponents[ActiveComponentName]; if (activeComponent != null && activeComponent.Recordset != null && activeComponent.Recordset.RecordCount > 0) { activeFID = int.Parse(activeComponent.Recordset.Fields["G3E_FID"].Value.ToString()); activeFieldValue = Convert.ToString(activeComponent.Recordset.Fields[ActiveFieldName].Value); } IGTComponent relatedComponent = RelatedComponents[RelatedComponentName]; if (relatedComponent != null && relatedComponent.Recordset != null && relatedComponent.Recordset.RecordCount > 0) { relatedFID = int.Parse(relatedComponent.Recordset.Fields["G3E_FID"].Value.ToString()); relatedFieldValue = Convert.ToString(relatedComponent.Recordset.Fields[RelatedFieldName].Value); } if (new gtLogHelper().CheckIfLoggingIsEnabled()) { LogEntries logEntries = new LogEntries { ActiveComponentName = ActiveComponentName, ActiveFID = activeFID, ActiveFieldName = ActiveFieldName, ActiveFieldValue = activeFieldValue, JobID = DataContext.ActiveJob, RelatedComponentName = RelatedComponentName, RelatedFID = relatedFID, RelatedFieldName = RelatedFieldName, RelatedFieldValue = relatedFieldValue, ValidationInterfaceName = "Network Management", ValidationInterfaceType = "RAI", }; gTValidationLogger = new GTValidationLogger(logEntries); gTValidationLogger.LogEntry("TIMING", "START", "Network Management Entry", "N/A", ""); } try { ValidationRuleManager validateMsg = new ValidationRuleManager(); IGTApplication gtApplication = GTClassFactory.Create <IGTApplication>(); gtApplication.SetStatusBarText(GTStatusPanelConstants.gtaspcMessage, "Network Management Validation Started"); if (m_oRelatedComponents.GetComponent(m_ManholeCNO).Recordset != null) { if (!(m_oRelatedComponents.GetComponent(m_ManholeCNO).Recordset.EOF&& m_oRelatedComponents.GetComponent(m_ManholeCNO).Recordset.BOF)) { m_oRelatedComponents.GetComponent(m_ManholeCNO).Recordset.MoveFirst(); networkManaged = Convert.ToString(m_oRelatedComponents.GetComponent(m_ManholeCNO).Recordset.Fields["NETWORK_MANAGED_YN"].Value); networkRestricted = Convert.ToString(m_oRelatedComponents.GetComponent(m_ManholeCNO).Recordset.Fields["NETWORK_RESTRICTED_YN"].Value); } } if (!m_oDataContext.IsRoleGranted("PRIV_DESIGN_NET") && networkManaged == "Y" && networkRestricted == "Y") { validateMsg.Rule_Id = "NETMGMT01"; validateMsg.BuildRuleMessage(GTClassFactory.Create <IGTApplication>(), null); ErrorMessageArray[0] = validateMsg.Rule_MSG; ErrorPriorityArray[0] = errorPriorityManaged; } if (!m_oDataContext.IsRoleGranted("PRIV_DESIGN_NET") && networkManaged == "N" && networkRestricted == "Y") { validateMsg.Rule_Id = "NETMGMT02"; validateMsg.BuildRuleMessage(GTClassFactory.Create <IGTApplication>(), null); ErrorMessageArray[0] = validateMsg.Rule_MSG; ErrorPriorityArray[0] = errorPriorityUnmanaged; } gtApplication.SetStatusBarText(GTStatusPanelConstants.gtaspcMessage, "Network Management Validation Completed"); if (gTValidationLogger != null) { gTValidationLogger.LogEntry("TIMING", "END", "Network Management Exit", "N/A", ""); } } catch (Exception ex) { throw new Exception("Error in Network Management Relationship Attribute Interface:" + ex.Message); } }